Reference no: EM132280610
Tarheel Limousine has a fleet of cars that it operates in the RDU area. It hires drivers for its cars on a monthly salary. The CEO wishes to determine how many drivers to employ in the next 5 months. Based on his forecast, the CEO believes he would need at least the following number of drivers:
February: 45 Drivers
March: 65 Drivers
April: 70 Drivers
May: 50 Drivers
June: 55 Drivers
At the beginning of each month, the company must decide how many drivers should be fired or hired. Tarheel Limousine incurs administrative costs of $500 to hire and train a driver and $300 to fire a driver. A driver’s salary is $3000 per month. At the beginn ing of February, Tarheel Limousine has 50 drivers.
A driver hired at the beginning of a month may be used to meet the current month’s requirements and is paid full salary for the current month. It is feasible (but expensive) to have too many drivers.
a) Formulate an LP to minimize Tarheel Limousine’s labor costs over the next five months.
b) Solve the LP in Excel and give the optimal solution. Explain in plain English what the CEO needs to do.
c) A labor organization believes that drivers who are fired need to be paid an extra $300 as compensation, i.e., the cost of firing increases from $300 to $600, of which $300 is paid to the fired worker. Now solve the LP in Excel assuming that the company pays each fired worker $300. How does the optimal solution you found in the previous part change? Will the total labor cost increase under the labor organization’s plan? Will the total compensation paid to the drivers increase under the labor organization’s plan? Explain