Gundy Company expects to produce 1,287,600 units of Product XX in 2017. Monthly production is expected to range from 78,800 to 118,000 units. Budgeted variable manufacturing costs per unit are direct materials $3, direct labor $7, and overhead $10. Budgeted fixed manufacturing costs per unit for depreciation are $5 and for supervision are $3. Prepare a flexible manufacturing budget for the relevant range value using 19,600 unit increments.

Please show formulas

For the Year 2017 Activity Level Finished units L 78800 L 98400 Variable Costs Direct Materials 236400 295200 Direct Labor v 551600 688800 Overhead 788000 084 000 1576000 1968000 Fixed Costs Depreciation T 94000 492000 i Supervision 2 295200 236400 630400 787200 2206400 2755200 L Total Costs 118000 354000 6000 1180000 2360000 90000 354000 3304000