You are trying to create a budget to optimize the use of a


You are trying to create a budget to optimize the use of a portion of your disposable income. You have a maximum of $2,700 per month to be allocated to food, shelter, and entertainment. The amount spent on food and shelter combined must not exceed $1,400. The amount spent on shelter alone must not exceed $800. Entertainment cannot exceed $700 per month. Each dollar spent on food has a satisfaction value of 2, each dollar spent on shelter has a satisfaction value of 8, and each dollar spent on entertainment has a satisfaction value of 5. Assuming a linear relationship, use the Excel Solver to determine the optimal allocation of your funds. (Round your answers to the nearest whole number.)

Request for Solution File

Ask an Expert for Answer!!
Operation Management: You are trying to create a budget to optimize the use of a
Reference No:- TGS02438963

Expected delivery within 24 Hours