(3) The Western Cape government has decided to develop four desalination plants to combat the negative...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
(3) The Western Cape government has decided to develop four desalination plants to combat the negative effects of climate change. A total of five contractors have submitted bids during the tender process. Based on the completion of previous, similar projects by the five contractors, government officials have calculated the expected cost (in R1 000 000's) shown in the following table. Plant 2 Plant 3 Plant 4. Plant 1 9 7 9 10 10 Contractor 1 Contractor 2 Contractor 3 Contractor 4 Contractor 5 14 17 18 12 15 19 20 21 18 21 15 19 18 19 16 In order to expedite the execution of this project, only one contractor is awarded the development of a desalination plant. Suppose the government only has R50 000 000 available and wants to determine a contractor-desalination plant assignment resulting in the smallest overall cost. Formulate the problem mathematically as an assignment problem. (Hint: The number of desalination plants is small than the number of contractors. A dummy desalination plant must therefore be inserted in order to transform the problem into a classical assignment problem.) Define your decision variables precisely and include short explanatory comments for each model constraint. Furthermore, use both the Hungarian method and an appropriate computer implementation (e.g. Microsoft Excel's Solver add-on or Python packages such as Scipy & PuLP) to determine an optimal assignment. If it is necessary to seek supplementary funds, how much money should the government seek? Finally, which of the five contractors will be unsuccessful? Please include a carefully commented print-out of your program embedded within your PDF submission. [36] (3) The Western Cape government has decided to develop four desalination plants to combat the negative effects of climate change. A total of five contractors have submitted bids during the tender process. Based on the completion of previous, similar projects by the five contractors, government officials have calculated the expected cost (in R1 000 000's) shown in the following table. Plant 2 Plant 3 Plant 4. Plant 1 9 7 9 10 10 Contractor 1 Contractor 2 Contractor 3 Contractor 4 Contractor 5 14 17 18 12 15 19 20 21 18 21 15 19 18 19 16 In order to expedite the execution of this project, only one contractor is awarded the development of a desalination plant. Suppose the government only has R50 000 000 available and wants to determine a contractor-desalination plant assignment resulting in the smallest overall cost. Formulate the problem mathematically as an assignment problem. (Hint: The number of desalination plants is small than the number of contractors. A dummy desalination plant must therefore be inserted in order to transform the problem into a classical assignment problem.) Define your decision variables precisely and include short explanatory comments for each model constraint. Furthermore, use both the Hungarian method and an appropriate computer implementation (e.g. Microsoft Excel's Solver add-on or Python packages such as Scipy & PuLP) to determine an optimal assignment. If it is necessary to seek supplementary funds, how much money should the government seek? Finally, which of the five contractors will be unsuccessful? Please include a carefully commented print-out of your program embedded within your PDF submission. [36]
Expert Answer:
Answer rating: 100% (QA)
To formulate the problem as an assignment problem we need to create a matrix that represents the costs of assigning each contractor to each desalinati... View the full answer
Related Book For
Advanced Financial Accounting
ISBN: 978-0137030385
6th edition
Authors: Thomas Beechy, Umashanker Trivedi, Kenneth MacAulay
Posted Date:
Students also viewed these general management questions
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
The following additional information is available for the Dr. Ivan and Irene Incisor family from Chapters 1-5. Ivan's grandfather died and left a portfolio of municipal bonds. In 2012, they pay Ivan...
-
List three specific parts of the Case Guide, Objectives and Strategy Section (See below) that you had the most difficulty understanding. Describe your current understanding of these parts. Provide...
-
Show by approximating with integrals that the number of distinct triples of integers between 0 and \(n\) is about \(n^{3} / 6\).
-
How would you treat a radiation heat transfer boundary condition for a one-dimensional steady problem? Develop the difference equation for a control volume near the boundary and explain how to solve...
-
An extract from the general ledger of D Wyangala at 30 June 2022 showed the following account balances: accounts receivable control $68 288 allowance for doubtful debts $1421 GST payable $2500 ...
-
Unless otherwise specified, which rule will always be processed?
-
Warranties Winslow Company sold 150 color laser copiers in 2010 for $4,000 apiece, together with a one-year warranty. Maintenance on each copier during the warranty period averages $300. (a) Prepare...
-
Prepare the journal entries to record each of the transactions 1 through 6 as of the date of occurrence. Note: Round answers to the nearest whole dollar. 1. On January 1, new equipment is purchased...
-
A dynamic vibration absorber is shown in Figure P2.2. This system is representative of many situations involving the vibration of machines containing unbalanced components. The parameters M2 and kl2...
-
The Admissions Office has the following process (capacity in applications per hour and task cycle time in sec) 1 +Z 120 30 240 15 3 120 30 40 90 5 20 180 30 120
-
Relevant Info: Civil law covers a very broad range of subjects, including adoption, admiralty, collections, corporate, divorce, employment, environmental, intellectual property, personal injury,...
-
City Foods, is a firm that is experiencing rapid growth. The firm just paid a dividend of $5.00 yesterday. They expect to see their dividend grow at a twenty percent rate for the next two years and...
-
Instructions. Answer the following questions logically and concisely giving your basis whenever possible. When required to explain, the sentences should not be less than two sentences to obtain...
-
If f(x) = 1 + Inz 1 dt for x1, then f'(2) =
-
how does the balance sheet of a for-profit company differ from the balance sheet of a non-profit company? (CLO 2) How does accounting for non-profits compare to accounting for for-profit companies?...
-
For the fiscal year ended June 30, Year 1, Safety Toys Company reported after-tax income from continuing operations of $87,500,000 and income from discontinued operations of $5,650,000 (net of tax)....
-
From a medical tourist perspective, compare Shouldice with the traditional hospital in terms of the key factors of competition. Using Table 15-3, why would Shouldice attract patients from outside the...
-
How did the expenditure basis of accounting discourage reinvestment in long- lived assets?
-
On January 1, 20X6, Woods Ltd. formed a foreign subsidiary that issued all of its currently outstanding common shares on that date. Selected captions from the SFPs, all of which are shown in local...
-
What is a fair-value hedge?
-
You can think of a financial plan as a "financial road map to guide you through life." Develop a visual display that illustrates this concept and the five steps of the financial planning process. Try...
-
Summarize the five steps that make up the financial planning process.
-
Visit your campus career counseling office to learn about the services available to assist you with your career search and your job search. What career management services, if any, are available...
Study smarter with the SolutionInn App