Tempo Company |
Flexible Budgets |
For the quarter ended 31 March 2017 |
Flexible budget | Flexible budget at |
Variable amount per unit | Total fixed cost | 10,000 units | 12,000 units | 14,000 units | |
Sales $216 per unit ($2,592,000/12,000) | 2,160,000 | 2,592,000 | 3,024,000 | ||
Variable Costs: | |||||
Direct Materials | $23 | 230,000 | 276,000 | 322,000 | |
Direct Labor | $42 | 420,000 | 504,000 | 588,000 | |
Production Supplies | $26 | 260,000 | 312,000 | 364,000 | |
Sales commission | $8 | 80,000 | 96,000 | 112,000 | |
Packaging | $14 | 140,000 | 168,000 | 196,000 | |
Total variable costs | $113 | 1,130,000 | 1,356,000 | 1,582,000 | |
Contribution margin | $103 | 1,030,000 | 1,236,000 | 1,442,000 | |
Fixed costs: | |||||
Plant manager salary | 76,000 | 76,000 | 76,000 | 76,000 | |
Advertising | 100,000 | 100,000 | 100,000 | 100,000 | |
Administrative salaries | 126,000 | 126,000 | 126,000 | 126,000 | |
Depreciation - office equip. | 96,000 | 96,000 | 96,000 | 96,000 | |
Insurance | 66,000 | 66,000 | 66,000 | 66,000 | |
Office rent | 76,000 | 76,000 | 76,000 | 76,000 | |
Total fixed costs | 540,000 | 540,000 | 540,000 | 540,000 | |
Income from Operations (Sales - VC - FC) | 490,000 | 696,000 | 902,000 |
Check Exercise 23-2 Preparing flexible budgets LO P1 Tempo Company's fixed budget (based on sales of...
Exercise 21-2 Preparing flexible budgets LO P1 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 $ 2,960,800 $240,000 430, eee 270,000 40, eee 980, eee 1,880,898 Sales (10,800 units) 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 90,000 150. eee...
Exercise 8-2 Preparing flexible budgets LO P1 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 $3,834,000 $450,000 792,000 486,000 250,000 1,978,000 1,856,000 Sales (18,000 units) 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 162,000 270,000 100,000 532,000 300,000 270,000 240,000...
tempo company’s fixed budget based of 12000 units 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 $2.460.000 $275,000 516,000 324,000 76,000 1, 192,000 1.268,000 Sales (12,000 units) 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 84,000 180,000 100,000 354.000...
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...
Exercise 21-2 Preparing flexible budgets LO P1 Tempo Company's fixed budget (based on sales of 16,000 units) for the first quarter of calendar year 2017 reveals the following. Fixed Budget Sales (16,000 units) $ 3,312,000 Cost of goods sold Direct materials $ 384,000 Direct labor 688,000 Production supplies 432,000 Plant manager salary 184,000 1,688,000 Gross profit 1,624,000 Selling expenses Sales commissions 144,000 Packaging 256,000 Advertising 100,000 500,000 Administrative expenses Administrative salaries 234,000 Depreciation—office equip. 204,000 Insurance 174,000 Office rent 184,000...
Exercise 21-3 Preparing flexible budgets LO P1 Tempo Company's fixed budget (based on sales of 18,000 units) for the first quarter reveals the following. Fixed Budget Sales (18,000 units × $206 per unit) $ 3,708,000 Cost of goods sold Direct materials $ 432,000 Direct labor 774,000 Production supplies 504,000 Plant manager salary 232,000 1,942,000 Gross profit 1,766,000 Selling expenses Sales commissions 126,000 Packaging 288,000 Advertising 100,000 514,000 Administrative expenses Administrative salaries 282,000 Depreciation—office equip. 252,000 Insurance 222,000 Office rent 232,000...
Exercise 08-3 Preparing flexible budgets LO P1 Tempo Company's fixed budget (based on sales of 16,000 units) for the first quarter reveals the following. Fixed Budget $3,392,000 $384,000 672,000 432,000 184,000 1,672,000 1,720,000 Sales (16,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 144,000 240,000 100,000 484,000 234,000 204,000 174,000...
Exercise 08-3 Preparing flexible budgets LO P1 Tempo Company's fixed budget (based on sales of 16,000 units) for the first quarter reveals the following. Fixed Budget $3,392,000 $384,000 672,000 432,000 184,000 1,672,000 1,720,000 Sales (16,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 144,000 240,000 100,000 484,000 234,000 204,000 174,000...
Tempo Company's fixed budget (based on sales of 16.000 units) for the first quarter of calendar year 2017 reveals the following. Fixed Budget $3,248,000 Sales (16,000 units) 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 $368,000 672,000 416,000 168,000 1,624,000 1,624,000 128,000 256,000 100,000 484,000 218,000 188,000 158,000 168,000 732,000 Income from operations 408,000 Compiete the following flexible...
Check my work 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 Skipped Fixed Budget $2,814,000 $322,000 602,000 392,000 122,000 eBook 1,430.000 1,376,000 Sales (14,000 units * $201 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 210,000...