In: Accounting
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 | ||||||||
| Sales (10,000 units) | $ | 2,150,000 | ||||||
| Cost of goods sold | ||||||||
| Direct materials | $ | 250,000 | ||||||
| Direct labor | 420,000 | |||||||
| Production supplies | 260,000 | |||||||
| Plant manager salary | 50,000 | 980,000 | ||||||
| Gross profit | 1,170,000 | |||||||
| Selling expenses | ||||||||
| Sales commissions | 70,000 | |||||||
| Packaging | 150,000 | |||||||
| Advertising | 100,000 | 320,000 | ||||||
| Administrative expenses | ||||||||
| Administrative salaries | 100,000 | |||||||
| Depreciation—office equip. | 70,000 | |||||||
| Insurance | 40,000 | |||||||
| Office rent | 50,000 | 260,000 | ||||||
| Income from operations | $ | 590,000 | ||||||
Complete the following flexible budgets for sales volumes of 8,000,
10,000, and 12,000 units. (Round cost per unit to 2 decimal
places.)
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| TEMPO COMPANY | |||||
| Flexible Budgets | |||||
| For Quarter Ended March 31, 2017 | |||||
| ------Flexible Budget------ | ------Flexible Budget at ------ | ||||
| Variable Amount per Unit | Total Fixed Cost | 8,000 units | 10,000 units | 12,000 units | |
| Sales | $215 | $1,720,000 | $2,150,000 | $2,580,000 | |
| Variable costs: | |||||
| Direct materials | 25 | $200,000 | $250,000 | $300,000 | |
| Direct labor | 42 | $336,000 | $420,000 | $504,000 | |
| Production supplies | 26 | $208,000 | $260,000 | $312,000 | |
| Sales commissions | 7 | $56,000 | $70,000 | $84,000 | |
| Packaging | 15 | $120,000 | $150,000 | $180,000 | |
| Total variable costs | 115 | 920000 | 1150000 | 1380000 | |
| Contribution margin | $100 | $800,000 | $1,000,000 | $1,200,000 | |
| Fixed costs: | |||||
| Plant manager salary | 50,000 | 50,000 | 50,000 | 50,000 | |
| Advertising | 100,000 | 100,000 | 100,000 | 100,000 | |
| Administrative salaries | 100,000 | 100,000 | 100,000 | 100,000 | |
| Depreciation—office equip. | 70,000 | 70,000 | 70,000 | 70,000 | |
| Insurance | 40,000 | 40,000 | 40,000 | 40,000 | |
| Office rent | 50,000 | 50,000 | 50,000 | 50,000 | |
| Total fixed costs | 410,000 | 410,000 | 410,000 | 410,000 | |
| Income from operations | $390,000 | $590,000 | $790,000 | ||