In: Accounting
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.)
| 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 | ||