
226 Practical Spreadsheet Risk Modeling for Management
7.5 Optimization with Simulation
When demand for seats is uncertain (as in our original airline pricing
model), the optimal deterministic strategy of mean control is no longer best.
If 30 seats are reserved for Y class customers, there are times that seats will
go unlled that could have been sold to a Q class customer (an opportunity
cost), and there are times when there may have been enough Y class demand
to ll some of the Q class seats with a higher paying customer. Given the
large difference in prices for the two classes, it seems reasonable that more
seats should be reserved ...