Answer A-H on the right hand side and input answers in excel sheet.

O AutoSave OFF THE Corrected ACCT 301 Course Project Worksheet For Deliverable #2 Q Q V Home Insert Draw Page Layout Formulas Data Review View Tell me what you want to do Share Comments X Calibri (Body) 11 v A A Conditional Formatting Format as Table v Paste BIUV A Number Cell Styles v Cells Editing Ideas Sensitivity P20 X v fx B C D E F G H K M N O Q 2 Conduct Variance Analysis Master Budget Actual Flex Budget Variances (flex. vs. actual) (A) Verify that the net income is the same as the Op Sales : February per Unit February per Unit February per Unit Total per Unit (B) Input the flex budget sales units, the per unit p (C) Input the flex budget production cost per unit 6 Units 42,500 $ 9.50 35,000 9.85 (B) (F) the total flex variable production costs. Total Sales Revenue S 403,750 $ 344,750 (B) (D) Input the flex budget variable selling costs per (E) Input the flex budget fixed selling and administ 9 Variable Costs: (F) Calculate the variances between the actual and 10 Production S 235,875 $ 5.55 190,750 $ 5.45 (C) S (F) (G) Input the spending variance 11 Selling 4,250 0.10 3,850 0.11 (D) ( F ) (H) Calculate the volume variance using the budget 12 Total Variable Costs 240,125 $ 5.65 $ 194,600 $ 5.56 $ $ $ $ 13 14 Contribution Margin 163,625 $ 3.85 $ 150,150 $ 4.29 S S 15 16 Fixed Costs: 17 Selling 52,500 60,000 52,500 (E) (F) 18 Administration 63,000 58,500 3,000 (E) (F) 19 Total Fixed Costs 115,500 118,500 115,500 20 21 Net Income $ 48,125 (A) $ 31,650 $ (115,500) $ ( F) 22 23 Master Budget vs. Actual Net Income Variance $ (16,475) 24 What is the volume variance (G) 25 What is the spending rate variance $ (H) 26 S 27 Operating Budget Cash Budget Variances Decisions Capital +