Business MBA course

Histograms

			Quality Control in Manufacturing
Sample #	Time	Diameter (cm)
#1	12:00 AM	9.959
#2	12:05 AM	9.945
#3	12:10 AM	10.011
#4	12:15 AM	10.027
#5	12:20 AM	10.084
#6	12:25 AM	9.964
#7	12:30 AM	9.911
#8	12:35 AM	9.979
#9	12:40 AM	10.020
#10	12:45 AM	10.010
#11	12:50 AM	9.993
#12	12:55 AM	9.991
#13	1:00 AM	9.960
#14	1:05 AM	10.072
#15	1:10 AM	10.052
#16	1:15 AM	9.960
#17	1:20 AM	10.090
#18	1:25 AM	10.061
#19	1:30 AM	9.906
#20	1:35 AM	10.033
#21	1:40 AM	10.057
#22	1:45 AM	10.048
#23	1:50 AM	10.055
#24	1:55 AM	10.026
#25	2:00 AM	9.955
#26	2:05 AM	9.952
#27	2:10 AM	9.956
#28	2:15 AM	9.996
#29	2:20 AM	10.012
#30	2:25 AM	9.931
#31	2:30 AM	10.077
#32	2:35 AM	9.941
#33	2:40 AM	9.945
#34	2:45 AM	9.958
#35	2:50 AM	9.921
#36	2:55 AM	10.008
#37	3:00 AM	9.963
#38	3:05 AM	9.961
#39	3:10 AM	10.047
#40	3:15 AM	9.975
#41	3:20 AM	10.109
#42	3:25 AM	9.942
#43	3:30 AM	9.967
#44	3:35 AM	10.036
#45	3:40 AM	10.011
#46	3:45 AM	9.977
#47	3:50 AM	9.968
#48	3:55 AM	10.015
#49	4:00 AM	9.947
#50	4:05 AM	9.903
#51	4:10 AM	9.901
#52	4:15 AM	9.930
#53	4:20 AM	9.982
#54	4:25 AM	10.094
#55	4:30 AM	9.907
#56	4:35 AM	9.935
#57	4:40 AM	10.030
#58	4:45 AM	10.085
#59	4:50 AM	9.932
#60	4:55 AM	10.165
#61	5:00 AM	9.920
#62	5:05 AM	10.103
#63	5:10 AM	9.911
#64	5:15 AM	10.048
#65	5:20 AM	9.945
#66	5:25 AM	10.001
#67	5:30 AM	10.111
#68	5:35 AM	9.963
#69	5:40 AM	9.944
#70	5:45 AM	9.966
#71	5:50 AM	10.171
#72	5:55 AM	10.019
#73	6:00 AM	10.130
#74	6:05 AM	10.066
#75	6:10 AM	9.931
#76	6:15 AM	10.131
#77	6:20 AM	10.122
#78	6:25 AM	10.046
#79	6:30 AM	9.911
#80	6:35 AM	9.957
#81	6:40 AM	9.985
#82	6:45 AM	10.056
#83	6:50 AM	9.977
#84	6:55 AM	10.161
#85	7:00 AM	10.045
#86	7:05 AM	9.951
#87	7:10 AM	10.051
#88	7:15 AM	10.099
#89	7:20 AM	9.930
#90	7:25 AM	9.904
#91	7:30 AM	9.985
#92	7:35 AM	10.075
#93	7:40 AM	10.029
#94	7:45 AM	10.016
#95	7:50 AM	9.951
#96	7:55 AM	10.010
#97	8:00 AM	10.036
#98	8:05 AM	10.040
#99	8:10 AM	9.992
#100	8:15 AM	10.073
#101	8:20 AM	10.036
#102	8:25 AM	9.982
#103	8:30 AM	10.005
#104	8:35 AM	9.958
#105	8:40 AM	10.046
#106	8:45 AM	9.956
#107	8:50 AM	9.945
#108	8:55 AM	10.058
#109	9:00 AM	10.024
#110	9:05 AM	9.964
#111	9:10 AM	9.913
#112	9:15 AM	10.070
#113	9:20 AM	10.176
#114	9:25 AM	9.973
#115	9:30 AM	9.949
#116	9:35 AM	10.044
#117	9:40 AM	9.976
#118	9:45 AM	10.056
#119	9:50 AM	10.165
#120	9:55 AM	9.957
#121	10:00 AM	10.020
#122	10:05 AM	10.094
#123	10:10 AM	10.061
#124	10:15 AM	10.027
#125	10:20 AM	10.080
#126	10:25 AM	9.987
#127	10:30 AM	10.103
#128	10:35 AM	9.923
#129	10:40 AM	9.952
#130	10:45 AM	10.054
#131	10:50 AM	10.049
#132	10:55 AM	9.984
#133	11:00 AM	9.931
#134	11:05 AM	10.111
#135	11:10 AM	10.081
#136	11:15 AM	10.109
#137	11:20 AM	10.025
#138	11:25 AM	10.035
#139	11:30 AM	9.996
#140	11:35 AM	10.006
#141	11:40 AM	10.066
#142	11:45 AM	10.025
#143	11:50 AM	10.056
#144	11:55 AM	10.150
#145	12:00 PM	10.088
#146	12:05 PM	9.982
#147	12:10 PM	9.930
#148	12:15 PM	10.027
#149	12:20 PM	10.096
#150	12:25 PM	10.120
#151	12:30 PM	9.995
#152	12:35 PM	9.951
#153	12:40 PM	10.003
#154	12:45 PM	9.957
#155	12:50 PM	10.015
#156	12:55 PM	9.939
#157	1:00 PM	10.105
#158	1:05 PM	10.004
#159	1:10 PM	9.965
#160	1:15 PM	10.118
#161	1:20 PM	9.994
#162	1:25 PM	9.933
#163	1:30 PM	9.991
#164	1:35 PM	9.941
#165	1:40 PM	9.996
#166	1:45 PM	9.892
#167	1:50 PM	9.944
#168	1:55 PM	10.079
#169	2:00 PM	9.935
#170	2:05 PM	9.985
#171	2:10 PM	10.052
#172	2:15 PM	9.991
#173	2:20 PM	9.982
#174	2:25 PM	10.036
#175	2:30 PM	10.127
#176	2:35 PM	9.921
#177	2:40 PM	10.129
#178	2:45 PM	9.916
#179	2:50 PM	10.011
#180	2:55 PM	10.014
#181	3:00 PM	10.042
#182	3:05 PM	10.088
#183	3:10 PM	9.987
#184	3:15 PM	10.195
#185	3:20 PM	10.142
#186	3:25 PM	9.987
#187	3:30 PM	9.985
#188	3:35 PM	9.994
#189	3:40 PM	10.118
#190	3:45 PM	9.974
#191	3:50 PM	9.932
#192	3:55 PM	9.935
#193	4:00 PM	9.986
#194	4:05 PM	9.950
#195	4:10 PM	9.977
#196	4:15 PM	9.986
#197	4:20 PM	10.076
#198	4:25 PM	10.012
#199	4:30 PM	9.922
#200	4:35 PM	9.936
#201	4:40 PM	10.103
#202	4:45 PM	10.039
#203	4:50 PM	10.143
#204	4:55 PM	9.975
#205	5:00 PM	10.174
#206	5:05 PM	10.044
#207	5:10 PM	10.015
#208	5:15 PM	9.982
#209	5:20 PM	9.922
#210	5:25 PM	9.968
#211	5:30 PM	9.909
#212	5:35 PM	9.986
#213	5:40 PM	9.982
#214	5:45 PM	9.955
#215	5:50 PM	9.993
#216	5:55 PM	10.053
#217	6:00 PM	10.078
#218	6:05 PM	9.967
#219	6:10 PM	9.949
#220	6:15 PM	10.154
#221	6:20 PM	9.925
#222	6:25 PM	9.902
#223	6:30 PM	9.996
#224	6:35 PM	9.961
#225	6:40 PM	10.148
#226	6:45 PM	9.964
#227	6:50 PM	9.999
#228	6:55 PM	9.940
#229	7:00 PM	10.115
#230	7:05 PM	10.077
#231	7:10 PM	10.053
#232	7:15 PM	9.964
#233	7:20 PM	10.065
#234	7:25 PM	9.954
#235	7:30 PM	9.946
#236	7:35 PM	10.099
#237	7:40 PM	9.940
#238	7:45 PM	10.041
#239	7:50 PM	9.986
#240	7:55 PM	10.077
#241	8:00 PM	9.955
#242	8:05 PM	10.008
#243	8:10 PM	9.997
#244	8:15 PM	9.907
#245	8:20 PM	10.062
#246	8:25 PM	9.994
#247	8:30 PM	9.957
#248	8:35 PM	10.130
#249	8:40 PM	10.039
#250	8:45 PM	9.930
#251	8:50 PM	10.075
#252	8:55 PM	10.178
#253	9:00 PM	10.025
#254	9:05 PM	9.774
#255	9:10 PM	10.034
#256	9:15 PM	10.127
#257	9:20 PM	9.923
#258	9:25 PM	10.068
#259	9:30 PM	9.941
#260	9:35 PM	9.905
#261	9:40 PM	10.050
#262	9:45 PM	10.027
#263	9:50 PM	9.914
#264	9:55 PM	10.113
#265	10:00 PM	9.997
#266	10:05 PM	10.035
#267	10:10 PM	9.967
#268	10:15 PM	9.920
#269	10:20 PM	9.926
#270	10:25 PM	9.720
#271	10:30 PM	9.810
#272	10:35 PM	9.750
#273	10:40 PM	9.740
#274	10:45 PM	9.760
#275	10:50 PM	9.736
#276	10:55 PM	9.735
#277	11:00 PM	9.750
#278	11:05 PM	9.850
#279	11:10 PM	9.710
#280	11:15 PM	9.725
#281	11:20 PM	9.801
#282	11:25 PM	9.775
#283	11:30 PM	9.789
#284	11:35 PM	9.782
#285	11:40 PM	9.786
#286	11:45 PM	9.782
#287	11:50 PM	9.775
#288	11:55 PM	9.750

Step #1: First understand the data and try to determine what the data is trying to tell you. Describe the data in a single paragraph ANSWER:

Determine if you want to tell a story by time or by diameter. If we assume that the first story is about the distribution of diameters per day then our histogram will have the X Axis in categories with the diameter of the rods. This means we will have to develop bins or categories. Question: How would you determine the number of bins and the range of each bin? ANSWER:

Create a histogram titled "Frequency of Diameters for a 24 hour period" Question: What does this histogram tell you? Are diameters symmetric or skewed. Does it look normally distributed? Is the average diameter close to 10 cm? ANSWER:

In manufacturing they use a lot of control charts to determine if a process, such as the manufacture of rods is in control or not. To create a control chart you simply plot a Scatter chart (no lines - just data points). The X Axis is time and Y axis is diameter. Create a control chart for the rod diameters . Using this very basic control chart what do you notice now? ANSWER:

The following is a series of measurements of a motor armature that were taken over one day (24 hours every 5 minutes) at a company that manufactures small motors. The average target thickness is 10 cm. If the rod is too thin the motor will fail earlier and might be returned for warranty. If the rod is too thick the company will have reduced profit as the raw material for the rod is expensive. An armature is the rod that spins in a motor and it is very critical that this rod is of a certain thickness .

Statistics

Store A Respondent#	Age Category	Income	#Desserts Out per Month		Store B Respondent#	Age Category	Income	#Desserts Out per Month
#1	22-25	5,000	4		#1	30-35	75,000	0
#2	30-35	100,000	5		#10	30-35	75,000	4
#3	26-30	75,000	3		#100	18-21	10,000	6
#4	18-21	40,000	0		#11	30-35	100,000	5
#5	30-35	100,000	12		#12	18-21	30,000	10
#6	26-30	50,000	8		#13	22-25	5,000	9
#7	30-35	20,000	1		#14	18-21	30,000	0
#8	30-35	100,000	18		#15	18-21	30,000	0
#9	30-35	20,000	14		#16	over 35	100,000	1
#10	30-35	100,000	4		#17	30-35	100,000	7
#11	30-35	75,000	0		#18	26-30	50,000	5
#12	18-21	30,000	0		#19	30-35	100,000	16
#13	22-25	30,000	4		#2	30-35	30,000	13
#14	18-21	30,000	0		#20	18-21	20,000	9
#15	18-21	5,000	0		#21	30-35	75,000	12
#16	over 35	50,000	1		#22	26-30	10,000	1
#17	30-35	40,000	1		#23	18-21	5,000	11
#18	26-30	20,000	10		#24	30-35	40,000	0
#19	30-35	100,000	11		#25	30-35	30,000	15
#20	18-21	30,000	0		#26	22-25	50,000	2
#21	30-35	30,000	3		#27	over 35	10,000	4
#22	26-30	75,000	1		#28	over 35	40,000	11
#23	18-21	5,000	0		#29	22-25	30,000	14
#24	22-25	20,000	0		#3	26-30	5,000	3
#25	18-21	10,000	0		#30	over 35	40,000	9
#26	22-25	5,000	13		#31	18-21	10,000	0
#27	26-30	75,000	5		#32	18-21	10,000	8
#28	over 35	20,000	4		#33	26-30	40,000	0
#29	22-25	5,000	14		#34	22-25	30,000	16
#30	over 35	100,000	12		#35	22-25	30,000	3
#31	18-21	10,000	0		#36	22-25	20,000	6
#32	18-21	10,000	0		#37	26-30	5,000	7
#33	26-30	100,000	11		#38	18-21	20,000	20
#34	22-25	10,000	3		#39	30-35	5,000	7
#35	22-25	50,000	13		#4	18-21	20,000	0
#36	22-25	20,000	6		#40	22-25	5,000	6
#37	26-30	20,000	6		#41	30-35	40,000	2
#38	18-21	10,000	0		#42	18-21	40,000	7
#39	30-35	75,000	1		#43	over 35	10,000	5
#40	22-25	30,000	20		#44	22-25	100,000	2
#41	30-35	100,000	2		#45	over 35	50,000	23
#42	18-21	5,000	0		#46	18-21	10,000	6
#43	22-25	10,000	8		#47	18-21	10,000	18
#44	22-25	20,000	20		#48	26-30	5,000	1
#45	30-35	20,000	9		#49	22-25	10,000	2
#46	18-21	20,000	0		#5	30-35	100,000	4
#47	18-21	5,000	0		#50	22-25	100,000	3
#48	26-30	5,000	10		#51	22-25	30,000	4
#49	22-25	5,000	15		#52	22-25	30,000	11
#50	22-25	50,000	14		#53	22-25	20,000	2
#51	22-25	40,000	20		#54	18-21	30,000	19
#52	22-25	50,000	13		#55	over 35	20,000	18
#53	22-25	5,000	3		#56	26-30	30,000	19
#54	18-21	40,000	0		#57	18-21	10,000	5
#55	30-35	100,000	3		#58	18-21	40,000	11
#56	26-30	50,000	20		#59	30-35	100,000	2
#57	18-21	30,000	0		#6	26-30	20,000	10
#58	18-21	30,000	0		#60	26-30	20,000	0
#59	30-35	100,000	7		#61	18-21	20,000	13
#60	26-30	30,000	5		#62	26-30	40,000	4
#61	18-21	10,000	0		#63	over 35	50,000	2
#62	26-30	75,000	18		#64	30-35	30,000	9
#63	over 35	100,000	8		#65	18-21	10,000	8
#64	30-35	5,000	0		#66	22-25	75,000	9
#65	18-21	30,000	0		#67	30-35	100,000	7
#66	22-25	100,000	7		#68	over 35	100,000	14
#67	30-35	5,000	2		#69	over 35	20,000	0
#68	over 35	50,000	6		#7	30-35	75,000	8
#69	26-30	20,000	1		#70	over 35	50,000	1
#70	26-30	50,000	7		#71	26-30	100,000	2
#71	26-30	30,000	3		#72	18-21	20,000	23
#72	18-21	20,000	0		#73	30-35	75,000	17
#73	30-35	40,000	10		#74	26-30	10,000	4
#74	26-30	30,000	3		#75	18-21	5,000	16
#75	18-21	5,000	0		#76	over 35	10,000	2
#76	over 35	10,000	20		#77	26-30	30,000	8
#77	26-30	20,000	25		#78	18-21	5,000	19
#78	18-21	5,000	0		#79	22-25	5,000	0
#79	22-25	50,000	5		#8	30-35	100,000	9
#80	over 35	20,000	1		#80	over 35	100,000	7
#81	18-21	30,000	0		#81	18-21	40,000	14
#82	30-35	100,000	14		#82	30-35	40,000	1
#83	26-30	5,000	2		#83	26-30	30,000	17
#84	30-35	100,000	9		#84	30-35	100,000	2
#85	26-30	20,000	17		#85	30-35	30,000	16
#86	18-21	40,000	0		#86	18-21	5,000	9
#87	18-21	30,000	0		#87	18-21	20,000	1
#88	18-21	30,000	0		#88	18-21	30,000	4
#89	26-30	5,000	18		#89	26-30	100,000	1
#90	over 35	10,000	8		#9	30-35	30,000	4
#91	22-25	75,000	13		#90	over 35	100,000	20
#92	18-21	10,000	0		#91	22-25	20,000	5
#93	26-30	20,000	11		#92	18-21	30,000	2
#94	26-30	40,000	22		#93	26-30	100,000	13
#95	18-21	10,000	0		#94	26-30	20,000	0
#96	22-25	75,000	17		#95	18-21	10,000	6
#97	18-21	30,000	0		#96	22-25	5,000	17
#98	22-25	75,000	12		#97	18-21	10,000	0
#99	22-25	100,000	16		#98	22-25	20,000	3
#100	18-21	5,000	0		#99	22-25	100,000	0

You own 2 dessert cafe's and for the last month you have surveyed 100 people that came into your cafe. In the survey you asked them their Age category, income category and how many desserts they had last month at any restaurant. You have compiled all the data below for Store A and Store B. Now you need to run some statistical analysis.

Step #1: First generate some basic statistics on the two stores with respect to the number of Desserts that are eaten out in a month. Use Excel Data Analysis - Descriptive Statistics for each store and compare in a paragraph or two what you found by looking at the statistical output for the stores. ANSWER:

Step #2: You are thinking of making your cafe a little higher end as you expect that the people with higher incomes eat more desserts than the ones with lower incomes. For Store A only what is the probability that a customer will have an income over $75,000 and what is the average number of desserts that customers that are in the $75,000 income or greater eat in one month? What are the same numbers for Customers who make less than $30,000 per year? Is there data to support your assumption that higher income go out for dessert more often? Explain. ANSWER: .

Step #3: You are thinking of making your cafe cater to a younger crowd as you expect that younger people have more disposable income and eat out more as older customers stay at home with their families more or have less disposable income. For Store B only what is the probability that a customer will be 25 or under and what is the average and total number of desserts that customers in this age group eat in one month? What are the same numbers for Customers who are over 35? Is there data to support your assumption that younger people go out for dessert more often? Explain. ANSWER:

Pivot Tables

Country

Salesperson

Order Amount

Order Date

Sale Date

OrderID

Canada

Buchanan

$440.00

7/16/09

9/26/09

10248

Canada

Suyama

$1,863.40

7/10/09

7/21/09

10249

USA

Peacock

$1,552.60

7/12/09

8/3/09

10250

USA

Leverling

$654.06

7/15/09

9/5/09

10251

USA

Peacock

$3,597.90

7/11/09

10/19/09

10252

USA

Leverling

$1,444.80

7/16/09

10/4/09

10253

Canada

Buchanan

$556.62

7/23/09

8/11/09

10254

Canada

Dodsworth

$2,490.50

7/15/09

11/11/09

10255

USA

Leverling

$517.80

7/17/09

9/3/09

10256

USA

Peacock

$1,119.90

7/22/09

8/29/09

10257

USA

Davolio

$1,614.88

7/23/09

9/11/09

10258

USA

Peacock

$100.80

7/25/09

10/18/09

10259

USA

Peacock

$1,504.65

7/29/09

8/11/09

10260

USA

Peacock

$448.00

7/30/09

9/24/09

10261

USA

Callahan

$584.00

7/25/09

8/7/09

10262

Canada

Dodsworth

$1,873.80

7/31/09

8/20/09

10263

Canada

Suyama

$695.62

8/23/09

10/25/09

10264

USA

Fuller

$1,176.00

8/12/09

11/29/09

10265

USA

Leverling

$346.56

7/31/09

11/3/09

10266

USA

Peacock

$3,536.60

8/6/09

10/8/09

10267

USA

Callahan

$1,101.20

8/2/09

11/30/09

10268

Canada

Buchanan

$642.20

8/9/09

10/1/09

10269

USA

Davolio

$1,376.00

8/2/09

11/23/09

10270

Canada

Suyama

$48.00

8/30/09

10/9/09

10271

Canada

Suyama

$1,456.00

8/6/09

10/1/09

10272

USA

Leverling

$2,037.28

8/12/09

9/15/09

10273

Canada

Suyama

$538.60

8/16/09

11/18/09

10274

USA

Davolio

$291.84

8/9/09

10/27/09

10275

USA

Callahan

$420.00

8/14/09

12/1/09

10276

USA

Fuller

$1,200.80

8/13/09

11/12/09

10277

USA

Callahan

$1,488.80

8/16/09

11/27/09

10278

USA

Callahan

$351.00

8/16/09

10/28/09

10279

USA

Fuller

$613.20

9/12/09

9/30/09

10280

USA

Peacock

$86.50

8/21/09

12/11/09

10281

USA

Peacock

$155.40

8/21/09

11/24/09

10282

USA

Leverling

$1,414.80

8/23/09

10/8/09

10283

USA

Peacock

$1,170.37

8/27/09

10/1/09

10284

USA

Davolio

$1,743.36

8/26/09

10/12/09

10285

USA

Callahan

$3,016.00

8/30/09

11/16/09

10286

USA

Callahan

$819.00

8/28/09

11/5/09

10287

USA

Peacock

$80.10

9/3/09

10/27/09

10288

Canada

King

$479.40

8/28/09

12/22/09

10289

USA

Callahan

$2,169.00

9/3/09

11/1/09

10290

Suyama

$497.52

9/4/09

12/28/09

10291

USA

Davolio

$1,296.00

9/2/09

11/11/09

10292

USA

Davolio

$848.70

9/11/09

12/1/09

10293

USA

Peacock

$1,887.60

9/5/09

12/20/09

10294

USA

Fuller

$121.60

9/10/09

10/10/09

10295

Canada

Suyama

$1,050.60

9/11/09

9/30/09

10296

Canada

Buchanan

$1,420.00

9/10/09

10/10/09

10297

Canada

Suyama

$2,645.00

9/11/09

11/19/09

10298

USA

Peacock

$349.50

9/13/09

10/25/09

10299

USA

Fuller

$608.00

9/18/09

12/9/09

10300

Country

Salesperson

Order Amount

Order Date

Sale Date

OrderID

USA

Callahan

$755.00

9/17/09

10/23/09

10301

USA

Peacock

$2,708.80

10/9/09

1/5/10

10302

Canada

King

$1,117.80

9/18/09

10/9/09

10303

USA

Davolio

$954.40

9/17/09

11/7/09

10304

USA

Callahan

$3,741.30

10/9/09

11/26/09

10305

USA

Davolio

$498.50

9/23/09

12/21/09

10306

USA

Fuller

$424.00

9/25/09

12/1/09

10307

Canada

King

$88.80

9/24/09

10/12/09

10308

USA

Leverling

$1,762.00

10/23/09

2/16/10

10309

USA

Callahan

$336.00

9/27/09

1/22/10

10310

USA

Davolio

$268.80

9/26/09

1/4/10

10311

USA

Fuller

$1,614.80

10/3/09

12/27/09

10312

USA

Fuller

$182.40

10/4/09

10/14/09

10313

USA

Davolio

$2,094.30

10/4/09

12/24/09

10314

USA

Peacock

$516.80

10/3/09

10/17/09

10315

USA

Davolio

$2,835.00

10/8/09

1/29/10

10316

Canada

Suyama

$288.00

10/10/09

1/9/10

10317

USA

Callahan

$240.40

10/4/09

10/19/09

10318

Canada

King

$1,191.20

10/11/09

10/22/09

10319

Canada

Buchanan

$516.00

10/18/09

12/6/09

10320

USA

Leverling

$144.00

10/11/09

10/28/09

10321

Canada

King

$112.00

10/23/09

1/23/10

10322

USA

Peacock

$164.40

10/14/09

2/3/10

10323

Canada

Dodsworth

$5,275.71

10/10/09

11/11/09

10324

USA

Davolio

$1,497.00

10/14/09

12/31/09

10325

USA

Peacock

$982.00

10/14/09

1/12/10

10326

USA

Fuller

$1,810.00

10/14/09

12/25/09

10327

USA

Peacock

$1,168.00

10/17/09

1/16/10

10328

USA

Peacock

$4,578.43

10/23/09

11/23/09

10329

USA

Leverling

$1,649.00

10/28/09

2/11/10

10330

Canada

Dodsworth

$88.50

10/21/09

12/11/09

10331

USA

Leverling

$1,786.88

10/21/09

11/23/09

10332

Canada

Buchanan

$877.20

10/25/09

12/13/09

10333

USA

Callahan

$144.80

10/28/09

2/20/10

10334

Canada

King

$2,036.16

10/24/09

2/4/10

10335

Canada

King

$285.12

10/25/09

1/24/10

10336

USA

Peacock

$2,467.00

10/29/09

1/7/10

10337

USA

Peacock

$934.50

10/29/09

1/31/10

10338

USA

Fuller

$3,354.00

11/4/09

11/16/09

10339

USA

Davolio

$2,436.18

11/8/09

3/4/10

10340

Canada

King

$352.60

11/5/09

1/17/10

10341

USA

Peacock

$1,840.64

11/4/09

2/20/10

10342

USA

Peacock

$1,584.00

11/6/09

12/21/09

10343

USA

Peacock

$2,296.00

11/5/09

1/26/10

10344

USA

Fuller

$2,924.80

11/11/09

11/27/09

10345

USA

Leverling

$1,618.88

11/8/09

1/21/10

10346

USA

Peacock

$814.42

11/8/09

1/17/10

10347

USA

Peacock

$363.60

11/15/09

11/29/09

10348

Canada

King

$141.60

11/15/09

3/2/10

10349

Canada

Suyama

$642.06

12/3/09

2/1/10

10350

USA

Davolio

$5,398.72

11/20/09

12/23/09

10351

USA

Leverling

$136.30

11/18/09

12/3/09

10352

Canada

King

$8,593.28

11/25/09

2/10/10

10353

USA

Callahan

$568.80

11/20/09

2/26/10

10354

Canada

Suyama

$480.00

11/20/09

12/29/09

10355

Canada

Suyama

$1,106.40

11/27/09

2/7/10

10356

USA

Davolio

$1,167.68

12/2/09

2/18/10

10357

Canada

Buchanan

$429.40

11/27/09

1/1/10

10358

Canada

Buchanan

$3,471.68

11/26/09

3/13/10

10359

USA

Peacock

$7,390.20

12/2/09

3/26/10

10360

USA

Davolio

$2,046.24

12/3/09

2/10/10

10361

USA

Leverling

$1,549.60

11/28/09

3/14/10

10362

USA

Peacock

$447.20

12/4/09

3/1/10

10363

USA

Davolio

$950.00

12/4/09

12/27/09

10364

USA

Leverling

$403.20

12/2/09

3/4/10

10365

USA

Callahan

$136.00

12/30/09

4/4/10

10366

Canada

King

$834.20

12/2/09

3/22/10

10367

USA

Fuller

$1,689.78

12/2/09

12/12/09

10368

USA

Callahan

$2,390.40

12/9/09

4/5/10

10369

Canada

Suyama

$1,117.60

12/27/09

2/26/10

10370

USA

Davolio

$72.96

12/24/09

1/9/10

10371

Canada

Buchanan

$9,210.90

12/9/09

1/2/10

10372

USA

Peacock

$1,366.40

12/11/09

2/28/10

10373

USA

Davolio

$459.00

12/9/09

1/29/10

10374

USA

Leverling

$338.00

12/9/09

3/8/10

10375

USA

Davolio

$399.00

12/13/09

1/30/10

10376

USA

Davolio

$863.60

12/13/09

12/27/09

10377

Canada

Buchanan

$103.20

12/19/09

3/23/10

10378

USA

Fuller

$863.28

12/13/09

4/4/10

10379

USA

Callahan

$1,313.82

1/16/10

1/30/10

10380

USA

Leverling

$112.00

12/13/09

1/1/10

10381

USA

Peacock

$2,900.00

12/16/09

2/15/10

10382

USA

Callahan

$899.00

12/18/09

4/12/10

10383

USA

Leverling

$2,222.40

12/20/09

1/29/10

10384

USA

Davolio

$691.20

12/23/09

4/15/10

10385

Canada

Dodsworth

$166.00

12/25/09

1/7/10

10386

USA

Davolio

$1,058.40

12/20/09

2/21/10

10387

USA

Fuller

$1,228.80

12/20/09

3/4/10

10388

USA

Peacock

$1,832.80

12/24/09

4/18/10

10389

Canada

Suyama

$2,090.88

12/26/09

1/30/10

10390

USA

Leverling

$86.40

12/31/09

3/31/10

10391

USA

Fuller

$1,440.00

1/1/10

2/7/10

10392

USA

Davolio

$2,556.95

1/3/10

2/14/10

10393

USA

Davolio

$442.00

1/3/10

4/4/10

10394

Canada

Suyama

$2,122.92

1/3/10

3/19/10

10395

USA

Davolio

$1,903.80

1/6/10

1/17/10

10396

Canada

Buchanan

$716.72

1/2/10

2/5/10

10397

USA

Fuller

$2,505.60

1/9/10

3/14/10

10398

USA

Callahan

$1,765.60

1/8/10

4/25/10

10399

USA

Davolio

$3,063.00

1/16/10

3/16/10

10400

USA

Davolio

$3,868.60

1/10/10

1/24/10

10401

USA

Callahan

$2,713.50

1/10/10

4/11/10

10402

USA

Peacock

$855.01

1/9/10

2/14/10

10403

USA

Fuller

$1,591.25

1/8/10

4/23/10

10404

USA

Davolio

$400.00

1/22/10

5/4/10

10405

Canada

King

$1,830.78

1/13/10

3/2/10

10406

USA

Fuller

$1,194.00

1/30/10

5/11/10

10407

USA

Callahan

$1,622.40

1/14/10

4/10/10

10408

USA

Leverling

$319.20

1/14/10

1/30/10

10409

USA

Leverling

$802.00

1/15/10

4/7/10

10410

Canada

Dodsworth

$966.80

1/21/10

3/22/10

10411

USA

Callahan

$334.80

1/15/10

4/22/10

10412

USA

Leverling

$2,123.20

1/16/10

4/11/10

10413

USA

Fuller

$224.83

1/17/10

4/2/10

10414

USA

Leverling

$102.40

1/24/10

3/17/10

10415

USA

Callahan

$720.00

1/27/10

2/17/10

10416

USA

Peacock

$11,188.40

1/28/10

3/3/10

10417

USA

Peacock

$1,814.80

1/24/10

4/28/10

10418

USA

Peacock

$2,097.60

1/30/10

5/17/10

10419

USA

Leverling

$1,707.84

1/27/10

5/26/10

10420

USA

Callahan

$1,194.27

1/27/10

5/17/10

10421

USA

Fuller

$49.80

1/31/10

2/21/10

10422

Canada

Suyama

$1,020.00

2/24/10

4/7/10

10423

Canada

King

$9,194.56

1/27/10

5/7/10

10424

Canada

Suyama

$360.00

2/14/10

4/29/10

10425

USA

Peacock

$338.20

2/6/10

5/13/10

10426

USA

Peacock

$651.00

3/3/10

4/25/10

10427

Canada

King

$192.00

2/4/10

5/19/10

10428

USA

Leverling

$1,441.37

2/7/10

5/5/10

10429

USA

Peacock

$4,899.20

2/3/10

5/3/10

10430

USA

Peacock

$1,892.25

2/7/10

4/4/10

10431

USA

Leverling

$485.00

2/7/10

5/15/10

10432

USA

Leverling

$851.20

3/4/10

4/28/10

10433

USA

Leverling

$321.12

2/13/10

5/28/10

10434

USA

Callahan

$631.60

2/7/10

3/16/10

10435

USA

Leverling

$1,994.52

2/11/10

6/4/10

10436

USA

Callahan

$393.00

2/12/10

4/15/10

10437

USA

Leverling

$454.00

2/14/10

3/29/10

10438

Canada

Suyama

$1,078.00

2/10/10

3/5/10

10439

USA

Peacock

$4,924.13

2/28/10

6/20/10

10440

USA

Leverling

$1,755.00

3/14/10

3/30/10

10441

USA

Leverling

$1,792.00

2/18/10

5/27/10

10442

USA

Callahan

$517.44

2/14/10

4/17/10

10443

USA

Leverling

$1,031.70

2/21/10

5/18/10

10444

USA

Leverling

$174.90

2/20/10

3/14/10

10445

Canada

Suyama

$246.24

2/19/10

6/13/10

10446

USA

Peacock

$914.40

3/7/10

6/8/10

10447

USA

Peacock

$443.40

2/24/10

4/28/10

10448

USA

Leverling

$1,838.20

2/27/10

6/17/10

10449

USA

Callahan

$425.12

3/11/10

6/2/10

10450

USA

Peacock

$3,849.66

3/12/10

3/29/10

10451

USA

Callahan

$2,018.50

2/26/10

5/24/10

10452

USA

Davolio

$407.70

2/26/10

6/25/10

10453

USA

Peacock

$331.20

2/25/10

6/2/10

10454

USA

Callahan

$2,684.00

3/3/10

6/22/10

10455

USA

Callahan

$557.60

2/28/10

5/14/10

10456

USA

Fuller

$1,584.00

3/3/10

4/5/10

10457

Canada

King

$3,891.00

3/4/10

5/23/10

10458

USA

Peacock

$1,659.20

2/28/10

5/1/10

10459

USA

Callahan

$176.10

3/3/10

5/25/10

10460

USA

Davolio

$1,538.70

3/5/10

4/3/10

10461

USA

Fuller

$156.00

3/18/10

5/16/10

10462

Canada

Buchanan

$713.30

3/6/10

6/8/10

10463

USA

Peacock

$1,609.28

3/14/10

6/24/10

10464

USA

Davolio

$2,518.00

3/14/10

6/27/10

10465

USA

Peacock

$216.00

3/13/10

5/4/10

10466

USA

Callahan

$235.20

3/11/10

4/28/10

10467

USA

Leverling

$717.60

3/12/10

4/22/10

10468

USA

Davolio

$956.67

3/14/10

5/18/10

10469

USA

Peacock

$1,820.80

4/30/10

3/14/10

10470

USA

Fuller

$1,328.00

3/18/10

3/31/10

10471

USA

Callahan

$1,036.80

3/19/10

6/28/10

10472

USA

Davolio

$230.40

3/21/10

6/22/10

10473

Canada

Buchanan

$1,249.10

3/21/10

6/25/10

10474

Canada

Dodsworth

$1,505.18

4/4/10

8/2/10

10475

USA

Callahan

$180.48

3/24/10

5/2/10

10476

Canada

Buchanan

$558.00

3/25/10

5/5/10

10477

USA

Fuller

$471.20

3/26/10

7/8/10

10478

USA

Leverling

$10,495.60

3/21/10

6/1/10

10479

Canada

Suyama

$756.00

3/24/10

7/10/10

10480

USA

Callahan

$1,472.00

3/25/10

4/11/10

10481

USA

Davolio

$147.00

4/10/10

5/7/10

10482

Canada

King

$668.80

4/25/10

8/15/10

10483

USA

Leverling

$386.20

4/1/10

7/20/10

10484

USA

Peacock

$1,584.00

3/31/10

7/12/10

10485

USA

Davolio

$1,272.00

4/2/10

5/13/10

10486

USA

Fuller

$889.70

3/28/10

6/17/10

10487

USA

Callahan

$1,512.00

4/2/10

5/20/10

10488

Canada

Suyama

$439.20

4/9/10

6/26/10

10489

Canada

King

$3,163.20

4/3/10

8/1/10

10490

USA

Callahan

$259.50

4/8/10

6/25/10

10491

USA

Leverling

$851.20

4/11/10

5/31/10

10492

USA

Peacock

$608.40

4/10/10

6/8/10

10493

USA

Peacock

$912.00

4/9/10

5/7/10

10494

USA

Leverling

$278.00

4/11/10

7/16/10

10495

Canada

King

$190.00

4/7/10

5/30/10

10496

Canada

King

$1,380.60

4/7/10

6/1/10

10497

USA

Callahan

$575.00

4/11/10

4/30/10

10498

USA

Peacock

$1,412.00

4/16/10

6/20/10

10499

Canada

Suyama

$523.26

4/17/10

7/16/10

10500

Canada

Dodsworth

$149.00

4/16/10

4/30/10

10501

USA

Fuller

$816.30

4/29/10

6/30/10

10502

Canada

Suyama

$2,048.50

4/16/10

7/7/10

10503

USA

Peacock

$1,388.50

4/18/10

8/2/10

10504

USA

Leverling

$147.90

4/21/10

5/25/10

10505

Canada

Dodsworth

$415.80

5/2/10

5/29/10

10506

Canada

King

$749.06

4/22/10

8/12/10

10507

USA

Davolio

$240.00

5/13/10

9/6/10

10508

USA

Peacock

$136.80

4/29/10

7/4/10

10509

Canada

Suyama

$4,707.54

4/28/10

8/11/10

10510

USA

Peacock

$2,550.00

4/21/10

7/31/10

10511

Canada

King

$525.30

4/24/10

7/27/10

10512

Canada

King

$1,942.00

4/28/10

5/31/10

10513

USA

Leverling

$8,623.45

5/16/10

5/29/10

10514

USA

Fuller

$9,921.30

5/23/10

8/12/10

10515

USA

Fuller

$2,381.05

5/1/10

8/29/10

10516

USA

Leverling

$352.00

4/29/10

6/20/10

10517

USA

Peacock

$4,150.05

5/5/10

5/19/10

10518

Canada

Suyama

$2,314.20

5/1/10

6/22/10

10519

Canada

King

$200.00

5/1/10

7/18/10

10520

USA

Callahan

$225.50

5/2/10

8/25/10

10521

USA

Peacock

$2,318.24

5/6/10

8/18/10

10522

Canada

King

$2,444.31

5/30/10

7/17/10

10523

USA

Davolio

$3,192.65

5/7/10

8/13/10

10524

USA

Davolio

$818.40

5/23/10

8/28/10

10525

USA

Peacock

$1,151.40

5/15/10

6/16/10

10526

Canada

King

$1,503.00

5/7/10

5/23/10

10527

Canada

Suyama

$392.20

5/9/10

6/27/10

10528

Canada

Buchanan

$946.00

5/9/10

8/1/10

10529

USA

Leverling

$4,180.00

5/12/10

8/25/10

10530

Canada

King

$110.00

5/19/10

9/2/10

10531

Canada

King

$796.35

5/12/10

7/30/10

10532

USA

Callahan

$2,222.20

5/22/10

8/19/10

10533

USA

Callahan

$465.70

5/14/10

6/24/10

10534

USA

Peacock

$1,940.85

5/21/10

7/31/10

10535

USA

Leverling

$1,645.00

6/6/10

9/5/10

10536

USA

Davolio

$1,823.80

5/19/10

8/13/10

10537

Canada

Dodsworth

$139.80

5/16/10

7/23/10

10538

Canada

Suyama

$355.50

5/23/10

6/18/10

10539

USA

Leverling

$10,191.70

6/13/10

8/14/10

10540

USA

Fuller

$1,946.52

5/29/10

6/23/10

10541

USA

Davolio

$469.11

5/26/10

6/26/10

10542

USA

Callahan

$1,504.50

5/23/10

7/4/10

10543

USA

Peacock

$417.20

5/30/10

7/7/10

10544

USA

Callahan

$210.00

6/26/10

9/24/10

10545

USA

Davolio

$2,812.00

5/27/10

9/9/10

10546

USA

Leverling

$1,792.80

6/2/10

8/27/10

10547

USA

Leverling

$240.10

6/2/10

7/18/10

10548

Canada

Buchanan

$3,554.27

5/30/10

6/13/10

10549

Canada

King

$683.30

6/6/10

7/19/10

10550

USA

Peacock

$1,677.30

6/6/10

9/24/10

10551

USA

Fuller

$880.50

6/5/10

9/1/10

10552

USA

Fuller

$1,546.30

6/3/10

8/8/10

10553

USA

Peacock

$1,728.52

6/5/10

8/28/10

10554

Canada

Suyama

$2,944.40

6/4/10

8/17/10

10555

USA

Fuller

$835.20

6/13/10

8/10/10

10556

Canada

Dodsworth

$1,152.50

6/6/10

9/10/10

10557

USA

Davolio

$2,142.90

6/10/10

9/30/10

10558

Canada

Suyama

$520.41

6/13/10

7/19/10

10559

USA

Callahan

$1,072.42

6/9/10

8/3/10

10560

USA

Fuller

$2,844.50

6/9/10

9/25/10

10561

USA

Davolio

$488.70

6/12/10

7/27/10

10562

USA

Fuller

$965.00

6/24/10

9/3/10

10563

USA

Peacock

$1,234.05

6/16/10

9/5/10

10564

USA

Callahan

$639.90

6/18/10

7/20/10

10565

Canada

Dodsworth

$1,761.00

6/18/10

7/2/10

10566

USA

Davolio

$2,519.00

6/17/10

6/28/10

10567

USA

Leverling

$155.00

7/9/10

10/27/10

10568

Canada

Buchanan

$890.00

7/11/10

8/25/10

10569

USA

Leverling

$2,465.25

6/19/10

7/29/10

10570

USA

Callahan

$550.59

7/4/10

8/17/10

10571

USA

Leverling

$1,501.08

6/25/10

10/2/10

10572

Canada

King

$2,082.00

6/20/10

10/11/10

10573

USA

Peacock

$764.30

6/30/10

7/11/10

10574

Canada

Buchanan

$2,147.40

6/30/10

9/13/10

10575

USA

Leverling

$838.45

6/30/10

10/7/10

10576

Canada

Dodsworth

$569.00

6/30/10

7/21/10

10577

USA

Peacock

$477.00

7/25/10

9/29/10

10578

USA

Davolio

$317.75

7/4/10

9/27/10

10579

USA

Peacock

$1,013.74

7/1/10

7/19/10

10580

USA

Leverling

$310.00

7/2/10

9/2/10

10581

USA

Leverling

$330.00

7/14/10

9/26/10

10582

USA

Fuller

$2,237.50

7/4/10

8/7/10

10583

USA

Peacock

$593.75

7/4/10

8/29/10

10584

Canada

King

$142.50

7/10/10

11/4/10

10585

Canada

Dodsworth

$23.80

7/9/10

10/18/10

10586

USA

Davolio

$807.38

8/16/10

7/9/10

10587

USA

Fuller

$3,120.00

7/10/10

10/6/10

10588

USA

Callahan

$72.00

7/14/10

9/21/10

10589

USA

Peacock

$1,101.00

7/14/10

8/29/10

10590

USA

Davolio

$812.50

7/16/10

9/13/10

10591

USA

Leverling

$516.46

7/16/10

10/15/10

10592

Canada

King

$1,994.40

8/13/10

9/14/10

10593

USA

Leverling

$565.50

7/16/10

10/27/10

10594

USA

Fuller

$4,725.00

7/14/10

10/30/10

10595

USA

Callahan

$1,180.88

8/12/10

9/14/10

10596

Canada

King

$718.08

7/18/10

10/26/10

10597

USA

Davolio

$2,388.50

7/18/10

11/11/10

10598

Canada

Suyama

$493.00

7/21/10

10/19/10

10599

USA

Peacock

$479.80

7/21/10

10/22/10

10600

Canada

King

$2,285.00

7/22/10

10/5/10

10601

USA

Callahan

7/22/10

8/28/10

10602

USA

Callahan

$1,483.00

8/8/10

10/31/10

10603

USA

Davolio

$230.85

7/29/10

10/17/10

10604

USA

Davolio

$4,109.69

7/29/10

10/31/10

10605

USA

Peacock

$1,130.40

7/31/10

9/22/10

10606

Canada

Buchanan

$6,475.40

7/25/10

9/3/10

10607

USA

Peacock

$1,064.00

8/1/10

11/21/10

10608

Canada

King

$424.00

7/30/10

8/14/10

10609

USA

Callahan

$299.25

8/6/10

9/27/10

10610

Canada

Suyama

$808.00

8/1/10

8/30/10

10611

USA

Davolio

$6,375.00

8/1/10

11/25/10

10612

USA

Peacock

$353.20

8/1/10

8/31/10

10613

USA

Callahan

$464.00

8/1/10

11/10/10

10614

USA

Fuller

$120.00

8/6/10

11/4/10

10615

USA

Davolio

$4,806.99

8/5/10

11/1/10

10616

USA

Peacock

$1,402.50

8/4/10

11/25/10

10617

USA

Davolio

$2,697.50

8/8/10

10/29/10

10618

USA

Leverling

$1,260.00

8/7/10

11/15/10

10619

USA

Fuller

$57.50

8/14/10

10/11/10

10620

USA

Peacock

$758.50

8/11/10

8/30/10

10621

USA

Peacock

$560.00

8/11/10

11/13/10

10622

USA

Callahan

$1,336.95

8/12/10

11/5/10

10623

USA

Peacock

$1,393.24

8/19/10

10/19/10

10624

USA

Leverling

$479.75

8/14/10

11/6/10

10625

USA

Davolio

$1,503.60

8/20/10

10/11/10

10626

USA

Callahan

$1,185.75

8/21/10

10/18/10

10627

USA

Peacock

$450.00

8/20/10

10/17/10

10628

USA

Peacock

$2,775.05

8/20/10

9/17/10

10629

USA

Davolio

$903.60

8/19/10

9/14/10

10630

USA

Callahan

$55.80

8/15/10

9/25/10

10631

USA

Callahan

$589.00

8/19/10

11/17/10

10632

Canada

King

$5,510.59

8/18/10

9/25/10

10633

USA

Peacock

$4,985.50

8/21/10

9/17/10

10634

USA

Callahan

$1,326.22

8/21/10

10/15/10

10635

USA

Peacock

$629.50

8/26/10

9/12/10

10636

Canada

Suyama

$2,761.94

8/26/10

10/25/10

10637

USA

Leverling

$2,720.05

9/1/10

9/28/10

10638

Canada

King

$500.00

8/27/10

10/31/10

10639

USA

Peacock

$708.75

8/28/10

10/2/10

10640

USA

Peacock

$2,054.00

8/26/10

10/20/10

10641

Canada

King

$696.00

9/5/10

12/22/10

10642

Canada

Suyama

$814.50

9/2/10

11/10/10

10643

USA

Leverling

$1,371.80

9/1/10

9/14/10

10644

USA

Peacock

$1,535.00

9/2/10

11/14/10

10645

Canada

Dodsworth

$1,446.00

9/3/10

9/28/10

10646

USA

Peacock

$636.00

9/3/10

11/7/10

10647

Canada

Buchanan

$372.37

9/9/10

12/7/10

10648

Canada

Buchanan

$1,434.00

8/29/10

11/13/10

10649

Canada

Buchanan

$1,779.20

9/3/10

11/24/10

10650

USA

Callahan

$397.80

9/11/10

12/14/10

10651

USA

Peacock

$318.84

9/8/10

11/3/10

10652

USA

Davolio

$1,083.15

9/19/10

1/8/11

10653

Canada

Buchanan

$601.83

9/11/10

9/27/10

10654

USA

Davolio

$154.40

9/11/10

11/1/10

10655

Canada

Suyama

$604.21

9/10/10

10/25/10

10656

USA

Fuller

$4,371.60

9/15/10

12/31/10

10657

USA

Peacock

$4,464.60

9/8/10

10/15/10

10658

Canada

King

$1,227.02

9/10/10

12/21/10

10659

USA

Callahan

$1,701.00

10/15/10

1/29/11

10660

Canada

King

$562.60

9/15/10

10/5/10

10661

USA

Leverling

$125.00

9/18/10

12/29/10

10662

USA

Fuller

$1,930.40

10/3/10

12/20/10

10663

USA

Davolio

$1,288.39

9/19/10

10/12/10

10664

USA

Davolio

$1,295.00

9/17/10

12/16/10

10665

Canada

King

$4,666.94

9/22/10

10/21/10

10666

Canada

King

$1,536.80

9/19/10

12/24/10

10667

USA

Davolio

$625.27

9/23/10

10/8/10

10668

USA

Fuller

$570.00

9/22/10

10/17/10

10669

USA

Peacock

$2,301.75

9/18/10

12/26/10

10670

USA

Davolio

$920.10

9/24/10

10/11/10

10671

Canada

Dodsworth

$3,815.25

9/26/10

1/4/11

10672

USA

Fuller

$412.35

9/19/10

11/20/10

10673

USA

Peacock

$45.00

9/30/10

12/15/10

10674

Canada

Buchanan

$1,423.00

9/23/10

11/18/10

10675

USA

Fuller

$534.85

9/29/10

12/8/10

10676

USA

Davolio

$813.36

9/26/10

10/19/10

10677

Canada

King

$5,256.50

10/16/10

11/2/10

10678

USA

Callahan

$660.00

9/30/10

11/22/10

10679

USA

Davolio

$1,261.88

9/26/10

11/21/10

10680

USA

Leverling

$1,287.40

9/30/10

10/27/10

10681

USA

Leverling

$375.50

10/1/10

12/3/10

10682

USA

Fuller

$63.00

10/1/10

/

10683

USA

Leverling

$1,768.00

9/30/10

1/3/11

10684

USA

Peacock

$801.10

10/3/10

1/20/11

10685

USA

Fuller

$1,404.45

10/8/10

12/1/10

10686

Canada

Dodsworth

$4,960.90

10/30/10

11/27/10

10687

USA

Peacock

$3,160.60

10/7/10

10/26/10

10688

USA

Davolio

$472.50

10/7/10

1/2/11

10689

USA

Davolio

$862.50

10/3/10

1/11/11

10690

USA

Fuller

$10,164.80

10/22/10

1/11/11

10691

USA

Peacock

$878.00

10/13/10

12/10/10

10692

USA

Leverling

$2,071.20

10/10/10

1/25/11

10693

USA

Callahan

$4,825.00

10/9/10

12/21/10

10694

Canada

King

$642.00

10/14/10

12/10/10

10695

USA

Callahan

$996.00

10/14/10

1/2/11

10696

USA

Leverling

$805.43

10/14/10

10/26/10

10697

USA

Peacock

$3,436.45

10/17/10

2/4/11

10698

USA

Leverling

$114.00

10/13/10

10/25/10

10699

USA

Leverling

$1,638.40

10/16/10

1/11/11

10700

Canada

Suyama

$2,864.50

10/15/10

12/29/10

10701

USA

Peacock

$330.00

10/21/10

12/20/10

10702

Canada

Suyama

$2,545.00

10/20/10

1/19/11

10703

Canada

Suyama

$595.50

11/7/10

1/14/11

10704

Canada

Dodsworth

$378.00

11/18/10

12/10/10

10705

USA

Callahan

$1,893.00

10/21/10

12/30/10

10706

USA

Peacock

$1,641.00

10/23/10

1/26/11

10707

Canada

Suyama

$180.40

11/5/10

12/1/10

10708

USA

Davolio

$3,424.00

11/20/10

2/7/11

10709

USA

Davolio

$93.50

10/23/10

11/12/10

10710

Canada

Buchanan

$4,451.70

10/29/10

12/8/10

10711

USA

Leverling

$1,233.48

10/31/10

12/12/10

10712

USA

Davolio

$2,827.90

10/24/10

2/21/11

10713

Canada

Buchanan

$2,205.75

10/27/10

1/14/11

10714

USA

Leverling

$1,296.00

10/29/10

2/18/11

10715

USA

Peacock

$706.00

10/27/10

2/11/11

10716

USA

Davolio

$1,270.75

10/29/10

1/28/11

10717

USA

Davolio

$3,463.00

10/29/10

12/11/10

10718

USA

Callahan

$844.25

11/5/10

2/5/11

10719

USA

Callahan

$550.00

11/5/10

11/30/10

10720

Canada

Buchanan

$923.87

10/31/10

1/11/11

10721

USA

Callahan

$1,570.00

11/4/10

12/20/10

10722

USA

Leverling

$468.45

11/25/10

12/28/10

10723

USA

Callahan

$638.50

11/5/10

12/22/10

10724

USA

Peacock

$287.80

11/5/10

2/14/11

10725

USA

Peacock

$655.00

12/5/10

1/21/11

10726

USA

Fuller

$1,624.50

12/5/10

3/5/11

10727

USA

Peacock

$1,296.75

11/11/10

1/20/11

10728

USA

Callahan

$1,850.00

11/14/10

1/25/11

10729

Canada

Buchanan

$484.25

11/14/10

3/12/11

10730

Canada

King

$1,890.50

11/14/10

11/26/10

10731

USA

Leverling

$360.00

11/7/10

12/29/10

10732

USA

Davolio

$1,459.00

11/10/10

/

10733

USA

Fuller

$1,498.35

11/12/10

1/6/11

10734

Canada

Suyama

$536.40

11/21/10

12/5/10

10735

Canada

Dodsworth

$997.00

11/21/10

3/19/11

10736

USA

Fuller

$139.80

11/18/10

2/7/11

10737

USA

Fuller

$52.35

11/18/10

3/9/11

10738

USA

Leverling

$240.00

11/17/10

12/12/10

10739

USA

Peacock

$1,416.00

11/25/10

12/9/10

10740

USA

Peacock

$228.00

11/18/10

12/11/10

10741

USA

Leverling

$3,118.00

11/18/10

2/13/11

10742

USA

Davolio

$319.20

11/21/10

1/8/11

10743

Canada

Suyama

$736.00

11/24/10

2/12/11

10744

Canada

Dodsworth

$4,529.80

11/27/10

1/26/11

10745

USA

Davolio

$2,311.70

11/21/10

2/10/11

10746

Canada

Suyama

$1,912.85

11/26/10

3/23/11

10747

USA

Leverling

$2,196.00

11/28/10

12/12/10

10748

USA

Peacock

$1,080.00

12/19/10

3/31/11

10749

Canada

Dodsworth

$1,590.56

11/24/10

1/7/11

10750

USA

Leverling

$1,631.48

12/3/10

12/30/10

10751

USA

Fuller

$252.00

11/28/10

1/4/11

10752

USA

Leverling

$88.00

11/27/10

3/25/11

10753

Canada

Suyama

$55.20

11/27/10

12/15/10

10754

USA

Peacock

$1,948.50

11/28/10

2/15/11

10755

USA

Callahan

$1,990.00

12/2/10

3/25/11

10756

Canada

Suyama

$3,082.00

12/15/10

3/21/11

10757

USA

Leverling

$1,644.60

12/4/10

3/30/11

10758

USA

Leverling

$320.00

12/12/10

2/16/11

10759

USA

Peacock

$2,917.00

12/10/10

2/12/11

10760

Canada

Buchanan

$507.00

12/8/10

12/21/10

10761

USA

Leverling

$4,337.00

12/9/10

2/6/11

10762

USA

Leverling

$616.00

12/8/10

2/12/11

10763

Canada

Suyama

$2,286.00

12/8/10

2/9/11

10764

USA

Leverling

$1,515.60

12/9/10

4/7/11

10765

USA

Peacock

$2,310.00

12/9/10

3/9/11

10766

USA

Peacock

$28.00

12/15/10

3/26/11

10767

USA

Leverling

$1,477.00

12/15/10

2/15/11

10768

USA

Leverling

$1,684.27

12/12/10

12/24/10

10769

USA

Callahan

$236.25

12/17/10

1/6/11

10770

Canada

Dodsworth

$344.00

1/2/10

1/25/10

10771

USA

Leverling

$3,603.22

12/19/10

1/15/11

10772

USA

Davolio

$2,030.40

12/16/10

3/11/11

10773

USA

Peacock

$868.75

12/12/10

1/2/11

10774

Canada

King

$228.00

12/26/10

4/6/11

10775

USA

Davolio

$6,635.27

12/18/10

4/1/11

10776

Canada

King

$224.00

1/21/11

2/6/11

10777

USA

Leverling

$96.50

12/24/10

3/9/11

10778

USA

Leverling

$1,335.00

4/20/11

10779

USA

Fuller

$720.00

12/25/10

2/22/11

10780

USA

Fuller

$975.88

12/19/10

1/11/11

10781

Canada

Dodsworth

$12.50

12/22/10

4/2/11

10782

USA

Peacock

$1,442.50

12/19/10

3/5/11

10783

USA

Peacock

$1,488.00

12/22/10

2/11/11

10784

USA

Davolio

$387.50

12/24/10

1/24/11

10785

USA

Callahan

$1,531.08

12/23/10

4/2/11

10786

USA

Fuller

$2,622.76

12/26/10

3/27/11

10787

USA

Davolio

$731.50

1/19/11

4/13/11

10788

USA

Davolio

$3,687.00

12/31/10

1/19/11

10789

Canada

Suyama

$722.50

12/26/10

2/22/11

10790

Canada

Suyama

$1,829.76

1/1/11

4/21/11

10791

USA

Davolio

$399.85

12/31/10

4/14/11

10792

USA

Leverling

$191.10

1/8/11

2/3/11

10793

Canada

Suyama

$314.76

1/2/11

2/24/11

10794

USA

Callahan

$2,158.00

1/20/11

2/7/11

10795

USA

Leverling

$2,341.36

1/14/11

4/19/11

10796

Canada

King

$420.00

1/5/11

1/23/11

10797

USA

Fuller

$446.60

1/5/11

3/29/11

10798

Canada

Dodsworth

$1,553.50

1/5/11

3/9/11

10799

USA

Davolio

$1,468.93

1/5/11

3/9/11

10800

USA

Peacock

$3,026.85

12/31/10

4/27/11

10801

USA

Peacock

$2,942.81

1/2/11

3/16/11

10802

USA

Peacock

$1,193.01

1/6/11

4/22/11

10803

Canada

Suyama

$2,278.40

1/7/11

3/30/11

10804

USA

Fuller

$2,775.00

1/9/11

1/23/11

10805

USA

Leverling

$439.60

1/5/11

3/24/11

10806

USA

Peacock

$18.40

1/30/11

5/11/11

10807

USA

Fuller

$1,411.00

1/9/11

2/7/11

10808

Canada

King

$140.00

1/7/11

2/25/11

10809

USA

Fuller

$187.00

1/7/11

2/17/11

10810

USA

Callahan

$852.00

1/8/11

3/13/11

10811

Canada

Buchanan

$1,692.80

1/12/11

4/17/11

10812

USA

Davolio

$602.40

1/9/11

1/30/11

10813

USA

Leverling

$1,788.45

1/14/11

4/23/11

10814

USA

Fuller

$40.00

1/14/11

4/13/11

10815

USA

Peacock

$8,446.45

2/4/11

2/17/11

10816

USA

Leverling

$10,952.84

1/13/11

2/13/11

10817

Canada

King

$833.00

1/12/11

3/4/11

10818

USA

Fuller

$477.00

1/16/11

4/10/11

10819

USA

Leverling

$1,140.00

1/13/11

4/12/11

10820

USA

Davolio

$678.00

1/15/11

2/10/11

10821

Canada

Suyama

$237.90

1/16/11

2/23/11

10822

Canada

Buchanan

$2,826.00

1/13/11

4/28/11

10823

USA

Callahan

$250.80

1/30/11

3/8/11

10824

USA

Davolio

$1,030.76

1/14/11

3/11/11

10825

Canada

Suyama

2/6/11

3/23/11

10826

USA

Davolio

$843.00

2/6/11

3/3/11

10827

Canada

Dodsworth

$932.00

2/4/11

4/23/11

10828

Canada

Dodsworth

$1,764.00

1/23/11

5/11/11

10829

USA

Peacock

$1,974.00

1/21/11

4/17/11

10830

USA

Leverling

$2,684.40

1/23/11

3/12/11

10831

USA

Fuller

$475.11

1/19/11

4/6/11

10832

Canada

Suyama

$906.93

1/23/11

4/9/11

10833

USA

Davolio

$1,432.71

1/19/11

3/11/11

10834

USA

Davolio

$845.80

1/21/11

4/24/11

10835

Canada

King

$4,705.50

1/21/11

4/26/11

10836

Canada

Dodsworth

$1,064.50

1/23/11

2/21/11

10837

USA

Leverling

$1,938.38

1/23/11

4/7/11

10838

USA

Leverling

$827.55

1/22/11

3/5/11

10839

USA

Peacock

$211.20

2/16/11

6/2/11

10840

Canada

Buchanan

$4,581.00

/

2/15/11

10841

USA

Davolio

$975.00

1/29/11

5/4/11

10842

USA

Peacock

$159.00

1/26/11

5/9/11

10843

USA

Callahan

$735.00

1/26/11

3/11/11

10844

USA

Callahan

$3,812.70

1/30/11

3/15/11

10845

USA

Fuller

$1,112.00

1/23/11

3/15/11

10846

USA

Peacock

$4,931.92

2/10/11

4/1/11

10847

Canada

King

$931.50

1/29/11

3/1/11

10848

Canada

Dodsworth

$967.82

1/30/11

3/10/11

10849

USA

Davolio

$629.00

1/30/11

3/18/11

10850

Canada

Buchanan

$2,603.00

2/2/11

4/5/11

10851

USA

Callahan

$2,984.00

1/30/11

2/20/11

10852

Canada

Dodsworth

$625.00

2/3/11

5/26/11

10853

USA

Leverling

$2,966.50

2/5/11

3/18/11

10854

USA

Leverling

$2,227.89

2/4/11

2/16/11

10855

USA

Leverling

$660.00

2/10/11

5/28/11

10856

USA

Callahan

$2,048.22

2/6/11

5/19/11

10857

USA

Fuller

$649.00

2/3/11

5/18/11

10858

USA

Davolio

$1,078.69

2/2/11

5/25/11

10859

USA

Leverling

$519.00

2/4/11

2/15/11

10860

USA

Peacock

$3,523.40

2/17/11

3/21/11

10861

USA

Callahan

$581.00

2/2/11

3/2/11

10862

USA

Peacock

$441.15

2/17/11

5/28/11

10863

USA

Peacock

$282.00

2/9/11

3/19/11

10864

USA

Fuller

$12,387.50

2/12/11

3/5/11

10865

Canada

Buchanan

$1,096.20

2/12/11

5/28/11

10866

Canada

Suyama

$98.40

2/11/11

3/21/11

10867

Canada

King

$1,920.60

2/23/11

4/8/11

10868

Canada

Buchanan

$1,630.00

2/9/11

5/31/11

10869

Canada

Buchanan

$160.00

2/13/11

5/6/11

10870

Canada

Dodsworth

$1,979.23

2/10/11

5/25/11

10871

Canada

Buchanan

$2,058.46

2/9/11

5/8/11

10872

USA

Peacock

$336.80

2/9/11

6/6/11

10873

Canada

Buchanan

$310.00

2/11/11

4/22/11

10874

USA

Peacock

$709.55

3/3/11

4/11/11

10875

Canada

King

$917.00

2/12/11

3/8/11

10876

USA

Davolio

$1,955.13

2/19/11

4/13/11

10877

USA

Peacock

$1,539.00

2/12/11

3/3/11

10878

USA

Leverling

$611.30

2/12/11

4/1/11

10879

Canada

King

$1,500.00

2/18/11

5/27/11

10880

USA

Peacock

$150.00

2/18/11

5/4/11

10881

USA

Peacock

$892.64

2/20/11

4/14/11

10882

USA

Callahan

$36.00

2/20/11

6/11/11

10883

USA

Peacock

$1,378.07

2/13/11

3/25/11

10884

Canada

Suyama

$1,209.00

2/18/11

3/22/11

10885

USA

Davolio

$3,127.50

3/2/11

5/1/11

10886

USA

Callahan

$70.00

2/16/11

3/27/11

10887

USA

Davolio

$605.00

2/23/11

6/3/11

10888

Canada

Dodsworth

$11,380.00

2/23/11

5/2/11

10889

Canada

King

$860.10

2/18/11

4/24/11

10890

Canada

King

$368.93

2/19/11

4/21/11

10891

USA

Peacock

$2,090.00

2/19/11

4/4/11

10892

Canada

Dodsworth

$5,502.11

2/20/11

4/14/11

10893

USA

Davolio

$2,753.10

2/20/11

4/25/11

10894

USA

Leverling

$6,379.40

2/23/11

3/19/11

10895

Canada

King

$750.50

2/27/11

5/28/11

10896

USA

Leverling

$10,835.24

2/25/11

4/2/11

10897

USA

Peacock

$30.00

3/6/11

6/30/11

10898

Canada

Buchanan

$122.40

2/26/11

3/21/11

10899

USA

Davolio

$33.75

3/4/11

3/20/11

10900

USA

Peacock

$934.50

2/26/11

3/25/11

10901

USA

Davolio

$863.43

3/3/11

3/16/11

10902

USA

Leverling

$932.05

3/4/11

4/20/11

10903

USA

Leverling

$1,924.25

2/27/11

4/1/11

10904

Canada

Dodsworth

$342.00

3/6/11

5/15/11

10905

USA

Peacock

$427.50

3/3/11

6/9/11

10906

Canada

Suyama

$108.50

2/27/11

4/27/11

10907

USA

Peacock

$663.10

3/6/11

4/29/11

10908

USA

Davolio

$670.00

3/10/11

4/3/11

10909

USA

Davolio

$452.90

3/4/11

5/8/11

10910

USA

Leverling

$858.00

3/5/11

4/29/11

10911

USA

Fuller

$6,200.55

3/18/11

4/5/11

10912

USA

Peacock

$768.75

3/4/11

6/27/11

10913

Canada

Suyama

$537.50

3/2/11

4/4/11

10914

USA

Fuller

$539.50

3/2/11

4/26/11

10915

USA

Davolio

$686.70

3/9/11

6/26/11

10916

USA

Peacock

$365.89

3/11/11

4/27/11

10917

USA

Leverling

$1,447.50

3/11/11

4/17/11

10918

USA

Fuller

$1,122.80

3/4/11

4/26/11

10919

USA

Peacock

$390.00

3/9/11

6/19/11

10920

USA

Davolio

$1,936.00

3/9/11

3/26/11

10921

Canada

Buchanan

$742.50

3/5/11

6/11/11

10922

Canada

King

$748.80

3/13/11

4/15/11

10923

USA

Leverling

$1,835.70

4/8/11

5/31/11

10924

USA

Leverling

$475.15

3/13/11

6/21/11

10925

USA

Peacock

$514.40

3/11/11

5/22/11

10926

USA

Peacock

$800.00

4/8/11

4/30/11

10927

USA

Davolio

$137.50

3/18/11

4/13/11

10928

Canada

Suyama

$1,174.75

3/12/11

5/9/11

10929

USA

Peacock

$2,255.50

3/18/11

4/17/11

10930

USA

Peacock

$799.20

3/19/11

7/7/11

10931

USA

Callahan

$1,788.63

3/24/11

5/28/11

10932

Canada

Suyama

$920.60

3/16/11

4/9/11

10933

USA

Leverling

$500.00

3/12/11

4/2/11

10934

USA

Peacock

$619.50

3/18/11

4/10/11

10935

USA

Leverling

$456.00

3/18/11

5/30/11

10936

Canada

King

$644.80

3/13/11

7/6/11

10937

USA

Leverling

$2,731.87

3/16/11

5/9/11

10938

USA

Fuller

$637.50

3/13/11

5/28/11

10939

USA

Callahan

$360.00

3/23/11

6/4/11

10940

Canada

King

$4,011.75

3/20/11

5/11/11

10941

Canada

Dodsworth

$560.00

3/18/11

5/27/11

10942

USA

Peacock

$711.00

3/19/11

5/7/11

10943

Canada

Suyama

$1,025.33

3/13/11

5/24/11

10944

USA

Peacock

$245.00

3/18/11

5/1/11

10945

USA

Davolio

$1,407.50

3/19/11

5/6/11

10946

USA

Leverling

$220.00

3/16/11

6/12/11

10947

USA

Leverling

$2,362.25

3/19/11

4/11/11

10948

USA

Fuller

$4,422.00

3/17/11

6/4/11

10949

USA

Davolio

$110.00

3/23/11

5/4/11

10950

Canada

Dodsworth

$458.74

4/7/11

7/5/11

10951

USA

Davolio

$471.20

3/24/11

6/13/11

10952

Canada

Dodsworth

$4,441.25

3/25/11

5/28/11

10953

Canada

Buchanan

$1,659.53

3/20/11

7/10/11

10954

USA

Callahan

$74.40

3/20/11

4/27/11

10955

Canada

Suyama

$677.00

3/20/11

6/11/11

10956

USA

Callahan

$1,762.70

3/27/11

5/2/11

10957

Canada

King

$781.00

3/27/11

6/3/11

10958

Canada

Suyama

$131.75

3/23/11

6/12/11

10959

USA

Leverling

$265.35

4/8/11

5/15/11

10960

USA

Callahan

$1,119.90

3/30/11

7/1/11

10961

USA

Callahan

$3,584.00

3/23/11

6/21/11

10962

Canada

Dodsworth

$57.80

3/26/11

7/21/11

10963

USA

Leverling

$2,052.50

3/24/11

5/12/11

10964

Canada

Suyama

$848.00

3/30/11

6/1/11

10965

USA

Peacock

$1,098.46

4/8/11

4/22/11

10966

USA

Fuller

$910.40

4/2/11

6/17/11

10967

USA

Davolio

$1,408.00

4/1/11

7/25/11

10968

USA

Davolio

$108.00

3/30/11

7/2/11

10969

Canada

Dodsworth

$224.00

4/24/11

5/28/11

10970

USA

Fuller

$1,733.06

4/2/11

7/22/11

10971

USA

Peacock

$251.50

3/26/11

4/19/11

10972

Canada

Suyama

$291.55

3/27/11

5/7/11

10973

USA

Leverling

$439.00

4/3/11

5/3/11

10974

USA

Davolio

$717.50

3/27/11

7/12/11

10975

USA

Davolio

$912.00

4/3/11

5/22/11

10976

USA

Callahan

$2,233.00

4/10/11

5/12/11

10977

Canada

Dodsworth

$1,303.19

4/23/11

5/20/11

10978

USA

Callahan

$4,813.50

3/31/11

5/31/11

10979

USA

Peacock

$248.00

4/17/11

5/19/11

10980

USA

Davolio

$11,810.00

4/2/11

5/28/11

10981

USA

Fuller

$1,014.00

4/8/11

5/22/11

10982

USA

Fuller

$720.90

4/6/11

6/28/11

10983

USA

Davolio

$1,809.75

4/3/11

7/21/11

10984

USA

Fuller

$2,023.38

4/2/11

6/26/11

10985

USA

Callahan

$2,220.00

4/21/11

7/30/11

10986

USA

Callahan

$2,772.00

4/6/11

4/28/11

10987

USA

Leverling

$3,574.80

4/10/11

4/21/11

10988

USA

Fuller

$1,353.60

4/2/11

7/1/11

10989

USA

Fuller

$4,288.85

4/7/11

7/5/11

10990

USA

Davolio

$2,296.00

4/7/11

6/7/11

10991

USA

Davolio

$69.60

4/3/11

4/23/11

10992

Canada

King

$4,895.44

4/10/11

4/23/11

10993

USA

Fuller

$940.50

4/9/11

5/11/11

10994

USA

$1,196.00

4/6/11

4/17/11

10995

USA

Peacock

$560.00

4/10/11

5/22/11

10996

USA

Callahan

$1,885.00

4/13/11

7/16/11

10997

USA

Callahan

$686.00

4/17/11

7/23/11

10998

Canada

Suyama

$1,197.95

4/10/11

6/24/11

10999

USA

Fuller

$903.75

4/14/11

6/23/11

11000

USA

Fuller

$2,769.00

4/14/11

6/27/11

11001

USA

Peacock

$1,811.10

4/16/11

7/17/11

11002

USA

Leverling

$326.00

4/8/11

5/15/11

11003

USA

Leverling

$295.38

4/20/11

5/26/11

11004

USA

Fuller

$586.00

4/10/11

4/22/11

11005

USA

Leverling

$329.69

4/15/11

5/23/11

11006

USA

Callahan

$2,633.90

4/13/11

5/22/11

11007

USA

Fuller

$616.50

4/10/11

6/5/11

11009

USA

Fuller

$645.00

4/21/11

7/6/11

11010

USA

Leverling

$933.50

4/13/11

7/30/11

11011

USA

Davolio

$2,825.30

4/17/11

5/27/11

11012

USA

Fuller

$361.00

4/10/11

4/24/11

11013

USA

Fuller

$243.18

4/15/11

7/25/11

11014

USA

Fuller

$622.35

4/20/11

7/2/11

11015

Canada

Dodsworth

$491.50

4/13/11

4/30/11

11016

Canada

Dodsworth

$6,750.00

4/20/11

8/9/11

11017

USA

Peacock

$1,575.00

4/16/11

6/13/11

11018

USA

Fuller

$632.40

4/16/11

8/1/11

11020

USA

Leverling

$6,306.24

4/21/11

7/21/11

11021

USA

Davolio

$1,500.00

4/24/11

7/5/11

11023

USA

Peacock

$1,966.81

4/20/11

6/18/11

11024

Canada

$270.00

4/24/11

7/9/11

11025

USA

Peacock

$1,030.00

4/28/11

8/20/11

11026

USA

Davolio

$877.72

4/20/11

7/26/11

11027

USA

Fuller

$2,160.00

4/22/11

8/13/11

11028

USA

Peacock

$1,286.80

4/27/11

7/8/11

11029

Canada

King

$12,615.05

4/27/11

6/28/11

11030

Canada

Suyama

$2,393.50

4/24/11

5/6/11

11031

USA

Fuller

$8,902.50

4/23/11

8/7/11

11032

Canada

King

$3,232.80

4/23/11

6/9/11

11033

USA

Callahan

$539.40

4/27/11

6/20/11

11034

USA

Fuller

$1,754.50

4/24/11

5/30/11

11035

USA

Callahan

$1,692.00

4/22/11

6/3/11

11036

Canada

King

$60.00

4/27/11

5/7/11

11037

USA

Davolio

$732.60

4/30/11

6/2/11

11038

USA

Leverling

$1,773.00

4/28/11

8/14/11

11041

USA

Fuller

$405.75

5/1/11

7/30/11

11042

Canada

Buchanan

210

4/29/11

7/3/11

11043

USA

Peacock

591.6

5/1/11

8/19/11

11044

USA

Callahan

1485.8

4/24/11

8/5/11

11046

Canada

King

817.87

5/1/11

6/2/11

11047

Canada

King

525

4/30/11

6/26/11

11048

USA

Leverling

1332

5/1/11

8/24/11

11052

USA

Fuller

3055

4/29/11

5/27/11

11053

USA

Callahan

3740

5/1/11

6/13/11

11056

USA

Leverling

45

5/1/11

7/25/11

11057

&F: &A

Pivot Tables As a Business Analyst you have extracted this data from the sales order module of a client’s accounting system. You added field names in row #1 and formatted them to just to make it a little easier to read. You recall back from that most wonderful BUSN 6251 course that the first step in any data analysis process is to understand the data and make sure that the data has no errors. After you do clean up the data, you will run a series of pivot tables to tell a story behind the data. In this spreadsheet 1. Freeze the first row with the field names – this is just to make it easier to work with. 2. Also remember that big problem with dates, so you need to format the two columns with dates into an acceptable format.

Explore the data and in the text box in your spreadsheet describe in 1 or 2 sentences what the data is about. In your description make sure you describe the number of data pieces (rows), the date ranges, and any other information that helps with the background of the story. ANSWER:

Note: The only field that will not have any errors is the field that is automatically generated by the accounting system and that is the field called Order ID. Now you are ready to start the Analysis of the data. Your analysis is going to be presented to the client, so your tables and charts must be “Client Ready".

Question 1: Is there a difference in sales between countries? – need a table, a chart and one or two sentences explaining what you found. Put the table and chart beside this text box and put your description below: ANSWER:

Clean data using Auto filters. Look for odd answers like blanks, typos, weird answers, etc. When you find the odd records or rows of data a) copy the row into the Table below and b) then delete the row entirely that had the invalid data

Question 2: Is there a difference in sales between Salespersons? – need a table, a chart and one or two sentences explaining what you found. Put the table and chart beside this text box and put your description below: ANSWER

Question 3: You need to calculate the bonuses for all the sales staff. The bonus structure of the company is such that it is divided into 3 categories (Top, Middle & Bottom,) so you first need to create a table that sums up the total sales by salesperson. Then, using this table, calculate the lower and upper limits of the three groups. The bottom performers get $0 bonus, the middle performers get a $5,000 bonus, and the top performers get a $10,000 bonus. Then you can use a VLookup (best way or you could do it manually as there are only 9 salespersons, but you will get less marks!) to assign the applicable bonus to each of the individual salespersons. Put the tables beside this text box. Make sure your answer is clear:

Question 4: Which staff are most efficient in collecting their accounts receivable and who needs help? The order data is the date the order was taken and the sale data is the date the order was paid for – so you will need to find the number of outstanding days for each order. For each salesperson, find their % of their total sales that were collected in 30 days or less, 60 days or less, and greater than 60 days – need a table, a chart and one or two sentences explaining what you found. Put the tables beside this text box. Make sure your answer is clear: