Hi, can you help me solve this linear programming case. The table of data is provided below. The question is to use the Solver function of a spreadsheet (ex. Excel) to come up with the optimal solution using a specific linear programming model. You can use an optimization model for this particular example. If a sensitivity analysis is to be used, what is the answer that the Solver will provide? Thank you.

3.5. Consider a resource-allocation problem having the following data. Resource Usage per Unit of Each Activity Amount of Resource Resource 1 2 3 4 Available P 3 5 -2 400 Q 2 300 R 6 3 2 400 -2 2 5 3 300 Contribution $11 $9 $9 per unit Coat bution per unit = prost por unn of the activity a. Formulate a linear programming model for this problem on a spreadsheet. b. Make five guesses of your own choosing for the optimal solution, Use the spreadsheet to check each one for feasibility and. if feasible, for the value of the objective function. Which feasible guess has the best objective function value? c Use Solver to find an optimal solution