Question: OPERATIONS RESEARCH; can you please extract the main equations. and can you do it on a software lingo or excel ( lingo is better). Homework

OPERATIONS RESEARCH; can you please extract the main equations. and can you do it on a software lingo or excel ( lingo is better).
OPERATIONS RESEARCH; can you please extract the
Homework #1 For all questions, formulate the LP problem by hand in your team of 2 or three and then solve using Excel or software. Q1. Stockco is considering four investments. - Investment 1 will yield a net present value (NPV) of $16,000; - investment 2 , an NPV of $22,000; - Investment 3 , an NPV of $12,000; and - Investment 4 an NPV of $8,000. Each investment requires a certain cash outflow at the present time: - investment 1,$5,000; - investment 2,$7,000; - investment 3,$4,000; and - investment 4,$3,000. Currently, $14,000 is available for investment. Formulate an IP whose solution will tell Stockco how to maximize the NPV obtained from investments 14. Homework #1 For all questions, formulate the LP problem by hand in your team of 2 or three and then solve using Excel or software. Q1. Stockco is considering four investments. - Investment 1 will yield a net present value (NPV) of $16,000; - investment 2 , an NPV of $22,000; - Investment 3 , an NPV of $12,000; and - Investment 4 an NPV of $8,000. Each investment requires a certain cash outflow at the present time: - investment 1,$5,000; - investment 2,$7,000; - investment 3,$4,000; and - investment 4,$3,000. Currently, $14,000 is available for investment. Formulate an IP whose solution will tell Stockco how to maximize the NPV obtained from investments 14

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!