ou are trying to create a budget to optimize the use of a portion of your disposable income. You have a maximum of $2,700 per month to be allocated to food, shelter, and entertainment. The amount spent on food and shelter combined must not exceed $1,800. The amount spent on shelter alone must not exceed $1,000. Entertainment cannot exceed $500 per month Each dollar spent on food has a satisfaction value of 8, each dollar spent on shelter has a satisfaction value of 3, and each dollar spent on entertainment has a satisfaction value of 3.
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.)
Decision for F
Decision for S
Decision for E
Total Satisfaction
Resources Used
Total budget
$ on food and shelter
$ on shelter
$ on entertainment
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"
