Is anyone using a custom report instead of IC182 for par utilization? This is the logic Lawson uses but wondering if someone has come up with a better way to determine usage and par recommendations through a custom script.
Recommended Par Level
(Avg. Requisition Qty + (2*Std Deviation)) * Requisition Count * (Replenishment Days/Number of Days with Activity)
Daily Average Utilization:
Total Quantity in date range / days in range + 1
Impact:
(Recommended Par Level - Current Reorder Point) * Last issue cost (at from location)
I have this Crystal report that calculates a suggested par level for keeping 2 week's usage on hand. You enter a date range to pull requisition line data and it basically calculates daily usage and multiplies by 14. If items on the par have no usage for the date range you won't see them in the report.
Change the file extension to .rpt to open it in Crystal. I had to change it to .doc in order for the forum to accept it.