Suggested par level formula

The Suggested Par Level (SPL) formula is based on the computation used in FSM or Infor Lawson Par Location Utilization.

The Inbound Master Scheduler is needed to retrieve all RQTRANS records for the previous calendar month up until current date. The scheduler runs daily but it checks first if it is supposed to fully run based on the data of the date tracker table. This is the same scheduler used for computing the APU of an item.

If Display APU/SPL = ‘Yes’ for the company, the download of APU/SPL information to the handheld will take place for each par form that the user selects for counting.

SPL = (Average Qty + 2 * Standard Deviation) * Requisition Count * (Replenishment Days / No. of Days with Activity + 1)

Average Qty = Sum of RQ Qty(s) of a Location Item / RQ count

Standard Deviation = "Sample-formula" Standard Deviation of RQ Qtys

Requisition Count = RQ Count of a Location item regardless of duplicates

Replenishment Days = Configured in Web MPC Configuration

No. of Days with Activity = Number of unique calendar days of RQ occurrence

Given:

Replenishment Days setup in MPC Configuration (web) is 3.

Get the SPL for Item 701 in Company 9500, Location 70 for February 2013.

Using the formula:

Average Qty = (10+1+5+1) / 4 = 4.25

Std Dev= STDEV(10,1,5,1) = 4.27

Requisition Count = 4

Replenishment Days = 3 (configurable)

No. of Days with Activity = 4 (Feb-2, Feb-10, Feb-17, Feb-28)

SPL = ( 4.25 + (2 * 4.27) ) * 4 * ( 3 / (4+1) ) => 30.696