Update Re-Order Min/Max Qty's by Sales History


Purchase Order Menu -> Inventory Re-Ordering -> Edit Min & Max Utility -> SALES HISTORY button -> Update Re-Order Min/Max Qty's

This utility can be used to determine more accurate and useful Minimum and Maximum Re-Order quantities for Sales and Rental products by calculating quantities based on Sales History.
It recommends Min/Max quantity adjustments based on a percent increase or decrease of the sales of the products made in a prior period, such as same season last year as tracked in the Sales History.

Alternatively, to update these re-order quantities by manually over-riding existing values use the Edit Min & Max Utility.

Using Sales History to calculate the Min/Max requirements, the products in the selection range are displayed on the screen in a worksheet format with the new recommended values, where the values can be accepted or modifications can be made to the Min/Max re-order information.
When the displayed information is accepted, the re-order quantities are saved in the Inventory Re-Order Information window of the Sales Inventory and the Make/Model and Re-Order Information window of the Rental Inventory, and in the Re-Order Information by Location for products ordered by location.
An optional report can be printed or exported to a spreadsheet.

The prompts to select the products and calculate the recommended values include:

FROM PRODUCT CLASS
Leave this field blank to include all Product Classes, or enter a starting Class, or select one from the Product Class Search window.
TO PRODUCT CLASS
Leave this field blank to include all Product Classes, or enter an ending Class or select one from the window.

FROM PRODUCT GROUP
Leave this field blank to include all Product Groups, or enter a starting Group, or select one from the Group Search window.
TO PRODUCT GROUP
Leave this field blank to include all Product Groups, or enter an ending Group, or select one from the window.

FROM DATE
Accept the first day of the current month, or enter a preferred starting date.
The Sales History in this date range will be used to calculate the suggested Min/Max quantities.
TO DATE
Accept the last day of the current month, or enter a preferred ending date.

SET MINIMUM QUANTITY
Uncheck this box to skip the calculation for the minimum re-order quantity.

Check this box to recalculate the minimum re-order quantity based on Sales History, by using the following formula on the Sales during the specified date range.

           Total Sales in date range
MIN QTY =     Days in date range      *  # Days for Min  *  (1 + MIN%)

% MINIMUM
Enter the percentage to be used in the calculation.
e.g. 20% INCREASE is 20.00, or 20% DECREASE is 20.00-

# OF DAYS FOR MINIMUM
Enter the number of days between submitting orders.
This is used in the calculation to determine the quantity to re-ordered based the quantity sold in the period and on the number of days until the next order.
e.g. If orders are submitted every other week, enter 14

SET MAXIMUM QUANTITY
Uncheck this box to skip the calculation for maximum re-order quantity.

Check this box to recalculate the maximum re-order quantity based on Sales History, by using the following formula on the Sales for the specified date range.

           Total Sales in date range
MAX QTY =     Days in date range      *  # Days for Max  *  (1 + MIN%)

% MAXIMUM
Enter the percentage to be used in the calculation.
e.g. 20 % INCREASE is 20.00, or 20 % DECREASE is 20.00-

# OF DAYS FOR MAXIMUM
Enter the number of days between orders.
This is used in the calculation to determine the quantity to re-ordered based on sales and the number of days before your firm re-orders.

PROCESS PRODUCTS WITH RE-ORDER BY
Select one of the following product filters for re-ordering:
  • Select Company to include only products that use the company wide re-order quantities in Inventory Re-Order Information or Make/Model and Re-Order Information, and to exclude products that are re-ordered by individual location re-order information.
  • Select Location to only include products that use location re-order quantities with Min/Max values defined in the Re-Order Information by Location window.

  • Select Both to include all eligible products ordered company-wide and by location, using the corresponding appropriate Min/Max values.


ALL LOCATIONS
This field does not apply and is disabled it the Process Products With Re-Order By option is set to Company.

Check this box to include all locations.

Uncheck this box to specify a single location.

LOCATION
Enter the location or select one from the drop-down list.
The specific location only applies to products ordered by location.

INCLUDE LOCATIONS WITH MIN/MAX=0
Uncheck this box to omit any locations where the suggested Minimum and Maximum equals zero, according to the above formula using Sales History information.
Check this box to include all locations, even those with Min/Max calculated as zero.

PRODUCT TYPES
Select one of the following product filters for re-ordering:
  • Select Rental to only include Rental products.
  • Select Sales to only include Sales products.
  • Select Both to include all products.

REPORT OPTIONS
Select one of the following output options:
The products are also displayed in a worksheet format on the screen.
  • Select Print to list the selected products with the calculated Min/Max re-order quantities in report output.
    A printer can be confirmed or re-selected from the Printer option located on the menu bar at the top of the screen.
  • Select Excel to list the selected products with the calculated Min/Max re-order quantities in a spreadsheet
  • Select Neither to skip the report or spreadsheet and move directly to the screen display of the products.

Finished?
Click the ACCEPT button to continue, or CANCEL to abort.

UPDATE MIN/MAX QTY'S WORKSHEET

The Part Number, Description, Location, Product Class, calculated Minimum quantity, Maximum quantity, and Re-Order Multiple values are displayed on the screen.
The Min and Max values can be adjusted as required, and the Re-Order multiple can be entered.
Sales parts that should not be updated can be deleted using the <F7> key.

Click ACCEPT or press <F3> when all adjustments are completed to accept the new re-order information as displayed on the screen.

Confirmation is required:

Select one of the following actions:
Converted from CHM to HTML with chm2web Pro 2.85 (unicode)