{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Delivery sheet

# Delivery sheet - Worksheet ChartData DataSet DeliveryForm...

This preview shows pages 1–6. Sign up to view the full content.

Worksheet Purpose ChartData Students will use the data to create charts DataSet Demonstrate various database functions in Excel DeliveryForm Used for IF & VLOOKUP Functions homework FunctionsHelp Examples of common Functions Tables Used for the VLOOKUP lesson TextData Grouping and separating text, paste special, concatenate

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Business Productivity Tools Java Juice Sales For Prepared by: Your Name January February March April May Food Sales Sandwiches \$42,000 \$42,500 \$43,000 \$43,500 \$44,000 Soup/Salads 19,000 20,710 22,574 24,606 26,820 Desserts 22,000 23,100 24,255 25,468 26,741 Total Food Sales \$83,000 \$86,310 \$89,829 \$93,573 \$97,561 Beverage Sales Coffee \$34,000 \$35,020 \$36,071 \$37,153 \$38,267 Tea 15,000 15,000 15,000 15,000 15,000 Beer/Wine 12,000 11,640 11,291 10,952 10,624 Juice 5,000 5,750 6,613 7,604 8,745 Soft Drinks 8,000 8,080 8,160 8,240 8,320 Total Beverage Sales \$74,000 \$75,490 \$77,134 \$78,949 \$80,956 Ingredient Costs Food Costs \$24,900 \$25,893 \$26,949 \$28,072 \$29,268 Beverage Costs \$11,100 \$11,324 \$11,570 \$11,842 \$12,143 Net Revenue \$121,000 \$124,584 \$128,444 \$132,608 \$137,105 Ratios Food Cost as a % of Sales 30% Beverage Cost as a % of Sales 15%
recast June Total % \$44,500 \$259,500 47.0% 29,234 142,943 25.9% 28,078 149,642 27.1% \$101,812 \$552,085 100% \$39,415 \$219,926 46.8% 15,000 90,000 19.2% 10,305 66,811 14.2% 10,057 43,769 9.3% 8,400 49,200 10.5% \$83,177 \$469,706 100% \$30,544 \$165,626 \$12,477 \$70,456 \$141,969 \$785,710 Sample

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
Demographics Monthly Purchases In Dollars ID # Last Name First Name Major Class M/F Gasoline Phone Music Clothes Food 250 La Aabedah Information Systems Junior F 73 12 0 67 257 183 Farley Aaron Finance Sophomore M 56 62 44 137 284 178 Eisenbarth Adam Management Sophomore M 75 30 95 107 301 191 Flores Adam Marketing Freshman M 92 21 33 46 417 273 Ly Adam Human Resource Sophomore M 61 93 91 27 315 277 Maddox Adam Accounting Senior M 61 19 75 23 466 300 Nguyen Adam Management Sophomore M 95 78 89 112 441 189 Fine Adina Accounting Freshman F 98 0 83 165 477 218 Ho Ainguyen Accounting Senior M 96 0 0 128 400 303 Nguyen Alex Finance Freshman M 11 86 0 31 316 227 Jamila Alicia Hospitality Mgmt Sophomore F 41 71 91 37 367 219 Holl Aline Corporate Finance Freshman F 43 0 57 60 468 153 Cross Alison Management Freshman F 47 98 97 156 438 207 Hall Alyssa Marketing Freshman F 64 71 92 97 374 260 Leone Amber Management Sophomore F 70 56 68 0 325 256 Lee Amin International Business Sophomore M 94 47 44 85 390 149 Cooper Amir Marketing Freshman M 95 17 54 117 351 292 Morris Amirissa Finance Freshman F 35 50 0 110 256 269 Lopez Ana Finance Sophomore F 53 80 3 77 287 163 Dicicco Andrew Corporate Finance Senior M 44 82 52 83 276 286 Mikhailova Andrew Marketing Junior M 32 27 49 40 371 287 Mina Andrew Marketing Senior M 50 34 76 15 442 313 Ou Andrew Marketing Senior M 47 60 19 153 263 121 Beltran Angela Finance Junior F 55 56 52 105 337 298 Ngo Anh Finance Junior F 56 69 19 133 459 101 Ablao Ann Marketing Junior F 67 11 32 144 400 248 Kwong Annchristy Corporate Finance Freshman F 76 0 5 131 279 159 Defriese Annette Finance Senior F 83 57 76 67 373 205 Ha Annie Management Sophomore F 90 93 30 0 334 157 Dang Anthony Management Junior M 98 15 93 173 266 214 Herrera Anthony Marketing Junior M 91 16 94 35 320 246 Kruschke Anthony Marketing Senior M 97 0 42 142 410 146 Cole Arishma International Business Sophomore F 37 66 0 146 301
216 Ho Arman Finance Sophomore M 48 25 0 174 253 262 Li Armand International Business Sophomore M 18 62 0 176 461 225 Huynh Aron Finance Junior M 33 40 0 69 301 173 Dove Arthur International Business Senior M 25 63 89 100 385 200 Gonzales Arthur Marketing Junior M 25 27 0 100 392 119 Begines Ashley Human Resource Junior F 32 81 22 41 396 267 Livingston Ashley Accounting Senior F 38 73 52 163 376 316 Parenti Audrey Hospitality Mgmt Junior F 98 0 64 168 410 161 Dela Belinda Information Systems Senior F 39 79 34 194 487

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.
• '09
• Splane,Mike
• Marketing, Corporate Finance, The Land, Sophomore Junior Sophomore Junior Sophomore Senior Senior Sophomore Freshman Senior Sophomore Sophomore Junior Senior Junior Junior Sophomore Sophomore Junior Sophomore Junior Sophomore Sophomore Senior Sophomore Sophomore Junior Sophomore Senior Junior J, Sophomore Junior Senior Junior Junior Senior Junior Senior Junior Freshman Senior Senior Sophomore Senior Freshman Senior Junior Junior Junior Sophomore Sophomore Sophomore Sophomore Sophomore Sophomore Junior Junior Junior Sophomore Junior Junior Sophomo, Senior Sophomore Sophomore Junior Junior Sophomore Senior Sophomore Junior Freshman Freshman Junior Sophomore Senior Sophomore Sophomore Freshman Junior Junior Sophomore Freshman Senior Sophomore Junior Senior Sophomore Junior Junior Sophomore Junior Juni

{[ snackBarMessage ]}

### Page1 / 23

Delivery sheet - Worksheet ChartData DataSet DeliveryForm...

This preview shows document pages 1 - 6. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online