Let’s start with what a seasonality index is. It is a forecasting tool used to determine demand for various commodities or goods in a given marketplace over the course of a typical year (or a shorter time period).Read More

Figuring out when product inventory will run out seems like a simple enough task, but when you have thousands of items, changing forecasts, and multiple open orders with differing receipt dates, things start to get complicated quickly.  This article will explain how to organize and display your data in a spreadsheet in order to efficiently identify your product run out dates. Read More

Often times in analyzing forecasting metrics you are asked to “weight” the results based on something like number of units sold, or dollar value of the item.  You can use the =SUMPRODUCT function to achieve this, but if you want to use a pivot table to quickly analyze the data in multiple ways then it does not quite cut it.  Luckily there is a way to do this in pivot tables!Read More