Go to previous topic
Go to next topic
Last Post 02/09/2018 8:22 AM by  JonA
Par Utilization
 1 Replies
Author Messages
Neil Allen
Supply Chain Lead IS Analyst
Veteran Member
(175 points)
Veteran Member

Send Message:

02/09/2018 7:32 AM

    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


    (Recommended Par Level - Current Reorder Point) * Last issue cost (at from location)

    Veteran Member
    (3069 points)
    Veteran Member

    Send Message:

    02/09/2018 8:22 AM

    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.

    Jon Athey - Supply Chain Analyst - Materials Management - MidMichigan Health