Question: Please solve on excell spreadsheet makign shareable *Use excel solver to solve after formulate the problem first* Using Excel Solver to solve linear programming problems
Using Excel Solver to solve linear programming problems Due Monday by 11:59pm Points 20 Submitting a file upload Available until Dec 12 at 11:59pm Please formulate the following problem first, then use Excel Solver to solve it (You can simply follow the two videos: one for formulating and the other for solving). For submission purpose, please upload the Excel file. Problem: A school is preparing a trip for 400 students. The company who is providing the transportation has 10 buses of 50 seats each and 8 buses of 40 seats, but only has 9 drivers available. The rental cost for a large bus is $800 and $600 for the small bus. Formulate a linear programming model to determine how many buses of each type should be used for the trip for the least possible cost. Videos: Eormulation LargeSmallBus
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
