Estimating Details Report

This report is used to view the predefined metrics based on the organization resource hierarchy. With this report you can view estimate details at the resource level to evaluate how an individual resource performs at the claim suffix level for the selected filters and time period.

To view a Estimating Details report

In the Report Navigator, under Mitchell Reports, WorkCenter Estimating, click Estimating Details 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

Report Filter	Definition
Estimating Hierarchy	Lists the available values - Original, Current. Current Hierarchy is the latest organizational company hierarchy for the current estimator. The current estimator is the estimator who wrote the latest estimate. Original Hierarchy is the latest organizational company hierarchy for the original estimator. The original estimator is the estimator who wrote the original estimate.
Region	Lists the available regions. Click to select the applicable regions. The user can select multiple regions.
Division	Lists the available divisions based on selected region. Click to select the applicable divisions. The user can select multiple divisions.
Office	Lists the available offices based on selected division. Click to select the applicable offices. The user can select multiple offices.
User	Lists the available users based on selected offices. Click to select the applicable users. The user can select multiple users.
Estimate Repairability	This identifies the vehicle as a Partial Loss (Repairable) or a Total Loss selected when writing the estimate. Lists the available values - Unknown Estimate Repairability, Total Loss, Partial Loss.
Vendor Type	Vendor Type identifies the estimating system used to create the estimate. Lists the available values - Unknown Estimate Vendor, Mitchell International, CCC, Audatex
Date Type	Contains the Original Commit Date. When an estimator commits the estimate the date is captured as Original Commit Date with the estimate information.Â Â Â Â Â
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	Name for the region to which the original/current estimator writing the estimate reports associated with region identification code.
Division	Name for the division to which the original/current estimator writing the estimate reports associated with region identification code.
Office	Name for the region to which the original/current estimator writing the estimate reports associated with region identification code.
Orig Estimator CD	User Code of the original estimator writing the estimate.
Orig Estimator Name	Name of the original estimator writing the estimate.
Curr Estimator CD	User Code of the current estimator writing the estimate.
Curr Estimator Name	Name of the current estimator writing the estimate.
Claim-Exposure Number	Claim Exposure represents a vehicle damaged in an accident and included within the Claim. Also known as Claim Suffix.
Supp No	Contains the version of the estimate. If this is 0 then this is the original estimate. If this is 1 then this is the first supplement.Â If this is 2 then this is the second supplement and so on.
# Days At Shop	Number of days vehicle is at shop
Vehicle Year	Vehicle Model Year
Vehicle Make	Vehicle Make
Vehicle Model	Vehicle Model
ACV Amt	The total Actual Cash Value using the Redbook Base Value / NADA Base Value, not including Options or mileage adjustments.Â UltraMate will continue to provide Canadian Redbook data for Canadian installations. UM 7.0: this figure represents the NADA value adjusted for options and mileage.
Repairability	This identifies the vehicle as a Partial Loss or a Total Loss as selected when writing the estimate.Â
Original Commit Date	Original Commit Date provides the ability to report on the commit date of the original estimate. When an estimator commits the estimate the date is captured with the estimate information.
Supplement Commit Date	Supplement Commit Date provides the ability to report on the commit date of the supplement. When an estimator commits the supplement the date is captured with the estimate information.
Loss Date	Date when the loss occurred.
Gross Amt	Total Gross dollar amount on all estimates. Includes all Labor Types, Additional Operations, Part Types, Markups, Discounts, Additional Costs and all Taxes. Customer Responsibility (Insurance Deductible, Betterment and Related Prior Damage) and Appearance Allowance have not been applied.
Net Amt	Net $ on the estimate. Includes all Labor Types, Additional Operations, Parts, Markups, Discounts, and Tax. Customer Responsibility (Insurance Deductible, Betterment and Related Prior Damage) and Appearance Allowance have been applied.
Total Part Amt	Total of Part amount includes all Part Types, Markups, Discounts and Tax. Sublet lines are included if the Labor Operation is Remove/Replace or Overhaul.Â All other Sublet Part $ amounts are applied to Labor. TruckEst: Tax is not included.
Total Labor Amt	Total of Labor amount includes all Labor, Additional Operations and Tax.Â Additional Operation amounts entered as a part dollar amount are also included. TruckEst: Does not include Additional Operations or Tax. Addl Ops are included in Additional Cost $.
Total Add'l Cost Amt	Additional Costs amount includes Towing, Storage, Coolant, Shipping, Lubricants, Rust Coating, Shop Materials, Paint/Materials, Estimate Charge, Detail/Cleanup, Hazardous Waste Disposal, SPCL Paint Materials, Flex Additive, Cavity Wax, Weld thru Primer, Freon & Oil , R12 Freon and Oil, R134A Freon and Oil and Tax.
Cust Resp Amt	The total amount of the customer payment responsibility on the estimate.
OEM Part Amt	Total OEM Part amount on the estimate. Markups, Discounts and Tax are included.
Aftermarket Part Amt	Total Aftermarket Part amount on the estimate. Markups, Discounts and Tax are included.
LKQ Part Amt	Total LKQ Part amount on the estimate. Markups, Discounts and Tax are included.
Reman'd Part Amt	Total Reman'd Part amount on the estimate. Includes Recored, Rechromed and Remanufactured part types.Â Markups, Discounts and Tax are included.
Sublet Part Amt	Total Sublet Part $ on the estimate. Sublet lines are included if the Labor Operation is Remove/Replace or Overhaul.Â All other Sublet Part $ amounts are applied to Labor. Markups, Discounts and Tax are included.
Total Part Qty	Total number of Aftermarket, LKQ and Reman'd parts as a percentage of the total number of parts on all estimates.
OEM Part Qty	Total number of New parts as a percentage of the total number of parts.Â Â
Aftermarket Part Qty	Total number of Aftermarket parts as a percentage of the total number of parts.Â Â
LKQ Part Qty	Total number of LKQ parts as a percentage of the total number of parts.
Reman'd Part Qty	Total number of Reman'd parts as a percentage of the total number of parts.Â Includes Remanufactured, Rechored and Rechromed parts.Â
Body Labor Amt	Body Labor dollar amount on the estimate. Includes Tax.
Body-Structural Labor Amt	Body-Structural Labor dollar amount on the estimate. Includes Tax.
Frame Labor Amt	Frame Labor dollar amount on the estimate. Includes Tax.
Mech Labor Amt	Mechanical Labor dollar amount on the estimate. Includes Tax.
Glass Labor Amt	Glass Labor dollar amount on the estimate. Includes Tax.
Refinish Labor Amt	Refinish Labor dollar amount on the estimate. Includes Tax.
Total Labor Hrs	The labor hours on the repair line are totaled: # Labor Hours = + Labor Hours on the repair line
Body Labor Hrs	If the Labor Type is Body Labor (LAB) then # Body Labor Hours = + Labor Hours on the repair line
Body-Structural Labor Hrs	If the Labor Type is Body-Structural Labor (LAS) then # Body-S Labor Hours = + Labor Hours on the repair line
Frame Labor Hrs	If the Labor Type is Frame Labor (LAF) then # Frame Labor Hours = + Labor Hours on the repair line
Mech Labor Hrs	If the Labor Type is Mechanical Labor (LAM) then # Mechanical Labor Hours = + Labor Hours on the repair line
Glass Labor Hrs	If the Labor Type is Glass Labor (LAG) then # Glass Labor Hours = + Labor Hours on the repair line
Refinish Labor Hrs	If the Labor Type is Refinish Labor (LAR) then # Refinish Labor Hours = + Labor Hours on the repair line
Body Labor Rate	The Labor Rates are the rates from the profile that was used when creating the estimate. If the total of Net Labor Amt for Body Labor (â€˜LAB) on the estimate > 0 then Total Body Labor Rate = + Body Labor Rate
Body-Structural Labor Rate	The Labor Rates are the rates from the profile that was used when creating the estimate. If the total of Net Labor Amt for Body-S Labor (â€˜LAS) on the estimate > 0 then Total Body-S Labor Rate = + Body Structural Rate
Frame Labor Rate	The Labor Rates are the rates from the profile that was used when creating the estimate. If the total of Net Labor Amt for Frame Labor (â€˜LAF) on the estimate > 0 then Total Frame Labor Rate = + Frame Rate
Mech Labor Rate	The Labor Rates are the rates from the profile that was used when creating the estimate. If the total of Net Labor Amt for Mechanical Labor (â€˜LAM) on the estimate > 0 then Total Mech Labor Rate = + Mechanical Rate
Glass Labor Rate	The Labor Rates are the rates from the profile that was used when creating the estimate. If the total of Net Labor Amt for Glass Labor (â€˜LAG) on the estimate > 0 then Total Glass Labor Rate = + Glass Rate
Refinish Labor Rate	The Labor Rates are the rates from the profile that was used when creating the estimate. If the total of Net Labor Amt for Refinish Labor (â€˜LAR) on the estimate > 0 then Total Refinish Labor Rate = + Refinish Rate
Deductible Applied	Deductible Applied amount is on the estimate. The deductible applied amount is part of the customer responsibility. This is deducted from the gross dollar amount with any additional customer responsibility amounts to arrive at the Net dollar amount.
Related Prior Damage Amt	Related Prior Damage Amt is on the estimate. The related prior damage amount is part of the Customer Responsibility. This is deducted from the gross dollar amount with any additional customer responsibility amounts to arrive at the Net dollar amount. Not available for TruckEst.
Betterment Amt	Betterment Amt is on the estimate. Includes Tax. Not available for TruckEst.
Appearance Allowance Amt	Total Appearance Allowance dollar amount on final versions of estimates (including estimates). The total of cash considerations given to vehicle owners in lieu of reports. Normally involves cosmetic damage which does not affect the safety or drivability of the vehicle.
Part Tax Amt	The total tax $ amount on the parts cost on the estimate.
Labor Tax Amt	The total tax $ amount on the labor cost on the estimate.
Add'l Cost Tax Amt	The total tax $ amount on the additional cost amount on the estimate.
Vendor Type	Vendor Type identifies the estimating system used to create the estimate. Like Unknown Estimate Vendor, Mitchell International, CCC, Audatex.
Loss Type	This identifies the type of loss. This is included when writing estimate. Possible values are - Collision, Comprehensive, Fire, Other, Property, Theft, Unknow Estimate Type of Loss.