Prepare flexible budget analysis with 5 valued colums of...

BASE CASE =Static Budget=Plan Units 1200 two columns of variable Variable Expense Fixed $Per Unit per $s Sold DL $ Fixed$s Sales$ 720,000 $ 600.00 Direct materials 180,000 $ 150.00 Direct labor 84,000$ 70.00 0 0 0 0 per unit Fxd. a BASE CASE -Static Budget=Plan $ 70,00 1200 Units Variable + b X bx $ 1.25 84,000 $ 105,000 Manufacturing $ 60.00 1,200 $72,000 overhead sum fixed & variable 267,000 2 Drivers: Units And DLSS Manufacturing overhead 267.000 $ 60.00 Selling Expense 81,000 $ 30.00 Administrative 66,000 $ 5.00 1.25 90,000 90,000 0 45,000 0 60,000 Operating Income 42,000 Actual Units 1100 $s Sales$ 654,000 DLS $ 70.00 per unit Direct materials 169,000 Direct labor 71,000 Manufacturing overhead 250,000 Selling Expense 79,000 Administrative 63,000 Operating Income 22,000 A. Prepare flexible budget analysis with 5 valued columns of Base (Plan or Budget) Volume variance Flexible budget Spending variance Actual