Question: Create the required table in Excel and use Excel formulas to complete this GHA. The idea of this assignment is that since we cannot tell
Create the required table in Excel and use Excel formulas to complete this GHA. The idea of this assignment is that since we cannot tell the future we often make assumptions of what is likely to happen. When we make assumptions, we tend to have a realistic idea of what could happen, a sense of a 'worse case' scenario, and a sense of a 'best case' scenario. Looking at these three options helps us anticipate future need and plan accordingly. A doctor's office is thinking about adding a new service line to their practice. They ask the practice manager to prepare a threelevel volume forecast as a first step in their decision making. Determine the base level revenue, best case revenue, and worse case revenue. You might find it helpful to use this format: Best: best volume per year x rate per procedure best revenue per year Base: base volume per year x rate per procedure base revenue per year Worse: worse volume per year x rate per procedure worse revenue per year Assumptions: The practice will earn $ for each patient that comes in for the new service. For the base level most likely revenue forecast, assume potential procedures per year. It's possible the new service will be a big hit! For the bestcase revenue forecast, assume an increase in volume over the base level of procedures annually. It's possible the practice might encounter some problems with insurance coverage. For the worse case revenue forecast, assume a decrease in volume below the base level of procedures annually.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
