Calculate the net revenue and develop the spreadsheet model

Reference no: EM131439115

Question: 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. Find the net revenue and number overbooked if 140 through 150 appointments are taken.

Reference no: EM131439115

Questions Cloud

Discuss innovative idea you can dream up for a new business : BUS-490: Discuss the most innovative idea you can dream up for a new business. Explain why you think it would be successful.

How was captain cook a symbol of his age : How was Captain Cook a symbol of his age? Describe the worldview he represented and analyze how it contributed to the impact he, and other explorers, had on the societies they encountered

How many stages are there in adult development : How many stages are there in adult development? Discuss your answer with examples.

Define qualitative research and quantitative research : RES-811: Define qualitative research and quantitative research. Is quantitative research more valid than qualitative research? Why or why not?

Calculate the net revenue and develop the spreadsheet model : 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 deposi..

What is racism : What is racism? In what ways does racism affect diversity - Throughout most of U.S. history, in most locations, what race has been in the majority? What is the common ancestral background of most members of this group?

What types of resources would you use in helping a child : What types of resources would you use in helping a child or adolescent deal with the questions and the pain associated with the loss of a loved one? Research and post a minimum of three websites or other resources that might be beneficial in helpi..

What powers did the constitution leave to the states : Why were the authors of the United States Constitution unwilling to create a strong central government? What powers did the constitution leave to the states

Describe the authors opinion : 1. Describe the authors opinion. 2. Describe whether or not you agree with the author that the U.S. Dollar will remain the global currency?

User Account

All Pages