The NTE Optimization ReportDashboard is designed to help you optimize the not-to-exceed amounts (or NTEs) configured to your trades. It also helps you understand the effectiveness of these NTEs from both an operational and a financial standpoint.
| bgColor | #F9F9F9 |
|---|---|
| titleColor | #0e3367 |
| titleBGColor | #EAEAEA |
| borderStyle | none |
| title | ⦿ How to access the NTE Optimization Report |
From Service Automation:
Click the menu icon
, and then select Analytics (ProView).On the upper-right of the page, click Click here to view more reports...
On the upper-left of the page, click the dashboards list down arrow and select NTE Optimization.
From other Analytics dashboards:
On the upper-left of the page, click the dashboards list down arrow and select NTE Optimization.You can download the data and email reports to recipients.
NTE Optimization Sections
NTE Optimization accounts for all of the relevant trades used to compile the metrics. This report is comprised of 2 parts:
- Headline Metrics that visualize essential statistics to help you analyze your NTEs; and
- NTE Optimization data table that breaks down NTE amounts and percentages by Trade.
Here, you can see data from the past 365 days (by default) or by the criteria set in the all-inclusive filters on along the top of the report.
NTE Headline Metrics
The key data in the headline metrics are as follows:
- % of Invoices within 95% of NTE: When analyzing this data, you want this percentage to be as high as possible. Should your invoice amounts be within 95%, you are operating your facilities in a comfortable range in with respect to your NTE.
- % of Invoices where Invoice Amount = NTE: When an invoice amount equals an NTE amount, your facilities operations are within budget but is are constrained because there is no room or margin.
- % of WO where NTE increased: You want to keep this metric as low as possible, as an increase in NTEs indicate that your company is not operating within your facilities budget, and thus have to spend more money than originally planned.
- % of WO where NTE changed: The difference between this percentage and the one regarding WO increasing represents the percentage of WOs who actually decrease the NTE. While this percentage as a whole includes WOs who increased the NTE, the difference is a positive percentage in that it signifies that certain WOs staying beneath the NTE and therefore saved your company money in other trades.
- Proposal to Work Order %: Denotes the proposals per WO ratio.
NTE Optimization Table
This report looks at each trade relevant to your facilities operations and looks deeper into various dollar amounts and percent changes in regards to NTE.
The following data is listed in the report, sortable by these column headers:
Trade: NTEs are configured by Trade. This helps you understand where you may be spending more money, or where you may be over/under your facilities budget.
Tip You can click Click the Trade to drill down into the list of associated work orders.
- Average Invoice Amount: Represent the average money spent per invoice for all invoiced WOs within a trade
- Original NTE: The original NTE, or maximum your company can spend, given to each trade
- Average NTE Amount: The actual NTE amount (on average) that is calculated amongst all invoiced WOs
- % Time NTE IncreasedIncrease: How many of the total invoiced WOs exceeded the NTE amount per trade
- Inv. Amt. = Current NTE (%): The percentage of invoice amounts that were equal to that of the NTE
- Inv. Amt. within 95% of NTE (%): The percentage of invoices that lie within 95% of your NTE
- # of WorkordersWork Orders: Total number of WOs completed within a trade
| Anchor |
|---|
| Column | ||
|---|---|---|
| ||
|
You can either download individual reports or download all reports into one file. Your reports will download with the criteria set in the global filters.
Downloading Individual Reports
When hovering your mouse over the data table, an icon
appears next to the table name. Click the icon to choose which format to download your report.
| Note |
|---|
The section title and the table title may have the same name. The table title is smaller and directly above the table. |
| bgColor | #F9F9F9 |
|---|---|
| titleColor | #0e3367 |
| titleBGColor | #EAEAEA |
| borderStyle | none |
| title | ⦿ How to download an individual report |
On the desired table, mouseover the table title. The download iconappears.
Click the icon, and then select Download As...
Choose the desired format (PDF, Microsoft Excel XLSX, CSV-formatted, or CSV-raw data).
| Tip |
|---|
When downloading tables to PDF, PDF (Landscape) is the recommended option. |
When prompted, save the report to your drive.
Downloading All Reports Into One File
You can download all the reports listed in this dashboard.
| Panel | ||||||||||
|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||
|
|
On top of the report are all-inclusive filters to help you hone in on key data. All reports on the page are affected by the criteria set in these all-inclusive filters.
You can filter this report by the following criteria:
- Word Order Call Date
- Category
- Priority
- Provider Name
| Tip |
|---|
Once you have your filters set, you can save the filter view so you can easily access the data. You can save multiple filter views, as needed. After setting your filters, click *Unsaved View on the top-right of the page, and then Save current view...
|
| title | Sorting Table Data (where available) |
|---|
| width | 70% |
|---|
|
| Insert excerpt | ||||||
|---|---|---|---|---|---|---|
|
| Live Search | ||||||||
|---|---|---|---|---|---|---|---|---|
|
| Panel | ||||||||
|---|---|---|---|---|---|---|---|---|
| ||||||||
|
| Panel | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||
|