The Inventory Performance Report compares the actual inventory performance to the theoretical (forecast) inventory performance.
1. Navigation in K3S
2. Filter Options
3. Reading the report
The Inventory Performance Report is very easy to generate and review. Start by selecting the Inventory Performance Report using the printer icon on the left side of your screen.
2. Filter Options
You will then see several filter options within the Request Criteria. To keep it simple, you can enter you Buyer Group. This will run the report on all of your suppliers. If you leave everything blank, it will run the report for every supplier in the company. If you would like to drill down to a specific supplier, location, supplier group, or product group, you can enter this as well.
Do you want a Summary Report by Buyer?
The default is No, change to a ‘Yes’ if you want a summary report by Buyer.
Do you want a Summary Report by Location?
The default is No, change to a ‘Yes’ if you want a summary report by Location.
Do you want a Summary Report for the Company?
The default is No, change to a ‘Yes’ if you want a summary report for the Company.
After you are satisfied with the request criteria, run the report. K3S will then email you two different files for the report. These include a CSV (spreadsheet file) and a PDF. The CSV will be great for certain reports if you want to drill down and edit the spreadsheet in excel. The PDF will be best for viewing the straightforward results. You can choose what will work best for you.
*Note: If you do not receive the reports in your email inbox, please email [email protected] we will get you set up.
3. Reading the Report
Now let’s quickly look at the PDF version of the report. You may also want to review the CSV report.
The fields displayed at the beginning of the report on Page 1, Request Criteria section, are a reflection of what was chosen in the initial online report selection screen.
Below is the information shown in the image above:
Buyer: The Buyer’s ID and name.
Locn (Location): The Location ID and name.
System product categories (1st report)
Special product categories (2nd report)
# of products: The number of products included on this line of the report.
% of total: The percent of products on this line equals the number of products on this line of the report divided by the total number of products.
# of mfg out: The number of manufacturer’s outs for the products included on this line of the report.
% of total: The number of manufacturer’s outs for the products included on this line of the report divided by the total number of manufacturer’s outs.
Actual: The quantity on hand * (regular cost / cost divisor).
Theoretical: Theoretically what the user should have on hand. It consists of safety stock + ½ of the cycle stock * (forecast / 364) * cost each.
Act/Theo Ratio: The accuracy of the inventory expressed as a percentage. Actual divided by Theoretical = Act/Theo Ratio.
Target Service: The service level target.
Unadjust Service: The service level achieved before adjustments for Manufacturer’s outs.
Adjust Service: The service level achieved after adjustments for Manufacturer’s outs.
You now know how to:
1. Navigate to the report
2. Use the filter options
3. Read the PDF report