Question: Table 2.1: Actual sales data for the reading glasses during 2021 Month & Actual Sales (Pairs of reading glasses) January 2021 : 2 800 February

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 June 2021 : 8 000 July 2021 : 8 000 August 2021 : 7 900 September 2021 : 6 000 October 2021 : 4 050 November 2021 : 4 900 December 2021 :5 550

4.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)

4.2 Determine the Mean Absolute Deviation (MAD) of the three-month-weighted-moving-average 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)

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!

In the case of personal communication as an assessment method, we rely almost completely on oral language to collect evidence of achievement. That means teacher and student must share a common...

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...

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 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...

Answer needed urgently 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...

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...

Please provide answers for question 4.1 and 4.2 a and 4.2b Table 2.1: Actual sales data for the reading glasses during 2021 QUESTION 4 Using the sales data of the reading glasses in Table 2.1...

A baseball player is offered a 5-year contract that pays him the following amounts: Year 1: $1.01 million Year 2: $1.89 million Year 3: $2.29 million Year 4: $2.62 million Year 5: $3.14 million Under...

Consider your previous thoughts on the study of history and reflect on how your thinking on history has evolved. Finally, respond to the following question: Writing in his 1532 work The Prince,...

1 . Explain the significance of empathy in the financial planning process. Provide an example to support your answer.

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...