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 Manager to display a report summarizing profit for the following scenarios: Scenario High cost/ High Price Medium cost / Medium Price Low cost / Low Price Price $ $ $ Unit Cost 5.00 $ 4.00 $ 2.50 $ Fixed Cost 1.00 $ 65,000.00 0.75$ 45,000.00 0.40 $ 25,000.00 I am thinking of startign a store in the local mall to sell gourmet lemonade. Before opening the store, i'm curious about how my profit, revenue, and variable costs will depend on the price I charge and the unit cost. price demand unit_cost fixed cost revenue variable_cost profit $ 1.00 56000 $ 0.45 $ 45,000.00 $ 56,000.00 $ 25,200.00 $ (14,200.00) Question 1: I want to know how changes in price (e.g. from $1.00 to $4.00 in $0.25 increments) affect annual profict, revenue, and variable cost ce $ $ $ $ $ $ $ $ $ $ $ $ $ profit revenue variable_cost $ (14,200.00) $ 56,000.00 $ 25,200.00 1.00 $ (14,200.00) $ 56,000.00 $ 25,200.00 1.25$ (2,000.00) $ 67,187.50 $ 24,187.50 1.50$ 9,075.00$ 77,250.00 $ 23,175.00 1.75 $ 19,025.00 $ 86,187.50 $ 22,162.50 automatically populate these with what if data 2.00 $ 27,850.00 $ 94,000.00 $ 21,150.00 2.25 $ 35,550.00 $ 100,687.50 $ 20,137.50 2.50 $ 42,125.00 $ 106,250.00 $ 19,125.00 2.75 $ 47,575.00 $ 110,687.50 $ 18,112.50 3.00 $ 51,900.00 $ 114,000.00 $ 17,100.00 3.25 $ 55,100.00 $ 116,187.50 $ 16,087.50 3.50 $ 57,175.00 $ 117,250.00 $ 15,075.00 3.75 $ 58,125.00 $ 117,187.50 $ 14,062.50 4.00 $ 57,950.00 $ 116,000.00 $ 13,050.00 ulu fx A B D E F H Q1 For the lemonade stand example from last lecture, use the Scenario Manager to display a report summarizing profit for the following scenarios: Scenario High cost/ High Price Medium cost / Medium Price Low cost / Low Price Price $ $ $ Unit Cost 5.00 $ 4.00 $ 2.50 $ Fixed Cost 1.00 $ 65,000.00 0.75$ 45,000.00 0.40 $ 25,000.00 I am thinking of startign a store in the local mall to sell gourmet lemonade. Before opening the store, i'm curious about how my profit, revenue, and variable costs will depend on the price I charge and the unit cost. price demand unit_cost fixed cost revenue variable_cost profit $ 1.00 56000 $ 0.45 $ 45,000.00 $ 56,000.00 $ 25,200.00 $ (14,200.00) Question 1: I want to know how changes in price (e.g. from $1.00 to $4.00 in $0.25 increments) affect annual profict, revenue, and variable cost ce $ $ $ $ $ $ $ $ $ $ $ $ $ profit revenue variable_cost $ (14,200.00) $ 56,000.00 $ 25,200.00 1.00 $ (14,200.00) $ 56,000.00 $ 25,200.00 1.25$ (2,000.00) $ 67,187.50 $ 24,187.50 1.50$ 9,075.00$ 77,250.00 $ 23,175.00 1.75 $ 19,025.00 $ 86,187.50 $ 22,162.50 automatically populate these with what if data 2.00 $ 27,850.00 $ 94,000.00 $ 21,150.00 2.25 $ 35,550.00 $ 100,687.50 $ 20,137.50 2.50 $ 42,125.00 $ 106,250.00 $ 19,125.00 2.75 $ 47,575.00 $ 110,687.50 $ 18,112.50 3.00 $ 51,900.00 $ 114,000.00 $ 17,100.00 3.25 $ 55,100.00 $ 116,187.50 $ 16,087.50 3.50 $ 57,175.00 $ 117,250.00 $ 15,075.00 3.75 $ 58,125.00 $ 117,187.50 $ 14,062.50 4.00 $ 57,950.00 $ 116,000.00 $ 13,050.00 ulu
