Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started