BUSM $36000$ Linear Programming Case #$1$ WELTE MUTUAL FUNDS Welte Mutual Funds, Inc., located in New York City has just VU$07$ obtained $$100,000$ by converting industrial bonds to cash and is now looking for other investment opportunities for these funds. Based on Welte's current investments, the firm's top financial analyst recommends that all new investments be made in the oil industry, steel industry, or in government bonds. Specifically, the analyst has identified five investment opportunities and projected their annual rate of return. The investments and rates of return are shown in the following table: INESTMENT OPPORTUNTIES FOR WELTE MUTUAL FUNDS Projected rate of return$\%7\mathrm{.}3103$ Investment Atlantic Oil Pacific Oil Midwest Steel Huber steel Government bonds $6\mathrm{.}47\mathrm{.}54\mathrm{.}5$ Management of Welte imposed the following investment guidelines: $1.$ Neither industry Coil or steel$)$ should receive more than $$50,000.2.$ Government bonds should be at least $25\%$ of the steel industry investment. $3.$ The investment in Pacific Oil, the high$-$retum but high$-$risk investment cannot be more than $60\%$ of the total oil industry investment. $1.$ Formulate a Linear$-$programming Model for Welte Mutual Funds. $(10)2.$ What portfolio recommendations $\_$investments and amounts $\_$should be made for the available $$100,000?$ Provide your Excel solution along with all the reports generated through Excel $(5)3.$ Write a report that explains your findings. $(5)$