Homework

Excel

Tips

s

Rate

Tip Sharing	Rate
Coworker	Based on
Beverage Worker	Beverage Total	13%
Assistant	Subtotal	2%

2

>

Monday

s

.00

.

.5

2

.

5

.00

4

5

6

5.25

.70

7

8

9.75

15

9

5.82

10

9.75

9

– 0 – 0

– 0 – 0 – 0
– 0 – 0 – 0
– 0 – 0 – 0
– 0 – 0 – 0
– 0 – 0 – 0
– 0 – 0 – 0
– 0 – 0 – 0
– 0 – 0 – 0

																																																										Kimo’s	Tip
Monday Lunch
				Customer						Food						Drinks						Subtotal					Tip Left
				1	$ Save Time On Research and Writing Hire a Pro to Write You a 100% Plagiarism-Free Paper. Get My Paper										4						5	$								6		50	$ 51.50							8
62.50									9						7	72.					25					15
					3	78.			18					13	91.18	18.82
4			5.25										6.50	51.75											10
66.80	18.00	84.80	15.2
15.45					20		4.3
27.38								9.75	37.13	7.5
60.00	69.75
					12			25.25	151.07			40
	42.18	51.93
				11	55.92						12.95	68.87								14
																																																												– 0
					Totals

Tuesday

Kimo’s Tips

Customer Food Drinks Subtotal Tip Left

1

.58

2

25

3

.50

40

4

4

5

9.75

18

6

6.50

6

7

3.25

4.3

8

50

9

3.25

0

4

10 42.18 6.50

9

11

9.75

14

12

50

13

– 0 14.25 3

14

6.50

– 0 – 0 – 0
– 0 – 0 – 0
– 0 – 0 – 0
– 0 – 0 – 0
– 0 – 0 – 0
– 0 – 0 – 0
Totals

Tuesday Lunch
$ 63.42	$					13.00	$ 76.42				16
85.00		25.00	1	10.00
135.45				19	154.95
15.95						3.25	19.20
65.32	75.07
29.18	35.68
1						8.45		21.70
125.35	40.00	165.35
15.25	1	8.5
48.68
75.00	84.75
160.18	35.00	195.18
	14.25
34.80	41.			30	6.7

Wednesday

Kimo’s Tips

Customer Food Drinks Subtotal Tip Left

1

8.5

2

8.45

10

3

25

4

6.75

0

7

5

8.45

12

6

5.25

7 12.95 6.75

4

8

8.45

14

9

25.25

30

10

6.75

9

11

12.95

14

12

12.95

20

13

– 0 12.25 2

14

6.75

5.5

15

20

16

10.25

– 0 – 0 – 0
– 0 – 0 – 0
– 0 – 0 – 0
– 0 – 0 – 0
Totals

Wednesday Lunch
$ 35.00	$									6.75	$ 41.75
	42.50		50.95
100.18				10.25	110.43
38.75	4	5.5
51.37	59.82
16.25	21.50	3.5
19.70
65.81	74.26
112.45	137.70
35.13	41.88
62.10	75.05
84.34	97.29
	12.25
25.45	32.20
75.12	1		3.50	88.62
40.44	50.69		8.85

Thursday

Kimo’s Tips

Customer Food Drinks Subtotal Tip Left

1

25

2

3.25

4

3

6.50

10

4

9.75

25

5

6.50

6

6.50

10

7

13.00

30

8

6.50

9

6.50

8

10

13.00

11

13.00

17

12

40

13

19.50

30

14

6.50

6

15

13.00

17

16

9.75

10

17

3.25

4

18

6.50

10

19

13.00

25

20

3.25

5

Totals

Thursday Lunch
$ 84.90	$ 2	7.00	$ 111.90
15.75	1	9.00
48.65	55.15
105.32	115.07
5		2.00	58.50	12.5
35.82	42.32
115.05	128.05
25.90	32.40	7.6
34.85	41.35
70.25	83.25					17
75.08	88.08
135.82	45.00	180.82
120.05	139.55
26.45	32.95
60.07	73.07
44.88	54.63
	14.95	18.20
36.33	42.83
95.35	108.35
	18.88	22.13

Friday

Kimo’s Tips

Customer Food Drinks Subtotal Tip Left

1

2 42.50 8.45 50.95 10.00
3

10.25

25.00

4

6.75

7.00

5

8.45

6

5.25

3.50

7 14.95 6.75 21.70

8

8.45

9

25.25

10

6.75

9.00

11

12.95

14.00

12

12.95

13

– 0 120.18 2.00

14

6.75

15

20.00

16 18.88 10.25

8.85

17

– 0 35.18 2.00

18

3.50

19

9.75

20

6.75

12.00

Totals

Friday Lunch
$ 76.18	$ 6.75	$ 82.93	$ 8.50
120.20	130.45
45.92	52.67
132.18	140.63		12.00
34.50	39.75
4.00
84.31	92.76		14.00
115.18	140.43	30.00
42.88	49.63
65.00	77.95
50.45	63.40		20.00
	120.18
80.45	87.20	5.50
100.05	13.50	113.55
29.13
	35.18
24.75	28.25	6.00
140.18	149.93	15.00
133.92	140.67

Week

Kimo’s Tips

Food Drinks Subtotal Tip

Monday

Tuesday $ – 0
Wednesday $ – 0
Thursday $ – 0
Friday $ – 0
Totals $ – 0 $ – 0

Weekly Totals
Day	Beverage Worker Tip	Assistant Tip	Net Tip
						$ – 0
$ 1,055.36