Hello, I have an excel mathematical question and need help building Linear Programming in MS Excel using the objective and constraints for the attached problem. I am having trouble showing the objective function and constraints correctly on how to formulate the model for this problem in Excel. I have attached the question below with an example of another practice model on how it should look and the steps to formulating the problem. The formula is in cell D2.

The 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 $12375 million to build and 45 employees to operate. The corporation can dedicate $82.5 million in constiuction 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? Formulate the model for this problem in excel. Let X1 = # of convenience store X2 = # of standard store X3 = # of expanded-services store \fFile Home Insert Draw Page Layout Formulas Data Review View Help X Cut Calibri 11 v A A ab Wrap Text LE Copy v Paste BIUV v v A v = Merge & Center Format Painter Undo Clipboard Font Alignment D2 V : XVfx =B2*B3+C2*C3 A B C D E F G H L Aqua Spa Hydro Lux Max Profit Unit Profit $350 $300 $61,300 60900 3 Decision Variables 170 6 A 5 Constraints Usage Relation Limit 6 Pump (unit) H 176 = OH 10 Non-negativity X2 1 6 >= 0 11 12 13 145 STEPS IN FORMULATING LP MODELS: 1. Understand the problem. 2. Identify the decision variables. X, =number of Aqua-Spas to produce X,=number of Hydro-Luxes to produce 3. State the objective function as a linear combination of the decision variables. MAX: 350X, + 300X25 STEPS IN FORMULATING LP MODELS (CONTINUED) 4. State the constraints as linear combinations of the decision variables. 1X, + 1X, = 0 X, >= 0SOLVING LP PROBLEMS AN INTUITIVE APPROACH Idea: Each Aqua-Spa (X, ) generates the highest unit profit ($350), so let's make as many of them as possible! How many would that be? " Let X2 = 0 - 1 st constraint: 1X, = bk . . fm(X1, X21 ...1 Xn)=bm Note: If all the functions in an optimization are linear, the problem is a Linear Programming (LP) problem\fBlue Ridge Hot Tubs produces Two types of hot 'rubs: Aqua-Spas & Hydro-Luxes. Aqua-Spa Hydro-Lux Pumps 1 1 Labor 9 hours 6 hours Tubing 12 feet 16 feet Uni'r Profit $350 $300 There are 200 pumps, 1566 hours of labor, and 2880 feet of tubing available