Reference no: EM131188782
Three-level Revenue Forecast
Three eye-ear-nose-and-throat physicians decide to hire an experienced audiologist in order to add a new service line to their practice. They ask the practice manager to prepare a three level colume forecast as a first step in their decision making.
Assumptions: for the base level (most likely) revenue forecast, assume $200 per procedure time 4 procedures per day times 5 days equals 20 procedures per week times 50 weeks per year equals 1,000 potential procedures per year
For the best case revenue forecast, assume an increase in volume of one procedure per day average, for an annual increase of 250 procedures (5 days per week times 50 weeks equals 250). The best case is if the practice gains a particular care contract.
For the worst case revenue forecast, assume a decrease in volume of 2 procedures per day average, for an annual decrease of 500 proocedures. The worst case is if the practice loses a major payer.
Create the required table in an Excel document and submit the assignment via the link provided below.
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.
To complete this assignment, you must calculate the revenue forecasts at each level (and show your work), but you do notneed to create the line chart shown in Figure 17-5 (p. 209). In other words, just show your calculations -- do not worryabout creating a chart/graph.
Assignment Exercise 17-2 already provides you with the facts that you need. You are given the 'base level' forecast (which would be the same as the 'basic forecast' line in Fig. 17-5). From that you can use addition and subtraction to calculate the 'high forecast' (or 'best case') and 'low forecast' (or 'worst case') revenue amounts.
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
|
What is the mass of the compound produced
: After the reaction, all of the aluminum is used and the mass of un-reacted sulfur is 0.430 g. What is the mass of the compound produced?
|
|
Explain potential areas of resistance or barriers
: Explain potential areas of resistance or barriers that will need to be overcome to implement this change. Describe how you will use technology to communicate this initiative to key stakeholders.
|
|
What is the modified internal rate of return
: A project requires a $150,000 investment today and provides cash flows of $30,000 at the end of the next 4 years, $35,000 at the end of years 5 through 9 and a final inflow of $40,000 at the end of the tenth year. The cost of capital (discount rate) ..
|
|
Work in modern america
: Write a paper showing your understanding of work in modern America. Included in this paper must be an analysis of positive and negative aspects of our relatively new service/knowledge based economy and our place in the global economy. You must als..
|
|
Three-level revenue forecast
: Three eye-ear-nose-and-throat physicians decide to hire an experienced audiologist in order to add a new service line to their practice. They ask the practice manager to prepare a three level colume forecast as a first step in their decision making. ..
|
|
Monopoly became americas best selling game in 1935
: Why do you think Monopoly became America's best-selling game in 1935 during the Great Depression?- Discuss the characteristics of the game and how it reflects the reality of this era.
|
|
Compare and contrast j. alfred prufrock and nick
: Write a 750-950 word essay on one of the following topics. Aim for a 5-paragraph essay structure ( introduction with thesis, three or more body paragraphs, and a conclusion). The word count does not include the Works Cited page or formatting. Com..
|
|
Health insurance coverage andother aspects of financial plan
: What is the relationship between health insurance coverage andother aspects of financial planning?
|
|
What are the earnings per share for your firm
: You currently work for a firm that has investment capital per share equal to $100. This firm currently enjoys an annual return on capital of 12 percent. Given the current payout policy, what are the earnings per share for your firm? What discount ra..
|