Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

International Financial Management

Authors: Cheol Eun

9th Edition

1260788865, 9781260788860

More Books

Students also viewed these Finance questions

Question

=+What do you want them to think?

Answered: 1 week ago

Question

=+Why should they buy this product/service?

Answered: 1 week ago