Demand Forcasting in Excel

En curso Publicado Nov 14, 2013 Pagado a la entrega
En curso 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.

Excel

Nº del proyecto: #5127341

Sobre el proyecto

7 propuestas Proyecto remoto Activo Nov 14, 2013

Adjudicado a:

workingzone088

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.

$20 USD en 10 días
(0 comentarios)
0.0

7 freelancers están ofertando un promedio de $32 por este trabajo

gitapodder1989

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

$50 USD en 7 días
(2 comentarios)
2.9
sa1968

i have the experience and qualification to undertake this work for you. Please consider my proposal, price negotiable

$25 USD en 10 días
(0 comentarios)
0.0
RonelBenade

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

$35 USD en 5 días
(0 comentarios)
0.0
tatyana27

I have great experience of work with Excel. I do work fast clear and accurately. I guaranty high quality of work done.

$25 USD en 2 días
(0 comentarios)
0.0
mahabur25

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 t Más

$25 USD en 10 días
(0 comentarios)
0.0
bluerain05

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,

$45 USD en 5 días
(0 comentarios)
0.0