Gundy Company expects to produce 1,256,880 units of Product XX in 2012. Monthly production is expected to range from 85,650 to 128,610 units. Budgeted variable manufacturing costs per unit are: direct materials $4, direct labor $7, and overhead $10. Budgeted fixed manufacturing costs per unit for depreciation are $5 and for supervision are $1.

Prepare a flexible manufacturing budget for the relevant range value using 21,480 unit increments. (List variable costs before fixed costs.)

GUNDY COMPANY Monthly Flexible Manufacturing Budget For the Year 2012
Total Costs Total Fixed Costs Fixed Costs Supervision Overhead Activity Level Total Variable Costs Variable Costs Depreciation Direct Labor Direct Materials Finished Units
Total Fixed Costs Variable Costs Supervision Finished Units Total Costs Fixed Costs Activity Level Depreciation Direct Labor Total Variable Costs Direct Materials Overhead
Total Fixed Costs Direct Labor Total Costs Variable Costs Finished Units Total Variable Costs Activity Level Fixed Costs Overhead Supervision Depreciation Direct Materials
Direct Labor Variable Costs Direct Materials Finished Units Total Variable Costs Fixed Costs Activity Level Overhead Supervision Depreciation Total Costs Total Fixed Costs	$	$	$
Variable Costs Depreciation Direct Labor Direct Materials Supervision Activity Level Finished Units Total Costs Fixed Costs Overhead Total Fixed Costs Total Variable Costs
Activity Level Depreciation Total Variable Costs Direct Materials Overhead Supervision Total Costs Finished Units Direct Labor Total Fixed Costs Fixed Costs Variable Costs
Total Fixed Costs Finished Units Supervision Variable Costs Direct Labor Total Variable Costs Depreciation Activity Level Fixed Costs Direct Materials Overhead Total Costs	$	$	$
Total Variable Costs Supervision Overhead Total Costs Finished Units Depreciation Direct Labor Total Fixed Costs Direct Materials Fixed Costs Variable Costs Activity Level
Total Variable Costs Total Costs Total Fixed Costs Finished Units Variable Costs Direct Labor Activity Level Depreciation Direct Materials Fixed Costs Overhead Supervision
Total Variable Costs Finished Units Total Costs Direct Labor Fixed Costs Total Fixed Costs Depreciation Overhead Direct Materials Supervision Variable Costs Activity Level
Total Fixed Costs Direct Materials Finished Units Fixed Costs Overhead Depreciation Direct Labor Total Variable Costs Supervision Total Costs Variable Costs Activity Level
Overhead Depreciation Total Fixed Costs Finished Units Total Costs Direct Labor Direct Materials Fixed Costs Supervision Total Variable Costs Variable Costs Activity Level	$	$	$