Program Description
This new program can be found on the Service Reports Service History Reports menu (SD-4-4-23). This report is used as a tool to analyze parts usage and the life of parts. It can also be used to show copy usage for not only parts, but also supplies and consumables. For simplification, the term parts will be used to refer to this type of item. This report displays parts that were replaced within a range of dates, item numbers, serial numbers, and part numbers. The first occurrence of a part that was taken out of the machine is classified with a part number of ORIGINAL and there is no cost associated with the original part. The parts print out sorted by description, then part number. The machines that print on this report are machines that are in the range of item number and serial numbers entered when the report is run and are currently placed at customer sites. A part is considered ORIGINAL if there are no previous calls (or sales history) records in which the part number was replaced. This report also displays totals on warranty parts. On ORIGINAL parts, the part is considered to be a warranty part if the date on which the part was installed is after or on the date the machine was placed, and the date in which the part was installed was within 90 days of the date the machine was placed, and the meter reading of last service call and last meter reading (both in Serial File) are both less than or equal to 10000. For a part that is not ORIGINAL, the part is considered to be a warranty part if the period in which the part was in the machine (difference between install date and failure date) is less than or equal to 90 days, and the date on which the part was installed is not equal to the date on which the machine was placed.
To run the report, follow the prompts below:
Beginning Date Or E'nd
Enter the beginning date to be included on the report, or enter E to end and return to the menu.
Ending Date
Enter the ending date to be included on the report.
Beginning Item Number Or A'll
Enter the beginning item number to be included on the report, or enter A for all items.
Ending Item Number
Enter the ending item number to be included on the report.
Beginning Serial Number Or A'll
Enter the beginning serial number to be included on the report, or enter A for all serial numbers.
Ending Serial Number
Enter the ending serial number to be included on the report.
Beginning Part Number Or A'll
Enter the beginning part number that should be included on the report, or enter A for all part numbers. This does not need to be an item number for a part. This can be used to print supply or consumable usage also.
Ending Part Number
Enter the ending part number that should be included on the report.
Print Detail (Y/N)
Enter Y to print detail on each machine parts usage including a summary of all of the machines at the end. Enter N to not print the detail for each machine, but only print the summary of all machines.
Include Items Entered Outside Of Svc Ticket Entry (Y/N)
Enter Y if you would like the report to take items from the Service Part file (PART.DT) and the Sales History File (SHHIST.DT). Enter N to have the report only look in the Service Part File. By entering Y, the program will be able to print all items billed through Service Invoicing, Invoice Entry, Credit Memo Entry, Order Entry, etc. It is not limited to just printing parts. This report can be used to print supply or consumable usage. By entering N, the program will only check for usage through Service Invoicing and Service Parts Entry. This would more than likely only be parts.
Report results:
Detail that prints per machine:
If the print detail prompt is set to Y, the report will print sorted by item number and then by serial number. Within each machine, it will sort the report by part description and then part number. After the detail prints for an item, the report will print a summary for that item (all serial numbers).
Item Number
Serial Number
Part Description
An asterisk (*) will print before the description if the part is considered to be a warranty part. A plus sign (+) will print before the description if the copy yield for that part was less than the Copy Yield for that part in that machine in the Model Association File (MAT.DT).
Part Number
This is either the part number that was replaced in the machine or ORIGINAL if it was the first part in the machine.
Install
This is the date on which the part was placed in the machine or the date on which the machine was placed if it is the original part.
Failed
This is the date on which the part was replaced. If this field is blank, this indicates that the part has not failed yet.
Copies Yielded
This is the number of copies made between the date on which the part was installed and the date it failed.
Mdl Assoc Yield
This is the copy yield in the Model Association File (MAT.DT) for that item and that part number.
Qty
This is the quantity of parts placed in the machine during the replacement.
Cost
This is the extended cost of the part(s) placed in the machine. If it is the original part, there is no cost.
Summary report:
The summary report will print for each item number. There will be a new page per item number. It will print the following:
Item Number
Part Description
A plus sign (+) will print before the description if the copy yield for that part was less than the Avg. Copy Yield for that part in that machine in the Model Association File (MAT.DT).
Part Number
This is either the part number that was replaced or ORIGINAL if it is the first time the part was replaced.
Avg Copy Yield
The Average Copy Yield is calculated by taking the total copies made by the part divided by the number of times the part was replaced.
Mdl Assoc Yield
This is the copy yield in the Model Association File (MAT.DT) for that item and that part number
Times Repl.
This is the total times that the part was replaced on all of the machines.
Cost
This is the total extended cost of all the parts that were replaced on all of the machines.
Warr %
This is the percentage of the parts that were on warranty when they were replaced. This is calculated by taking total number of parts under warranty divided by the number of times the part was replaced.
There are 12 totals that print at the end of each machine's summary report. These consist of the following:
Total Machine Population
This is the total number of machines currently placed at a customer site within the range of item numbers and range of serial numbers entered.
Number of Service Calls
This is the number of service calls with that specific primary sort code. This includes any call type. However, it does exclude all calls that are excluded from the calculations because the prior call date equals the date placed in the serial file (SERIALD), or the prior meter reading equals 0, or the service call's meter reading equals 0. Note: there may be a variation between this total and the sum of all of the primary sort codes added together because this figure excludes "bad" service calls.
Machine Failure Rate
This is calculated by taking the number of EM calls divided by total population divided by the number of months between the beginning and ending date of the report.
Machines with activity
This is the number of machines that had a service call within the time period.
Number of EM calls
This is the number of service calls with an EM call type within the date range.
Service Rate
This is calculated by taking the Number of EM Calls divided by the Number of Service Calls.
Machines with Parts Replaced
This is the total number of machines that had parts replaced during the time period.
Number of Part EM Calls
This is the total number of service calls with an EM call type that had parts replaced within date range.
Failure Rate of Parts
This is calculated by taking the number of machines with parts replaced divided by the total machines with activity divided by the number of months between the beginning and ending date range of the report.
Warranty Parts Cost
This is the total cost of the parts replaced under warranty.
Warranty EM Calls
This is the number of service calls with an EM call type that had warranty parts replaced.
Warranty Failure
This is calculated by taking the number of parts on the report that were under warranty divided by the total number of parts on the report (warranty and non-warranty).