Question

flexible budget for assembly department

Show lle How Calculator Fee d for Assembly Department l es filing cabinets in an Assembly Department Steelcase Inc. (SCS) is one of the largest manufacturers of office furniture in the United States In Grand Rapids, Michigan, ta Assume the following wormation for the Assembly Department: Direct labor perling cabinet 15 minutes Supervisor salaries Depreciation $250,000 per month $18,500 per month $25 per hour Direct laborate Prepare a flexible budget for 70,000, 80,000, and 90,000 fing cabinets for the month ending February 28 in the Assembly Department, similar to Exhibit Steelcase Inc. Assembly Department Budget for the Month Ending February 20 (assumed data) its of production 70,000 000 Towe Tudo Tortos Check My Work Next

Answer 1

Answer-

Steelcase Inc.
Assembly Departmental Budget
For the month of February 28
	Filling Cabinets
Units in production (a)	70000	80000	90000
Direct Labor per filing cabinet (b)	18 minutes	18 minutes	18 minutes
Total time (in minutes) [c=a*b]	1260000	1440000	1620000
Conversion minutes into hours (d)	1260000 minutes/60 minutes=21000 hours	1440000 minutes/60 minutes=24000 hours	1620000 minutes/60 minutes =27000 hours
1 Hours = 60 minutes
Direct labor rate (e)	$28 per hour	$28 per hour	$28 per hour
Direct labor cost (f=d*e)	588000	672000	756000
Supervisor salaries $ (g)	250000	250000	250000
Depreiation $ (h)	18500	18500	18500
Total fixed costs (i)	268500	268500	268500
Total department costs $ (j=f+i)	856500	940500	1024500