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 … 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 … Read More