Skip to end of banner
Go to start of banner

Managing Price Plans

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 16 Next »

On this page

Overview

Price plans are your company's price catalogues. All the billed products are added to at least one price plan in order for billing to be applicable. Subscribers and customers are billed for their purchases based on the rates defined in the price plan usually agreed upon contract signing.

Major features

  • Use price plans to define rates for every billable product that is added to a subscription, job or activity with the exception of usage services which are added in dedicated Usage Price Catalogs. 
  • Provide discounts to customers by defining lower than base rates for a specific period, or for a certain purchased quantity
  • Create conditional price plans, where rates specified can be applied only on fulfilling conditions specified on each price plan, making them a powerful tool used for providing several types of promotions and discounts to customers.
  • Easily manage overall price adjustments due to changed tax rates

 

Setting Up Price Plans

 Finance Application > Products and Pricing > Price Plans

Price Plans


Price plan rate models

Before setting up your price plans, it is important to understand the different rate models that exist and how billing handles each rate model. When adding new products to the price plan, the rate models available for selection depend on the classification of the product which can be one of the following: expense, termed service, one time service or physical good.

Rate Model

How it works

Applicable for Product Classification

Calculation LogicExample
Flat RateApplies a single fixed price.

Expenses

Final price is based on the base amountSetup fee: €20

Flat Rate, Quantity Based

 

Applies a single fixed price based on the quantity of the product, which starts from a base rate and can be modified as the quantity increases, by using a multiple tiers table.

If used for termed services, then the logic changes according to the number of the distributors. The quantity of the service will be measured based on the number of authorised distributors of the service. The service will be billed only once, taking into consideration the applicable price.

 

Termed services, physical goods

Not cumulative;

If the quantity falls into multiple tiers , then the final price is equal to the price of the highest level .

If the quantity does not fall into any quantity range, then the final price is equal to base rate price

A channel available from multiple TVs (rooms in the house with different decoders):
If for 1 TV the price is €10 and from 2 to unlimited units the price is €8 then:

  • A channel available from one TV will be billed €10
  • A channel available from two TVs will be billed (€8*2) = €16
  • A channel available from three TVs will be billed (€8*3) = €24
Flat Rate, Duration Based

Applies a single fixed price based on the duration of the services, which starts from a base rate and can change as the duration required to provide the service increases, by using a multiple tiers table.

One-time services

Not cumulative;

If the duration falls into multiple tiers, then the final price is equal to the flat rate price of the highest level.

If the duration does not fall into any quantity range, then the final price is equal to the base rate price

Installation service: for 1 hour the charge is €10 and from 2 to unlimited hours the charge is €8 then:

  • An installation that lasts for one hour will be billed €10
  • An installation that lasts for two hours will be billed (€8*2) = €16
  • An installation that lasts for three hour will be billed (€8*3) = €24

 

Tiered Rate, Quantity Based

Applies a price which starts from a base rate and can progressively change as the quantity increases, using a price table made up of multiple tiers.
Each tier, defines a quantity range and the rate that will be applied to a product if the quantity of the purchased product falls within that range.

Termed services, physical goods

 

Cumulative;

If the purchase of a product falls into multiple tiers, then the final price is calculated by adding up the base rate and the rates of each tier.

If the duration does not fall into any quantity range, then the final price is equal to the base rate price

Antenna: If for 1 antenna the price is €10 and from 2 to unlimited units the price is €8 then:

  • An antenna will be billed €10
  • Two antennas will be billed for  €10 + €8 = €18
  • Three antennas will be billed for (€10*1) + (€8*2) = €26
Tiered Rate, Duration Based

Applies a price which starts from a base rate and can progressively change as the duration required to provide the service increases, using a price table made up of multiple tiers.
Each tier, defines a duration range and the rate that will be applied to a service if the duration of the service falls within that range.

One-time services

Cumulative,

If the duration of the service falls into multiple tiers, then the final price is calculated by aggregating the base rate and the rates of each tier.

Installation service: for 1 hour the charge is €10 and from 2 to unlimited hours the charge is €8 then:

  • An installation that lasts for one hour will be billed €10
  • An installation that lasts for two hours will be billed  €10 + €8 = €18
  • An installation that lasts for three hour will be billed (€10*1) + (€8*2) = €26

Tiered Rate, Maturity Based

Applies a price which starts from a base rate and progressively changes as the subscription maturity (age length) increases, using a price table made up of multiple tiers.
Each tier defines a period range and the rate that will be applied on a product if the subscription age falls within that range.

 

Termed services

Cumulative;

If the subscription age falls into multiple tiers, then the final price is calculated by adding up the base rate and the rates of each tier.
The 'to' field, in tiered pricing, includes the binding end as an extra option (free text integers and unlimited option).

Channel: if for the first month the channel is for free, from the second to third month is €10 and then until binding end is €20 then

  • A subscriber with a biannual billing frequency (6 months) will be billed 0 +  €10 + €10 +  €20 +  €20 +  €20 = €80


Back to top

Price Plan fields

This table contains an explanation of the sections of price plans Data Entry page, a description of the usage of its fields and additional information.

 Mandatory   Configurable

Main Information

Code: The code of the price plan which is used to identify the plan throughout the system along with the name. Due to constant price changes, price plans usually have multiple versions, each applicable for a specific period. The code is always the same, for all versions of the price plan.

Type: The type of the Price Plan which can be either Base or Conditional and it is generated automatically by the system when creating the price plan.

Effective Date: The date that the price plan rates can be used for billing. A new effective date is set in each version of the price plan automatically.

Expiration Date: The date that the price plan rates can no longer be used for billing. 

    • Rates from expired price plan versions may still be used if the customer made a binding contract with the business, and the system is configured to apply the rates applicable during sign up. This applies even if the price changes due to a change in VAT.
    • The expiration date is set in each version of the price plan. Every time a new version is created it, the expiration date of the system is automatically set equal to the effective date of the new version.

Base Price Plan : Used when creating a new conditional price plan. The rates from the base price plan rates will be applied if the conditions specified in the conditional price plan are not met.
When a Base Price Plan is selected then, 'Selection Conditions' and 'Validity Condition' tabs become available.

Rates

 

Define the rates of the products. The rates are categorised and can be filtered by product classification: physical good rates, One time services rates, termed services rates, expenses rates.

 

Product Information: The product that is rated, along with product type and product classification.

Code: The rate code used by the system to identify rates. It is automatically generated but is editable.

Product Bundle: The product bundle related with the selected product. This information is visible only if the specified product is used as a component belonging to a product with a type classified as flexible bundle product which is only applicable for termed services. 

Rate Model: The rate model that is applicable on the rate. The available rate models depend on the classification of the product to be rated, as described in the Rate Model Table. 

 Base Amount: The rate that is applied if tiered rates are not provided or are not applicable. Base amount also has a UOT(Unit of Time) which is applicable and mandatory for termed services and one-time services.
If necessary, the system will convert a rate from monthly to daily. Businesses which bill on a daily basis are recommended to add a Daily rate for more precise results. 

 Effective Starting From: This is applicable for termed services only and is used to determine when the recurring charge will become active. The following options are available:

  • Binding start date: The rate will become active on the date that the binding period (as specified at the Billing Term) begins.
  • Service Effective date: rate will become active on the date that the Service will become effective.
  • Agreement date: The rate will become active on the date that the customer accepted the Billing Terms.
Tiered Rates

Tiered Rates are used to define a different rate than the base rate either for a particular period or quantity, according to the rate model selected. Check the Rate Model Table to understand the application of the tiered rates.

Level: A level number to identify the order by which levels are considered.

From: The value from which the tier level applies.

To:The value up to which the Tier level applies. A selection can be done from:

    • Specific Number
    • Binding End (for termed services only)
    • Unlimited
  • According to the selected Rate Model and the UOT, the unit for the From and To value may differ.
    • If it refers to a tiered service whose base rate is defined in UOT, the From and To fields refer to the number of UoT. (for example days, month)
    • If it refers to a duration based one time service and the UOT is hours then, the From and To fields refer to the number of UOT. (for example hours)
    • If it refers to a quantity based physical good, then the From and To fields refer to the number of items.

Amount: The amount to be applied for the tier level. 

Selection Conditions

Only available for conditional price plans 

 Conditions which are used to validate whether the price plan can be selected for a subscription or a job

Validity Conditions
Only available for conditional price plans 
Conditions which are used to determine if the rates denoted by a price plan can be applied during billing or not.
Billing will revert to using the respective base price plan rates if any conditions in the conditional price plan are violated.
Allowed Organisational Units
The organisational units that can select and assign the price plan on billing term schemes (as allowed price plans to be used), subscriptions and jobs.

 

Related configuration areas

The following modules are related to price plans and must be configured in order to be able to start using them

Manual LinkAreaDescription 
ProductsProduct Types and ProductsThe products that you would like to provide a rate for must already be configured. Note that if the price plan is already created then upon creation of the product you can also add it to the Price plan through the Product's screen. 

/wiki/spaces/WIP/pages/10008666

/wiki/spaces/WIP/pages/10008551

Billing Term SchemesOnce price plans are created they are added in the 'allowed price plans' tab of the billing term schemes in order to be available for selection on jobs and subscriptions 

 

Back to top 

Using Price Plans

Multiple effective price plans can be created and the applicable one (according to the customer's agreement terms) can be selected when creating a subscription or a job. If conditional price plans are available then they are also available for selection given that the selection conditions defined on the price plan are met, but will only e used during billing if the 'validity conditions set on the price plan are met.

Selecting and creating a price plan



Specify the criteria that match the price plan you are interested in or use NEW from the Actions Menu to create a new plan. Provide the mandatory information in the price plan fields table before you SAVE the plan.

Amend existing price plan rates



Price plans already assigned on a subscription or a job cannot be modified, as rates are agreed between the customer and the business when creating the subscription or job. There are occasions however that even price plans that are already added to customers must be amended. For example, a change in VAT or the overall increase of rates regardless of the contract. 
Customers who that have the price plan updated on their job or subscription will be billed with the new price plan rates. Although this is the default behaviour of the system, the user has the option to define (via Billing Definitions) that until the 'binding end date', customers should be charged the previous price plan rates.

  1. Search for the price plan you wish to amend and from the Data Entry page click on Actions > Replace from the Actions Menu to open the Replace Price Plan Form modal.
    1. New Price Plan's Effective Date: Define the date from which the new price plan rates will take effect.
    2. Adjust Rates by '%': Add a % to update all rates in the price plan or leave empty to make manual updates.
      If you would like to increase rates then add a positive number, if you would like to decrease all rates then add a negative number. If you want to manually change rates of each product then leave this field blank.
  2. Click on SAVE to close the modal.
    If the Adjust Rates By % is defined then, all rates will be automatically updated.  
  3. Click on EDIT from the Actions Menu to start updating the price plan rates.

Automatically calculate and apply discount to rates



You have the option to offer a discount on already defined base or tiered rates provided that the price plan is not already in use. By using the Calculate Amount link, you can define a discount as an amount or percentage (%) and the system will calculate and set the new discounted price. The action is available on adding new product rates or editing existing.

  1. Select the product rate you want to update.
  2. Click on Calculate Amount link, either on the base or tiered rate.
  3. In the modal
    1. Provide a number in the 'initial amount' text box (this can be the same or different than the base/tiered amount).
    2. Select between amount and percentage and provide a number in the text box below.
    3. Click anywhere outside the text box and check the calculated rate.
    4. Click on SAVE  to apply the change.
      • The system will set the amount that has been calculated, regardless if the 'initial amount' provided was different to the base or tiered amount.
  • Positive numbers must be used in offering a discount.
  • If a negative number is used, then the System will ADD this to the initial amount instead.

    Initial AmountDiscount AmountCalculated Amount
    10.005.005.00
    10.00-5.0015.00
    10.005%9.50
    10.00-5%10.50

Adding new product to existing price plans



While you cannot change price plans that are already in use you can use Add New Product action to define rates for new products to existing price plans. An alternative to this, is to add the product to an existing price plan when creating the new product directly from the Products data entry page.

  1. Click on the name of the plan you would like to add a new product rate to go to the Data Entry page.
  2. Click on Actions > Add New Product from the Actions Menu.
  3. Use Quick Search or click on the magnifying glass to search for the product .
  4. In the modal provide all the necessary information for the creation of the Product as explained in the fields table.

Creating a conditional price plan


 Conditional price plans as implied by the name can be added and used for billing jobs or subscriptions only if two types of conditions are met. These conditions are defined in the price plan.

  • Selection Conditions: If satisfied, the price plan will be available where a price plan is selected to be added to a job or subscription.
  • Validity Conditions: If satisfied, the rates from the applied price plan will be used when billing the job or subscription. Validity conditions are required because from the time that a (job or subscription) price plan is set until the time that is it is billed, the 'selection conditions' may no longer be satisfied. It is recommended to have the same conditions defined for selection and validity.
    If during billing, the validity conditions are not met, then the system will get the rates from the base price plan that was used when creating the conditional price plan.

 

  1. Click on NEW from the actions menu to create a new price plan.
    1. Provide the information in the section as in the case of a base price plan and make sure you select a Base Price Plan that the system will use in case the selected conditional price plan conditions are not met during Billing
    2. Rates
      1. All the rates available in the selected Base Price Plan will be present here. Change the rates accordingly or use the Replace Price Plan action to change all the rates simultaneously by a certain percentage.

    3. SELECTION & VALIDITY CONDITIONS

      1. The process for adding Selection or Validity conditions is the same. 
        Follow the steps below:
      2. In 'Evaluation Settings' there are 2 options that can be set at 2 different levels to select whether all conditions or at least one condition should be met.

        1. General: Select whether conditions for all the condition groups should be met or at least one.

        2. Condition Group Specific: Select whether conditions for all rows within each of the condition group should be met or at least one.

      3. Once the Evaluation Settings are in place, click on each of the condition groups in the group list on the left to start defining the group row conditions.

        1. Click on ADD to add a new row.
          or 
          ADD FROM TEMPLATE to select an existing condition group row.
          Templates are condition group rows that have been previously saved to be reused. They already contain information such as type, operator and value.

        2. Type: Select the type of the condition from the drop-down list.
        3. Operator: Select whether the values defined should be:
            1. Equal
            2. Not Equal
          1. Value: Click on the ADD VALUES link to open the modal to add values for each condition group row, i.e. for the type you have selected.
            1. Like in Evaluation Settings, set whether all the values defined in the modal should be met, or at least one.
            2. Value 1 - Value 20: Use Quick Search or click on the magnifying glass for a search modal to select the values to be set as conditions.

        4. Save as Template: Save the values per Condition Group as a template so that it can be reused in other condition groups of the same type.
          1. Click on the SAVE AS TEMPLATE link and provide a name and description.
          2. Once all the Condition Group rows are complete, repeat the process for a new Condition Group.
          1. Allowed Organisational Units
            1. Add the organisational units that can select and assign the Price Plan
        5. Click on SAVE to save the Price Plan

 

Different values will be available for selection for each type selected in the condition group.
The available types are:

  • Subscription Type: Evaluated against the subscription type of the subscription being billed; that is, the offering the customer is subscribed to. (only available for 'selection conditions')
  • Billable Entity Maturity: Evaluated based on the maturity of the billable entity, which means whether is a new or existing subscription or job. (only available for 'selection conditions')
  • Billable Entities Existing Products: Evaluated against physical goods or services added to the subscription or job
  • Billable Entities Products To Be Added: Evaluated against products that will be added to the subscription or job . (only available for 'selection conditions')
  • Billable Entities Existing Price Plans: Evaluated against existing price plans; for example if you have multiple subscriptions billed from the same account, it evaluates based on the price plans on the subscription (only available for 'selection conditions')
  • Billable Entities Owner Groups: Evaluated against the group that owns the subscription or job
  • Accounts Receivable Classifications: Evaluated against the classification of the account owner that owns the subscription or job
  • Accounts Receivable Credit Ratings: Evaluated against the credit rating of the account owner that owns the subscription or job
  • Accounts Receivable Payment Preference: Evaluated against the payment preference of the account owner that owns the subscription or job
  • Billing Term Scheme: Evaluated against the billing term scheme of the subscription or job
  • Billing Terms Binding State: Evaluated against the binding state of the subscription; for example whether the subscription is in and out of binding
  • Billing Terms Binding Period: Evaluated against the binding period of the subscription; for example if its annual or 2 years
  • Billing Terms Billing Frequency: Evaluated against the billing frequency of the subscription; for example if its billed monthly or annually
  • Segmentation: Evaluated against accounts receivable that belong to a selected segment (list)


 

Defining product bundle pricing



A product bundle is a product which is made up of multiple component products; for example an offering to a customer where a single package includes multiple channels. 

There are two types of product bundles, fixed and flexible.

  • Flexible Bundle Products: Products that have a variable selection of constituent products as components.
  • Fixed Bundle Products: Products that have a fixed selection of constituent products as components.

The price of fixed bundle products can be set just like the rest of the products.  Flexible bundle products which is only applied to termed service, allow the user to:

  • Define a price at bundle level; one price for all included products.
  • Define a price at the product level and differentiate when a product is sold as a stand-alone product or as part of a bundle.
  • Define both prices and bill for both the bundle and each product individually.

Add a rate at the bundle product Level

Add the product and in the 'Rates' section provide all the required information and leave empty 'Applicable Only If Part of Bundle'

Add a rate for a product when provided through a bundle

Add the product and in the 'Rates' section provide all the required information and for 'Applicable Only If Part of Bundle'  select the bundle in which the product belongs, and for which you are defining the rate.

Add a rate for a product that belongs to a bundle but is also sold as a standalone product.

  1. Add the product and in the 'Rates' section provide all the required information and leave empty 'Applicable Only If Part of Bundle'
  2. Add the product again and in the 'Rates' section provide all the required information and for 'Applicable Only If Part of Bundle'  select the bundle in which the product belongs, and for which you are defining the rate.


Back to top 

Applying business flows on price plans

Bulk adjustment of rates based on tax changes


Tax changes don't need to be a big hassle. Price Plan Adjustment Run Definitions allow you to define rules that will be used to adjust all affected price plan rates whenever vat or tax rates changes. 

Once the definition is created and scheduling setting set, SUBMIT the definition. Once the run is completed, it will create a new version of each affected price plan and calculate the new rate for products whose tax rate has changed. Note that the adjustment runs should not be used in case the rates in the price plans are not tax inclusive. Refer to Tax Definition, for more information.

 

 Price Plan Adjustment Definition

Price plan adjustment run definition fields

This table provides an explanation of the sections of the definition Data Entry page, a description of the usage of its fields and additional information.

 Mandatory   Configurable

Criteria
VAT Rates

VAT Rate Change as of Date: Defines the date on which the VAT Rate changes to a new rating period.
All VAT Rates which have a 'period start date' before or equal to this date will be available for selection.

VAT Rates: A selection of VAT Rates. Multiple VAT rates can be selected and at least one should be specified.

Price PlansA selection of price plans on which the adjustment will be applied exclusively.
Only non-expired price plans whose 'effective date' is before the 'VAT Rate Change as of Date' will be available for selection.
If no price plans are specified, then all non-expired price plans whose 'effective date' is before the 'VAT Rate Change as of Date' will be considered
Products

Products to be adjusted A selection of products and/or product types, whose rates will be adjusted.
If no products are specified, then the rates of all affected products will be modified.

Products not to be adjusted:  A selection of products and/or product types, whose rates should NOT be adjusted.
If no products are specified, then the rate of all affected products will be modified.

Process Runs
Displays the Runs that were executed for the specific Definition. Each Run includes the Price Plans that were processed. In case of an error, the error code and description is displayed.
Scheduling Settings
Define the scheduling settings which can either be now or in the future.
  • Run Now
  • Run on Specific Date / Time

 

Back to top 

Price Plans Business Example

Scenario

Company ZX wants to set the rates for the following products, with the following billing requirements:

  • TV Subscription Start-up fee
    • Start up fee: €5
       
  • Installation Service Fee based on the duration, providing a Tiered Rate:

    • €20 per hour

      • 1 hour: €20 per hour
      • 2 - 5 hours: €15 per hour
      • 6- unlimited: €10 per hour
        i.e. 5 hours of repairs = (1*20)+(4*15) = €80
         

  • Repairs based on the duration, providing a Flat Rate:

    • €20 per hour
      • 1 hour: €20 per hour
      • 2 - 5 hours: €15 per hour
      • 6- unlimited: €10 per hour
        i.e. 5 hours of repairs = 5*15 = €75

  • Antennas based on the quantity, providing a Flat Rate:
    • Antennas
      • 1: €10
      • 2: €9
      • 3: €8
      • 4 - Unlimited: €7
        i.e., buying 3 antennas = 3* €8 =  €24
         
  • Decoders based on the quantity, providing a Tiered Rate:
    • Decoders
      • 1: €10
      • 2: €9
      • 3: €8
      • 4 - Unlimited: €7
        i.e. Buying 3 decoders = €10 + €9 + €8 = €27

  • VOD Service fee, based on the number of distributors that the Services are supplied to, providing a Flat Rate:

    • VOD Subscription Service
      • Only Main Distributor (i.e.,.1): €5
      • Main and Twin 1 Distributors (i.e. 2): €4
      • Main, Twin 1 & Twin 2 Distributors (i.e. 3) : €3
      • For any additional distributors (i.e. <= 4) : €2
         
  • PPV Service fee, based on the number of distributors that the Services are supplied to, providing a Tiered Rate:

    • VOD Subscription Service
      • Only Main Distributor (i.e.,1) : €5
      • Main and Twin 1 Distributors (i.e., 2): €4
      • Main, Twin 1 & Twin 2 Distributors (i.e., 3) : €3
      • For any additional distributors (i.e., <= 4) : €2
         
  • Gold Service Subscription, based on a monthly fee with a free three month trial period:

    • For the first three months, the Subscription will cost €0 per month
    • Starting from the fourth month the Subscription will cost €20 per month

Solution

Create the following Base Price Plan

  • Create the price plan
  • Once created add the rates into the plan
  • Check the table below and see the rate type and model that should be used to satisfy each requirement
Product NameProduct Rate TypeRate ModelBase AmountTiered PriceComments
    Tier LevelFromToTier Amount 
Start Up FeeExpenseFlat Rate€5    Tiered Rates not allowed for Rate Type: Expenses
         
RepairsOne Time ServiceFlat Rate, Duration Based€10     
    111€20 
    225€15 
    36Unlimited€10 
         
Installation Service FeeOne Time ServiceTiered Rate, Duration Based€20    

5 hours of repairs = (1*20)+(4*15) = 80

    111€20 
    225€15 
    36Unlimited€10 
 
AntennaPhysical GoodFlat Rate, Quantity Based€10    Buying 3 antennas = 3* €8 =  €24
    111€10 
    222€9 
    333€8 
    44Unlimited€7 
 
DecoderPhysical GoodTiered Rate, Quantity Based€10    Buying 3 decoders = €10 + €9 + €8 = €27
    111€10 
    222€9 
    333€8 
    44Unlimited€7 
 
GoldTermed ServiceTiered Rate, Maturity Based€20    Subscription billed for a year: (3*0) +(9*20) = €180
    1130 
    23Unlimited€20 
         
VOD ServiceTermed ServiceFlat Rate, Quantity Based€5    Service is distributed on 4 distributors = 4*2 =€8
    111€5 
    222€4 
    333€3 
    44Unlimited€2 
         
PPV ServiceTermed ServiceTiered Rate, Quantity Based€5    Service is distributed on 4 distributors = (1*5) + (1*4) + (1*3) + (1*2) = €14
    111€5 
    222€4 
    333€3 
    44Unlimited€2 

Notes

 

Glossary  

CRM.COM TermDefinition
Usage ServicesServices that are provided upon customer request and are billed based on their usage.
SubscriptionA collection of customer services billed on a recurring, usage or one-time basis.
JobA small project initiated by the operator for customers, involving the delivery and billing of services, products and activities. Customer requests and orders, such as that for a new subscription, can be initiated and registered through a job.
ActivitySmall task or action that is either stand-alone or must be completed as part of a larger project.
ExpensesServices that are provided just once, usually upon customer request, and are billed just once.
Termed ServicesServices which are billed for a term and they cycle
Physical GoodsA tangible commodity which is provided to customers, such as cameras, decoders and magazines. Physical Goods can be traceable or not traceable.
One -time ServicesServices which are only provide once and billed based on their duration
Provisioning Distributors

Distributors are used to relate subscription services and subscription associated devices to a specific Provisioning Provider as well as define what services will be available from each device, if more than one device is available on a single subscription.

CRM.COM offers integration with several providers.

SegmentsLists of records in CRM.COM based on conditions that are defined using CRMQL (CRM.COM Query Language), a business query language developed by CRM.COM.

 

 

  • No labels