Excel Help on making a forecast

Zamknięty Opublikowano 6 lat temu Płatność przy odbiorze
Zamknięty Płatność przy odbiorze

This is a simple excel question composed of multiple parts.

Use the data in the Excel file provided to forecast the demand of a particular product using various methods and time periods as noted below.

NOTE: YOU MUST SHOW ALL YOUR WORK IN THE EXCEL FILE. YOU CAN CREATE NEW WORKSHEETS OR SHOW ADDITIONAL WORK IN THE WORKSHEET PROVIDED.

a. Prepare a time-series plot of the data. Does the data appear to have a trend or seasonality?

b. Use the naïve method to forecast the demand for the last three months of 2016.

c. Use the moving average method with 4 periods, i.e., MA(4), to forecast the monthly demand for January 2016 through December 2016.

d. Use the exponential smoothing method with =0.4 to forecast the monthly demand for January 2016 through December 2016. Use the actual demand observed in January 2015 as your initial forecast for January 2015 (That is, start the model in January 2015.

e. Fit a trend line to the data provided for January 2015 to December 2015. Using the equation of the trend line you found, forecast the monthly demand for January 2016 through December 2016.

f. Compute the MAD for each method, that is, the Naïve, MA(4), ES(0.4), and the trend line during January 2016 to September 2016.

g. Choose one of the time-series methods you analyzed thus far which will provide you the most reliable estimate and why? What are the demand forecasts for the last three months of 2016 if this method is used?

Księgowość Wprowadzanie danych Przetwarzanie danych Excel Matematyka

Numer ID Projektu: #16033865

O projekcie

16 ofert Zdalny projekt Aktywny 6 lat temu

16 freelancerów złożyło ofertę za $43 w tym projekcie

rIbrarahmed

Hi, I am very good in accounting and finance having 6 years of working experience in a multinational organization. For further you can visit my profile. Please contact with me. Thanks

$87 USD w ciągu 1 dnia
(23 Oceny)
4.4
Sindustrus

hi i am expert in excel i can do that task for you

$15 USD w ciągu 1 dnia
(5 Oceny)
2.4
arslanu2

I am working in a business acumen role since four years and I can help your business through a suite of service, I provide.

$250 USD w ciągu 3 dni
(3 Oceny)
2.4
jamalagouram

A proposal has not yet been provided

$30 USD w ciągu 3 dni
(2 Oceny)
2.0
Zaharay

Time to do it on time, and cheap. Relevant Skills and Experience Every skill needed to do this project.

$25 USD w ciągu 1 dnia
(2 Oceny)
1.2
immsohail520

Hi I am new to freelancing but surely not new to accounting and data. Hire me I will work professionally

$25 USD w ciągu 1 dnia
(0 Oceny)
0.0
DataExperrt

expert in data entry work, well known to excel and word too . experienced with other brands and organizations.

$25 USD w ciągu 3 dni
(0 Oceny)
0.0
balaji2656

Dear Employer We will give you the best result by using my Past experience and excellent academic skills on your project. you can chat with me and let's get started.

$25 USD w ciągu 1 dnia
(1 Ocena)
0.1
Kahekashan09

A proposal has not yet been provided

$15 USD w ciągu 7 dni
(0 Oceny)
0.0
uoscar

I am currently a PhD student in Ohio University in the US. I have excellent understanding of the various forecasting techniques: naive method, moving average, exponential-smoothing and trend analysis. I also poss Więcej

$15 USD w ciągu 1 dnia
(0 Oceny)
0.0
ruchi2407

A proposal has not yet been provided

$35 USD w ciągu 3 dni
(0 Oceny)
0.0