Question: Please solve this using excel scenario manager Consider the Part 2 Lemonade Stand data of the HM3-Excel-Data spreadsheet. 1. Use the scenario manager to display

Please solve this using excel scenario manager

Consider the Part 2 Lemonade Stand data of the HM3-Excel-Data spreadsheet. 1. Use the scenario manager to display a report summarizing profit for the following scenarios: SCENARIO PRICE UNIT COST FIXED COST HIGH COST/HIGH PRICE $5.00 $1.00 $65,000.00 MEDIUM COST/MEDIUM PRICE $4.00 $0.75 $45,000.00 LOW COST/LOW PRICE $2.50 $0.40 $25,000.00 2. For a given price, how many glasses of lemonade does a lemonade store needs to sell per year to break-even?

price	$ 4.00
demand	29000
unit cost	$ 0.45
fixed cost	$ 45,000.00
revenue	$116,000.00
variable cost	$ 13,050.00
profit	$ 57,950.00

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Consider the Part 2 Lemonade Stand data of the HM3-Excel-Data spreadsheet. 1. Use the scenario manager to display a report summarizing profit for the following scenarios: SCENARIO PRICE UNIT COST...

PLEASE HELP ME!! THIS IS AN EMERGENCY!!! CAN YOU PLEASE DO THIS AS SOON AS HUMANLY POSSIBLE.. New Perspectives Excel 2019 | Module 8: End of Module Project 2 Expo Events EXPLORE BUSINESS OPTIONS WITH...

New Perspectives Excel 2019 | Module 8: SAM Project 1a Cairo ConsultingEXPLORE BUSINESS OPTIONS WITH WHAT-IF TOOLS GETTING STARTED Open the file NP_EX19_8a_ FirstLastName _1.xlsx , available for...

Please help solve both part 1 and 2 in excel. Part 2: Consider the Part 2 Lemonade Stand data of the HM3-Excel-Data spreadsheet. 1. Use the scenario manager to display a report summarizing profit for...

the user manually inputs data or the program accesses data from a file in the system. The program runs the data through its algorithms and displays output formatted as information; the manager uses...

1. Fernanda Oliveira is a financial analyst for Expo Events, a full-service trade show and exhibition company headquartered in Orlando, Florida. Fernanda created a workbook containing details about...

EXCEL SCENERIO MANAGER HELP.. Create a scenario manager for the following image USE IMAGE #2 FOR LEMONADE EXAMPLE fx A B D E F H Q1 For the lemonade stand example from last lecture, use the Scenario...

I need help writing therecommendation to the CFO (not the executive summary). I have already completed the attached excel workbook. Introduction: You have recently been hired as a Financial Analyst...

Convert the Fischer projection formula for d-threose to three-dimensional representations.

The elements of Si, Ga, As, Ge, Al, Cd, S, and Se are all used in the manufacture of various semiconductor devices. Write the expected electron configurations for these atoms.

Appropriate control over obsolete materials requires that they be Retained within the regular storage area. Carried at cost in the accounting records until the actual disposition takes place....

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...