Drivers in the London (England) Underground railway system work two four-hour shifts per day. In some...
Fantastic news! We've Found the answer you've been seeking!
Question:
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.
Expert Answer:
Answer rating: 100% (QA)
a Formulate a model for the problem either in LINGO syntax or an Excel file i N... View the full answer
Related Book For
Accounting Information Systems
ISBN: 978-0133428537
13th edition
Authors: Marshall B. Romney, Paul J. Steinbart
Posted Date:
Students also viewed these general management questions
-
An engineer working in an electronics lab connects a parallel-plate capacitor to a battery, so that the potential difference between the plates is 260 V. Assume a plate separation of d=1.61 cm and a...
-
Formulate but do not solve an algebraic model for the following situation. City bus drivers work two four-hour shifts per day. In some cases, the two shifts are consecutive (effectively one...
-
1. The quantity of organically bound nitrogen (org-N) released by acid digestion is referred to as Kjeldahl nitrogen. One method used to determine the Kjeldahl nitrogen content involves a back...
-
[10 marks] Click the link below to see the code for a program. Your task is as in assignment 3: re-write the code of this program so that, to a user of the program, it works as before, but in your...
-
In Figure particle 1 of charge ?? 5.00q and particle 2 of charge + 2.00q are held at separation L on an x axis. If particle 3 of unknown charge q3 is to be located such that the net electrostatic...
-
In order to determine the unbalance in a grinding wheel, rotating clockwise at \(2400 \mathrm{rpm}\), a vibration analyzer is used and an amplitude of \(0.1 \mathrm{~mm}\) and a phase angle of...
-
What is critical natural capital? Provide examples. For a company, who determines whether natural capital is a critical ecological resource? Is there a difference between other natural capital and...
-
Police are to conduct random breath testing on drivers on a busy road one Friday evening. Suppose 3% of the drivers drink and drive at the time. Let X be the number of drivers that police need to...
-
Review a published journal article of your choosing that was written within the last 5 years from one of the online EKU library data bases . Select an article that is on a topic that is close to your...
-
On March 17, Door Products Inc. sold building materials to Mar Homebuilding for $15,000 with terms of 3/10 n/20. What amount did Door Products Inc. record as revenue on March 25 when Mar paid for the...
-
The final scores from an honors seminar in marketing were 65 55 70 80 90 100 50 75 Find the mean, median, and mode. Is one measure preferable to another. Why or why not?
-
Compare the following measures of dispersion: variance, standard deviation, mean absolute deviation, and range. (a) What are the benefits and disadvantages of each measure? (b) Which measure is the...
-
A sample of 20 workers in a small company earned the following weekly wages: $175, 175, 182, 175, 175, 200, 250, 225, 250, 200, 195, 200, 200, 190, 325, 300, 310, 325, 400, 225 (a) Calculate the mean...
-
The following graph shows the Lorenz curves for two countries, Modestia and Richardonia. Which country has the most nearly equal distribution of income? Cumulative Percentage of Family Income...
-
What is the coefficient of variation? What does it measure? Explain how the coefficient of variation can be used to decide which of these two stocks to purchase.
-
Meriton Ltd borrows $ 100,000 at an interest rate of 11.5% per annum, repayable by equal monthly instalments over 20 years. Calculate the principal and interest components of the first and last...
-
A 20-cm-square vertical plate is heated to a temperature of 30oC and submerged in glycerin at 10oC. Calculate the heat lost from both sides of the plate.
-
Ajax Manufacturing installed a new bar code based inventory tracking system in its warehouse. To close the books each month on a timely basis, the six people who work in the warehouse must scan each...
-
Explain what an event is. Using the Internet as a resource, create a list of some of the many internal and external factors that COSO indicated could influence events and affect a companys ability to...
-
From the database created in the comprehensive problem, perform queries based on the tables and query grid shown in Table 4-19. a. Which borrowers use Advent Appraisers? b. What is the average amount...
-
What are the responsibilities of the governments toward the stateless? Do the United States and other powerful nations have responsibilities toward groups such as the Rohingya? Following the...
-
The United States and Canada are two of only 33 countries that have jus soli, the right to citizenship of any individual born on their soil. Why do you think this right is so limited, and do you...
-
What are stratified societies and what kinds of social systems are they identified with?
Study smarter with the SolutionInn App