please solve this with steps shown . i will make sure u get thumbs up thanks

just make sure its right and so that i can do same on my excel sheet . plz thanks

plz explain

Travel Agency Revenue sheet 612 313 LOCATION TRAVEL AGENT 21 815 19 412 21 814 21 815 19 212 17 406 21 814 19 612 19 612 17 713 19 512 19 19 212 19 612 19 312 14 311 21 814 21 145 21 815 17 111 17 14 415 19 412 14 916 14 19 312 17 313 17 293 17 293 19 412 17 713 19 612 14 23 704 17 406 19 512 17 313 21 815 21 467 21 815 21 21 606 14 916 14 415 14 311 CRUISE LINE Fant-X-TC Excalibur Bahama Lines Away-From-I-AI Canadian Cruises Royal Dutch Pacific Destiny Streamers Excalibur Bahama Lines Pacific Destiny Pacific Destiny Royal Dutch Excalibur Streamers Excalibur Bahama Lines Streamers Bahama Lines Excalibur Away-From-il-All Streamers Streamers Streamers Excalibur Royal Dutch Royal Dutch Streamers Away From-It-All Royal Dutch Excalibur Pacific Destiny Canadian Cruises Bahama Lines Bahama Lines Streamers Away-From-It-All Canadian Cruises Pacific Destiny Bahama Lines Royal Dutch Bahama Lines Excalibur Excalibur Bahama Lines TOTAL PACKAGE PRICE $6,300 $2,825 $2,325 $1,775 $4.250 $1,850 $2,525 $7.875 $1,650 $3,150 $1.950 $2,150 $2.925 $2,375 $2.975 $2.000 $4,350 $10,000 $8.500 $2,275 $1,200 $4.775 $3,100 $1,475 $4,375 $675 $4,200 $2,475 $900 $1,300 $2,000 $1,775 $8.500 $1,400 $3,075 $8.500 $2,400 $6,300 $19.000 $3,350 $4,750 $9,700 $2,000 $1,725 $1,900 COMMISSION $500 $200 $285 $200 $325 $79 $250 $560 $95 $185 $100 $150 $175 $100 $150 $98 $240 $550 $500 $175 $120 $400 $175 $65 $425 $74 $650 $155 $90 $75 $125 $105 $450 $75 $123 $750 $225 $650 $789 $175 $300 $700 $90 $75 $145 311 415 815 $75 14 21 19 17 21 14 23 19 17 17 17 14 19 19 21 17 17 21 17 17 21 17 21 17 21 21 23 21 19 17 14 21 14 19 21 21 21 17 21 19 14 19 21 21 21 23 17 17 14 14 311 814 412 406 813 916 702 212 313 406 313 415 512 612 467 406 313 467 406 111 719 293 814 293 815 145 703 814 212 111 415 815 916 312 606 815 467 111 Streamers Excalibur Excalibur Streamers Pacific Destiny Pacific Destiny Equatorial Easy Canadian Cruises Away-From-I-A Royal Dutch Canadian Cruises Away-From-It All Pacific Destiny Streamers Pacific Destiny Bahama Lines Bahama Lines Pacific Destiny Pacific Destiny Excalibur Fant-X-Tic Pacific Destiny Away-From-It-All Canadian Cruises Pacific Destiny Bahama Lines Pacific Destiny Streamers Royal Dutch Excalibur Canadian Cruises Bahama Lines Pacific Destiny Pacific Destiny Canadian Cruises Royal Dutch Fant-X-Tic Excalibur Canadian Cruises Fant-X-Tic Streamers Streamers Pacific Destiny Bahama Lines Streamers Equatorial Easy Excalibur Pacific Destiny Streamers Away-From-I-AB $1,925 $2,775 $2,975 $2,975 $4,700 $2,400 $4,750 $2,400 $2,025 $2,900 $2,675 $1,200 $2,375 $2.400 $3,350 $2,800 $1,975 $8,500 $1,625 $2,150 $1.975 $2,475 $10,000 $2,350 $8,500 $2,375 $2,400 $8,500 $2,150 $4,575 $2,775 $8,500 $1,900 $1,500 $3,350 $4,675 $2,400 $1,900 $4,000 $1,325 $675 $2,250 $3,925 $4,700 $4,700 $1,675 $2,000 $2,400 $1,850 $2,400 $350 $225 $212 $240 $130 $650 $175 $175 $155 $135 $89 $95 $150 $175 $124 $108 $350 $145 $215 $155 $258 $420 $126 $850 $200 $175 $350 $250 $325 $135 $425 $85 815 512 415 612 815 606 467 702 111 313 415 311 $75 $400 $240 $175 $99 $350 $85 $64 $130 $175 $240 $275 $115 $100 $300 $80 $300 21 21 21 19 21 14 14 19 17 21 21 14 14 19 14 21 17 19 17 21 14 14 21 815 606 145 312 815 311 415 312 293 467 815 415 916 212 415 815 293 512 293 815 415 415 467 293 467 814 813 313 512 512 311 293 702 815 813 815 212 512 212 21 21 21 17 19 19 14 17 23 21 21 21 19 19 19 21 17 23 21 21 21 17 21 17 21 19 Away-From-I-A Canadian Cruises Bahama Lines Pacific Destiny Excalibur Away-From-I-AI Streamers Away-From-I-A Bahama Lines Royal Dutch Bahama Lines Bahama Lines Away-From-I-AI Pacific Destiny Streamers Pacific Destiny Away From-I-A Away-From-It-Al Excalibur Excalibur Canadian Cruises Excalibur Fant-X-Tic Pacific Destiny Bahama Lines Royal Dutch Bahama Lines Pacific Destiny Bahama Lines Canadian Cruises Bahama Lines Pacific Destiny Equatorial Easy Bahama Lines Away-From-I-A Streamers Pacific Destiny Canadian Cruises Pacific Destiny Fant-X-TC Excalibur Canadian Cruises Royal Dutch Pacific Destiny Royal Dutch Royal Dutch Excalibur Streamers Excalibur Excalibur $5,250 $10,000 $10,000 $8,500 $6,300 $4,250 $4,550 $3.575 $2,400 $3,050 $4.900 $1.950 $2,375 $2,400 $2,375 $4,250 $2.100 $650 $1,000 $4,000 $2.150 $1,650 $2.900 $2.775 $5.250 $10,000 $8.500 $3.150 $1,000 $1,175 $2,400 $1,900 $1,950 $1,575 $1,975 $4,750 $8,500 $3,175 $3,450 $4,600 $2,400 $8,500 $6,300 $4.100 $6,300 $8,500 $10,000 $2,400 $2,900 $6,775 $325 $465 $650 $1,100 $525 $200 $450 $315 $120 $155 $225 $120 $140 $200 $90 $175 $86 $79 $85 $150 $90 $75 $120 $120 $375 $358 $350 $145 $85 $98 $150 $100 $175 $100 $200 $400 $500 $145 $320 $275 $125 $450 $400 $275 $370 $450 $600 $205 $150 $800 467 111 704 813 815 815 313 815 293 815 212 293 713 703 916 702 212 467 313 815 17 17 23 14 23 19 21 17 21 19 23 23 23 17 17 23 17 19 21 14 19 14 14 19 21 14 23 21 17 21 14 21 19 23 21 17 19 21 17 21 17 17 21 19 14 21 17 21 21 17 212 701 702 704 293 313 704 713 612 467 415 612 415 415 412 815 415 702 814 406 815 311 467 512 702 815 713 412 813 293 814 713 406 815 512 311 606 406 815 606 406 Excalibur Bahama Lines Canadian Cruises Pacific Destiny Equatorial Easy Bahama Lines Streamers Fant-X-TC Fant-X-TC Canadian Cruises Canadian Cruises Equatorial Easy Streamers Royal Dutch Fant-X-Tic Pacific Destiny Excalibur Excalibur Royal Dutch Streamers Canadian Cruises Excalibur Canadian Cruises Streamers Canadian Cruises Bahama Lines Equatorial Easy Royal Dutch Royal Dutch Excalibur Canadian Cruises Bahama Lines Fant-X-Tic Equatorial Easy Excalibur Bahama Lines Streamers Canadian Cruises Excalibur Royal Dutch Bahama Lines Away-From-It-All Fant-X-Tic Canadian Cruises Bahama Lines Bahama Lines Streamers Away-From-It-All Streamers Bahama Lines $2,800 $1,975 $8,500 $1,900 $2,150 $1.425 $3,100 $2,000 $2,925 $2,450 $2,400 $3.975 $21,000 $675 $2,900 $500 $2.100 $1.950 $2,900 $7.575 $2,000 $2,450 $2,350 $1,975 $4.775 $1,900 $1.900 $6,300 $2.900 $7,000 $1,275 $4,125 $3.150 $3,150 $8,475 $3,000 $3,475 $2,375 $2,375 $975 $2,765 $3,125 $4,700 $1,800 $1,200 $3.000 $8,500 $4,700 $2,000 $8,500 $320 $125 $350 $170 $115 $75 $155 $86 $215 $250 $95 $335 $825 $69 $155 $78 $115 $100 $180 $350 $98 $185 $115 $75 $250 $165 $76 $275 $125 $325 $89 $289 $150 $225 $600 $225 $150 $180 $123 $50 $150 $200 $800 $200 $55 $250 $554 $350 $200 $725 17 17 17 19 19 14 19 19 14 17 21 21 19 14 21 23 21 19 21 19 17 21 19 21 19 111 313 713 312 512 311 412 312 415 293 467 815 412 311 814 702 719 312 813 412 713 606 312 815 612 415 415 Royal Dutch Streamers Excalibur Royal Dutch Excalibur Pacific Destiny Pacific Destiny Away-From-il-All Excalibur Pacific Destiny Royal Dutch Away From-It-All Pacific Destiny Excalibur Excalibur Equatorial Easy Fant-X-Tic Bahama Lines Royal Dutch Streamers Pacific Destiny Bahama Lines Fant-X-Tic Excalibur Away From-I-A Excalibur Away-From-It-All Royal Dutch Canadian Cruises Excalibur Away-From-It-All Canadian Cruises Streamers Streamers Royal Dutch Royal Dutch Royal Dutch Streamers Royal Dutch Pacific Destiny Bahama Lines Royal Dutch Bahama Lines Royal Dutch Canadian Cruises Streamers Streamers Excalibur Streamers Royal Dutch $2,400 $2,475 $2,400 $2.400 $1,150 $8,500 $2,975 $900 $1,000 $1,200 $5,100 $4,400 $4,275 $1.000 $9.700 $4,550 $1,500 $1,900 $2,125 $3,000 $975 $4,700 $1.200 $3,350 $6,250 $1,250 $1,900 $4,300 $2,875 $1.100 $1,950 $4,000 $2,400 $1,450 $4,700 $6,300 $975 $2,175 $1.975 $2.650 $2,400 $2,400 $10,000 $10,000 $1.675 $5,000 $8,500 $4,350 $3,350 $2,400 $107 $155 $300 $150 $100 $500 $175 $45 $100 $99 $222 $425 $185 $50 $700 $235 $200 $70 $125 $250 $65 $250 $75 $175 $375 $89 $145 $250 $185 $90 $135 $275 $98 $65 $650 $450 $64 $200 $75 14 17 21 815 415 313 916 612 704 606 815 406 412 704 17 14 19 23 21 21 17 19 23 19 17 19 21 21 14 17 21 21 21 14 $200 412 713 512 B15 606 313 145 145 815 415 $205 $100 $850 $500 $150 $275 $650 $250 $150 $140 313 815 415 293 612 312 145 406 406 702 916 145 17 21 14 17 19 19 21 17 17 23 14 21 17 21 21 21 21 19 17 23 17 17 19 21 17 14 21 19 21 21 23 21 17 21 19 14 17 21 19 23 21 17 19 14 17 21 21 21 17 14 111 815 815 815 815 312 313 702 313 313 612 813 406 415 606 612 145 813 704 606 293 606 212 916 293 815 Royal Dutch Royal Dutch Bahama Lines Fant-X-Tic Streamers Canadian Cruises Away-From-I-A Royal Dutch Pacific Destiny Equatorial Easy Canadian Cruises Bahama Lines Royal Dutch Fant-X-TC Canadian Cruises Bahama Lines Streamers Bahama Lines Pacific Destiny Equatorial Easy Canadian Cruises Royal Dutch Royal Dutch Pacific Destiny Royal Dutch Canadian Cruises Pacific Destiny Bahama Lines Away-From-It-All Excalibur Pacific Destiny Pacific Destiny Streamers Royal Dutch Bahama Lines Excalibur Away-From-It-All Fant-X-Tic Excalibur Equatorial Easy Pacific Destiny Streamers Bahama Lines Fant-X-Tic Canadian Cruises Bahama Lines Pacific Destiny Away-From-It-All Bahama Lines Excalibur $4,100 $9,375 $775 $1,475 $1,925 $2,400 $1,675 $2,500 $2,075 $8,500 $3,575 $4,250 $2,000 $10,000 $3,350 $5,125 $2,900 $1,225 $3,100 $4,675 $8,500 $1,975 $1,500 $4,700 $2,675 $2,000 $6,300 $2,325 $3,150 $4,000 $6,275 $2,900 $2,925 $10,000 $4,000 $8,500 $2,400 $3,300 $1.450 $2,775 $10,000 $475 $2,900 $2.475 $1,975 $6,250 $8,500 $10,000 $3,275 $8,500 $175 $1,100 $64 $84 $85 $175 $98 $208 $115 $325 $180 $165 $112 $1,000 $350 $230 $170 $75 $185 $450 $785 $200 $100 $200 $185 $165 $650 $130 $175 $300 $400 $125 $245 $600 $200 $500 $176 $185 $56 $165 $500 $44 $285 $250 $200 $275 $650 $350 $180 $600 612 702 815 713 412 415 293 815 815 606 313 311 2. Add one additional column to calculate the revenue after commission is deducted from total package price. 3. Create pivot tables to help you answer the following questions: a. Design a table that shows total revenue generated by each destination. Which destination brings in the most revenue? b. Design a table that shows the total revenue generated by each travel agent. Who is the best employee (travel agent)? c. Design a table that shows which cruise line is the most valuable for the travel agency. d. Design a table that calculates the total revenue by travel agent, location, and cruise line. Which location on which line bring in the most revenue, and which agent is involved in that business? e. Provide a table that shows which agent earns the highest average commission for Bahama lines. Travel Agency Revenue sheet 612 313 LOCATION TRAVEL AGENT 21 815 19 412 21 814 21 815 19 212 17 406 21 814 19 612 19 612 17 713 19 512 19 19 212 19 612 19 312 14 311 21 814 21 145 21 815 17 111 17 14 415 19 412 14 916 14 19 312 17 313 17 293 17 293 19 412 17 713 19 612 14 23 704 17 406 19 512 17 313 21 815 21 467 21 815 21 21 606 14 916 14 415 14 311 CRUISE LINE Fant-X-TC Excalibur Bahama Lines Away-From-I-AI Canadian Cruises Royal Dutch Pacific Destiny Streamers Excalibur Bahama Lines Pacific Destiny Pacific Destiny Royal Dutch Excalibur Streamers Excalibur Bahama Lines Streamers Bahama Lines Excalibur Away-From-il-All Streamers Streamers Streamers Excalibur Royal Dutch Royal Dutch Streamers Away From-It-All Royal Dutch Excalibur Pacific Destiny Canadian Cruises Bahama Lines Bahama Lines Streamers Away-From-It-All Canadian Cruises Pacific Destiny Bahama Lines Royal Dutch Bahama Lines Excalibur Excalibur Bahama Lines TOTAL PACKAGE PRICE $6,300 $2,825 $2,325 $1,775 $4.250 $1,850 $2,525 $7.875 $1,650 $3,150 $1.950 $2,150 $2.925 $2,375 $2.975 $2.000 $4,350 $10,000 $8.500 $2,275 $1,200 $4.775 $3,100 $1,475 $4,375 $675 $4,200 $2,475 $900 $1,300 $2,000 $1,775 $8.500 $1,400 $3,075 $8.500 $2,400 $6,300 $19.000 $3,350 $4,750 $9,700 $2,000 $1,725 $1,900 COMMISSION $500 $200 $285 $200 $325 $79 $250 $560 $95 $185 $100 $150 $175 $100 $150 $98 $240 $550 $500 $175 $120 $400 $175 $65 $425 $74 $650 $155 $90 $75 $125 $105 $450 $75 $123 $750 $225 $650 $789 $175 $300 $700 $90 $75 $145 311 415 815 $75 14 21 19 17 21 14 23 19 17 17 17 14 19 19 21 17 17 21 17 17 21 17 21 17 21 21 23 21 19 17 14 21 14 19 21 21 21 17 21 19 14 19 21 21 21 23 17 17 14 14 311 814 412 406 813 916 702 212 313 406 313 415 512 612 467 406 313 467 406 111 719 293 814 293 815 145 703 814 212 111 415 815 916 312 606 815 467 111 Streamers Excalibur Excalibur Streamers Pacific Destiny Pacific Destiny Equatorial Easy Canadian Cruises Away-From-I-A Royal Dutch Canadian Cruises Away-From-It All Pacific Destiny Streamers Pacific Destiny Bahama Lines Bahama Lines Pacific Destiny Pacific Destiny Excalibur Fant-X-Tic Pacific Destiny Away-From-It-All Canadian Cruises Pacific Destiny Bahama Lines Pacific Destiny Streamers Royal Dutch Excalibur Canadian Cruises Bahama Lines Pacific Destiny Pacific Destiny Canadian Cruises Royal Dutch Fant-X-Tic Excalibur Canadian Cruises Fant-X-Tic Streamers Streamers Pacific Destiny Bahama Lines Streamers Equatorial Easy Excalibur Pacific Destiny Streamers Away-From-I-AB $1,925 $2,775 $2,975 $2,975 $4,700 $2,400 $4,750 $2,400 $2,025 $2,900 $2,675 $1,200 $2,375 $2.400 $3,350 $2,800 $1,975 $8,500 $1,625 $2,150 $1.975 $2,475 $10,000 $2,350 $8,500 $2,375 $2,400 $8,500 $2,150 $4,575 $2,775 $8,500 $1,900 $1,500 $3,350 $4,675 $2,400 $1,900 $4,000 $1,325 $675 $2,250 $3,925 $4,700 $4,700 $1,675 $2,000 $2,400 $1,850 $2,400 $350 $225 $212 $240 $130 $650 $175 $175 $155 $135 $89 $95 $150 $175 $124 $108 $350 $145 $215 $155 $258 $420 $126 $850 $200 $175 $350 $250 $325 $135 $425 $85 815 512 415 612 815 606 467 702 111 313 415 311 $75 $400 $240 $175 $99 $350 $85 $64 $130 $175 $240 $275 $115 $100 $300 $80 $300 21 21 21 19 21 14 14 19 17 21 21 14 14 19 14 21 17 19 17 21 14 14 21 815 606 145 312 815 311 415 312 293 467 815 415 916 212 415 815 293 512 293 815 415 415 467 293 467 814 813 313 512 512 311 293 702 815 813 815 212 512 212 21 21 21 17 19 19 14 17 23 21 21 21 19 19 19 21 17 23 21 21 21 17 21 17 21 19 Away-From-I-A Canadian Cruises Bahama Lines Pacific Destiny Excalibur Away-From-I-AI Streamers Away-From-I-A Bahama Lines Royal Dutch Bahama Lines Bahama Lines Away-From-I-AI Pacific Destiny Streamers Pacific Destiny Away From-I-A Away-From-It-Al Excalibur Excalibur Canadian Cruises Excalibur Fant-X-Tic Pacific Destiny Bahama Lines Royal Dutch Bahama Lines Pacific Destiny Bahama Lines Canadian Cruises Bahama Lines Pacific Destiny Equatorial Easy Bahama Lines Away-From-I-A Streamers Pacific Destiny Canadian Cruises Pacific Destiny Fant-X-TC Excalibur Canadian Cruises Royal Dutch Pacific Destiny Royal Dutch Royal Dutch Excalibur Streamers Excalibur Excalibur $5,250 $10,000 $10,000 $8,500 $6,300 $4,250 $4,550 $3.575 $2,400 $3,050 $4.900 $1.950 $2,375 $2,400 $2,375 $4,250 $2.100 $650 $1,000 $4,000 $2.150 $1,650 $2.900 $2.775 $5.250 $10,000 $8.500 $3.150 $1,000 $1,175 $2,400 $1,900 $1,950 $1,575 $1,975 $4,750 $8,500 $3,175 $3,450 $4,600 $2,400 $8,500 $6,300 $4.100 $6,300 $8,500 $10,000 $2,400 $2,900 $6,775 $325 $465 $650 $1,100 $525 $200 $450 $315 $120 $155 $225 $120 $140 $200 $90 $175 $86 $79 $85 $150 $90 $75 $120 $120 $375 $358 $350 $145 $85 $98 $150 $100 $175 $100 $200 $400 $500 $145 $320 $275 $125 $450 $400 $275 $370 $450 $600 $205 $150 $800 467 111 704 813 815 815 313 815 293 815 212 293 713 703 916 702 212 467 313 815 17 17 23 14 23 19 21 17 21 19 23 23 23 17 17 23 17 19 21 14 19 14 14 19 21 14 23 21 17 21 14 21 19 23 21 17 19 21 17 21 17 17 21 19 14 21 17 21 21 17 212 701 702 704 293 313 704 713 612 467 415 612 415 415 412 815 415 702 814 406 815 311 467 512 702 815 713 412 813 293 814 713 406 815 512 311 606 406 815 606 406 Excalibur Bahama Lines Canadian Cruises Pacific Destiny Equatorial Easy Bahama Lines Streamers Fant-X-TC Fant-X-TC Canadian Cruises Canadian Cruises Equatorial Easy Streamers Royal Dutch Fant-X-Tic Pacific Destiny Excalibur Excalibur Royal Dutch Streamers Canadian Cruises Excalibur Canadian Cruises Streamers Canadian Cruises Bahama Lines Equatorial Easy Royal Dutch Royal Dutch Excalibur Canadian Cruises Bahama Lines Fant-X-Tic Equatorial Easy Excalibur Bahama Lines Streamers Canadian Cruises Excalibur Royal Dutch Bahama Lines Away-From-It-All Fant-X-Tic Canadian Cruises Bahama Lines Bahama Lines Streamers Away-From-It-All Streamers Bahama Lines $2,800 $1,975 $8,500 $1,900 $2,150 $1.425 $3,100 $2,000 $2,925 $2,450 $2,400 $3.975 $21,000 $675 $2,900 $500 $2.100 $1.950 $2,900 $7.575 $2,000 $2,450 $2,350 $1,975 $4.775 $1,900 $1.900 $6,300 $2.900 $7,000 $1,275 $4,125 $3.150 $3,150 $8,475 $3,000 $3,475 $2,375 $2,375 $975 $2,765 $3,125 $4,700 $1,800 $1,200 $3.000 $8,500 $4,700 $2,000 $8,500 $320 $125 $350 $170 $115 $75 $155 $86 $215 $250 $95 $335 $825 $69 $155 $78 $115 $100 $180 $350 $98 $185 $115 $75 $250 $165 $76 $275 $125 $325 $89 $289 $150 $225 $600 $225 $150 $180 $123 $50 $150 $200 $800 $200 $55 $250 $554 $350 $200 $725 17 17 17 19 19 14 19 19 14 17 21 21 19 14 21 23 21 19 21 19 17 21 19 21 19 111 313 713 312 512 311 412 312 415 293 467 815 412 311 814 702 719 312 813 412 713 606 312 815 612 415 415 Royal Dutch Streamers Excalibur Royal Dutch Excalibur Pacific Destiny Pacific Destiny Away-From-il-All Excalibur Pacific Destiny Royal Dutch Away From-It-All Pacific Destiny Excalibur Excalibur Equatorial Easy Fant-X-Tic Bahama Lines Royal Dutch Streamers Pacific Destiny Bahama Lines Fant-X-Tic Excalibur Away From-I-A Excalibur Away-From-It-All Royal Dutch Canadian Cruises Excalibur Away-From-It-All Canadian Cruises Streamers Streamers Royal Dutch Royal Dutch Royal Dutch Streamers Royal Dutch Pacific Destiny Bahama Lines Royal Dutch Bahama Lines Royal Dutch Canadian Cruises Streamers Streamers Excalibur Streamers Royal Dutch $2,400 $2,475 $2,400 $2.400 $1,150 $8,500 $2,975 $900 $1,000 $1,200 $5,100 $4,400 $4,275 $1.000 $9.700 $4,550 $1,500 $1,900 $2,125 $3,000 $975 $4,700 $1.200 $3,350 $6,250 $1,250 $1,900 $4,300 $2,875 $1.100 $1,950 $4,000 $2,400 $1,450 $4,700 $6,300 $975 $2,175 $1.975 $2.650 $2,400 $2,400 $10,000 $10,000 $1.675 $5,000 $8,500 $4,350 $3,350 $2,400 $107 $155 $300 $150 $100 $500 $175 $45 $100 $99 $222 $425 $185 $50 $700 $235 $200 $70 $125 $250 $65 $250 $75 $175 $375 $89 $145 $250 $185 $90 $135 $275 $98 $65 $650 $450 $64 $200 $75 14 17 21 815 415 313 916 612 704 606 815 406 412 704 17 14 19 23 21 21 17 19 23 19 17 19 21 21 14 17 21 21 21 14 $200 412 713 512 B15 606 313 145 145 815 415 $205 $100 $850 $500 $150 $275 $650 $250 $150 $140 313 815 415 293 612 312 145 406 406 702 916 145 17 21 14 17 19 19 21 17 17 23 14 21 17 21 21 21 21 19 17 23 17 17 19 21 17 14 21 19 21 21 23 21 17 21 19 14 17 21 19 23 21 17 19 14 17 21 21 21 17 14 111 815 815 815 815 312 313 702 313 313 612 813 406 415 606 612 145 813 704 606 293 606 212 916 293 815 Royal Dutch Royal Dutch Bahama Lines Fant-X-Tic Streamers Canadian Cruises Away-From-I-A Royal Dutch Pacific Destiny Equatorial Easy Canadian Cruises Bahama Lines Royal Dutch Fant-X-TC Canadian Cruises Bahama Lines Streamers Bahama Lines Pacific Destiny Equatorial Easy Canadian Cruises Royal Dutch Royal Dutch Pacific Destiny Royal Dutch Canadian Cruises Pacific Destiny Bahama Lines Away-From-It-All Excalibur Pacific Destiny Pacific Destiny Streamers Royal Dutch Bahama Lines Excalibur Away-From-It-All Fant-X-Tic Excalibur Equatorial Easy Pacific Destiny Streamers Bahama Lines Fant-X-Tic Canadian Cruises Bahama Lines Pacific Destiny Away-From-It-All Bahama Lines Excalibur $4,100 $9,375 $775 $1,475 $1,925 $2,400 $1,675 $2,500 $2,075 $8,500 $3,575 $4,250 $2,000 $10,000 $3,350 $5,125 $2,900 $1,225 $3,100 $4,675 $8,500 $1,975 $1,500 $4,700 $2,675 $2,000 $6,300 $2,325 $3,150 $4,000 $6,275 $2,900 $2,925 $10,000 $4,000 $8,500 $2,400 $3,300 $1.450 $2,775 $10,000 $475 $2,900 $2.475 $1,975 $6,250 $8,500 $10,000 $3,275 $8,500 $175 $1,100 $64 $84 $85 $175 $98 $208 $115 $325 $180 $165 $112 $1,000 $350 $230 $170 $75 $185 $450 $785 $200 $100 $200 $185 $165 $650 $130 $175 $300 $400 $125 $245 $600 $200 $500 $176 $185 $56 $165 $500 $44 $285 $250 $200 $275 $650 $350 $180 $600 612 702 815 713 412 415 293 815 815 606 313 311 2. Add one additional column to calculate the revenue after commission is deducted from total package price. 3. Create pivot tables to help you answer the following questions: a. Design a table that shows total revenue generated by each destination. Which destination brings in the most revenue? b. Design a table that shows the total revenue generated by each travel agent. Who is the best employee (travel agent)? c. Design a table that shows which cruise line is the most valuable for the travel agency. d. Design a table that calculates the total revenue by travel agent, location, and cruise line. Which location on which line bring in the most revenue, and which agent is involved in that business? e. Provide a table that shows which agent earns the highest average commission for Bahama lines