New Purchasing Module


This is a complete overhaul of the current suggested order logic in an attempt to provide the user with more of a table driven utility while at the same time making the underlying logic that determines the order quantities more transparent. In addition, the demand cleansing or smoothing will become more granular by the use of weekly versus monthly demand.

The fundamental changes include the adoption of a weekly sales bucket (Current plus the last 104 weeks), an ABC ranking based on Annual Sales $’s or Units and the introduction of an automatic reorder point based on a dynamic lead time (Last x receiving’s) and a parameterized safety stock factor by sales rank.

There is a corporate version of the ABC ranking table as well as one for each branch, carrying different values that will support inter branch versus corporate replenishment.

The vendor profile is also expanded to support the rules for pre-paid freight shipment. This will be used to determine when a corporate suggested order could have one or more PO’s produced because one or more branches meet the free shipment criteria. This requires user confirmation that split PO’s are desired on any given SO.

The PO receiving process is also enhanced to allow a recalculation of the branch split if the order was a corporate PO. In addition, a prorated calculation is performed for partial shipments, with an option to receive any partial shipment into the DC only.

Basic functionality

  1. ABC ranking: A new weekly process will calculate the annual sales in $’s at cost or Unit’s, based on which method is being used, for each part number. This value will be compared to a table that carries up to twenty ranges, 100 – 1000, 1001 – 5000, etc. Each range will be associated with an ABC ranking which in turn will carry the number of required inventory turns as well as the safety stock %. The number of weeks used in the sales ranking is determined by the user, 1  104.
  2. Re-order Point: Will replace or become the current Minimum Qty field on the item master. There is also be a new field that controls whether or not the re-order point is recalculated weekly or is locked for the number of weeks enteredmanually into this field. If the Re-order point is to be permanently locked a value of 99 is used in the Auto Lock field. The weekly process will decrement this field by one until it reaches zero. Zero will be considered as indicating the item is on automatic re-order point calculation. NOTE: the manual change of the Auto Lock forces entry into the Re-order point field to enter the quantity manually. New product will default to a standard parameter for the Auto Lock weeks and a Re-order point will need to be entered manually.
  3. Re-order Point calculation: This will be done on a weekly boundary based on the items lead time (Average of last xx number of receiving’s) and the safety stock associated with the items ABC ranking. The lead time in days would be multiplied by the daily use rate and the result of this multiplied again by the safety stock. EXAMPLE: Item A123 is classified as a “C” ranking (25% safety stock), has a lead time of 20 days and a daily use rate of 2 units. The re-order point qty therefore would be (40 times 1.25 or 50 units).
  4. Re-Order Quantity: This new value for the Vendor and DC replenishment is calculated based on the Sales Ranking of the product and the required Turns setup in the sales ranking table. The annual sales are divided by the required number of turns to determine the Re-order Quantity.
  5. Rounding: Parameters are available to control the rounding characteristics of both the Re-order Point and the Re-order Quantity, round up, round at 0.5 or round down.
  6. Suggested Order Calculation: Would be calculated as the total annual units sold divided by the number of required turns for the items ABC ranking plus the difference between On-hand and the Re-order point qty. EXAMPLE: Item A123 from above has 35 units On-hand, sells 1200 units a year and is classified as a C ranking, which calls for 4 turns. This would result in the suggested order qty being calculated as 1200 (annual unit sales) divided by 4 (required turns for “C” ranking) plus 15 (Re-order qty – On-hand) or 315 units.

Inventory Enhancements

Supplier Enhancements

Weekly Demand

A new WEEKSALES data has been created to include the RAW sales total as well as the smoothed or normalized total. This will then allow the potential for a refresh if the smoothing parameters are changed. The daily average sales for the week is also stored to avoid having to calculate this number on the fly. The need to perform a weighted average in regards the daily sales qty will no longer be required as all xx weeks (Number of weeks to be considered in calculations) will be added and then averaged. The demand smoothing and calculation of average daily sales is done on a weekly boundary.

Sales Ranking

The sales ranking is recalculated on a weekly basis after the demand smoothing is completed along with the Vendor and DC replenishment Re-order quantities.

Lead Time and Safety Stock

Branch replenishment

The current replenishment logic has been changed to look at the branch ABC ranking table to determine what the correct stocking levels for a branch would be. For a DC replenishment the re-order point (lead time and safety stock) would be driven from a
parameterized setting by branch. For a vendor purchase the corporate lead time and safety stock would be used. In both cases the Suggested Order Qty would be based on the branch ABC ranking of the item and whatever turns and safety stock are contained in the sales ranking table.

Seasonal Profiling (In Development)

Revisions are being made to the Seasonal profiling to support User Defined seasons.
This will include up to 4 seasons indicating the start and end month for each season and the % of annual sales required in the season to mark the part as a seasonal item.
The calculation of Re-order Point and Re-order Quantity will use the movement from the previous season when buying in season and the movement from the previous off-season when buying out of season.
The intent is to use the lead time of the product to determine if the purchase is going into or out of season.
The seasonal flag will be visible on the suggested order detail.

Suggested Order

The SO routine has been modified to remove the need for user input, taking instead a series of default arguments in how the program will function. This will allow for easier management and more consistency in what the buyers use as criteria. In addition, the system will maintain a perpetual pending order status by creating a SO for every vendor every night, adding or changing the status of an item based upon the previous day’s activity.

The buyers will now be offered a Buyers Focus screen with a number of filters that will control the view, and therefore the amount of data they will have to look at. This includes those vendors where there is a schedule, daily, weekly, monthly. In addition, the concept of a buyer being assigned a vendor will be introduced that will further filter the current data overload as well as support monitoring of a buyers habits and/or performance.

Receiving Enhancements

Calculation of the Xdocking requirements for the branches are made upon the receipt of the product at the DC. Stock Transfers can be automatically created when the PO is updated for Xdock product.
The receipt of product either by the use of bar code scanning or entry against the purchase order data itself.


Revision #1
Created 9 January 2019 12:18:02 by Jim
Updated 15 September 2021 23:56:01 by Jim