Sheffield Company expects to produce 1,312,800 units of Product XX in 2020. Monthly production is expected to range from 84,000 to 130,000 units. Budgeted variable manufacturing costs per unit are direct materials $5, direct labor $7, and overhead $11. Budgeted fixed manufacturing costs per unit for depreciation are $4 and for supervision are $2. Prepare a flexible manufacturing budget for the relevant range value using 23,000 unit increments.

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