excel Projects
bzbz93
np_excel2013_t1_p1a__1.xlsxDocumentation
| New Perspectives Excel 2013 | |
| Tutorial 1: SAM Project 1a | |
| Spring Software | |
| CREATE AN EXPENSE REPORT | |
| Author: | Fawaz Alomrani |
| 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. | |
Expenses by Salesperson
| Spring Software | |||
| Sales Team Expenses | |||
| April 1-30, 2016 | |||
| Sales | Total Expenses | Travel Expenses | Non-Travel Expenses |
| 853.98 | 687.06 | ||
| 2794.10 | 796.78 | ||
| 3324.28 | 994.24 | ||
| 883.79 | 758.55 | ||
| 2266.74 | 1087.19 | ||
| As of April 30, 2016 | |||
| * In April, Sales Team updated Travel Policy. | |||
Expenses Detail
| Spring Software | |||
| Sales Team Expenses | |||
| April 1-30, 2016 | |||
| Salesperson | Expense Amount | Expense Category | Code |
| Tori | 1.25 | Client Meeting | |
| Ken | 202.14 | Travel | |
| Raj | 2275.00 | Vendor | |
| Mona | 53.09 | Travel | |
| Mona | 1429.08 | Supplies | |
| Phillipe | 308.11 | Travel | |
| Ken | 98.88 | Client Meeting | |
| Tori | 758.55 | Travel | |
| Raj | 125.65 | Travel | |
| Ken | 484.92 | Travel | |
| Ken | 68.04 | Client Meeting | |
| Mona | 500.00 | Vendor | |
| Phillipe | 1126.53 | Vendor | |
| Raj | 868.59 | Travel | |
| Phillipe | Supplies | ||
| Mona | Travel | ||
| Mona | Travel | ||
| Mona | Supplies | ||
| Raj | Client Meeting | ||
| Phillipe | Travel | ||
