ou are trying to create a budget to optimize the use of a portion of your disposable income. You have a maximum of $$2,900$ per month to be allocated to food, shelter, and entertainment. The amount spent on food and shelter combined must not exceed $$1,300.$ The amount spent on shelter alone must not exceed $$800.$ Entertainment cannot exceed $$600$ per month. Each dollar spent on food has a satisfaction value of $4,$ each dollar spent on shelter has a satisfaction value of $5,$ and each dollar spent on entertainment has a satisfaction value of $8.$

Assuming a linear relationship, use the Excel Solver to determine the optimal allocation of your funds.

Decision for F$,$ S$,$ E and Total Satisfaction?

Resourses used $($$$)$ on

$1.$ food and shelter

$2.$ shelter

$3.$ entertainment

$4.$ Total budget.