Loading...

logistics excel exercise

Open Posted By: roundtracker Date: 11/01/2021 Academic Level: High School Paper Type: Case Study Writing

Question Description

Ron Mesia, Circuit City Supply Chain Manager finds his profit at $15,000 as shows below, he consider that it is inadequate for expanding his business. 

Bank of America is insisting on an improved profit picture prior to approval of a loan for some new equipment. Ron would like to improve the profit line to $25,000 so he can obtain the bank’s approval for the loan.

What percentage improvement is needed in a Cost of Material Strategy for the profit to improve to $25,000? Sales, Other Production Cost, and Fixed Cost will remain the same.

What percentage improvement is needed in Sales for the profit to improve to $25,000? Cost of Material, Other Production Cost, and Fixed Cost will remain the same.

Current Situation

% Distribution

Cost of Material Startegy 

Percent Increase or Decrease

Sales Strategy

Percent Increase or Decrease

Sales

$250,000

100%

250,000

0%

Cost of material (supply chain)

$175,000

70%

175,000

0%

Other production cost

$30,000

12%

30,000

0%

30,000

0%

Fixed cost

$30,000

12%

30,000

0%

30,000

0%

Profit

$15,000

6%

25,000

67%

25,000

67%


Category: Business & Management Subjects: Business Law Deadline: 24 Hours Budget: $60 - $90 Pages: 2-3 Pages (Short Assignment)