Hello I have an excel mathematical question and need help formulating a model. Below I have attached the question of the problem and notes and examples all in order that I hope are helpful. I am having trouble understanding the concept.

Question>

Sheet view D2 V XV fx =B2*B3+C2*C3 A B C D E G Aqua Spa Hydro Lux Max Profit 2 Unit Profit $350 $300 $61,300 3 Decision Variables 170 6 4 5 Constraints Usage Relation Limit 6 Pump (unit) 176 = O O 10 Non-negativity X2 6 >= 11 121. The Happy Pet pet food company produces dog and cat food. Each food is comprised of meat, soybeans and llers. The company earns a prot on each product but there is a limited demand for them. The pounds of ingredients required and available, prots and demand are summarized in the following table. The company wants to plan their product mix, in terms of the number of bags produced, in order to maximize prot. Prot Demand Pounds of Pounds of Pounds of Product per Bag for Meat per Soybeans Filler per (33) product bag per bag bag Dog food 4 4O 4 6 4 Cat food 5 3O 5 3 1 Material available (pounds) 100 120 160 Formulate the model for this problem in excel. Let X1 = bags of Dog food to produce X2 = bags of Cat food to produce INTRODUCTION We all face decision about how to use limited resources such as: - Oil in the earth - Land for dumps - Time - Money - WorkersMATHEMATICAL PROGRAMMING... MP is a field of management science that finds the optimal, or most efficient, way of using limited resources to achieve the objectives of an individual or a business. a.k.a. OptimizationAPPLICATIONS OF OPTIMIZATION Determining Product Mix Manufacturing Routing and Logistics Financial Planning\fJIM'S WINERY Jim's winery blends fine wines for local restaurants. One of his customers has requested a special blend of two burgundy wines, call them A and B. The customer wants 500 gallons of wine and it must contain at least 100 gallons of A and be at least 45% B. The customer also specified that the wine have an alcohol content of at least 12%. Wine A contains 14% alcohol while wine B contains 10%. The blend is sold for $10 per gallon. Wine A costs $4 per gallon and B costs $3 per gallon. The company wants to determine the blend that will meet the customer's requirements and maximize profit. JIM'S WINERY Formulate the model for this problem in excel. Let X1 = Gallons of wine A in mix X2 = Gallons of wine B in mixFile Home Insert Draw Page Layout Formulas Data Review View He Default Page Layout -100 H Normal Page Break I Custom Views Show Zoom 100% Zoom Preview Selecti Sheet View Workbook Views Zoom H6 : XVfx A B C D E F G Aqua Spa Hydro Lux Max Profit 2 Unit Profit $350 $300 $61,300 3 Decision Variables 170 6 A UT Constraints Usage Relation Limit 6 Pump (unit) 176 = 10 Non-negativity X2 6 > = 0 11 12 13 14 15 16 W N - OO OO - 24File Home Insert Draw Page Layout Formulas Data Review View Help G Calibri v 11 = ab General Condi B I UAA $ ~ % " Forma Paste A = = 00 .00 Cell St Undo Clipboard Font Alignment Number E1 V : XVfx A B C D E F G Dog Food Cat Food Max Profit 2 Unit Profit 3 Decision Variables X1 X2 A 5 Constraints Usage Relation Limit 6 Profit Per Bag ($) 4 5 = 0 10 Pounds of Filler Per Bag 4 > = 0 11 Non-negativity X1 > = 0 12 Non-negativity X2 O O > = 13 14 15 16 17 18 19 20File Home Insert Draw Page Layout Formulas Data Review View Help G Calibri 11 General BIUAA $ ~ % " Paste 00 .00 Undo Clipboard Font Alignment Number B4 vi XVfx A B C D E F G Wine A Wine B Minimize Cost Max Profit IN Cost $4 $3 $1,775 $3,225 w Decision Variable 275 225 A 5 Constraints Usage Relation Limit 6 Wine A in Blend 275 >= 100 Wine B in Blend 225 >= 225 8 Alcohol Content 14% 10% 61 > = 60 9 Total Production 500 = 500 10 Non-negativity X1 HOR 275 >= OH 11 Non-negativity X2 225 >= O 12 13 14 15 16 17 18 19\f5 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