1 4 Given the following data for demand at the XYZ Company, calculate the monthly forecast using a 4 month m oving average Calculate the Forecast, Error, MAD (mean absolute percentage error), Bias and the TS (tracking signal) Period Demand Forecast Error MAD Bias TS 2 Oct 20 20 850 2 Nov 20 20 950 2 Dec 20 20 900 2 Jan 20 21 1000 2 Feb 20 21 950 2 Mar 20 21 1050 2 Apr 20 21 850 2 M a y 2021 8 00 2 June 2021 9 00 2 J ul y 2021 1 000

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

Question: 1 4 . Given the following data for demand at the XYZ Company, calculate the monthly forecast using a 4 -month m oving average .

14. Given the following data for demand at the XYZ Company, calculate the monthly forecast using a 4-month moving average. Calculate the Forecast, Error, MAD (mean absolute percentage error), Bias and the TS (tracking signal) .

Period	Demand	Forecast	Error	MAD	Bias	TS
2-Oct 2020	850
2-Nov 2020	950
2-Dec 2020	900
2-Jan 2021	1000
2-Feb 2021	950
2-Mar 2021	1050
2-Apr 2021	850
2-May 2021	800
2-June 2021	900
2-July 2021	1000

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!

Hello dear Please if its posible to provide the answers with the respectives formulae gonna be great. Thanks 15. Given the following data for demand at the XYZ Company, calculate the monthly forecast...

Given the following data for demand at the XYZ Company, calculate the monthly forecast using a 4-month moving average. Calculate the Forecast, Error, MAD (mean absolute percentage error), Bias and...

please look well at the question and all the requirements. And also privide or write down the formulaes in order for me to apply it in my excel. please and thanks dear. 14. Given the following data...

Given the following data for demand at the XYZ Company, calculate the monthly forecast for 2003 using a 3-month moving average. Calculate the Forecast, Error, MAD (mean absolute percentage error),...

Given the following data for demand at the XYZ Company, calculate the monthly forecast using a 3-month moving average and simple exponential smoothing (SES) with a = 0.4. When using SES, use the...

supply chain management Given the following data for demand at the XYZ Company, calculate the monthly forecast for 2003 using a 3-month moving average. Calculate the MAD and the tracking signal. Is...

a) Briefly state the basic, six-step approach to help an organization perform effective forecasting. (6 marks) b) Given the following data for demand at the XYZ Company shown in table 1, i) Calculate...

Case Study Adam James is the CEO of Southern Industries Ltd, a manufacturer of air conditioners for the commercial and Housing sector. His supply chain manager informed him that a special team would...

C. Given the following data for demand at Southern Industries Ltd, calculate the forecast for periods 4-10 using a 3-period weighted moving average. The weight of 0.5, 0.3 and 0.2 are assigned to the...

Characterize several different types of real- time processing in OLRS.

Michelson actually made 100 measurements on the velocity of light in five trials of 20 observations each. The second set of 20 measurements is shown in Table 6E.28 (a) Plot these new measurements on...

Which of the following situations would indicate increased inherent risk in the accounts payable and acquisition cycle? good quality internal controls for cash handling the use of clear, standard...

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...