OPERATIONS RESEARCH; can you please extract the main equations. and can you do it on a software lingo or excel ( lingo is better).
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. Table 4. For example, if a check is mailed from the West to Atlanta, it would take an average of 8 days before Nickles could earn interest on the check. The annual cost of running a lockbox in any city is $50,000. Formulate an IP that Nickles can use to minimize the sum of costs due to lost interest and lockbox operations. Assume that each region must send all its money to a single city and that there is no limit on the amount of money that each lockbox can handle. TABLE 4 Averase Number of Davs Irom Mallina of Pawnent Until Pament Clears TABLE 5 Calcelation of Annual Lost litterest 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. Table 4. For example, if a check is mailed from the West to Atlanta, it would take an average of 8 days before Nickles could earn interest on the check. The annual cost of running a lockbox in any city is $50,000. Formulate an IP that Nickles can use to minimize the sum of costs due to lost interest and lockbox operations. Assume that each region must send all its money to a single city and that there is no limit on the amount of money that each lockbox can handle. TABLE 4 Averase Number of Davs Irom Mallina of Pawnent Until Pament Clears TABLE 5 Calcelation of Annual Lost litterest