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:

Trans # Trans Date Company Req Location Item Quantity
1 02/01/2013 4200 70 701 10
2 02/02/2013 9500 70 701 10
3 02/05/2013 9500 71 701 6
4 02/06/2013 4200 70 702 5
5 02/10/2013 9500 70 701 1
6 02/11/2013 4200 70 701 20
7 02/12/2013 9500 71 701 11
8 02/16/2013 9500 70 705 15
9 02/17/2013 9500 70 701 5
10 02/23/2013 9500 71 701 10
11 02/28/2013 9500 70 701 1

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

If the Replenishment days is modified after the Inbound Master Scheduler has run, the system will re-compute for the SPL using the new replenishment days value when these conditions are satisfied:
  • Inbound Master Scheduler runs again.
  • New transaction is created after the Inbound Master Scheduler last ran.