Help prepare a flexible budget with all information provided please

Ex.06-157 Manufacturing Budget Units of production Variable cost Instruction 10,000 Rodgers Cabinet Manufacturers uses flexble budgets that are based on the following Labels For the Month Ended July 31 Direct materials Direct labor Electric power (variable) Electric power (ixed) Supervisor salaries Property taxes on factory Straight-ine depreciation $5 per unit $0.30 per unit $4,000 per month Direct labor Direct materials Electrie power Property taxers Supervisor salaries Total fixed cost Total manufacturing costs Total variable cost 7 Fixed overhead cost: $25,000 per month $4,000 per month $2,900 per month Prepare a lexible budget for Rodgers based on production of 10,000, 15,000, and 20,000 units. Refer to the Ists of Labeis and Amount Descriptions for the 14. MC.04-97 in cost-v volume-profit analysis, all costs are classified into the following two categories discretionary costs and sunk costs mixed costs and variable costs sunk costs and fixed costs variable costs and fixed costs 15. MC.06-94 Production and sales estimates for March for the Robin Co. are as follows: Estimated inventory (units), March 1 Desired inventory (unit), March 31 18,000 21,600