Drivers in the London (England) Underground railway system work two four-hour shifts per day. In some...

  

Transcribed Image Text:

Drivers in the London (England) Underground railway system work two four-hour shifts per day. In some cases, the two shifts are consecutive (effectively one eight- hour shift), but usually they are not. All Underground drivers earn a base rate of £21 per hour (ie. £168 per day). Because of the inconvenience of breaking up the day. those who work non-consecutive shifts are paid a £15 per day bonus. The London Underground has the following daily requirements for drivers: Shift Time of Day 10500 to 0859 0900 to 1259 2 3 4 5 1300 to 1659 1700 to 2059 2100 to 0059 Minimum Number of Drivers Needed 430 150 230 390 270 No-one will be asked to work on both shifts 1 and 5. Subject to meeting all its requirements for drivers, the London Underground wishes to minimize its daily labour cost (regular and bonus). Make the objective function so that each of the £21 (or £168) and the £15 is multi- plied by just one variable. (a) Formulate a model for the problem either in LINGO syntax or an Excel file. For each model: (i) Write your name and student number. (ii) Write the definitions of all the variables. (This is the same as what was given for Q1: make your own variable definitions for the other questions.) (iii) Write the objective function. (iv) Write the constraints with comments to explain their purpose.² (v) The non-negativity restrictions are to be omitted. (vi) LINGO only: Every variable which must be integer must be so declared using an @GIN command. This is followed by an END command. Copy-and-paste the LINGO file into the Word or pdf submission document. (vii) Excel only: The Solver Parameters box must be filled in, including an int dec- laration for each integer variable. Copy-and-paste the Excel file into the Word or pdf submission document, and include a screenshot of the Solver Parameters box into this document. (b) Solve the model, and copy-and-paste either the LINGO solution file or the Excel Solver Answer Report into the Word or pdf submission document. (c) State the solution in words in the Word or pdf submission document. When you attempt to solve these models, you might receive a message about the solution being infeasible. While this is a theoretical possibility, it won't happen for any of these questions. It would mean that a mistake has been made in formulating the model. Drivers in the London (England) Underground railway system work two four-hour shifts per day. In some cases, the two shifts are consecutive (effectively one eight- hour shift), but usually they are not. All Underground drivers earn a base rate of £21 per hour (ie. £168 per day). Because of the inconvenience of breaking up the day. those who work non-consecutive shifts are paid a £15 per day bonus. The London Underground has the following daily requirements for drivers: Shift Time of Day 10500 to 0859 0900 to 1259 2 3 4 5 1300 to 1659 1700 to 2059 2100 to 0059 Minimum Number of Drivers Needed 430 150 230 390 270 No-one will be asked to work on both shifts 1 and 5. Subject to meeting all its requirements for drivers, the London Underground wishes to minimize its daily labour cost (regular and bonus). Make the objective function so that each of the £21 (or £168) and the £15 is multi- plied by just one variable. (a) Formulate a model for the problem either in LINGO syntax or an Excel file. For each model: (i) Write your name and student number. (ii) Write the definitions of all the variables. (This is the same as what was given for Q1: make your own variable definitions for the other questions.) (iii) Write the objective function. (iv) Write the constraints with comments to explain their purpose.² (v) The non-negativity restrictions are to be omitted. (vi) LINGO only: Every variable which must be integer must be so declared using an @GIN command. This is followed by an END command. Copy-and-paste the LINGO file into the Word or pdf submission document. (vii) Excel only: The Solver Parameters box must be filled in, including an int dec- laration for each integer variable. Copy-and-paste the Excel file into the Word or pdf submission document, and include a screenshot of the Solver Parameters box into this document. (b) Solve the model, and copy-and-paste either the LINGO solution file or the Excel Solver Answer Report into the Word or pdf submission document. (c) State the solution in words in the Word or pdf submission document. When you attempt to solve these models, you might receive a message about the solution being infeasible. While this is a theoretical possibility, it won't happen for any of these questions. It would mean that a mistake has been made in formulating the model.

Answer rating: 100% (QA)

Unfortunately I am unable to directly provide or work with LINGO syntax or Excel files nor can I view or analyze actual files students may have Nevertheless I can guide you on how to approach the opti... View the full answer