Note: To understand how Replenishment works, read Intro to Replenishment. Table View is an alternate view to the Recommendations Grid.
Remi AI offers two views on Replenishment Recommendations, the Grid View and the Table View. The Grid View is generally easier to understand, but the Table View is more powerful. We recommend therefore that you review the Grid View first before coming back here to learn about the Table View.
To make a real-world analogy, you can think of the Grid View as a stack of purchase orders (PO's). You can sort them in different ways and make changes on the fly, but in the end, they remain PO's.
The Table View doesn't have a real-world equivalent: What it does is offer a future view of your warehouse, and how stock levels will fluctuate - that is what makes it so powerful.
Selecting what is displayed
First, select what you would like to see:
- "View recommended SKU's only" hides all SKU that currently don't have an order recommendation; since no order is planned, no action is necessary, and they normally don't need to be viewed.
Understanding what is shown
Each SKU is technically a single row, although a row is quite tall with multiple sub-rows - marked below in yellow is the row for one particular SKU.
On the left side, we have information about the product in general and about the recommended order. On the right side, we have projections about the product and future demand. Note that the columns on the right side extend beyond the screen and can be navigated with the green slider up to 16 weeks (or months, depending on your setup) into the future.
Important: The shown stock levels, as well as the future orders, are all based on the assumption that the recommended order is placed as recommended. Note further that these predictions don't change when you're changing the order quantity or actually placing the order. These fields are updated once a day, and you will see the changed data reflected tomorrow.
Daily work with the Recommendations Table
You go through the Recommendations SKU by SKU, and look at predicted stock levels, expected deliveries, and consumption to gain an understanding of the current situation. Then, you review the recommended order quantity on the left in light of net stock, minimum order quantity, and lead time. If all that checks out, you "Approve" the order, which puts it in the queue for being sent.
To get a deeper understanding of working with the Recommendations table, we have a real-life example that covers every number in detail.
Review of every field in the Replenishment Table
Right side: Future projections
On the right side of the screen, we see five rows, and their respective values over time:
- Future Orders: In addition to the one current order we review, the system is possibly already planning more orders. These future orders are shown, as well as the one currently under review in the current week.
- Stock Levels: These are the projected stock levels based on expected demand and planned orders. Note: This includes the Recommended Order amount as proposed; if edits are made, this is NOT reflected in the forecasted columns.
- Expected Deliveries: Orders have lead times of sometimes several weeks. This shows when they arrive and are actually added to stock.
- Base Forecast: This is the week-over-week expected consumption or demand.
Left side: The recommended order
- Quantity: How much the system recommends you order - this value can be changed.
- Approve order: Clicking this button will add the order with the selected quantity to the queue of orders.
- Three-dot button: Provides quick access to the related Demand Forecast, Recommendation, and Replenishment Settings.
- Net Stock: Today's net stock level. Hover to see a breakdown of the expected order, returns, etc.
- Minimal Order Quantity: Some vendors require a certain quantity for an order. In this case, it is 0.
- Lead time: How many days will it take for this product to arrive?
- Comment: enter a comment that will go back to each manufacturer along with the order