Comments on: Using Excel To Present & Update Forecasts At The Demand Review

By: Mariusz Lesiewicz

Mariusz Lesiewicz — Mon, 04 Nov 2019 13:29:40 +0000

Hi Witek,

Algorithm takes into consideration 3 factors:
– Base sales – 12 month average
– Sales trend that user can select from pick list (e.g. 6 month trend is an growth index of last 6 month sales vs 6 month sales from analogical period 1 year earlier)
– Seasonality index for each month calculated on 2 years history

Yes, you can increase amount of product groups. If you want to learn more how to do it please drop me a message on LinkedIn, I will share with you instruction.

Mariusz

By: Witek Hubisz

Witek Hubisz — Wed, 30 Oct 2019 13:35:24 +0000

Hi Mariusz,
Are you using special algorithms to determinate forecast?
I have downloaded your version. It seems very similar to that I’ve created and been using over the years. 😉 It seems that you can actually increase amount of product groups, is it correct?

By: Mariusz Lesiewicz

Mariusz Lesiewicz — Wed, 09 Oct 2019 08:57:23 +0000

Hello,

The tool is available under the link at the beginning of the article.

By: Alessandro Racco

Alessandro Racco — Tue, 08 Oct 2019 17:48:32 +0000

Hello,

Very interesting description of the tool. Would it be possible to see the excel tool itself?

By: Matt Littell

Matt Littell — Tue, 08 Oct 2019 13:01:06 +0000

Mariusz, can you share the Excel document you describe in your article? I have created something very similar using pivot charts but would like to see what methods you used to summarize the data including the override method.

By: Kayode Adedigba

Kayode Adedigba — Mon, 07 Oct 2019 19:19:41 +0000

Could you please share the tool with me?

Thanks

Kadedigba@gmail.com