Question

In: Operations Management

Tower Engineering Corporation is considering undertaking several proposed projects for the next fiscal year. The projects,...

Tower Engineering Corporation is considering undertaking several proposed projects for the next fiscal year. The projects, the number of engineers and the number of support personnel required for each project, and the expected profits for each project are summarized in the following table: Project 1 2 3 4 5 6 Engineers Required 20 55 47 38 90 63 Support Personnel Required 15 45 50 40 70 70 Profit ($1,000,000s) 1.0 1.8 2.0 1.5 3.6 2.2 Formulate an integer program that maximizes Tower's profit subject to the following management constraints: 1) Use no more than 175 engineers 2) Use no more than 150 support personnel 3) If either project 6 or project 4 is done, both must be done 4) Project 2 can be done only if project 1 is done 5) If project 5 is done, project 3 must not be done and vice versa 6) No more than three projects are to be done.

Show Process.

Solutions

Expert Solution

Let Xj be the binary integer such that Xj=1 when project-j is selected and Xj=0 otherwise.

Maximize Z = total profit = 1.0X1 + 1.8X2 + 2.0X3 + 1.5X4 + 3.6X5 + 2.2X6

Subject to,

20X1 + 55X2 + 47X3 + 38X4 + 90X5 + 63X6 <= 175 ----(1)

15X1 + 45X2 + 50X3 + 40X4 + 70X5 + 70X6 <= 150 ----(2)

X6 - X4 = 0 ----(3)

X1 - X2 >= 0 ----(4)

X3 + X5 <= 1 ----(5)

X1 + X2 + X3 + X4 + X5 + X6 <= 3 ----(6)

Xj = {0,1}

----------------------------------

Truth table for constraint (3)

X6 X4 Remarks
1 1 Accept
0 0 Accept
1 0 Reject
0 1 Reject

Truth table for constriant (4)

X1 X2 Remarks
1 0 Accept
1 1 Accept
0 0 Accept
0 1 Reject

Truth table for constraint (5)

X3 X5 Remarks
1 0 Accept
0 1 Accept
0 0 Accept
1 1 Reject

---------------------------

LINDO Code

Max 1.0X1 + 1.8X2 + 2.0X3 + 1.5X4 + 3.6X5 + 2.2X6
s.t.
20X1 + 55X2 + 47X3 + 38X4 + 90X5 + 63X6 <= 175
15X1 + 45X2 + 50X3 + 40X4 + 70X5 + 70X6 <= 150
X6 - X4 = 0
X1 - X2 >= 0
X3 + X5 <= 1
X1 + X2 + X3 + X4 + X5 + X6 <= 3
end
INT 6

--------------------------------


Related Solutions

Imagine that you need to have at least 5 sucessful projects in the next fiscal year....
Imagine that you need to have at least 5 sucessful projects in the next fiscal year. Projects have a success chance of 0.6. How many projects do you need to start to have a 90% chance of 5 or more successes?
HKV company is considering investing in several projects that have varying capital requirements over the next...
HKV company is considering investing in several projects that have varying capital requirements over the next four years. The net present value of each project, cash outflows required over the years and capital available per year are given (in millions) in the table below: Plant 1 Expansion Plant 2 Expansion New Product Development Automation Annual Capital Available Year 1 8 5 4 7 20 Year 2 10 7 2 5 25 Year 3 10 10 1 5 20 Year 4...
Giant Equipment Ltd. is considering two projects to invest next year. Both projects have the same...
Giant Equipment Ltd. is considering two projects to invest next year. Both projects have the same start-up costs. Project A will produce annual cash flows of $42,000 at the beginning of each year for eight years. Project B will produce cash flows of $48,000 at the end of each year for seven years. The company requires a 12% return. Required: a) Which project should the company select and why? b) Which project should the company select if the interest rate...
Giant Equipment Ltd. is considering two projects to invest next year. Both projects have the same...
Giant Equipment Ltd. is considering two projects to invest next year. Both projects have the same start-up costs. Project A will produce annual cash flows of $42,000 at the beginning of each year for eight years. Project B will produce cash flows of $48,000 at the end of each year for seven years. The company requires a 12% return. Required: 1. a) Which project should the company select and why? 2. b) Which project should the company select if the...
Giant Equipment Ltd. is considering two projects to invest next year. Both projects have the same...
Giant Equipment Ltd. is considering two projects to invest next year. Both projects have the same start-up costs. Project A will produce annual cash flows of $42,000 at the beginning of each year for eight years. Project B will produce cash flows of $48,000 at the end of each year for seven years. The company requires a 12% return. Required: a) Which project should the company select and why? b) Which project should the company select if the interest rate...
Giant Equipment Ltd. is considering two projects to invest next year. Both projects have the same...
Giant Equipment Ltd. is considering two projects to invest next year. Both projects have the same start-up costs. Project A will produce annual cash flow of $42 000 at the beginning of each year for eight years. Project B will produce cash flow of $48 000 at the end of each year for seven years. The company requires a 12% return. Required: a. Which project should the company select and why? b. Which project should the company select if the...
At the end of 2015, Uma Corporation is considering undertaking a major long-term project in an...
At the end of 2015, Uma Corporation is considering undertaking a major long-term project in an effort to remain competitive in its industry. The production and sales departments have determined the potential annual cash flow savings that could accrue to the firm if it acts soon. Specifically, they estimate that a mixed stream of future cash flow savings will occur at the end of the years 2016 through 2021. The years 2022 through 2026 will see consecutive and equal cash...
Your task is to find a newspaper article about a corporation undertaking or considering a capital...
Your task is to find a newspaper article about a corporation undertaking or considering a capital budgeting project. Prompt include a brief summary of what you read, a discussion of why you chose this example, and an analysis of whether you think the company is making the right decision. In addition, please attach or provide a link to the article you have chosen for your initial post. minimum 300 words
Eastern Engineering Company is trying to decide which of 6 projects to perform during the next...
Eastern Engineering Company is trying to decide which of 6 projects to perform during the next quarter. The net present value, the estimated cost, and the number of engineers and staff personnel required for each project are given in the following table. Project Net Present Value ($1000’s) Cost ($1000’s) Engineers Required Staff Required 1 100 35 5 2 2 145 65 8 3 3 200 95 11 2 4 250 180 4 2 5 500 250 16 7 6 695...
A proposed project will generate £150,000 in revenue a year for 20 years (starting next year),...
A proposed project will generate £150,000 in revenue a year for 20 years (starting next year), but will cause another product line to lose £60,000 in revenue a year during that time. The project will make use of 50% of an already leased warehouse with total annual rent of£50,000 (the contract does not prohibit sub-leasing). The discount rate for this project is 6%. Should the firm undertake this project if the required investment is £250,000? What is the Payback Period...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT