Prepare a flex budget from this info for three activity levels: 18,000 units, 22,000 units, and 25,000 units. Thank you in advance for help.

For simplicity, assume that the company produces a single product, sales are equal to production, and inventory levels are zero. Below are the standard costs per boot: Standard Price Standard Quantity of input Ailowed per Unit of Output pounds per Unit of Input $3 per pound $17 per hour Direct materials Direct labor 1 hour Below is the budgeted information for the month of July: Units produced and sold Average selling price per unit Direct materials - based on the standards per unit Direct labor-based on the standards per unit Variable factory overhead per unit Fixed factory overhead Variable shipping costs per unit Variable selling cost per unit Fixed selling costs Fixed administrative costs 20,000 $42 $5 per direct labor hour $50,000 $3 $1 $15,000 $20,000 Below are the actual results for the month July: Units produced and sold Actual sales revenue (see table below by customer) 20,120 $829,820 $191,750 $333,450 $103,000 $54,000 $61,000 $19,850 $17,000 $21,000 Direct materials (65,000 lbs used) Direct labor (19,500 actual hours) Variable factory overhead Fixed factory overhead Variable shipping costs Variable selling cost Fixed selling costs Fixed administrative costs *include variable shipping costs in cost of goods sold when preparing the income statement Actual sales units and selling prices by customer for July: Selling Price $39 per unit Units Customer A 12,000 $44 per unit $46 per unit 5,850 Customer B Customer C 2,270