Follow

What data is included in the Inventory Report - Forecasting & Replenishment report?

Created:   |   Updated:

ShippingEasy REPORTS include a number of preconfigured reports. These reports accommodate the reporting needs of most shipping operations. They can also be scheduled to be emailed to you on a recurring basis. Though the columns cannot be edited or rearranged, they make for easy access to your inventory data. Learn more about REPORTS.

The Forecasting & Replenishment Report is available to all ShippingEasy Inventory Management users and utilized the actual sales velocity of your products to predict future sales and makes stock replenishment recommendations based on the sales history and forecast periods that you choose.

To generate the report, hover over the INVENTORY tab and then select REPORTS.

There are three settings along the top of the report which enables customization of the data:

  • Store
  • Sales History
  • Forecast Period

The report data will refresh automatically if you select a different Store, Sales History period or Forecast Period.

Screen_Shot_2019-04-30_at_9.42.52_PM.png

Store:

By default, "All Stores" will be selected from the Stores filter. Use the Store filter to capture sales data from a specific store in the forecasting calculations.

TIP: the "Store" filter usage will depend on where products are stored >>>

  • Merchant stores all their own products: in this case, the merchant fulfills all sales themselves. The report will help determine how much to reorder, for each "Store", to stock their warehouse and keep up with velocity projections.

Amazon merchant:

  • Has Fulfillment by Amazon store all their products: in this case, the merchant only sells on FBA and all sales are fulfilled by Amazon. Filtering the "Store" to "Amazon" will show how much to reorder and send to Amazon to keep up with velocity projections.
  • Has some products exclusively stored at Fulfillment by Amazon: in this case, the merchant sells a mix of products, but some SKUs are only fulfilled by FBA. When it is known which SKUs are fulfilled at FBA, filtering the "Store" to "Amazon" will show how much to reorder and send to Amazon of those specific SKUs. Likewise, knowing which SKUs are fulfilled by the merchant, the same insights can be used to restock the merchant's warehouse and keep up with velocity projections.
  • Has products stored at both Fulfillment by Amazon and their warehouse: in this case, the merchant divides storage of individual SKUs between FBA and their warehouse. To make the best use of the "Store" filter, it helps to know what percentage of sales come from FBA and merchant-fulfilled channels. Using this proportion, filtering the "Store" to "Amazon" will help to calculate the quantity to reorder, and how much to retain versus send to Amazon.

Multi-Channel Fulfillment merchant:

  • Has products stored at Amazon, but sells on a different platform: in this case, the merchant is using Multi-Channel Fulfillment to fulfill orders, but those orders are coming from a different sales channel. The guidelines above can be used to determine how much stock needs to be retained or sent to Amazon. Simply filter the "Store" to the channel where MCF orders come from.

Sales History:

This will display the defaults you have set on the INVENTORY SETTINGS page. Learn how to set your default Sales History.

Choose the Sales History period that best represents the velocity you expect for sales in the Forecast Period. Usually, a more recent sales history better represents the upcoming sales period.

Sales History options:

  • 7 day
  • 14 day
  • 30 day
  • 60 day
  • 90 day
NOTE: Sales Velocity is calculated using your actual sales history. For new ShippingEasy users, an import of the last 90-days of sales per SKU will happen automatically when you integrate a new store.

Forecast Period: 

This will display the defaults you have set on the INVENTORY SETTINGS page. Learn how to set your default Forecast Period.

Typically, the Forecast Period chosen should cover the amount of time until you plan to reorder stock again as the QTB (Quantity to Buy) recommendation will be calculated to cover projected sales in the forecast period only.

Forecast Period options:

  • 7 day
  • 14 day
  • 30 day
  • 60 day
  • 90 day
  • 120 day
  • 180 day

 

The inventory data in the Inventory Status report includes:

  • SKU, for:
    • Active Product SKUs
    • Product Variant SKUs
  • Alias SKUs (SKU | SKU)
  • Item Name
  • Supplier Name (Supplier | Supplier)
  • Units Sold
  • Velocity:
    • Expressed as units per day, based on the Sales History period.
    • Rounded down to the nearest tenth (e.g. 9.7).
  • Available stock
  • Awaiting stock
  • Stockout:
    • Days until Available stock is zero, rounded down to the nearest day.
    • If Velocity is zero, Stockout will be blank as there is no rate to determine when Available stock will run out.
    • If Available stock is negative (ie. you've oversold the product), Stockout will be negative as you're past-due to reorder. 
  • Lead Time:
    • User-defined value that identifies the amount of time between when a PO is placed and the replenishment order is received.
    • Set globally from INVENTORY SETTINGS or on the individual product. Learn how to set up Lead Time.
  • Lead Demand:
    • Projected demand during the lead time.
    • Rounded up to the nearest unit.
  • Projected Available:
    • Projected remaining Available stock taking into account Awaiting Stock and Projected Sales.
    • Rounded up to the nearest unit.
  • Projected Sales:
    • Projected sales during the reorder period (Lead Time + Forecast Period).
    • Rounded up to the nearest unit.
  • DTR (Days to Reorder):
    • The number of days until a PO must be placed to avoid stockout, rounded down to the nearest day.
    • If Velocity is zero, DTR will be blank as there is no rate to determine when Available stock will run out.
    • If Available stock is negative (ie. you've oversold the product), DTR will be negative as you're past-due to reorder.
  • QTB (Quantity to Buy):
    • The recommended quantity to buy in order to have enough inventory to fulfill all orders through the reorder period.
    • Rounded up to the nearest unit.
    • Takes into account the In-stock Expectation set on INVENTORY SETTINGS.

NOTE: in some cases, data may be excluded.

  • No data is reported for SKUs that are inactive.
  • No data is reported for Bundle SKUs. While sales from the Bundle SKU are included in velocity metrics used to calculate forecast and replenishment suggestions, only the component SKUs that would be reordered are displayed in the report.

 


Related articles: 

FAQs: Velocity, Forecasting & Replenishment
What data is included in the Inventory Report - Sales Velocity Report?
Overview: INVENTORY REPORTS page
How to: Create a Purchase Order?


Comments

Please sign in to leave a comment.




Community    browse  

COMMUNITY FORUMS
FEATURE REQUESTS

Questions & Answers

Issues & Bugs

Productivity

Partners

Shipping

Inventory

Marketing