Billing Model Excel |
|
This model was originally designed to test changes in
billing structures for a Medical Practice (Public
versus Private Billing), however it is equally suited
to any professional practice and can be used to test
the impact of fee changes. When billing structures
are altered they impact on client numbers and in turn
revenue and profit. The Billing Model allows you to
forecast what this impact will be. It does this using
a Client Number Change Percentage. This is the
percentage change in client numbers when your billing
structure is changed. For each business this is
influenced by the level of competition,
differentiation of the business, client profiles, and
type of service provided. An estimate of this
percentage combined with basic data on average
billing fees and cost percentages allow revenue,
profit and client numbers to be forecast for the
range of billing fee combinations. The model
considers two billing structures, Current (1st) and
Proposed (2nd). From basic billing and cost data
breakeven points at revenue and profit will be
calculated for the proposed billing structure.
Breakeven points tell you the Client Number Change
Percentage at which your current and proposed billing
structures provide the same Revenue or Profit. If you
change billing structures and the Client Number
Change Percentage is greater than the Revenue
Breakeven your Revenue will decrease, if it is
greater than the Profit Breakeven your Profit will
decrease. You can input an Estimated Client Number
Change Percentage to forecast the Revenue, Profit and
Client Numbers for your business for the full range
of current and proposed billing structure
combinations. Full results are displayed in easy to
interpret Charts and Table format. Details displayed
include Revenue, Profit, and Client Numbers.
Client Comments "This was my first software purchase
over the internet. I am very please with the
results." |
| Additional Information: Billing Model Excel | |
|
30 day Money back guarantee. Software is written with Excel 2000/2002 but most software features should run on Excel versions from 97 on. OS : Windows 9x/Me/NT/2000/XP |
|
|
$29.00 |
|