Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Based on the modeling case, please conduct the decision analysis on a selected variable. You need to construct a payoff matrix and use non-probabilistic and
Based on the modeling case, please conduct the decision analysis on a selected variable. You need to construct a payoff matrix and use non-probabilistic and probabilistic methods on it. Draw at least one decision tree to summarize the results.
Please see attached.
8/4/2023 PARAMETERS Percent Allocation 5% 10% 15% 20% Price of Product $150.00 Cost of Product $25.00 Next Day Recall Index 1.3 1.4 1.2 Overhead Rate 0.15 Market Size 21 2500 Cost of Salesforce 8000 8000 8000 8000 Advertisement Budget $100,000 Ad Expenditure $5,000 $10,000 $15,000 $20,000 OUTPUTS Max Profit $489,001 Base Case $489,001 CALCULATIONS Percent Allocation 5% 10% 15% 20% Next Day Recall Index 1.3 1.4 1.2 Units Sold 1054 3052 3889 3780 Revenue $158,048.78 $595,185.39 $816,743.43 $680,400.00 Cost of Product $26,341.46 $76,305.82 $97,231.36 $94,500.00 Gross Margin $131,707.32 $518,879.57 $719,512.07 $585,900.00 Sales Expense $8,000 $8,000 $8,000 $8,000 Advertising $100,000.00 $100,000.00 $100,000.00 $100,000.00 Overhead $23,707.32 $89,277.81 $122,511.51 $102,060.00 Total Fixed Cost $131,707 $197,278 $230,512 $210,060 Profit SO $321,602 $489,001 $375,840Step 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