An architectural design firm is faced with a decision as to which projects to bid on for

Question:

An architectural design firm is faced with a decision as to which projects to bid on for the coming year. Ten projects are available for which they are qualified. The following table lists the profit they can expect to make from each project, as well as the initial investment they will have to make and the design time required. They cannot afford to invest more than $55,000 or use more than a total of 1,000 hours of design time. Their objective is to choose those projects that will maximize their expected profit.
Design time (hours) Profit Investment ($000) Project ($000) 55 6.2 123 2 75 8.8 145 3 98 8.4 164 4 67 5.9 135 5 78 6.9 1

a. Assuming no uncertainty in profits, investment, or design time, what is the maximum profit the firm can achieve, and which projects should it select? Note: this solution must not use more investment capital or design time than is available.
b. Represent the uncertainty in profits, investment, and design time using normal distributions, with standard deviations of 5 percent of the mean for profit, 10 percent for the initial investment, and 15 percent for design time. Determine the maximum expected profit the firm can achieve under these assumptions, and which projects it should select. Note: this solution must be such that the investment and design time constraints are violated no more than 5 percent of the time.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Management Science The Art Of Modeling With Spreadsheets

ISBN: 1301

4th Edition

Authors: Stephen G. Powell, Kenneth R. Baker

Question Posted: