the description to support your answer 3. On the third worksheet, create two pivot tables one showing the total amount spent on travel by each sales person and one showing the percentage of travel for each sales person out of the total. Illustrate your results with a PivotChart. Put the pivot table and pivot chart in the word file and comment on which sales persons has the highest expenses. 4. On the forth worksheet, create a pivot table to find the total revenue by region and type. illustrate your results with a PivotChart. In the word document, answer the following question: Which region has the most sales? Which type of product should the company focus on? Include the pivot table and pivot chart to illustrate your answers Page of 4 Travel Expenses 3/2/2014 972014 3/12/2014 3/13/2014 3/16/2014 9/112014 18 2014 320 2014 321/2014 3/24/2014 3/25/2014 3/20/2014 Sales Rep Crawford Crawford S Crawford Crawford S Craford Crond Crawford Crong S Crawford S Crawford Croaford Crond Crawford S Expenses $ 22125 022 S 232.94 9 14 $ 110.15 $ 1988 S 208.84 5170 9256 24611 151.00 $ 109 53 TA84 S 13771 92.09 Jones 13/2014 2014 3/12/2014 143 32/2014 30/2014 31 2014 2014 312014 324/2014 Rogers 129/2014 MacBook Pro wucture.com courses/266500 s/1614649252module item id 53731400 Page of 4 Transaction Code Source GUT. Sales Transactions: July 14 Custo Region Payment 0001 East Papa 10002 West 10003 North 10004 West Paypal 10005 South Credit 10006 West Amount Product Time Of Day POD DVD $17.85 DVD $23.98 DVD $23.51 Book $1533 Book $17.30 DVD $177.72 Book $21.75 Book $1592 DVD $2339 DVD 1132609 Cred Paypal Paypal 5739622 54242587 62507750 51555882 54332964 20623353 $21.01 DVD $22.91 DVD 5008026 2545 $17.16 Rock $205.50 BOOK $18.12 Book $20.04 DVD $2321 DVD 10024 West $18.91 DVD $18.36 DVD $17.95 DVD $18.29 Book 316.60 DVD 315.87 Bock 52102 DVD MacBook Pro ) w instructure.com/course/266500/files/1614049257module item id=53731400 Page of 4 web 17:35 15:52 Paypal Web $18.12 Book $18 22 DVD $18.32 Bock $23.77 DVD 64471213 70288635 46067931 73400503 31794035 72954240 10059 East 10060 East 10061 West 10062 East 10063 South Web 19.53 15.16 13.55 13.34 Email Credit Credit 19974213 15.02 Email Email 065 North 10006 East 10067 East 10068 South 10089 South $20.13 DVD $20 77 DVD $16.98 DVD $19.40 Book 323.49 Book $15.58 Book $21.94 DVD $229.73 Book 20:19 10071 West Credit 77232784 94731015 49007475 71384500 15282110 87012305 27742544 97981670 83870405 Web Email $22 21 DVD $21.58 DVD $16.09 Bock 10075 East $19.30 DVD 1124 1023 11:29 19.02 19:26 37371293 100 East 100et East 10088 East 27497000 29510284 521037 Bock $15 33 Book 520.61 DVD Email $23.70 DVD $18.93 Bock $22.19 Book 52031 DVD MacBook Pro structure.com/courses/2665001/es/161464925?module_item_id 53731400 Page of 4 Web Email Email Web 21 0:00 9:09 20:46 8:08 12:30 12:15 Web Web Web Web Web 5:05 9.09 2:02 17:34 Web Web Ema Web Web 20:28 20:35 10182 South 10183 West 10184 South 10185 West 10186 West 10187 West 10188 West 10189 North 10100 North 10191 South 10192 West 10193 East 10104 West 10195 West 10195 North 10197 West 10198 West 10199 South 10200 South 10201 North 10202 South 10203 East 10204 North 10205 South 10206 South 10207 East 10208 West 10209 West 10210 East 10211 South Credit Credit Credit Paypal Paypal Paypal Paypal Paypal Credit Credit Credit Paypal Paypal Paypal Paypal Credit Paypal Credit Credit Credit Paypal Credit Paypal Credit Credit Paypal Credit Credit Credit Crede 67165323 55081583 5022125 25679000 35078468 75772225 25433486 65056232 96077043 6830003 92733708 17567620 95291830 49471722 TOBIAS 44142213 69832322 54284580 69967343 70032816 74082072 92299116 33160396 22141389 43297905 72307242 6613185 71759916 551020 25266837 Wieb Wieb Web 11:27 19-18 3.00 Web 17 27 Email 15.09 0.00 Web TOT Web Web Web $19 37 Book $19.17 DVD $241.77 Book $19.65 Bock $19.88 Bock $15.18 DVD $15 08 Book $23.74 Book $19.44 Book $17.70 DVD $16.99 DVD $16.13 Book $24.80 DVD $1752 Book $23.63 Book $23.03 DVD $21.03 DVD $21.88 Bock $24. Book $21.43 DVD $16.32 DVD $17.20 DVD $17.87 DVD $17 27 OVD $19.78 Book $17.10 Book $15.66 Book $2237 Bock $15.81 DVD $18.75 DVD $192.41 Book 5242 52 Book $20 40 Bock $24.71 DVD $21.49 DVD $2220 DVD $2239 Book $21.01 Book $220.15 Bock $20 57 Book $21.72 DVD 516 3 Bock $19.19 Book $19.21 DVD $18.00 Book $20.87 DVD $15.33 DVD $23.58 DVD $15.34 Book $216.20 Boch 1215 DVD $9044 21:13 5.05 11:18 16:21 12-26 202 10213 South Credit Credit Credit 55140815 COURO Email Web 0:00 1245 CO 10217 West Credit 8:08 10219 East 10220 West 19-27 71026084 86140667 9780596S 40197352 43741856 7816031 5045939 1615142 16575164 96323938 77226031 1077 85174502 7335370 104OTTA Email Credit Credit 1428 $161.46 Bock $19.00 OVO 10241 East 10242 East 5243 TO W 3210 38 OOR MacBook Pro Page ( 4 ) of Email Email Web 16.15 8.06 20:34 3.03 12-41 3.03 1255 28911817 36561487 71502183 54077093 92266350 60490288 72701137 32435141 4130352 17689891 67182932 97950489 50561220 70759248 77616151 79551499 90656731 33909737 63841931 Web Email Email Web Web Email Email 202 Web Emai Web Web Web Web 10244 West Paypal 10245 South Credit 10246 West Credit 10247 West Credit 10248 West Paypal 10249 West Paypal 10250 North Paypal 10251 South Paypal 10252 North Credit 10253 East Credit 10254 East Credin 10255 West Credit 10256 West Paypal 10257 East Credit 10258 North Paypal 10259 South Paypal 1020 East Credit 10261 East Paypal 1022 West Credit 1023 South Credit 10254 South Credit 10265 West Credit 10266 West Paypal 10257 West Paypal 10258 East Credit 10269 North Paypal 10270 East 10271 North Credit 10272 E Credit 10273 South Credit 10274 West 10275 West 10278 West Paypal 10277 south Credit 10278 South 10279 West 10280 South Credit 10981 West 102 South 10283 South 10254 fouth Paypal 14.04 17-19 11:52 12:36 0.00 17.14 10:36 21:59 8:08 303 11:43 10-15 15 18 20.39 Web Web $161.50 Book $21.92 DVD $23.75 DVD $23.74 DVD $21.67 Book $2204 Book $17.83 DVD $23.50 Book $19.90 Book $209.20 Book $24 Book $17.81 Book $24.77 DVD $21 DVD $191.43 Book $24.52 DVD 517 34 DVD $17.19 Book $2255 Book $15.35 DVD $23.20 Book $241.65 Book $242.40 Book 523 01 DVD $17.22 DVD $15.96 DVD $15.45 DVD $17.41 DVD $21.64 Book $157 86 Book $18.17 DVD $18.73 Bock $17 24 Book 391 DVD $22.12 Bock $15 25 DVD $24.77 Bock Web Web Email Web Email 81572757 70596149 95125045 10754185 BA506060 B631900 2701635 80034508 766771 CASTRO 5477 18066842 20240553 24796034 609PS 1:01 9.09 5.05 10:39 5:05 Web Web Web Email 498597 707457 8007514 77983153 Web 18 22 $20.33 DVD $16.90 Bock $16.47 Book $21.18 Back 315 $24.42 Book 56231568 4929039 65745301 18744208 10236 West 10287 West 10258 South Credit Paypal 7604140 92175770 32571506 Web 23.08 Bock $23.40 DVD $22.65 Book 12461 Book 118.57 Bock Emal Creat $12.13 Bock 3231.23 Bock MacBook Pro Page Web Web Emai Email Web Web Emai Web 10307 South 10308 West 10309 South 10310 North 10311 South 10312 West 10313 West 10314 South 10315 East 10316 East 10317 South 10318 West 10319 West 10320 North 10321 South 10322 West 10323 North 10324 South 10025 South 10325 East 10327 West 10328 South 106 South 10330 North 10331 West 10332 West 10333 East 10334 North Paypal Credit Credit Paypal Paypal Paypal Credit Credit Credit Credit Credit Credit Credit Credit Crede Credit Paypal Credit Credit Paypal Paypal Cred Credit 12677778 77758706 14512758 23076219 71350323 60396312 38530736 16039556 93053650 14150787 97279589 65882511 88066592 82643293 97730191 5688740 93504435 82961120 9123213 1472 85470735 Web Web Web Emai Email 20.25 1:01 101 20:19 4.04 20:54 11:48 21:19 9-09 9:09 16:23 0:00 17:37 404 1921 18.45 13:34 16:47 8:08 404 Web Email Web Web $21.36 DVD $21 83 Book $21.58 DVD $17.51 Book $23.29 DVD $18.35 Back $23.08 DVD $19.81 DVD $162 74 Book $16.88 DVD $23 31 Book $22.92 Book $22.84 DVD $16.97 DVD $189. 16 Book $2257 DVD $24.71 DVD $248 67 Book $2097 Book $19.83 Bock $19.00 Bock $16.52 Book $2231 Book $19.52 DVD $24,79 DVD $18.84 DVD $24.58 OVD $17.19 Book $19.65 Book $17.35 Book $22.92 DVD $18.81 DVD $20.08 Book $24.54 Beck 524 81 515 94 DVD $182 DVD Web Web Emai Email Emai Email Credit Credit Email 2.02 0.00 9.09 22:04 0:00 12-19 We SO228 15045216 91 31841597 60450143 43384272 65292790 7133291 30859 81921349 40237279 816746 Credit Paypal 10335 Sau 21:37 16:23 Credit 10338 North 1033 West 10340 West 10341 West 10142 West 10343 North Emai 1440 Email 10046 West 10347 East 10348 South $19.20 OVD $17.34 DVD $22.51 DVD 20.52 18-10 506 73200296 Emal $16.15 DVD 08126061 Web Email $2211 Book $18.41 DVD $17.08 DVD 2013 DVD $177 30 focs 515 7 DVD 315 54 517 50 OVO MacBook Pro Page 4 Web Web Web Web Web Web Web Email Web Web Email Web Web Web Web Web Web Web Email Email Email Web Web Web Email Email 13:52 16:04 16:14 18:39 6:06 14:38 4:04 12:35 14:00 20:29 18:38 9:09 0:00 10:43 18:33 8:08 13:40 21:27 11:41 14:32 6:06 9:09 0.00 18:09 8:08 22:41 20:26 0:00 17:46 16:11 16:14 7:07 17:07 19:16 7:07 8:08 22:37 9:09 15:07 15:03 20.02 17:57 19:37 0:00 8:08 0.00 20:15 18:39 11:25 $23.87 DVD $21.53 Book $19.64 DVD $18.27 Book $19.27 DVD $20.16 Book $15.59 DVD $16.34 DVD $199.18 Book $19.99 Book $18.44 DVD $23.75 Book $20.88 DVD $197.43 Book $20.32 Book $16.82 DVD $20.16 Book $16.79 Book $22.53 Book $21.68 Book $23.54 Book $17.67 DVD $22.79 Book $24.80 Book $15.27 Book $18.74 Book $16.47 DVD $18.11 DVD $20.73 DVD $21.64 DVD $17.38 Book $17.70 DVD $24.66 Book $24.24 DVD $19.79 Book $16.86 DVD $19.97 DVD $22.99 Book $153 83 Book $15.20 DVD $16.01 DVD $18.88 DVD $21.54 Book $24.11 Book $21.43 Book $24.80 DVD $19.76 DVD $23.97 DVD $19.96 DVD $18.19 Book $17 28 DVD $24.84 Book $16.32 Book $23.47 Beak $16.65 Book 10369 East Credit 80160243 10370 North Credit 70859272 10371 North Credit 41514905 10372 West Paypal 68986646 10373 West Credit 51423763 10374 North Credit 78615837 10375 West Credit 95641106 40892422 10376 South Paypal 10377 East Credit 70431710 10378 South Paypal 95673115 10379 North Credit 72527223 10380 West Credit 77577648 10381 West Credit 26849225 10382 South Credit 27508938 10383 West Credit 43095105 10384 South Credit 70978581 10385 West Paypal 72898757 10386 West Credit 56976893 10387 North Credit 35119351 10388 South Paypal 65437162 10389 North 70003314 10390 East Paypal 54664522 10391 West Credit 10325805 10392 East Paypal 28672617 10393 South Paypal 21364705 10394 West Credit 44719881 10395 West Credit 42164058 10396 West Paypal 68675115 10397 West Paypal 48712948 10398 West Credit 93152872 10399 East Credit 12824694 10400 West Credit 73484989 10401 West Credit 79418802 10402 West Credit 85598102 10403 South Paypal 81254753 10404 North Credit 97869460 10405 North Credit 19446725 10408 East Credit 12075708 10407 North Credit 8784524B 10408 South Credit 88351358 10409 West Credit 86741411 10410 West Paypal 85689748 10411 South Credit 39676844 10412 East Credit 59845402 10413 North Paypal 39287241 10414 North Crect 82025542 10415 West Credit 16550991 10416 North Credit 80278554 10417 North Credit 30257860 10418 West Credit 46744434 10419 East 10420 West 53795790 10421 South 75332091 10422 North 8319480S 10423 West Credit 10424 East 10425 North 10426 North 99361092 10427 West Paypal 39373058 Paypal 10429 West Credit 39142197 10430 East Credit Bal Web Web Web Web Web Web Web Web Email Web Web Web Web Web Web Web Web Web Web Web Web Web BOB Email Web Email Emai $16.60 Book $21.78 Book 14:14 14:47 14:38 20:13 $21.10 Book $169.79 Book Web 10440 South Credit 10441 North Paypal 10442 West Credit 10443 South Credit 10444 West Paypal 10445 West Credit 10446 East Credit 10447 North Credit 10448 North Credit 10449 North Credit 10450 West Credit 10451 West Credit 10452 North Paypal 10453 North Paypal 10454 West Credit 10455 South Credit 10456 East Credit 10457 West Paypal 10458 South Paypal 10459 South Paypal 10460 West Credit 10461 South Credit 10462 South Paypal 10463 East Credit 10464 West Credit 10465 West Credit 10466 East Credit 10467 South Credit 10468 South Credit 10469 North Paypal 10470 West Credit 10471 West Paypal 10472 North Credit 45/69254 94775848 98078573 48152632 44336631 74850396 85688947 83549993 62629771 76032910 78837536 61532595 50289683 56319779 26242351 80577738 81079401 17165782 90636722 43626259 61496170 16101751 55348039 50785284 92997267 30255549 85660114 43913307 47286881 62265606 63133211 24646414 65043803 Vov Email Web Email Web Web Web Web Web Web Email Web Web Web Web Web Web Web Web Web Web Web Web Web Email Web Email Web Email Email Email Web Web $23.88 DVD $17.76 Book $23.06 Book $18.87 Book $17.87 DVD $18.77 Book $18.60 DVD $152.27 Book $20.83 Book $21.47 Book $218.60 Book $163.37 Book $24.78 Book $17.01 Book $231.23 Book $22.57 DVD $24.16 DVD $20.68 Book $21.20 DVD $247.14 Book $19.10 Book $19.02 DVD $19.66 Book $168.10 Book $16.83 Book $23.89 Book $16.73 DVD $22.05 DVD $17.88 Book $15.18 DVD $15.62 DVD $20.58 DVD 3:03 14:37 11:57 16:33 16:11 15:09 0.00 6:06 16:46 17:52 12:33 16:55 21:56 7:07 20:26 15:02 11:02 21:51 7:07 17:16 13:04 22.07 1:01 16:22 8.08 0:00 19:20 10:27 6:06 19:25 3:03 18:02
