Versions Compared

Key

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

The NTE Optimization Dashboard 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.

Panel
bgColor#F9F9F9
titleColor#0e3367
titleBGColor#EAEAEA
borderStylenone
title⦿ How to access the NTE Optimization Report

From Service Automation:

  1. Click the menu icon Image Removed, and then select Analytics (ProView).

  2. On the upper-right of the page, click Click here to view more reports...

  3. On the upper-left of the page, click the dashboards list down arrow and select NTE Optimization.

Image Removed

From other Analytics dashboards:

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

Image Added

NTE Optimization Sections

NTE Optimization accounts for all of the relevant trades used to compile the metrics. This report is comprised of 2 parts:

Image Removed

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

Image RemovedImage Added

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

Image RemovedImage Added

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

You can download this report onto your local drive for sharing, viewing, and further data manipulation.

Anchor

filters
  • Click the down arrow (column headers) or the right arrow (row headers) to sort from highest to lowest / Z - A / latest to earliest. Click it again to return to the default sorting.
  • Column
    width30%

    Image Removed

    Image Removed

    AnchordownloaddownloadDownloading Reports

    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 iconImage Removedappears 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.

    Panel
    bgColor#F9F9F9
    titleColor#0e3367
    titleBGColor#EAEAEA
    borderStylenone
    title⦿ How to download an individual report
  • On the desired table, mouseover the table title. The download iconImage Removedappears.

    Image Removed

  • 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
    bgColor#F9F9F9
    titleColor#0e3367
    titleBGColor#EAEAEA
    borderStylenone
    title⦿ How to download all reports
    1. On the top-right of the screen, click the gear icon.

      Image Removed

    2. Choose the desired format:

      1. Export to PDF saves the current page view as a PDF file. Only the data immediately listed on the page will appear in the PDF export.

      2. Export to XLSX saves all data in a Microsoft Excel XLSX spreadsheet. Each table is saved on a different Excel tab.

    3. When prompted, save the report to your drive.

    commondatafeatures

    filtersReport Filters and Sorting

    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.

    Image Removed

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

    Image RemovedYou can also schedule the report to email to your inbox, print a PDF version of the full report, and export the full report to MS Excel. See Analytics Settings for more information.

    Anchorsortsort Info
    titleSorting Table Data (where available)
    Section Column
    width70%
    Click the up arrow (column headers) or the left arrow (row headers) to sort data from lowest to highest / A - Z / earliest to latest. Click it again to return to the default sorting.

    commondatafeatures

    Insert excerpt
    All Calls Tab
    All Calls Tab
    nopaneltrue

    Live Search
    spaceKeySCU
    additionalpage excerpt
    placeholderSearch our Knowledge Base
    typepage

    Panel
    titleColor#ffffff
    titleBGColor#5fa7d0
    borderStylegroove
    titleIn this Article

    Table of Contents
    maxLevel3
    minLevel2
    indent20px

    Image Modified

    Panel
    titleColorwhite
    titleBGColor#75a346
    titleRelated Articles

    Filter by label (Content by label)
    showLabelsfalse
    max8
    showSpacefalse
    sorttitle
    cqllabel = "label" in ( "enhancedanalytics" , "analytics" , "budgets" , "nte" , "facilitiescost" , "facilitiescosts" ) and space = currentSpace ( )