Need help with this and show work please

MGMT 4630 SPC Assignment 41 Read the scenario below. Then construct and interpret the appropriate control charts. Exercise Objective: Construct and interpret statistical process control charts. Course Lenming Objective: Use a variety of curent industry quality tools for measuring and monitoring quality UNCIBrew Corporation produces instant coffee. They market their instant collee in preprackaged coffee bays Por custiiner cnvenience. Each bag contains enough coffee to breweght (8) cups of coffee, the typical size coffee maker found in most retail stores. Production standards call fou each bag to contain 100.0 +/- 2.0 grams of coffee. To be "safe," the weight listed on the package is 9 yrains (the lower specification limit). Chovernment regulations state that the packages rest meet the amount printed on the package. UNGBrew has requested that you, one of their process analysts, evaluate the capability of this process. In order to conduct your analysis you have had the Packaging Department select four (4) inags from the packaging line each hour fura 24 hour pericid. There were 25 sels of observations 1) Develop the appropriate control chart(s) and examine the hug filling process 2) Dues the bag filling process appear to be stable during the period of time where the observations were monde? Instructions When evaluating the control, include a table that shows the longest runs observed for all six of the run tests (the same way shown in the lecture video). In the end, you must stale your conclusion about the price von Submit your calculations (acal and organized) You may NOT usc Excel to do the calculations (80 that you lcarn the process and are prepnre for the test). Submit a very beatly prepared pnge of boodwritten calculations Round all calculations to two (2) decimal places. * *li the tim charls using pencil and men and a straight edge. Make it to scale and real. The charts must clearly show and label the control limits, the ABC zones and the centerline. The y-axis must be clearly labeled with these components, ie show the numeric values. The charts presented in the lecture video represent properly formale! charts. Neatness cont Data Day 2 Bag 3 X-ber R R Subgroup Bag 1 99.6 Bag 4 100.5 98.4 100.0 100.4 99.2 2 99.1 99,2 3 E 993 98.5 98.9 99.1 044 98.4 4 S 97.6 99.7 99.4 99.5 98.6 9 98.8 98.2 98.4 98.50 0.60 7 99.8 99.58 1.40 99.0 2. 98.7 100.4 www. 98.8 8 99.1 98.5 98.78 98.90 9 995 S 99.1 99.8 982 1.4 10 99.5 99.1 99.4 1.90 11 99,2 101.0 100.1 99.2 1002 99.75 99.85 99.15 0. 12 98.8 99.4 0.60 13 99.6 99.9 98.2 1003 99.50 2.10 14 99.5 100.1 99.9 98.7 99.55 1.40 15 98.1 99.4 99.3 99.6 99.10 1.50 16 188 10X1.1 100.0 107 1.30 17 993 99.1 98.2 98.7 98.83 1.10 18 99.5 98.2 99.6 97.4 98.6 2.20 19 99.4 99.0 99.2 98.7 99.08 0.70 20 100.0 99.2 98.7 1000 99.18 1.9 21 10X1.4 99,0 166 1.40 992 985 22 999 186 905 99 SKN ! 1 400 . 1.10 99.1 100.0 98.9 99.33 23 24 99.9 100.0 98.9 90.9 99.5 99.13 25 98.2 99.2 99.9 99.6 99.23 1.70 (Bag weights are reported in grams)