Question

In: Accounting

Russell Preston delivers parts for several local auto parts stores. He charges clients 0.85 per mile...

Russell Preston delivers parts for several local auto parts stores. He charges clients 0.85 per mile driven. Russell has determined that if he drives 3,000 miles in a month, his average operating cost is $0.75 per mile. If he drives 5,000 miles in a month, his average operating cost is $0.55 per mile. Russell has used the high-low method to determine that his monthly cost equation is: total cost = $1,320.00 + $0.25 per mile.        

Required:
1.
Determine how many miles Russell needs to drive to break even.



2. Assume Russell drove 2,600 miles last month. Without making any additional calculations, determine whether he earned a profit or a loss last month.

Loss
Profit



3. Determine how many miles Russell must drive to earn $1,500.00 in profit.

  

4-a. Prepare a contribution margin income statement assuming Russell drove 2,600 miles last month. (Enter your answers rounded to 2 decimal places.)

  

4-b. Use the above information to calculate Russell’s degree of operating leverage. (Round your answer to the 2 decimal places.)

Solutions

Expert Solution

  • All working forms part of the answer
  • Requirement 1

A

Price charged

$                       0.85

per mile

B

Variable cost

$                       0.25

per mile

C = A - B

Contribution margin

$                       0.60

per mile

D

Fixed Cost

$              1,320.00

per month

E = D/C

Miles needed to Break Even

                        2,200

miles

  • Requirement 2

--PROFIT, because 2600 miles is MORE than the Break Even miles of 2,200

  • Requirement 3

A

Target profits

$              1,500.00

B

Fixed Cost

$              1,320.00

C = A+B

Total Contribution required

$              2,820.00

D

Contribution margin per mile

$                       0.60

E = C/D

Miles needed to earn target profit

                        4,700 miles

  • Requirement 4 a

Contribution margin Income Statement

Working

Revenue

$              2,210.00

[2600 miles x $ 0.85]

Variable cost

$                  650.00

[2600 miles x $ 0.25]

Contribution margin

$              1,560.00

[2210 - 650]

Fixed Cost

$              1,320.00

Net Income

$                  240.00

[1560 - 1320]

  • Requirement 4 b

A

Contribution margin

$              1,560.00

B

Net Income

$                  240.00

C = A/B

Degree of Operating Leverage

6.50


Related Solutions

Russell Preston delivers parts for several local auto parts stores. He charges clients $1.45 per mile...
Russell Preston delivers parts for several local auto parts stores. He charges clients $1.45 per mile driven. Russell has determined that if he drives 2,700 miles in a month, his average operating cost is $0.90 per mile. If he drives 3,700 miles in a month, his average operating cost is $0.80 per mile. Russell has used the high-low method to determine that his monthly cost equation is total cost = $1,380 + $0.53 per mile. Required: 1. Determine how many...
Russell Preston delivers parts for several local auto parts stores. He charges clients 0.90 per mile...
Russell Preston delivers parts for several local auto parts stores. He charges clients 0.90 per mile driven. Russell has determined that if he drives 2,100 miles in a month, his average operating cost is $0.60 per mile. If he drives 3,100 miles in a month, his average operating cost is $0.50 per mile. Russell has used the high-low method to determine that his monthly cost equation is: total cost = $1,220.00 + $0.29 per mile.    1. Determine how many...
Mr. Northman runs a moving business. He currently charges $5 per mile and $4 per square...
Mr. Northman runs a moving business. He currently charges $5 per mile and $4 per square foot when quoting prices. Unfortunately, this results in wide variations in his gross profit margin. He wants an average gross profit margin of 25.67% without wide variations. Give Mr. Northman an excel tool that he can use for future quotes. floors Total Mileage Square Footage Quoted Price Direct Costs - Actual Gross Profit Labor Hours Labor Cost Gas cost Amount % 73 98 1,150...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT