Div | 1 | 2 | 3 | 4 | |
Sales | 509500 | 418600 | 313300 | 179300 | |
COGS | 289700 | 249000 | 166600 | 154800 | |
Variable | 202790 | 221610 | 123284 | 142416 | |
Fixed | 86910 | 27390 | 43316 | 12384 | |
Selling & Admin Exp | 60100 | 75400 | 67400 | 75000 | |
Variable | 22838 | 36192 | 43810 | 52500 | |
Fixed | 37262 | 39208 | 23590 | 22500 | |
Contribution | 146206 | -15616 | |||
Contribution Margin | 46.67 | (8.71) | |||
1. Shut Down Analysis | |||||
Keep Div III | Shut Div III | Income Increase /(Decrease) | |||
Contribution Margin | 146,206 | - | (146,206) | ||
Fixed Cost | (66,906) | (33,453) | 33,453 | ||
Net Income | 79,300 | (33,453) | (112,753) | ||
Keep Div IV | Shut Div IV | Income Increase /(Decrease) | |||
Contribution Margin | (15,616) | - | 15,616 | ||
Fixed Cost | (34,884) | (17,442) | 17,442 | ||
Net Income | (50,500) | (17,442) | 33,058 | ||
Divison III | Should be kept running as net icome of 79,300 is there | ||||
Divison IV | Should be shut down as loss is reduced to 17,442 | ||||
Condensed Income Statement | |||||
Div | I | II | III | ||
Sales | 509,500 | 418,600 | 313,300 | ||
Variable Cost | |||||
COGS - Variable Portion | 202,790 | 221,610 | 123,284 | ||
S & A Exp -Variable portion | 22,838 | 36,192 | 43,810 | ||
Contribution | 283,872 | 160,798 | 146,206 | ||
Fixed Cost | |||||
COGS - Fixed Portion | 86,910 | 27,390 | 43,316 | ||
S & A Exp -Fixed portion | 37,262 | 39,208 | 23,590 | ||
Divison IV Allocated exp | 5,814 | 5,814 | 5,814 | ||
Net Profit | 153,886 | 88,386 | 73,486 | ||
ents of $ 1 00 and me Ribeiro Manufacturing Company has four operating divisions. During the...
Ribeiro Manufacturing Company has four operating divisions. During the first quarter of 2020, the company reported aggregate income from certions of $12.700 d divisional results: o Division III TV Sales $509,500 $418,600 $313,300 $179,300 Cost of goods sold 289,700 249,000 266,600 154,800 Selling and administrative expenses 60,100 75,400 67,400 75,000 Income (loss) from operations $159,700 594,200 $(20,700) S(50,500) The analysis reveals the following percentages of variable costs in each division 1 Cost of goods sold 70% Selling and administrative expenses...
Pina Company has four operating divisions. During the first quarter of 2017, the company reported aggregate income from operations of $212,300 and the following divisional results. 1 Sales Cost of goods sold Selling and administrative expenses Income (loss) from operations $254,000 204,000 69,700 $(19,700) Division II III $199,000 $501,000 190,000 301,000 61,000 57,000 $ (52,000) $143,000 IV $443,000 247,000 55,000 $141,000 Analysis reveals the following percentages of variable costs in each division. Cost of goods sold Selling and administrative expenses...
*Problem 12-5 Sarasota Company has four operating divisions. During the first quarter of 2017, the company reported aggregate income from certions Division Sales Cost of goods sold Selling and administrative expenses Income (loss) from operations $250,000 204,000 76,600 3 (30,600) $199,000 190,000 55,000 $ (46,000) $499,000 297,000 56,000 $146,000 $443,000 246,000 52.000 $145,000 Analysis reveals the following percentages of variable costs in each division I Cost of goods sold Selling and administrative expenses 71% 37 II 91 61 TV 73%...
Please help me fill out these tables for accounting, thanks! Indigo Company has four operating divisions. During the first quarter of 2017, the company reported aggregate income from operations of $218,700 and the following divisional results. Division I II III IV Sales $250,000 $198,000 $499,000 $447,000 Cost of goods sold 195,000 194,000 298,000 250,000 Selling and administrative expenses 70,300 62,000 57,000 49,000 Income (loss) from operations $ (15,300) $ (58,000) $144,000 $148,000 Analysis reveals the following percentages of variable costs...
Flint Company has four operating divisions. During the first quarter of 2017, the company reported aggregate income from operations of $204,500 and the following divisional results. Division I II III IV Sales $253,000 $195,000 $504,000 $446,000 Cost of goods sold 199,000 192,000 300,000 248,000 Selling and administrative expenses 75,500 60,000 64,000 55,000 Income (loss) from operations $ (21,500) $ (57,000) $140,000 $143,000 Analysis reveals the following percentages of variable costs in each division. I II III IV Cost of goods...
Pina Company has four operating divisions. During the first quarter of 2017, the company reported aggregate income from operations of $212,300 and the following divisional results. Sales Cost of goods sold Selling and administrative expenses Income (loss) from operations $254,000 204,000 69,700 $ (19,700) Division III $199,000 $501,000 190,000 301,000 61,000 57,000 $ (52,000) $143,000 IV $443,000 247,000 55,000 $141,000 Analysis reveals the following percentages of variable costs in each division. Cost of goods sold Selling and administrative expenses I...
Culver Company has four operating divisinns. During the first quarter of 2017, the company reported aggregate income from operations of $205,100 and the following divisional results. II Division III $199,000 $499,000 191,000 298,000 63,000 63,000 S (56,000) $138,000 $750,000 198,000 74,900 S (22,900) Cost of goods sold Selling and administrative expenses Income (lees) frur operations IV $446,000 254,000 46,0IDD $146,00D Analysis reveals the following percentages of variable costs in each division. Cost of goods sold Selling and administrative expenses I...
Pina Company has four operating divisions. During the first quarter of 2017, the company reported aggregate income from operations of $212,300 and the following divisional results. Sales Cost of goods sold Selling and administrative expenses Income (loss) from operations $254,000 204,000 69,700 $ (19,700) Division III $199,000 $501,000 190,000 301,000 61,000 57,000 $ (52,000) $143,000 IV $443,000 247,000 55,000 $141,000 Analysis reveals the following percentages of variable costs in each division. Cost of goods sold Selling and administrative expenses I...
Problem 12-5 Riverbed Company has four operating divisions. During the first quarter of 2017, the company reported aggregate income from operations of $191,000 and the following divisional res I results. Division II III IV Sales $250,000 $198,000 $496,000 $443,000 Cost of goods sold 205,000 190,000 297,000 255,000 Selling and administrative expenses 70,000 64,000 61,000 54,000 $ (25,000) Income (loss) from operations $ (56,000) $134,000 $138,000 Analysis reveals the following percentages of variable costs in each division. II III IV 89...
Problem 7-5 (Part Level Submission) Riverbed Company has four operating divisions. During the first quarter of 2017, the company reported aggregate income from operations of $191,000 and the following divisional results. Division Sales Cost of goods sold Selling and administrative expenses income (loss) from operations $250,000 205,000 70.000 (25,000) $199,000 190,000 64,000 (56,000) $496,000 297,000 61.000 $138,000 $443,000 255,000 $4.000 $134,000 Analysis reveals the following percentages of variable costs in each division. I 69% 37 Cost of goods sold Selling...