Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

As an industrial engineer working for a manufacturing company, your task is to forecast the demand.a . Using Winter's method, calculate the one - step

As an industrial engineer working for a manufacturing company, your task is to forecast the demand.a. Using Winter's method, calculate the one-step and two-step demand forecasts for the upcoming two
3-month periods (i.e., Jan-Mar 2024 and Apr-Jun 2024). Show each step of your work.
b. Suppose that the demand for Jan-Mar 2024 turns out to be 1800 units. Update the forecasting model
using the following smoothing parameters: (level) of 0.3,(trend) of 0.2, and (seasonality) of 0.1.
Using the updated model, forecast the demand for Apr-Jun 2024.
c. Suppose that the demand for Apr-Jun 2024 turns out to be 2200 units. What is the MAPE value for
your one-period-ahead forecasts? That means you must use your Jan-Mar 2024 forecast from part a
and Apr-Jun 2024 forecast from part b.
d. Suppose that the demand for Apr-Jun 2024 turns out to be 2200 units. What is the MAPE value for
your two-period-ahead forecasts? That means you can only use your Apr-Jun 2024 forecast from part
a.
You have access to the historical data for the past 2 years.
3-month Period Demand (units)
Jan-Mar 20223200
Apr-Jun 20223600
Jul-Sep 20223600
Oct-Dec 20224000
Jan-Mar 20232600
Apr-Jun 20232400
Jul-Sep 20232400
Oct-Dec 20232200
a. Using Winters method, calculate the one-step and two-step demand forecasts for the upcoming two
3-month periods (i.e., Jan-Mar 2024 and Apr-Jun 2024). Show each step of your work.
b. Suppose that the demand for Jan-Mar 2024 turns out to be 1800 units. Update the forecasting model
using the following smoothing parameters: \alpha (level) of 0.3,\beta (trend) of 0.2, and \gamma (seasonality) of 0.1.
Using the updated model, forecast the demand for Apr-Jun 2024.
c. Suppose that the demand for Apr-Jun 2024 turns out to be 2200 units. What is the MAPE value for
your one-period-ahead forecasts? That means you must use your Jan-Mar 2024 forecast from part a
and Apr-Jun 2024 forecast from part b.
d. Suppose that the demand for Apr-Jun 2024 turns out to be 2200 units. What is the MAPE value for
your two-period-ahead forecasts? That means you can only use your Apr-Jun 2024 forecast from part
a.
image text in transcribed

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

Operations Management An Integrated Approach

Authors: R. Dan Reid, Nada R. Sanders

6th edition

1118952618, 978-1118952559, 1118952553, 978-1118952610

More Books

Students also viewed these General Management questions

Question

1. Does the parent brand have strong equity?

Answered: 1 week ago