Question: Actual sales data for the reading glasses during 2021 Using the sales data of the reading glasses in Table 1 Calculate the three-month-weighted-moving-average monthly forecasts

Actual sales data for the reading glasses during

Actual sales data for the reading glasses during 2021 Using the sales data of the reading glasses in Table 1 Calculate the three-month-weighted-moving-average monthly forecasts for the period April 2021 - December 2021. Use weights of 0.5, and 0.2 for the most recent and oldest monthly data respectively and 0.3 for the middle month (show all workings). (9 marks) 2 Determine the Mean Absolute Deviation (MAD) of the three-month-weighted-movingaverage monthly forecasts for the April - December 2021 period. (4 marks) a. The linear regression equation of the sales of reading glasses for the 2021 financial year is given by the expression: y=201.4x+4091 (where ' y ' denotes monthly sales, and 'x', the number representing the month. For example, x=1,2,3, etc., if the month is January, February, March, etc.). Use the regression equation to determine the Mean Absolute Deviation (MAD) of the regression forecasts for the April - December 2021 period. (5 marks) b. Which of the two methods is better at forecasting the sales of the reading classes? Explain. (2 marks)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

Table 2.1: Actual sales data for the reading glasses during 2021 3.1 Using the actual sales data provided above, detemine the economic order quantity (EOQ) of reading glasses for 2021 financial year....

Table 21: Actual sales data for the reading glasses during 2021 QUESTION 4 (20 marks) Using the sales data of the reading glasses in Table 21 (question 3), answer the following quostions: 4.1...

Table 2.1: Actual sales data for the reading glasses during 2021 3.1 Using the actual sales data provided above, determine the economic order quantity (EOQ) of reading glasses for 2021 financial...

QUESTION 4 (20 marks) Table 2.1: Actual sales data for the reading glasses during 2021 Month Actual Sales (Pairs of reading glasses) January 2021 2 800 February 2021 3 000 March 2021 5 000 April 2021...

Table 2.1: Actual sales data for the reading glasses during 2021 QUESTION 4 (20 marks) Using the sales data of the reading glasses in Table 2.1 (question 3), answer the following questions: 4.1...

Table 2.1: Actual sales data for the reading glasses during 2021 Jsing the sales data of the reading glasses in Table 2.1 (question 3), answer the following questions: 1 Calculate the...

Table 2.1: Actual sales data for the reading glasses during 2021 Month & Actual Sales (Pairs of reading glasses) January 2021 : 2 800 February 2021 : 3 000 March 2021 : 5 000 April 2021 : 4 000 May...

Table 2.1: Actual sales data for the reading glasses during 2021 Month Actual Sales (Pairs of reading glasses) January 2021 2 800 February 2021 3 000 March 2021 5 000 April 2021 4 000 May 2021 5 600...

Oasis B is 25 km due east of oasis A. Starting from oasis A, a camel walks 24km in a direction 15o south of east and then walks 8.0 km due north. How far from oasis B?

Calculating Costs of Issuing Stock Your company needs to raise $50 million to finance plant expansion. In discussions with its investment bank, you learn that the bankers recommend a gross price of...

( a ) Bond investors will require a higher return for a bond rated AAA than a bond rated BBB ( b ) Bond investors will require a higher return for a bond rated B than A ( c ) Bond prices will go up...

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...