subject
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?

ansver
Answers: 2

Another question on Business

question
Business, 21.06.2019 13:00
Assume that a national restaurant firm called bbq builds 10 new restaurants at a cost of $1 million per restaurant. it outfits each restaurant with an additional $200,000 of equipment and furnishings. to partially defray the cost of this expansion, bbq issues and sells 200,000 shares of stock at $30 per share. what is the amount of economic investment that ahs resulted from bbq's actions? how much purely financial investment took place?
Answers: 2
question
Business, 21.06.2019 15:30
Should the government be downsized? which functions should be cut back? which ones should be expanded?
Answers: 2
question
Business, 21.06.2019 23:00
Assume today is december 31, 2013. barrington industries expects that its 2014 after-tax operating income [ebit(1 รขโ‚ฌโ€œ t)] will be $400 million and its 2014 depreciation expense will be $70 million. barrington's 2014 gross capital expenditures are expected to be $120 million and the change in its net operating working capital for 2014 will be $25 million. the firm's free cash flow is expected to grow at a constant rate of 4.5% annually. assume that its free cash flow occurs at the end of each year. the firm's weighted average cost of capital is 8.6%; the market value of the company's debt is $2.15 billion; and the company has 180 million shares of common stock outstanding. the firm has no preferred stock on its balance sheet and has no plans to use it for future capital budgeting projects. using the corporate valuation model, what should be the company's stock price today (december 31, 2013)? round your answer to the nearest cent. do not round intermediate calculations.
Answers: 1
question
Business, 22.06.2019 10:30
The card shoppe needs to maintain 21 percent of its sales in net working capital. currently, the store is considering a four-year project that will increase sales from its current level of $349,000 to $408,000 the first year and to $414,000 a year for the following three years of the project. what amount should be included in the project analysis for net working capital in year 4 of the project?
Answers: 3
You know the right answer?
The Texas Electronics Company (TEC) is contemplating a research and development program encompassing...
Questions
question
Geography, 15.12.2020 18:40
question
Mathematics, 15.12.2020 18:40
Questions on the website: 13722360