AutoSave OFF ayvc E ASSIGNMENT A - Saved to my Mac Home Insert Draw Design Layout References Mailings Review View Table Design Layout Tell me Share Comments Calibri (Bo... v 11 fo - AI Aa A V V TO AL I AalbCcDdEe AaBbcDdEe AaBbCcDc Paste Normal B IV ab X X* ALA No Spacing Heading 1 Dictate Sensitivity V V Styles Pane The following data show the sales (in Millions) of seeds in Oman. Using the least square method find the trend values. YEAR 2012 2013 2014 2015 2017 2018 2019 2020 2021 2016 1200 SALES 600 750 900 1050 2160 3000 3840 3600 4200 The following data show the sales of products A, B, C, D and E in Sultanate of Oman. Find the four, five and six years simple moving averages and three years weighted moving average. (WEIGHTS - 2021 - 0.50, 2020 - 0.30, 2019 -0.20). Year Sales - A Sales - B Sales - Sales-D Sales-E (RO in 000) (RO in 000) (RO in 000) (RO in 000) (RO in 000) 2016 10800 16200 21600 27000 13500 2017 19440 29160 38880 48600 24300 2018 27000 40500 54000 67500 33750 34560 51840 69120 86400 43200 2019 2020 32400 48600 81000 40500 64800 75600 2021 37800 56700 94500 47250 The following data is the consumption pattern of certain materials in an organization. Categorize the materials based on ABC. A - 65 %, B-25 and C - 10%. Group No of Items Monthly Consumption Price in RO 1 210 14000 42 140 525 787.5 420 7700 52.5 IV 770 6125 70 V 280 1400 210 VI 1120 10500 17.5 VII 945 8750 21 VIII 175 1050 700 Page 1 of 2 428 words English (United States) O Focus E E 128% AutoSave OFF ayvc E W ASSIGNMENT A - Saved to my Mac Home Insert Draw Design Layout References Mailings Review View Table Design Layout Tell me Share Comments Calibri (Bo... v 11 ' ' fo Aa A V V == = ST AL I AalbCcDdEe AaBbcDdEe AaBbCcDc Paste B I U U ale XL Normal .... No Spacing ALA Dictate Heading 1 x Sensitivity V Styles Pane Construct Mean and Range chart from the following data. Assume constant values A2 = 1.02, D3 = 0, D4 = 2.57 Is the process under control? CHART MUST SUB- SAMPLE 1 SAMPLE 2 SAMPLE 3 SUB- SAMPLE 1 SAMPLE 2 SAMPLE 3 GROUP GROUP 1 16.25 16.25 12.5 14 15 11.25 11.25 2 16.25 15 17.5 15 10 16.25 13.75 3 10 13.75 13.75 16 10 17.5 0 4 10 7.5 8.75 17 12.5 15 10 5 5 0 2.5 18 7.5 15 15 6 15 15 15 19 13.75 12.5 18.75 7 15 10 10 20 17.5 15 12.5 8 15 10 15 21 12.5 12.5 12.5 9 13.75 12.5 11.25 22 12.5 6.25 8.75 10 17.5 15 15 23 10 13.75 12.5 11 10 7.5 8.75 24 10 0 5 12 10 8.75 7.5 25 12.5 7.5 8.75 13 12.5 8.75 12.5 26 6.25 12.5 7.5 For the following data, construct a fraction defective chart. Is the process under control? CHART MUST GROUP SAMPLE SIZE NO. OF DEFECTIVES 1 96 6 2 96 9 3 150 9 4 150 6 5 96 3 6 240 12 7 150 6 8 150 0 9 96 6 10 96 3 Page 2 of 2 428 words English (United States) O Focus E E 119% AutoSave OFF ayvc E ASSIGNMENT A - Saved to my Mac Home Insert Draw Design Layout References Mailings Review View Table Design Layout Tell me Share Comments Calibri (Bo... v 11 fo - AI Aa A V V TO AL I AalbCcDdEe AaBbcDdEe AaBbCcDc Paste Normal B IV ab X X* ALA No Spacing Heading 1 Dictate Sensitivity V V Styles Pane The following data show the sales (in Millions) of seeds in Oman. Using the least square method find the trend values. YEAR 2012 2013 2014 2015 2017 2018 2019 2020 2021 2016 1200 SALES 600 750 900 1050 2160 3000 3840 3600 4200 The following data show the sales of products A, B, C, D and E in Sultanate of Oman. Find the four, five and six years simple moving averages and three years weighted moving average. (WEIGHTS - 2021 - 0.50, 2020 - 0.30, 2019 -0.20). Year Sales - A Sales - B Sales - Sales-D Sales-E (RO in 000) (RO in 000) (RO in 000) (RO in 000) (RO in 000) 2016 10800 16200 21600 27000 13500 2017 19440 29160 38880 48600 24300 2018 27000 40500 54000 67500 33750 34560 51840 69120 86400 43200 2019 2020 32400 48600 81000 40500 64800 75600 2021 37800 56700 94500 47250 The following data is the consumption pattern of certain materials in an organization. Categorize the materials based on ABC. A - 65 %, B-25 and C - 10%. Group No of Items Monthly Consumption Price in RO 1 210 14000 42 140 525 787.5 420 7700 52.5 IV 770 6125 70 V 280 1400 210 VI 1120 10500 17.5 VII 945 8750 21 VIII 175 1050 700 Page 1 of 2 428 words English (United States) O Focus E E 128% AutoSave OFF ayvc E W ASSIGNMENT A - Saved to my Mac Home Insert Draw Design Layout References Mailings Review View Table Design Layout Tell me Share Comments Calibri (Bo... v 11 ' ' fo Aa A V V == = ST AL I AalbCcDdEe AaBbcDdEe AaBbCcDc Paste B I U U ale XL Normal .... No Spacing ALA Dictate Heading 1 x Sensitivity V Styles Pane Construct Mean and Range chart from the following data. Assume constant values A2 = 1.02, D3 = 0, D4 = 2.57 Is the process under control? CHART MUST SUB- SAMPLE 1 SAMPLE 2 SAMPLE 3 SUB- SAMPLE 1 SAMPLE 2 SAMPLE 3 GROUP GROUP 1 16.25 16.25 12.5 14 15 11.25 11.25 2 16.25 15 17.5 15 10 16.25 13.75 3 10 13.75 13.75 16 10 17.5 0 4 10 7.5 8.75 17 12.5 15 10 5 5 0 2.5 18 7.5 15 15 6 15 15 15 19 13.75 12.5 18.75 7 15 10 10 20 17.5 15 12.5 8 15 10 15 21 12.5 12.5 12.5 9 13.75 12.5 11.25 22 12.5 6.25 8.75 10 17.5 15 15 23 10 13.75 12.5 11 10 7.5 8.75 24 10 0 5 12 10 8.75 7.5 25 12.5 7.5 8.75 13 12.5 8.75 12.5 26 6.25 12.5 7.5 For the following data, construct a fraction defective chart. Is the process under control? CHART MUST GROUP SAMPLE SIZE NO. OF DEFECTIVES 1 96 6 2 96 9 3 150 9 4 150 6 5 96 3 6 240 12 7 150 6 8 150 0 9 96 6 10 96 3 Page 2 of 2 428 words English (United States) O Focus E E 119%