Exp22_Excel_Ch12_CumulativeAssessment_Business_Travel_Budget
paull222
EXP22_Excel_Ch12_Cumulative_Budget.xltxBusiness Trip Budget
| Business Trip Budget | ||||||
| Target trip budget | $2,500.00 | $2,369.36 | ||||
| Total cost of the trip | $2,369.36 | $2,500.00 | ||||
| You're under budget by | $130.64 | |||||
| Item | Description | Cost | Qty | Amount | Notes | |
| Airfare | Tickets | $300.00 | 1 | $300.00 | ||
| Airfare | Tickets | $350.00 | 1 | $350.00 | ||
| Hotel | Room | $125.00 | 3 | $375.00 | ||
| Hotel | Room | $150.00 | 3 | $450.00 | ||
| Car rental | Cost per day | $52.00 | 6 | $312.00 | ||
| Gas | Cost per gallon | $1.74 | 14 | $24.36 | ||
| Entertainment | Amount | $130.00 | 1 | $130.00 | ||
| Gifts | Amount | $85.00 | 1 | $85.00 | ||
| Miscellaneous | Amount | $55.00 | 1 | $55.00 | ||
| Food | Cost per day | $48.00 | 6 | $288.00 | ||
| Total | $2,369.36 |
2369.3599999999997 2500
