Table 1.2 shows the number of lawn mowers sold by Mangi Enterprises over a period of...

Transcribed Image Text:

Table 1.2 shows the number of lawn mowers sold by Mangi Enterprises over a period of three years. Table 1.2: Sales Data of Lawn Mowers Monthly sales (units) Feb Mar Jul Sep Oct Dec Jan Apr May 345 Jun Aug Nov 220 380 2016 238 195 245 270 220 280 120 110 85 410 2017 135 185 219 240 420 520 380 320 290 240 145 505 2018 205 230 340 370 395 500 402 360 310 280 540 REQUIRED: Based on the number of lawn mowers sold over the 36 months provided in Table 1.2, compute the following: 3.1 The three-month moving average forecast (MA-3). The six-month moving average forecast (MA-6). On the same graph, plot the actual sales as well as the MA-3 and MA-6 forecasts. Comment briefly, but meaningfully, on the graph plotted in question 3.3. Determine the linear regression equation that describes the relationship between the month of sales and the units of lawn mowers sold monthly and use it to predict the number of units of lawn mowers to be sold in quarter 1 of the 2019 financial year. 3.2 3.3 3.4 3.5 Table 1.2 shows the number of lawn mowers sold by Mangi Enterprises over a period of three years. Table 1.2: Sales Data of Lawn Mowers Monthly sales (units) Feb Mar Jul Sep Oct Dec Jan Apr May 345 Jun Aug Nov 220 380 2016 238 195 245 270 220 280 120 110 85 410 2017 135 185 219 240 420 520 380 320 290 240 145 505 2018 205 230 340 370 395 500 402 360 310 280 540 REQUIRED: Based on the number of lawn mowers sold over the 36 months provided in Table 1.2, compute the following: 3.1 The three-month moving average forecast (MA-3). The six-month moving average forecast (MA-6). On the same graph, plot the actual sales as well as the MA-3 and MA-6 forecasts. Comment briefly, but meaningfully, on the graph plotted in question 3.3. Determine the linear regression equation that describes the relationship between the month of sales and the units of lawn mowers sold monthly and use it to predict the number of units of lawn mowers to be sold in quarter 1 of the 2019 financial year. 3.2 3.3 3.4 3.5