Question

In: Accounting

Tempo Company's fixed budget (based on sales of 12,000 units) for the first quarter of calendar...

Tempo Company's fixed budget (based on sales of 12,000 units) for the first quarter of calendar year 2017 reveals the following.

Fixed Budget
Sales (12,000 units) $ 2,436,000
Cost of goods sold
Direct materials $ 288,000
Direct labor 516,000
Production supplies 324,000
Plant manager salary 88,000 1,216,000
Gross profit 1,220,000
Selling expenses
Sales commissions 96,000
Packaging 192,000
Advertising 100,000 388,000
Administrative expenses
Administrative salaries 138,000
Depreciation—office equip. 108,000
Insurance 78,000
Office rent 88,000 412,000
Income from operations $ 420,000


Complete the following flexible budgets for sales volumes of 10,000, 12,000, and 14,000 units. (Round cost per unit to 2 decimal places.)

Solutions

Expert Solution

TEMPO COMPANY
Flexible Budgets
For Quarter Ended March 31, 2017
------Flexible Budget------ ------Flexible Budget at ------
Variable Amount
per Unit
Total Fixed Cost 10,000 units 12,000 units 14,000 units
Sales 203 2,030,000 2,436,000 2,842,000
Variable costs:
Direct materials 24 240,000 288,000 336,000
Direct labor 43 430,000 516,000 602,000
Production supplies 27 270,000 324,000 378,000
Sales commissions 8 80,000 96,000 112,000
Packaging 16 160,000 192,000 224,000
Total variable costs 118 1180000 1416000 1652000
Contribution margin 85 850,000 1,020,000 1,190,000
Fixed costs:
Plant manager salary 88,000 88,000 88,000 88,000
Advertising 100,000 100,000 100,000 100,000
Administrative salaries 138,000 138,000 138,000 138,000
Depreciation—office equip. 108,000 108,000 108,000 108,000
Insurance 78,000 78,000 78,000 78,000
Office rent 88,000 88,000 88,000 88,000
Total fixed costs 600,000 600,000 600,000 600,000
Income from operations 250,000 420,000 590,000

Related Solutions

Tempo Company's fixed budget (based on sales of 12,000 units) for the first quarter reveals the...
Tempo Company's fixed budget (based on sales of 12,000 units) for the first quarter reveals the following. Fixed Budget Sales (12,000 units × $215 per unit) $ 2,580,000 Cost of goods sold Direct materials $ 288,000 Direct labor 504,000 Production supplies 324,000 Plant manager salary 88,000 1,204,000 Gross profit 1,376,000 Selling expenses Sales commissions 96,000 Packaging 180,000 Advertising 100,000 376,000 Administrative expenses Administrative salaries 138,000 Depreciation—office equip. 108,000 Insurance 78,000 Office rent 88,000 412,000 Income from operations $ 588,000 (1)...
Tempo Company's fixed budget (based on sales of 12,000 units) for the first quarter reveals the...
Tempo Company's fixed budget (based on sales of 12,000 units) for the first quarter reveals the following. Fixed Budget Sales (12,000 units × $209 per unit) $ 2,508,000 Cost of goods sold Direct materials $ 288,000 Direct labor 528,000 Production supplies 324,000 Plant manager salary 88,000 1,228,000 Gross profit 1,280,000 Selling expenses Sales commissions 96,000 Packaging 168,000 Advertising 100,000 364,000 Administrative expenses Administrative salaries 138,000 Depreciation—office equip. 108,000 Insurance 78,000 Office rent 88,000 412,000 Income from operations $ 504,000 (1)...
Tempo Company's fixed budget (based on sales of 12,000 units) for the first quarter reveals the...
Tempo Company's fixed budget (based on sales of 12,000 units) for the first quarter reveals the following. Fixed Budget Sales (12,000 units × $207 per unit) $ 2,484,000 Cost of goods sold Direct materials $ 288,000 Direct labor 528,000 Production supplies 324,000 Plant manager salary 88,000 1,228,000 Gross profit 1,256,000 Selling expenses Sales commissions 96,000 Packaging 192,000 Advertising 100,000 388,000 Administrative expenses Administrative salaries 138,000 Depreciation—office equip. 108,000 Insurance 78,000 Office rent 88,000 412,000 Income from operations $ 456,000 (1)...
Tempo Company's fixed budget (based on sales of 18,000 units) for the first quarter of calendar...
Tempo Company's fixed budget (based on sales of 18,000 units) for the first quarter of calendar year 2017 reveals the following. Fixed Budget Sales (18,000 units) $ 3,816,000 Cost of goods sold Direct materials $ 432,000 Direct labor 792,000 Production supplies 468,000 Plant manager salary 232,000 1,924,000 Gross profit 1,892,000 Selling expenses Sales commissions 144,000 Packaging 288,000 Advertising 100,000 532,000 Administrative expenses Administrative salaries 282,000 Depreciation—office equip. 252,000 Insurance 222,000 Office rent 232,000 988,000 Income from operations $ 372,000 Complete...
Tempo Company's fixed budget (based on sales of 14,000 units) for the first quarter of calendar...
Tempo Company's fixed budget (based on sales of 14,000 units) for the first quarter of calendar year 2017 reveals the following. Fixed Budget Sales (14,000 units) $ 2,940,000 Cost of goods sold Direct materials $ 336,000 Direct labor 588,000 Production supplies 378,000 Plant manager salary 136,000 1,438,000 Gross profit 1,502,000 Selling expenses Sales commissions 112,000 Packaging 196,000 Advertising 100,000 408,000 Administrative expenses Administrative salaries 186,000 Depreciation—office equip. 156,000 Insurance 126,000 Office rent 136,000 604,000 Income from operations $ 490,000 Complete...
Tempo Company's fixed budget (based on sales of 14,000 units) for the first quarter of calendar...
Tempo Company's fixed budget (based on sales of 14,000 units) for the first quarter of calendar year 2017 reveals the following. Fixed Budget Sales (14,000 units) $ 2,954,000 Cost of goods sold Direct materials $ 350,000 Direct labor 588,000 Production supplies 378,000 Plant manager salary 150,000 1,466,000 Gross profit 1,488,000 Selling expenses Sales commissions 112,000 Packaging 224,000 Advertising 100,000 436,000 Administrative expenses Administrative salaries 200,000 Depreciation—office equip. 170,000 Insurance 140,000 Office rent 150,000 660,000 Income from operations $ 392,00 Complete...
Tempo Company's fixed budget (based on sales of 14,000 units) for the first quarter of calendar...
Tempo Company's fixed budget (based on sales of 14,000 units) for the first quarter of calendar year 2017 reveals the following. Fixed Budget Sales (14,000 units) $ 3,066,000 Cost of goods sold Direct materials $ 336,000 Direct labor 602,000 Production supplies 364,000 Plant manager salary 136,000 1,438,000 Gross profit 1,628,000 Selling expenses Sales commissions 126,000 Packaging 210,000 Advertising 100,000 436,000 Administrative expenses Administrative salaries 186,000 Depreciation—office equip. 156,000 Insurance 126,000 Office rent 136,000 604,000 Income from operations $ 588,000 Complete...
Tempo Company's fixed budget (based on sales of 10,000 units) for the first quarter of calendar...
Tempo Company's fixed budget (based on sales of 10,000 units) for the first quarter of calendar year 2017 reveals the following. Fixed Budget Sales (10,000 units) $ 2,190,000 Cost of goods sold Direct materials $ 240,000 Direct labor 430,000 Production supplies 270,000 Plant manager salary 40,000 980,000 Gross profit 1,210,000 Selling expenses Sales commissions 90,000 Packaging 140,000 Advertising 100,000 330,000 Administrative expenses Administrative salaries 90,000 Depreciation—office equip. 60,000 Insurance 30,000 Office rent 40,000 220,000 Income from operations $ 660,000 Complete...
Tempo Company's fixed budget (based on sales of 14,000 units) for the first quarter of calendar...
Tempo Company's fixed budget (based on sales of 14,000 units) for the first quarter of calendar year 2017 reveals the following. Fixed Budget Sales (14,000 units) $ 2,940,000 Cost of goods sold Direct materials $ 336,000 Direct labor 602,000 Production supplies 378,000 Plant manager salary 136,000 1,452,000 Gross profit 1,488,000 Selling expenses Sales commissions 98,000 Packaging 210,000 Advertising 100,000 408,000 Administrative expenses Administrative salaries 186,000 Depreciation—office equip. 156,000 Insurance 126,000 Office rent 136,000 604,000 Income from operations $ 476,000 Complete...
Tempo Company's fixed budget (based on sales of 14,000 units) for the first quarter of calendar...
Tempo Company's fixed budget (based on sales of 14,000 units) for the first quarter of calendar year 2017 reveals the following. Sales (14,000 units) $ 2,828,000 Cost of goods sold Direct materials $ 350,000 Direct labor 602,000 Production supplies 378,000 Plant manager salary 150,000 1,480,000 Gross profit 1,348,000 Selling expenses Sales commissions 112,000 Packaging 224,000 Advertising 100,000 436,000 Administrative expenses Administrative salaries 200,000 Depreciation—office equip. 170,000 Insurance 140,000 Office rent 150,000 660,000 Income from operations $ 252,000 Complete the following...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT