This is only one question please answer OPERATION MANAGEMENT subject

Based on Table 1, answer all the given questions. Value for A and B will be determined by your unique number as indicated in Table 1. You may use an appropriate software such as word, excel or PowerPoint to solve the calculation. i. Identified the equation of the trend. [2 marks] ii. What is the correlation of the given data? Displayed the graph in your answer's script. [10 marks] iii. Develop your conclusion on that graph. [5 marks] iv. Identified an appropriate action that need to be taken based on the graph that you have obtained. [5 marks] V. List up AND explained FOUR (4) requirements that need to be fulfil in order to create a properly prepared forecast. [8 marks] Page 2 of 5 Test 1 MGTM623, Semester 1, 2021/2022 Table 1 Sales and Demand past 5 years of marketing Year 2015 2016 2017 2018 2019 2020 Sales (units) 918 878 850 700 1070 B B Demand (units) 700 650 500 A 600 400 Student Unique number's range A B Pentagon, Hexagon 800 900 Nonagon 1000 1500 Octagon 1100 1300 Based on Table 1, answer all the given questions. Value for A and B will be determined by your unique number as indicated in Table 1. You may use an appropriate software such as word, excel or PowerPoint to solve the calculation. i. Identified the equation of the trend. [2 marks] ii. What is the correlation of the given data? Displayed the graph in your answer's script. [10 marks] iii. Develop your conclusion on that graph. [5 marks] iv. Identified an appropriate action that need to be taken based on the graph that you have obtained. [5 marks] V. List up AND explained FOUR (4) requirements that need to be fulfil in order to create a properly prepared forecast. [8 marks] Page 2 of 5 Test 1 MGTM623, Semester 1, 2021/2022 Table 1 Sales and Demand past 5 years of marketing Year 2015 2016 2017 2018 2019 2020 Sales (units) 918 878 850 700 1070 B B Demand (units) 700 650 500 A 600 400 Student Unique number's range A B Pentagon, Hexagon 800 900 Nonagon 1000 1500 Octagon 1100 1300