Gundy Company expects to produce 1,311,240 units of Product XX in 2012. Monthly production is expected to range from 86,330 to 128,210 units. Budgeted variable manufacturing costs per unit are: direct materials $3, direct labor $8, and overhead $11. Budgeted fixed manufacturing costs per unit for depreciation are $4 and for supervision are $1.
Prepare a flexible manufacturing budget for the relevant range value using 20,940 unit increments IN EXCEL.