Excel Lab Part 2

By /

Description

In addition to the lab you just did, there’s a small part 2 section to it. you just need to answer the questions and do whatever’s necessary in correlation to the first part of the lab

Don't use plagiarized sources. Get Your Custom Assignment on
Excel Lab Part 2
From as Little as $13/Page

Unformatted Attachment Preview

Part (1)
Simple
Comparable Influential
What may go wrong if we use these KPIs?
KPI
Weekly telephone cost in a company
(The company is trying to raise profit by cutting cost.)
Weekly lost sales due to shortage at a grocery store
Weekly # of signup of the 30-day free trial program
Weekly dollar amount of return at a department store
For Uber, percentage of customers who cancelled their rides
and switched to Lyft because of long wait time.
Part (2)
Answer the following questions using case#2 data.
Any issues with this KPI?
1. For plant Gary, which month has the highest daily average raw material cost? How much is it?
2. For plant Frankfurt, which month has the highest daily average operating cost? How much is it?
3. In March, which plant has the highest daily average total cost per 100 pounds of output? How much is it? What
4. Calculate the ratio of operating cost over total cost for each production output data point (each row). Which pla
of this ratio in January? What about the rest of the year?
ny issues with this KPI?
Any suggestion for a better one?
uch is it?
much is it?
ut? How much is it? What about other months in the year?
oint (each row). Which plant has the highest daily average
Average of KPI1 _ Output
Output over Month
120000
100000
80000
Plant
Frankfurt
60000
Gary
Mexico
Sunchem
40000
20000
0
1
Month
2
3
4
5
6
7
8
9
10
11
12
Average of KPI1 _ Output Column Labels
Row Labels
Frankfurt
Gary
Mexico
Sunchem
1
104176.7908 38516.63184
47224.978 11026.69458
2
104798.4939 38176.85161
47535.256 10745.40139
3
103914.9992 38320.21606 47342.37629 11064.38477
4
104316.9056 38247.2008 47189.62917 11055.9364
5
103968.8403 38678.93458 47645.59345 11000.50877
6
104278.6916 38439.61323 47190.66397 10922.83817
7
103607.3972 38129.79329 46989.54416 10880.77597
8
104102.259 38211.71271 46952.89045 10956.01458
9
104340.4485 38441.14457 47013.6208 10788.44617
10
103378.268 38267.83332 47697.93039 10905.67994
11
104695.0552 38891.2721 47083.26147 11119.33967
12
104244.2154 38321.3459 46930.36535 10926.66281
Grand Total
104143.7444 38387.31305 47231.7711 10950.82305
Grand Total
50236.27381
50314.00072
50160.49408
50202.41798
50323.46927
50207.95175
49901.87765
50055.71918
50145.91501
50062.42792
50447.23211
50105.64735
50178.41291
Average of KPI2 _ Raw Material Cost
70000
60000
50000
40000
Plant
Frankfurt
Gary
Mexico
30000
Sunchem
20000
10000
0
1
Month
2
3
4
5
6
7
8
9
10
11
12
Average of KPI2 _ Raw Material Cost
Row Labels
1
2
3
4
5
6
7
8
9
10
11
12
Grand Total
Column Labels
Frankfurt
Gary
Mexico
55442.47916 26706.88661 34478.00292
56317.18572 26493.11875 37434.3038
57553.20946 26608.86968 40400.1216
56643.33075 26593.88083 35720.39271
54903.45369 26893.01774 36551.46243
57968.51194 26771.18033 36787.27853
55913.84857 26571.27968 40487.00174
55496.7334 26655.75613 38249.96202
54648.27153 26825.89467 36775.54517
57650.72212 26735.98855 34589.8627
58479.79727 27185.29683 36835.23932
53592.13255 26798.03226 39029.77942
56208.79039 26737.42371 37285.16755
Sunchem
Grand Total
10331.96322 31739.83298
10184.54791 32607.28904
10242.57751 33701.19456
10483.38814 32360.24811
10305.2046 32163.28461
10362.75752 32972.43208
10192.65015 33291.19503
10139.92895 32635.59513
10106.34414 32089.01388
10088.84206 32266.35386
10543.57676 33260.97755
10236.26157 32414.05145
10267.69756 32624.7698
Average of KPI3 _ Output per Worker
1400
1200
1000
800
Plant
Frankfurt
Gary
Mexico
600
Sunchem
400
200
0
1
Month
2
3
4
5
6
7
8
9
10
11
12
Average of KPI3 _ Output per Worker
Row Labels
1
2
3
4
5
6
7
8
9
10
11
12
Grand Total
Column Labels
Frankfurt
Gary
Mexico
1255.142058 664.0798593 1049.443956
1218.587138 669.7693264 1056.339022
1194.425278 660.6933804 1052.052806
1185.419381 648.2576407 1048.658426
1155.209336 678.5777997 1058.790966
1158.652129 662.7519523 1048.681421
1164.128058 680.8891659 1044.212092
1196.577689 658.8226329 1043.397566
1227.534688 662.7783546 1044.747129
1216.214918 637.797222 1059.954009
1261.386207 670.5391741 1046.294699
1241.002564 649.5143373 1042.897008
1206.065504 661.9861948 1049.594913
Sunchem
Grand Total
355.6998252 831.0914246
346.6258514 822.8303346
356.9156379 816.0217757
356.6431097 809.7446394
354.8551217 811.8583058
352.3496183 805.6087803
350.9927732 810.0555225
353.4198252 813.0544282
348.0143925 820.768641
351.796127 816.4405689
358.6883763 834.2271142
352.4729938 821.4717257
353.2523566 817.7247422
Average of KPI4 _ Total Cost per 00 pounds of output
180
160
140
120
Plant
100
Frankfurt
Gary
Mexico
80
Sunchem
60
40
20
0
1
Month
2
3
4
5
6
7
8
9
10
11
12
Average of KPI4 _ Total Cost per 00 pounds of output
Row Labels
1
2
3
4
5
6
7
8
9
10
11
12
Grand Total
Column Labels
Frankfurt
Gary
74.33175581 99.92412113
75.42107997 99.83540252
78.01013772 100.1105056
76.53150916 100.5256266
74.73927598 99.75079797
78.68312132 100.2573149
76.27959728 99.85586256
75.02950063 100.4730587
73.41815964 100.3920214
78.31269183 101.1409183
77.97329934 100.3216668
71.9462113 100.8841584
75.88519784 100.2920884
Mexico
Sunchem
Grand Total
87.81604304 156.9685269 104.7601117
94.64958738 159.4969473 107.3507543
102.602353 154.9826424 108.9264097
91.03517796 158.7865235 106.7197093
92.21706764 157.0047904 105.927983
93.78514905 159.160324 107.9714773
103.6926456
157.29489 109.2807489
98.018312 155.2226482 107.1858799
94.09506331 157.5162517 106.355374
87.20016926 155.2850366 105.484704
94.09431752 158.6448922 107.758544
100.0895706 157.1928027 107.5281857
94.96219364 157.2647828 107.1010657
Average of KPI5 _ Yield
1
0.98
0.96
0.94
Plant
Frankfurt
0.92
Gary
Mexico
Sunchem
0.9
0.88
0.86
0.84
1
Month
2
3
4
5
6
7
8
9
10
11
12
Average of KPI5 _ Yield Column Labels
Row Labels
Frankfurt
Gary
Mexico
Sunchem
1
0.987636017 0.903531885 0.947016192 0.980384735
2
0.989136867 0.902779096 0.944581629 0.981009828
3
0.990810913 0.902245983 0.945419916 0.980217209
4
0.98888854 0.901028276 0.946171597 0.98059326
5
0.989148527 0.901062449 0.946002671 0.980596522
6
0.990984039 0.89956427 0.948107428 0.980051168
7
0.988797184 0.899029776 0.948522204 0.980600798
8
0.988949164 0.898102371 0.947006968 0.980415349
9
0.988910842 0.897752761 0.946046307 0.980613569
10
0.989846057 0.896724331 0.94815903 0.980865275
11
0.988427816 0.89627264 0.945947757 0.980587569
12
0.988625861 0.895908629 0.948285997 0.980572423
Grand Total
0.989179164 0.899482524 0.94679255 0.980539353
Grand Total
0.954642207
0.954376855
0.954673505
0.954170418
0.954202542
0.954676726
0.954237491
0.953618463
0.95333087
0.953898673
0.952808945
0.953348227
0.953998398
Row Labels
Frankfurt
Gary
Mexico
Sunchem
Grand Total
Sum of Sales
20.01804659
30.72316387
13.93
9.111255628
73.78246609
Sum of Sales
12%
19%
TOTAL
12%
27%
Plant
Frankfurt
Gary
Mexico
Sunchem
42%
Values
Average of KPI1 _ Output
Average of KPI2 _ Raw Material Cost
Average of KPI3 _ Output per Worker
Average of KPI4 _ Total Cost per 00 pounds of output
Average of KPI5 _ Yield
Column Labels
Frankfurt
Gary
104143.7444 38387.31305
56208.79039 26737.42371
1206.065504 661.9861948
75.88519784 100.2920884
0.989179164 0.899482524
Values
Average of KPI1 _ Output
Average of KPI2 _ Raw Material Cost
Average of KPI3 _ Output per Worker
Average of KPI4 _ Total Cost per 00 pounds of output
Average of KPI5 _ Yield
Frankfurt
Gary
1.591562995 -0.34774693
1.414205424 -0.35303212
1.164869008 -0.46715417
-1.028521978 -0.22434689
0.998461559 -1.54720917
Mexico
Sunchem
Grand Total Mean
Std
47231.7711 10950.82305 50178.41291
50178.41291 33907.1288
37285.16755 10267.69756 32624.7698
32624.7698 16676.5169
1049.594913 353.2523566 817.7247422
817.7247422 333.377195
94.96219364 157.2647828 107.1010657
107.1010657 30.3502196
0.94679255 0.980539353 0.953998398
0.953998398 0.03523497
Mexico
Sunchem
-0.08690331 -1.15691276
0.279458702 -1.34063201
0.695518994 -1.39323383
-0.39995994 1.652828806
-0.2045084 0.753256009
Average of KPI5 _ Yield
Average of KPI4 _ Total Cost per 00
pounds of output
Average of KPI1 _ Output
Average of KPI2 _ Raw Material Cost Average of KPI3 _ Output per Worker
Average of KPI1 _
Output
120000
100000
80000
Average of KPI5 _ 60000
40000
Yield
20000
0
Average of KPI4 _
Total Cost per 00
pounds of output
Average of KPI2 _
Raw Material
Average of KPI3 _
Output per
Worker
Values
Chart Title
Frankfurt
PI4 _ Total Cost per 00
unds of output
Gary
Mexico
Sunchem
Average of KPI1 _ Output
2
1.5
1
0.5
0
-0.5
Average of KPI2 _ Raw Material Cost
-1
-1.5
-2
Average of KPI3 _ Output per Worker
e of KPI3 _ Output per WorkerAverage of KPI4 _ Total Cost per 00 pounds of output
Average of KPI2 _
Raw Material
Cost
Average of KPI5 _ Yield
Plant
Frankfurt
Gary
Mexico
Average of KPI3 _
Output per
Worker
Average of KPI2 _ Raw Material Cost
e of KPI3 _ Output per Worker
Sunchem
Sum of Sales
TOTAL
12%
27%
Plant
Frankfurt
19%
Gary
Mexico
Sunchem
42%
Average of KPI4 _ Total Cost per 00 poundsColumn
of output
Labels
Row Labels Trendline
1
Frankfurt
74.3
Gary
99.9
Mexico
87.8
Sunchem
157.0
2
75.4
99.8
94.6
159.5
3
78.0
100.1
102.6
155.0
4
76.5
100.5
91.0
158.8
Chart Title
Frankfurt
Gary
Average of KPI1 _ Output
2
1.5
1
0.5
0
-0.5
-1
-1.5
-2
Average of KPI5 _ Yield
Average of KPI4 _ Total Cost per
00 pounds of output
5
74.7
99.8
92.2
157.0
6
78.7
100.3
93.8
159.2
7
76.3
99.9
103.7
157.3
Mexico
8
75.0
100.5
98.0
155.2
Sunchem
Average of KPI2 _ Raw Material
Cost
Average of KPI3 _ Output per
Worker
9
73.4
100.4
94.1
157.5
10
78.3
101.1
87.2
155.3
11
78.0
100.3
94.1
158.6
ge of KPI2 _ Raw Material
3 _ Output per
12 Limit
71.9
78.0
100.9
100.7
100.1
100.2
157.2
158.8
Average of KPI4 _ Total Cost per 00 pounds of output
Row Labels
Frankfurt
Gary
Mexico
Sunchem
Grand Total
Column Labels
1
74.33175581
99.92412113
87.81604304
156.9685269
104.7601117
2
75.42107997
99.83540252
94.64958738
159.4969473
107.3507543
3
78.01013772
100.1105056
102.602353
154.9826424
108.9264097
4
76.53150916
100.5256266
91.03517796
158.7865235
106.7197093
5
74.73927598
99.75079797
92.21706764
157.0047904
105.927983
6
78.68312132
100.2573149
93.78514905
159.160324
107.9714773
7
76.27959728
99.85586256
103.6926456
157.29489
109.2807489
8
75.02950063
100.4730587
98.018312
155.2226482
107.1858799
9
73.41815964
100.3920214
94.09506331
157.5162517
106.355374
10
78.31269183
101.1409183
87.20016926
155.2850366
105.484704
11
77.97329934
100.3216668
94.09431752
158.6448922
107.758544
12 Grand Total
71.9462113 75.88519784
100.8841584 100.2920884
100.0895706 94.96219364
157.1928027 157.2647828
107.5281857 107.1010657
Date
Plant
1/1/2013 Mexico
1/2/2013 Mexico
1/3/2013 Mexico
1/4/2013 Mexico
1/5/2013 Mexico
1/6/2013 Mexico
1/7/2013 Mexico
1/8/2013 Mexico
1/9/2013 Mexico
1/10/2013 Mexico
1/11/2013 Mexico
1/12/2013 Mexico
1/13/2013 Mexico
1/14/2013 Mexico
1/15/2013 Mexico
1/16/2013 Mexico
1/17/2013 Mexico
1/18/2013 Mexico
1/19/2013 Mexico
1/20/2013 Mexico
1/21/2013 Mexico
1/22/2013 Mexico
1/23/2013 Mexico
1/24/2013 Mexico
1/25/2013 Mexico
1/26/2013 Mexico
1/27/2013 Mexico
1/28/2013 Mexico
1/29/2013 Mexico
1/30/2013 Mexico
1/31/2013 Mexico
2/1/2013 Mexico
2/2/2013 Mexico
2/3/2013 Mexico
2/4/2013 Mexico
2/5/2013 Mexico
2/6/2013 Mexico
2/7/2013 Mexico
Raw
Production Material
Sales
45508.469
48250
48526.165
51460
47136.297
49760
48495.783
51310
45360.287
47580
49444.524
51880
49288.925
52260
48871.258
51180
47516.039
49970
44904.153
47680
48319.599
50920
49000.604
52170
45551.711
48070
46494.111
49450
45695.338
47850
49079.783
51470
49068.875
51460
45111.623
47480
44981.754
47400
45699.333
48180
46823.696
49760
47970.061
50360
48731.178
51710
45931.217
48750
47473.439
49990
47964.173
51040
49149.858
52340
46472.958
49080
47668.653
50050
46506.082
49450
45228.372
47620
46937.652
49110
47421.094
50560
48367.293
50700
47632.04
50240
45750.443
48050
48972.435
52080
45074.495
47600
Raw
Material
Operating
Cost per
Cost per
pound
pound
0 9.53621347 1.43837357
0.07 9.53621347 1.43837357
0.07 9.53621347 1.43837357
0 9.53621347 1.43837357
0.07 9.53621347 1.43837357
0 9.53621347 1.43837357
0.07 9.53621347 1.43837357
0.07 9.53621347 1.43837357
0 9.53621347 1.43837357
0 9.53621347 1.43837357
0.07 9.53621347 1.43837357
0.07 9.53621347 1.43837357
0 9.53621347 1.43837357
0 9.53621347 1.43837357
0 9.53621347 1.43837357
0 9.53621347 1.43837357
0 9.53621347 1.43837357
0.07 9.53621347 1.43837357
0 9.53621347 1.43837357
0.07 9.53621347 1.43837357
0.07 9.53621347 1.43837357
0 9.53621347 1.43837357
0.07 9.53621347 1.43837357
0 9.53621347 1.43837357
0 9.53621347 1.43837357
0 9.53621347 1.43837357
0.07 9.53621347 1.43837357
0.07 9.53621347 1.43837357
0 9.53621347 1.43837357
0 9.53621347 1.43837357
0 9.53621347 1.43837357
0.07 9.53621347 1.43837357
0.07 9.53621347 1.43837357
0 9.53621347 1.43837357
0 9.53621347 1.43837357
0.07 9.53621347 1.43837357
0 9.53621347 1.43837357
0.07 9.53621347 1.43837357
2/8/2013 Mexico
2/9/2013 Mexico
2/10/2013 Mexico
2/11/2013 Mexico
2/12/2013 Mexico
2/13/2013 Mexico
2/14/2013 Mexico
2/15/2013 Mexico
2/16/2013 Mexico
2/17/2013 Mexico
2/18/2013 Mexico
2/19/2013 Mexico
2/20/2013 Mexico
2/21/2013 Mexico
2/22/2013 Mexico
2/23/2013 Mexico
2/24/2013 Mexico
2/25/2013 Mexico
2/26/2013 Mexico
2/27/2013 Mexico
2/28/2013 Mexico
3/1/2013 Mexico
3/2/2013 Mexico
3/3/2013 Mexico
3/4/2013 Mexico
3/5/2013 Mexico
3/6/2013 Mexico
3/7/2013 Mexico
3/8/2013 Mexico
3/9/2013 Mexico
3/10/2013 Mexico
3/11/2013 Mexico
3/12/2013 Mexico
3/13/2013 Mexico
3/14/2013 Mexico
3/15/2013 Mexico
3/16/2013 Mexico
3/17/2013 Mexico
3/18/2013 Mexico
3/19/2013 Mexico
3/20/2013 Mexico
3/21/2013 Mexico
49026.264
46702.856
45907.969
48529.563
48604.722
49276.443
49467.271
48711.882
49037.352
47999.545
47335.773
46760.082
48222.176
44811.882
49299.471
49179.802
45909.275
49032.061
45214.955
46167.329
45635.043
48912.797
47262.847
45812.735
46730.95
47752.466
47163.048
48308.54
49335.875
47880.525
46275.885
45641.039
48860.338
47515.171
44804.656
48914.049
45974.866
47288.614
48757.876
46889.299
46480.774
47113.17
51990
49670
48640
50780
51620
52490
52300
51890
52230
50750
50140
49780
51220
47710
52050
52070
48430
52120
48180
48760
47990
52030
50070
48380
49670
49980
49420
51220
52310
50980
48430
48470
51680
50360
47510
51690
48650
49740
51740
49770
49390
50090
0
0
0.07
0
0.07
0
0.07
0
0
0.07
0
0
0
0.07
0
0.07
0.07
0
0
0.07
0.07
0.07
0
0.07
0.07
0.07
0.07
0
0.07
0.07
0.07
0
0.07
0.07
0
0
0.07
0.07
0
0
0.07
0.07
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
3/22/2013 Mexico
3/23/2013 Mexico
3/24/2013 Mexico
3/25/2013 Mexico
3/26/2013 Mexico
3/27/2013 Mexico
3/28/2013 Mexico
3/29/2013 Mexico
3/30/2013 Mexico
3/31/2013 Mexico
4/1/2013 Mexico
4/2/2013 Mexico
4/3/2013 Mexico
4/4/2013 Mexico
4/5/2013 Mexico
4/6/2013 Mexico
4/7/2013 Mexico
4/8/2013 Mexico
4/9/2013 Mexico
4/10/2013 Mexico
4/11/2013 Mexico
4/12/2013 Mexico
4/13/2013 Mexico
4/14/2013 Mexico
4/15/2013 Mexico
4/16/2013 Mexico
4/17/2013 Mexico
4/18/2013 Mexico
4/19/2013 Mexico
4/20/2013 Mexico
4/21/2013 Mexico
4/22/2013 Mexico
4/23/2013 Mexico
4/24/2013 Mexico
4/25/2013 Mexico
4/26/2013 Mexico
4/27/2013 Mexico
4/28/2013 Mexico
4/29/2013 Mexico
4/30/2013 Mexico
5/1/2013 Mexico
5/2/2013 Mexico
46986.644
45700.958
49038.613
45399.726
48900.018
47629.021
44770.272
48008.998
48511.077
48992.818
48211.267
47610.182
46610.347
47041.807
47166.046
46757.934
47139.649
48302.965
47991.524
48069.82
48701.806
45233.841
48325.928
47513.174
48746.056
47727.681
45179.171
45456.695
44909.607
48446.785
46051.765
46726.771
47334.465
48957.439
48304.358
44805.937
44965.981
47851.337
47323.359
48225.178
48266.421
49148.405
49630
48050
51950
48390
51130
50710
47370
50310
51130
52130
51260
50560
49400
50130
49380
49150
50090
50610
50620
50710
51900
48030
51250
49850
51810
50090
48090
48040
47390
51490
48500
49200
49680
52020
50590
47050
47370
50810
50440
50800
51440
51540
0.07
0.07
0.07
0.07
0.07
0.07
0
0
0
0
0.07
0.07
0
0
0
0
0.07
0
0
0
0
0
0.07
0.07
0
0
0.07
0
0.07
0.07
0.07
0
0
0.07
0.07
0.07
0.07
0
0
0
0.07
0.07
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
5/3/2013 Mexico
5/4/2013 Mexico
5/5/2013 Mexico
5/6/2013 Mexico
5/7/2013 Mexico
5/8/2013 Mexico
5/9/2013 Mexico
5/10/2013 Mexico
5/11/2013 Mexico
5/12/2013 Mexico
5/13/2013 Mexico
5/14/2013 Mexico
5/15/2013 Mexico
5/16/2013 Mexico
5/17/2013 Mexico
5/18/2013 Mexico
5/19/2013 Mexico
5/20/2013 Mexico
5/21/2013 Mexico
5/22/2013 Mexico
5/23/2013 Mexico
5/24/2013 Mexico
5/25/2013 Mexico
5/26/2013 Mexico
5/27/2013 Mexico
5/28/2013 Mexico
5/29/2013 Mexico
5/30/2013 Mexico
5/31/2013 Mexico
6/1/2013 Mexico
6/2/2013 Mexico
6/3/2013 Mexico
6/4/2013 Mexico
6/5/2013 Mexico
6/6/2013 Mexico
6/7/2013 Mexico
6/8/2013 Mexico
6/9/2013 Mexico
6/10/2013 Mexico
6/11/2013 Mexico
6/12/2013 Mexico
6/13/2013 Mexico
46616.81
49267.529
49343.597
48947.757
48373.799
47463.032
47132.561
46550.126
44827.584
47942.042
47012.03
47544.879
48624.96
45387.571
46125.989
48210.418
48597.847
48034.938
48783.244
47770.144
49227.905
48676.146
46750.846
48848.3
45643.957
45568.209
46795.849
49126.179
46404.323
48101.613
46348.062
44786.637
45820.753
49386.038
44953.716
47539.655
49253.698
46279.397
47330.734
48375.647
48571.374
45167.15
49230
51750
52430
51810
51580
49900
50050
49010
47130
50530
49760
50670
51060
48410
48590
51160
50980
50540
51650
50370
52020
51440
48890
52040
48510
48180
49120
52130
49450
50300
48790
47160
48730
52550
47500
49720
52380
49260
49620
50860
51290
47470
0.07
0
0
0.07
0.07
0.07
0.07
0.07
0.07
0.07
0.07
0
0.07
0.07
0
0.07
0
0
0.07
0.07
0
0.07
0.07
0
0.07
0.07
0.07
0
0
0.07
0.07
0.07
0
0
0
0.07
0.07
0
0
0.07
0.07
0.07
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
6/14/2013 Mexico
6/15/2013 Mexico
6/16/2013 Mexico
6/17/2013 Mexico
6/18/2013 Mexico
6/19/2013 Mexico
6/20/2013 Mexico
6/21/2013 Mexico
6/22/2013 Mexico
6/23/2013 Mexico
6/24/2013 Mexico
6/25/2013 Mexico
6/26/2013 Mexico
6/27/2013 Mexico
6/28/2013 Mexico
6/29/2013 Mexico
6/30/2013 Mexico
7/1/2013 Mexico
7/2/2013 Mexico
7/3/2013 Mexico
7/4/2013 Mexico
7/5/2013 Mexico
7/6/2013 Mexico
7/7/2013 Mexico
7/8/2013 Mexico
7/9/2013 Mexico
7/10/2013 Mexico
7/11/2013 Mexico
7/12/2013 Mexico
7/13/2013 Mexico
7/14/2013 Mexico
7/15/2013 Mexico
7/16/2013 Mexico
7/17/2013 Mexico
7/18/2013 Mexico
7/19/2013 Mexico
7/20/2013 Mexico
7/21/2013 Mexico
7/22/2013 Mexico
7/23/2013 Mexico
7/24/2013 Mexico
7/25/2013 Mexico
47982.915
46041.143
48154.675
46327.732
47452.976
46811.468
48365.193
46099.923
48234.151
46861.493
48515.058
48782.513
49194.288
47805.463
45374.428
47016.806
44785.22
46866.137
48762.251
46796.629
49353.324
45162.994
48449.691
44779.001
47635.38
49047.451
46797.052
45287.694
47510.321
48072.109
49153.531
48898.657
45753.993
46547.411
46478.914
45269.923
45251.208
45664.097
46450.549
45308.022
47302.605
47325.186
50570
48260
50760
49110
49920
49300
51080
48270
50910
49190
51070
51150
52130
50880
47980
49960
47110
49640
51240
49790
52280
47670
50770
47200
50160
51390
49390
47760
50110
50290
52220
51580
48120
49560
49570
47640
48130
47920
48940
47580
49890
49970
0.07
0
0
0
0
0.07
0.07
0
0.07
0
0
0.07
0.07
0.07
0.07
0
0
0
0
0
0
0.07
0.07
0.07
0
0.07
0.07
0.07
0.07
0.07
0
0
0.07
0
0
0.07
0
0.07
0
0
0.07
0.07
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
7/26/2013 Mexico
7/27/2013 Mexico
7/28/2013 Mexico
7/29/2013 Mexico
7/30/2013 Mexico
7/31/2013 Mexico
8/1/2013 Mexico
8/2/2013 Mexico
8/3/2013 Mexico
8/4/2013 Mexico
8/5/2013 Mexico
8/6/2013 Mexico
8/7/2013 Mexico
8/8/2013 Mexico
8/9/2013 Mexico
8/10/2013 Mexico
8/11/2013 Mexico
8/12/2013 Mexico
8/13/2013 Mexico
8/14/2013 Mexico
8/15/2013 Mexico
8/16/2013 Mexico
8/17/2013 Mexico
8/18/2013 Mexico
8/19/2013 Mexico
8/20/2013 Mexico
8/21/2013 Mexico
8/22/2013 Mexico
8/23/2013 Mexico
8/24/2013 Mexico
8/25/2013 Mexico
8/26/2013 Mexico
8/27/2013 Mexico
8/28/2013 Mexico
8/29/2013 Mexico
8/30/2013 Mexico
8/31/2013 Mexico
9/1/2013 Mexico
9/2/2013 Mexico
9/3/2013 Mexico
9/4/2013 Mexico
9/5/2013 Mexico
45716.214
47733.167
48844.217
45104.019
47421.919
47932.203
48200.337
48108.506
45559.827
46754.692
48535.556
47712.007
48719.22
45887.571
48028.619
45441.043
48128.066
46211.488
47046.806
45129.054
46934.204
47692.32
48825.229
48597.994
45079.91
44933.187
46018.244
46710.587
46670.225
46833.293
48486.392
48288.032
46845.506
46581.406
44814.646
45620.725
47144.912
48728.286
48194.148
44938.454
48987.36
45378.725
48320
49990
51220
47160
49770
50480
50540
51140
48410
48940
50900
50110
51590
48880
50980
48170
50380
48610
49390
47610
49210
50000
51400
51200
47780
47530
48730
49720
49360
49800
50970
51310
49920
49410
47050
48230
49710
51230
50430
47240
51470
47640
0
0.07
0.07
0
0.07
0
0
0
0
0.07
0
0.07
0.07
0
0
0.07
0.07
0
0.07
0
0.07
0
0
0.07
0
0.07
0.07
0.07
0.07
0.07
0.07
0
0.07
0.07
0.07
0.07
0.07
0.07
0.07
0
0
0
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
9/6/2013 Mexico
9/7/2013 Mexico
9/8/2013 Mexico
9/9/2013 Mexico
9/10/2013 Mexico
9/11/2013 Mexico
9/12/2013 Mexico
9/13/2013 Mexico
9/14/2013 Mexico
9/15/2013 Mexico
9/16/2013 Mexico
9/17/2013 Mexico
9/18/2013 Mexico
9/19/2013 Mexico
9/20/2013 Mexico
9/21/2013 Mexico
9/22/2013 Mexico
9/23/2013 Mexico
9/24/2013 Mexico
9/25/2013 Mexico
9/26/2013 Mexico
9/27/2013 Mexico
9/28/2013 Mexico
9/29/2013 Mexico
9/30/2013 Mexico
10/1/2013 Mexico
10/2/2013 Mexico
10/3/2013 Mexico
10/4/2013 Mexico
10/5/2013 Mexico
10/6/2013 Mexico
10/7/2013 Mexico
10/8/2013 Mexico
10/9/2013 Mexico
10/10/2013 Mexico
10/11/2013 Mexico
10/12/2013 Mexico
10/13/2013 Mexico
10/14/2013 Mexico
10/15/2013 Mexico
10/16/2013 Mexico
10/17/2013 Mexico
45759.886
47935.516
45668.076
46032.453
46928.285
46375.157
48123.402
48762.772
47879.43
45273.792
46010.887
45402.948
49417.528
49031.654
44811.806
49390.809
46499.507
48931.894
46177.493
45903.14
46039.181
47625.595
46817.439
45096.628
48286.373
47659.606
46518.072
48678.551
45547.605
49101.79
47386.862
47698.007
48067.181
48412.662
48414.689
48820.953
45180.596
45890.336
48980.734
46538.382
44775.62
47418.687
48800
50740
48700
48620
49970
49310
51200
51810
50680
47950
48300
47790
51800
52180
47750
52460
49350
52000
48370
48620
48870
49940
49470
47520
50670
50140
49400
51400
48570
51670
49550
50010
51210
50720
50960
51330
47270
48620
51250
49570
46950
50140
0.07
0
0
0
0.07
0.07
0.07
0.07
0
0
0.07
0
0.07
0.07
0.07
0.07
0.07
0
0.07
0
0.07
0
0
0
0.07
0.07
0
0.07
0.07
0
0
0.07
0.07
0.07
0
0.07
0.07
0
0.07
0.07
0
0.07
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
10/18/2013 Mexico
10/19/2013 Mexico
10/20/2013 Mexico
10/21/2013 Mexico
10/22/2013 Mexico
10/23/2013 Mexico
10/24/2013 Mexico
10/25/2013 Mexico
10/26/2013 Mexico
10/27/2013 Mexico
10/28/2013 Mexico
10/29/2013 Mexico
10/30/2013 Mexico
10/31/2013 Mexico
11/1/2013 Mexico
11/2/2013 Mexico
11/3/2013 Mexico
11/4/2013 Mexico
11/5/2013 Mexico
11/6/2013 Mexico
11/7/2013 Mexico
11/8/2013 Mexico
11/9/2013 Mexico
11/10/2013 Mexico
11/11/2013 Mexico
11/12/2013 Mexico
11/13/2013 Mexico
11/14/2013 Mexico
11/15/2013 Mexico
11/16/2013 Mexico
11/17/2013 Mexico
11/18/2013 Mexico
11/19/2013 Mexico
11/20/2013 Mexico
11/21/2013 Mexico
11/22/2013 Mexico
11/23/2013 Mexico
11/24/2013 Mexico
11/25/2013 Mexico
11/26/2013 Mexico
11/27/2013 Mexico
11/28/2013 Mexico
46307.285
48864.059
46485.094
46887.631
47903.282
48910.472
47818.894
49454.376
46645.032
49221.599
49183.096
48683.376
49061.816
48119.497
47959.542
46782.186
47655.447
48554.48
45071.334
46728.631
46541.714
47962.175
46701.121
45907.385
46241.872
47966.28
48065.246
47407.446
47666.696
46627.616
44772.223
45033.54
45563.932
49052.665
48918.922
47443.557
45487.061
48130.786
45988.593
49174.895
46408.107
46969.037
48760
51910
48740
49150
50640
51290
50450
52260
48920
51720
52060
51880
51860
51150
50710
49120
50760
51340
48060
49620
49620
50470
49480
48400
48660
50910
50680
50530
50810
49010
47210
47550
47790
52000
52010
50110
47880
51030
48140
52030
49360
49160
0
0
0
0
0.07
0.07
0
0
0
0.07
0
0.07
0.07
0.07
0.07
0
0
0.07
0
0.07
0.07
0.07
0.07
0
0
0.07
0
0.07
0.07
0.07
0.07
0.07
0
0.07
0
0.07
0.07
0.07
0
0
0
0
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
11/29/2013 Mexico
11/30/2013 Mexico
12/1/2013 Mexico
12/2/2013 Mexico
12/3/2013 Mexico
12/4/2013 Mexico
12/5/2013 Mexico
12/6/2013 Mexico
12/7/2013 Mexico
12/8/2013 Mexico
12/9/2013 Mexico
12/10/2013 Mexico
12/11/2013 Mexico
12/12/2013 Mexico
12/13/2013 Mexico
12/14/2013 Mexico
12/15/2013 Mexico
12/16/2013 Mexico
12/17/2013 Mexico
12/18/2013 Mexico
12/19/2013 Mexico
12/20/2013 Mexico
12/21/2013 Mexico
12/22/2013 Mexico
12/23/2013 Mexico
12/24/2013 Mexico
12/25/2013 Mexico
12/26/2013 Mexico
12/27/2013 Mexico
12/28/2013 Mexico
12/29/2013 Mexico
12/30/2013 Mexico
12/31/2013 Mexico
1/1/2013 Frankfurt
1/2/2013 Frankfurt
1/3/2013 Frankfurt
1/4/2013 Frankfurt
1/5/2013 Frankfurt
1/6/2013 Frankfurt
1/7/2013 Frankfurt
1/8/2013 Frankfurt
1/9/2013 Frankfurt
48713.425
47001.93
48165.531
45423.55
45503.229
44959.723
46725.447
47930.2
45139.917
44866.871
48331.879
46421.004
47980.192
47746.44
48531.792
46848.695
48481.976
45620.634
47066.206
47329.16
48206.253
46861.344
46444.714
48575.939
46574.455
48625.164
45507.422
45437.861
47477.836
46817.862
47651.039
48153.275
45435.716
106029.417
103316.634
98978.516
99827.998
103167.708
100088.566
108088.244
104871.483
105178.413
51200
49650
51050
48380
48360
47330
49140
50130
47800
46990
50740
49270
50780
50540
50880
49220
50700
47880
49360
50290
50800
49070
49320
50820
49560
51590
48150
48140
50480
49360
49840
50560
47650
108190.841
104943.204
99935.301
101288.582
104265.225
101502.971
108273.775
106499.302
106222.201
0.07
0
0.07
0.07
0
0.07
0.07
0.07
0
0
0.07
0.07
0
0.07
0.07
0
0.07
0
0
0.07
0.07
0
0
0
0
0.07
0.07
0.07
0.07
0
0
0.07
0.07
0.04572364
0.04561285
0.04510253
0.04514503
0.0457282
0.04544935
0.04523969
0.04562494
0.045636
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
9.53621347
0.40644172
0.40644172
0.40644172
0.40644172
0.40644172
0.40644172
0.40644172
0.40644172
0.40644172
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
1.43837357
0.07768405
0.07768405
0.07768405
0.07768405
0.07768405
0.07768405
0.07768405
0.07768405
0.07768405
1/10/2013 Frankfurt
1/11/2013 Frankfurt
1/12/2013 Frankfurt
1/13/2013 Frankfurt
1/14/2013 Frankfurt
1/15/2013 Frankfurt
1/16/2013 Frankfurt
1/17/2013 Frankfurt
1/18/2013 Frankfurt
1/19/2013 Frankfurt
1/20/2013 Frankfurt
1/

Related Questions:

  1. ACC 502- Managerial Case
  2. mgt 311.211.322 haya
  3. Apply the analytical process to accomplishing the daily tasks.
  4. HRM533: WEEK 1 discussion