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

$13.00

or $1 if you
register a new account!

Related Homework Solutions

Present Value Of The Lease
Homework Solution
$5.00
Accounting
Business
Finance
Economics
Payments
Lease
Discount Rate
Present Value
Rounding Numbers
Percentage
Microsoft Excel
Business Problems
Homework Solution
$100.00
Business
Accounting
Finance
Fibonacci
Practical Problems
Roman Numerals
Annual Compensation
Bond
Face Value
Maturity
Competitive Market
Shares
Prices
Buying
Standard Deviation
Acer Stock
Homework Solution
$8.00
Business
Finance
Acer
Stock
Price
Expiration
Date
Share
Profit
Put
Option
Finance Questions
Homework Solution
$25.00
Business
Accounting
Administration
Economy
Calculating Payback
IRR
NPV
Profitability Index
Cash Flow
Investments
Discount Rates
Helpdesk Questions
Homework Solution
$24.00
Accounting
Business
Financial Management
Economics
Security
Prices
Helpdesk
Supply
Demand
Customer Support
Email Literacy
NPV Of The Alternative
Homework Solution
$5.00
Accounting
Business
Finance
Economics
Microsoft Excel
Alternatives
NPV
Rounding Numbers
Constant Dollars
Payments
Cash
Tables
Get help from a qualified tutor
Live Chats