Question

Neptune Company has developed a small inflatable toy that it is anxious to introduce to its customers. The company's Marketing Department estimates that demand for the new toy will range between 15,000 units and 30,000 units per month. The new toy will sell for $8.00 per unit. Enough capacity exists in the company's plant to produce 20,000 units of the toy each month. Variable expenses to manufacture and sell one unit would be $4.00, and incremental fixed expenses associated with the toy would total $32,000 per month. Neptune has also identified an outside supplier who could produce the toy for a price of $3.00 per unit plus a fixed fee of $49,000 per month for any production volume up to 20,000 units. For a production volume between 20,001 and 45,000 units the fixed fee would increase to a total of $98,000 per month. Required: 1. Calculate the break-even point in unit sales assuming that Neptune does not hire the outside supplier. 2. How much profit with Neptune earn assuming: a. It produces and sells 20,000 units. b. It does not produce any units and instead outsources the production of 20,000 units to the outside supplier and then sells those units to its customers. 3. Calculate the break-even point in unit sales assuming that Neptune plans to use all of its production capacity to produce the first 20,000 units that it sells and that it also commits to hiring the outside supplier to produce up to 10,000 additional units. 4. Assume that Neptune plans to use all of its production capacity to produce the first 20,000 units that it sells and that it also commits to hiring the outside supplier to produce up to 10,000 additional units. a. What total unit sales would Neptune need to achieve in order to equal the profit earned in requirement 2a? b. What total unit sales would Neptune need to achieve in order to attain a target profit of $50,500 per month? c. How much profit will Neptune earn if it sells 30,000 units per month? d. How much profit will Neptune earn if it sells 30,000 units per month and agrees to pay its marketing manager a bonus of 20 cents for each unit sold above the break-even point from requirement 3?

Answer 1

B C с А. 1 1) Produces and sells 2 Selling price per unit 3 Less: Variable costs per unit 4 Contribution margin per unit 5 Incremental fixed expenses 6 Break-even point in unit sales - without hiring $8.00 $4.00 $4.00 $32,000 8,000 7 20,000 $80,000 $32,000 $48,000 12 8 2a) Produces and sells 9 Units produced and sold 10 Total Contribution margin 11 Less: Fixed expenses Profit if produces and sells 13 14 2b) Outsouces the production and sells 15 Units outsourced for production and sold 16 Selling price per unit 17 Less: Variable costs per unit 18 Contribution margin per unit 19 Total Contribution margin 20 Less: Fixed expenses 21 Profit if outsources the production and sells 22 20,000 $8.00 $3.00 $5.00 $100,000 $49,000 $51,000

B с D 8 4 =C2-C3 32000 =C5/04 А 1 1) Produces and sells 2 Selling price per unit 3 Less: Variable costs per unit 4 Contribution margin per unit 5 Incremental fixed expenses 6 Break-even point in unit sales - without hiring 7 8 2a) Produces and sel 9 Units produced and sold 10 Total Contribution margin 11 Less: Fixed expenses Profit if produces and sells 13 14 2b) Outsouces the production and sells 15 Units outsourced for production and sold 16 Selling price per unit 17 Less: Variable costs per unit 18 Contribution margin per unit 19 Total Contribution margin 20 Less: Fixed expenses Profit if outsources the production and sells 22 20000 =C9*C4 32000 =C10-C11 12 20000 8 3 =C16-C17 =C18*C15 49000 21 =C19-C20

F A B с D E 1 3) 2 Fixed expenses for first 20,000 units $32,000 3 Add: Fixed expenses for next 10,000 units $49,000 4 Total fixed expenses for 30,000 units $81,000 5 6 Produces and sells 7 Units produced and sold 20,000 8 Contribution margin per unit $4.00 9 Total Contribution margin for first 20,000 units $80,000 10 11 Outsources production and sells 12 Contribution margin per unit $5.00 13 Break-even point in unit sales - hiring 20,200 14

А B с D E 32000 49000 =E2+E3 5 1 3) 2 Fixed expenses for first 20,000 units 3 Add: Fixed expenses for next 10,000 units 4 Total fixed expenses for 30,000 units 5 6 Produces and sells 7 Units produced and sold 8 Contribution margin per unit 9 Total Contribution margin for first 20,000 units 10 11 Outsources production and sells 12 Contribution margin per unit Break-even point in unit sales - hiring 20000 4 =E7*E8 5 13 =E7+((E4-E9)/E12) 14