In: Accounting
In a company that makes assorted clocks, the new manager will like to report on the sales mix of the company. The company’s fixed cost for the three styles of clocks is $729,000. Time Tellers sales mix, and contribution margin per crate are shown below: Product Type Sales Mix Contribution Margin per crate Red 35% $140 Brown 65% $130 Green 25% $66 Required: a. Based on the current sales mix, compute the weighted average contribution margin per crate. b. Compute the number of each type of clock that the company would need to sell in order to break even under this product mix.
A | B | C = A x B | ||
a | Product Type | Sales Mix | Contribution Margin per crate | Weighted-Average Unit Contribution Margin |
Red | 35% | $ 140 | $ 49.00 | |
Brown | 65% | $ 130 | $ 84.50 | |
Green | 25% | $ 66 | $ 16.50 | |
$ 150.00 | ||||
b | Total Break even | $729000 ÷ 150 | 4860 | units |
Sales Units | ||||
Red | 4860 x 35% | 1,701 | units | |
Brown | 4860 x 65% | 3,159 | units | |
Green | 4860 x 25% | 1,215 | units | |