In: Finance
Phoenix Company’s 2017 master budget included the following
fixed budget report. It is based on an expected production and
sales volume of 15,000 units.
| PHOENIX COMPANY Fixed Budget Report For Year Ended December 31, 2017  | 
|||||
| Sales | $ | 3,375,000 | |||
| Cost of goods sold | |||||
| Direct materials | $ | 975,000 | |||
| Direct labor | 300,000 | ||||
| Machinery repairs (variable cost) | 60,000 | ||||
| Depreciation—Plant equipment (straight-line) | 330,000 | ||||
| Utilities ($45,000 is variable) | 205,000 | ||||
| Plant management salaries | 215,000 | 2,085,000 | |||
| Gross profit | 1,290,000 | ||||
| Selling expenses | |||||
| Packaging | 75,000 | ||||
| Shipping | 105,000 | ||||
| Sales salary (fixed annual amount) | 270,000 | 450,000 | |||
| General and administrative expenses | |||||
| Advertising expense | 130,000 | ||||
| Salaries | 261,000 | ||||
| Entertainment expense | 100,000 | 491,000 | |||
| Income from operations | $ | 349,000 | |||
Phoenix Company’s actual income statement for 2017
follows.
| PHOENIX COMPANY Statement of Income from Operations For Year Ended December 31, 2017  | 
|||||
| Sales (18,000 units) | $ | 4,128,000 | |||
| Cost of goods sold | |||||
| Direct materials | $ | 1,187,000 | |||
| Direct labor | 368,000 | ||||
| Machinery repairs (variable cost) | 63,000 | ||||
| Depreciation—Plant equipment (straight-line) | 330,000 | ||||
| Utilities (fixed cost is $158,000) | 211,000 | ||||
| Plant management salaries | 226,000 | 2,385,000 | |||
| Gross profit | 1,743,000 | ||||
| Selling expenses | |||||
| Packaging | 87,250 | ||||
| Shipping | 119,000 | ||||
| Sales salary (annual) | 287,000 | 493,250 | |||
| General and administrative expenses | |||||
| Advertising expense | 138,000 | ||||
| Salaries | 261,000 | ||||
| Entertainment expense | 103,500 | 502,500 | |||
| Income from operations | $ | 747,250 | |||
Required:
1. Prepare a flexible budget performance report
for 2017.