| Description |
| 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. |
| Supported languages: English |
| Supported OS: Win98, WinME, WinNT 3.x, WinNT 4.x, Windows2000 |
| Installation: Install and Uninstall |
| Requirements: Microsoft Excel |
|
| Release info |
|
12/02/2001
New Release
|
|
| Permissions |
| *Distribution* You may freely distribute this software in Evaluation form without Registration Codes. Any software distributed must require the user to provide payment to Bizpep to maintain software beyond the Evaluation Period as originally designed. You may not sell or require payment in any form for Bizpep software. Evaluation software must be distributed without cost or penalty to the user. |
|
| End user license agreement |
| *Evaluation* Software is provided free for 7 Day Evaluation. To maintain software after this period payment is required. Print and Save functions are restricted during Evaluation. *Purchase* To maintain software beyond the Evaluation Period payment must be provided equivalent to: US$29.00. If payment is not provided all software must be deleted. Payment gives you license to use software on one system, for one user. The license is Non-commercial for private and internal business use only. This license does not cover the Commercial use of software for Inter-Business support, advice, or consulting. Please contact us (mail@bizpeponline.com) for details on Commercial and Multi-User licenses. Payment is online at: http://www.bizpeponline.com/Purchase.html. Upon receipt of payment Bizpep will provide by return email registration code to fully enable evaluation software. Registering software removes restrictions on Print and Save functions. All other features including cell and macro protection are the same in evaluation and registered software. All non-input cells and macros remain protected to ensure the integrity of the formula and programming. |
|
|
| Also by this author |
Pricing and Breakeven Analysis Excel
2.1
Bizpep
Pricing and Breakeven Analysis, test price changes, determine optimum pricing to maximize profit, and calculate breakeven points. Easy to use input with tabluar and graphical outputs. For new or established businesses, products, or services.
Queuing Model Excel
2.0
Bizpep
Calculate the optimum number of customer service points (staff) to minimize costs for your business. Identify the impact of changes in service staff, the number of customers waiting, their average waiting time, and service point (staff) utilization.
Profit Contribution Breakdown Excel
30
Bizpep
Profit Contribution Breakdown identifies the components of your business profit. This component performance is combined with indicators for future potential and business ability to identify areas that will maximize current and future performance.
Investment Analysis Software
10
softSWOT
Easily analyze the performance of any investment to maximize returns. Compare and forecast investment performance, determine net worth and income streams, identify buy / sell indicators, make informed investment and retirement planning decisions.
Business Valuation Model Excel
32
Bizpep
Business valuation software with a 3 year performance forecast, sensitivity analysis, investment return, and calculated business valuation. Easy to use input interface with tabular and graphical outputs. Quick and effective result, minimal input.
Product and Supplier Profitability Excel
20
Bizpep
Identify the true costs associated with your products and suppliers. This software is suitable for all resale business operations regardless of size. It allows you to build a complete product/supplier database with cost and profit analysis.
Form1 Builder GoldMine
20
softSWOT
Automatically add form submission data directly to your GoldMine database. You can also specify the full range of GoldMine functions including running duplication checks and automatic processes.
Production Mix Model Excel
20
Bizpep
Maximize overall profit by optimizing resource use, for products or services. Up to six unique outputs can be handled with ten specific resource inputs. It considers the resource demand, profit contribution and any minimum or maximum requirements.
Form1 Builder MYSQL
20
softSWOT
Easily easily build web forms that can automatically import form data directly into your MYSQL Database.
Form1 Builder
20
softSWOT
Form1 Builder runs in your web browser and allows you to easily build any web form. It applies the base Form1 structure to provide a single file form (no cgi) with a hidden email delivery address and an extensive range of benefits and options.
|
|
|
Forecast the impact of billing fee changes on Revenue, Profit and Client numbers. From basic billing and cost data billing change breakeven points are calculated for revenue and profit and you can build a forecast your business.
