Business
Business, 10.06.2021 20:00, Queenashley3232

The Texas Electronics Company (TEC) is contemplating a research and development program encompassing eight major projects. The company is constrained from embarking on all projects by the number of available scientists, which is 40, and the budget constraint, which is $300,000. Following are resource requirements and the estimated profits for each project: Project Expense($000) Scientists Required Profit ($000)
1 60 7 36
2 110 9 82
3 53 6 29
4 147 4 16
5 192 7 56
6 185 6 61
7 173 8 48
8 165 5 41
Formulate this problem using integer programming.
Solve it using excel. (Hint: in excel, assign integer constraint to decision variables by selecting "int" when selecting integer constraints)
What is the maximal profit? Which projects should be selected?
Suppose the management team decides that project 2 and project 5 are mutually exclusive, what it the revised formula? What is the revised maximal profit? What is the revised projected selected?
Suppose the management team also decides to undertake at least two of the projects involving consumers products (these happens to be projects 5-8). Then what is the revised formula? What is the revised maximal profit? What is the revised projected selected?

answer
Answers: 2

Other questions on the subject: Business

image
Business, 21.06.2019 18:30, raquelwilliams6912
What’s the best type of healthcare plan
Answers: 1
image
Business, 23.06.2019 02:30, jamilamiller200
Consider the following condensed financial statements of money freedom comma inc. the company's target rate of return is 30%: (click the icon to view the comparative balance sheet.) (click the icon to view the income statement.) requirements 1. calculate the company's roi. round all of your answers to four decimal places. 2. calculate the company's profit margin ratio. interpret your results. 3. calculate the company's asset turnover ratio. interpret your results. 4. use the expanded roi formula to confirm your results from requirement 1. interpret your results. 5. calculate the company's ri. interpret your results. requirement 1. calculate the company's roi. round all of your answers to four decimal places. begin by selecting the formula to calculate return on investment (roi), and then enter the amounts to calculate the company's roi. (round your calculations to four decimal places and enter your answer as a percent, x. xx%)
Answers: 1
image
Business, 23.06.2019 02:40, Jorianes
Some years ago it was estimated that the demand for steel approximately satisfied the equation p=194-25x x, and the total cost of producing x units of steel was upper c left parenthesis x right parenthesis equals 145 plus 40 x. (the quantity x was measured in millions of tons and the price and total cost were measured in millions of dollars.) determine the level of production and the corresponding price that maximize the profits.
Answers: 3
image
Business, 23.06.2019 03:10, yyy77uh
Identify whether each of the following statements best illustrates the concept of consumer surplus, producer surplus, or neither. statement consumer surplus producer surplus neither a local store was having a sale on textbooks, so i bought a used textbook for my brother. i sold a watch for $61, even though i was willing to go as low as $55 in order to sell it. even though i was willing to pay up to $116 for a used laptop, i bought a used laptop for only $110.
Answers: 1
Do you know the correct answer?
The Texas Electronics Company (TEC) is contemplating a research and development program encompassing...

Questions in other subjects: