PROFORECAST - Help Vs 10
×
Menu
Index
  • Selecting Revenue Models

Selecting Revenue Models

Revenue model choice
There are 9 active Revenue models, further models are in development and will be added as appropriate, models can be used in any combination, to reflect businesses with multiple revenue streams or alternatively by using a combination of models creating a particular type of revenue stream. There follows a brief overview of each model to enable users to make the appropriate selection. These revenue models can have a Cost of Sales built in a number of ways, for goods and services sold the COGS can either be calculated from the Top Down or Bottom UP.
 
By bottom up, we mean that the cost of sales is built up from the number of units sold, the cost and selling price per unit, which generates in turn the sales figure and the cost of those sales, whereas in the Top Down model, the number of units sold and costs are derived from the sales figure using a table to determine the mix of products that are sold. The Product Mix menu item will only appear if a Top Down COGS revenue model is selected, and can not be used in conjunction with the Bottom Up Cogs Sales Model.
 
Bottom Up COGS Sales Model
 
1 - Products Target Model - Works in conjunction with the Products Set up Menu and Includes seasonality, new business, lead time, deposits, and debtors models. Sales and cogs are derived from the number of units sold of each product, ie from the bottom up.
 
Key Revenue Drivers: -
 
· Customer Discounts
· Unit Targets
 
Key Cost Drivers: -
 
· Product Sales Price
· Product Costs
· Stock turn days
 
Top Down COGS Sales Model
 
2 - Manual Sales  - Works in conjunction with the Products Set up Menu, and Product Mix Menu, the model also Includes seasonality, new business, lead time, deposits, and debtors models. Sales and cogs are derived from the mix of units sold of each product so that the gross sales figure is worked backwards to calculate the units sold, ie from the top down.
 
Other Revenue Models
 
3 - Manufacturing - As many additional Manufacturing processes as required can be added and assigned to either any Operating Cost Department, where costs are built up in the same way as all other cost centres.
 
The manufacturing model is an output driven models where the level of production is set by the product demand . The model can accommodate multiple input materials used in the processing and up to three outputs which are managed like a recipe. The first output is deemed to be the primary output and any secondary outputs are measured as a % of the output volume, this is done by entering the sales volume of each Secondary Output as a % of the Primary Output volume.
 
4 - Licence or Franchise Fee Revenue Model - This model could be used for any business that earns revenue by the sale of licences or franchise fees. The model incorporates multiple tiers of licence or franchise fees and four data sets to build the forecast.
 
Key Revenue Drivers
· Average customer discount
· The customer retention rate
· The average annual licence fee
· The number of licences sold per annum
 
This model is used to forecast the revenues generated from the sale of licence or franchise fees. If the business operates a franchise model, the initial franchise fee sale is represented by this model but the ongoing franchise income generated by franchisees should be forecast by selecting and using the most appropriate revenue model. There is no factoring or invoice discounting option.
 
5 - Capacity Yield Model - Can be used for any business that earns revenue from operating a business process which has a defined capacity and a known yield or utilisation.
 
Key Revenue Drivers
· Available Capacity
· Revenue Per Unit
· Utilisation or Yield
 
Key Cost Drivers
· COGS – Cost Price
· Direct Costs
· Target Days Stockholding
· Cost Price
 
The cost of sales (COGS) model to be used with this revenue model should be determined by allocation of the % of sales generated by the sale of products or services, if the sale of products occurs, ensure that the products module is enabled on the setup menu.
 
For each outlet or department there can be up to a total of seven services or processes, each service or product can have its own Cost of Goods (COGS).
 
6 - Agency Sales  - The agency model can work for a business that acts as a Principal or acts as a pure agency and the model includes the following options and automatically calculates any deferred revenues.
 
Key Revenue Drivers
· Transaction or contract Type
· Principal or Agent
· Variable commissions received per transaction
· Product value
· Fixed commissions received per transaction
· Customers or transactions per month
· Renewal rates and export sales
 
Key Cost Drivers
· Direct costs incurred per transaction
· Customers or transactions per month
· Product costs
 
7 - Box Office also known as Differred Box Office - This revenue model automatically creates and releases deferred revenues created by advance ticket sales and also automatically calculates any deferred costs which are subsequently recovered from artists.
 
The model works by creating scenarios for different types of events and profiling the ticketing process, so for some events, the ticket lead time may be brief, for others tickets can be sold up to a year in advance of the event. So a separate event would be created type of ticket profile required.
 
Key Revenue Drivers
· Venue Capacity
· Event Timetable
· Average Revenue Per Ticket
· Yield
· Addittional Product Sales
 
Key Cost Drivers
· Direct costs incurred per transaction
· Recovered costs per transaction
· Product costs
 
8 - Miscellaneous Income - Model enables any miscellaneous one off or repeat revenues to be entered manually such as the receipt of management charges, the revenue stream name can be customised for use in the income statements.
 
9 - Professional Services - This model uses Fee Earners to create revenues but can work in conjunction with the products module to generate a cost of sales.
 
Key Revenue Drivers
- Number of Fee Earners
- Hourly Rates
- Capacity/Availability in hours per annum
- Utilisation/Yield
 
Key Cost Drivers
- Fee Earners Salaries
- % of Sales linked to the sales of products?
- Direct Costs as a % of those product based sales
- Direct Costs as a % of non product based sales
- Sales Commissions