CASE ANALYSIS (2,000 words maximum (not including tables, graphs)

Kylin
STAT201AT12018CaseAnalysisAssessmentWorkbook.xlsx
Home>Business & Finance homework help>Management homework help>CASE ANALYSIS (2,000 words maximum (not including tables, graphs)

DATASET 1

2017 Orders in Kgs
External Customers Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
1 33 34 36 37 40 40 39 39 40 41 45 48
2 34 36 38 40 42 43 42 41 42 44 48 50
3 37 38 41 43 46 46 46 45 46 48 52 56
4 56 59 63 67 70 71 70 69 70 55 51 55
5 32 33 32 35 36 37 35 35 36 37 40 43
6 35 37 40 42 45 45 44 44 45 47 51 54
7 69 73 71 75 79 80 78 77 79 82 89 96
8 31 32 35 36 38 39 38 38 38 40 43 46
9 38 40 43 45 47 48 47 46 47 49 54 57
10 38 41 44 46 49 48 48 48 49 51 55 59
11 34 35 33 35 37 37 36 36 37 36 39 42
12 36 37 40 42 45 45 44 44 45 47 51 54
13 38 40 43 45 50 50 50 49 50 51 57 60
14 48 51 55 58 61 61 61 60 61 64 70 75
15 31 32 35 36 38 39 38 38 38 35 37 39
16 27 28 34 36 38 37 38 37 38 39 44 46
17 26 28 30 31 33 33 33 32 33 35 38 39
Total 643 673 712 748 794 799 789 778 793 802 863 919
Internal Carts Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
1 102 103 105 105 107 110 112 115 118 120 123 127
2 105 106 109 111 114 116 119 118 121 123 126 130
3 87 89 90 92 94 96 98 101 103 105 108 109
4 99 100 103 105 107 110 112 113 117 118 121 125
5 78 82 83 85 86 88 88 88 90 92 94 97
6 111 113 115 118 122 111 114 135 136 141 144 149
7 88 89 92 93 95 93 94 95 97 100 102 105
Total 670 682 696 708 726 725 738 765 782 800 818 842
Mobiles Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
1 63 65 64 72 71 66 66 71 78 74 76 79
2 73 76 78 82 83 82 83 85 87 89 91 94
3 56 57 57 59 60 57 59 61 67 63 66 69
Total 192 198 199 213 214 205 209 216 232 226 233 242

DATASET 2

Outlet Service Coffee Frequency
1 3 4 c
1 4 4 c
2 5 4 d
1 4 5 d
1 5 4 d
1 4 5 d
2 5 5 c
1 4 5 c
2 5 5 c
2 1 2 a
1 4 5 d
2 3 3 b
1 4 5 d
1 4 5 d
2 5 5 d
1 4 5 c
2 5 3 A
1 4 3 A
2 3 3 b
2 5 4 a
1 5 4 d
2 5 4 b
1 3 4 b
2 3 3 B
1 4 3 B
2 4 4 A
1 5 3 B
2 5 5 c
1 4 5 d
1 4 5 d
2 4 5 d
2 3 5 c
2 5 5 c
1 5 5 c
2 2 5 c
1 4 5 c
2 5 5 c
1 5 5 d
1 5 4 c
2 4 4 c
1 4 4 c
2 4 4 c
1 3 4 b
1 5 4 b
1 5 4 b
2 4 4 b
2 4 4 b
1 5 4 b
1 5 3 A
2 3 4 b
2 2 5 b
1 4 5 d
1 4 5 c
1 1 3 a
1 2 3 a
1 4 5 d
1 5 3 b
1 3 4 d
1 5 4 d
1 5 5 d
1 4 3 c
1 4 5 d
1 5 3 c
1 5 3 c
2 1 1 b
2 3 3 c
2 5 4 d
2 4 5 d
2 3 3 c
2 5 5 d
2 2 2 c
2 3 3 b
2 5 4 c
2 4 4 c
2 5 3 d
2 4 4 d
2 5 3 d
2 2 4 d
2 2 4 b
2 3 3 a
2 3 4 a

DATASET 3

Orders 2017 Jan Espresso Mocha Sublime Total Dec Espresso Mocha Sublime Total
External Customer
1 33 9 6 18 33 48 22 13 13 48
2 34 11 4 19 34 50 14 13 23 50
3 37 11 9 17 37 56 15 15 26 56
4 56 16 7 33 56 55 33 16 6 55
5 32 9 7 16 32 43 12 24 7 43
6 35 20 7 8 35 54 5 5 44 54
7 69 20 9 40 69 96 35 18 43 96
8 31 5 9 17 31 46 35 2 9 46
9 38 3 12 23 38 57 15 13 29 57
10 38 11 5 22 38 59 15 16 28 59
11 34 5 11 18 34 42 15 17 10 42
12 36 4 4 28 36 54 23 24 7 54
13 38 11 6 21 38 60 12 14 34 60
14 48 14 6 28 48 75 34 16 25 75
15 31 9 5 17 31 39 23 15 1 39
16 27 2 9 16 27 46 12 24 10 46
17 26 8 4 14 26 39 13 9 17 39
Total 643 919