i am attaching an example on how to do this...and power point instructions if necessary. its mainly about replacing the info and updating the formulas. not that many sheets required, only a few to answer the questions below.
Turn in a single MS Excel file containing your answers.
Sales Yr 1 Yr 2 Yr 3 Yr 4 Yr 5
Jan 2000 2706 3214 3537 3800
Feb 5000 6323 8105 9184 9978
Mar 7000 9494 10361 12666 13238
Apr 11000 15216 16860 18789 21028
May 14500 18000 21298 25576 30828
Jun 19000 25264 29086 30954 37167
Jul 26000 36449 38057 47982 50933
Aug 15000 18503 23695 28530 28663
Sep 10000 13053 15037 17091 21534
Oct 5000 6478 7711 8635 9654
Nov 4500 5665 6874 8531 8876
Dec 3000 4003 4660 4974 5731
*Hint: you'll probably want to make these demand numbers a single column!
Using the table of sales figures listed above, do the following:
1) Moving average forecasts for year 6 using "p+1" as the number of periods to include.
2) Four-month weighted moving average forecasts for year 6, with the weights of 10%, 20%, 30%, and 40% (most recent month last).
3) Simple exponential smoothing forecast for year 6 with an alpha = 0.15.
4) "Static" deseasonalizing method forecast for year 6.
5) Use Winter's method of trend and seasonality corrected exponential smoothing to forecast year 6. Use solver to find the optimal alpha, beta, and gamma.
6) Compare the MAD, MAPE, and MSE for each of the forecasting methods used above. Which method works best?
To be clear, I want you to create something that resembles the "Tahoe Salt" example analysis in Excel.
I am expert in excel and can do your job perfectly. Please check reviews of my past works / projects before awarding the project. You have to release $25 immediately after I accept the offer if you award me the project. If you agree only then I can proceed.
I am a qualified professional with a Masters Degree in Computer Science.
This is a very interesting project! By doing some calculations in Excel, you can easily build a Forecasting model.
I currently build models daily, and have also worked on financial models.
Please feel free to contact me.
Dear sir
I have an experience of over 3 years in data entry and data manipulation field. My key skills include proficiency in MS Excel, MS Word and other MS Office tools, Web search, PDF conversion, data entry, copy typing etc. I am here in Freelancer to prove my skills and to earn through my work. I value my satisfaction in work, so always do work with 100% dedication. And also provide sincere assistance to make my employer satisfied in the project.
Thanks
Mahabur
Hi there,
I'm a logistics and supply chain manager (MS from the U.S.). I'm quite proficient in what you are looking for. Just let me know please if you need my assistance.
Best regards,