UPS wants to deliver 400 packages in downtown Miami today. There are 11 large trucks available with capacity 40 packages each, and 10 small trucks with capacity 25 packages each. There are only 13 drivers available. The daily cost for operating a large truck is $200 and $120 for the small truck. 1. Formulate the above problem as a Linear Programming problem. 2. Solve the problem using excel; in other words, find the number of drivers which are driving small trucks and large trucks respectively to achieve the minimum operating cost.
Please provide excel sheet using solver.