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.

CAR PRODUCTION Objective and Constraints: Suppose we need to produce at least 400 cars at plant 3 according to a labor agreement. We have 3300 hours of labor and 4000 units of material available. We are allowed to produce 12000 units of pollution, and we want to maximize the number of cars produced. How can we model this problem?PROBLEM SET UP 1. What are the decision variables? x1, x2, x3, x4, where xi denotes the number of cars at plant i. 2. What is our objective? maximize x1 + x2 + x3 + x4. 3. What are the constraints? x3 2 400 2x1 + 3x2 + 4x3+ 5x4 = 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. 2. A diet chart shows calories, protein, carbohydrate and fat content for four food items below. Sara wants a diet with minimum cost. The diet chart is as follows: Food Item 1 Food Item 2 Food Item 3 Food Item 4 Calories 400 200 150 500 Protein (in grams) 3 2 0 0 Carbohydrates ( in grams) 2 2 4 4 Fat (in grams) 2 4 l 5 Cost $0.50 $0.20 $0.30 $0.80 The chart gives the nutrient content as well as the per-unit cost of each food item. The diet has to be planned in such a way that it should contain at least 1,250 calories, 8 grams of protein, 10 grams of carbohydrates and 8 grams of fat. Formulate the model for this problem in excel. Let X1 = Food Item 1 X2 = Food Item 2 X3 = Food Item 3 X4 = Food Item 4