Question: Q3. Create an excel model for the Binary Integer Programming - Investment Example discussed in the Lecture notes of Week 9, and solve it using

Q3. Create an excel model for the Binary Integer Programming - Investment Example discussed in the Lecture notes of Week 9, and solve it using excel solver. Take clear screenshots for the model and excel solver window. Binary Integer Programming - Investment Example John is looking to invest in different financial products. The following table summarizes the name of each product, expected annual return, and cost. He is interested in buying at most one one of each of the 7 products. The table below summarizes the expected annual return and the purchase cost (in thousands of dollars) per product. He has a budget of $3 million and is also interested in the following conditions: 1) At least two products of T,H and L must be in the portfolio. 2) No more than one investment can be made in B or D (i.e., either B or D or none of them) 3) Exactly one of Products C or S must be purchased. 4) If Product B is purchased, then Product T must be purchased. . Formulate a Binary Integer Program to help John select an investment portfolio that will maximize annual return
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
