DATA INPUT
Paints & Supplies
Carpeting Wallpaper
Sales 190,000$ 230,000$ 70,000$
Variable Costs 114,000$ 161,000$ 56,000$
Fixed Costs 28,000$ 37,500$ 22,500$
Total Costs 142,000$ 198,500$ 78,500$
Operating Income (loss) 48,000$ 31,500$ (8,500)$
Remodeling
Remodeling Costs 6,200$
Increased Sales 60,000$
Increased Contribution Margin 5%
Wallpaper fixed costs cut 40%
Loss of Paint Sales 20%
New Adveritising 12,500$
SOLUTION
Contemporary Trends will be worse off by $6400 if it discontinues wallpaper sales
Paints & Supplies
Carpeting Wallpaper
Sales 190,000$ 230,000$ 70,000$
If wallpaper is closed, then:
Loss of wall paper contribution margin
(14,000)$
Remodeling (6,200)$
Added profitability from carpet sales* 32,500$
Fixed Cost Savings 9,000$
Decreased Contribution Margin
Increased Advertising (12,500)$
* The current contribution margin ratio for carpeting is 30% ($69000/$230000)
Less: Variable Costs 114,000$ 161,000$ 56,000$
Contribution Margin 76,000$ 69,000$ 14,000$