Delivery sheet - Worksheet ChartData DataSet DeliveryForm...

Info iconThis preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon
Worksheet Purpose ChartData Students will use the data to create charts DataSet Demonstrate various database functions in Excel DeliveryForm FunctionsHelp Examples of common Functions Tables Used for the VLOOKUP lesson TextData Grouping and separating text, paste special, concatenate
Background image of page 1

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

View Full DocumentRight Arrow Icon
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%
Background image of page 2
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
Background image of page 3

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

View Full DocumentRight Arrow Icon
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
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 09/08/2010 for the course BUS 91L at San Jose State University .

Page1 / 23

Delivery sheet - Worksheet ChartData DataSet DeliveryForm...

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

View Full Document Right Arrow Icon
Ask a homework question - tutors are online