Answered step by step
Verified Expert Solution
Question
1 Approved Answer
An eye surgery clinic, Vision Associates, specializes in laser-assisted corrective eye surgery. Prospective patients make appointments for prescreening exams to determine their candidacy for surgery.
An eye surgery clinic, Vision Associates, specializes in laser-assisted corrective eye surgery. Prospective patients make appointments for prescreening exams to determine their candidacy for surgery. If they qualify, a $275 charge is applied as a deposit for their actual procedure. The weekly demand is 150, and about 12% of prospective patients fail to show up or cancel their exam last minute. Patients who do not show up are refunded the prescreening fee less a $27 processing fee. The eye clinic can handle 125 patients per week and is considering overbooking its appointments to reduce the lost revenue associated with cancellations. However, any patient who is overbooked may spread unfavorable comments about the company; thus, the overbooking estimated to be $137. 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 pa demand. Click the icon to view a blank Excel model. Overbooked Revenue 7 $34861 Cost Net Revenue Fill in the two-way data table. (Round to the nearest dollar as needed.) $959 $33902 Appointments Accepted Demand 130 140 150 160 130 140 150 160 170 180 190 170 180 190 Excel Model 1 Vision Associates Appointments taken per week Demand per week 5 No show rate 6 Capacity per week 8 Pre-screen fee 9 Nonrefundable processing fee 10Overbooking cost 11 12Scheduled per week 13 Number showing up per week 14Cancellations per week 15Number pre-screened 16Overbooked 17 18 Revenue 19 Cost 20 Net revenue Print Done
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started