The Item Card is your go-to for forecast and inventory information on each product.
Purchasing Recommendations Item Card
You will find the item card in Purchasing, by clicking on the graph icon under the Forecast Recommended Qty column or Links column. You can also access the item card with the search bar on the top navigation menu.
In the Purchasing section, the item card recommendations are meant for use in purchase orders. Click on the graph icon to open the Item Card to view more information on how the forecast recommendation was determined.
This grid will show the item's previous 4 years of sales history and its forecast for the upcoming 12 months, in the top row.
Need 12 months of forecast data for all SKUs at once? Download the Forecast Report at the top navigation menu.
Purchasing Calculations and Details
This dropdown will show you historical sales data, current inventory, and future projections. Inventory Status will include what you entered for warehouse inventory, open POs, and On Hand inventory. If you are an Amazon seller, you will also see Inbound inventory along with saleable FC Transfer inventory. Your inventory quantities will influence Future Projections.
Future Projections starts with your Projected Sales Over Horizon and Recommended Safety Stock. The number of days that make up the Sales Horizon is your lead time + order interval of the product. Projected Sales Over Horizon is the number of units the product is forecasted to sell in that time period. Based on your set service level, Recommended Safety Stock will display the number of additional units you want in stock over the Sales Horizon. If this item is also sold as part of a separate kit, the demand for this component will be included as well in the projected sales under the Projected Kit Demand. These projections, and the current inventory, will influence the number of units you will need to reorder.
Projected OOS Date and Projected Days Left in Stock will signify how much inventory you have remaining. Recommended Order Date will be the date by which you need to place your purchase order, for the units to arrive before the out-of-stock date.
This information is also available in the grid view of Purchasing so you can sort and export the data to fit your business needs.
The Settings area of the Item Card will display information previously entered for the supplier, kit relationships, Sales Horizon, and ordering parameters including Case Pack Qty and MOQ. This is here for additional information and can be changed in the Items section of ForecastRx. Case Pack Qty and MOQ are important for your purchase recommendation because your Purchase Qty will show the number of units needed to order in multiples and minimums based on this information.
If you have open purchase orders for the item you are viewing, the Purchase Orders tab will be included in the Item Card. Here you will see the same information as the Supply section but for the specified SKU only. Any open purchase orders will be factored into your recommended purchase quantity to prevent over-ordering.
If you sell products in kits or bundles, you will see the Kit Demand section appear in the Item Card. If you are viewing the Item card for the kit item, the Kit Demand section will display what SKUs make up that kit, their individual inventories, and how many units are needed of each component.
When viewing the Item Card of a component SKU (item used in a kit), you will see all kits this item is associated with. Under the Kit Demand tab, direct demand and inventory will show the forecasted demand and current inventory of the kit listed. Demand Inventory is the difference between Direct Demand and Inventory; if this number is positive, the kit is understocked by that amount of units, and if it is negative, then the kit is well stocked. Units per assembly will list the amount of this component used in each kit.
This is useful when bundling products in your facilities so you know what units to allocate to which kit. For example, if Demand Inventory of a kit shows 10 and Units Per Assembly is 2, that would mean you would need to allocate 20 units of the component to the kit in order to not run out of stock.
Consolidate is the last section of the Item Card. Here you will see the quantity recommended to reorder in case-packed multiples. If you have the purchase as feature set for SKUs to be purchased from your supplier under the SKU you are viewing, you will see the consolidated section broken down by each SKU's recommendation. The total quantity needed will be shown in the Purchase Qty and Recommended Qty columns.
RestockAMZ Item Card
For Amazon Sellers using RestockAMZ, in addition to the Purchasing Item Card, there is also a RestockAMZ Item Card found in Restock from Supplier and Restock from Warehouse under the Forecast Recommended Qty Column. The RestockAMZ Item Card displays the same information as the Purchasing Item Card, except the recommendations and Sales Horizon are modified for restocking Amazon.
Your Sales Horizon is based on the lead time to ship products into Amazon and the target days of inventory. Restock from Warehouse will display Warehouse Lead Time plus Maximum Days of FBA Inventory for the Sales Horizon and Restock from Supplier will display as the supplier's lead time plus Maximum Days of FBA Inventory. Recommended Safety Stock is not included in RestockAMZ because the use of Maximum Days of FBA Inventory can be adjusted to include more inventory per restock.
You will also see that the rest of the Future Projections box looks the same as the Purchasing Item Card, but the information is modified to show projections based on Amazon inventory levels. For example, the Projected OOS Date displays when the product will be out of stock in Amazon whereas the Purchasing Item Card will show the Projected OOS Date as the date all known inventory will be depleted.
Want to know the difference between your Forecast Recommended Qty (RestockAMZ Item Card) and other Restock Recommendations? Click here to learn more.
If you would like to schedule a meeting with a member of the team—let us know, we are here to help!