The bottom is the task (A.). It is essentially just 1 table and those are the columns that need to be filled out. if possible show work

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 94,000 S 70.00 0 0 BASE CASE Static Budget=Plan $ 70.00 1200 per unit 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 DL$s 0 0 Fxd & 90,000 90,000 45,000 60,000 Manufacturing overhead 267 000 $ 60.00 Selling Expense 81,000 $ 30.00 Administrative 66,000 $ 5.00 1.26 0 0 Operating Income 42.000 Actual Units 1100 $8 Sales$ 654,000 DL$ $ 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