Question: Question 2: Apply Moving Average (k=3) and Exponential Smoothing (alpha =0.1) to the following demand data and forecast the demand for the maximum # period

Question 2: Apply Moving Average (k=3) and Exponential Smoothing (alpha =0.1) to the following demand data and forecast the demand for the maximum # period you can. Calculate, MAD, MSE, and MAPE. Discuss which method is superior.

Week	Demand
1	108
2	116
3	157
4	124
5	96
6	119
7	96
8	101
9	112
10	102
11	98
12	91

Please, solve the problems by using MS Excel.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Question 2: The SC03001 Company sells a new type of products with the following demand data: Period 1 2 3 Demand 300 290 310 The company tries to forecast the demand with the exponential smoothing...

appeso questions 1-3. Weekly sales of ballpeen hammers at a home improvement store have been 14.9,30, 22, 34, 12.19.23 over the past 8 weeks. The following table shows the forecasts for weeks 4, 5...

NT 5160, Fall 2016 Semester Individual Case Assignment: Cutting Edge This case was adapted from Hiller, Frederick S. & Mark S. Hillier (2014). Introduction to Management Science: A Modeling and Case...

University of Derby Derby Business School In-course Assignment Specification Module Code and Title: 7LO510 Supply Chain Analysis and System Modelling Assignment No. and Title: Coursework Assessment...

FORECASTING NOTES 1. Plot the demand given > chart > line. 2. Decide on the appropriate method: a. Static Method - Use it if data exhibits both trend and seasonality; assuming static L,T, & S. b....

Name: Please submit this spreadsheet with your answers to Canvas. This assignment will be due on Nov 8 Go to the first tab (Data), you have the mouthly sales data from the previous 36 months and are...

The following applies to questions 1 -8. Weekly sales of ballpeen hammers at a home improvement store have been 14,9,30,22, 34, 12, 19,23 over the past 8 weeks. The following table shows the...

Your manager has tasked you to find out which of the two forecasting methods: three-month moving average (MA) or exponential smoothing (ES) is suitable for predicting the demand of an item. You have...

(a) Aston Clothiers is a company which makes ladies clothes in Singapore. It purchases fabric from neighbouring countries and makes the dresses in its workshop in Serangoon. Recently, it has decided...

Please run your computations in Excel and answer the questions within Excel as well. The Excel Spreadsheet with the raw data has been posted on Canvas. Once you are done with this assignment, please...

What is the amount of non controlling interest in net income for 20x2? What is the amount of consolidated net income for 20x2? Peter acquired 80% of the outstanding ordinary shares of Simon on...

Well-designed performance evaluation systems accomplish many goals. Requirement 1. Describe the potential benefits performance evaluation systems offer.

The following information on Spud s retailers for the quarter ended June 3 0 : Actual Budgeted May June July August Invoices: Cash 4 0 % Credit 6 0 % R 4 2 0 0 0 0 R 4 5 0 0 0 0 R 4 8 0 0 0 0 R 5 0 0...

ACTIVTY ESTIMATED DURATIONS (WEEKS) - Optimistic Most Likely Pessimistic 1-2 3 6 15 1-3 2 5 14 1-4 6 12 30 2-5 2 5 8 2-6 5 11 17 3-6 3 6 15 4-7 3 9 27 5-7 1 4 7 6-7 4 19 28 a) FIND CRITICAL PATH FOR...