Linear Programming using Excel Solver/integer

written by - Comments off

The texas Consolidated Electronics Company is contemplating a research and development program encompassing eight research projects. The company is constrained from embarking on all projects by the number of available management scientists (40) and the budget available for R&D projects ($300,000). Further, if project 2 is selected, project 5 must also be selected (but not vice versa). Following are the resource requirements and the estimated profit for each project:

Project Expense($1,000) MGNT required Estimated Profit($1,000,000)
1 $60 7 $0.36
2 110 9 0.82
3 53 8 0.29
4 47 4 0.16
5 92 7 0.56
6 85 6 0.61
7 73 8 0.48
8 65 5 0.41

Formulate the integer programming model using excel solver for this problem and solve it by using the computer.

Note: Currently, Regular Priority times are 3-5 days. Log in to upload files with your questions. Tutorials you buy shall be emailed to your PAYPAL email. Talking about quality references: finding and referencing an (n+1)th article for your tutorial requires substantially more time than the (n)th article referenced, therefore you will see the price increasing with the number of references you require in some questions. Wanted to contact us over something related to this question? Email us: support AT oxenmine.com.

© 2010 oxenMINE.com: Customized Homework help. - Powered by OM