A B E F G H J 1 ACCTG 231 EXCEL PROBLEM 2 Fall 2022 2 3 Number of Units sold 10,000 PER 4 TOTAL UNIT PERCENTAGE OF SALES 5 Q1 Sales $ 350,000 6 Variable Expenses $ 245,000 7 Contribution Margin $ 105,000 8 Fixed Expenses $ 58,502 9 Net Operating Income $ 46,498 10 11 12 Q2 & Q3 Scenario #1 Scenario #2 13 Sales 14 Variable Expenses 15 Contribution Margin 16 Fixed Expenses 17 Net Operating Income 18 19 20 Q4 21 Units Sold Case 1 Case 2 20,900 22 23 Sales $ 331,200 24 Variable expenses 188,100 25 Contribution margin 26 Fixed expenses 161,000 27 Net operating income (loss) $ 26,200 $ 202,600 28 29 Contribution margin per unit $ 13 14 30 31 32 33 K L Insert the last 5 digits of your student number in the yellow highlighted box (cell E8). M