SuperTutor

(15)

$15/per page/Negotiable

About SuperTutor

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Accounting,Business & Finance See all
Accounting,Business & Finance,Economics,Engineering,HR Management,Math Hide all
Teaching Since: Apr 2017
Last Sign in: 327 Weeks Ago, 5 Days Ago
Questions Answered: 12843
Tutorials Posted: 12834

Education

  • MBA, Ph.D in Management
    Harvard university
    Feb-1997 - Aug-2003

Experience

  • Professor
    Strayer University
    Jan-2007 - Present

Category > Business & Finance Posted 26 May 2017 My Price 8.00

Time Series

Key Objective: Crusty Pizza Executives must forecast December sales for the 10 stores in worksheet "Time Series".

• Use data in worksheet "Time Series". Plot the data for each store.

• Develop a sales forecast for each of the 10 stores for the month of December, using:

a) A three month moving average

b) A 2- month weighted moving average, with weights of 0.7 on the most recent month and 0.3 on the older month.

c) Exponential smoothing with an alpha value of 0.25. Assume February forecast is January's actual.

d) Compute measures of forecast accuracy to recommend the best forecasting technique to use for the data.

e) Rank the 10 stores based on the forecasts you made with the technique that you determined (in the above step) to be the best forecasting method.

Attachments:

Answers

SuperTutor
(15)
Status NEW Posted 26 May 2017 03:05 AM My Price 8.00

-----------

Attachments

file 1495769529-Solutions file.docx preview (51 words )
S-----------olu-----------tio-----------ns -----------fil-----------e -----------Hel-----------lo -----------Sir-----------/Ma-----------dam----------- T-----------han-----------k y-----------ou -----------for----------- yo-----------ur -----------int-----------ere-----------st -----------and----------- bu-----------yin-----------g m-----------y p-----------ost-----------ed -----------sol-----------uti-----------on.----------- Pl-----------eas-----------e p-----------ing----------- me----------- on----------- ch-----------at -----------I a-----------m o-----------nli-----------ne -----------or -----------inb-----------ox -----------me -----------a m-----------ess-----------age----------- I -----------wil-----------l b-----------e q-----------uic-----------kly----------- on-----------lin-----------e a-----------nd -----------giv-----------e y-----------ou -----------exa-----------ct -----------fil-----------e a-----------nd -----------the----------- sa-----------me -----------fil-----------e i-----------s a-----------lso----------- se-----------nt -----------to -----------you-----------r e-----------mai-----------l t-----------hat----------- is----------- re-----------gis-----------ter-----------ed -----------onÂ----------- th-----------is -----------web-----------sit-----------e -----------Tha-----------nk -----------you----------- -----------
Not Rated(0)
Relevent Questions