Question: Please note that this problem has four parts (a, bc, and d). You may need...

Transcribed Image Text:

Question: Please note that this problem has four parts (a, bc, and d). You may need to scroll the screen down and navigate left and right to see the whole problem. Clearly label your parts when answering. You are allowed a Maximum of 3 Files for this problem. Show all calculations/results to at least FOUR PLACES AFTER THE DECIMAL POINT (except when all succeeding digits are zeros). Must show work completely (including all calculations/steps). Failure to do so will result in a score of "0," even if your final answer is correct. York Lane Computers (YLC) has collected the following data of actual laptop sales in the past six months, from September 2022 (month 1) to February 2023 (month 6). Month Sales (units) September October 325 181 November December 154 201 January 186 February 153 a) Cathy is a new manager of YLC, and she wants you to use a weighted moving average to forecast for the month of March with weights of 0.15, 0.20, and 0.65 for December, January, and February, respectively. b) Calculate the sales forecast for the month of March using simple exponential smoothing with a = 0.25 when the forecast for the month of January is 242 units. c) Cathy also would like you to calculate the exponential smoothing with trend forecast of March for the above data using an (Alpha) a of 0.30, a (delta) & of 0.40, a January forecast with trend [FIT January] of 350 units and an estimated January trend [TJanuary] of -2.5200, respectively. d) Based on a certain forecasting method, Cathy forecasted sales for each month and the actual sales of each month data are summarized in the table below. Use Tracking Signal (TS) to evaluate the accuracy of the following forecasting method (from September to February). Assume that Cathy would flag the forecast/s with signals outside the 36. You must show your work by filling out the table. Is this a good or poor forecasting model? Briefly state your reason. d) Based on a certain forecasting method, Cathy forecasted sales for each month and the actual sales of each month data are summarized in the table below. Use Tracking Signal (TS) to evaluate the accuracy of the following forecasting method (from September to February). Assume that Cathy would flag the forecast/s with signals outside the 36. You must show your work by filling out the table. Is this a good or poor forecasting model? Briefly state your reason. [A simple YES or NO answer receives ZERO mark.] Month Actual Forecast Forecast Sales Sales Error Cumulative Deviation (RSFE) Absolute Deviation Sum of Absolute MAD TS Deviation September 325 252 October 181 185 November 154 167 December 201 121 January 186 188 February 153 203 When you completed a question, upload the solution immediately before moving to the next question. If this is your last question, then submit the Test. Remember: Ensure your image/s is/are uploaded BEFORE the last minute. During the last minute of the test/exam, it is possible that your file/s attaching/uploading process may not be completed and time might be over resulting in test/exam being closed. It is your responsibility to make sure your solution file/s are uploaded on time, failure to do so may result in your answers not being recorded or marked. Note: Before uploading, check file/s is/are executing appropriately and visible. Question: Please note that this problem has four parts (a, bc, and d). You may need to scroll the screen down and navigate left and right to see the whole problem. Clearly label your parts when answering. You are allowed a Maximum of 3 Files for this problem. Show all calculations/results to at least FOUR PLACES AFTER THE DECIMAL POINT (except when all succeeding digits are zeros). Must show work completely (including all calculations/steps). Failure to do so will result in a score of "0," even if your final answer is correct. York Lane Computers (YLC) has collected the following data of actual laptop sales in the past six months, from September 2022 (month 1) to February 2023 (month 6). Month Sales (units) September October 325 181 November December 154 201 January 186 February 153 a) Cathy is a new manager of YLC, and she wants you to use a weighted moving average to forecast for the month of March with weights of 0.15, 0.20, and 0.65 for December, January, and February, respectively. b) Calculate the sales forecast for the month of March using simple exponential smoothing with a = 0.25 when the forecast for the month of January is 242 units. c) Cathy also would like you to calculate the exponential smoothing with trend forecast of March for the above data using an (Alpha) a of 0.30, a (delta) & of 0.40, a January forecast with trend [FIT January] of 350 units and an estimated January trend [TJanuary] of -2.5200, respectively. d) Based on a certain forecasting method, Cathy forecasted sales for each month and the actual sales of each month data are summarized in the table below. Use Tracking Signal (TS) to evaluate the accuracy of the following forecasting method (from September to February). Assume that Cathy would flag the forecast/s with signals outside the 36. You must show your work by filling out the table. Is this a good or poor forecasting model? Briefly state your reason. d) Based on a certain forecasting method, Cathy forecasted sales for each month and the actual sales of each month data are summarized in the table below. Use Tracking Signal (TS) to evaluate the accuracy of the following forecasting method (from September to February). Assume that Cathy would flag the forecast/s with signals outside the 36. You must show your work by filling out the table. Is this a good or poor forecasting model? Briefly state your reason. [A simple YES or NO answer receives ZERO mark.] Month Actual Forecast Forecast Sales Sales Error Cumulative Deviation (RSFE) Absolute Deviation Sum of Absolute MAD TS Deviation September 325 252 October 181 185 November 154 167 December 201 121 January 186 188 February 153 203 When you completed a question, upload the solution immediately before moving to the next question. If this is your last question, then submit the Test. Remember: Ensure your image/s is/are uploaded BEFORE the last minute. During the last minute of the test/exam, it is possible that your file/s attaching/uploading process may not be completed and time might be over resulting in test/exam being closed. It is your responsibility to make sure your solution file/s are uploaded on time, failure to do so may result in your answers not being recorded or marked. Note: Before uploading, check file/s is/are executing appropriately and visible.