Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Problem 1 - 8 points YEAR 2019 2020 2021 2022 2023 FORECAST 11,800 13,100 14,325 17,030 ? ACTUAL 12,075 13,885 16,015 16,542 DEMAND A. Calculate

image text in transcribed
Problem 1 - 8 points YEAR 2019 2020 2021 2022 2023 FORECAST 11,800 13,100 14,325 17,030 ? ACTUAL 12,075 13,885 16,015 16,542 DEMAND A. Calculate the MAD for the period 2020 - 2022 (2 points) B. Calculate the 2023 forecast using Exponential Smoothing. The smoothing constant (a) is 0.25. (2 points) C. Using the information below and your answer for B above, calculate the quarterly seasonal index and 2023 monthly forecast. (4 points) Sea. 2023 Month 2019 2020 2021 2022 X Index Forecast 1 st QTR 2900 3110 3210 3618 2nd QTR 3050 4175 4425 4517 3 nd QRT 3200 3250 3975 4011 4th QRT 2925 3350 4405 4396 Total

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

Modern Database Management

Authors: Heikki Topi, Jeffrey A Hoffer, Ramesh Venkataraman

10th Edition

0132998440, 9780132998444

More Books

Students also viewed these General Management questions

Question

Make eye contact when talking and listening

Answered: 1 week ago

Question

Do not go, wait until I come

Answered: 1 week ago

Question

Pay him, do not wait until I sign

Answered: 1 week ago