2) The sales of X brand facial cream are dependent on its selling price (p). Specifically,...

Transcribed Image Text:

2) The sales of X brand facial cream are dependent on its selling price (p). Specifically, Sales equal to (1000-3p). Thus, the revenue of X facial cream is (1000-3p)* p The cost of X facial cream including 5000 fixed cost and 0.5 variable cost per unit. Use goal seek feather to find the price that make the product break even (revenue = cost) Selling Price Sales Amount Revenue Cost Difference between revenue and cost 3) David would like to calculate the sum of project 1 NPV and project 2 NPV for three different scenarios. Use Scenario Manager to compare below scenarios. Scenario 1 low interest 0.50% Scenario 2 medium intere 2.50% Scenario 3 high interest 4.50% Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Project 1 625 445 845 1234 145 478 985 325 652 NPV Project1 Project 2 124 565 894 2000 356 521 754 225 134 NPV Project2 Total NPV 2) The sales of X brand facial cream are dependent on its selling price (p). Specifically, Sales equal to (1000-3p). Thus, the revenue of X facial cream is (1000-3p)* p The cost of X facial cream including 5000 fixed cost and 0.5 variable cost per unit. Use goal seek feather to find the price that make the product break even (revenue = cost) Selling Price Sales Amount Revenue Cost Difference between revenue and cost 3) David would like to calculate the sum of project 1 NPV and project 2 NPV for three different scenarios. Use Scenario Manager to compare below scenarios. Scenario 1 low interest 0.50% Scenario 2 medium intere 2.50% Scenario 3 high interest 4.50% Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Project 1 625 445 845 1234 145 478 985 325 652 NPV Project1 Project 2 124 565 894 2000 356 521 754 225 134 NPV Project2 Total NPV