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
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
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 & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage
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
Algebra & Trigonometry with Analytic Geometry
Algebra
ISBN:
9781133382119
Author:
Swokowski
Publisher:
Cengage
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