i need the appointments accepted the demand from 130-190 both the rows and columns

An eye surgery clinic Vision Associates, specializes in laser-assisted corrective eye surgery. Prospective patients make appointments for prescroening exams to determine their candidacy for the surgery. If they quality, a $275 charge is applied as a deposit for their actual procedure. The weekly demand is 150 and about 12% of prospective patients tal to show up or cancel their exam at the last minute. Patients who do not show up are refunded the prescreening fee less a S21 processing fee. The eye cinic can handle 115 patents per week and is considering overbooking its appointments to reduce the lost revenue associated with cancellation. However, any patient who is overbooked may spread untavorable comments about the company, thus the overbooking cost is estimated to be $143. Develop a spreadsheet model for calculating net revenue, Use data tables to study how revenue is affected by changes in the number of appointments accepted and patient demand Click the con to view a blank Excel model Fill in all the values from the spreadsheet model for the given scenario, (Round to the nearest whole number as needed) Vision Associates 150 150 Appointments Takon per week Demand per week No Show Rate Capacity per week 12% 115 Pre-screen Fee Nonrefundable processing foo Overbooking Cost $ 275 $ 21 $ 143 Scheduled per week Number showing up per week Cancellations per week Number pre-screened Overbooked 150 132 18 115 17 B A 1 Vision Associates 2 3 Appointments taken per week 4 Demand per week 5 No show rate 6 Capacity per week 7 8 Pre-screen fee 9 Nonrefundable processing fee 10 Overbooking cost 11 12 Scheduled per werk 13 Number showing up per week 14 Cancellations per week 15 Number pre-screened 16 Overbooked 17 18 Revenue 19 Cost 20 Net revenue Overbooking Cost $ 143 150 Scheduled per week Number showing up per week Cancellations per week Number pre-screened Overbooked 132 18 115 17 Revenue Cost $ 32003 $ 2431 $ 29572 Net Revenue Fill in the two-way data table. (Round to the nearest dollar as needed.) Appointments Accepted Demand 130 140 150 160 170 180 190 130 $ 31,686 $ 31,686 $ 31,686 $31,686 $ 31,686 $ 31,686 $ 31,686 140 $ 31686 $ An eye surgery clinic Vision Associates, specializes in laser-assisted corrective eye surgery. Prospective patients make appointments for prescroening exams to determine their candidacy for the surgery. If they quality, a $275 charge is applied as a deposit for their actual procedure. The weekly demand is 150 and about 12% of prospective patients tal to show up or cancel their exam at the last minute. Patients who do not show up are refunded the prescreening fee less a S21 processing fee. The eye cinic can handle 115 patents per week and is considering overbooking its appointments to reduce the lost revenue associated with cancellation. However, any patient who is overbooked may spread untavorable comments about the company, thus the overbooking cost is estimated to be $143. Develop a spreadsheet model for calculating net revenue, Use data tables to study how revenue is affected by changes in the number of appointments accepted and patient demand Click the con to view a blank Excel model Fill in all the values from the spreadsheet model for the given scenario, (Round to the nearest whole number as needed) Vision Associates 150 150 Appointments Takon per week Demand per week No Show Rate Capacity per week 12% 115 Pre-screen Fee Nonrefundable processing foo Overbooking Cost $ 275 $ 21 $ 143 Scheduled per week Number showing up per week Cancellations per week Number pre-screened Overbooked 150 132 18 115 17 B A 1 Vision Associates 2 3 Appointments taken per week 4 Demand per week 5 No show rate 6 Capacity per week 7 8 Pre-screen fee 9 Nonrefundable processing fee 10 Overbooking cost 11 12 Scheduled per werk 13 Number showing up per week 14 Cancellations per week 15 Number pre-screened 16 Overbooked 17 18 Revenue 19 Cost 20 Net revenue Overbooking Cost $ 143 150 Scheduled per week Number showing up per week Cancellations per week Number pre-screened Overbooked 132 18 115 17 Revenue Cost $ 32003 $ 2431 $ 29572 Net Revenue Fill in the two-way data table. (Round to the nearest dollar as needed.) Appointments Accepted Demand 130 140 150 160 170 180 190 130 $ 31,686 $ 31,686 $ 31,686 $31,686 $ 31,686 $ 31,686 $ 31,686 140 $ 31686 $