Hello I have an agricultural excel question and I am having trouble understanding the concept and steps to the problem. Below I have provided the actual question with instructions, a spare of notes, and just an example of a problem that has nothing to do with the actual question. Please the example I give you is not a apart of the actual question it is just a guide to help you and me. The actual question will be the very first and second image. The rest are notes and an example. The actual question has to do with a LP Sensitivity Analysis Problem.

Instructions and Actual Question>

.5 Instructions Build Linear Programming in MS Excel using the objective and constraints for the attached problem. Show objective function and constrains properly on Excel similar to class examples. Include necessary formulas/equations for the objective function and usages. Solve the LP problem using Excel Solver as described in class. Create answer, sensitivity and limits reports using solver tool. Create a separate worksheet for sensitivity (cost) analysis for new Store (Mega Store) option. A corporation plans on building a maximum of 11 new stores in a large city. They will build these stores in one of three sizes for each location a convenience store (open 24 hours), standard store, and an expanded services store. The convenience store requires $4.125 million to build and 30 employees to operate. The standard store requires $8.25 million to build and 15 employees to operate. The expanded-services store requires $12.3 75 million to build and 45 employees to operate. The corporation can dedicate up to $82.5 million in construction capital, and 300 employees to staff the stores. On the average, the convenience store nets $1.2 million annually, the standard store nets $2 million annually, and the expanded services store nets $2.6 million annually. How many of each should they build to maximize revenue? a) Formulate the problem on Excel. b) Find the optimal level of these stores in three sizes. c) They also want to check the feasibility of opening M new store called \"Mega Store\" after the completion of their 1 1 new stores. The mega store requires $14.75 million to build and 52 employees to operate. The store nets $3.2 annually. Is it profitable? d) What would be the minimum construction expense for the Mega Store so that it would be profitable to open it? //l//7l'00[/(/70/l/ When solving an LP problem we assume that values of all model coefficients are known with certainty. Such certainty rarely exists. Sensitivity analysis helps answer questions about how sensitive the optimal solution is to changes in various coefficients in a model. GENERAL FORM OF A LINEAR PROGRAMMING (LP) PROBLEM MAX (or MIN): c1X, + c2X2+ ...+ CX Subject to: a1X , + a 12 X2 + ... + ainX, = 0 } nonnegativityMicrosoft Excel 16.0 Answer Report Worksheet: [Lesson5-LPOptimizationUsingSolver.xIsx]Sheet1 Report Created: 10/3/2022 11:17:06 AM Result: Solver found a solution. All Constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0.015 Seconds. Iterations: 2 Subproblems: 0 Solver Options Max Time 100 sec, Iterations Unlimited, Precision 0.000001, Use Automatic Scaling Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegative Objective Cell (Max) Cell Name Original Value Final Value $D$2 Profit Max Profit $0 $66,100 Variable Cells Cell Name Original Value Final Value Integer $B$3 Decision Variables Aqua-Spas 0 122 Contin $C$3 Decision Variables Hydro-Luxes 0 78 Contin Constraints Cell Name Cell Value Formula Status Slack $D$6 Pump (unit) Usage 200 $D$6