Prepare a Flexible Budget Conduct Variance Analysis Master Budget

(A)	Verify that the net income is the same as the Op Budget
(B)	Input the flex budget sales units and the per unit price
(C)	Input the flex budget production cost per unit and calculate
	the total flex production costs.
(D)	Input the flex budget variable selling costs per unit
(E)	Input the flex budget fixed selling and administration costs
(F)	Calculate the variances between the actual and flex budget
(G)	Input the spending variance
(H)	Calculate the volume variance using the budgetted contribution margin

Prepare a Flexible Budget Conduct Variance Analysis Master Budget February Actual February per Unit Flex Budget February per Unit Variances (flex. vs. actual) Total Sales : per Unit per Unit Units 9.50 9.85 35,000 $ 9.50 (B) $ 0.35 (F) 42,500 $ 403,750 35,000 $ 344,750 Total Sales Revenue $ $ 12,250 $ (C) $ Variable Costs: Production Selling Total Variable Costs 235,875 $ 4,038 239,913 $ 5.55 190,750 $ 5.45 0.10 3,850 0.11 5.65 $ 194,600 $ 5.56 (F) (F) (D) 0 $ $ $ $ $ Contribution Margin $ 163,838 $ 3.86 $ 150,150 $ 4.29 $ $ 9.50 $ 12,250 $ 0.35 Fixed Costs: Selling Administration 52,500 63,000 60,000 58,500 52,500 (E) 63,000 (E) 115,500 (F) (F) Total Fixed Costs 115,500 118,500 Net Income $ 48,338 (A) $ 31,650 $ (115,500) $ 12,250 (F) Master Budget vs. Actual Net Income Variance $ (16,688) What is the volume variance (G) What is the spending rate variance $ 12,250 (H) $ 12,250