Question: Please sir answer for me these two questions I really need it 6) Given the following data and seasonal index: Month Sales Year 1 Jan

Please sir answer for me these two questions I

Please sir answer for me these two questions I

Please sir answer for me these two questions I really need it

6) Given the following data and seasonal index: Month Sales Year 1 Jan 8 Feb 7 Mar 5 Apr 10 May 9 June 12 July 15 Aug 20 Sept 4 Oct 3 Nov 8 9 Year 2 8 9 6 11 12 16 20 25 4 2 7 9 Dec (a) Compute the seasonal index using only year 1 data. (b) Determine the deseasonalized demand values using year 2 data and year l's seasonal indices. (c) Determine the trend line on year 2's deseasonalized data. (d) Forecast the sales for the first 3 months of year 3, adjusting for seasonality. 7) The following table represents the actual vs. forecasted amount of new customers acquired by a major credit card company: Month Actual Forecast Jan 1024 1010 Feb 1057 1025 March 1049 1141 April 1069 1053 May 1065 1059 (a) What is the tracking signal? (b) Based on the answer in part (a), comment on the accuracy of this forecast 6) Given the following data and seasonal index: Month Sales Year 1 Jan 8 Feb 7 Mar 5 Apr 10 May 9 June 12 July 15 Aug 20 Sept 4 Oct 3 Nov 8 9 Year 2 8 9 6 11 12 16 20 25 4 2 7 9 Dec (a) Compute the seasonal index using only year 1 data. (b) Determine the deseasonalized demand values using year 2 data and year l's seasonal indices. (c) Determine the trend line on year 2's deseasonalized data. (d) Forecast the sales for the first 3 months of year 3, adjusting for seasonality. 7) The following table represents the actual vs. forecasted amount of new customers acquired by a major credit card company: Month Actual Forecast Jan 1024 1010 Feb 1057 1025 March 1049 1141 April 1069 1053 May 1065 1059 (a) What is the tracking signal? (b) Based on the answer in part (a), comment on the accuracy of this forecast

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!