Develop and analyze a simulation model for Koehler Vision Associates (KVA) in Problem 13 of Chapter 11 (LISTED BELOW) with the following assumptions. Assume that the demand is uniform between 110 and 160 per week and that anywhere between 10% and 20% of prospective patients fail to show up or cancel their examination at the last minute. Determine the distribution of net profit (revenue less overbooking costs) and number overbooked for scheduling 133, 140, or 150 patients.

The wording in problem 23 may be misleading. When it asks "...for scheduling 133, 140, or 150 patients", it is not referring to the actual number of reservations made, but rather to changing the values of the reservation limit and then running separate simulations with each of those values of reservation limit. You might be tempted to use a data table, but that would give the results of a single trial at each of those values, instead of the results of 2,500 trials. There is a way to automate this "parameter analysis" but that is beyond the expectations of this problem and is not supported in the student version of the software.

Problem 13 of Chapter 11: Koehler Vision Associates (KVA) specializes in laser-assisted corrective eye surgery. Prospective patients make appointments for prescreening examinations to determine their candidacy for the surgery: if they qualify, a $250 charge is applied as a deposit for the actual procedure. The weekly demand is 150, and about 12% of prospective patients fail to show up or cancel their examination at the last minute. Patients that do not show up are refunded the prescreening fee less a $25 processing fee. KVA can handle 125 patients per week and is considering overbooking its appointments to reduce the lost revenue associated with cancellations. However, any patient that is overbooked may spread unfavorable comments about the company; thus, the overbooking cost is estimated to be $125. Develop a spreadsheet model for calculating net revenue. Find the net revenue and number overbooked if 140 through 150 appointments are taken.