Answered step by step
Verified Expert Solution
Question
1 Approved Answer
(19) QUESTION 3 Table 1.2 shows the number of lawn mowers sold by Mangi Enterprises over a period of three years. Table 1.2: Sales Data
(19) QUESTION 3 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) Jan Feb Mar Apr May Jun Jul Aug 2016 238 220 195 245 345 380 270 220 2017 135 145 185 219 240420520410 2018 205 230 340 370 395 505 540 500 Sep Oct 280 120 380 320 402360 Nov 110 290 310 Dec 85 240 280 REQUIRED: Based on the number of lawn mowers sold over the 36 months provided in Table 1.2, compute the following: (4) 3.1 3.2 3.3 3.4 3.5 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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started