Hello. The following problem must be solved in Excel using Solver, with the Simplex Linear Programming engine:

You need to withdraw money from an interest$-$bearing savings account into a short$-$term, daily use cash account. On Monday morning, you have $$3000$ in cash on hand in the daily use account. For the next seven days, the following cash requirements must be met: Monday, $$5000$; Tuesday, $$6000$; Wednesday, $$9000$; Thursday, $$2000$; Friday, $$7000$; Saturday, $$2000$; Sunday, $$3000.$ At the beginning of each day, you must decide how much money $($if any$)$ to withdraw from the interest$-$bearing account into the daily cash account. It costs $$10$ to make a withdrawal of any size. You believe that the opportunity cost of having $$1$ of cash on hand for a year is $$0\mathrm{.}20.$ Assume that opportunity costs are incurred on each day$$s ending balance $($$$0\mathrm{.}20/365).$ Determine how much money you should withdraw from the bank during each of the next seven days.