Travel Expenses

Create a visual basic application that calculates and displays the total travel expenses for a business trip. The user must provide the following information:

•             Number of days on the trip

•             Amount of airfare, if any

 •            Amount paid for meals, if any

•             Amount of car rental fees, if any

•             Number of miles driven, if a private vehicle was used

 •            Amount of parking fees, if any

•             Amount of taxi charges, if any

•             Conference or seminar registration fees, if any

•             Lodging charges, per night

 

The company reimburses travel expenses according to the following policy:

•             $37 per day for meals

•             Parking fees, up to $10.00 per day

•             Taxi charges up to $20.00 per day

•             Lodging charges up to $95.00 per day

•             If a private vehicle is used, $0.27 per mile driven

The application should calculate and display the following:

•             Total expenses incurred by the business person

•             The total allowable expenses for the trip

•             The excess that must be paid by the business person, if any

•             The amount saved by the business person if the expenses were under the total allowed

 

The application should have the following functions:

CalcMeals - Calculates and returns the amount reimbursed for meals.

CalcMileage- Calculates and returns the amount reimbursed for mileage driven in a private vehicle

CalcParkingFees - Calculates and returns the amount reimbursed for parking fees.

CalcTaxiFees - Calculates and returns the amount reimbursed for taxi charges.

CalcLodging - Calculates and returns the amount reimbursed for lodging.

CalcTotalReimbursement - Calculates and returns the total amount reimbursed.

CalcUnallowed- Calculates and returns the total amount of expenses that are not allowable, if any. These are parking fees that exceed $10.00 per day, taxi charges that exceed $20.00 per day, and lodging charges that exceed $95.00 per day.

CalcSaved- Calculates and returns the total amount of expenses under the allowable amount, if any. For example, the allowable amount for lodging is $95.00 per day. If a business person stayed in a hotel for $85.00 per day for five days, the savings would be $50.00.

 

Input validation: Do not accept negative numbers for any dollar amount or for miles driven in a private vehicle. Do not accept numbers less than 1 for the number of days.

 

Days = 2

Vehicle Miles = 10 

Airfare = 700

Car Rental = 100

Park = 100

Taxi = 10

Registration = 100

Lodging per night = 100

 

 

The calculated output should be:

 

Expenses = $1310.00

Reimburment = $206.70

Exceeds (unallowed) = $106.00

Savings = $120.00