Answered step by step
Verified Expert Solution
Question
1 Approved Answer
a) Use the scenario manager to create the following two scenarios: (10 points) Scenario Name Changing Cells Standard Premium Total 195 175 7 8 Exper
a) Use the scenario manager to create the following two scenarios: (10 points) Scenario Name Changing Cells Standard Premium Total 195 175 7 8 Exper 9 Variat 10 Units 11 Varia 12 Total 13 Fixed 14 Total 15 Expen 16 Total 17 18 Profit 19 Total 20 21 Gros: 22 23 Break 24 Price 25 Cost 26 Units 27 Gross 28 29 30 31 32 33 34 35 36 37 38 Variable_Cost (B11) Fixed Cost (B14) 300,000 350,000 b) Make sure to keep the Standard scenario visible (show Standard scenario). (2 points) c) Create a Scenario Summary by showing B24:B27 as the result cells for each scenario. Move is after worksheet Q2. 16 noints) E SE A1 x fx Gabby Mobile - Bluetooth Hdphone A B C Gabby Mobile - Bluetooth Headphone $ $ 10,500 209.00 2,194,500.00 $ $ 10,500 179.00 1,879,500.00 1 2 3 Sales 4 Units Sold 5 Price Per Unit 6 Total Sales 7 8 Expenses 9 Variable Expenses 10 Units Manufactured 11 Variable Cost per Unit 12 Total Variable Costs 13 Fixed Costs 14 Total Fixed Cost 15 Expenses - Total 16 Total Expense Per Unit Sold 17 18 Profit 19 Total Sales 20 Total Expenses 21 Gross Profit 22 23 Break-even Analysis 24 Price per Unit 25 Cost Per Unit 26 Units Sold 27 Gross Profit 28 on 260,000.00 2,139,500.00 203.76 $ $ $ $ 2,194,500.00 2,139,500.00 55,000.00 S $ 209.00 203.76 10,500 55,000.00 ST 31 32 33 34 35 36 37 38
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started