Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The dollar value of monthly sales for Illini volleyball t-shirts with Vrankovics name and player number 6 at the Gameday Store on Gregory Drive is

The dollar value of monthly sales for Illini volleyball t-shirts with Vrankovic’s name and player number 6 at the Gameday Store on Gregory Drive is given below:

MonthSales
13470
23620
33280
43830
53180
63420

Please indicate the formula you use to show your work. Note that you are asked to generate forecasts for multiple months; however, you are only required to explain your logic once, i.e., for one of the months, to avoid unnecessary duplication.

Create forecasted values for sales using three-period moving averages, i.e., MA(3). (6 points)

Compute the mean absolute error (MAD) for the MA(3) forecast generated. (6 points)

Use alpha = 0.2 for exponential smoothing and calculate forecasted values for months 2-7. (8 points)

Step by Step Solution

3.58 Rating (155 Votes )

There are 3 Steps involved in it

Step: 1

To generate forecasts using a threeperiod moving average MA3 we take the average of the sales for the current month and the two preceding months For e... 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

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

Niebels Methods, Standards and Work Design

Authors: Andris Freivalds, Benjamin Niebel

13th edition

978-0073376363, 73376361, 978-0073376318

More Books

Students also viewed these General Management questions