Conglomo Corporation is considering investing in other smaller companies, and it can purchase any fraction of each company. Each investment by Conglomo requires a partial payment now and a final payment 1 year from now. For each investment, the following table summarizes the amount of each payment (in millions of dollars) and the projected 5-year profit (also in millions of dollars).

This table may be interpreted as follows: if Conglomo purchases one-fifth of Company 4, then it pays 1/5 (6.0) $1.2 million now and 1/5 (1.2) $0.24 million $240,000 after 1 year, and the one-fifth share has a projected 5-year profit of 1/5 (16.8) $3.36 million. Conglomo has available $48 million for investment now and $24 million for investment 1 year from now. What fraction of each smaller company should Conglomo purchase in order to maximize the projected 5-year profit? What is the maximum profit?
Use Excel to solve each linear programming problem.

Transcribed Image Text:

Company Company Company Company Company 3 2 Paid now 13.2 63.6 34.8 6.0 6.0 Paid in 1 year Projected 7.2 1.2 40.8 3.6 6.0 profit 19.2 15.6 19.2 16.8 46.8