Formulate and solve the following linear program in excel please show me the calculation and how to get the answers too :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,100. The amount spent on shelter alone must not exceed $800. Entertainment cannot exceed $400 per month. Each dollar spent on food has a satisfaction value of 2, each dollar spent on shelter has a satisfaction value of 3, and each dollar spent on entertainment has a satisfaction value of 5.a. Write the Objective Function and Constraints for this problem.b. Assuming a linear relationship, use the Excel Solver to determine the optimal allocation of your funds.c. Report the maximum value of the Objective function.