• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Demand Planning using historical data

G

gocvac

New Member
What would be the best way to develop a dynamic forecasting tool in Excel using historical data? Each week new data would be added that I would like to influence future forecasts. I would like like to be able to forecast new items by connecting them to "like" items.
 
Collect a Table of Data with sufficient number of fields to allow future analysis

Add a report to extract suitable data and sort

Forecast using a suitable algorithm based on your business model, This may be as simple as a straight linear regression/extrapolation or it may feed into a whole business model.
 
You must log in or register to reply here.
Back
Top