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: