Question 3 The Operations Manager of a construction company wants to assign four contractors to four...

Question 3

The Operations Manager of a construction company wants to assign four contractors to four jobs in such a way as to minimize the time taken to complete four buildings of a special kind and size. Based on experience, the times taken (in months) for each contractor to complete each job are given in the table below.

Jobs	Contractor
	1 2 3 4
1	15 15 16 14
2	20 18 16 19
3	24 26 20 23
4	30 35 38 25

b. Write an LP formulation that could be used to solve this problem with the relevant LP software packages. [13 marks]

Solutions

Expert Solution

Let assune Xij reprsent the Jobs assignment to the contractor, where i = 1, 2, 3, 4 and j= 1,2,3,4.

Decision Variable - To find the value of Xij to minimize the time to complete the task.

Objective = Min. Z= 15X11+15X12+16X13+14X14+20X21+18X22+16X23+19X24+ 24X31+26X32+20X33+23X34+ 30X41+35X42+38X43+25X44

Constraints -

X11+X12+X13+X14=1

X21+X22+X23+X24=1

X31+X32+X33+X34=1

X41+X42+X43+X44=1

X11+X21+X31+X41=1

X12+X22+X32+X42=1

X13+X23+X33+X43=1

X14+X24+X34+X44=1

Xij = Binary (0 or 1)

Below is the screenshotof the LP table in excel -

Below is the screenshot of the formula applied -

Below is the screenshot of the solver -

Below is the screenshot of the result -

keosha answered 1 year ago

Next > < Previous

Related Solutions

Question 3 The Operations Manager of a construction company wants to assign four contractors to four...

Question 3 The Operations Manager of a construction company wants to assign four contractors to four jobs in such a way as to minimize the time taken to complete four buildings of a special kind and size. Based on experience, the times taken (in months) for each contractor to complete each job are given in the table below. . Jobs Contractor 1 2 3 4 1 15 15 16 14 2 20 18 16 19 3 24 26 20 23...

Sara Chapman knew the construction contractors in her area well. She was the HR manager at...

Sara Chapman knew the construction contractors in her area well. She was the HR manager at the power plant, a business that was the major employer in the region. Whenever a repair or maintenance job came up, Sara would hire her friends as independent contractors instead of collecting bids for the job or hiring an employee. Upon completion of the job, the independent contractors would inflate the invoice by 10% for “unanticipated additional costs” and would then kick back the...

Sara Chung knew the construction contractors in her area well. She was the purchasing manager at...

Sara Chung knew the construction contractors in her area well. She was the purchasing manager at the power plant, a business that was the major employer in the region. Whenever a repair or maintenance job came up, Sara’s friends would inflate the invoice by 10%. The invoice would then be passed through the accounts payable department, where the clerk was supposed to review and verify the charges before processing the payment. The accounts payable clerk, Valerie Judson, was happy to...

Sara Chung knew the construction contractors in her area well. She was the purchasing manager at...

Imagine you are the manager of operations for a manufacturing company. Your vice president wants to...

Imagine you are the manager of operations for a manufacturing company. Your vice president wants to expand production by building a new facility, and she would like you to develop a business case for the project. Assume that your company’s weighted average cost of capital is 13%, the after-tax cost of debt is 7%, preferred stock is 10.5%, and common equity is 15%. As you work on the business case, you surmise that this is a fairly risky project because...

Question: In ABC firm of building, contractors began construction on 1st April, 2019. The contract is...

Question: In ABC firm of building, contractors began construction on 1st April, 2019. The contract is incomplete and the contractor is confused about how to transfer profit or loss in the P/L account. Being a student of cost accounting, you are required to state the rules regarding the transfer of profits to profit and loss account in case of incomplete contracts( 0%,20%,50%,75%,90 %) to the contractor.

Johnson Company is preparing a bid on a new construction project. Two other contractors will be...

Johnson Company is preparing a bid on a new construction project. Two other contractors will be submitting bids for the same project. Based on past bidding practices, bids from other contractors can be described by the following probability distributions: Contractor A: Uniform probability distribution between $500,000 and $1,000,000. Contractor B: Normal probability distribution with a mean bid of $700,000 and a standard deviation of $100,000. a. If Johnson Company submits a bid of $750,000, what is the probability Butler will...

Question A: The marketing manager of a company producing a new cereal aimed for children wants...

Question A: The marketing manager of a company producing a new cereal aimed for children wants to examine the effect of the color and shape of the box's logo on the approval rating of the cereal. He combined 3 colors and 2 shapes to produce a total of 6 designs. Each logo was presented to 3 different groups (a total of 18 groups) and the approval rating for each was recorded and is shown below. The manager analyzed these data...

3) You work at a company as an entry level internal auditor. Your manager wants to...

3) You work at a company as an entry level internal auditor. Your manager wants to check the completeness of the audit trail for the purchase of a very expensive asset, which is expected to have a big impact on the way the company does business. Typically, this sort of decision requires a request for tender to be approved. (A request for tender (RFT) is a document put out by the purchaser, letting relevant suppliers know about the opportunity. Suppliers...

1. An operations manager at a factory that produces rechargeable batteries for smart phones wants to...

1. An operations manager at a factory that produces rechargeable batteries for smart phones wants to determine if the new brand of battery that they are producing is superior to their original design. Sample Average Life Standard Dev. Old 25 6.5 hours 1.25 hours New 35 7.2 hours 0.75 hours Using a 0.01 level of significance and assuming equal variances, identify the alternative hypothesis to these the claim that the new brand of batteries is superior to the original design....

Subjects