Answer the questions given and compete the Excel
- The case states that the clinic completes 5,283 operations per year. Given that 22-percent of initial callers are screened out by the PSRs who take the call, 28-percent of those accepted by ClearEyes do not return for an intake appointment, and 34.4-percent of those who completed intake do not return for their scheduled surgery, how many initial inquiries are received each year? [Hint: Fill in the yellow-shaded cells on Sheet 3 of the ClearEyes spreadsheet.] 2. By what percentage would patient volume increase if ClearEyes reduced by 50-percent the percentage of patients who complete intake but fail to show up for surgery? [Hint: Fill in the yellow-shaded cells on Sheet 4 of the ClearEyes spreadsheet.] 3. Calculate capacity utilizations for each category of staff, and for intake, surgical, and examination rooms assuming the increase in patient yield described in question 13. [Hint: Fill in the yellow-shaded cells on Sheet 5 of the ClearEyes spreadsheet.] 4. Calculate capacity utilizations for each category of staff, and for intake, surgical, and examination rooms assuming the increase in patient yield described in question 13 and one additional operating room, one more technician, and one part-time (30%) staff surgeon. [Hint: Fill in the yellow-shaded cells on Sheet 6 of the ClearEyes spreadsheet.] 5. How much would pretax profit change if the increase in yield described in question 13 were accomplished? Assume that Direct Variable Cost per Procedure, Cleaning, and Maintenance, Legal, and Miscellaneous expenses increase proportionally with patient volume, a part-time (30-percent) staff surgeon is hired with costs proportional to the current staff surgeon, and a depreciation expense of 15-percent of the cost of ten new waiting-room chairs ($1,100 each) and 15-percent of the cost of one new surgical room ($93,000). [Hint: Fill in the yellow-shaded cells on Sheet 7 of the ClearEyes spreadsheet.]
Sample Solution
