Create the required table in Excel and use Excel formulas to complete

. 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 three-level 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 $200 for each patient that comes in for the new service. For the base level (most likely) revenue forecast, assume 1,000 potential procedures per year. It's possible the new service will be a big hit! For the best-case revenue forecast, assume an increase in volume (over the base level) of 250 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 500 procedures annually.