Em Andamento

Demand Forcasting in Excel

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.

Habilidades: Excel

Veja mais: you on demand, mse excel, in demand, how to find power point, how excel works, find power point, turn in to, the power of sales, on-demand, formulas sheets, excel solver, demand, find average numbers, point excel, trend following, answers excel, sep nov, dec 2013, nov 2013, create excel formulas, exponential moving average, questions answers excel, 5000 questions answers, file excel compare, excel sales sheets

Acerca do Empregador:
( 0 comentários ) Hyderabad, India

ID do Projeto: #5127341

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

$20 USD em 10 dias
(0 Comentários)

7 freelancers estão ofertando em média $32 para esse trabalho


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 Mais

$50 USD in 7 dias
(2 Comentários)

Hi Sir WEDOMS is an Online Business Promoting company doing extensive work in the field of Website Designing,Logo designing,Brochure designing, Website Development,Testing and Search Engine Optimization. We are more th Mais

$50 USD in 7 dias
(0 Comentários)

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

$25 USD in 10 dias
(0 Comentários)

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 Mais

$35 USD in 5 dias
(0 Comentários)

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

$25 USD in 2 dias
(0 Comentários)

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 Mais

$25 USD in 10 dias
(0 Comentários)

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 in 5 dias
(0 Comentários)