File Home Insert Formulas Data Review View Automate Help Open in Desktop App Tell me what you want to do Calibri Light v 11 EDO A .. General 515 fo 100 F G H I 3 B D E 3 4 Required: Part A (8 marks)- Create a Static Budget Report Variance Analysis, indicating whether variances are favorable (F) or unfavorable (U). All variance amounts should be shown as positive numbers. 5 Static Budget Actual Variance Favorable or 6 Amount Results Amount Unfavorable 7 Sales in Units 4,032 5,210 B Sales s 504.000 $ 625,200 9 Less: Variable Costs: 10 Cost of Goods Sold 219.000 215.000 11 Sales Commissions 65 520 87.528 12 Total Variable Costs 284,520 302,528 13 Contribution Margin 219.480 322,672 14 Less: Fixed Costs: 15 Advertising 23.000 25.000 16 Property Taxes 9,000 10.000 17 Rent $4.000 52.000 18 Salaries & Wages 112.000 101.000 19 Total Fixed Costs 198,000 188.000 20 Net Operating Income 21480 134,672 21 Discuss the variances you've identified in the statie budget report de. what are potential causes of the Case Intro Group Members Q1 Q2 Q3 04 05