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
- Inbound Master Scheduler runs again.
- New transaction is created after the Inbound Master Scheduler last ran.