Number of appointments accepted and patient demand

Assignment Help Financial Management

Reference no: EM132012130

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 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 exam 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.

a. Find the net revenue and number overbooked if 140 through 150 appointments are taken.

b. Use data tables to study how revenue is affected by changes in the number of appointments accepted and patient demand.

c. Develop and analyze a simulation model 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 exam at the last minute. Determine the distribution of net profit (revenue less overbooking costs) and number overbooked for scheduling 133, 140, or 150 patients.

Reference no: EM132012130

Questions Cloud

What percentage of drivers have a reaction time : What percentage of drivers have a reaction time more than 1.88 seconds? % What percentage of drivers have a reaction time less than 1.46 seconds? %

Evaluating the effect of a new growth hormone : A researcher is evaluating the effect of a new growth hormone. It is known that regular adult rats weigh an average of 400 grams, with a standard deviation.

What is the payback period for each project : What is the payback period for each project?

Describe the certification requirements : Identify the governmental agency or authority responsible for regulation of the safety of the airline's flight operations in its home nation.

Number of appointments accepted and patient demand : Use data tables to study how revenue is affected by changes in the number of appointments accepted and patient demand.

Compute the external rate of return of the best project : Compute the External Rate of Return (ERR) of the BEST project

How many different ways can this be done : If a student must take one of each, how many different ways can this be done?

Contrast rules-based versus principles-based accounting : In a professional career, one may be called upon to conduct research and deliver findings in professional settings. As discussed in the text, the SEC.

Find the probability of selecting two red cards : Two cards are drawn from a deck of cards without replacement of the first one. Find the probability of selecting two red cards.

User Account

All Pages