Question: 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

Please help solve both part 1 and 2 in excel. Please help solve both part 1 and 2 in excel.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 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? B C price demand unit cost fixed cost revenue variable cost profit D $ 4.00 29000 $ 0.45 $ 45,000.00 $ 116,000.00 $ 13,050.00 $ 57,950.00 E 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 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? B C price demand unit cost fixed cost revenue variable cost profit D $ 4.00 29000 $ 0.45 $ 45,000.00 $ 116,000.00 $ 13,050.00 $ 57,950.00 E

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!