1) A firm is interested in developing a Decision Table to help sales managers manage their employee transportation expenses. Such a table will be used by the managers 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: Employee would submit monthly report indicating the mileage used for business. The firm will reimburse at $0.90 per mile. Purchase Alternative: Purchase 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 end of month) is $450. 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 36th 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 36th month). The lease contract does not allow you to buy the vehicle at the end of lease termination. Other Key Assumptions: EPA Estimate for fuel efficiency of the car considered = 22mpg combined. Average cost of Gasoline $2.50/gallon. Car wash & other miscellaneous maintenance charges ignore. 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. a) Present the results in a table similar to the one shown below. b) 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.