Boston Via Transportation company has been given the job of providing advance transport to a new stadium.
Question:
Boston Via Transportation company has been given the job of providing advance transport to a new stadium. It is possible to use existing railway connections and bus routes. Each bus will cost $90000 and carry 60 passengers. Each railway train will cost $135000 and carry 80 passengers. A bus can make 20 trips a day. A railway train can make 15 trips a day. There are a number of financial and design constraints. Boston Via Transportation is required to ensure at least 96000 passengers are carried a day and the total cost is no more than $10800000. There is also an agreement to use at least 10 trains, while no more than 66 buses are available. Develop an LP model for this problem and solve it using Excel solver. Then, upload your file, which must contain the definition of decision variables, objective function and constraint and the optimal solution.
Introduction to Management Science A Modeling and Cases Studies Approach with Spreadsheets
ISBN: 978-0078024061
5th edition
Authors: Frederick S. Hillier, Mark S. Hillier