Demand Forcasting in Excel
$10-30 USD
Pagado a la entrega
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.
Nº del proyecto: #5127341
Sobre el proyecto
Adjudicado a:
HI, Your Excel expert here.I worked long time with MS office so I can do it properly in right time. you can call me.
7 freelancers están ofertando un promedio de $32 por este trabajo
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 Más
i have the experience and qualification to undertake this work for you. Please consider my proposal, price negotiable
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 model Más
I have great experience of work with Excel. I do work fast clear and accurately. I guaranty high quality of work done.
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,