1) Calculation of Variable cost per unit
Direct materials (350000/14000) | $25 |
Direct labor (616000/14000) | 44 |
Production supplies (364000/14000) | 26 |
Sales commissions (98000/14000) | 7 |
Packaging (210000/14000) | 15 |
Total variable costs | $117 |
2) Calculation of Fixed costs
Plant manager salary | $150000 |
Advertising | 100000 |
Administrative salaries | 200000 |
Depreciation- office equipment | 170000 |
Insurance | 140000 |
Office rent | 150000 |
Total fixed costs | $910000 |
3) Calculation of Income from operation for sales volume of 12000 units
Sales (12000*$201) | $2412000 | |
Less: Variable costs | ||
Direct materials (12000*$25) | 300000 | |
Direct labor (12000*$44) | 528000 | |
Production supplies (12000*$26) | 312000 | |
Sales commissions (12000*$7) | 84000 | |
Packaging (12000*$15) | 180000 | |
Total variable costs | 1404000 | |
Contribution margin | 1008000 | |
Less: Fixed costs | ||
Plant manager salary | 150000 | |
Advertising | 100000 | |
Administrative salaries | 200000 | |
Depreciation- office equipment | 170000 | |
Insurance | 140000 | |
Office rent | 150000 | |
Total fixed costs | 910000 | |
Income from operations | $98000 |
4) Calculation of Income from operation for sales volume of 16000 units
Sales (16000*$201) | $3216000 | |
Less: Variable costs | ||
Direct materials (16000*$25) | 400000 | |
Direct labor (16000*$44) | 704000 | |
Production supplies (16000*$26) | 416000 | |
Sales commissions (16000*$7) | 112000 | |
Packaging (16000*$15) | 240000 | |
Total variable costs | 1872000 | |
Contribution margin | 1344000 | |
Less: Fixed costs | ||
Plant manager salary | 150000 | |
Advertising | 100000 | |
Administrative salaries | 200000 | |
Depreciation- office equipment | 170000 | |
Insurance | 140000 | |
Office rent | 150000 | |
Total fixed costs | 910000 | |
Income from operations | $434000 |
Tempo Company's fixed budget (based on sales of 14,000 units) for the first quarter reveals the...
Tempo Company's fixed budget (based on sales of 14,000 units) for the first quarter reveals the following. Fixed Budget Sales (14,000 units × $211 per unit) $ 2,954,000 Cost of goods sold Direct materials $ 350,000 Direct labor 588,000 Production supplies 392,000 Plant manager salary 150,000 1,480,000 Gross profit 1,474,000 Selling expenses Sales commissions 112,000 Packaging 196,000 Advertising 100,000 408,000 Administrative expenses Administrative salaries 200,000 Depreciation—office equip. 170,000 Insurance 140,000 Office rent 150,000 660,000 Income from operations $ 406,000 (1)...
Tempo Company's fixed budget (based on sales of 14,000 units) for the first quarter reveals the following. Fixed Budget $2,926,000 $350,000 588,000 378,000 150,000 1,466,000 1,460,000 Sales (14,000 units x $209 per unit) Cost of goods sold Direct materials Direct labor Production supplies Plant manager salary Gross profit Selling expenses Sales commissions Packaging Advertising Administrative expenses Administrative salaries Depreciation-office equip. Insurance Office rent Income from operations 112,000 196,000 100,000 408,000 200,000 170,000 140,000 150,000 660,000 $ 392,000 (1) Compute the...
Tempo Company's fixed budget (based on sales of 14,000 units) for the first quarter reveals the following. Fixed Budget $ 2,996,000 $350,000 602,000 392,000 150,000 1,494,000 1,502,000 Sales (14,000 units X $214 per unit) Cost of goods sold Direct materials Direct labor Production supplies Plant manager salary Gross profit Selling expenses Sales commissions Packaging Advertising Administrative expenses Administrative salaries Depreciation-office equip. Insurance Office rent Income from operations 126,000 210,000 100,000 436,000 200,000 170,000 140,000 150,000 660,000 406,000 $ (1) Compute...
Tempo Company's fixed budget (based on sales of 18,000 units) for the first quarter reveals the following. Fixed Budget $3,798,000 $ 432,000 756.000 468,000 232,000 1,888,000 1,910,000 Sales (18,000 units $211 per unit) Cost of goods sold Direct materials Direct labor Production supplies Plant manager salary Gross profit Selling expenses Sales commissions Packaging Advertising Administrative expenses Administrative salaries Depreciation-office equip. Insurance Office rent Income from operations 144,000 270,000 100.000 514,000 282,000 252,000 222,000 232,000 988.000 408.000 $ (1) Compute the...
Tempo Company's fixed budget (based on sales of 12,000 units) for the first quarter reveals the following. Fixed Budget $2,592,000 Sales (12,000 units $216 per unit) Cost of goods sold Direct materials Direct labor Production supplies Plant manager salary Gross profit Selling expenses Sales commissions Packaging Advertising Administrative expenses Administrative salaries Depreciation-office equip Insurance Office rent $300,000 504,000 324,000 100,000 1,228,000 1,364,000 84,000 180,000 100,000 364,000 150,000 120,000 90,000 100,000 460,000 $ 540,000 Income from operations (1) Compute the total...
Tempo Company's fixed budget (based on sales of 14,000 units) for the first quarter reveals the following. Fixed Budget Sales (14,000 units × $205 per unit) $ 2,870,000 Cost of goods sold Direct materials $ 322,000 Direct labor 602,000 Production supplies 392,000 Plant manager salary 122,000 1,438,000 Gross profit 1,432,000 Selling expenses Sales commissions 112,000 Packaging 210,000 Advertising 100,000 422,000 Administrative expenses Administrative salaries 172,000 Depreciation—office equip. 142,000 Insurance 112,000 Office rent 122,000 548,000 Income from operations $ 462,000 (1)...
Tempo Company's fixed budget (based on sales of 10,000 units) for the first quarter reveals the following Fixed Budget $2,050,e00 Sales (10,000 units x $205 per unit) Cost of goods sold Direct materials $240,000 Direct labor 440,000 Production supplies Plant manager salary Gross profit Selling expenses Sales commissions Packaging Advertising Administrative expenses Administrative salaries Depreciation-office equip. Insurance Office rent 260,000 40,000 980,000 1,070,000 80,000 150,000 100,000 330,000 90,000 60,000 30,000 40,000 220,000 $ 520,000 Income from operations (1) Compute the...
Tempo Company's fixed budget (based on sales of 18,000 units) for the first quarter reveals the following. Fixed Budget $3,798,000 $432,000 774,000 486,000 232,000 1,924,000 1,874,000 Sales (18,000 units * $211 per unit) Cost of goods sold Direct materials Direct labor Production supplies Plant manager salary Gross profit Selling expenses Sales commissions Packaging Advertising Administrative expenses Administrative salaries Depreciation-office equip. Insurance Office rent Income from operations 144,000 270,000 100,000 514,000 282,000 252,000 222,000 232,000 988,000 372,000 $ (1) Compute the...
Exercise 08-3 Preparing flexible budgets LO P1 Tempo Company's fixed budget (based on sales of 14,000 units) for the first quarter reveals the following. Fixed Budget $2,926,000 $350,000 602,000 378,000 150,000 1,480,000 1,446,000 Sales (14,000 units X $209 per unit) Cost of goods sold Direct materials Direct labor Production supplies Plant manager salary Gross profit Selling expenses Sales commissions Packaging Advertising Administrative expenses Administrative salaries Depreciation-office equip. Insurance Office rent Income from operations 126,000 210,000 100,000 436,000 200,000 170,000 140,000...
Tempo Company's fixed budget (based on sales of 12,000 units) for the first quarter reveals the following. Fixed Budget $ 2,544,000 $300,000 528,000 312,000 100,000 1,240,000 1,304,000 Sales (12,000 units X $212 per unit) Cost of goods sold Direct materials Direct labor Production supplies Plant manager salary Gross profit Selling expenses Sales commissions Packaging Advertising Administrative expenses Administrative salaries Depreciation office equip. Insurance Office rent Income from operations 96,000 180,000 100,000 376,000 150,000 120,000 90,000 100,000 460,000 468,000 $ (1)...