A firm is interested in developing a Decision Table to help sales managers manage their employee transportation expenses. Such a decision table will be used by the manager to determine whether an employee should be provided a new leased car, a new purchased car or pay the employee for miles used

The car considered for acquisition is well equipped 2016 Chevy Impala.It costs $40,000 to buy including tax, title and other miscellaneous admin fees.The car is expected to be replaced once in three years.Following three competing alternatives are being considered.The maintenance on the car is included

Employee Reimbursement: The sales person would submit monthly expense report indicated the mileage used for business. The firm will reimburse at $0.76 per mile.

Purchase Alternative: Purchase the car for $40,000 inclusive of sales tax, title fees, etc. The expected resale value of the car is $21,000 at the end of 3 years. The resale value will go down by $0.20 for every mile driven in excess of 36,000 miles. If the miles driven is less than 36,000 miles, the resale value will not go up.

Lease Alternative: Initial down payment including bank fee is $4,900. Lease term = 36 months. Monthly lease payment (payable beginning of month) is $600. Miles allowed is 36,000 over the 36-month lease period. Payment at lease termination is $2,000 to prepare the vehicle for sale to a different customer; the payment is due at the end of 36^th month. Charge for excess mileage is 70 cents per mile inclusive of taxes. The excess mileage charges are due to the dealership at the end of the lease term (end of 36^th month). The lease contract does not allow you to buy the vehicle at the end of lease termination.

You need to compute Present Value Cost of using the vehicle over a 3-year period for the above three mutually exclusive alternatives.Interest Rate is 9.00 percent /year Compounded Monthly.

Present the results in a table similar to the one shown below.

Show the results as line graphs with x-axis showing the miles driven and the y axis showing the monthly costs. Show cost as a positive number; it is ok to do that since we know that this problem is a cost only problem without any revenues.