Labor Sold - Analytics

Use the Labor Sold tab under the Sales category on the Analytics menu to see a detailed view of sales by hours. Sales are divided by department (Body, Paint, Mechanical, and Frame), then divided by a user-definable number of production employees to achieve a business forecast of resources or technicians needed.

Note: The Repair Order number appears red if the job was considered a FastLane job.

Use the Labor Sold Tab

On the Analytics menu, click Sales > Labor Sold.
Enter the desired criteria and click the Apply Filter button.
If desired, select the Normal Jobs Only check box. This will exclude repair orders with unusual or unique criteria.
If applicable, select the Include Multi-Shops check box. A new area appears at the bottom right of the tab, listing the shops in your network. Select the shop or shops to be included.
Click the Exclude by Job Type button to open a box from which you can select job types to be excluded from the listing. Select the desired check boxes, then click OK.
From the Date field, select one of the following from the list: Sold, Due In, Due Out, Completed, Delivered, or Closed. Then enter the range of dates.
In the Select field, choose a repair type. All is the default. If any other type is selected, an additional field (having) appears, from which you can further define criteria. For example, if you select Insurance Company, the having field would be where you would identify the specific insurance company.
Once you have entered the desired criteria, click the Apply Filter button. Totals are shown in the bottom section of the tab.
All information in the bottom section of the tab is read-only, except for the number of technicians (Num Techs). Change the number in this field, then click the Apply button to see the adjustment in Average Hours per Day - Hours per Tech.
If you selected Include Multi-Shops in step 5, you can change the number and selection of shops to be included in the calculation. Click Select All to include all shops listed; click Clear Selections to clear all check boxes; click the Apply button to implement the changes you've made.

Reference

The Labor Sold tab consists of three parts: The list of repair orders and information specific to each repair/vehicle; the criteria fields and filters (dates, etc.); and the results/totals in the bottom section of the tab.

Labor Sold Tab Fields

Field	Description
Columns
Sold	Date the labor (the repair job) was sold.
RO	Repair order number.
Last Name	Last name of the vehicle owner.
F	First name of the vehicle owner.
Yr	Year of the vehicle.
Make	Make of the vehicle.
Model	Model of the vehicle.
Due In	Date the vehicle is due to come into the shop for repair.
Due Out	Date the vehicle is due out of the shop after the repair is complete.
Estimator	Name of the estimator who wrote the original estimate.
Insurance	Name of the insurance company associated with the repair order.
Total Hrs	Total number of labor hours associated with the repair order.
Body	Number of hours estimated for the vehicle repair to be in the body department.
Paint	Number of hours estimated for the vehicle repair to be in the paint department.
Frame	Number of hours estimated for the vehicle repair to be in the frame department.
Mech	Number of hours estimated for the vehicle repair to be in the mechanical department.
Other	Number of hours estimated for the vehicle to be in another area of repair.
Job Type	Type of job, such as On Hold, Customer Pay, Direct Repair Program, Standard Repair, etc.
Buttons, Check boxes, and Filter Boxes
Normal Jobs Only	Select this check box to exclude jobs that were placed in your FastLane Schedule.
Exclude by Job Type	Button used to exclude specific types of jobs from the tab and from the calculations.
Print	Button used to preview the Vital Signs - Hours Sold report. To print the report, use the printer icon in the top left corner of the report.
Print Summary Only	Check box used to restrict the info on the tab and in the report to summary only.
Date	Date type; select from the following choices listed: Sold Due In Due Out Completed Delivered Closed
between	The beginning and ending dates of the filtering date range; calendars to select dates.
Select	Field to choose filters on the information contained in the tab. From the list, select either All (default), Make, Estimator, Insurance Company, or Job Type. If you select an option other than All, an additional field, having, is provided to choose or enter additional criteria.
Apply Filter	Button used to implement selected filtering criteria.
Bottom Section
Total Hrs	Total number of hours in a specific area of repair.
Avg Hrs per Job	Average number of hours per job for a specific area of repair.
Body	First row: Total number of hours of labor in the body department for repair. Second row: Average number of hours of labor per job for the specific area of repair.
Paint	First row: Total number of hours of labor in the paint department for repair. Second row: Average number of hours of labor per job for the specific area of repair.
Frame	First row: Total number of hours of labor in the frame department for repair. Second row: Average number of hours of labor per job for the specific area of repair.
Other	First row: Total number of hours of labor in another department for repair. Second row: Average number of hours of labor per job for another area of repair.
Total	First row: Total number of hours of labor in all repair departments. Second row: Average number of hours of labor per job in all repair departments.
Average Hours per Day	Box listing average number of hours per day (categories below).
Hours	Average number of hours per day for all repair jobs included in the tab .
Hours per Tech	Average number of hours per technician, per day for all repair jobs included in the tab.
Num Techs	Average number of technicians working on the repair jobs, per day. (This field is a variable that can be changed.)
Apply	Button used to apply the number of technicians specified in the filtering box to the left of the button.