Employees_Report_Nishka.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M
1	U.C Davis (923230753)
2
3
4	PLS 21 Associate Sales Employees Report
5	Shipping	UC Davis
6	Address	1 Shields Ave.
7		Davis, CA 95616
8
9	Sales	$0	$50	$60	$80	$125	$150
10	Commission & Bonus	$3.00	$9.00	$11.00	$13.00	$26.00	$51.00
11
12
13			Quarterly Sales (in thousands)				Total		Commision &	Total	Date	Years	Training
14	Employee		First	Second	Third	Fourth	Sales	Salary	Bonus	Salary	Hired	W/Firm	Required?
15	Katarina Kent		$27.93	$24.70	$11.17	$17.79	$81.59	$36.70	$13.00	$49.70	28-Jan-15	10.90	YES
16	Brandon Huynh		$22.18	$14.34	$32.54	$14.22	$83.28	$36.77	$13.00	$49.77	27-May-98	27.58	YES
17	Adina Boyce		$42.03	$15.23	$30.50	$20.81	$108.57	$36.83	$13.00	$49.83	2-Jul-05	20.48	NO
18	Neil Patel		$23.67	$12.50	$12.87	$15.04	$64.08	$38.17	$11.00	$49.17	15-Dec-17	8.01	YES
19	Kellie Wong		$15.24	$40.41	$15.90	$19.12	$90.67	$38.23	$13.00	$51.23	29-Jun-09	16.48	YES
20	Olivia Avaiusini		$36.06	$42.17	$19.78	$30.41	$128.42	$85.12	$26.00	$111.12	18-Jun-14	11.51	NO
21	Matthew Low		$38.29	$26.52	$21.12	$20.65	$106.58	$37.29	$13.00	$50.29	19-Mar-11	14.76	NO
22	Riya Kotak		$14.87	$34.49	$52.87	$33.33	$135.56	$53.11	$26.00	$79.11	7-Nov-90	35.14	NO
23	Liyuan Yang		$8.94	$10.50	$12.47	$18.50	$50.41	$39.98	$9.00	$48.98	20-Apr-94	31.68	YES
24	Camila Gutierrez		$33.12	$26.67	$38.52	$26.51	$124.82	$40.02	$13.00	$53.02	1-May-03	22.65	NO
25	Alejandro Munoz		$45.02	$55.76	$40.21	$22.56	$163.55	$53.25	$51.00	$104.25	14-Aug-20	5.35	NO
26	Ethan Frehner		$13.00	$33.59	$45.20	$15.40	$107.19	$42.98	$13.00	$55.98	18-Aug-02	23.35	NO
27	Xiaolu Zhang		$40.24	$28.45	$10.76	$22.67	$102.12	$43.02	$13.00	$56.02	23-Apr-09	16.67	NO
28			PLS 21 Average Total Sales				$103.60
29
30	Comments
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100