CREATE CHARTS 1056 3 shifts EDI USING EXCEL OR BY HAND 872 175 Wkis Producti Below find the 42 week production output of a plant showing: 1. The week of production 2. The number of production parts planned for the week 3. The number of shifts needed to create the actual output that week 4. The average output per shift for the week 5. The total number of parts actually produced that week Total Date & Ave per per Shift Source Plan Nb Shift Shift Week Status Wk01 (3 1264 3 shifts Rework 1.428G Wkoz 640 3 shifts 170 2,117 G Wk03 1156 3 shifts 158 2.206 G Wk04 1120 3 shifts 181 1.984G wkos 185 2009 Wk06 1176 3 shifts 158 1.895G Wk07 1100 3 shifts 174 2,083 G Wkos 876 3 shifts 181 1,879 G Wk09 3 shifts 170 2.041 G Wk 10 1180 2 shifts 171 1.371 G Wk11 760 2 shifts 174 1.415 G A. Plot five run charts: Wk12 1028 2 shifts 183 994 G Wk13 1080 2 shifts 1.053 G 1. Planned production for the week, each week Wk14 (4w 1264 2 shifts Rework 784 2. Number of shifts run each week 1225 7 shifts a week 167 1,148 Y 3. Average production per shift each week 1225 7 shifts a week 167 1.148 Y 4. Actual production each week Wk16 1225 7 shifts a week 1901.345G Wk17 1400 8 shifts a week 192 1.538G 5. Difference between the planned and actual production each week. Wk18 (1 b 1050 6 shifts a week 165 1,040 Y B. On each chart show the Mean, upper and lower control limits Wk19 (2b 1050 6 shifts a week 173 1.038 (show your calculations under each chart). Wk20 1575 9 shifts a week. 175 1.575 G Wk21 1225 7 shifts a week 171 1.133 Wk22 1575 9 shifts a week 169 1.521 Wk23 1750 10 shifts a week 174 1,740 Y Wk24 Producti 10506 shifts a week 177 1,064G Wk25 on 175010 shifts a week 1751,752 G Wk26 Planning 1400 8 shifts a week 178 1,550 G Wk27 1225 7 shifts a week 178 Wk28 1575 9 shifts a week 1.679G Wk29 1575 9 shifts a week 178 1.600 Wk30 1575 9 shifts a week 164 1,432 Wk31 1400 8 shifts a week 159 1,210 Y Wk32 1575 9 shifts a week 172 1,544 Y Wk33 1575 9 shifts a week 1513 Wk34 1575 9 shifts a week 190 1.726 G Wk35 1400 shifts a week 174 1.394. Y Wk36 2100 12 shifts a week 174 1,500 R Wk37 2625 15 shifts a week 1752,620G Wk38 2450 14 shifts a week 173 2.425 G Wk39 1925 11 shifts a week 173 1.825G Wk40 2275 13 shifts a week 173 2.297 G Wk41 1925 11 shifts a week 137 1,506 Y Wk42 1925 11 shifts a week 162 1,951 G wk15 178 181