Microsoft Excel Assignment 1
paecaeryloe
SC_EX19_EOM1-2_ToddWashington_1.xlsxDocumentation
| Shelly Cashman Excel 2019 | Module 1: End of Module Project 2 | |
| RetailPro | |
| COMPLETE A TRAVEL EXPENSE WORKSHEET | |
| Author: | Todd Washington |
| Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website. | |
Travel Expenses
| Travel Expense Statement | |||||||
| Current mileage rate: | $ 0.55 | ||||||
| Name: | Martin Hernandez | ||||||
| Employee ID: | B10-M82 | ||||||
| Department: | Operations | ||||||
| From: | 5/3/21 | ||||||
| To: | 5/7/21 | ||||||
| Date | Trip Description | Miles Driven | Mileage Expense | Hotel | Meals | Incidentals | Total |
| 5/3/21 | QMarket stores in Deer Park | 0.00 | 12.50 | 0.00 | 12.50 | ||
| 5/4/21 | Southwright stores in Arlington | 20 | 312.25 | 67.78 | 24.00 | 404.03 | |
| Circle Ranch main office | 25 | 0.00 | 0.00 | 36.25 | 36.25 | ||
| 5/7/21 | Circle Ranch stores Baytown | 15 | 0.00 | 15.25 | 0.00 | 15.25 | |
| 5/7/21 | RetailPro headquarters | 80 | 0.00 | 47.50 | 32.00 | 79.50 | |
| 5/6/21 | Retail conference | 24 | 135.00 | 24.32 | 120.00 | 279.32 | |
| Totals | |||||||
| Approved by: |
Travel Expenses
Mileage Expense Hotel Meals Incidentals
