ASSIGNMENT.xlsx

	A	B	C	D	E	F	G	H	I
1	Employee ID	Name	Hourly Wage	Hours Worked	Taxable Income	Taxes to Be Paid	Tax Rate:	0.07	Hello
2	1	Julia	$14.25	158	$ 2,251.50	$ 157.61
3	2	James	$15.50	160	$ 2,480.00	$ 173.60
4	3	Amelia	$16.00	125	$ 2,000.00	$ 140.00
5	4	Freddy	$13.75	165	$ 2,268.75	$ 158.81
6	5	Jeff	$15.50	144	$ 2,232.00	$ 156.24
7	6	Jefferson	$17.00	174	$ 2,958.00	$ 207.06
8	7	Clifford	$13.75	161	$ 2,213.75	$ 154.96
9	8	Janay	$15.50	69	$ 1,069.50	$ 74.87
10	9	Tanisha	$10.75	85	$ 913.75	$ 63.96
11	10	Tre	$15.50	117	$ 1,813.50	$ 126.95
12	11	Ariana	$12.00	160	$ 1,920.00	$ 134.40
13	12	Marisela	$15.50	152	$ 2,356.00	$ 164.92
14	13	Adrienne	$11.75	129	$ 1,515.75	$ 106.10
15	14	Keegan	$12.00	74	$ 888.00	$ 62.16
16	15	Nestor	$19.00	111	$ 2,109.00	$ 147.63
17	16	Mari	$17.00	132	$ 2,244.00	$ 157.08
18	17	Jerod	$19.00	168	$ 3,192.00	$ 223.44
19	18	Graciela	$16.00	187	$ 2,992.00	$ 209.44
20	19	Kenan	$18.00	70	$ 1,260.00	$ 88.20
21	20	Andrea	$16.50	138	$ 2,277.00	$ 159.39
22	21	Kolton	$13.00	72	$ 936.00	$ 65.52
23	22	Dangelo	$12.00	130	$ 1,560.00	$ 109.20
24	23	Louis	$18.00	208	$ 3,744.00	$ 262.08
25	24	Kerry	$22.00	97	$ 2,134.00	$ 149.38
26	25	Anne	$32.00	199	$ 6,368.00	$ 445.76
27	26	Dangelo	$11.00	160	$ 1,760.00	$ 123.20
28	27	Keisha	$14.00	156	$ 2,184.00	$ 152.88
29	28	Dymond	$15.50	117	$ 1,813.50	$ 126.95
30	29	Ingrid	$15.00	76	$ 1,140.00	$ 79.80
31	30	Jaime	$12.00	175	$ 2,100.00	$ 147.00
32	31	Lilly	$15.50	87	$ 1,348.50	$ 94.40
33	32	Rogelio	$11.75	130	$ 1,527.50	$ 106.93
34	33	Joshua	$12.00	185	$ 2,220.00	$ 155.40
35	34	Lindsay	$19.00	152	$ 2,888.00	$ 202.16
36	35	Audra	$17.00	186	$ 3,162.00	$ 221.34
37	36	Aubrie	$19.00	96	$ 1,824.00	$ 127.68
38	37	Pranav	$16.00	100	$ 1,600.00	$ 112.00
39	38	Jordyn	$18.00	124	$ 2,232.00	$ 156.24
40	39	Macie	$15.50	71	$ 1,100.50	$ 77.04
41	40	Glen	$14.00	83	$ 1,162.00	$ 81.34
42	41	Zayne	$12.00	168	$ 2,016.00	$ 141.12
43	42	Samuel	$11.00	165	$ 1,815.00	$ 127.05
44	43	Ester	$12.00	145	$ 1,740.00	$ 121.80
45	44	Leandra	$15.50	133	$ 2,061.50	$ 144.31
46	45	Emma	$11.75	92	$ 1,081.00	$ 75.67
47	46	Efrain	$12.00	74	$ 888.00	$ 62.16
48	47	Phillip	$19.00	201	$ 3,819.00	$ 267.33
49	48	Judah	$17.00	112	$ 1,904.00	$ 133.28
50	49	Keaton	$19.00	166	$ 3,154.00	$ 220.78
51	50	Kavon	$16.00	160	$ 2,560.00	$ 179.20
52	51	Allan	$18.00	117	$ 2,106.00	$ 147.42
53	52	Jacinda	$11.50	152	$ 1,748.00	$ 122.36
54	53	Caden	$15.50	129	$ 1,999.50	$ 139.97
55	54	Tanya	$15.50	74	$ 1,147.00	$ 80.29
56	55	Rosalinda	$12.00	111	$ 1,332.00	$ 93.24
57	56	Raekwon	$15.50	132	$ 2,046.00	$ 143.22
58	57	Jude	$11.75	168	$ 1,974.00	$ 138.18
59	58	Dante	$12.00	187	$ 2,244.00	$ 157.08
60	59	Jayden	$19.00	70	$ 1,330.00	$ 93.10
61	60	Tianna	$17.00	138	$ 2,346.00	$ 164.22
62	61	Dean Ling	$19.00	72	$ 1,368.00	$ 95.76
63	62	Danae	$16.00	130	$ 2,080.00	$ 145.60
64	63	Alvaro	$18.00	208	$ 3,744.00	$ 262.08
65	64	Jayce	$11.00	97	$ 1,067.00	$ 74.69
66	65	Tanner	$15.50	199	$ 3,084.50	$ 215.92
67	66	Derek	$11.00	160	$ 1,760.00	$ 123.20
68	67	Ellie	$12.00	156	$ 1,872.00	$ 131.04
69	68	Alek	$15.50	117	$ 1,813.50	$ 126.95
70	69	Riya	$11.00	76	$ 836.00	$ 58.52
71	70	Cortney	$12.00	175	$ 2,100.00	$ 147.00
72			Totals:	9367	$ 142,794.50	$ 9,995.62
73			Average:	133.8142857	$ 2,039.92	$ 142.79
74			Highest:	208	$ 6,368.00	$ 445.76
75			Lowest:	69	$ 836.00	$ 58.52
76			Number of Employees:	70	$ 70.00	$ 70.00
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100