Estimating Productivity Report

This report is used to view the predefined productivity parts metrics based on the organization resource hierarchy. With this report you can track total estimate and supplement numbers, cycle times, and productivity measures.

To view a Estimating Details report

In the Report Navigator, under Mitchell Reports, WorkCenter Estimating, click Estimating Productivity Report.
Set the filter criteria for your report (see Screen Components below).
Click View Report.

The system retrieves the data, then the report appears in the workspace.

Reference

Screen Components

Filter	Definition
Region	Lists the available regions. Click to select the applicable region.
Division	Lists the available divisions based on selected region. Click to select the applicable division.
Office	Lists the available offices based on selected division. Click to select the applicable office.
User	Lists the available users based on selected office. Click to select the applicable user.
Estimate Repairability	List the available values - Unknown Estimate Repairability, Total Loss, Partial Loss. This identifies the vehicle as a Partial Loss (Repairable) or a Total Loss as selected when writing the estimate.
Estimator Type	The estimator type is based on the user who created the estimate. Lists the available values - Body Shop, Independent, Staff, Unknown Estimator Type.
Vendor Type	Vendor Type identifies the estimating system used to create the estimate. Lists the available values - Unknown Estimate Vendor, Mitchell International, CCC, Audatex
Inspection Type	This identifies where inpection took place. Lists the available values - Audit, Drive-In, Field, Other Inspection Type, Unknow Inspection Type.
Drivable Condition	This identifies the vehicle drivable condition. Lists the available values - Not Available, Unknown Vehicle Drivable Indicator, Vehicle Drivable, Vehicle Non-Drivable.
Date Range	The Date Range filter is based on Original Commit Date. If a specific date range is selected from the dropdown such as YTD and the start and end dates are changed, the report will still display data for YTD. The date range 'Custom' must be selected before start and end dates can be applied to a report.

Report Definitions

Column	Definition
Region	This is the selected region names. e.g. If the selected hierarchy level is "All Regions" then a list of region names will be displayed. These are hyperlinks and if selected will display the next hierarchy level. The User level name is the lowest hierarchy level on this report.
# Ests	Total number of Original Estimates, based on the date committed. Does not include supplements.
# Supps	Total number of supplements. This is a productivity figure which represents Supplement volume activity. Example - if one estimate has two supplements and another has three the total is five. Supplements are counted in the month they are received.
# Ests Supp	Total number of estimates with one or more Supplements. Based on the commit date of the original estimate.
# Supps for own Origs	Total number of supplements created by the estimator for his own originals. When a supplement is received and the estimator is the same as the estimator who created the original, the supplement is flagged as being created by this original estimator for his own original. Example: Estimator A creates the original and also creates the supplement. The supplement will be included in this total for Estimator A.
# Supps for other Origs	Total number of supplements created by the estimator for originals that were created by another estimator. When a supplement is received and the estimator is a different estimator than the estimator who created the original, the supplement is flagged as being created by this estimator for an original that was created by another estimator. Example: Estimator B creates the original and Estimator A creates the supplement. The supplement will be included in this total for Estimator A.A.A1
Supp Delta Amt	The difference between the Gross dollar amount of the prior version (current supplement version minus 1) and the Gross dollar amount of the current supplement. The prior version may have been written by a different estimator. It may also have been written in a different month than the current supplement version.
Avg Supp Delta Amt	Total Supp Delta $ amounts divided by the number of supplements used to calculate the Supp Delta $.
% Partial Loss	The percentage of all estimates in the estimate count that are repairable based on the most recent version of the estimate.
% Total Loss	The percentage of all estimates in the estimate count that are total losses based on the most recent version of the estimate.
% Orig Ests Suppl'd	Total number of original estimates with one or more supplements as a percentage of the total number of original estimates received. All estimates are flagged as being the latest or not the latest version of the estimate family. If the estimate is an original and is not the latest version then this is counted as being supplemented. Supplements may have been written by a different estimator. They may also have been written in a different month than the original version. Example: Estimator A created original version 0 Estimator B created supplement version 1 # Originals that were supplemented for Estimator A = 1+A1