IS 2080C Excel assignment

profileNate-1
ISassignment22.xlsx
Home>Computer Science homework help>IS 2080C Excel assignment

Key

Uber Driver Pay
Rates $ 0.79 $ 0.60 $ 0.17
Date # of Trips Miles Minutes
1-Jan 20.00 150.00 200.00
2-Jan
3-Jan 10.00 80.00 100.00
4-Jan 13.00 180.00 300.00
5-Jan 15.00 200.00 360.00
6-Jan
7-Jan 5.00 40.00 60.00
8-Jan 10.00 80.00 136.00
9-Jan
10-Jan 10.00 80.00 100.00
11-Jan 13.00 180.00 300.00
12-Jan 15.00 200.00 360.00
13-Jan
14-Jan 5.00 40.00 60.00
15-Jan 10.00 80.00 136.00
16-Jan
17-Jan 10.00 80.00 100.00
18-Jan 13.00 180.00 300.00
19-Jan 15.00 200.00 360.00
20-Jan
21-Jan 5.00 40.00 60.00
22-Jan 10.00 80.00 136.00
23-Jan
24-Jan 10.00 80.00 100.00
25-Jan 13.00 180.00 300.00
26-Jan 15.00 200.00 360.00
27-Jan
28-Jan 5.00 40.00 60.00
29-Jan 10.00 80.00 136.00
30-Jan
31-Jan 10.00 80.00 100.00
January Total 242.00 2,550.00 4,124.00
1-Feb 20.00 150.00 200.00
2-Feb
3-Feb 10.00 80.00 100.00
4-Feb 13.00 180.00 300.00
5-Feb 15.00 200.00 360.00
6-Feb
7-Feb 5.00 40.00 60.00
8-Feb 10.00 80.00 136.00
9-Feb
10-Feb 10.00 80.00 100.00
11-Feb 13.00 180.00 300.00
12-Feb 15.00 200.00 360.00
13-Feb
14-Feb 5.00 40.00 60.00
15-Feb 10.00 80.00 136.00
16-Feb
17-Feb 10.00 80.00 100.00
18-Feb 13.00 180.00 300.00
19-Feb 15.00 200.00 360.00
20-Feb
21-Feb 5.00 40.00 60.00
22-Feb 10.00 80.00 136.00
23-Feb
24-Feb 10.00 80.00 100.00
25-Feb 13.00 180.00 300.00
26-Feb 15.00 200.00 360.00
27-Feb
28-Feb 5.00 40.00 60.00
February Total 222.00 2,390.00 3,888.00
1-Mar 20.00 150.00 200.00
2-Mar
3-Mar 10.00 80.00 100.00
4-Mar 13.00 180.00 300.00
5-Mar 15.00 200.00 360.00
6-Mar
7-Mar 5.00 40.00 60.00
8-Mar 10.00 80.00 136.00
9-Mar
10-Mar 10.00 80.00 100.00
11-Mar 13.00 180.00 300.00
12-Mar 15.00 200.00 360.00
13-Mar
14-Mar 5.00 40.00 60.00
15-Mar 10.00 80.00 136.00
16-Mar
17-Mar 10.00 80.00 100.00
18-Mar 13.00 180.00 300.00
19-Mar 15.00 200.00 360.00
20-Mar
21-Mar 5.00 40.00 60.00
22-Mar 10.00 80.00 136.00
23-Mar
24-Mar 10.00 80.00 100.00
25-Mar 13.00 180.00 300.00
26-Mar 15.00 200.00 360.00
27-Mar
28-Mar 5.00 40.00 60.00
29-Mar 10.00 80.00 136.00
30-Mar
31-Mar 10.00 80.00 100.00
March Total 242.00 2,550.00 4,124.00
1-Apr 20.00 150.00 200.00
2-Apr
3-Apr 10.00 80.00 100.00
4-Apr 13.00 180.00 300.00
5-Apr 15.00 200.00 360.00
6-Apr
7-Apr 5.00 40.00 60.00
8-Apr 10.00 80.00 136.00
9-Apr
10-Apr 10.00 80.00 100.00
11-Apr 13.00 180.00 300.00
12-Apr 15.00 200.00 360.00
13-Apr
14-Apr 5.00 40.00 60.00
15-Apr 10.00 80.00 136.00
16-Apr
17-Apr 10.00 80.00 100.00
18-Apr 13.00 180.00 300.00
19-Apr 15.00 200.00 360.00
20-Apr
21-Apr 5.00 40.00 60.00
22-Apr 10.00 80.00 136.00
23-Apr
24-Apr 10.00 80.00 100.00
25-Apr 13.00 180.00 300.00
26-Apr 15.00 200.00 360.00
27-Apr
28-Apr 5.00 40.00 60.00
29-Apr 10.00 80.00 136.00
30-Apr
April Total
1-May 20.00 150.00 200.00
2-May
3-May 10.00 80.00 100.00
4-May 13.00 180.00 300.00
5-May 15.00 200.00 360.00
6-May
7-May 5.00 40.00 60.00
8-May 10.00 80.00 136.00
9-May
10-May 10.00 80.00 100.00
11-May 13.00 180.00 300.00
12-May 15.00 200.00 360.00
13-May
14-May 5.00 40.00 60.00
15-May 10.00 80.00 136.00
16-May
17-May 10.00 80.00 100.00
18-May 13.00 180.00 300.00
19-May 15.00 200.00 360.00
20-May
21-May 5.00 40.00 60.00
22-May 10.00 80.00 136.00
23-May
24-May 10.00 80.00 100.00
25-May 13.00 180.00 300.00
26-May 15.00 200.00 360.00
27-May
28-May 5.00 40.00 60.00
29-May 10.00 80.00 136.00
30-May
31-May 10.00 80.00 100.00
May total 13.00 180.00 300.00
1-Jun 20.00 150.00 200.00
2-Jun
3-Jun 10.00 80.00 100.00
4-Jun 13.00 180.00 300.00
5-Jun 15.00 200.00 360.00
6-Jun
7-Jun 5.00 40.00 60.00
8-Jun 10.00 80.00 136.00
9-Jun
10-Jun 10.00 80.00 100.00
11-Jun 13.00 180.00 300.00
12-Jun 15.00 200.00 360.00
13-Jun
14-Jun 5.00 40.00 60.00
15-Jun 10.00 80.00 136.00
16-Jun
17-Jun 10.00 80.00 100.00
18-Jun 13.00 180.00 300.00
19-Jun 15.00 200.00 360.00
20-Jun
21-Jun 5.00 40.00 60.00
22-Jun 10.00 80.00 136.00
23-Jun
24-Jun 10.00 80.00 100.00
25-Jun 13.00 180.00 300.00
26-Jun 15.00 200.00 360.00
27-Jun
28-Jun 5.00 40.00 60.00
29-Jun 10.00 80.00 136.00
30-Jun
Jun Total
1-Jul 20.00 150.00 200.00
2-Jul
3-Jul 10.00 80.00 100.00
4-Jul 13.00 180.00 300.00
5-Jul 15.00 200.00 360.00
6-Jul
7-Jul 5.00 40.00 60.00
8-Jul 10.00 80.00 136.00
9-Jul
10-Jul 10.00 80.00 100.00
11-Jul 13.00 180.00 300.00
12-Jul 15.00 200.00 360.00
13-Jul
14-Jul 5.00 40.00 60.00
15-Jul 10.00 80.00 136.00
16-Jul
17-Jul 10.00 80.00 100.00
18-Jul 13.00 180.00 300.00
19-Jul 15.00 200.00 360.00
20-Jul
21-Jul 5.00 40.00 60.00
22-Jul 10.00 80.00 136.00
23-Jul
24-Jul 10.00 80.00 100.00
25-Jul 13.00 180.00 300.00
26-Jul 15.00 200.00 360.00
27-Jul
28-Jul 5.00 40.00 60.00
29-Jul 10.00 80.00 136.00
30-Jul
31-Jul 10.00 80.00 100.00
July Total
1-Aug 20.00 150.00 200.00
2-Aug
3-Aug 10.00 80.00 100.00
4-Aug 13.00 180.00 300.00
5-Aug 15.00 200.00 360.00
6-Aug
7-Aug 5.00 40.00 60.00
8-Aug 10.00 80.00 136.00
9-Aug
10-Aug 10.00 80.00 100.00
11-Aug 13.00 180.00 300.00
12-Aug 15.00 200.00 360.00
13-Aug
14-Aug 5.00 40.00 60.00
15-Aug 10.00 80.00 136.00
16-Aug
17-Aug 10.00 80.00 100.00
18-Aug 13.00 180.00 300.00
19-Aug 15.00 200.00 360.00
20-Aug
21-Aug 5.00 40.00 60.00
22-Aug 10.00 80.00 136.00
23-Aug
24-Aug 10.00 80.00 100.00
25-Aug 13.00 180.00 300.00
26-Aug 15.00 200.00 360.00
27-Aug
28-Aug 5.00 40.00 60.00
29-Aug 10.00 80.00 136.00
30-Aug
31-Aug 10.00 80.00 100.00
August Total
1-Sep 20.00 150.00 200.00
2-Sep
3-Sep 10.00 80.00 100.00
4-Sep 13.00 180.00 300.00
5-Sep 15.00 200.00 360.00
6-Sep
7-Sep 5.00 40.00 60.00
8-Sep 10.00 80.00 136.00
9-Sep
10-Sep 10.00 80.00 100.00
11-Sep 13.00 180.00 300.00
12-Sep 15.00 200.00 360.00
13-Sep
14-Sep 5.00 40.00 60.00
15-Sep 10.00 80.00 136.00
16-Sep
17-Sep 10.00 80.00 100.00
18-Sep 13.00 180.00 300.00
19-Sep 15.00 200.00 360.00
20-Sep
21-Sep 5.00 40.00 60.00
22-Sep 10.00 80.00 136.00
23-Sep
24-Sep 10.00 80.00 100.00
25-Sep 13.00 180.00 300.00
26-Sep 15.00 200.00 360.00
27-Sep
28-Sep 5.00 40.00 60.00
29-Sep 10.00 80.00 136.00
30-Sep
September Total
1-Oct 20.00 150.00 200.00
2-Oct
3-Oct 10.00 80.00 100.00
4-Oct 13.00 180.00 300.00
5-Oct 15.00 200.00 360.00
6-Oct
7-Oct 5.00 40.00 60.00
8-Oct 10.00 80.00 136.00
9-Oct
10-Oct 10.00 80.00 100.00
11-Oct 13.00 180.00 300.00
12-Oct 15.00 200.00 360.00
13-Oct
14-Oct 5.00 40.00 60.00
15-Oct 10.00 80.00 136.00
16-Oct
17-Oct 10.00 80.00 100.00
18-Oct 13.00 180.00 300.00
19-Oct 15.00 200.00 360.00
20-Oct
21-Oct 5.00 40.00 60.00
22-Oct 10.00 80.00 136.00
23-Oct
24-Oct 10.00 80.00 100.00
25-Oct 13.00 180.00 300.00
26-Oct 15.00 200.00 360.00
27-Oct
28-Oct 5.00 40.00 60.00
29-Oct 10.00 80.00 136.00
30-Oct
31-Oct 10.00 80.00 100.00
October Total
1-Nov 20.00 150.00 200.00
2-Nov
3-Nov 10.00 80.00 100.00
4-Nov 13.00 180.00 300.00
5-Nov 15.00 200.00 360.00
6-Nov
7-Nov 5.00 40.00 60.00
8-Nov 10.00 80.00 136.00
9-Nov
10-Nov 10.00 80.00 100.00
11-Nov 13.00 180.00 300.00
12-Nov 15.00 200.00 360.00
13-Nov
14-Nov 5.00 40.00 60.00
15-Nov 10.00 80.00 136.00
16-Nov
17-Nov 10.00 80.00 100.00
18-Nov 13.00 180.00 300.00
19-Nov 15.00 200.00 360.00
20-Nov
21-Nov 5.00 40.00 60.00
22-Nov 10.00 80.00 136.00
23-Nov
24-Nov 10.00 80.00 100.00
25-Nov 13.00 180.00 300.00
26-Nov 15.00 200.00 360.00
27-Nov
28-Nov 5.00 40.00 60.00
29-Nov 10.00 80.00 136.00
30-Nov
November Total
1-Dec 20.00 150.00 200.00
2-Dec
3-Dec 10.00 80.00 100.00
4-Dec 13.00 180.00 300.00
5-Dec 15.00 200.00 360.00
6-Dec
7-Dec 5.00 40.00 60.00
8-Dec 10.00 80.00 136.00
9-Dec
10-Dec 10.00 80.00 100.00
11-Dec 13.00 180.00 300.00
12-Dec 15.00 200.00 360.00
13-Dec
14-Dec 5.00 40.00 60.00
15-Dec 10.00 80.00 136.00
16-Dec
17-Dec 10.00 80.00 100.00
18-Dec 13.00 180.00 300.00
19-Dec 15.00 200.00 360.00
20-Dec
21-Dec 5.00 40.00 60.00
22-Dec 10.00 80.00 136.00
23-Dec
24-Dec 10.00 80.00 100.00
25-Dec 13.00 180.00 300.00
26-Dec 15.00 200.00 360.00
27-Dec
28-Dec 5.00 40.00 60.00
29-Dec 10.00 80.00 136.00
30-Dec
31-Dec 10.00 80.00 100.00
December Total

Sheet2

0.062 0.0145 0.04997
Gross FICA SSI FICA Medicare Ohio Inc Total Taxes Net Income
January $ 2,401.74 $ 148.91 $ 34.83 $ 120.01 $ 303.75 $ 2,097.99
February $ 2,250.99 $ 139.56 $ 32.64 $ 112.48 $ 284.68 $ 1,966.31
March $ 2,401.74 $ 148.91 $ 34.83 $ 120.01 $ 303.75 $ 2,097.99
April $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
May $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
June $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
July $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
August $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
September $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
October $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
November $ - 0 $ - 0 $ - 0 $ - 0 $ - 0
December $ - 0 $ - 0 $ - 0 $ - 0 $ - 0

Sheet3

Month February
Gross Income $ 2,250.99
Total Taxes $ 284.68
Net Income $ 1,966.31