Contract_Profitability

In the Contract Profitability factbox, the individual components of the total profitability are listed as the profitability of the contract (the sum of partial values).

The values are predicted – they do not take into account, for example, the actual costs of services, interest, etc., and are calculated if payments are calculated without a payment schedule or with a payment schedule.

• Interest Margin

  • Displays the value of an even field from a financing contract (hidden field)

  • Filling the field (calculation) is different depending on the existence of the contract payment calendar:

    • If there is no payment calendar, the field is calculated by a formula when the Payment Calculation button is pressed. Formula:

      • Interest Margin=Financing Period (in Months)*(Annuity excl. VAT) - PMT (formula as for Annuity Excl.VAT, but using Reference Rate % instead of Calculation Interest Rate %(p.a))

    • If a payment calendar exists, the field is calculated as the sum of the Interest Margin values from the payment calendar. The Interest Margin field in the payment calendar is recalculated each time the payment calendar is recalculated on the unposted calendar lines as follows (ratio calculation):

      • Interest Margin = (Interest Margin % / Calculation Interest Rate % (150)) * Interest (16)

• Maintenance Margin

  • The system finds in the API Contract Service (4026681):

    • Services with Service Kind=Maintenance

    • In Status=Preparation|Active|Terminated|Change Copy (i.e. not in status=Cancelled)

  •  Maintenance Margin = sum of Margin Total values (85)

  •  When clicked, it opens the Services overview of the contract with a filter for the given services.

• Tyres Margin

  • The system finds in the API Contract Service (4026681):

    • Services with Service Kind=Tire Service

    • In Status=Preparation|Active|Terminated|Change Copy (i.e. not in status=Cancelled)

  •  Tyres Margin = sum of Margin Total values (85)

  •  Note: the set of services determined in this way will include all tires and services of the contract (tires, rafts, tire change, storage, accessories)

  •  When clicked, it opens the Services overview of the contract with a filter for the given services.

• Other Services Margin

  • The system finds in the API Contract Service (4026681):

    • Services with Service Kind=Fee/Service|Replacement Car|Highway Ticket|Fuel Card (i.e. services except Maintenance, Tire Service and Road Tax)

    • In Status=Preparation|Active|Terminated|Change Copy (i.e. not in status=Cancelled)

  •  Other Services Margin = sum of Margin Total values (85)

  •  When clicked, it opens the Services overview of the contract with a filter for the given services.

• Liability Ins.Margin

  • The system finds insurance contracts:

    • Product Base Type=Liability

    • Status=Preparation|Active|Closed|Change Copy, i.e. it will not take into account insurance policies in the Unrealised, Canceled status

  • Liability Ins.Margin = the sum of the Insurance Margin fields from the insurance contracts found in this way Insurance Margin is calculated on the insurance contract:

    • Insurance Margin = (Client Month Insurance Amount – Insurance Company Month Amount) * Insurance Duration (month)

  •  After clicking, it opens an overview of insurance contracts with a filter for the given insurance contracts.

• Property Ins.Margin

  •  The system finds insurance contracts:

    • Product Base Type=Property

    • Status=Preparation|Active|Closed|Change Copy, i.e. it will not take into account insurance policies in the Unrealised, Canceled status

  • Property Ins.Margin = sum of Insurance Margin fields from insurance contracts found in this way

  •  After clicking, it opens an overview of insurance contracts with a filter for the given insurance contracts.

• Other Ins.Margin

  • The system finds insurance contracts:

    • Product Base Type=Supplementary

    • Status=Preparation|Active|Closed|Change Copy, i.e. it will not take into account insurance policies in the Unrealised, Canceled status

  • Other Ins.Margin = sum of Insurance Margin fields from insurance contracts found in this way

  •  After clicking, it opens an overview of insurance contracts with a filter for the given insurance contracts.

• Contract Margin

  •  is the sum of Interest Margin+Maintenance Margin+Tires Margin+Other Services Margin+Property Ins.Margin+Liability Ins.Margin+Other Ins.Margin

A similar factbox can be found on the customer card – see detailed description Address book.

It is also possible to use the report in Reports/Customer Profitability to determine the customer margin – see detailed description Contract Changes.