|
|
|
Main
> Business
& Finance > Business
& Finance >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.
Quantity: The number of licenses you purchase is the maximum Number
of Users and the maximum Number of Computer Systems the purchased software
can be installed on or that can access the software if on a network.
License Type: Non-Commercial Licenses are for private and internal
business use only. They do not cover the commercial use of software for
inter-business support, advice, or consulting. Commercial Licenses allow you
to use your software for inter-business support, advice, or consulting. This
license type is generally suitable for Accountants, Consultants, Valuers,
Realtors and other professionals providing a service to their clients.
Software is in Microsoft Excel format and Excel is required for use. |
|
Buy
Now |
|
Billing Model Excel screenshot:
 |
|
|