Skip to end of banner
Go to start of banner

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 24 Next »

On this page

Overview

Price plans are the set of rates at which a company offers goods and services.  The plans are used by the billing engine to charge customer accounts receivables for purchases. 

Every billable product that is added to a subscription, job or activity must belong to at least one price plan, with the exception of usage services whose rates are defined in Usage Service Catalogs. 

Price plans functionality 

  • Suitable for promotions and discounting; Price plans can be subject to conditions that result in special rates (such as discounts for employees).
  • Ideal for making price reductions; rates that are lower than the base rate can be defined for a specific period or purchase quantity.
  • Simplify overall price adjustments when tax rates change.

Setting Up Price Plans

 Finance Application > Products and Pricing > Price Plans > Manage Price Plans


Price plan rate models

The classification of each product determines the rate models available when adding a product to a plan.  Billing handles each model differently.

 Products are classified as:

  • Expenses
  • Termed services
  • One-time services
  • Physical goods.

Rate Model

Application

Intended for Classifications

Calculation LogicExample
Flat RateA single fixed price

Expenses

Price = Base rate

A €20 setup fee

Flat Rate, Quantity Based

 

A single fixed price based on purchased quantity, starting from a base rate, and adjusted as the quantity increases according to preset tiers.

The purchased quantity of termed services depends on the number of service distributors. I.e., if the same channel is available from two different boxes, the quantity of the services is two.

Termed services, physical goods

  • Not cumulative
  • Price is that of the highest tier
  • If the quantity does not fall in a tier, the price is equal to the base rate.

A channel is accessible through several TV decoders (in different rooms).  If the price for accessing the channel is €10 from one TV decoder and €8 from two or more, then:

  • Access from one decoder is billed €10 (1*10)
  • Access from two decoders is billed €16 (2*8)
  • Access from three TV decoders is billed  €24 (3*8).
Flat Rate, Duration Based

A single fixed price based on the duration of the service, starting from a base rate, and adjusted as the duration of the service provided increases, according to preset tiers.

One-time services

  • Not cumulative
  • Price is flat rate price of last/highest level tier
  • If the duration does not fall in a tier, the price is equal to the base rate.

An installation service is billed €10 for the first hour and €8 for each consecutive hour.

  • An installation that takes one hour is billed €10
  • An installation that takes two hours is billed €16 (2*8)
  • An installation that takes three hours is billed €24 (3*8).

 

Tiered Rate, Quantity Based

A price starting from a base rate, which can be progressively adjusted as the quantity increases, according to preset tiers.  Each tier defines a quantity range and the rate for the product within that range.

Termed services, physical goods

 

  • Cumulative
  • Price is the sum of tiered rates, according to the purchased quantity
  • If the quantity does not fall in a tier, the price is equal to the base rate.

The price of an antenna is €10 for one and €8 for two or more.

  • One antenna is billed €10
  • Two antennas are billed €18 (10+8)
  • Three antennas are billed €26 (10+(8*2)).
Tiered Rate, Duration Based

A price starting from a base rate, which can be progressively adjusted as the duration required to provide the service increases, according to preset tiers.  Each tier defines a duration range and the rate for the product within that range.

One-time services

  • Cumulative
  • Price is the sum of tiered rates, according to the duration of the service.
  • If the duration does not fall in a tier, the price is equal to the base rate.

An installation service is billed €10 for the first hour and €8 for each consecutive hour.

  • An installation that takes one hour is billed €10
  • An installation that takes two hours is billed €18 (10+8)
  • An installation that takes three hours is billed €26 (10+(2*8)).

Tiered Rate, Maturity Based

A price starting from a base rate, which can be progressively adjusted as the subscription matures, according to preset tiers.  Each tier defines a period and the rate for the product in that period.

Termed services

  • Cumulative
  • Price is the sum of tiered rates, according to the duration of the subscription.
  • If the maturity does not fall in a tier, the price is equal to the base rate.

A channel is free for the first month, €10 for the second and third month, and €20 for each consecutive month until binding end.

  • A subscriber with an annual binding period will be billed €80 ((0*1)+(2*10)+ (3*20)) for the first six months and €120 (6*20) for the next six months.


Back to top

Price plan fields

The table describes the sections of the Price Plans Data Entry page and explains how the fields in the page are used.

 Mandatory   Configurable

Main Information

Code & Name: Price plan identifiers that are used interchangeably in the system and remain constant across versions.

Version: Reflect price changes in specific periods for the same price plan.

Type: 'Base' or 'Conditional', selected by the system when creating the price plan. The value is 'Conditional' if a price plan is defined in the base price plan field.

Effective Date: The day from which the rates can be used for billing. A new effective date is automatically set for each version.

Expiration Date: The day from which the rates can no longer be used for billing. 

  • Based on the agreement between the customer and company, the system can be configured to keep the rates from an expired price plan version effective (even if the price is adjusted to reflect a change in VAT).
  • Whenever a new price plan version is created, the expiration date of the current version is set equal to the effective date of the new version.

Base Price Plan: Used when creating a new conditional plan. If the conditions specified in the new conditional plan are not met during billing, the rates from the base plan are applied on subscriptions.
When a base price plan is selected, 'Selection Conditions' and 'Validity Condition'
sections become available.

Conditional price plans consist of a different set of rates (usually discounted) for the same products defined in a base price plan. These conditional rates are used for billing (instead of the base rates) provided the conditions defined in the plan are met. For example, customers are billed the conditional discounted rate, as long as their account receivable satisfies the defined requirement of VIP classification.

Rates

Including information on the type and classification of the rated product

Rates are grouped by (and can be filtered on) product classification.

 Products are classified as:

  • Expenses
  • Termed services
  • One-time services
  • Physical goods.

Code: Used by the system to identify rates. It is automatically generated and can be edited.

Applicable only if part of a Bundle: Makes it possible to define a lower rate for the for termed service components of flexible bundle products when offered in a bundle.Rate Model: Available rate models depend on the classification of the product, as described in the Rate Model Table. 

 Base Amount: The rate that is applied in the absence of tiered rates.

UOT: The unit of measurement of the period during which the base or tiered amounts are applied, for termed and one-time services.

Although the system can convert a monthly rate into a daily one, it is recommended that businesses that bill on a daily basis select a daily UOT. This produces more precise results than subsequently converting a monthly rate into a daily one.

Effective Starting From: Displays when the rate will become active (for termed services only). The options are:

  • Binding Start Date: On the date that the binding period begins (as specified in the Billing Terms).
  • Service Effective Date: On the date that the service will become effective.
  • Agreement Date: On the date that the customer accepted the Billing Terms.
Tiered Rates

Used to define a rate other than the base, for a particular period or quantity, depending on the selected rate model. Refer to the Rate Model Table for information on the application of tiered rates.

Level: A number that determines the order in which levels are considered.

From and To are the inclusive integer values that determine the range of each tier level (expressed in the defined UOT)

One of the following can be defined for the 'To' field value:
  • A specific number which is valid up to a specific UOT
  • 'Unlimited', i.e., until the end of the customer's subscription
  • Binding period end, i.e., valid until the binding end date of the subscription (this option is only available in tiered pricing of maturity based models).

The unit for the From and To values may differ, subject to the selected rate model and UOT.

    • For tiered services whose base rate is defined in UOT, the fields refer to the defined UOT; e.g., number of days or months.
    • For duration based one-time services defined as a UOT, the fields refer to the defined UOT; e.g., number of days or months.
    • For quantity based physical goods, the fields refer to the number of items.

Amount: The rate applied to the tier level. 

Selection Conditions

(For conditional plans only)

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

Validity Conditions

(For conditional plans only)

Conditions that are used to determine if the price plan rates can be applied during billing.
Billing will revert to the respective base price plan rates, if any condition in the conditional price plan is breached.
Allowed Organisational Units
Organisational units that are authorised to select and assign the price plan on billing term schemes, subscriptions and jobs.

 

Related configuration areas

Mandatory modules must be configured for the Price Plan module to work. 

Optional modules may be configured for the module to operate at its full capacity.

Manual LinkAreaDescriptionConfiguration
ProductsProduct Types and Products

Products must be configured before they are rated. New products can be added to existing price plans from the Product page.

Mandatory
PlatformVAT and other Tax RatesVAT and other tax rates that will apply for the products added to the price plans. Through the tax rates area, it is possible to define whether or not the price plan rates include taxes.Optional

 

Back to top 

Using Price Plans

Validations take place before an action is initiated (prerequisite) or after it is submitted (postcondition).

Several 'Effective' price plans can be present in the system. A price plan is selected when a subscription or job is created, reflecting the customer's terms of agreement. 

Conditional price plans, if available, can be selected by users subject to 'Selection Conditions'. Whether the selected plan is used during billing depends on the price plan's 'Validity Conditions'.

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 information defined as mandatory in the price plan fields table and SAVE the plan.

Editing a price plan


Use EDIT from the Actions menu to edit price plans that have been created but not yet added to a subscription or job. You can add, remove or edit product rates and information already defined in a plan. Use the respective actions to add new product rates or amend price plans that are already in use by subscriptions or jobs.

Amending existing price plan rates



As a general rule, price plans that are already in use cannot be modified, as the company and customer agreed the plan rates when the subscription or job was created. 

In exceptional cases it is possible to amend a plan, for example, to reflect a change in VAT or in rates across all contracts. When a price plan is updated, a new version of the plan is created including the previously defined products and rates.

Customers with updated price plans will be billed using the new rates (by default).  

The user can also, through billing term schemesdefine that customers are charged with the previous rates, until the binding end date.

  1. Find the price plan to amend and from its Data Entry page, click Replace in the Actions menu to open the Replace Price Plan modal.
    1. Define the New Price Plan's Effective Date.
    2. Input the percentage by which all price plan rates should be adjusted under Adjust Rates by '%', or leave field empty for individual updates.
      Use a positive or negative number to increase and decrease rates, respectively.
  2. Click on SAVE to close the modal.
  3. Once a new price plan version is created including the products and rates from the previous plan, click on edit and update price plan rates. 

Calculating and applying discount to rates


As long as a price plan is not already in use, it is possible to provide a discount on defined base and tiered rates.  When adding new or editing existing product rates, use Calculate Amount to enter a discount, expressed as an amount or percentage.  The discounted price is calculated and set automatically.

  1. While on EDIT mode and select the product rate to update.
  2. Click on CALCULATE, on the base or tiered rate.
  3. In the Calculate Amount 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 are used in discount calculations.
  • Negative numbers have the opposite effect (making the product more expensive).

    Initial amountDiscountResulting amount
    10.005.005.00
    10.00-5.0015.00
    10.005%9.50
    10.00-5%10.50

Adding a new product rate to existing price plans


Use the Add New Product action to define rates for new products in existing price plans.

  1. Select the plan to which the new product should be added.
  2. In the Data Entry page, click 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, enter the information that is necessary to create the product (refer to the price plan fields table).

Add the new product to an existing price plan directly from the Products Data Entry page, when creating the product.


Creating a conditional price plan


Conditional price plans can be used for billing jobs or subscriptions, subject to two types of conditions, defined in the price plan:

  • Selection Conditions must be met to make the price plan available.
  • Validity Conditions must be met in order to use the rates for billing. 
    Selection conditions can change from the time a price plan is set until it is billed. It is recommended to have the same conditions defined for selection and validity.
    If validity conditions are not met during billing, then the system will use rates from the base price plan that was used when creating the conditional 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.

  1. Click on NEW from the Actions menu to create a new plan.
    1. Provide the mandatory information in the price plan fields table (like in base price plans).  

      Important: Select a Base Price Plan for the system to use in case the selected conditional price plan conditions are not met during billing.

    2. Rates: Available rates from the selected base price plan are displayed. Change the rates individually or use the Replace Price Plan action to change all the rates simultaneously by a specific percentage value.
    3. SELECTION & VALIDITY CONDITIONS (The process for adding selection or validity conditions is identical) 

      Follow the steps below:
      1. Under 'Evaluation Settings' select:

        1. General: whether 'Criteria in all condition groups should be met' or 'Criteria in at least one condition group' should be met

        2. Condition Group Specific: whether 'Criteria in all condition rows should be met' or 'Criteria in at least one condition row' should be met.

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

        1. Click to ADD a new row, or ADD FROM TEMPLATE (a saved row that was used previously with preset values, such as for type and operator) to select an existing condition group row.  

        2. Type: Select from the drop-down list.
        3. Operator: Select whether the defined values should be 'Equal' or 'Not Equal'.
          1. ValueADD VALUES from the modal for each selected condition group row.
            1. Specify whether all values, or at least one, defined in the modal should be met.
            2. Value 1 - Value 20: Use Quick Search or click on the magnifying glass for a search modal to select the values to be used as conditions.

        4. Save as Template: Save the values for each condition group as a template, so that it can be used again with condition groups of the same type.
          1. Click on SAVE AS TEMPLATE and provide a name and description.
          2. Once all the condition group rows are complete, repeat the process for a new condition group.
        5. Select the Allowed Organisational Units which are authorised to select and assign the Price Plan.
        6. SAVE the Price Plan.

 

Selection and Validity Conditions

Each condition group type selected in the condition group has different available values:

TypeEvaluated against

Only available for 'Selection conditions'

Subscription TypeSubscription type of the subscription being billed.
Billable Entity MaturityMaturity of the billable entity; whether it is a new or existing subscription or job.
Billable Entities Existing ProductsPhysical goods or services added to the subscription or job. 
Billable Entities Products To Be AddedProducts that will be added to the subscription or job.
Billable Entities Existing Price Plans

The price plan already used by the subscription or job
(Applicable only when the billing term scheme is modified using the 'Amend Billing Terms' action through jobs or subscriptions).

Billable Entities Owner GroupsGroup that owns the subscription or job. 
Accounts Receivable ClassificationsClassification of the account owner of the subscription or job. 
Accounts Receivable Credit RatingsCredit rating of the account owner of the subscription or job. 
Accounts Receivable Payment PreferencePayment preference of the account owner of the subscription or job. 
Billing Term SchemeBilling term scheme of the subscription or job. 
Billing Terms Binding StateBinding state of the subscription; i.e., whether the subscription is in or out of binding. 
Billing Terms Binding PeriodBinding period of the subscription; e.g., for one or two years. 
Billing Terms Billing FrequencyBilling frequency of the subscription; e.g., monthly or annual. 
SegmentationAccounts receivable that belong to a selected segment. 

 

Defining product bundle pricing



A product bundle is a combination of component products offered for sale as one product, such as a single package including multiple channels.  Fixed Bundle Products have a fixed selection of constituent products as components.  Flexible Bundle Products are available for termed services and have a variable selection of constituent products as components.  The price of a fixed bundle product is set as that of a regular product.

Flexible bundle products allow the user to define prices at:

  • Bundle level; i.e., one price for all included products.
  • Product level, and differentiate when a product is sold as a stand-alone or part of a bundle.
  • Both bundle and product levels.

To add a rate at bundle product level:

  1. Add the product to the price plan.
  2. Provide the information required in the 'Rates' section.
  3. Leave 'Applicable Only If Part of Bundle' empty. 

To add a rate for a product when provided through a bundle:

  1. Add the product to the price plan.
  2. Provide the information required in the 'Rates' section.
  3. Under 'Applicable Only If Part of Bundle' select the bundle that the product is part of.

To add a rate for a product that is sold as a standalone product and as part of a bundle:

  1. Add the product to the price plan.
  2. Provide the information required in the 'Rates' section.
  3. Leave 'Applicable Only If Part of Bundle' empty
  4. Add the product to the price plan again.
  5. Provide the information required in the 'Rates' section.
  6. Under 'Applicable Only If Part of Bundle' select the bundle that the product is part of.


 
 Back to top

Applying business flows on price plans

Bulk adjustment of rates based on tax changes


Price plan adjustment run definitions enable the user to set up rules so as to reflect changes in VAT or other taxes across all affected price plans.

  1. Create the definition.
  2. Set the scheduling setting.
  3. SUBMIT the definition.

Once the run is completed, new rates for affected products will be calculated and a new version of each affected price plan will be created.

Do not use adjustment runs if price plan rates are not tax inclusive.

Refer to Tax Definition for more information.

 

 Finance Application > Products and Pricing > Price Plans > Perform Price Plan Adjustment Runs

Price plan adjustment run definition fields

The table describes the sections of the Perform Price Plan Adjustment Runs Data Entry page and explains how the fields in the page are used.

 Mandatory   Configurable

Criteria
VAT Rates

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

VAT Rates: At least one should be specified, several can be selected.

Price PlansA selection of plans on which the adjustment will apply.
Only effective price plans whose 'effective date' is before the 'VAT Rate Change as of Date' can be selected.  If none are specified, then all will be considered.

Products

 

 

Products to be adjusted / not to be adjusted 

A selection of products and/or product types, whose rates should or should not be adjusted.
If no products are specified, then the rates 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 a description of the error is displayed.
Scheduling Settings

Select whether to run the process now or on a specific date and time.

 

Back to top 

Price Plans Business Example

Scenario

Company ZX wants to set rates for its products, according to its billing requirements:

  • TV Subscription Start-up fee.
    • Start-up fee: €5

  • Installation Service Fee, with a tiered rate, based on duration.

    • 1 hour: €20/hour
    • 2 to 5 hours: €15/hour
    • 6 or more: €10/hour
      E.g., a five hour installation is billed €80 [(1*20)+(4*15)].

  • Repairs, with a flat rate, based on duration.

    • 1 hour: €20/hour
    • 2 to 5 hours: €15/hour
    • 6 or more: €10/hour
      E.g., a repair that takes five hours is billed €75 (5*15).

  • Antennas, with a flat rate, based on quantity.
    • 1 unit: €10
    • 2 units: €9
    • 3 units: €8
    • 4 units or more: €7.
      E.g., purchasing three antennas costs €24 (3*8).

  • Decoders, with a tiered rate, based on quantity.
    • 1 unit: €10
    • 2 units: €9
    • 3 units: €8
    • 4 units or more: €7.
      E.g., purchasing three decoders costs €27 (10+9+8).

  • VOD Service fee, with a flat rate, based on the number of distributors that the service is supplied to.

    • One Main Distributor (1): €5
    • Main and Twin 1 Distributors (2): €4
    • Main, Twin 1 and Twin 2 Distributors (3): €3
    • Additional distributors (4 or more): €2.
      E.g., viewing from three different boxes costs €9 (3*3).

  • PPV Service fee, with a tiered rate, based on the number of distributors that the services are supplied.

    • One Main Distributor (1): €5
    • Main and Twin 1 Distributors (2): €4
    • Main, Twin 1 and Twin 2 Distributors (3): €3
    • Additional distributors (4 or more): €2.
      E.g., viewing from three different boxes costs €12 (5+4+3).
  • Gold Service Subscription, based on a monthly fee with a free three month trial period.

      • The subscription is free for the first three months.
      • From the fourth month onward, the subscription costs €20/month.


Solution

Create the following Base Price Plan

  • Create the price plan
  • Add the rates to the plan
  • Refer to the table below for the rate type and model used to satisfy each requirement.
Product NameProduct Rate TypeRate ModelBase AmountTiered PriceComments
    Tier LevelFromToTier Amount 
Start-up feeExpenseFlat rate€5    

Tiered rates are not allowed for 'Expense' rate type

 
RepairsOne-time serviceFlat rate, duration based€10     
    111€20 
    225€15 
    36Unlimited€10 
 
Installation service FeeOne-time serviceTiered rate, duration based€20    

Five hours of repairs costs:

(1*20) + (4*15) = 80

    111€20 
    225€15 
    36Unlimited€10 
 
AntennaPhysical goodFlat rate, quantity based€10    

Purchasing three antennas costs:

3*8 = €24

    111€10 
    222€9 
    333€8 
    44Unlimited€7 
 
DecoderPhysical goodTiered rate, quantity based€10    

Purchasing three decoders costs:

10+9+8 = €27

    111€10 
    222€9 
    333€8 
    44Unlimited€7 
 
GoldTermed serviceTiered rate, maturity based€20    

A subscription billed for a year is billed:

(3*0) + (9*20) = €180

    1130 
    23Unlimited€20 
         
VOD serviceTermed serviceFlat rate, quantity based€5    

Service is distributed on four distributors:

4*2 = €8

    111€5 
    222€4 
    333€3 
    44Unlimited€2 
         
PPV ServiceTermed serviceTiered rate, quantity based€5    

Service is distributed on four distributors:

(1*5) + (1*4) + (1*3) + (1*2) = €14

    111€5 
    222€4 
    333€3 
    44Unlimited€2 

Notes

 

Glossary  

CRM.COM TermDefinition
Usage ServiceA product (usually a service) provided on customer request and billed based on its 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.
ActivityA small task or action that is either stand-alone or must be completed as part of a larger project.
ExpenseA service that is provided (usually on customer request) and billed once for a fixed amount.
Termed ServiceA service that is provided continuously and billed for a recurring period, regardless of usage.
Physical GoodA tangible item that is provided to the customer, such as a camera, decoder or magazine (generally with exclusive ownership); can be traceable or non-traceable.
One-time Service

A service (usually requested by the customer), which is provided and billed once, based on duration.

  

Provisioning Distributors

An abstract layer used in CRM.COM to relate subscription services (e.g., broadband service) and subscription associated devices (e.g., modems) to a provisioning provider and to define what services will be available from each device (if more than one is available on a subscription).

SegmentsLists of records in CRM.COM based on conditions that are defined using CRMQLa CRM query language developed by CRM.COM.

 


 

  • No labels