Forecast and Inventory Planning Report

You also have options to show which types of forecasts Amazon used in their report and download these reports to include in your own forecasting models. The dropdown menus at the top of the right side of the page will allow you to choose which data you wish to have in report. Your distributive view options can either be sourcing, which means you are viewing the products you sourced from another party and shipped to Amazon or manufacturing, which means you are viewing products.

You ship from your own manufacturing warehouse. The sales view options can either be ordered units, which are the units, Amazon audited, or shipped units, which are the actual units you shipped further drop down menus will be category, subcategory and brand. If you sell multiple brands. Your reporting range options can be daily or weekly.

Your viewing can then be a variety of options, depending on which of the reporting ranges you selected.

Once you have selected your data criteria from these dropdown menus, you would need to select apply in order for the reports below to be updated accordingly. Once you have the selected views in place, you can then opt to download the various options for reports by clicking on the download button in the top right hand side of the page.

Further to this, the graph below the selection criteria drop down menus can also be amended to show you even further data selection you can include or exclude ordered units from your report. You can include or exclude mean forecast from your report, you can include or exclude P 70 forecast from your report.

You can include or exclude P 80 forecast from your report. You can include or exclude P 90 forecast from your report.

The table below the graph also allows for further manipulation. You can choose to view by ASIN, subcategories or category. You can add additional ASIN identifiers for easier reference to your catalog or other internal reports from your own systems. And you can select your forecast option again here too.

This version of the forecasting and inventory planning model gives you additional data such as. Replenishable out of stock glance views, the product received when it was out of stock, but replenishable as a percentage of total product glance, views, glance views, the product received when it was out of stock, but replenishable as a percentage of total product glance views across all ASINs replenishable out of stock glance views, the product received when it was out of stock, but replenishable as a percentage of total product glance views from the previous period.

Ordered units, ordered units as a percentage increase or decrease against the prior period, unfilled customer ordered units available inventory, available inventory as a percentage increase or decrease from the prior period weeks on hand, open purchase order quantity, open purchase order quantity as a percentage increase or decrease from the prior period.

Receive fill rate as a percentage overall vendor lead time in number of days and the replenishment category. And there on we’ll have the same information as from your basic Amazon retail analytics dashboard. Your forecasting an inventory planning model off of Amazon’s vendor central can greatly assist you in forecasting and planning your inventory to supply Amazon and thereby reduce the risk of being unable to supply Amazon with certain ASINs, especially if you are outsourcing your product and rely on it to be shipped by sea or air to your own warehouse from where you ship to Amazon or its customers.

The ordered units shows you what ASINs ordered in the past. And can give you an overview of a trend when compiled over several months to a year. For example, you may find that the red version of one of your products tends to sell better over the first of season, whereas throughout the rest of the year, doesn’t seem to do well at all.

You can then know to build in a seasonality percentage into your forecast and planning model for that ASIN. The mean forecast is Amazon’s best estimate of a customer demand for each particular ASIN and as probably the forecast you would most likely use in your own forecasting model, especially if you’re using Amazon’s forecasting report for the first time.

The P 70 forecast is Amazon’s estimate of a 70% probability that the customer demand will be at or below this value. This is an important option to look at as it’ll most likely apply more strongly to your slow moving ASINs in your planning and forecasting model.

The P 80 forecast is Amazon’s estimate of an 80% probability that the customer demand will be at or below this value. This is an important option to look at as it will most likely apply more strongly to your consistently moving ASINs in your planning and forecasting model that rarely tend to dip or spike at all.

The P 90 forecast is Amazon’s estimate of a 90% probability that the customer demand will be at or below this value. This is an important option to look at as it will most likely apply more strongly to your fast moving ASINs in your planning and forecasting model that are most sought after by consumers.

The forecasting model that Amazon provides can offer you an in depth, look at each one of your ASINs as they perform on Amazon and can provide you with vital Intel as to how consumers engage with your brand overall, as well as each individual ASIN, thus assisting you to better plan your inventory holding for Amazon sales specifically and greater alleviate shortages or unfulfilled units to Amazon’s fulfillment centers.