You are trying to create a budget to optimize the use of a portion of your disposable income. You have a maximum of $1,5

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899603
Joined: Mon Aug 02, 2021 8:13 am

You are trying to create a budget to optimize the use of a portion of your disposable income. You have a maximum of $1,5

Post by answerhappygod »

You are trying to create a budget to optimize the use of aportion of your disposable income. You have a maximum of $1,500 permonth to be allocated to food, shelter, and entertainment. Theamount spent on food and shelter alone must not exceed $800.Entertainment cannot exceed $1,100. The amount spent on shelteralone must not exceed $800. Entertainment cannot exceed $400 permonth. Each dollar spent on food has a satisfaction value of 2,each dollar spent on shelter has a satisfaction value of 3, andeach dollar spent on entertainment has a satisfaction value of5
1. Write the objective function and constraints for thisproblem
2. Assuming a linear relationship, use the Excel solver todetermine the optimal allocation of your funds
3. Report the maximum value of the objective function
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Post Reply