Search Posts

Activity by Vehicle Report

Print Friendly, PDF & Email

The Activity by Vehicle Report gives you an overall look at transactions and sales activity for a specific date or date range. The first page gives you general information, as well as information related to a specified vehicle make. The second page is a detailed breakdown of sales activity by make, grouped by manufacturer.

The top half of the first page analyzes the average amount for each ticket, as well as mileage and service interval information for all vehicles serviced. Results include the following figures:

  • Average number of tickets per day of all vehicles serviced
  • Average ticket amount of all vehicles serviced
  • Base ticket amount (as set up in the Base Ticket Amount field on screen 1 of the Center Control File)
  • Average dollar amount over base amount of all vehicles serviced
  • Average year of all vehicles serviced
  • Average mileage of all vehicles serviced
  • Highest daily ticket average
  • Highest daily car count

The bottom half of the first page shows service information either for all vehicle makes and models or for the manufacturer or make you specified. It allows you to see the percentage of specific makes that were serviced as a part of the total number of vehicles serviced. You can also see the percentage of new customers, as well as the average number of service interval days and miles. Results include the following figures:

  • Percentage of vehicles serviced (all, specified manufacturer or specific make)
  • Average year of vehicles serviced (all, specified manufacturer or specific make)
  • Average mileage of vehicles serviced (all, specified manufacturer or specific make)
  • Percentage of new customers
  • Percentage of AF (air filter category) sales
  • Percentage of WB (wiper blades category) sales
  • Percentage of TR (tire rotation category) sales
  • Average service interval days
  • Average service interval miles

The second page is a breakdown of the sales activity for each manufacturer and shows information specific to each make within that manufacturer. For each manufacturer you will see the following information:

  •  Number of vehicles serviced
  • Percentage of vehicles serviced
  • Dollar amount of vehicle sales

This page will also show a subtotal for all of the manufacturer information combined for each make.

Printing the Report

Use the following steps to print an Activity by Vehicle Report:

  1. On the Main Menu, select Lubrication Menu.
  2. Select Customer Service Menu (4).
  3. Select Activity by Vehicle Report (6) to receive the Activity by Vehicle Report Control Screen.
  4. Fill in the report control parameters, explained below.
Field Description
Print Time on Report Printing the time helps you identify the most current report when the same report is printed more than once during a day. This field defaults to Y to print the time on the report. If you do not want the time to print on a report, type N. We recommend that you always print the time on a report.
Duplex This field appears for terminals that have report type 2 enabled in the Set Up Printer Controls screen. Duplex mode enables printing on both sides of the paper.

Note: This will only function on printers that support Duplex mode.
Number of Printed Lines per Page This value tells the computer how many lines to print on each page of the report. A typical 11-inch page can contain up to 66 lines, but this field defaults to 60 to allow three-line margins at the top and bottom of the page.

If you type 0 (zero) in this field, the report header does not print and the form feeds do not work.
Total Number of Lines per Page This field indicates the length of the paper in the printer. A typical 11-inch page contains 66 lines. Your system interprets a 0 or 66 in this field to mean that standard 11-inch paper is loaded in the printer. Because a 66 causes a form feed to take more time, accepting the default, 0, is recommended.
Print Report To This field tells the computer where to send the report. The following list contains the different selections available for this field.

  • 0 Printer – Sends report to the terminal’s default report printer immediately. (Default)
  • 1 Screen – Provides an on-screen view of a report. This can be used as a preview before you print it or when a hard copy of the report is not needed. The function keys at the bottom of the on-screen version allow you to move around to view the entire report.
  • 2 Disk file – Useful when you want an electronic copy of the report. If you select this option, you receive a prompt to enter the name of the report file. The file that is created can be copied to a USB drive or viewed later. This option is for advanced computer users.
    • If you use this option, we suggest you precede your report name with /tmp/. For example, at the prompt to enter the report name for a customer list, you might type /tmp/custlist. This is a good storage directory for temporary files.
Command Line Options The line at the bottom of the screen contains commands to print the report and to save or change the report settings.

  • Save – Press [F4] to save the current settings for the report. This is useful if a report is generated repeatedly with the same options. Do not save date selections because they may not be useful in the future.
  • Start – Press [F7] to submit the report to print on the printer, on the screen, or in a disk file. (Reports print in the order they are submitted.)
  • Again – Press [F9] to return to the top of the screen. This allows you to change any of the information you have entered on the screen before you submit the report.
  1. Press [F7] to receive the following screen.

  1. In the Enter Make Code field, type a vehicle make code or range of make codes you want to include on the report. Leave blank to print for all vehicle makes.
Note: Press [F1] for a list of make codes.
If you choose to leave this field blank, this report can take a long time to generate.
  1. In the Enter Manufacturer Code field, specify the vehicle manufacturer code you want to include on this report. You cannot fill in both specific make codes and manufacturer codes.
Note: Press [F1] for a list of manufacturer codes and the vehicle makes grouped in each one.

Codes:

    • D – Daimler/Chrysler
    • F – Ford
    • G – General Motors
    • H – Honda
    • N – Nissan
    • T – Toyota
    • V – Volkswagen
  1. Press [F7] to start the Activity by Vehicle Report. When the processing is complete, you return to the Customer Service Menu.

You can set up this report on the Set Up Closing Processes screen (1-6-3) to print automatically during closing processes.

Report Contents

Callout Item Description
1 Average # of Tickets/Per Day for All Vehicles Average number of tickets per day for a selected date or date range. Only dates that have at least one transaction will be used when calculating this number.
2 Average Ticket Amount for All Vehicles Average sales amount per ticket for store tickets. This is based on gross sales.
3 Base Ticket Amount The standard average ticket amount, as specified in the Base Ticket Amount field on screen 1 of the Center Control File (1-6-1-1).
4 Average Dollars Over Base for All Vehicles Average dollar amount of items sold above the base ticket amount.

Average Dollars Over Base = Average Ticket − Base Amount
5 Average Year of All Vehicles Serviced Average year of all vehicles serviced during the selected date or date range.
6 Average Mileage of All Vehicles Serviced Average mileage of all vehicles serviced during the selected date or date range.
7 Highest Daily Ticket Average Shows the highest daily ticket average (dollar amount) achieved as far back as you have run this report.

Note: For existing customers, this field will only show data as far back as you have specified in the Transactions field on screen 4 of the Center Control File (1-6-1-1).
 8 Highest Daily Car Count  Shows the highest number of cars serviced as far back as you have run this report.

Note: For existing customers, this field will only show data as far back as you have specified in the Transactions field on screen 4 of the Center Control File (1-6-1-1).
9 Percentage of ALL Vehicles Serviced  Shows the percentage of vehicles serviced during the selected date range. Shows ALL, MANUFACTURER (for example, FORD) or SELECTED.

Vehicles Selected ÷ Total Vehicles

ALL – Appears if you selected all vehicle makes to print on this report. This will show 100% if you selected ALL.

MANUFACTURER – If you selected a specific vehicle manufacturer, this will show the name of that manufacturer (for example, FORD) and the percentage of vehicles serviced for that manufacturer code compared to all vehicles serviced within the specified date range.

SELECTED – If you selected a range of vehicle makes, this will show SELECTED and the percentage of vehicles serviced within the make range compared to all vehicles serviced within the specified date range.
10 Average Year of ALL Vehicles Serviced Shows the average year of vehicles serviced within the specified date range for either ALL vehicle makes, a MANUFACTURER of vehicle makes or a SELECTED vehicle make.
11 Average Mileage of ALL Vehicles Serviced Shows the average mileage of vehicles serviced within the specified date range for either ALL vehicle makes, a MANUFACTURER of vehicle makes or a SELECTED vehicle make.
12 Percentage of New Customers Percentage of total vehicles that were new customers for the selected date or date range.
13 Percentage of AF, WB, TR Sales Percentage of total tickets that included sales of air filters, wiper blades or tire rotations.

Note: You must have the AF, WB, and TR service codes set up with these exact same codes on the Set Up Service Codes screen. The Include in History field on the Set Up Inventory Items screen must also be set to Y. If these are not set up correctly, no information will appear in this field.
 13 Percentage of AF, WB, TR Sales  Percentage of total tickets that included sales of air filters, wiper blades or tire rotations.

Note: You must have the AF, WB, and TR service codes set up with these exact same codes on the Set Up Service Codes screen. The Include in History field on the Set Up Inventory Items screen must also be set to Y. If these are not set up correctly, no information will appear in this field.
14 Average Service
Interval Days		 Average number of days between vehicle services for all vehicles for the selected date or date range. Only vehicles with more than one service will be used to calculate this number.
15 Average Service Interval Miles Average number of miles customers have driven between services since their last service. This looks at all service histories for all vehicles within the selected date or date range. Only vehicles with more than one service will be used to calculate this number.
16 (Manufacturer) Shows vehicles grouped by manufacturer. Depending on what you selected on the Report Control Screen, this will list a specific manufacturer or all manufacturers.
17 (Make) Shows the vehicle makes for each manufacturer.
18 # Vehicles Serviced Shows the number of times an individual make was serviced within the selected date or date range.
19 % of Total Vehicles Shows the percentage of specific vehicle makes serviced, compared to the total number of vehicles serviced for the selected date or date range.
20 Vehicle Sales $ Shows the total sales dollar amount for a specific vehicle make within the selected date or date range.
21 Subtotal Subtotals the number of times all makes within a specific manufacturer were serviced within the selected date or date range.
22 Subtotal Veh % Subtotals the percentage of all vehicle makes serviced within a specific manufacturer compared to the total number of vehicles serviced for the selected date or date range.
23 Subtotal Vehicle Sales Shows the total sales dollar amount for all vehicle makes within a specific manufacturer within the selected date or date range.
24 Total Vehicles Shows the total number of all vehicles serviced within the selected date or date range.
25 Total Veh % Shows the percentage of all vehicles serviced during the date range.
26 Total Vehicle Sales Shows the gross sales for all vehicles serviced during the selected date or date range.

Recommendations for Using This Report

Use this report to view the average service interval information for vehicles for both miles and days. If you have target percentage sales goals, you can also use it as a quick check to see if you are meeting your air filter, wiper blades and tire rotation sales. This report can also be used to analyze your marketing efforts, by giving you demographic information about your customer base. For example, you can check service interval information to see if a recent marketing campaign was successful. You can also see the vehicle makes that are coming in most often and perhaps target a specific marketing campaign to those customers.

Beyond the Basics

This report can also be used with the Inventory Usage Report and the Inventory Usage Status Report to help you decide which inventory items to keep in stock.