Question: Starting with the finished version of the file for Example 9.3, change the fixed cost in cell B5 to $4000. Then get back into PrecisionTrees

Starting with the finished version of the file for Example 9.3, change the fixed cost in cell B5 to $4000. Then get back into PrecisionTree’s One-Way Sensitivity Analysis dialog box and add three more inputs. (These will be in addition to the two inputs already there, cells B9 and B5.) The first should be the unit margin in cell B6, varied from $15 to $21 in increments of $1, the second should be the sales volume from a good market in cell C9, varied from 400 to 700 in increments of 50, and the third should be the probability of a good prediction, given a good market, in cell B14, varied from 0.7 to 0.9 in increments of 0.05. Make sure the analysis type is one-way, all five of the inputs are checked, and the starting node is “Entire Model.” In the “Include Results” section, check the Strategy Region, Tornado Graph, and Spider Graph options, and then run the analysis. Interpret the resulting outputs. Specifically, what do the tornado and spider graphs indicate?

Step by Step Solution

3.48 Rating (168 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

The tornado graph indicates how the various inputs affect the decision maker s expe... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Excel file Icon

1497_60473a67e8245_837914.xlsx

300 KBs Excel File

Students Have Also Explored These Related Practical Management Science Questions!