Question: Please show ALL steps to compute in EXCEL using SOLVER to get to the right answers. Thank you in advance, will upvote! Eaton Medical Services
Please show ALL steps to compute in EXCEL using SOLVER to get to the right answers. Thank you in advance, will upvote!
Eaton Medical Services is evaluating 10 independent indivisible projects, all with positive NPV. The company's capital budgeting for the year is limited to a maximum of $5,000,000.
(A) Use solver to find the optimum combination of projects the company should accept, under the assumption that A and B are mutually exclusive and one of them has to be selected.
(B) Ignore the constraint from previous part, assume that project I has to be accepted. Use solver to find optimum combination of projects the company should accept now.
+ Project A B C D E Cost NPV 1,061,191 122,737 561,758 58,102 1,647,849 280,660 1,026,020 89,365 191,870 17,568 1,333,625 76,960 3,102,642 123,240 275,568 79,367 2,044,070 60,506 1,017,567 56,690 F G H I J + Project A B C D E Cost NPV 1,061,191 122,737 561,758 58,102 1,647,849 280,660 1,026,020 89,365 191,870 17,568 1,333,625 76,960 3,102,642 123,240 275,568 79,367 2,044,070 60,506 1,017,567 56,690 F G H I J
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
