| Crazy Cars |
| Auto Sales and Commissions (Part-Time Staff) |
| | Salesperson | Car Description | Mileage | Purchase Date | Base Cost of Car | State Sales Tax | Total Cost with Tax | 48-month Payment Plan | Salesperson Commission
Rate |
| | Brown | 2003 Hybrid Sedan | 100,000 | 6/17/12 | $ 9,800.00 |
| | Brown | 2007 Hybrid Sedan | 25,000 | 6/10/12 | $ 21,800.00 |
| | Taylor | 2007 Hybrid Sport Utility | 36,000 | 6/10/12 | $ 21,500.00 |
| | Taylor | 2008 Hybrid Sport Utility | 25,000 | 6/17/12 | $ 40,700.00 |
| | Harris | 2007 Hybrid Sport Utility | 30,000 | 6/17/12 | $ 29,800.00 |
| | Harris | 2007 Sport Utility (SUV) | 36,000 | 6/24/12 | $ 22,800.00 |
| | Robinson | 2007 Minivan-LX | 30,000 | 6/10/12 | $ 23,400.00 |
| | Robinson | 2007 Minivan-EX | 40,000 | 6/24/12 | $ 25,800.00 |
| | Walker | 1998 Minivan-GL | 133,000 | 6/10/12 | $ 3,000.00 |
| | Walker | 2008 Minivan-LE | 24,000 | 6/24/12 | $ 23,900.00 |
| | King | 2007 Crossover-SE | 30,000 | 6/17/12 | $ 21,600.00 |
| | King | 2008 Crossover-SE | 25,000 | 6/24/12 | $ 21,900.00 |
| | | | | | Total for all sales: |
| | | | | | Average price: |
| | | Interest rate: | 6.25% | | Lowest price: |
| | | | | | Highest price: |
| Brown | | Lookup Table | | | Today's date: |
| Taylor | | 3000 | 0.01 | | Bonus: |
| Harris | | 10000 | 0.02 |
| Robinson | | 20000 | 0.025 |
| Walker | | 30000 | 0.03 |
| King | | 40000 | 0.035 |
MrsCook
excel4work.xlsx
