In: Accounting
Johnny Lee Inc. produces a line of small gasoline-powered engines that can be used in a variety of residential machines, ranging from different types of lawnmowers, to snowblowers, to garden tools (such as tillers and weed-whackers). The basic product line consists of three different models, each meant to fill the needs of a different market. Assume you are the cost accountant for this company and that you have been asked by the owner of the company to construct a flexible budget for factory overhead costs, which seem to be growing faster than revenues. Currently, the company uses machine hours (MHs) as the basis for assigning both variable and fixed factory overhead costs to products.
Within the relevant range of output, you determine that the following factory fixed overhead costs per month should occur: engineering support, $16,100; insurance on the manufacturing facility, $6,100; property taxes on the manufacturing facility, $13,100; depreciation on manufacturing equipment, $14,900; and indirect labor costs of supervisory salaries, $15,900, setup labor, $3,500, and materials handling, $3,600. Variable factory overhead costs are budgeted at $76.00 per machine hour, as follows: electricity, $19.00; indirect materials for Material A of $12.00 and for Material B of $15.00; indirect labor—maintenance, $17.00; and production-related supplies, $13.00.
Required:
1. Prepare a flexible budget for Johnny Lee for each of the following monthly levels of machine hours: (a) 5,100, (b) 6,100, and (c) 7,100.
2. Generate an equation to represent, within the relevant range, the factory overhead costs per month for Johnny Lee. Use this equation to estimate monthly total overhead cost for machine hours of 4,100 to 7,100, in increments of 500.