Explore BrainMass

Explore BrainMass

    Modeling Excel

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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?

    © BrainMass Inc. brainmass.com June 3, 2020, 8:31 pm ad1c9bdddf
    https://brainmass.com/business/business-management/modeling-excel-141577

    Solution Preview

    Hi,

    Please see excel file for detailed response on each of the ...

    Solution Summary

    Excel file contains calculation of maximum profit using solver tool.

    $2.19

    ADVERTISEMENT