Report of low profit contract up for renewal/escalation
Jump to Overview | Samples | Variables | Alert Functionality | Best Practices & Tips | Related Alerts
Overview
Overview
When possible, Best Practice is to evergreen your service contracts (auto renew) with a clause in your contract that allows you to increase the rate each year. Then set up eAutomate to have automatic rate increases for base and overages. Typically you review each contract before renewing and perhaps have a larger increase for a less profitable contract. Typically we see dealers auto increase contracts by 10% each year. This alert will tell you about contracts up for renewal with low profit margin in last VariableW (12 or 24) months due to expire (or has a scheduled price increase) in the next 90 days.
Run Schedule: Monthly on 1st AM
Type of Output: Email
* * *
Sample
Sample
* * *
Variables
Variables
Variable W: Rolling Periods Back to Report (Enter RMXX - options RM02 to RM24)
Variable X: Contract Type Code(s) to consider (separate list with comma) or blank for ALL
Variable Y: Enter Number of Minimum Months Contracts should be Active
Variable Z: Custom Property on Contract Record for Snooze Date
Variable 1: Enter number of contracts to report on to limit output quantity or lave at 9,999 to report on ALL
Variable 2: Note Type Code used on Contract notes for action plan
Variable 4: Contract with a lower GP Percent to report on (numbers only, no % please)
Variable 5: Enter 'Contract' to reference the Sales Rep assigned to the Contract, or 'Customer' to reference rep assigned to the customer per CRM else the customer per eAuto
Variable 5: To limit which branches alert considers, enter Branch Numbers you do wish to the alert to consider
* * *
Alert Functionality
Alert Functionality
-If contracts are terminated or have another increase date set for after the date it’s reporting then they fall off the list.
-The contract profitability alert (ID768) is reporting the worst XX contracts, whereas the CEOJuice Contract Analytics Customer Profitability report groups/ranks the performance at the CUSTOMER level. So the worst XX contracts in this alert may not match the worst XX Customers for the same contract types (a customer might have multiple contracts of the same type that total up to a different overall performance level than an individual contract).
-Alert considers Expiration Date on Contract Record of Expiration Date of upcoming scheduled rate increase.
Expiration Date on Contract Record:
Contract Rate Schedule details (alert would fire from sample below 90-days prior to 8/27/2021):
Auto Rate Schedules can be set as follows:
At Contract Base Rate Level:
At Meter Group Level:
At Meter Group Detail Level:
-Alert does NOT monitor At Equipment Detail Level:
Column Headers Explanation:
Column Headers Explanation:
(1) Branch: Branch assigned at Contract Level
(2) EventActionDate: Date of upcoming expiration
(3) EventSource:
Contract ExpDate - contract has fixed expiration date in next 90-days
OR
Contract NextBaseIncreaseDate - contract has auto increase set on base rate in next 90 days
OR
Contract NextOvgIncreaseDate - contract has auto increase set on overage rate in next 90 days
(4) Period Margin / PeriodMarginPct / Period Revenue / Period Cost: Period is for number of months set in your VariableW and is at Contract Level (not Customer or Parent Customer Level). The revenue is revenue accrued thus far and not revenue billed if a period is billed in advance.
(5) ContractLifeMargin / ContractLifeRev / ContractLifeCost: Contract Level for entire life of contract (as long as it has been active)
(6) CustPeriodMargin / CustLifeTimeMargin: Customer Level for life of Customer in eAuto
(7) NPS Score: Customer's NPS Score for reporting period (per VariableW)
(8) SnoozeDate: If contract was snoozed, then will show snooze date populated in Custom Property ZCJProfitAlertSnooze
(9) ActionNote: If notes listed on Contract under Note Type of ReviewAction, those notes populate here
Snoozing:
Snoozing:
To "snooze" a contract so it disappears off our ID560 report until snooze date reached. Go to the Custom properties tab:
1. Enter date to snooze (Contract will not report on ID560 until that date is reached) on Contract Record Custom Properties ZCJProfitAlertSnooze:
2. Enter Note on Contract Record indicating research results and action(s) to be taken:
Be sure to use Note Type of Review Action to explain why snoozed and what to do once ready to review again:
* * *
Best Practices & Tips
Best Practices & Tips
-See THIS LINK on Best Practices for setting automatic contract rate increases
-Use On Demand SSRS Report ID150 Contract Profitability to review profitability details, CLICK HERE on how to best run
Custom Property Set Up
To create Custom Property for snoozing contracts:
Step 1: Create Custom Property Attribute name via Tools / Lists & Codes / Attributes
Attribute name: ZCJProfitAlertSnooze
Description: Snooze contract from showing on reports until date
Data type: Date
Step 2: Add this Attribute to Contract Custom Properties Configuration via Tools / Lists & Codes / Configurations (custom properties, select Contract Properties Group
Use available attribute(s) drop down to quick add ZCJProfitAlertSnooze (no default value), select OK:
Step 3: Create Note Type Revie Action via Tools / Lists & Codes / Note Types:
Be sure to check off "Allow changes. edits, and deletions of notes of this type"
* * *
Related Alerts
Related Alerts
ID150 - Contract Profitability
ID174 - Contract Change Audit
ID261 - Contracts with no scheduled increases or escalations setup for base or overage
* * *
0 Comments