This preview shows pages 1–2. Sign up to view the full content.
This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: Each book they sell (new or used), they earn a profit of $50. If they run out of books, students will buy their books elsewhere. Excess books they can send back to the publisher for a restocking cost of $15 per book. The demand for books in the spring is normally distributed with a mean of 250 and a standard deviation of 15. The @RISK simulation is shown below. What formulas would be used in each of the following cells in this simulation? B10: A14: D14: H14: Solution: 1. Only b is true. a. We use RiskSimTable when using @RISK to compare different values of the decision variable and their impact on the output variable. b. True c. Tornado Graph show the impact on the output variable not decision variable. 2. Simulation Question B10: =RiskSimtable(E8:E11) A14: =ROUND(RiskTriang(A5,B5,C5),0) D14: =MIN(B14:C14) or =IF(B14<C14,B14,C14) H14: =RISKOutput()+E14 G14...
View Full Document
This note was uploaded on 01/31/2011 for the course MGMT 306 taught by Professor Staff during the Fall '08 term at Purdue University-West Lafayette.
- Fall '08