Using the data set provided Make (and state) any necessary assumptions and apply the following forecast method to the earliest two years of actual data Three period simple moving average Cumulative forecast error (CFE) Mean error Mean absolute deviation (MAD) Mean absolute percentage error (MAPE) Tracking signal Shipments Fasteners Jan 17 335798 Feb 17 297853 Mar 17 318399 Apr 17 311730 May 17 363876 Jun 17 296832 Jul 17 297513 Aug 17 321144 Sep 17 317677 Oct 17 325487 Nov 17 272937 Dec 17 276282 Jan 18 335439 Feb 18 310514 Mar 18 407754 Apr 18 356169 May 18 345322 Jun 18 331997 Jul 18 343059 Aug 18 350277 Sep 18 265205 Oct 18 389332 Nov 18 310474 Dec 18 308429 Jan 19 385807 Feb 19 332529 Mar 19 407606 Apr 19 361946 May 19 453432 Jun 19 412892 Jul 19 447359 Aug 19 363769 Sep 19 361232 Oct 19 451421 Nov 19 363724 Dec 19 331619

The Answer is in the image, click to view ...

Question: Using the data set provided; Make (and state) any necessary assumptions and apply the following forecast method to the earliest two years of actual data:

Using the data set provided; Make (and state) any necessary assumptions and apply the following forecast method to the earliest two years of actual data:

Three-period simple moving average

Cumulative forecast error (CFE)

Mean error

Mean absolute deviation (MAD)

Mean absolute percentage error (MAPE)

Tracking signal

Shipments	Fasteners
Jan-17	335798
Feb-17	297853
Mar-17	318399
Apr-17	311730
May-17	363876
Jun-17	296832
Jul-17	297513
Aug-17	321144
Sep-17	317677
Oct-17	325487
Nov-17	272937
Dec-17	276282
Jan-18	335439
Feb-18	310514
Mar-18	407754
Apr-18	356169
May-18	345322
Jun-18	331997
Jul-18	343059
Aug-18	350277
Sep-18	265205
Oct-18	389332
Nov-18	310474
Dec-18	308429
Jan-19	385807
Feb-19	332529
Mar-19	407606
Apr-19	361946
May-19	453432
Jun-19	412892
Jul-19	447359
Aug-19	363769
Sep-19	361232
Oct-19	451421
Nov-19	363724
Dec-19	331619

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!

Using the data set provided, Make (and state) any necessary assumptions and apply the following forecast methods to the earliest two years of actual data: Three-period weighted moving average with...

At the beginning of chapter 8 there is a case study (Kimberly-Clark) discuss what you believe is the most effective actions the company took in their project to improve their forecasting and why. Be...

Forecasting Efficient operations require that managers match supply to demand. As they lack a crystal ball, they must rely on forecisting to help predict future demand. Forecasts then drive decistons...

The question is the last one Chinese Pharmaceuticals (HK) Limited: Effective Forecasting for Optimal Inventory Management Accurate forecasts are vital to our business because they drive all of our...

subject: Differential Equations pls read instructions do not use ai. drop all references and link Instructions ODE application. - find an article related to ODE application - provide a short...

1 Which of the following statements is TRUE regarding time series forecasting methods? a Moving average (MA) method is appropriate for forecasting an item that shows seasonal pattern b By assigning...

I need help with following questions from the homework. I have attached the chapters so please see the attached files to answer the following questions specifically. Ch 4 (p 176 of text or p 34 of...

Please attach Excel file so I can study formulas! Thank you Demand Forecasting for the Inner-city Health Center Inner City Health Center is a federally funded health clinic that serves the needs of...

3.) An air compressor is to compress 8.5 m^3/min from 98.56 kPa to 985.6 kPa, Assuming ideal conditions, and with n 1.3, what will be the saving work in due to two staging? Let P,intercooler =...

(a) Find the Differential Equation (DE) of all circles passing through the origin and having their centres on the x-axis. (b) Find the order and degree of the DE found in 1(a)

Examples of fixed expenses are: Group of answer choices All of these Property taxes & insurance Utilities Management fees

atch the compensation objectives with their meanings. Efficiency Efficiency drop zone empty. Fairness Fairness drop zone empty. Compliance Compliance drop zone empty. Improving performance and...