Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

(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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Case Studies In Forensic Accounting And Fraud Auditing

Authors: Professor D. Larry Crumbley, Wilson LaGraize, Christopher E. Peters

2nd Edition

0808041932, 978-0808041931

More Books

Students also viewed these Accounting questions