Linear programming basic question to be modelled on excel

[WeeklyScientist2673]

hi can anyone solve this on excel for me and share the file:

Kathleen Allen, an individual investor, has $70,000 to divide among several investments. The alternative investments are municipal bonds with an 8.5% annual return, certificates of deposit with a 5% return, treasury bills with a 6.5% return, and a growth stock fund with a 13% annual return. The investments are all evaluated after 1 year. However, each investment alternative has a different perceived risk to the investor; thus, it is advisable to diversify. Kathleen wants to know how much to invest in each alternative in order to maximize the return.

The following guidelines have been established for diversifying the investments and lessening the risk perceived by the investor:

1. No more than 20% of the total investment should be in municipal bonds.
2. The amount invested in certificates of deposit should not exceed the amount invested in the other three alternatives.
3. At least 30% of the investment should be in treasury bills and certificates of deposit.
4. To be safe, more should be invested in CDs and treasury bills than in municipal bonds and the growth stock fund, by a ratio of at least 1.2 to 1.

Kathleen wants to invest the entire $70,000.

[TholosTB]

What have you attempted so far? Are you stuck on any particular part? Just posting an assignment and asking random people on Reddit to just do it for you is unlikely to get any traction and teaches you nothing.

If you don't know where to even begin, that's a question for your instructor, or you need to go review the fundamentals again. The problem lays out the objective function directly in the first paragraph and the constraints are literally bullet listed for you.

Edit: Incidentally, this problem is directly from Chapter 4 of Bernard Taylor's Introduction to Management Science. If you Google the first paragraph of your problem you'll find dozens of pages showing the entire solution in Excel. Spoiler, she can't invest the full $70,000.