Problem A$-7($Algo$)$

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

Assuming a linear relationship, use the Excel Solver to determine the optimal allocation of your funds. $($Leave no cells blank $-$ be certain to enter $"0"$ wherever required. Round your answers to the nearest whole number.$)$