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
 Staff
 Management

Click to edit the document details