MTH301 Week 8 Homework 1. Month Sales January $450,000 February… MTH301 Week 8Homework  1.MonthSalesJanuary$450,000February$375,000March$4

MTH301 Week 8 Homework 1. Month Sales January $450,000 February… MTH301 Week 8Homework  1.MonthSalesJanuary$450,000February$375,000March$425,000April$475,000May$375,000June  Using a 2 month moving average what would be the sales forecast be for JuneUsing a 3 month moving average what would be the sales forecast  be for JuneUsing a 4 month weighted average with the following weight (30% for the most recent period, 25%for the next period, 25% for the next period and 20% for the furthest period) What would the sales forecast be for the month of June  2.  TSV ForecastErrorSq Error    71     7071-1.001  69     68     64                  Using  a = .1 for exponential smoothing, complete the above chart                              What is the Forecast for period 6?               What is the sum of the squared errors?              What is the Mean Squared Error?         3.  QuarterYear 1Seasonal IndexYear 2Seasonal IndexAverage IndexYear 3 Fall 12,000 1.213,0001.2381.2213,725Winter11,500 11,000   Spring 9,500 9,500   Summer7,000 8,500   Total40,000X42,000XX45,000Average10,000X10,500XX11,250  Fill in the above chart on seasonal averaging.   4.   Here is the sales and profit data for a sporting goods company with 12 stores. Use the data to answer the regression problem #4. Sales in $ millionsProfits in $ millions7.152.106.134.1514.2515.2716.2412.2014.2720.4415.347.17 What is the r value?Do you consider the correlation strong?What is the expected profit when sales are $10 million?   Business Economics Macroeconomics ECO-2020 MISC Share QuestionEmailCopy link