One-Parameter Sensitivity Analysis (Tab: LP)
Use Data Table
A) In the LunaPharm model, vary the Belex Sales reps from 0 to 200 with step size of 1. Make a table that shows the Change from Base.
B) Repeat A) with step size of 100.
C) Make a single scatter chart that shows the results from A) and B) together. What do you lose from having a big increment?
D) Using the same input values as in part A), make a single scatter chart that shows Total Net Profit, Belex Sales Revenue, and Belex Net Profit.
E) Suppose you wanted to change the Sales Rep Cost to $70,000 and Belex Contribution Margin to 67%. Briefly describe the actions required to obtain the results from parts A) – D) above. (Don’t actually do it, just describe what to do.)
The input model is below :
Download Attachments:
- l.JPG
Skip QuestionShow 9 CommentsReport Issue