Average par utilization formula

The Average Par Utilization (APU) 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 Suggested Par Level 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.

APU =    Sum of all Requisition Qty(s) of a LOCATION_ITEM             
             _______________________________________________ 	                      
	            Number of days of the previous month

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

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

Using the formula:

APU = (10 + 1 + 5 + 1) /28

=.6701