Four projects are available for investment. The projects require the cash flows and yield the net present values (in millions) shown in the file P06_39.xlsx. If $6 million is available now for...

Four projects are available for investment. The projects require the cash flows and yield the net present values (in millions) shown in the file P06_39.xlsx. If $6 million is available now for investment, find the investment plan that maximizes NPV.

Suppose in the previous problem that each customer’s demand must be met from a single warehouse. Solve the problem with this restriction.