create spreadsheet.

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