Program Description
This new program can be found on the Service Reports Service History Reports menu (SD-4-4-21). The purpose of the report is to provide cost per copy information for a technician and/or a team of technicians. The program uses the branch number stored in the Sales Rep/Service Tech File (SLMD) as the team number. The information can be used to aid in the pricing of the service contracts. The report includes the number of failure calls per technician and/or technician team. The CPC By Technician Report also includes total copies, labor cost, labor CPC, travel cost, travel CPC, parts cost, parts CPC, parts cost per call, total CPC for each service call, technician, and technician team included on the report.
Service history is used to gather the number of service calls and copies produced. Calls must be completed and have the service ticket entered. This is determined by the ticket entered switch set on Y for yes and an arrival time greater than 0. A custody (CU) call is the only call type not included in any of the report calculations. Call types of TA, CC, SH, EM, PM, and HP will be included as failure types. Only parts in the PART.DT File assigned a call type of P are included in the parts cost. A service call is considered a failure if another service call is performed on the same machine at a later date. Thus, if a machine has had only one service call, it will never be included in this report. The second service call may or may not be within the date range inputted on the report. The most recent service call information will never be included in the report.
The following fields are described below:
Print D’etail, S’ummary, B’oth, Or E’nd
Enter D to print the detailed report, which includes every technician, technician team, and item number. The technician, team, and report totals print. Enter S to print the summary report, which includes every technician and technician team. The team and report totals print. Enter B to print both the detailed and summary reports. Enter E to end and return to the previous menu.
Beginning Completion Date or A’ll
Enter the beginning date in a date range for which the program searches service history. Calls must be completed within this date range and have the service ticket entered to be included on the report. Enter A to search service history for all dates. (MM/DD/YY)
Ending Completion Date
The beginning completion date defaults. Press return to accept the default or enter the ending completion date in a date range. (MM/DD/YY)
Beginning Product Class Or A’ll
Enter the beginning product class in a range of product classes to include only items in the product class or classes on the report. Enter A to include all product classes. (4 Numeric)
Ending Product Class
The beginning product class defaults. Press return to accept the default or enter the ending product class in a range of product classes. (4 Numeric)
Enter Specific Item Numbers To Print, R’ange Or A’ll
Enter an unlimited number of item numbers to include on the report. Enter R to include a range of item numbers on the report. Input prompts for the beginning and ending item number display. Enter A to include all items on the report. (18 alphanumeric)
Enter Specific Item Numbers To Exclude
Enter an unlimited number of valid item numbers to exclude from the report. This prompt is bypassed if you entered specific item numbers to print. (18 alphanumeric)
Enter Specific Technician Numbers, R’ange Or A’ll
Enter an unlimited number of technician numbers to include on the report. Enter R to include a range of technician numbers on the report. Input prompts for the beginning and ending technician number display. Enter A to include all technicians on the report. The program uses the technician that performed the service call (DISPA) rather than the primary tech stored in the Serial File. (4 Numeric)
Enter Specific Team (Branch) Numbers, R’ange Or A’ll
Enter an unlimited number of team (branch) numbers to include on the report. Enter R to include a range of team numbers on the report. Input prompts for the beginning and ending team number display. Enter A to include all teams on the report. The program uses the branch number stored in the SLMD File as the team number. (3 Numeric)
Print C’ontract Machines, N’on-Contract Machines, Or B’oth
Enter C to include only service calls for machines on contract. Enter N to include only service calls for machines not on contract. Enter B to include service calls for machines on contract and not on contract. The program searches the Serial File for a contract number.
Exclude Non-Product Time Within Calls (Y/N)
Enter Y to exclude non-product time from the service calls on the report. The program searches the Tech Labor File for non-product records with the correct call number. It subtracts the non-product time from the labor time. Enter N to include non-product time from service calls on the report.
Enter Mileage Rate
The mileage rate is stored in the defaults of Service Call Control File Maintenance. Enter a different mileage rate if desired. The program uses this mileage rate to calculate Travel Cost. (3 Numeric)
Include Travel Time In Labor Cost (Y/N)
Enter Y to include travel time in the calculation of Labor Cost. Enter N to exclude travel time from the calculation of Labor Cost.
Report Results
Item Number
This is the item number on which the service call was performed.
# Of Calls
This is the number of service calls that failed for that technician or team. All call types are included except custody (CU). The program also skips calls that have not had a service ticket entered.
Total Copies
This is the number of copies from the service call to the next service call. If there is no next call, the program does not include that call because the technician’s fix has yet to fail.
Labor Cost
This is the Mechanical time (minutes) + Travel time (minutes) X Burden Rate / 60. The program uses the burden rate stored the SLMD File. If that is zero, it uses the burden rate from the Global File (BI-3-1-18-10). If you chose not to include travel time in the Labor Cost calculation, Labor Cost = Mechanical time (minutes) X Burden Rate / 60.
Labor CPC
This is Labor Cost divided by Total Copies (rounded to 6 decimal positions).
Travel Cost
This is the Mileage from the Labor History File times the Mileage Rate.
Travel CPC
This is Travel Cost divided by Total Copies (rounded to 6 decimal positions).
Parts Cost
This is the Cost from the Parts File for all records with a call type of P for part for the calls within the range, not including the most recent call.
Parts CPC
This is Parts Cost divided by Total Copies (rounded to 6 decimal positions).
Parts Cost Per Call
This is Parts Cost divided by the Number Of Calls.
Total CPC
This is Labor CPC + Travel CPC + Parts CPC.
Example:
Call Date Tech Meter Labor Cost Mileage Cost Parts Cost
12/15/97 40 5000 42.00 8.00 50.00
02/98 50 15000 21.00 14.50 10.00
30/98 40 25000 126.00 4.00 100.00
On the report
For Tech 40, Copies=10000, # Call=1, Labor Cost=42.00, Mileage Cost=8.00, and Parts Cost=50.00.
For Tech 50, Copies=10000, # Calls=1, Labor Cost=21.00, Mileage Cost=14.50, and Parts Cost=10.00.
The last call on the machine is never included because the technician’s work has yet to fail. If another service call is performed on the machine at a later date, but the date is not within the inputted date range, this call is considered a failure and included on the report.
Miscellaneous Notes
Mechanical and travel times are retrieved from the Labor History (TECH) file.
The report is designed so that if it is printed for all technicians and specific or a range of items, the MACH.IX index will be used to look at the service history (DISPA). Otherwise, it will use the DISP.IX index (technician index) to pull from the service history. This is done to make the retrieval of information as efficient as possible.
The service history (DISPA) file is the main file.
During the inputs, specific items or technicians can be entered to include or exclude. These are stored in four separate indices. This allows for an unlimited number that can be stored.
If the non-product time is greater than the mechanical time, it will not be deducted if the report is run to exclude non-product time within calls.