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
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
Chapter1: Equations, Inequalities, And Mathematical Modeling
Section1.7: Linear Inequalities In One Variable
Problem 6ECP
Related questions
Question
please answer in text form and in proper format answer with must explanation , calculation for each part and steps clearly
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
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by step
Solved in 2 steps
Recommended textbooks for you
Algebra for College Students
Algebra
ISBN:
9781285195780
Author:
Jerome E. Kaufmann, Karen L. Schwitters
Publisher:
Cengage Learning
College Algebra (MindTap Course List)
Algebra
ISBN:
9781305652231
Author:
R. David Gustafson, Jeff Hughes
Publisher:
Cengage Learning
Algebra for College Students
Algebra
ISBN:
9781285195780
Author:
Jerome E. Kaufmann, Karen L. Schwitters
Publisher:
Cengage Learning
College Algebra (MindTap Course List)
Algebra
ISBN:
9781305652231
Author:
R. David Gustafson, Jeff Hughes
Publisher:
Cengage Learning
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
Elementary Geometry For College Students, 7e
Geometry
ISBN:
9781337614085
Author:
Alexander, Daniel C.; Koeberlein, Geralyn M.
Publisher:
Cengage,