Formulate the linear programming model, develop a spreadsheet, and solve the capital rationing problem in Example (a)

Question:

Formulate the linear programming model, develop a spreadsheet, and solve the capital rationing problem in Example

(a) As presented

(b) Using an investment limit of $13 million.

Capital Rationing
Capital rationing is the act of placing restrictions on the amount of new investments or projects undertaken by a company. Capital rationing is the decision process used to select capital projects when there is a limited amount of funding available....