Koehler Vision Associates (KVA) specializes in laser-assisted corrective eye surgery. Prospective patients make appointments for prescreening examination to determine their candidacy for the surgery:...

Koehler Vision Associates (KVA) specializes in laser-assisted corrective eye surgery. Prospective patients make appointments for prescreening examination 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

Aug 25, 2022

SOLUTION.PDF

Sun	Mon	Tue	Wed	Thu	Fri	Sat
30	31	1	2	3	4	5
6	7	8	9	10	11	12
13	14	15	16	17	18	19
20	21	22	23	24	25	26
27	28	29	30	1	2	3

Koehler Vision Associates (KVA) specializes in laser-assisted corrective eye surgery. Prospective patients make appointments for prescreening examination to determine their candidacy for the surgery:...

Get Answer To This Question

Related Questions & Answers

Submit New Assignment