Calculate RSL Par Levels

(ParBuild.exe) This program is used to allow the system settings and history to calculate the Remote Stocking Location Par Levels.

Select the Entity using the drop down. Select the RSL using the drop down, select the Vendor by entering Vendor ID or Name, or using the lookup or check All for all vendors.  Select the Product Class using the drop down. Choose with arrows the Times Ordered per week (1-7), Days of Safety Stock and Months of History to Use.  Select Lead Days for Non Stocks.  When ready, press the Calculate button.  An information box displays "Done" when completed. The report, RSL Calculated Par Levels, may be run to review recommended changes after calculating. After reviewing, the Process Calculated RSL Par Levels program may be run to effect the changes. If you wish to exclude items from the calculation check the Exclude ROP box on the Detail tab of the RSL Master File.

The formula for calculating the Reorder Point (ROP) is as follows: Lead Days (either based on the Average Vendor Lead Days as calculated by the system or entered by the user) plus Order Days (times per week) plus the Safety Stock Days times the Average Daily Usage (Total Item Usage divided by the number of days).

The formula for calculating the Reorder Quantity (ROQ) is as follows: Average Monthly Usage (Total Item Usage divided by the number of months) divided by the Times Ordered per Month.

The formula for Max is the Reorder Point (ROP) plus Reorder Quantity (ROQ).

The formula for Min is Safety Stock Days times the Average Monthly Usage.