In: Accounting
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,408,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,720,000 | |||||||
| Selling expenses | ||||||||
| Sales commissions | 128,000 | |||||||
| Packaging | 240,000 | |||||||
| Advertising | 100,000 | 468,000 | ||||||
| Administrative expenses | ||||||||
| Administrative salaries | 234,000 | |||||||
| Depreciation—office equip. | 204,000 | |||||||
| Insurance | 174,000 | |||||||
| Office rent | 184,000 | 796,000 | ||||||
| Income from operations | $ | 456,000 | ||||||
Complete the following flexible budgets for sales volumes of
14,000, 16,000, and 18,000 units. (Round cost per unit to 2
decimal places.)
| Flexible Budget | ||||||||
| variable | total | 14,000 | 16,000 | 18,000 | ||||
| amount | fixed cost | units | units | units | ||||
| per unit | ||||||||
| Sales | 213 | 2982000 | 3408000 | 3834000 | ||||
| Variable costs: | ||||||||
| Direct materials | 24 | 336000 | 384000 | 432000 | ||||
| direct labor | 43 | 602000 | 688000 | 774000 | ||||
| production supplies | 27 | 378000 | 432000 | 486000 | ||||
| Sales commissions | 8 | 112000 | 128000 | 144000 | ||||
| packaging | 15 | 210000 | 240000 | 270000 | ||||
| total variable costs | 117 | 1638000 | 1872000 | 2106000 | ||||
| contribution margin | 96 | 1344000 | 1536000 | 1728000 | ||||
| Fixed costs : | ||||||||
| plant manager salary | 184,000 | 184,000 | 184,000 | 184,000 | ||||
| Advertising | 100,000 | 100,000 | 100,000 | 100,000 | ||||
| Administrative salaries | 234,000 | 234,000 | 234,000 | 234,000 | ||||
| Depreciation -office Equip | 204,000 | 204,000 | 204,000 | 204,000 | ||||
| insurance | 174,000 | 174,000 | 174,000 | 174,000 | ||||
| office rent | 184,000 | 184,000 | 184,000 | 184,000 | ||||
| total fixed costs | 1,080,000 | 1,080,000 | 1,080,000 | 1,080,000 | ||||
| income from operations | 264,000 | 456,000 | 648,000 | |||||