Please solve using excel solver show what values$/$the formulas were used for the DV cell and the objective function cell. I have set up my values already, just having trouble figuring out what goes where to have enough data to feed the solver. So basically i need the formula$/$ components of what is in the fornula of the objective function and what to input into the DV spot so i can get my left hand side values, thank you!

Note: All decision variables are expressed in thousands of dollars.

If required, round your answers to five decimal places. For subtractive or negative numbers use a minus sign even if there is a $+$ sign before the blank. $($Example:

$-300)$

Round your answer to the nearest dollar. If an amount is zero, enter $"0"$

As part of the settlement for a class action lawsuit, Hoxworth Corporation must provide sufficient cash to make the following annual payments $($in thousands of dollars$)$:

The annual payments must be made at the beginning of each year. The judge will approve an amount that, along with earnings on its investment, will cover the annual

payments. Investment of the funds will be limited to savings $($at $4\%$ annually$)$ and government securities$,$ at prices and rates currently quoted in The Wall Street

Journal.

Hoxworth wants to develop a plan for making the annual payments by investing in the following securities $($par value $=$$$1000).$ Funds not invested in these securities

will be placed in savings.

Assume that interest is paid annually. The plan will be submitted to the judge and, if approved, Hoxworth will be required to pay a trustee the amount that will be

required to fund the plan.

a$.$ Use linear programming to find the minimum cash settlement necessary to fund the annual payments.

Let

$F=$ total funds required to meet the six years of payments

$G_1=$ units of government security $1$

$G_2=$ units of government security $2$

$S_i=$ investment in savings' at the beginning of year $i$