Question

Flexible Overhead Budget

Leno Manufacturing Company prepared the following factory overhead cost budget for the Press Department for October of the current year, during which it expected to require 20,000 hours of productive capacity in the department:

Variable overhead costs:
Indirect factory labor	$180,000
Power and light	12,000
Indirect materials	64,000
Total variable overhead cost		$256,000
Fixed overhead costs:
Supervisory salaries	$ 80,000
Depreciation of plant and equipment	50,000
Insurance and property taxes	32,000
Total fixed overhead cost		162,000
Total factory overhead cost		$418,000

Assuming that the estimated costs for November are the same as for October, prepare a flexible factory overhead cost budget for the Press Department for November for 18,000, 20,000, and 22,000 hours of production. Enter all amounts as positive numbers. Round your interim computations to the nearest cent, if required.

Leno Manufacturing Company
Factory Overhead Cost Budget-Press Department
For the Month Ended November 30
Direct labor hours	18,000	20,000	22,000
Variable overhead costs:
Indirect factory labor	$	$	$
Power and light
Indirect materials
Total variable factory overhead	$	$	$
Fixed factory overhead costs:
Supervisory salaries	$	$	$
Depreciation of plant and equipment
Insurance and property taxes
Total fixed factory overhead	$	$	$
Total factory overhead	$	$	$

Answer 1

Solution

Leno Manufacturing Company
Factory Overhead Cost Budget-Press Department
For the Month Ended November 30
Direct labor hours	18,000	20,000	22,000
Variable overhead cost:
Indirect factory labor	$   57,600.00	$   64,000.00	$   70,400.00
Power and light	$   10,800.00	$   12,000.00	$   13,200.00
Indirect materials	$   57,600.00	$   64,000.00	$   70,400.00
Total variable factory overhead	$ 126,000.00	$ 140,000.00	$ 154,000.00
Fixed factory overhead cost:
Supervisory salaries	$   80,000.00	$   80,000.00	$   80,000.00
Depreciation of plant and equipment	$   50,000.00	$   50,000.00	$   50,000.00
Insurance and property taxes	$   32,000.00	$   32,000.00	$   32,000.00
Total fixed factory overhead	$ 162,000.00	$ 162,000.00	$ 162,000.00
Total factory overhead cost	$ 288,000.00	$ 302,000.00	$ 316,000.00

Working

Leno Manufacturing Company
Factory Overhead Cost Budget-Press Department
For the Month Ended November 30
Direct labor hours	18000	20000	22000
Variable overhead cost:
Indirect factory labor	=64000/20000*18000	=64000/20000*20000	=64000/20000*22000
Power and light	=+(12000)/20000*18000	=+(12000)/20000*20000	=+(12000)/20000*22000
Indirect materials	=+(64000)/20000*18000	=+(64000)/20000*20000	=+(64000)/20000*22000