I'm trying to do forecasting for year 2015 based on last year data for call volume ( data avaliable weekwise) ,how to do seasonal forecasting based on volumes. I tried to use FORECAST , but the numbers are not accurate.
I'm trying to do forecasting for year 2015 based on last year data for call volume ( data avaliable weekwise) ,how to do seasonal forecasting based on volumes. I tried to use FORECAST , but the numbers are not accurate.
please add the expected (desired) result in your sheet and post it again.
please also explain the definition of seasonal.
Please also the formula you used and didn't work (forcast)
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Hi,
What values would you calculate manually? If you can tell us that and explain your calculation then we can no doubt encapsulate the logic in a formula.
In short Excel needs some algorithm to work with. In any case and as stated you only mention 'last year data' implying this is the only (or at least most significant) factor. More information is needed.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
Column G has Forecast formula which i have used but not giving me desired result
Column I has expected result or should be close to it. (already forecasted upto 20 weeks )
Seasonal factor means, any spike or dip in volume should be consider for future forecast,
...you need to explain how you have calculated your expected results.
Accidental duplicate of post below...
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Apart from 2011, there is no seasonality, to speak of. As for the general trends - year on year the call number is falling. A polynomial fit would suggest that you'll be out of business in 1 -2 years, with calls in year 4 (2015), being about 10% of those in the first year!! A linear fit gives you a more graceful decline, with 2015 calls being about 45% of those in the first year. Tak your pick (or change your business model!!).
See the sheet for pretty (meaningless) graphs...
Glenn Kennedy
Thanks for picking this item up and your contribution.
Many Thanks Glenn Kennedy, for graphical view of forecast, There is definetely seen decrease in volume year by year , but still I have to do forecast for 2015 and 2016 how much it would be,
@ Richard Buttrey,I have not calculated expected result , it was done by previous employee who has forecast this value, but now unfortunetely he has left the organisation and I actually dont know what was the logic behind this,
Hi
I am looking for a forecast model that can be used for a 80 FTE call centre to predict monthly call volumes.
Can anyone suggest what is the best excel/ suitable tool to be used.
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks