Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Anchor
top
top

Excerpt
hiddentrue

Learn to work with Price plans

...

Price plans are the set of rates at which a company offers goods and 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 whose rates are defined in in Usage Service Catalogs. 

Price plans functionalityfunctionality 

  • 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.

...

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

Price PlanImage RemovedImage Added


Anchor
rate_model
rate_model
Price plan rate models

The classification of each product determines the rate models available when  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.

...

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.

Note

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).

Note

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.

...

Back to top 

Using Price Plans

Note

Actions are subject to validations that Validations take place before an action is initiated (prerequisite) or after it is submitted (postcondition).

Several 'Effective' price 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'.

...

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 to add new product rates or  rates or amend price price plans that are already in use by subscriptions or jobs.

...

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.

...

  1. Find the price plan to amend and from its Data Entry page, click click Replace in the Actions menu to open the Replace Price Plan modal.
    1. Define the New 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. 

...

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  use Calculate Amount to to enter a discount, expressed as an amount or percentage.  The discounted price is calculated and set automatically.

  1. While on 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.

...

  1. Select the plan to which the new product should be added.
  2. In the Data Entry page, click Add 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 plan fields table).
Tip

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

...

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 must be met to make the price plan available.
  • Validity Conditions 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.

...

  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).  

      Note

      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 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 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 Allowed Organisational Units Units which are authorised to select and assign the Price Plan.
        6. SAVE SAVE the Price Plan.

 

Note
titleSelection 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. 

...

Anchor
bundle
bundle
Defining product bundle pricingpricing

...


A product bundle is a combination combination of component products offered for sale as one product, such as as a single package including multiple channels.    Fixed Bundle Products Products have a fixed selection of constituent products as components.    Flexible Bundle Products are 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.

...

  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. Leave 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.

...

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.

...

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

Refer to Tax Definition for for more information.

 

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

Image RemovedImage Added

Price plan adjustment run definition fields

The table describes the sections of the Perform Price Plan Adjustment Runs Data Entry page 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.

...

Price Plans Business Example

Panel
nameblue

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€10Tier Level From To Tier Amount  
    111€20 
    225€15 
    36Unlimited€10 
 
Installation service FeeOne-time serviceTiered rate, duration based€20Tier Level From To Tier Amount 

Five hours of repairs costs:

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

    111€20 
    225€15 
    36Unlimited€10 
 
AntennaPhysical goodFlat rate, quantity based€10Tier Level From To Tier Amount 

Purchasing three antennas costs:

3*8 = €24

    111€10 
    222€9 
    333€8 
    44Unlimited€7 
 
DecoderPhysical goodTiered rate, quantity based€10Tier Level From To Tier Amount 

Purchasing three decoders costs:

10+9+8 = €27

    111€10 
    222€9 
    333€8 
    44Unlimited€7 
 
GoldTermed serviceTiered rate, maturity based€20Tier Level From To Tier Amount 

A subscription billed for a year is billed:

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

    1130 
    23Unlimited€20 
         
VOD serviceTermed serviceFlat rate, quantity based€5Tier Level From To Tier Amount 

Service is distributed on four distributors:

4*2 = €8

    111€5 
    222€4 
    333€3 
    44Unlimited€2 
         
PPV ServiceTermed serviceTiered rate, quantity based€5Tier Level From To Tier Amount 

Service is distributed on four distributors:

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

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

 

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.
Panel
namegrey

Related Links

Filter by label (Content by label)
showLabelsfalse
spacesV4Manual
showSpacefalse
labelsglobal