OSCM 230 Homework 9 Solutions H O M E W O R K # 9 S O L U T I O N S S I M U L A T I O N M O D E L I N G Problem 10-30 See file P10-30 CB.XLS for the simulation model and calculations using Crystal Ball. Define cell B11 as the Forecast cell. Based on 5,000 trials, average profit per flight is $195. To evaluate the profitability of overbooking 0,1,2,3,4,5 passengers, we can use the “Decision Tables” under Run-> Tools. Follow the following steps: 1. Run-> Reset Simulation 2. Define Cell F28 as Decision Cell: Define -> Define Decisions… a. Set Bounds: Low: 0, High:5 b. Set Type: select Discrete 3. Run -> Tools-> Decision Table… Based on 5000 trials overbooking by zero passengers seems to result in the highest average profit per flight (see sheet Decision Table ) Problem 10-31*. See file P10-31 CB.XLS. This is a somewhat challenging problem since we must track the
This is the end of the preview. Sign up
access the rest of the document.