This preview shows pages 1–3. 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: maximize expected profit, how many reservations for the flight should Deleast book? Hint : The function RISKBINOMIAL can be used to formulate the number who show up. Question 1 (2 points): Write down your formula for cell B17. Question 2 (2 points): Complete the following formula for cell B22: =RiskDiscrete( , ) Question 3 (2 points): Write down your formula for cell C22. Question 4 (2 points): Write down your formula for cell D22. Question 5 (2 points): What is the best # of reservations among the six given alternatives? Solution to Quiz 4 Question 1: =RiskSimtable(B19:G19) Question 2: =RiskDiscrete(B7:F7,B8:F8) Question 3: =RiskBinomial(B17,B15) Question 4: =MIN(C22,B4) Question 5: 104...
View Full Document
This note was uploaded on 01/17/2012 for the course MGMT 306 taught by Professor Staff during the Spring '08 term at Purdue.
- Spring '08