Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I am stuggling with this question can someone please help me ? Question 32 (18 points) Jim's department at a local department store has tracked

I am stuggling with this question can someone please help me ? image text in transcribed
Question 32 (18 points) Jim's department at a local department store has tracked the sales of a product over the last seven weeks. Period Demand 1 24 2 23 3 26 4 36 5 26 6 30 7 32 Round your answers to two decimal places. a) Compute a three-period weighted moving average forecasts for weeks 4, 5, 6, and 7, with weight 6, 4, 3 (largest weight is for most recent data). (4pt) b) Use exponential smoothing with smoothing constant a = 0.4 to forecast sales for weeks 5, 6, and 7. Assume a sales forecast of 30 for week 4. (4pt) c) Compute MAPE for weighted moving average and exponential smoothing (Parts a and b). (7pt) d) Which model is more accurate? (1pt) e) Forecast week 8 with the more accurate method. (2pt)

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

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

Fundamentals Of Financial Accounting

Authors: Fred Phillips, Robert Libby, Patricia Libby

1st Edition

0072992573, 9780072992571

More Books

Students also viewed these Accounting questions