You are trying to create a budget to optimize the use of a portion of your disposable income. You have a maximum of $1,500 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 $200 per month. Each dollar spent on food has a satisfaction value of 7, each dollar spent on shelter has a satisfaction value of 4, 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. (Leave no cells blank - be certain to enter "O" wherever required. Round your answers to the nearest whole number.) Decision for F Decision for S Decision for E Total Satisfaction Total budget $ on food and shelter $ on shelter $ on entertainment Resources Used

Algebra & Trigonometry with Analytic Geometry
13th Edition
ISBN:9781133382119
Author:Swokowski
Publisher:Swokowski
Chapter9: Systems Of Equations And Inequalities
Section: Chapter Questions
Problem 13T
Question

please answer in text form and in proper format answer with must explanation , calculation for each part and steps clearly

You are trying to create a budget to optimize the use of a portion of your disposable income. You have a maximum of $1,500 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 $200 per month. Each dollar spent on food
has a satisfaction value of 7, each dollar spent on shelter has a satisfaction value of 4, 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. (Leave no cells blank - be
certain to enter "O" wherever required. Round your answers to the nearest whole number.)
Decision for F
Decision for S
Decision for E
Total Satisfaction
Total budget
$ on food and shelter
$ on shelter
$ on entertainment
Resources
Used
Transcribed Image Text:You are trying to create a budget to optimize the use of a portion of your disposable income. You have a maximum of $1,500 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 $200 per month. Each dollar spent on food has a satisfaction value of 7, each dollar spent on shelter has a satisfaction value of 4, 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. (Leave no cells blank - be certain to enter "O" wherever required. Round your answers to the nearest whole number.) Decision for F Decision for S Decision for E Total Satisfaction Total budget $ on food and shelter $ on shelter $ on entertainment Resources Used
Expert Solution
steps

Step by step

Solved in 2 steps

Blurred answer
Recommended textbooks for you
Algebra & Trigonometry with Analytic Geometry
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage
College Algebra (MindTap Course List)
College Algebra (MindTap Course List)
Algebra
ISBN:
9781305652231
Author:
R. David Gustafson, Jeff Hughes
Publisher:
Cengage Learning
Algebra for College Students
Algebra for College Students
Algebra
ISBN:
9781285195780
Author:
Jerome E. Kaufmann, Karen L. Schwitters
Publisher:
Cengage Learning
College Algebra
College Algebra
Algebra
ISBN:
9781337282291
Author:
Ron Larson
Publisher:
Cengage Learning