This
preview
has intentionally blurred sections.
Sign up to view the full version.
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
- Fall '08
- Staff
- Management, Standard Deviation, $50, $15, @Risk, RiskSimTable
-
Click to edit the document details