Last five digets are 84345

Home Insert Draw Page Layout Formulas Data Review View Tell me Calibri (Body) ~ A A Wrap Text General MISS Paste B TV- Merge & Center Conditional Formatting D27 A D F C EXCEL PROBLEM 1 SPRING 2021 1 ACCTG 231 2 Number of Units sold 10,000 TOTAL $ $ $ Sales 6 Variable Expenses Contribution Margin Bed Expenses 9 Net Operating income 10 PER PERCENTAGE UNIT OF SALES 250,000.00 100,000.00 150,000.00 Insert the last 5 digits of your student number 150,000.00 3 Scenario Mi Scenario #2 Scenario 32 11 14 15 16 17 18 19 20 21 Sales Variable Expenses Contribution Margie Fixed Expenses Net Operating Income 23 24 25 22 30 31 32 H the spreadsheet putes the answers changes the number of Units Sola correctly. REQUIREMENTS 1. 2. After inserting the last 5 digits of your student number into the yellow cell (D8) for total fixed costs, enter formulas in the gray cells (E5, E6 and E7) to compute the per unit amounts for Sales, Variable Expenses, and contribution Margin. (1 POINT) Insert formulas in the gray cells (G5, G6, and G7) to compute the percentage of sales for Sales, Variable Expenses, and contribution Margin. (1 POINT) Scenario #1 Insert formulas in the gray cells (G12 through G16) to prepare an income statement, assuming sales increased by 1,000 units. (1 POINT) 3. 4. Scenario #2 Insert formulas in the gray cells (112 through 116) to prepare an income statement, assuming advertising increased by $10,000, and unit sales increased by 20%. (1 POINT) Scenario #3 Insert formulas in the gray cells (K12 through Kl6) to prepare an income statement, assuming variable expenses increased by $5.00 per unit and unit sales increased by 15% (1 POINT) 5. 6. When your assignment is being graded, the grader will change the number of units sold (cell B3) from 10,000 to 20,000 to verify that the formulas you entered will correctly compute the required amounts with this change in data. (5 POINTS) Home Insert Draw Page Layout Formulas Data Review View Tell me Calibri (Body) ~ A A Wrap Text General MISS Paste B TV- Merge & Center Conditional Formatting D27 A D F C EXCEL PROBLEM 1 SPRING 2021 1 ACCTG 231 2 Number of Units sold 10,000 TOTAL $ $ $ Sales 6 Variable Expenses Contribution Margin Bed Expenses 9 Net Operating income 10 PER PERCENTAGE UNIT OF SALES 250,000.00 100,000.00 150,000.00 Insert the last 5 digits of your student number 150,000.00 3 Scenario Mi Scenario #2 Scenario 32 11 14 15 16 17 18 19 20 21 Sales Variable Expenses Contribution Margie Fixed Expenses Net Operating Income 23 24 25 22 30 31 32 H the spreadsheet putes the answers changes the number of Units Sola correctly. REQUIREMENTS 1. 2. After inserting the last 5 digits of your student number into the yellow cell (D8) for total fixed costs, enter formulas in the gray cells (E5, E6 and E7) to compute the per unit amounts for Sales, Variable Expenses, and contribution Margin. (1 POINT) Insert formulas in the gray cells (G5, G6, and G7) to compute the percentage of sales for Sales, Variable Expenses, and contribution Margin. (1 POINT) Scenario #1 Insert formulas in the gray cells (G12 through G16) to prepare an income statement, assuming sales increased by 1,000 units. (1 POINT) 3. 4. Scenario #2 Insert formulas in the gray cells (112 through 116) to prepare an income statement, assuming advertising increased by $10,000, and unit sales increased by 20%. (1 POINT) Scenario #3 Insert formulas in the gray cells (K12 through Kl6) to prepare an income statement, assuming variable expenses increased by $5.00 per unit and unit sales increased by 15% (1 POINT) 5. 6. When your assignment is being graded, the grader will change the number of units sold (cell B3) from 10,000 to 20,000 to verify that the formulas you entered will correctly compute the required amounts with this change in data. (5 POINTS)