e115inClass6

e115inClass6 - dinner 10 12 120 8.4 128.4 Charles Brown...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Sheet1 Page 1 Tax Rate 0.07 Breakfast 4.49 Buffet 6.25 Lunch 9.00 Dinner 12.00 Party# Party Name Meal Number in Party Cost per person Subtotal Tax Total Bill Tom Smith breakfast 1 4.49 4.49 0.31 4.8 lunch 11 9 99 6.93 105.93 Kim Sykes dinner 2 12 24 1.68 25.68 Tammy Appleton buffet 10 6.25 62.5 4.38 66.88 lunch 3 9 27 1.89 28.89 Jake Barbour dinner 9 12 108 7.56 115.56 Louie Johnston breakfast 4 4.49 17.96 1.26 19.22 Cyndi James dinner 8 12 96 6.72 102.72 Liz Bradley buffet 6 6.25 37.5 2.63 40.13 Pat Taylor breakfast 7 4.49 31.43 2.2 33.63 Anna Foster lunch 5 9 45 3.15 48.15 Robert Davis dinner 4 12 48 3.36 51.36 Michael Miller buffet 8 6.25 50 3.5 53.5 Susan Jones lunch 7 9 63 4.41 67.41 Linda Wilson
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: dinner 10 12 120 8.4 128.4 Charles Brown buffet 7 6.25 43.75 3.06 46.81 dinner 15 12 180 12.6 192.6 Margaret Moore buffet 12 6.25 75 5.25 80.25 breakfast 8 4.49 35.92 2.51 38.43 Heidi Holmes lunch 2 9 18 1.26 19.26 Sales Summary Customers served: 139 Parties Served: 20 Smallest Total Bill: 4.8 Largest Total Bill: 192.6 Average Total Bill: 63.48 1186.55 *Note: Daily Revenue is the amount of the bill before tax. Jane Doughe Radney White Deborah Bryk Ed Bello Total Daily Revenue:...
View Full Document

Ask a homework question - tutors are online