Question

In: Accounting

4. Confirm your calculations in Requirement 3 above by increasing the unit sales in your worksheet...

4. Confirm your calculations in Requirement 3 above by increasing the unit sales in your worksheet by 20% so that the Data area looks like this:

Chapter 5: Applying Excel
Data
Unit sales 84,000 units
Selling price per unit $10 per unit
Variable expenses per unit $4 per unit
Fixed expenses $210,000

(a) What is net operating income? (Negative amount should be indicated by a minus sign.)

(b) By what percentage did the net operating income increase?

Thad Morgan, a motorcycle enthusiast, has been exploring the possibility of relaunching the Western Hombre brand of cycle that was popular in the 1930s. The retro-look cycle would be sold for $16,000 and at that price, Thad estimates 300 units would be sold each year. The variable cost to produce and sell the cycles would be $11,200 per unit. The annual fixed cost would be $1,152,000.

a. What is the break-even in unit sales?

b. What is the margin of safety in dollars?

c. What is the degree of operating leverage? (Round your answer to 2 decimal places.)

Thad is worried about the selling price. Rumors are circulating that other retro brands of cycles may be revived. If so, the selling price for the Western Hombre would have to be reduced to $13,000 to compete effectively. In that event, Thad would also reduce fixed expenses to $911,000 by reducing advertising expenses, but he still hopes to sell 300 units per year.

d. What would the net operating income be in this situation? (Negative amount should be indicated by a minus sign.)

Solutions

Expert Solution

Part 1 of the question
Sales Units = 84000
Sales units after 20% increase = 84000*1.2 100800
Particulars per unit for 100800 units for 84000 units
Sales 10 1008000 840000
Variable Expenses 4 403200 336000
Contribution 6 604800 504000
Fixed Expenses 210000 210000
(a) Operating Income 394800 294000
% of Operating Income 39.17 35
(b) Increase in Operating Income = 39.17-35 = 4.17
Part 2 of the question (Thad Morgan)
Particulars per unit for 300 units for 260 units
Sales 16000 4800000 4160000
Variable Expenses 11200 3360000 2912000
Contribution 4800 1440000 1248000
Fixed Expenses 1152000 1152000
Operating Income 288000 96000
(a) Breakeven Units = Fixed Cost/(Selling Price - Variable Cost) = =1152000/(4800) 240
(b) Margin of Safety = (Actual Sales - Breakeven Sales) * Selling Price =(300-240)* 16000 960000
(c) Degree of Operating Leverage = % change in Operating Income / % change in Sales = 13.33/67.67 0.197
% change in Operating Income =(288000-96000)/288000 66.67%
% change in Sales =(4800000-4160000)/4800000 13.33%
(d) Particulars per unit for 300 units
Sales 13000 3900000
Variable Expenses 11200 3360000
Contribution 1800 540000
Fixed Expenses 911000
Net Operating Income -371000

Related Solutions

Confirm your calculations in Requirement 3 above by increasing the unit sales in your worksheet by...
Confirm your calculations in Requirement 3 above by increasing the unit sales in your worksheet by 20% so that the Data area looks like this: A B C D 1 Chapter 5: Applying Excel 2 3 Data 4 Unit sales 24,000 units 5 Selling price per unit $10 per unit 6 Variable expenses per unit $5 per unit 7 Fixed expenses $90,000 8 (a) What is net operating income? (Negative amount should be indicated by a minus sign.)       (b)...
Requirement 2: Revise the data in your worksheet to reflect the results for the subsequent period...
Requirement 2: Revise the data in your worksheet to reflect the results for the subsequent period as shown below: A B C D E 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 Chapter 9: Applying Excel Data Revenue $16.50 q Cost of ingredients $6.25 q Wages and salaries $10,400 Utilities $800 + $0.20 q Rent $2,200 Miscellaneous $600 + $0.80 q Actual results: Revenue $29,730 Cost of ingredients...
Please complete this worksheet showing all calculations for this case. Submit this to your professor for...
Please complete this worksheet showing all calculations for this case. Submit this to your professor for grading. Complete all colored spaces. CONCH REPUBLIC ELECTRONICS Student Name: Student Assumptions, provided in the text Equipment $      34,500,000.00 Salvage value $       3,500,000.00 R&D $          750,000.00 Marketing study $          200,000.00 Year 1 Year 2 Year 3 Year 4 Year 5 Sales(units) 64000 106000 87000 78000 54000 Depreciation rate 14.29% 24.49% 17.49% 12.49% 8.93% Price $                480.00 VC $                205.00 per unit FC $       5,100,000.00...
Creatine clearance Worksheet Refer to page 14 of your textbook for reference and calculations For each...
Creatine clearance Worksheet Refer to page 14 of your textbook for reference and calculations For each of these questions calculate the creatine clearance using the most appropriate method John Sanders DOB 4-17-91 Patient’s urine creatine- 569mg/day Patient’s plasma creatine- 3.69mg/dL Total volume-729ml/24 hours Debbie Renninger DOB 7-19-86 Patient’s urine creatine- 1179 mg/day Patient’s plasma creatine-5.79 mg/dL Total volume- 2253mL/24 hours Samantha Pierson DOB 8-25-76 Patient’s urine creatine- 1589 mg/day Patient’s plasma creatine- 7.73 mg/dL Total volume- 785mL/24 hours Wesley Matthews...
3. Name 3 biochemical tests that confirm that the bacteria isolated is Staphylococcus aureus. 4. Describe...
3. Name 3 biochemical tests that confirm that the bacteria isolated is Staphylococcus aureus. 4. Describe the test that you would use to determine whether the S. aureus that you identified above, is a MRSA. 5. Outline the procedure for Gram stain and negative stain. What would these stains determine?
Recalculate cash flow as shown from above table if variable costs are 83 percent of sales. Confirm that NPV will be - $788,000.
Year 0Years 1-12Investment- $5,400,000Sales$ 16,000,000Variable costs13,000,000Fixed costs2,000,000Depreciation450,000Pre-tax profit (1 – 2 – 3 – 4)550,000Taxes (at 40%)220,000Profit after tax330,000Cash flow from operations (4 + 7)780,000Net cash flow-$5,400,000$       780,000Recalculate cash flow as shown from above table if variable costs are 83 percent of sales. Confirm that NPV will be - $788,000.
Requirement 2: The company has just hired a new marketing manager who insists that unit sales...
Requirement 2: The company has just hired a new marketing manager who insists that unit sales can be dramatically increased by dropping the selling price from $8 to $7. The marketing manager would like to use the following projections in the budget: Year 2 Quarter Year 3 Quarter Data 1 2 3 4 1 2 Budgeted unit sales 50,000 65,000 115,000 70,000 85,000 100,000 Selling price per unit $7 A B C D E F G 1 2 3 4...
Requirement 2: The company has just hired a new marketing manager who insists that unit sales...
Requirement 2: The company has just hired a new marketing manager who insists that unit sales can be dramatically increased by dropping the selling price from $8 to $7. The marketing manager would like to use the following projections in the budget:      Data Year 2 Quarter Year 3 Quarter 1 2 3 4 1 2   Budgeted unit sales 50,000 65,000 105,000 60,000 85,000 95,000   Selling price per unit $7 per unit                 Chapter 7: Applying...
Requirement 2: The company has just hired a new marketing manager who insists that unit sales...
Requirement 2: The company has just hired a new marketing manager who insists that unit sales can be dramatically increased by dropping the selling price from $8 to $7. The marketing manager would like to use the following projections in the budget:      Data Year 2 Quarter Year 3 Quarter 1 2 3 4 1 2   Budgeted unit sales 50,000 65,000 105,000 60,000 85,000 95,000   Selling price per unit $7 per unit                 1 Chapter 7:...
Requirement 2: The company has just hired a new marketing manager who insists that unit sales...
Requirement 2: The company has just hired a new marketing manager who insists that unit sales can be dramatically increased by dropping the selling price from $8 to $7. The marketing manager would like to use the following projections in the budget:      Data Year 2 Quarter Year 3 Quarter 1 2 3 4 1 2   Budgeted unit sales 45,000 70,000 110,000 70,000 85,000 90,000   Selling price per unit $7 per unit          Data Year 2 Quarter Year...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT