• 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.

Forecast units sales

Kmahraz

Kmahraz

Member
Hello,
I was wondering if there's a way to forecast units sales, I have captured the unit sold in the last 3 years and wanted to see if i can use that data to predict next year.
Any help will be much appreciated.

Thanks
K
 

Attachments

  • Forecast Unit sold 2017.xls
    29 KB · Views: 8
@Kmahraz
If You're wondering to get 'forecast' then
there should be much much more data!
... or the result would be as GUESS!
'Forecasting' from ONE value ... yes ...
it would be next year ... something or nothing!
Anyway, I did sample for You and You would notice ... not good/work!
ex 3/8 TF ... if Sales/QTY has ... crushed down ... then You would pay 2017!
If You could have 36 months same kind of data then ...
it would be give something better.
 

Attachments

  • Forecast Unit sold 2017.xls
    46.5 KB · Views: 16
Hi @vletm
Thank you so much for the help, you are correct that we need more data to be able to forecast better, I was looking for the method on how, and your solution is perfect,
I will collect more data and use your suggestions to come up with a better forecast.
Thanks again Mate!

K
 
You must log in or register to reply here.
Back
Top