Excel

profileyituo
2020Exam_Spring2020_Section3.xlsx

StartHere

Final Exam Bus 91L Spring 2020 Answer Sheet
Name Section # Name and Section #
Data Questions From Info in the Students Worksheet From ProductSales
Answer to Q1 Answer to Q2 Answer to Q3 Answer to Q4 Revenue
Products Sales Summary
Name Cost Price Margin ($) Margin (%) Total Sold Revenue
Computer $225 $549
Dryer $200 $429
Refrigerator $350 $899
Stove $125 $288
TV Screen $260 $579
Washer $180 $398
Totals $0
Author: Total should be 210
$0
Author: Should equal 111617

Author: should equal 111617
Item Revenue

Students

Final Exam Bus 91L Spring 2020 Student Data
ID # Last Name First Name City M/F Major Class GPA Gas Phone Food
101 Ablao Ann Sunnyvale F Marketing Junior 3.29 67 11 400
102 Ahmari Velia Milpitas F Marketing Senior 1.99 51 51 355
103 Alvarez Wendy Fremont F Finance Sophomore 2.08 63 81 384
104 Alvarez Vivian Fremont F Marketing Sophomore 2.84 60 51 373
105 Amador Zhichun San Jose F Undeclared Sophomore 3.32 11 92 485
106 Andaya Vinh Milpitas F Finance Freshman 3.24 54 98 422
107 Anderson Vu Fremont M Management Junior 3.05 60 27 359
108 Andrews Elliott Fremont M Marketing Senior 3.48 62 33 382
109 Arellano John Fremont M International Business Senior 3.22 62 33 320
110 Armanino Elana Fremont F Management Sophomore 2.72 59 35 268
111 Arredondo Jonathan Sunnyvale M Accounting Sophomore 3.17 68 37 376
112 Avram Tuan San Jose M Undeclared Junior 2.76 42 46 331
113 Badillo Tony San Jose M Undeclared Junior 3.10 39 46 323
114 Baird Catherine Santa Clara F Marketing Junior 1.94 46 51 364
115 Bala Joel Santa Clara M Human Resource Senior 2.60 47 56 300
116 Basati Shaun Santa Clara M Information Systems Senior 2.71 48 58 406
117 Bauer Jose Campbell M International Business Sophomore 4.00 70 75 277
118 Bautista Nicholas Sunnyvale M Marketing Sophomore 2.98 65 78 420
119 Begines Ashley San Jose F Human Resource Junior 3.38 32 81 396
120 Bella Jenny San Jose F Undeclared Junior 4.00 42 92 452
121 Beltran Angela Milpitas F Finance Junior 3.58 55 56 337
122 Benjamin Jeremiah San Jose M Marketing Junior 3.87 42 98 441
123 Bhandari Neda Sunnyvale F Undeclared Senior 2.06 64 0 384
124 Bianco Ogana Mountain View F Marketing Junior 2.61 83 0 269
125 Bourgouin Vincent Milpitas M Management Senior 3.15 51 18 443
126 Bravo Wanling Fremont M Accounting Sophomore 3.05 61 21 390
127 Brown Yesenia Sunnyvale F Accounting Junior 1.91 67 28 421
128 Buhagiar Myngoc Santa Clara F Management Junior 3.82 47 35 286
129 Bui Ziyin San Jose M Undeclared Senior 2.68 29 69 466
130 Bumgarner Nancy Milpitas F Marketing Senior 2.70 52 78 419
131 Camarena Joel Santa Clara M Marketing Junior 3.38 46 90 337
132 Cao Jessica San Jose F Finance Junior 2.47 42 0 470
133 Castro Nam Santa Clara M Undeclared Junior 3.44 51 15 262
134 Ceolla John Milpitas M Management Senior 1.86 52 31 357
135 Charan Jessica Santa Clara F Hospitality Mgmt Senior 3.24 45 46 318
136 Chavez Xiumei Sunnyvale F Accounting Senior 3.03 65 49 471
137 Chen Tony San Jose M Marketing Sophomore 1.81 37 53 337
138 Cheng Jimmy Santa Clara M Marketing Junior 3.19 45 56 333
139 Cheung Jessica San Jose F Information Systems Junior 2.94 42 17 392
140 Chey Nicholas Sunnyvale M Management Junior 3.23 65 90 265
141 Chin Zacil Palo Alto M Accounting Sophomore 3.48 89 0 452
142 Chu Xiawan Sunnyvale F Information Systems Junior 3.75 64 44 401
143 Chu Joelson Santa Clara M Accounting Junior 2.20 48 23 324
144 Chung Shannon San Jose F Management Sophomore 3.72 38 49 491
145 Chung Susan Fremont F Undeclared Junior 2.60 62 65 265
146 Cole Arishma San Jose F International Business Sophomore 2.17 37 66 301
147 Cole Steven San Jose M Management Sophomore 1.97 40 81 406
148 Condino Blanca Santa Clara F Marketing Sophomore 3.14 51 0 494
149 Cooper Amir Santa Cruz M Marketing Freshman 1.83 95 17 351
150 Cornejo Susan Santa Clara F Management Junior 2.97 49 33 356
151 Craig Olga Palo Alto F Information Systems Sophomore 1.93 89 30 335
152 Craig Belkisa Milpitas M Marketing Junior 3.23 52 37 371
153 Cross Alison Santa Clara F Management Freshman 3.82 47 98 438
154 Cummins Christopher Mountain View M Management Junior 2.77 77 0 436
155 Cunningham Thomas Gilroy M Finance Senior 2.96 99 83 387
156 Cutshaw Luis Fremont M Marketing Senior 3.95 58 21 403
157 Dang Anthony Oakland M Management Junior 3.23 98 15 266
158 Davis Clifford San Jose M International Business Senior 2.60 36 44 465
159 Defriese Annette Mountain View F Finance Senior 3.66 83 57 373
160 Deguzman Ly San Jose F Management Junior 4.00 17 74 420
161 Dela Belinda San Jose F Information Systems Senior 3.12 39 79 487
162 Delapena Duong Milpitas M Management Junior 2.24 52 50 301
163 Dicicco Andrew Santa Clara M Corporate Finance Senior 3.86 44 82 276
164 Dickey Branden Milpitas M Human Resource Senior 2.27 54 24 442
165 Diep Bien San Jose F Management Senior 2.69 43 64 430
166 Dinsmore Hong Los Gatos M Marketing Sophomore 2.70 86 71 416
167 Dizon Justin Santa Cruz M Undeclared Freshman 2.66 91 87 357
168 Do Ross San Jose M Management Freshman 3.36 26 91 396
169 Do Collin San Jose M Marketing Junior 2.93 42 28 424
170 Dolci Brian Mountain View M Marketing Junior 3.13 83 0 256
171 Dolmatch Sean San Jose M Management Junior 2.57 16 0 392
172 Dorso Marc Milpitas M Marketing Junior 2.37 53 36 309
173 Dove Arthur San Jose M International Business Senior 3.81 25 63 385
174 Duong Eric Sunnyvale M Information Systems Sophomore 3.23 70 11 407
175 Duong Christopher Sunnyvale M Management Senior 3.05 64 0 251
176 Durso Omar Mountain View M Finance Freshman 2.38 80 24 437
177 Edmonson Chris Mountain View M Management Junior 3.38 84 29 454
178 Eisenbarth Adam Campbell M Management Sophomore 1.93 75 30 301
179 Elias Luke San Jose M Accounting Sophomore 2.53 10 31 403
180 Enriquez Madhumathi San Jose M Human Resource Junior 3.12 21 37 386
181 Esterkin Quynh Santa Clara F Management Junior 3.16 45 54 417
182 Fan Rahul Santa Clara M Finance Junior 2.51 46 62 453
183 Farley Aaron Milpitas M Finance Sophomore 3.47 56 62 284
184 Ferla Cardenas San Jose M Finance Sophomore 1.96 11 65 288
185 Fernandez Dominic Fremont M Marketing Junior 2.87 62 90 330
186 Fernando Raymond Sunnyvale M Marketing Sophomore 3.40 67 93 301
187 Fiato Luis Mountain View M International Business Sophomore 2.77 84 96 313
188 Figone Oscar San Jose M Accounting Freshman 3.49 13 85 467
189 Fine Adina Oakland F Accounting Freshman 2.02 98 0 477
190 Flint Paige San Jose F Accounting Freshman 2.84 13 0 375
191 Flores Adam Santa Cruz M Marketing Freshman 2.07 92 21 417
192 Florez Crystal San Jose F Marketing Freshman 3.24 19 38 400
193 Forks Leroy Hayward M Accounting Junior 3.29 88 46 331
194 Gamez Soanne Hayward F Finance Senior 3.16 88 46 316
195 Garcia Christiane Hayward F Marketing Senior 3.73 88 57 355
196 Garcia Mai San Jose F International Business Senior 2.82 35 61 364
197 Garcia Steven San Francisco M International Business Sophomore 3.00 97 78 439
198 Gaw Julieta Fremont F Corporate Finance Junior 2.10 63 88 436
199 Golkowski Eric Sunnyvale M Information Systems Junior 2.13 67 24 475
200 Gonzales Arthur San Jose M Marketing Junior 2.07 25 27 392
201 Gragg Marian San Jose F Accounting Junior 2.39 40 35 288
202 Gray Chelsea Sunnyvale F Marketing Junior 2.87 64 38 413
203 Gutierrez Li Santa Cruz F Accounting Junior 3.14 91 80 287
204 Gutierrez Taylor Santa Cruz F Management Sophomore 3.95 92 84 407
205 Ha Annie Palo Alto F Management Sophomore 1.93 90 93 334
206 Haas Gustavo San Jose M Information Systems Freshman 2.59 16 21 374
207 Hall Alyssa Fremont F Marketing Freshman 3.06 64 71 374
208 Hannibal Darcy Milpitas M Management Senior 3.07 52 64 472
209 Harrington Kimika San Mateo F Marketing Senior 1.88 95 16 301
210 Hayes Samson Sunnyvale M Marketing Sophomore 3.26 68 78 413
211 Hayilu Christine Palo Alto F Management Sophomore 3.83 90 99 476
212 Henderson Bich Milpitas F Finance Freshman 3.79 56 17 389
213 Hernandez Gary Hayward M Information Systems Freshman 3.57 89 31 421
214 Herrera Anthony Palo Alto M Marketing Junior 3.78 91 16 320
215 Hightower Kristine San Jose F Management Senior 1.80 38 77 393
216 Ho Arman Santa Clara M Finance Sophomore 2.50 48 25 253
217 Ho Brandon Milpitas M Marketing Freshman 2.12 55 40 303
218 Ho Ainguyen San Mateo M Accounting Senior 3.71 96 0 400
219 Holl Aline San Jose F Corporate Finance Freshman 2.65 43 0 468
220 Hopf Randy Milpitas M Hospitality Mgmt Junior 3.45 55 20 277
221 House Kelly Sunnyvale F Undeclared Senior 3.47 64 0 412
222 Hu Lesly Hayward F Accounting Sophomore 2.74 88 10 332
223 Huang Lily Santa Cruz F Information Systems Freshman 2.30 94 23 372
224 Hung Paiman San Jose M Marketing Freshman 3.23 13 31 420
225 Huynh Aron San Jose M Finance Junior 2.73 33 40 301
226 Jacobo Dan Milpitas M Finance Sophomore 3.18 55 70 333
227 Jamila Alicia San Jose F Hospitality Mgmt Sophomore 2.07 41 71 367
228 Jandaur Steven San Jose M Finance Junior 2.44 24 79 456
229 Jiang Genesis Palo Alto M Information Systems Sophomore 2.63 91 92 453
230 Johnson Patrick San Jose M Management Sophomore 2.88 29 96 326
231 Jones Glen Santa Cruz M Information Systems Sophomore 3.50 91 98 415
232 Jozaki Neda Fremont F Management Senior 3.08 62 0 324
233 Jung Brandon Sunnyvale M Marketing Senior 3.07 64 0 424
234 Kahl Brittany Gilroy F International Business Sophomore 2.37 99 0 257
235 Kambou Sheryl Fremont F Management Freshman 1.96 59 87 385
236 Kamman David Fremont M Management Freshman 2.83 63 58 415
237 Kaneyuki Gregory San Jose M Management Freshman 3.69 32 57 353
238 Kapenga Kimberley Campbell F International Business Junior 2.60 75 84 482
239 Kelez Rayna Mountain View F Information Systems Senior 2.47 84 70 266
240 Kelley Catherine Santa Clara F Marketing Sophomore 2.15 48 82 286
241 Kemp Margaret Mountain View F International Business Freshman 3.92 83 0 412
242 Kewal Helen Milpitas F Marketing Freshman 2.72 55 45 253
243 Khuzaie Justin Milpitas M Corporate Finance Junior 3.81 52 11 424
244 Kolodziejak Binh San Jose M Marketing Senior 3.42 43 69 477
245 Konye Linda San Mateo F Human Resource Sophomore 3.29 96 91 411
246 Kruschke Anthony San Francisco M Marketing Senior 2.76 97 0 410
247 Kurtich Monica San Jose F International Business Sophomore 1.86 38 0 271
248 Kwong Annchristy Campbell F Corporate Finance Freshman 2.57 76 0 279
249 Kyu Cody San Jose M Information Systems Freshman 2.93 40 0 377
250 La Aabedah Campbell F Information Systems Junior 3.63 73 12 257
251 Landaverde Olivia Santa Cruz F Management Junior 2.49 93 20 323
252 Langley Hooveral Los Gatos M Undeclared Sophomore 2.57 86 22 284
253 Lau Kevin San Mateo M Management Junior 2.98 95 25 270
254 Lau Joseph San Jose M Finance Junior 3.03 24 24 487
255 Le Zaneta Fremont M Accounting Sophomore 2.85 63 47 390
256 Lee Amin Santa Cruz M International Business Sophomore 2.85 94 47 390
257 Lee Hajrudin San Jose M Management Senior 3.59 18 52 272
258 Lee Magdalena San Jose F Management Sophomore 2.41 22 53 340
259 Lehnhardt Samantha Fremont F Finance Sophomore 3.58 63 55 253
260 Leone Amber Sunnyvale F Management Sophomore 2.92 70 56 325
261 Leung Brenda Sunnyvale F Marketing Junior 2.51 67 62 286
262 Li Armand San Jose M International Business Sophomore 3.40 18 62 461
263 Liang Julia San Jose F Finance Freshman 2.74 43 66 308
264 Lin Justin Santa Cruz M International Business Freshman 2.54 91 69 476
265 Lipsius Cody San Jose M Management Freshman 3.43 38 70 294
266 Liu Kayte Santa Clara F Finance Freshman 2.84 46 70 283
267 Livingston Ashley San Jose F Accounting Senior 3.85 38 73 376
268 Lopez Ray Milpitas M Accounting Freshman 2.59 56 89 461
269 Lopez Ana Milpitas F Finance Sophomore 3.76 53 80 287
270 Lopez Daniel San Jose F Finance Freshman 2.12 42 85 283
271 Luong Shanti Santa Clara F Accounting Senior 2.90 45 93 350
272 Luong Sunhee Mountain View F International Business Senior 2.72 83 93 305
273 Ly Adam Fremont M Human Resource Sophomore 2.51 61 93 315
274 Ly Marthe Hayward F Information Systems Freshman 2.71 88 98 423
275 Macias Kris San Jose F Accounting Freshman 3.77 21 99 453
276 Madar Kristen San Jose F Marketing Junior 3.97 36 13 346
277 Maddox Adam Fremont M Accounting Senior 1.99 61 19 466
278 Mahasin Michael San Jose M Hospitality Mgmt Sophomore 2.64 33 33 345
279 Mahmoudi Philip San Jose M Management Freshman 1.80 14 34 431
280 Mancuso Chris Mountain View M Marketing Junior 2.28 83 58 431
281 Marshall Hector Santa Clara M Finance Senior 2.80 51 88 441
282 McDonough Marcus San Jose M Marketing Freshman 2.76 10 0 371
283 Mcgaffey Paula Santa Cruz F Marketing Freshman 3.18 91 0 383
284 McQueen Brian Los Gatos M Accounting Junior 3.00 85 12 272
285 Mendonca Kirk San Jose M Marketing Junior 2.76 11 18 402
286 Mikhailova Andrew San Jose M Marketing Junior 3.28 32 27 371
287 Mina Andrew Santa Clara M Marketing Senior 3.17 50 34 442
288 Mir David Fremont M Accounting Sophomore 3.25 60 36 323
289 Mirzaei Cheryl Campbell F Finance Sophomore 3.92 75 37 390
290 Mitsunaga Cory Mountain View M Information Systems Freshman 2.93 77 45 266
291 Morris Kimberly Campbell F Management Freshman 2.62 76 58 401
292 Morris Amirissa San Jose F Finance Freshman 2.42 35 50 256
293 Munoz Derek Sunnyvale M Finance Senior 2.71 64 57 393
294 Munzelong Patrick Los Gatos M Corporate Finance Sophomore 2.91 86 55 278
295 Navab Eric Campbell M Finance Freshman 3.54 71 62 274
296 Nealon Daniel San Jose M Management Freshman 3.57 18 66 339
297 Ngo Dang Mountain View M Finance Junior 2.49 81 71 430
298 Ngo Anh Milpitas F Finance Junior 3.23 56 69 459
299 Nguyen Shalin San Jose F Finance Junior 3.94 36 21 437
300 Nguyen Adam Santa Cruz M Management Sophomore 1.95 95 78 441
301 Nguyen Keith Milpitas M Accounting Senior 2.14 57 0 355
302 Nguyen Frances Mountain View F Marketing Sophomore 2.24 84 92 286
303 Nguyen Alex San Jose M Finance Freshman 2.33 11 86 316
304 Nguyen Phillip San Jose M Accounting Sophomore 2.89 38 0 423
305 Nguyen Kathy San Jose F Hospitality Mgmt Junior 3.54 42 98 439
306 Nguyen Justin San Jose M Marketing Junior 2.54 42 97 356
307 Nguyen Hao Sunnyvale F Corporate Finance Freshman 3.78 66 94 400
308 Nguyen Renee Los Gatos F Marketing Junior 3.68 85 16 342
309 Nguyen Manuel San Jose M Information Systems Sophomore 3.08 17 0 343
310 Nguyen Kosuke San Jose F Marketing Senior 2.04 18 0 481
311 Norton Justin Fremont M Finance Junior 3.30 62 41 363
312 Oh Derek Campbell M Management Senior 2.81 71 42 250
313 Ou Andrew Santa Clara M Marketing Senior 2.90 47 60 263
314 Pala Julia Santa Clara F Accounting Junior 3.00 50 84 444
315 Pang Kayla Santa Clara F Information Systems Junior 2.07 45 84 462
316 Parenti Audrey Oakland F Hospitality Mgmt Junior 2.17 98 0 410
317 Parian Matthew San Jose M Management Sophomore 3.70 24 0 302
318 Pavlov Kenny Palo Alto M International Business Senior 3.13 89 21 421
319 Penava Harinder San Jose M Marketing Senior 3.18 40 22 464
320 Perez Natalie Milpitas F Marketing Freshman 2.77 55 31 362
321 Pham Ronil Sunnyvale F Information Systems Junior 3.02 67 31 354
322 Phan Romel Oakland M Accounting Junior 2.30 98 35 293
323 Phillips James San Jose M Information Systems Junior 3.62 17 37 354
324 Phung Marios Fremont M International Business Senior 2.57 62 39 486
325 Posada Jaime San Mateo M Information Systems Senior 2.67 95 45 264
326 Posada Thanh San Francisco M Marketing Sophomore 3.00 96 46 322
327 Prasad Robert San Francisco M Undeclared Sophomore 3.07 96 49 467
328 Prasad Robert San Francisco M Information Systems Junior 3.13 96 52 276
329 Preciado Dung San Jose M Information Systems Junior 4.00 41 53 384
330 Remulla Jasmine Santa Clara F Undeclared Senior 3.35 45 60 330
331 Resendez Varinder Santa Clara M Accounting Junior 2.51 50 67 384
332 Richardson James San Mateo M Management Senior 1.83 95 71 412
333 Robinson Huong Los Gatos F Information Systems Senior 2.20 87 72 275
334 Robinson Sandeep San Jose M Finance Junior 3.24 10 76 343
335 Rodarte John Fremont M Corporate Finance Senior 2.13 61 95 258
336 Rogers Jeff Hayward M Marketing Sophomore 3.54 88 12 456
337 Roh Diane Los Gatos F Human Resource Sophomore 2.98 86 18 436
338 Rono Mark Los Gatos M Management Sophomore 3.00 86 23 382
339 Rupakula Ryan San Jose M Management Sophomore 3.57 41 27 358
340 Ryan John Fremont M Finance Junior 2.79 60 32 250
341 Sabalburo Vanessa San Jose F Information Systems Junior 3.27 42 34 433
342 Safi Juan San Jose M Accounting Junior 3.49 36 35 271
343 Sahi Marvin Hayward M Undeclared Junior 2.80 88 74 477
344 Scales Melanie Milpitas F Management Senior 2.33 52 79 471
345 Schenkhuizen Debra Sunnyvale F Information Systems Sophomore 3.30 64 88 421
346 Schwartz Jeff San Jose M Management Sophomore 2.78 11 84 466
347 Selig Bryan San Jose M Marketing Sophomore 2.39 22 90 283
348 Semedo Caleb San Jose M Finance Sophomore 2.88 10 0 263
349 Sharland Thong Gilroy F Marketing Sophomore 2.97 99 0 472
350 Shue Camille San Jose F Management Sophomore 3.59 10 0 301
351 Silvester Matthew San Jose M Undeclared Freshman 3.25 26 24 437
352 Singh Carolyn San Jose F Information Systems Junior 2.30 42 34 446
353 Sizer Ronald Gilroy M Finance Junior 3.76 99 40 273
354 Smith Jason Milpitas M Accounting Sophomore 2.61 55 58 413
355 Smith Tan Palo Alto F Marketing Sophomore 3.24 89 58 402
356 Standberry Brittany San Francisco F Human Resource Sophomore 3.79 97 62 263
357 Stuart Tina San Jose F Undeclared Sophomore 3.44 38 72 494
358 Su Roseanna Mountain View F Information Systems Sophomore 2.60 83 72 454
359 Tan Sei San Jose F Accounting Sophomore 2.61 26 97 353
360 Tate Carina San Jose F Accounting Junior 3.88 15 12 267
361 Ton Kevin Palo Alto M Accounting Junior 2.12 90 70 321
362 Tran Yvonne-Yen Mountain View F Management Junior 2.42 83 0 304
363 Tran John Sunnyvale M Accounting Junior 3.28 66 91 416
364 Tran Dominic Santa Cruz M Management Junior 2.83 95 0 443
365 Tran Jinny Santa Clara F Marketing Sophomore 2.21 46 87 382
366 Tran Dwight Milpitas M Marketing Senior 2.63 53 39 486
367 Tran Charles Milpitas M Management Junior 3.81 57 80 290
368 Tsang James San Mateo M Management Sophomore 2.70 95 0 357
369 Tsang Truong San Jose M Management Junior 2.95 39 29 473
370 Tsigaris Elaine Milpitas F Marketing Sophomore 3.25 57 42 282
371 Tu Jason Santa Clara M Corporate Finance Sophomore 3.17 49 88 418
372 Ungari Robert San Francisco M Management Junior 3.25 96 90 305
373 Vahdatinia Jeffrey San Jose M Management Junior 2.17 14 61 404
374 Vargas Michael Hayward M Management Junior 2.86 88 64 457
375 Vargas Tony San Jose M Management Senior 3.83 28 38 408
376 Vaughan Rohit San Francisco M Corporate Finance Sophomore 3.19 96 60 280
377 Vo Max Santa Clara M Marketing Sophomore 2.25 44 51 355
378 Vogel Danielle Santa Clara F Marketing Sophomore 2.55 49 71 365
379 Vong Tanya Palo Alto F Marketing Junior 3.46 89 92 452
380 Vu Michael Milpitas M Marketing Junior 1.81 56 43 342
381 Vu Taiwuit Hayward F Undeclared Sophomore 2.35 88 70 317
382 Vu Eric Sunnyvale M Management Junior 2.58 67 41 383
383 Wan Larry Santa Clara M Finance Sophomore 2.10 47 74 460
384 Wells Sarah San Jose F Management Sophomore 2.93 12 0 375
385 Wondolowski Theresa San Francisco F Marketing Sophomore 3.04 96 13 353
386 Wong Harinder San Jose M Undeclared Sophomore 2.60 43 34 433
387 Wray Teressa Santa Cruz F Finance Junior 2.81 94 57 381
388 Wright Maylin Santa Clara F Undeclared Junior 3.02 51 18 419
389 Wright Mario Santa Clara M Management Sophomore 3.92 45 0 290
390 Wright Jason Milpitas M Finance Senior 3.49 57 69 461
391 Wu Nicole Campbell F International Business Junior 2.85 72 58 417
392 Yamamoto Matthew Santa Clara M Information Systems Senior 3.33 49 86 303
393 Yap Sherry Santa Clara F Management Sophomore 2.72 48 0 326
394 Yip Mary Santa Cruz F Management Junior 2.75 93 32 475
395 Yu Douglas San Jose M Finance Junior 1.91 31 37 371
396 Yu James Gilroy M Management Senior 3.83 99 42 281
397 Yu John Sunnyvale M Undeclared Sophomore 1.98 66 75 289
398 Yuan Navpreet Fremont F Management Sophomore 1.90 61 83 376
399 Zhu Karla San Jose F Information Systems Sophomore 2.07 39 85 265
400 Zmolek Mark Los Gatos M Management Sophomore 2.87 87 96 326

ProductSales

Final Exam Bus 91L Spring 2020 Product Sales
Products Table
Name Cost Price
Computer $225 $549
Dryer $200 $429
Refrigerator $350 $899
Stove $125 $288
TV Screen $260 $579
Washer $180 $398
Sales Data Table February 2020
Date Agent Store Location Product Quantity Price Revenue
February 1, 2020 Amy San Jose Stove 1 $0
February 1, 2020 Tammy Santa Clara Stove 1 $0
February 2, 2020 Tammy Santa Cruz Dryer 2 $0
February 2, 2020 Mai Fremont Dryer 1 $0
February 2, 2020 Mai Fremont Refrigerator 1 $0
February 2, 2020 Mai Santa Clara TV Screen 1 $0
February 2, 2020 Mai Santa Clara Washer 1 $0
February 2, 2020 Tammy San Jose Computer 1 $0
February 2, 2020 Amy Santa Cruz Washer 1 $0
February 2, 2020 Amy San Jose Dryer 1 $0
February 2, 2020 Kim Fremont Washer 1 $0
February 3, 2020 Amy Santa Cruz Dryer 1 $0
February 3, 2020 Tammy Fremont Stove 1 $0
February 3, 2020 Amy Santa Clara Refrigerator 1 $0
February 4, 2020 Mai Santa Cruz TV Screen 1 $0
February 4, 2020 Tammy San Jose Dryer 1 $0
February 4, 2020 Kim Santa Clara TV Screen 1 $0
February 5, 2020 Mai Fremont Computer 1 $0
February 5, 2020 Mai Santa Clara Computer 1 $0
February 5, 2020 Mai Santa Clara Dryer 1 $0
February 5, 2020 Tammy Fremont Washer 1 $0
February 5, 2020 Tammy Fremont Washer 1 $0
February 6, 2020 Kim Fremont Refrigerator 1 $0
February 6, 2020 Kim Fremont Dryer 1 $0
February 6, 2020 Mai San Jose Refrigerator 1 $0
February 6, 2020 Mai Fremont Refrigerator 1 $0
February 6, 2020 Mai Santa Cruz Computer 1 $0
February 6, 2020 Mai Fremont Dryer 1 $0
February 6, 2020 Mai Santa Cruz Stove 1 $0
February 7, 2020 Kim San Jose Stove 2 $0
February 7, 2020 Mai Fremont Refrigerator 2 $0
February 7, 2020 Kim Fremont TV Screen 1 $0
February 7, 2020 Tammy San Jose Washer 1 $0
February 7, 2020 Tammy Santa Clara Computer 1 $0
February 7, 2020 Amy San Jose Washer 1 $0
February 7, 2020 Mai Santa Cruz Computer 1 $0
February 7, 2020 Tammy San Jose TV Screen 1 $0
February 7, 2020 Mai Santa Cruz Stove 1 $0
February 7, 2020 Kim Fremont Stove 1 $0
February 7, 2020 Kim Santa Cruz Refrigerator 1 $0
February 8, 2020 Amy San Jose Refrigerator 1 $0
February 8, 2020 Tammy San Jose Dryer 1 $0
February 8, 2020 Mai Santa Clara TV Screen 1 $0
February 8, 2020 Kim Santa Clara Stove 1 $0
February 9, 2020 Amy Santa Clara Stove 1 $0
February 9, 2020 Kim Santa Clara Dryer 1 $0
February 9, 2020 Tammy Santa Clara Washer 1 $0
February 10, 2020 Tammy Santa Clara Washer 2 $0
February 10, 2020 Tammy Fremont TV Screen 1 $0
February 10, 2020 Mai San Jose Washer 1 $0
February 10, 2020 Tammy Santa Cruz Computer 1 $0
February 11, 2020 Kim San Jose Computer 1 $0
February 11, 2020 Tammy San Jose Washer 1 $0
February 11, 2020 Mai Santa Cruz Dryer 1 $0
February 11, 2020 Mai Santa Cruz TV Screen 1 $0
February 11, 2020 Mai Santa Clara Computer 1 $0
February 11, 2020 Tammy San Jose Computer 1 $0
February 11, 2020 Tammy Santa Clara Dryer 1 $0
February 11, 2020 Tammy Santa Cruz Washer 1 $0
February 11, 2020 Kim Fremont Stove 1 $0
February 12, 2020 Tammy Santa Cruz Dryer 3 $0
February 12, 2020 Kim Santa Clara TV Screen 1 $0
February 12, 2020 Mai Fremont Dryer 1 $0
February 12, 2020 Kim Santa Clara Stove 1 $0
February 12, 2020 Mai Santa Cruz Refrigerator 1 $0
February 12, 2020 Tammy Santa Clara TV Screen 1 $0
February 12, 2020 Kim Fremont Dryer 1 $0
February 12, 2020 Mai San Jose TV Screen 1 $0
February 13, 2020 Mai Santa Clara Computer 1 $0
February 13, 2020 Amy Fremont Washer 1 $0
February 13, 2020 Kim Fremont Washer 1 $0
February 13, 2020 Kim Santa Cruz TV Screen 1 $0
February 13, 2020 Amy Santa Cruz Refrigerator 1 $0
February 13, 2020 Kim Fremont TV Screen 1 $0
February 13, 2020 Kim Santa Cruz Computer 1 $0
February 14, 2020 Kim Santa Clara Dryer 2 $0
February 14, 2020 Tammy Santa Clara Washer 3 $0
February 14, 2020 Kim Fremont Dryer 1 $0
February 14, 2020 Kim Santa Cruz Stove 1 $0
February 14, 2020 Mai Santa Clara TV Screen 1 $0
February 14, 2020 Mai Santa Cruz Computer 1 $0
February 14, 2020 Tammy Santa Cruz Stove 1 $0
February 14, 2020 Mai Santa Cruz Stove 1 $0
February 14, 2020 Kim San Jose Computer 1 $0
February 14, 2020 Amy Fremont Dryer 1 $0
February 14, 2020 Mai Fremont Computer 1 $0
February 15, 2020 Mai San Jose Refrigerator 4 $0
February 15, 2020 Kim Santa Clara TV Screen 1 $0
February 15, 2020 Mai Santa Cruz Dryer 1 $0
February 15, 2020 Tammy Fremont Computer 1 $0
February 15, 2020 Tammy San Jose Washer 1 $0
February 16, 2020 Amy San Jose Refrigerator 2 $0
February 16, 2020 Kim San Jose TV Screen 1 $0
February 16, 2020 Amy Fremont TV Screen 1 $0
February 16, 2020 Kim San Jose Washer 1 $0
February 16, 2020 Mai San Jose TV Screen 1 $0
February 16, 2020 Amy Santa Cruz Computer 1 $0
February 16, 2020 Kim San Jose Computer 1 $0
February 17, 2020 Tammy Fremont Refrigerator 3 $0
February 17, 2020 Kim Fremont Dryer 4 $0
February 17, 2020 Tammy San Jose Computer 1 $0
February 17, 2020 Amy Santa Cruz Refrigerator 1 $0
February 17, 2020 Amy Santa Cruz Refrigerator 1 $0
February 17, 2020 Mai Santa Clara Dryer 1 $0
February 17, 2020 Tammy Fremont Refrigerator 1 $0
February 17, 2020 Mai Fremont Dryer 1 $0
February 18, 2020 Kim Santa Clara Washer 2 $0
February 18, 2020 Mai San Jose Refrigerator 2 $0
February 18, 2020 Amy Fremont Computer 1 $0
February 18, 2020 Kim Santa Clara Dryer 1 $0
February 18, 2020 Kim Santa Clara Computer 1 $0
February 18, 2020 Tammy San Jose TV Screen 1 $0
February 18, 2020 Mai Santa Cruz Computer 1 $0
February 18, 2020 Kim Santa Cruz Refrigerator 1 $0
February 19, 2020 Tammy Santa Clara Washer 2 $0
February 19, 2020 Kim Fremont TV Screen 1 $0
February 19, 2020 Mai Fremont Computer 1 $0
February 19, 2020 Kim Santa Clara Dryer 1 $0
February 19, 2020 Amy Santa Clara Dryer 1 $0
February 19, 2020 Kim Fremont Stove 1 $0
February 19, 2020 Amy Fremont Computer 1 $0
February 19, 2020 Kim Santa Clara Computer 1 $0
February 19, 2020 Amy Santa Clara TV Screen 1 $0
February 20, 2020 Kim Fremont Refrigerator 1 $0
February 20, 2020 Kim San Jose TV Screen 1 $0
February 20, 2020 Amy San Jose Refrigerator 1 $0
February 21, 2020 Mai Fremont Computer 1 $0
February 21, 2020 Mai Santa Cruz Stove 1 $0
February 21, 2020 Kim San Jose Computer 1 $0
February 21, 2020 Amy Santa Clara Washer 1 $0
February 21, 2020 Tammy Fremont Washer 1 $0
February 22, 2020 Tammy Santa Clara Dryer 2 $0
February 22, 2020 Tammy Santa Clara TV Screen 1 $0
February 22, 2020 Kim San Jose Refrigerator 1 $0
February 22, 2020 Mai Santa Clara Refrigerator 1 $0
February 22, 2020 Tammy Santa Clara Washer 1 $0
February 22, 2020 Kim Santa Clara Washer 1 $0
February 23, 2020 Mai Santa Cruz Refrigerator 1 $0
February 23, 2020 Kim Fremont Washer 1 $0
February 23, 2020 Tammy Santa Cruz Dryer 1 $0
February 23, 2020 Tammy Santa Clara Stove 1 $0
February 23, 2020 Amy Santa Cruz Washer 1 $0
February 23, 2020 Mai Santa Cruz Refrigerator 1 $0
February 23, 2020 Amy Santa Cruz Computer 1 $0
February 23, 2020 Tammy San Jose Stove 1 $0
February 23, 2020 Mai Santa Cruz Refrigerator 1 $0
February 24, 2020 Amy Santa Cruz TV Screen 2 $0
February 24, 2020 Kim Santa Cruz Dryer 2 $0
February 24, 2020 Kim Santa Cruz Computer 3 $0
February 24, 2020 Kim San Jose Washer 1 $0
February 24, 2020 Amy San Jose Stove 1 $0
February 24, 2020 Mai San Jose Computer 1 $0
February 24, 2020 Amy Fremont Dryer 1 $0
February 24, 2020 Amy Fremont Refrigerator 1 $0
February 25, 2020 Kim Santa Clara Washer 1 $0
February 25, 2020 Kim Santa Cruz TV Screen 1 $0
February 25, 2020 Tammy Santa Cruz Stove 1 $0
February 25, 2020 Kim Santa Cruz Computer 1 $0
February 26, 2020 Amy Fremont Refrigerator 1 $0
February 26, 2020 Mai San Jose Stove 1 $0
February 26, 2020 Kim Santa Cruz Dryer 1 $0
February 27, 2020 Amy Fremont TV Screen 3 $0
February 27, 2020 Mai Santa Clara Refrigerator 1 $0
February 27, 2020 Amy Santa Cruz TV Screen 1 $0
February 27, 2020 Kim Santa Clara Computer 1 $0
February 27, 2020 Amy Fremont Computer 1 $0
February 27, 2020 Tammy San Jose Computer 1 $0
February 28, 2020 Tammy Fremont Dryer 2 $0
February 28, 2020 Amy San Jose Washer 4 $0
February 28, 2020 Tammy San Jose Stove 1 $0
February 28, 2020 Tammy San Jose Stove 1 $0
February 28, 2020 Mai Santa Cruz Computer 1 $0
February 28, 2020 Mai Fremont Stove 1 $0
February 28, 2020 Tammy Fremont Refrigerator 1 $0
February 28, 2020 Mai San Jose Dryer 1 $0
February 28, 2020 Amy Fremont Stove 1 $0
February 28, 2020 Mai Santa Clara Computer 1 $0
February 28, 2020 Tammy Fremont Stove 1 $0
210 $0

Charts

Final Exam Bus 91L Spring 2020 Charts