Excel Capstone INSS 141
Jocra6
exploring_ecap_grader_h1_Trips1.xlsxLookup Tables
| Base Price | Commission | Package | Tour Description | Departure | Base Cost | |
| $1,699 | 2.5% | 10 | Adventures in Canada | 6/11/16 | $1,699.00 | |
| $1,749 | 3.0% | 20 | Check Out the Czech Republic! | 6/4/16 | $1,799.00 | |
| $1,799 | 3.5% | 30 | Croatian Wonders | 6/11/16 | $1,899.00 | |
| $1,849 | 4.0% | 40 | Live it Up London | 6/18/16 | $1,699.00 | |
| $1,899 | 4.5% | 50 | Parisian Pleasures | 6/25/16 | $1,749.00 | |
| 60 | Roaming Rome | 6/11/16 | $1,849.00 | |||
| 70 | Viva España | 6/25/16 | $1,799.00 |
Data
| European Excursions | ||||||||
| Agent Sales and Commissions | ||||||||
| Input Area | Summary Statistics | |||||||
| Taxes and Fees | 20% | Total for all trips: | ||||||
| Loan APR | 7% | Average trip cost: | ||||||
| Months Per Year | 12 | Median trip cost: | ||||||
| Total Payments | 3 | Lowest cost: | ||||||
| Highest cost: | ||||||||
| Today's date: | ||||||||
| Agent Name | Student ID | Tour Code | Trip Description | Departure Date | Base Cost of Trip | Total Cost with Taxes | Student Payment Plan | Agent Commission |
| Avery | 10001 | 20 | ||||||
| Collins | 10002 | 30 | ||||||
| Avery | 10003 | 10 | ||||||
| McDonnough | 10004 | 50 | ||||||
| Ross | 10005 | 60 | ||||||
| Shannon | 10006 | 70 | ||||||
| Collins | 10007 | 10 | ||||||
| Ross | 10008 | 40 | ||||||
| McDonnough | 10009 | 50 | ||||||
| Ross | 10010 | 60 | ||||||
Summary
| 2016 Total Sales by Agent January - June | ||||||||
| January | February | March | April | May | June | Trends | Bonus | |
| Avery | $ 3,671 | $ 2,973 | $ 4,017 | $ 5,040 | $ 4,963 | $ 5,497 | ||
| Collins | $ 1,549 | $ 992 | $ 2,267 | $ 3,201 | $ 4,008 | $ 3,798 | ||
| Kinsley | $ 2,996 | $ 6,948 | $ 4,205 | $ 5,523 | $ 6,597 | $ 5,147 | ||
| McDonnough | $ 2,003 | $ 4,190 | $ 3,496 | $ 1,975 | $ 2,936 | $ 3,498 | ||
| Ross | $ 4,038 | $ 2,064 | $ 7,015 | $ 6,832 | $ 5,971 | $ 5,497 | ||
| Shannon | $ 1,172 | $ 866 | $ 2,109 | $ 3,385 | $ 4,078 | $ 3,598 | ||
| Bonus | $ 500 |
