Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Demand (Yt) for milk (in gallons) at a local grocery store is as follows during the past 8 months. Week Demand (Yt) 1 200 2

Demand (Yt) for milk (in gallons) at a local grocery store is as follows during the past 8 months.

Week

Demand (Yt)

1

200

2

210

3

190

4

185

5

198

6

205

7

195

8

207

  1. What are the forecasted demands (Ft) using the 3 MA (3-period moving average) method and the exponential smoothing method (use =0.2)? Please show all the relevant calculations. (10 points)
  2. Calculate the MAE, MSE & MAPE values for the 3 MA (3-period moving average) method and the exponential smoothing method ( use =0.2). Please show all the relevant calculations. Which method do you recommend for future demand predictions based on the MAPE criterion and why?

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

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

Step: 2

blur-text-image

Step: 3

blur-text-image

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

Introduction To Business Statistics

Authors: Ronald M. Weiers

7th Edition

978-0538452175, 538452196, 053845217X, 2900538452198, 978-1111524081

Students also viewed these Economics questions