In: Accounting
Lovejoy's Cake Shop makes three types of cakes: White, Chocolate, and, Swirl on one assembly line that has a limit of 400 labour-hours per week. Lovejoy can sell all the cakes it can make under current operating capacity. Manufacturing information per cake for each product is as follows:
White Chocolate Swirl
Selling price $16 $10 $20
Variable costs 10 5 18
Labour-hours per cake .4 .2 .4
Required:
Determine the total weekly contribution margin when all labour-hours are allotted to the product with the highest:
a. Unit selling price.
b. Unit contribution margin.
c. Contribution per labour-hour.
d. Assume we have 400 labour hours of capacity and demand as follows White-500; Chocolate-600; & Swirl 700. If we should produce at least half of the demand of each product; how should the 400 hours be allocated?
Req 1. | ||||||
Contribution margin per unit and per DLH | ||||||
White | Chocolate | Swirl | ||||
Selling price | 16 | 10 | 20 | |||
Less: variable cost per unit | 10 | 5 | 18 | |||
Unit contribution margin | 6 | 5 | 2 | |||
Divide: DLH used per unit | 0.4 | 0.2 | 0.4 | |||
Contribution per DLH | 15 | 25 | 5 | |||
Rank | Second | First | Third | |||
a. Highest unit selling price (Swirl) | ||||||
Total Labour hours available | 400 | |||||
Divide: Hours required per unit of Swirl | 0.4 | |||||
Units of Swirl produced | 1000 | |||||
Multiply: Unit contribution margin of Swirl | 2 | |||||
Weekly contribution margin | 2000 | |||||
b. Highest Unit contribution margin (White) | ||||||
Total Labour hours available | 400 | |||||
Divide: Hours required per unit of White | 0.4 | |||||
Units of White produced | 1000 | |||||
Multiply: Unit contribution margin of White | 6 | |||||
Weekly contribution margin | 6000 | |||||
c. Highest Contribution per DLH (Chocolate) | ||||||
Total Labour hours available | 400 | |||||
Divide: Hours required per unit of Chocolate | 0.2 | |||||
Units of Chocolate produced | 2000 | |||||
Multiply: Unit contribution margin of Chocolate | 5 | |||||
Weekly contribution margin | 10000 | |||||
Req d. | ||||||
White | Chocolate | Swirl | Total | |||
Maximum demand | 500 | 600 | 700 | |||
Minimum demand to be met | 250 | 300 | 350 | |||
Multiply: Hours required per unit | 0.4 | 0.2 | 0.4 | |||
Total Hours | 100 | 60 | 140 | 300 | ||
Total available hours | 400 | |||||
Remaining Hours | 100 | |||||
Remaining hours utilized | 40 | 60 | -100 | |||
Total Hours utilized | 140 | 120 | 140 | 400 | ||
Labour hours allocated | ||||||
White | 140 | |||||
Chocolate | 120 | |||||
Swirl | 140 | |||||