Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Problem 2: Forecasting (10 points) Given these sales figures over the last 6 weeks, your boss needs you to test two different forecasting methods (parts

image text in transcribed
Problem 2: Forecasting (10 points) Given these sales figures over the last 6 weeks, your boss needs you to test two different forecasting methods (parts a and b below) to determine which method is best. For your measure of "best", recommend to your boss that the company should use the method with the lowest mean absolute deviation (MAD). Then use that method to provide your forecast for week 7 in part c. Week UWN Unit Sold 523 587 622 601 615 578 a) Create a 3 period moving average forecast for weeks 4-7 and then calculate the MAD. (4 points). b) Create a 2 period weighted moving average forecast for weeks 3-7 and then calculate the MAD. Use weights of 0.6 and 0.4, with the most recent observation weighted higher (4 points) c) How many units would you forecast will be sold in week 7? (2 points)

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

International Trade Finance

Authors: Indian Institute Of Banking & Finance

1st Edition

9386394723, 978-9386394729

More Books

Students also viewed these Finance questions