Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Table 2. The manager of Carpet City outlet store needs to be able to forecast accurately demand for Soft Shang carpet. Demand for the past

image text in transcribed
image text in transcribed
Table 2. The manager of Carpet City outlet store needs to be able to forecast accurately demand for Soft Shang carpet. Demand for the past 20 wecks appears in table 1 below weck Demand Forecadad Ahe Des Som AS 120 4 22 18 22 22 22 o 10 lii 13 12 23 23 bu 127 125 13 116 11 18 19 120 123 14 14 15 11 16 22 23 14 Using the exponential smoothing forecasting techniques with a =40. a). Compute the exponentially smoothed forecast average without trend: Use this formula F,=(A.-) +(1-a) F... to calculate separately the forecast for all the required weeks in the table provided, before inserting the answers from your calculations in the forecast column of the table. b). Calculate the Mean Absolute Deviation (MAD) e). Mean Square Error (MSE). d). Mean Absolute Percentage Error (MAPE). Table 2. The manager of Carpet City outlet store needs to be able to forecast accurately demand for Soft Shang carpet. Demand for the past 20 weeks appears in table I below weck Demand Free Timo Ahe DAPO 20 13 4 18 22 22 16 193 11 12 13 14 16 17 118 19 27 25 22 20 114 14 15 11 16 21 22 ST 14 40. Using the exponential smoothing forecasting techniques with a a). Compute the exponentially smoothed forecast average without trend: Use this formula F,= (A.-1) +(1-a) F1 to calculate separately the forecast for all the required weeks in the table provided, before inserting the answers from your calculations in the forecast column of the table. b). Calculate the Mean Absolute Deviation (MAD). c). Mean Square Error (MSE). d). Mean Absolute Percentage Error (MAPE)

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

Financial Management Theory And Practice

Authors: Eugene F Brigham, Michael C Ehrhardt

11th Edition

0324259689, 9780324259681

More Books

Students also viewed these Finance questions