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

Glencoe Algebra 1, Student Edition, 9780079039897, 0079039898, 2018
18th Edition
ISBN:9780079039897
Author:Carter
Publisher:Carter
Chapter5: Linear Inequalities
Section5.6: Graphing Ineualities In Two Variables
Problem 29PPS
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
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Glencoe Algebra 1, Student Edition, 9780079039897…
Glencoe Algebra 1, Student Edition, 9780079039897…
Algebra
ISBN:
9780079039897
Author:
Carter
Publisher:
McGraw Hill
PREALGEBRA
PREALGEBRA
Algebra
ISBN:
9781938168994
Author:
OpenStax
Publisher:
OpenStax
Calculus For The Life Sciences
Calculus For The Life Sciences
Calculus
ISBN:
9780321964038
Author:
GREENWELL, Raymond N., RITCHEY, Nathan P., Lial, Margaret L.
Publisher:
Pearson Addison Wesley,
Algebra for College Students
Algebra for College Students
Algebra
ISBN:
9781285195780
Author:
Jerome E. Kaufmann, Karen L. Schwitters
Publisher:
Cengage Learning
College Algebra (MindTap Course List)
College Algebra (MindTap Course List)
Algebra
ISBN:
9781305652231
Author:
R. David Gustafson, Jeff Hughes
Publisher:
Cengage Learning
Elementary Geometry For College Students, 7e
Elementary Geometry For College Students, 7e
Geometry
ISBN:
9781337614085
Author:
Alexander, Daniel C.; Koeberlein, Geralyn M.
Publisher:
Cengage,