This on demand report will help you determine which parts are best to be harvested off a trade-in unit based on historical data of parts and usage.
Jump to a specific section by clicking a link
Overview | Samples | Variables | Alert Functionality | OnDemand Report Filters | Best Practices & Tips | Related Alerts |
Overview
Overview
We all have trade-ins that we pull parts from when needed and then try to pull that same part again just to discover it's already gone. Then the debate becomes whether to replace that part and still try to refurbish the unit or just strip it.
The report identifies which parts would be most useful to harvest from a given unit. Within the run-on-demand SSRS Report filters, enter the make(s) and model(s) and the report will look at trends in parts usage, existing inventory levels (of standard and green parts) and cost of parts when ordered to prioritize and give enough detail for your parts harvester to make educated decisions on what's worth digging out and what is not. For retired equipment from your fleet, it will also consider age of part in days and clicks since it was last replaced on that equipment. The report assumes a fair amount of parts usage history for that model in question for best results.
Run Schedule: On Demand
Type of Output: On Demand SSRS Report
* * *
Sample
Sample
*See Alert Functionality section for column definitions by numbers in red in sample
Click on the + sign next to Item Number to see model level drill down for historical usage and active MIF
* * *
Variables
Variables
This process ID has no variables.
* * *
Alert Functionality
Alert Functionality
Output Column Definitions:
1. Shows Item Number and Description of applicable parts
2. Bar graph showing usage (consumption of part on service calls) trend for last 6 rolling quarters. The red bar is most recent rolling quarter. Colors serve as visual separation of bars, colors don't signify anything specific.
3. Usage quantity for the last rolling quarter. A rolling quarter is the last completed 3-months, it excludes current month.
4. Available quantity of item in warehouses selected in 'Selected warehouse(s)' filter on report.
5. Cost columns represent average cost value, last cost value and preferred vendor cost (per Item Record). We do not calculate average cost, we pull it from the information inside eAuto. How it is calculated depends upon several factors, including your inventory accounting method, for instance lifo or fifo, and it is recalculated on-the-fly after every inventory transaction. Further details are covered inside ECi's online help tool.
6. Historical count of parts usage is actual usage for last 6 rolling quarters.
7. Active MIF is based on the best information we have based on historical consumption.
When entering the make(s) and model(s) into the on-demand report filter fields, the report will look at trends in parts usage, existing inventory levels (of standard and green parts) and cost of parts when ordered to produce a harvest value. Below are the areas within the system that these data points come from.
Make and Model: On the equipment record, the areas below show the make and model.
Parts Usage: this report will look at service calls within e-automate from the last 6 rolling quarters that used parts that are listed as related items for item records in the system with same make and model being searched.
Existing Inventory Levels: this report reviews availability of related items for item records in the system with same make and model being searched which can be found in e-automate by going to inventory and then availability and searching by item.
Cost of Parts when Ordered: this report looks at the average cost of an item a well as the last cost paid for same item. The average cost is found by going to Inventory and then availability and searching for the item.
The last cost is found on the last non-voided completed purchase order for this item
* * *
OnDemand Report Filters
OnDemand Report Filters
The highlighted ShipOut ITT filters are available so you can exclude your ITT ShipOut equipment from usage consideration. Use any one or a combination of these filters to identify depending on how you have your ITT equipment identified.
* * *
Best Practices & Tips
Best Practices & Tips
Setting and identifying ITT devices: Please THIS POST on suggested Best Practice. Parts Harvest report will populate these ITT filters based on your ID945 variable settings. We highly recommend using SSRS Report ID945 for tracking these devices. The set up of this equipment and use of this report will impact this and future SSRS Reports currently in development.
* * *
Related Alerts
Related Alerts
ID945 - Tracking Ship Out and Ship In (ITT) Dealer Relationships Overview & Sample:
ID863 - Parts Available for Harvest Overview & Sample:
* * *
0 Comments