Datasetformodule4exercise.xls
Problem 1
| SKU | FillRate3 | FillRate4 | FillRate5 | FillRate6 | FillRate7 | FillRate8 | Zone | DC |
| 1 | 93 | 83 | 87 | 97 | 74 | 87 | 1 | 2 |
| 2 | 50 | 68 | 71 | 53 | 59 | 60 | 3 | 2 |
| 3 | 78 | 68 | 71 | 82 | 57 | 72 | 3 | 2 |
| 4 | 50 | 78 | 82 | 53 | 62 | 66 | 3 | 1 |
| 5 | 97 | 74 | 78 | 88 | 62 | 81 | 2 | 2 |
| 6 | 41 | 71 | 75 | 43 | 61 | 57 | 3 | 2 |
| 7 | 80 | 72 | 76 | 82 | 63 | 53 | 3 | 1 |
| 8 | 81 | 83 | 87 | 83 | 72 | 61 | 2 | 1 |
| 9 | 71 | 63 | 66 | 75 | 56 | 66 | 2 | 2 |
| 10 | 85 | 89 | 93 | 89 | 75 | 87 | 1 | 2 |
| 11 | 86 | 93 | 98 | 90 | 74 | 89 | 2 | 2 |
| 12 | 67 | 64 | 67 | 70 | 57 | 64 | 2 | 2 |
| 13 | 52 | 76 | 60 | 55 | 61 | 61 | 2 | 1 |
| 14 | 88 | 83 | 87 | 92 | 66 | 84 | 1 | 2 |
| 15 | 75 | 73 | 74 | 76 | 69 | 73 | 1 | 1 |
| 16 | 92 | 97 | 97 | 88 | 78 | 92 | 1 | 2 |
| 17 | 64 | 71 | 75 | 65 | 57 | 47 | 3 | 2 |
| 18 | 60 | 75 | 79 | 63 | 61 | 67 | 3 | 2 |
| 19 | 93 | 84 | 88 | 98 | 67 | 86 | 1 | 2 |
| 20 | 94 | 93 | 98 | 99 | 83 | 92 | 1 | 1 |
| 21 | 90 | 89 | 93 | 95 | 77 | 89 | 1 | 1 |
| 22 | 78 | 80 | 84 | 82 | 66 | 78 | 2 | 1 |
| 23 | 50 | 84 | 88 | 53 | 71 | 69 | 3 | 2 |
| 24 | 74 | 50 | 53 | 78 | 45 | 60 | 2 | 2 |
| 25 | 62 | 93 | 98 | 65 | 75 | 79 | 2 | 1 |
| 26 | 80 | 81 | 85 | 84 | 69 | 79 | 2 | 2 |
| 27 | 87 | 97 | 74 | 91 | 81 | 86 | 1 | 1 |
| 28 | 75 | 61 | 64 | 26 | 52 | 46 | 3 | 2 |
| 29 | 50 | 82 | 86 | 53 | 71 | 68 | 2 | 1 |
| 30 | 99 | 93 | 98 | 93 | 84 | 93 | 2 | 2 |
| 31 | 50 | 64 | 67 | 53 | 52 | 58 | 3 | 2 |
| 32 | 91 | 77 | 83 | 96 | 66 | 83 | 1 | 2 |
| 33 | 66 | 62 | 65 | 69 | 56 | 64 | 3 | 2 |
| 34 | 50 | 98 | 86 | 53 | 80 | 73 | 3 | 2 |
| 35 | 86 | 94 | 99 | 94 | 82 | 91 | 1 | 2 |
| 36 | 76 | 53 | 56 | 77 | 46 | 42 | 4 | 2 |
| 37 | 41 | 72 | 76 | 43 | 63 | 58 | 4 | 2 |