In: Accounting
Classic Cabinets has a factory that produces custom kitchen cabinets. It has multiple product lines.
Materials and labor for the cabinets are determined by each job. To simplify the assignment, we will assume the following average costs.
The following information shows Classic Cabinet’s cost structure of 2018. The materials include $1,500 for the wood and other materials on a per job basis. It requires 20 hours of labor on average for a custom kitchen. The hourly rate is $12. The sales price will be set at a markup of 85%.
The company estimates that it will have 16,000 direct labor hours in total for the kitchen cabinets.
It assumes 800 units are sold on average per year. A breakdown of estimated yearly costs related to the kitchen cabinets follows:
Salaries- office & administrative |
$ 520,000 |
Salaries for factory personal |
$ 220,000 |
Office Rent |
$ 125,000 |
Factory Rent |
$ 20,000 |
Utilities and Misc. office expenses (based on units sold) |
$ 20,000 |
Sales Travel (based on units sold) |
$ 24,000 |
Insurance - office |
$ 14,000 |
Depreciation - office equipment |
$ 45,000 |
Depreciation for factory equipment |
$ 70,000 |
Advertising |
$ 20,000 |
Sales commissions (based on units sold) |
$ 45,000 |
Factory Property taxes |
$ 10,000 |
Maintenance for factory equipment |
$ 80,000 |
What is the Contribution Margin (CM) in total and per unit dollars, and CM% for the sale of 800 kitchen cabinets?
TotalCost | Fixed cost | Variable costs | ||||
Salaries- office & administrative | $520,000 | $520,000 | ||||
Salaries for factory personal | $220,000 | $220,000 | ||||
Office Rent | $125,000 | $125,000 | ||||
Factory Rent | $20,000 | $20,000 | ||||
Utilities and Misc. office expenses (based on units sold) | $20,000 | $20,000 | ||||
Sales Travel (based on units sold) | $24,000 | $24,000 | ||||
Insurance - office | $14,000 | $14,000 | ||||
Depreciation - office equipment | $45,000 | $45,000 | ||||
Depreciation for factory equipment | $70,000 | $70,000 | ||||
Advertising | $20,000 | $20,000 | ||||
Sales commissions (based on units sold) | $45,000 | $45,000 | ||||
Factory Property taxes | $10,000 | $10,000 | ||||
Maintenance for factory equipment | $80,000 | $80,000 | ||||
A | Total Cost | $1,213,000 | $1,124,000 | $89,000 | ||
B | Units Sold | 800 | 800 | 800 | ||
C=A/B | Cost per unit(other than prime cost) | $ 1,516.25 | $ 1,405.00 | $ 111.25 | ||
D | Direct Material cost per unit | $1,500 | $1,500 | |||
E | Direct Labor cost per unit(20*$12) | $240 | $240 | |||
F=C+D+E | Total Cost per unit | $ 3,256.25 | $ 1,405.00 | $ 1,851.25 | ||
G=F*1.85 | Sales Price per unit (markup85%) | $ 6,024.06 | ||||
H=G-1851.25 | Contribution margin per unit =(Sales Price-Variable cost) | $ 4,172.81 | ||||
I=H*800 | Total contribution Margin | $ 3,338,250 | ||||
J=(H/G)*100 | Contribution Margin Percentage | 69.27% | ||||