Modeling Excel
Not what you're looking for?
Selecting Projects. 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 scientist (40) and the budget available for projects ($300,000). Following are the resource requirements and the estimated profit for each project.
_______
Project Expense ($000) Scientists Required Profit ($000)
1 60 7 36
2 110 9 82
3 53 8 29
4 47 4 16
5 92 7 56
6 85 6 61
7 73 8 48
8 65 5 41
_______
a. What is the maximum profit, and which projects should be selected?
b. Suppose that management decides that projects 2 and 5 are mutually exclusive. That is, TEC should not undertake both. As a result, what are the revised project portfolio and the revised maximum profit?
c. Suppose that management also decides to undertake at least two of the projects involving consumer products. (These happen to be projecdts 5-8.) As aresult, what are the revised project portfolio and the revised maxumum profit?
Purchase this Solution
Solution Summary
Excel file contains calculation of maximum profit using solver tool.
Solution Preview
Hi,
Please see excel file for detailed response on each of the ...
Purchase this Solution
Free BrainMass Quizzes
Understanding Management
This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.
Marketing Research and Forecasting
The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.
Accounting: Statement of Cash flows
This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.
SWOT
This quiz will test your understanding of the SWOT analysis, including terms, concepts, uses, advantages, and process.
Team Development Strategies
This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.