Implement a linear binary program for the investment opportunities shown in Table 5, with investment budget constraint equal to £ 1000.

Transportation problems modeling. The linear programming has vast applications in the management and industrial engineering area. An important topic is solving the transportation problems. Essentially, given a matrix of costs cij for shipping the goods from the source i (i.e., the production center) to the destination j (i.e., depository center) the problem consists of finding the optimal flow of units xij in order to minimize the total transportation cost, subject to the production capacity of each source center (supply capacity), demands required in each destination center, and nonnegativity constraints. The linear problem is formalized therefore as follows: min fxijg Xm i ¼ 1 Xn j ¼ 1 cijxij s:t: Xm i ¼ 1 xij ¼ dj ðj ¼ 1; /; nÞ Xn j ¼ 1 xij ¼ si ði ¼ 1; /; mÞ xij 0 Solve the following problems in Excel using the Simplex LP Solver.

Transcribed Image Text:

TABLE 5 Investment Project PV of Outlay NPV 1 1234 Period1 600.0 300.0 600.0 270.0 200.0 80.0 400.0 100.0