ID150
Contract Profitability by Rolling Month
Output Type: SSRS Report
Contract / Customer Profitability Report is an On Demand SSRS Report providing profitability details by contract. Can be used to show best and worst performing contracts based on gross margin.
Related Alerts
| ID # | Description | Notes | Required |
|---|---|---|---|
| ID334 | HouseKeeping CEOJuice Background Tables | 334 must be run nightly in order for the custom report 150 to be accurate daily!! The task 150 alert updates the report for the schedule of the task, but since we created an on demand custom report it requires that the 150 table be updated nightly! | Yes |
| ID219 | Service Call Closed with potential bad data entered | In order to insure the accuracy of ID150 contract profit alert, please install ID219. | No |
| ID560 | Low profit contract up for renewal/escalation | ID150 looks at all contracts each month and alerts on low profits, ID560 looks at contracts up for renewal with low profits. | No |
| ID768 | Biggest problem contracts without a plan | ID150 is just a custom report now, ID768 will email a list of your bottom worst contracts. | No |
| ID174 | Contract change audit | Typically contracts increase by X% on the anniversary date, the base rate and the overage rate will increase but the credit rate for underages does not change. ID174 helps monitor this, change the credit rate when this report is received. | No |
| ID399 | [Contracts] Contract Profitability Sub - Action Notes | SubReport Required for ID150 SSRS | Yes |
| ID400 | [Contracts] Contract Profitability Sub - Bad Data View | SubReport Required for ID150 SSRS | Yes |
| ID401 | [Contracts] Contract Profitability Sub - Contract Notes | SubReport Required for ID150 SSRS | Yes |
| ID402 | [Contracts] Contract Profitability Sub - Contract Rates | SubReport Required for ID150 SSRS | Yes |
| ID408 | [Contracts] Contract Profitability Sub - Profit Model | SubReport Required for ID150 SSRS | Yes |
| ID555 | Contract & Transactional Analysis eView | No | |
| ID576 | Daily Housekeeping Tasks | Yes | |
| ID923 | Contract MIF Analysis | The MIF report uses the data rolled up from id150's ZCJ_ContractAnalyticTable_UpdateRM stored procedure that updates the table [ZCJ_ContractAnalyticProfitAlert_RM] | Yes |
| ID472 | Metered Contract Performance Report | No |