Question: Suppose the weekly demand for a call centre is shown in the table below. Apply the moving average and exponential smoothing methods to forecast the

Suppose the weekly demand for a call centre is shown in the table below. Apply the moving average and exponential smoothing methods to forecast the demand for Week 17. Assume the following: Simple moving average method: two-week moving average Single exponential smoothing method: assume the 1st week forecast is 333 and =0.65. Include the MSE, MAD and MAPE in your calculations. Based on your results, recommend which method should be used and give reasons to support your recommendation.

Week	Demand (Number of calls)
1	300
2	360
3	410
4	289
5	279
6	302
7	376
8	329
9	248
10	322
11	503
12	511
13	399
14	402
15	380
16	469

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!

Month Demand (thousands) 51 1 2 3 53 62 4 74 Assume that there is a production plant producing bicycles. You are working in this plantas an industrial engineer. You have monthly data for bicycles...

Demand (thousands) 51 53 62 74 87 91 95 87 75 64 Assume that there is a production plant producing bicycles. You are working in this plantas an industrial engineer. You have monthly data for bicycles...

What type of company was studied? What kind of product did they sell? What is their geographic reach? Why is demand forecasting in this business? What types of models did the author use? Please give...

Part 1. The company sells higher-end custom-design socks in three-sock sets (rather than two). The company operates from a small packaging and distribution facility in Richmond, CA from which it...

1. Throx sells higher-end custom-design socks in three-sock sets (rather than two). The company operates from a small packaging and distribution facility in Richmond, CA from which it ships product...

Analytics Exercise 18-2 (Algo) Starbucks has a large, global supply chain that must efficiently supply over 17,000 stores. Although the stores might appear to be very similar, they are actually very...

Explain each question in details. Throx sells higher-end custom-design socks in three-sock sets (rather than two). The company operates from a small packaging and distribution facility in Richmond,...

Suppose the sales for ABC Corp. are shown in the table below. a ) Use linear regression method to forecast the demand for Quarter 1 of Year 4 . ( Note that Year 2 , Quarter 1 should be changed to...

I need help in this question. Please do it correctly and dont make it wrong. Please do it on MS WORD and copy/paste here and use the below formulas to do it. Question 5 (40 points) The last seven...

1 Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Forecasts MA(3) = MA(5) = MAE MA(3) MA(5) Part Grader b c Orders MA(3) MA(5) Delivered Forecast Forecast 120 90 100 75 110 50 75 130 110 90 Value...

Michelle Pass more is purchasing a $25,000 automobile, which is to be paid for in 60 monthly installments of $489.15. What effective annual interest is she paying for this financing arrangement?

When might data analytics be appropriate for making a decision? When data is dirty and making an unethical decision? When data suggest making an unethical decision When data does not exist in a...

Entries for payroll and payroll taxes The following information about the weeldy payroll was obtained from the records of Saine Ca . : Salaries: \ table [ [ Sales salaries,$ 6 2 5 , 0 0 0 Show all...

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...