Question

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 volume forecast as a first step in their decision-making. Assumptions: for the base level (most likely) revenue forecast, assume $200 per procedure times 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 managed 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 procedures. (The worst case is if the practice loses a major payer.)

Audiologists were designated as “eligible for physician and other prescriber incentives” as discussed elsewhere. Thus the new service line was a logical move.

Using the above assumptions, calculate revenue forecast at each level in Microsoft Excel.

Solution Preview

This material may consist of step-by-step explanations on how to solve a problem or examples of proper writing, including the use of citations, references, bibliographies, and formatting. This material is made available for the sole purpose of studying and learning - misuse is strictly forbidden.

Revenue Forecast

This is only a preview of the solution. Please use the purchase button to see the entire solution

Related Homework Solutions

The Shuanghui Acquisition of Smithfield Foods (440 words)
Homework Solution
$40.00
Business
Financial Management
Economics
Administration
Growth Strategy
Shuanghui Acquisition
US government
Companies
Workers
Import Balance
Export Balance
China
United Food and Commercial Workers International Union
Bedo Case
Homework Solution
$88.00
Business
Finance
Bedo
Liability
Assets
Value
Risk
Insurance
Premium
HO-3 Policy
Inflation Protection
Exposure
Coverage
Split-Limit
Part D
Fund
Risk Tolerance
Risk Capacity
Regular Income Stream
Capital Appreciation
Portfolio Management Questions
Homework Solution
$30.00
Business
Financial Management
Economy
Investors
Stocks
Bonds
Asset Allocation
Asset Correlation
Portfolio Management
Foreign Securities
Security Market Line
Market Efficiency
Pricing Model
Finance Questions
Homework Solution
$33.00
Business
Finance
Rate of Return
Economy
NPV
IRR
Arithmetic Returns
Geometric Returns
Average Arithmetic Return
Total Arithmetic Return
Stocks
Net Present Values
Business Questions
Homework Solution
$20.00
Business
Accounting
Economy
Finance
Payments
Savings Accounts
Interest
Withdrawals
Future Value
Pension Fund
NPV Function
Deposits
Business Questions
Homework Solution
$25.00
Accounting
Business
Financial Management
Economics
Stock Market
Prices
Payments
Companies
Facebook
Twitter
Starbucks
Shareholders
Cash
Bonds
Dividends
Get help from a qualified tutor
Live Chats