In this assignment, use the information from the previous unit's Individual Project to create an expanded worksheet with a summary area and a chart showing this summary area.
capocheers1
comp101_u4_expensereport.xls
Sheet1
|
|
| | | | | Expense Report |
| | | | | | | | | Allowance Per Miles | | | $0.40 |
| | | Meals | | | Transportation |
| Date | Description | Brkfast | Lunch | Dinner | Air | Ground | Lodging | Miles | Mileage $ | Phone | Entertain | Other | | Daily Totals |
| Thursday, March 15, 2007 | Conference in Texas | $6.00 | $12.00 | $23.50 | $550.00 | $50.00 | $100.00 | 50 | $ 20.00 | $4.00 | $10.00 | $5.00 | | $780.50 |
| Friday, March 16, 2007 | Meeting in Altona | $10.00 | $9.00 | $25.00 | $500.00 | $45.00 | $85.00 | 400 | $ 160.00 | $5.00 | $12.50 | $10.00 | | $861.50 |
| Saturday, March 17, 2007 | Meeting in Salem | $11.00 | $8.00 | $25.80 | $600.00 | $60.00 | $95.00 | 275 | $ 110.00 | $6.00 | $67.00 | $12.00 | | $994.80 |
| Sunday, March 18, 2007 | Meeting in Salem | $8.00 | $10.00 | $28.40 | $800.00 | $75.00 | $90.00 | 500 | $ 200.00 | $7.00 | $85.60 | $52.00 | | $1,356.00 |
| Monday, March 19, 2007 | Meeting in California | $15.00 | $12.00 | $40.50 | $1,000.00 | $78.00 | $100.00 | 236 | $ 94.40 | $5.50 | $90.00 | $89.00 | | $1,524.40 |
| | Category Totals | $50.00 | $51.00 | $143.20 | $3,450.00 | $308.00 | $470.00 | 1461 | $584.40 | $27.50 | $265.10 | $168.00 | | $5,517.20 |
