Develop a spreadsheet model for calculating net revenue, and use data tables to study how revenue is affected by changes in the number of appointments accepted and patient demand.
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, and if they qualify, the $300 charge is applied as a deposit for the actual procedure. The weekly demand is 175, and about 15% of prospective patients fail to show […]
