About the Low-Stock Wholesaler Report — Cycle
The Low-Stock Wholesaler Report — Cycle report suggests an order amount for each inventory item based on sales history and cycle weeks. The suggested order amount is based on three or 17 months' usage. When you run the Low-Stock Report, you can create a low-stock file, which you can use to create purchase orders automatically. You can also use the low-stock file when posting stock transfers. The Low-Stock Report can calculate the suggested order quantity in two ways: using the sales history of each item and the projected number of weeks between purchases, or using minimum and maximum stock levels.
The on-hand, on-order, and backordered quantities are compared to project if stock levels will fall below the minimum. If so, an order quantity is suggested to bring stock levels to the maximum. For items without information in the Min and Max boxes, cycle weeks are used to calculate order quantities.
The suggested order amount is calculated for each item that is at or below the minimum according to the following formula:
Max - O/H = Need
Need - (O/O + O/H) + B/O = Order Quantity
Max |
Amount in the Max field |
O/H |
On-hand |
O/O |
On-order |
B/O |
Backordered |
Note: An asterisk (*) next to the suggested order quantity means the amount is based on the Min and Max boxes. No asterisk means the quantity is based on the cycle weeks formula.
This report contains the following information:
Inventory Location
Item Number
Company
Replacement Cost
Last Year's Sales
Year-to-Date Sales
Last Three Month's Sales
Current Month's Sales
Hits
Amount Needed Based on Sales History
Quantity on Order
Quantity on Hand
Quantity Backordered
Suggested Order Amount
See also:
About the Low-Stock Wholesaler Report — Min/Max