Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

3. Sales Forecast: Arabco Dairy, Inc. supplies milk to local grocery stores. Managers at Arabco Dairy hired you to forecast the weekly milk sale. You

image text in transcribed
3. Sales Forecast: Arabco Dairy, Inc. supplies milk to local grocery stores. Managers at Arabco Dairy hired you to forecast the weekly milk sale. You obtained past data about the number of half gallons of milk sold weekly over the past 12 weeks. The data is provided in the "Milk Sales Data" file posted on campus web. Use this file to answer the following questions: a. Construct a time series plot and comment on it. b. Use the moving average technique to forecast the demand for week 13 using 3-period MA and 5period MA and comment on your answer. c. Calculate the MAD, MSE, RSME, and MAPE for each forecast in part b. Compare your answers and determine which MA length is better for your forecast. d. Use the simple exponential smoothing technique to forecast the demand for week 13 using a smoothing constant of 0.4 and comment on your answer. e. Calculate the MSE and RSME for your forecast in part d

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Covered Calls Option Trading Strategy

Authors: Andrew P.C.

1st Edition

1549658697, 978-1549658693

More Books

Students also viewed these Finance questions

Question

please dont use chat gpt AI 3 4 0 .

Answered: 1 week ago