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
Private
Veteran Member
(172 points)
Veteran Member
Posts:86


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

    Impact:

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

    JonA
    Private
    Private
    Veteran Member
    (2891 points)
    Veteran Member
    Posts:1017


    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
    Attachments


    ---