Please answer with excel screenshots with formulas. Most of the problem is already finished, just need help with the table on the left.

A B C E F G H J K L M N P Q 1 Koehler Vision Associates (KVA) specializes in laser-assisted corrective eye surgery. Prospective patients make appointments for prescreening exams to determine their candidacy for the surgery: if 2 they qualify, a $250 charge is applied as a deposit for the actual procedure. The weekly demand is 180, and about 15% of prospective patients fail to show up or cancel their exam at the last minute. Patients that do not show up are refunded the prescreening fee less a $30 processing fee. KVA can handle 150 patients per week and is considering overbooking its appointments to reduce the lost 4 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 $150. Develop a 5 spreadsheet model for calculating net revenue. 8 9 Koehler Vision Associates 10 11 12 Appointments Taken 180 patients per week 13 Demand 180 14 No Show Rate 0.15 15 16 Capacity 150 patients per week 17 Revenue # Overbooked 18 Pre-screen Revenue s 250.00 Appointments Taken |$ 37,860.00 3 19 Nonrefundable processing fee S 30.00 140 20 Overbooking Cost $ 150.00 141 21 142 22 SCHEDULED 180 143 23 SHOW UP 153 144 24 CANCELLATIONS 27 145 25 PRE-SCREENED 150 146 26 OVERBOOKED 3 147 27 148 28 REVENUES $ 38,310.00 149 29 COSTS $ 450.00 150 30 NET REVENUE $ 37,860.00 31