Solution
TEMPO COMPANY | |||||
Flexible Budget | |||||
For the quarter ended March 31 2017 | |||||
Flexibla budget | Flexible budget at | ||||
variable Amount per Unit | Total Fixed cost | 16000 Units | 18000 Units | 20000 Units | |
Sales | $ 203.00 | $ 3,248,000.00 | $ 3,654,000.00 | $ 4,060,000.00 | |
Variable costs | |||||
Direct material | $ 24.00 | $ 384,000.00 | $ 432,000.00 | $ 480,000.00 | |
Direct Labor | $ 44.00 | $ 704,000.00 | $ 792,000.00 | $ 880,000.00 | |
Production Supplies | $ 26.00 | $ 416,000.00 | $ 468,000.00 | $ 520,000.00 | |
Sales commission | $ 7.00 | $ 112,000.00 | $ 126,000.00 | $ 140,000.00 | |
Packaging | $ 14.00 | $ 224,000.00 | $ 252,000.00 | $ 280,000.00 | |
Total Variable Costs | $ 115.00 | $ 1,840,000.00 | $ 2,070,000.00 | $ 2,300,000.00 | |
Contribution margin | $ 88.00 | $ 1,408,000.00 | $ 1,584,000.00 | $ 1,760,000.00 | |
Fixed Costs | |||||
Plant manager's salary | $ 232,000.00 | $ 232,000.00 | $ 232,000.00 | $ 232,000.00 | |
Advertising | $ 100,000.00 | $ 100,000.00 | $ 100,000.00 | $ 100,000.00 | |
Administrative salaries | $ 282,000.00 | $ 282,000.00 | $ 282,000.00 | $ 282,000.00 | |
Depreciation-Office equipment | $ 252,000.00 | $ 252,000.00 | $ 252,000.00 | $ 252,000.00 | |
Insurance | $ 222,000.00 | $ 222,000.00 | $ 222,000.00 | $ 222,000.00 | |
Office rent | $ 232,000.00 | $ 232,000.00 | $ 232,000.00 | $ 232,000.00 | |
Total Fixed Costs | $ 1,320,000.00 | $ 1,320,000.00 | $ 1,320,000.00 | $ 1,320,000.00 | |
Income From operations | $ 88,000.00 | $ 264,000.00 | $ 440,000.00 |
please be sure to answer in the format that follows the table provided. Tempo Company's fixed budget (based on sale...
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) Cost of goods sold $3,888,000 Direct materials Direct labor Production supplies Plant manager salary $432,000 774,000 486,000 232,000 1,924,000 Gross profit Selling expenses 1,964,000 Sales commissions Packaging Advertising 162,000 252,000 100.000 514,000 Administrative expenses Administrative salaries epreciation-office equip. Insurance Office rent 282,000 252,000 222,000 232,000 988,000 462,000 Income from operations Complete the following flexible...
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 on sales of 16,000 units) for the first quarter of calendar year 2017 reveals the following Fixed Budget 53,424,800 $368,000 672,000 416,000 168,00 1.624,000 1,800,000 Sales (16,000 units) Cost of goods sold Direct materials Direct labor Production supplies Plant manager salary Gross profit Selling expenses Sales Comissions Packaging Advertising Administrative expenses Administrative salaries Depreciation-office equip. Insurance Office rent Income from operations 128,000 240,000 100,000 468,000 218,000 188,888 158,000 168,000 1732,000 $ 600,000 Complete the following...
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...
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...
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 × $204 per unit) $ 3,672,000 Cost of goods sold Direct materials $ 450,000 Direct labor 792,000 Production supplies 504,000 Plant manager salary 250,000 1,996,000 Gross profit 1,676,000 Selling expenses Sales commissions 126,000 Packaging 252,000 Advertising 100,000 478,000 Administrative expenses Administrative salaries 300,000 Depreciation—office equip. 270,000 Insurance 240,000 Office rent 250,000 1,060,000 Income from operations $ 138,000 (1)...
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 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...
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) Cost of goods sold $3,328,000 $384,00e Direct materials Direct labor Production supplies Plant manager salary 688,000 416,000 184,000 1,672,000 Gross profit Selling expenses 1,656,000 Sales Commissions Packaging Advertising 128,000 256,000 100,000 484,000 Administrative expenses Administrative salaries Depreciation-office equip. 204,000 Insurance OTTice rent 234,000 174,000 184,000 96,900 Income from operations $ 376,000 Complete the following...
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 x $214 per unit) Cost of goods sold Direct materials $3,852,000 $432,000 774,000 504,000 232,000 Direct labor Production supplies Plant manager salary Gross profit Selling expenses 1,942,000 1,910,000 126,000 270,000 Sales commissions Packaging Advertising Administrative expenses 100,000 496,000 Administrative salaries 282,000 252,000 222,000 Depreciation-office equip Insurance Office rent 232,000 988,000 Income from operations $ 426,000 (1) Compute the...