Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

Drivers in the London (England) Underground railway system work two four-hour shifts per day. In some cases, (a) Formulate a model for the problem either in LINGO syntax or an Excel file. For each model: (i) Write your 

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.

Step by Step Solution

3.45 Rating (148 Votes )

There are 3 Steps involved in it

Step: 1

a Formulate a model for the problem either in LINGO syntax or an Excel file i N... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting Information Systems

Authors: Marshall B. Romney, Paul J. Steinbart

13th edition

133428532, 978-0133428537

More Books

Students also viewed these General Management questions

Question

Disordered eating in dance professionals

Answered: 1 week ago