PLEASE HELP!!!
. APA, MLA) 7. KEY POINTS TO FOLLOW FOR THE HOMEWORK SUBMISSION: . You should upload your completed homework assignment on Canvas as a PDF file or Microsoft Word file (doc, docx). I would prefer one PDF or Word file that combines scans or pictures of your handwritten work (e-g-questions/problems worked out by hand) with your typewritten work. For clarity, please put one picture (or image) per page. If you are NOT uploading your completed homework assignment as a PDF or Word file, you can upload it as JPEG images that are CLEAR and READABLE. If you use software (eg, Microsoft Excel), you must also upload your original software file(s) on Canvas. Please make sure the scans or pictures of your handwritten work are CLEAR and READABLE. I expect your homework submission to contain detailed step-by-step work for each question to receive a fair, objective assessment. Please name your submission appropriately, e.g., HW4_LASTNAME FIRSTNAME. You must include your full name and G-number in the final document you upload on Canvas 1. (SHOW YOUR COMPLETE WORK) The actual sales data for a product being sold at a local retailer during the past eight months are shown below: ACTUAL SALES MONTH (number of units sold) Eight months ago Seven months ago 339 Six months ago 338 Five months ago Four months ago Three months ago 337 Two months ago 335 One month ago 342 THIS MONTH ACTUAL SALES NOT KNOWN 336 341 336 Determine the sales forecast for THIS MONTH using each of the following methods: a A 3-month moving average. [3 points) b. A 5-month weighted moving average using weights of 41, 12, 4, 2, and 1 for one month ago, two o 05 to search RI no account Bolonui Homework this week 1416 - Homework 4 (Oct 22) 418 - HW H7 60ot at Date Use Assigntbetta Quiz #lecoctial 381 Chapter 9 toota Exam2 tout ty 401 - Ch 8 reading (Oct is) Group paper #21 Oct ) # for customer customer 2 2333 351 fres Homework Assignment Homework 4-MGT416- X o file:///C:/Users/sbembridk/AppData/local/Packages/Microsoft Microsoft EdgeSwekyb3dabbwe/Tempta - + Rt to page Page view A Read aloud L Add notes OP months ago three months ago, four months ago, and five months ago, respectively. [10 points] (Hint: the higher weights are applied to the more recent time periods.) c Exponential smoothing using the following smoothing constant, a=0.4 and the sales forecast for three months ago 338 units. [12 points] 2. (SHOW YOUR COMPLETE WORK) A store manager has been monitoring the demand for 1- gallon milk bottles. The actual demand data during the last five months are shown below. MONTH ACTUAL DEMAND (number of milk bottles sold) Five months ago 302 Four months ago 326 Three months ago 346 Two months ago 370 One month ago 390 THIS MONTH ACTUAL DEMAND NOT KNOWN Use trend-adjusted exponential smoothing to obtain the demand forecast for THIS MONTH. Use the following Exponentially smoothed forecast five months ago = 281 milk bottles Exponentially smoothed trend estimate five months ago = 22 milk bottles The smoothing constants: a = 0,4,8 =0.5. [32 points! 3. (SHOW YOUR COMPLETE WORK) The actual demand data over the past eight months for a brand new product are shown below: ACTUAL DEMAND MONTH (number of units sold) February 2020 656 March 2020 600 April 2020 ere to search e 560 no ner account Homework this week 14166-Homework 4 (Oct 22) 418 - HW H7 foot tat Data use Assiantbetta Quiz #lecoctial 1381 Chapter 9 toca Bolonui me #for customer a customer inglest is) ank Homework Assignment 4 Homework 4-MGT416 X o file:///C:/Users/sembrick/AppData/local/Packages/Microsoft.Microsoft Edge_8wekyb3dsbbwe/Tempsta Add notes + Ritto page Page view A Read aloud I W WC JTU One month ago 390 THIS MONTH ACTUAL DEMAND NOT KNOWN Use trend adjusted exponential smoothing to obtain the demand forecast for THIS MONTH. Use the following: Exponentially smoothed forecast five months ago = 281 milk bottles Exponentially smoothed trend estimate five months ago = 22 milk bottles The smoothing constants: a =0.4, B =0.5. [32 points) 3. (SHOW YOUR COMPLETE WORK) The actual demand data over the past eight months for a brand new product are shown below: MONTH ACTUAL DEMAND (number of units sold) February 2020 656 March 2020 600 April 2020 560 May 2020 524 June 2020 492 July 2020 472 August 2020 470 September 2020 466 a Plot the monthly demand data using a software OR on a sheet of graph paper. [3 points) b. Use TREND PROJECTIONS method to determine the equation of the trend line estimating the linear relationship between time (in months) and demand (in units sold). [25 points) c. Use the equation of the trend line to predict demand for the month of October 2020. (2 points) (Hint: February 2020' will have a value of 'l' in the equation of the trend line, and by the same logic "September 2020' will have a value of 'S' in the equation of the trend line.) o e here to search ther Bolonus Homework this week 14166- Homework 4 (Oct 22) 418-HWH 7 Coot tat Data USC Assigntbetta fyiz #lecockat account . APA, MLA) 7. KEY POINTS TO FOLLOW FOR THE HOMEWORK SUBMISSION: . You should upload your completed homework assignment on Canvas as a PDF file or Microsoft Word file (doc, docx). I would prefer one PDF or Word file that combines scans or pictures of your handwritten work (e-g-questions/problems worked out by hand) with your typewritten work. For clarity, please put one picture (or image) per page. If you are NOT uploading your completed homework assignment as a PDF or Word file, you can upload it as JPEG images that are CLEAR and READABLE. If you use software (eg, Microsoft Excel), you must also upload your original software file(s) on Canvas. Please make sure the scans or pictures of your handwritten work are CLEAR and READABLE. I expect your homework submission to contain detailed step-by-step work for each question to receive a fair, objective assessment. Please name your submission appropriately, e.g., HW4_LASTNAME FIRSTNAME. You must include your full name and G-number in the final document you upload on Canvas 1. (SHOW YOUR COMPLETE WORK) The actual sales data for a product being sold at a local retailer during the past eight months are shown below: ACTUAL SALES MONTH (number of units sold) Eight months ago Seven months ago 339 Six months ago 338 Five months ago Four months ago Three months ago 337 Two months ago 335 One month ago 342 THIS MONTH ACTUAL SALES NOT KNOWN 336 341 336 Determine the sales forecast for THIS MONTH using each of the following methods: a A 3-month moving average. [3 points) b. A 5-month weighted moving average using weights of 41, 12, 4, 2, and 1 for one month ago, two o 05 to search RI no account Bolonui Homework this week 1416 - Homework 4 (Oct 22) 418 - HW H7 60ot at Date Use Assigntbetta Quiz #lecoctial 381 Chapter 9 toota Exam2 tout ty 401 - Ch 8 reading (Oct is) Group paper #21 Oct ) # for customer customer 2 2333 351 fres Homework Assignment Homework 4-MGT416- X o file:///C:/Users/sbembridk/AppData/local/Packages/Microsoft Microsoft EdgeSwekyb3dabbwe/Tempta - + Rt to page Page view A Read aloud L Add notes OP months ago three months ago, four months ago, and five months ago, respectively. [10 points] (Hint: the higher weights are applied to the more recent time periods.) c Exponential smoothing using the following smoothing constant, a=0.4 and the sales forecast for three months ago 338 units. [12 points] 2. (SHOW YOUR COMPLETE WORK) A store manager has been monitoring the demand for 1- gallon milk bottles. The actual demand data during the last five months are shown below. MONTH ACTUAL DEMAND (number of milk bottles sold) Five months ago 302 Four months ago 326 Three months ago 346 Two months ago 370 One month ago 390 THIS MONTH ACTUAL DEMAND NOT KNOWN Use trend-adjusted exponential smoothing to obtain the demand forecast for THIS MONTH. Use the following Exponentially smoothed forecast five months ago = 281 milk bottles Exponentially smoothed trend estimate five months ago = 22 milk bottles The smoothing constants: a = 0,4,8 =0.5. [32 points! 3. (SHOW YOUR COMPLETE WORK) The actual demand data over the past eight months for a brand new product are shown below: ACTUAL DEMAND MONTH (number of units sold) February 2020 656 March 2020 600 April 2020 ere to search e 560 no ner account Homework this week 14166-Homework 4 (Oct 22) 418 - HW H7 foot tat Data use Assiantbetta Quiz #lecoctial 1381 Chapter 9 toca Bolonui me #for customer a customer inglest is) ank Homework Assignment 4 Homework 4-MGT416 X o file:///C:/Users/sembrick/AppData/local/Packages/Microsoft.Microsoft Edge_8wekyb3dsbbwe/Tempsta Add notes + Ritto page Page view A Read aloud I W WC JTU One month ago 390 THIS MONTH ACTUAL DEMAND NOT KNOWN Use trend adjusted exponential smoothing to obtain the demand forecast for THIS MONTH. Use the following: Exponentially smoothed forecast five months ago = 281 milk bottles Exponentially smoothed trend estimate five months ago = 22 milk bottles The smoothing constants: a =0.4, B =0.5. [32 points) 3. (SHOW YOUR COMPLETE WORK) The actual demand data over the past eight months for a brand new product are shown below: MONTH ACTUAL DEMAND (number of units sold) February 2020 656 March 2020 600 April 2020 560 May 2020 524 June 2020 492 July 2020 472 August 2020 470 September 2020 466 a Plot the monthly demand data using a software OR on a sheet of graph paper. [3 points) b. Use TREND PROJECTIONS method to determine the equation of the trend line estimating the linear relationship between time (in months) and demand (in units sold). [25 points) c. Use the equation of the trend line to predict demand for the month of October 2020. (2 points) (Hint: February 2020' will have a value of 'l' in the equation of the trend line, and by the same logic "September 2020' will have a value of 'S' in the equation of the trend line.) o e here to search ther Bolonus Homework this week 14166- Homework 4 (Oct 22) 418-HWH 7 Coot tat Data USC Assigntbetta fyiz #lecockat account