Suggested Restock

The Suggested Restock feature helps you manage inventory replenishment by providing data-driven recommendations for restocking products based on historical sales data, lead times, and desired stock levels.

Overview

The Suggested Restock table displays your products with key metrics and allows you to:

• View suggested restock quantities
• Manage lead times and days of stock settings
• Create purchase orders
• Assign suppliers to products
• Filter and search products

Key Features

Product Information

Each row shows:

• Product name and variant
• SKU and cost (if available)
• Current available stock
• Forecasted daily demand
• Usable PO quantities within lead time
• Suggested restock amount

Bulk Actions

Select multiple products to:

1. Set Lead Time
2. Set Days of Stock
3. Assign Supplier
4. Create Purchase Order

Filtering

Filter your products using various criteria:

• Available Stock
• Daily Sales Average
• Open PO Quantity
• Suggested Restock
• Product Name
• Location
• Lead Time
• Days of Stock
• Supplier
• SKU

Search

Use the search bar to quickly find products by name or variant.

Settings

Lead Time

• Defines how long it typically takes to receive inventory from your supplier
• Can be set individually per product or in bulk
• Affects suggested restock calculations

Days of Stock

• Determines how many days of inventory you want to maintain
• Can be set per product or in bulk
• Used to calculate suggested restock quantities

Supplier Management

• Assign suppliers to products
• Create and edit supplier information
• Track supplier assignments

Creating Purchase Orders

1. Select products you want to reorder
2. Click "Create PO"
3. Review suggested quantities
4. Adjust quantities if needed
5. Select supplier and delivery location
6. Submit the purchase order

Calculation Method

Suggested restock quantities are calculated using a more sophisticated approach that considers:

1. Desired Stock Level = Lead Time Demand + Days of Stock Demand + Safety Stock

   • Lead Time Demand = Forecasted Daily Demand × Lead Time
   • Days of Stock Demand = Forecasted Daily Demand × Days of Stock
   • Safety Stock = z-score × Standard Deviation of Daily Sales × √Lead Time

2. Usable PO Quantity = Sum of PO quantities that will be:

   • Received within the lead time window
   • Available to offset demand during the remaining lead time

Final Calculation: Suggested Restock = Desired Stock Level - Available Stock - Usable PO Quantity

Important Notes:

• Forecasted daily demand is used instead of historical average demand
• Only PO quantities that arrive within your lead time window are considered
• PO quantities are adjusted based on when they arrive and how much demand they can offset
• Safety stock is included to handle demand variability

Tips

1. Regular Updates: Keep lead times and days of stock settings current for accurate suggestions

2. Bulk Actions: Use bulk actions to efficiently manage settings for multiple products

3. Filtering: Combine multiple filters to focus on specific product groups

4. Supplier Assignment: Assign suppliers to products for streamlined purchase order creation

5. Mobile View: Access key features on mobile devices with a responsive interface

6. PO Timing: Consider PO arrival dates carefully as they affect usable quantities

7. Forecast Accuracy: Keep forecasts up-to-date for better suggestions

Best Practices

1. Review and update lead times regularly based on actual supplier performance

2. Adjust days of stock based on:

   • Product seasonality
   • Storage costs
   • Supplier reliability
   • Product margin

3. Use filters to identify:

   • Products needing immediate restock
   • Excess inventory
   • Missing supplier assignments

4. Monitor average daily demand trends to adjust stock levels accordingly

Troubleshooting

If suggested restock quantities seem incorrect:

1. Verify lead time settings
2. Check days of stock values
3. Confirm current inventory levels
4. Review open purchase orders
5. Check historical sales data accuracy

For additional support or questions, contact our support team.