please need help ASAP in excel nothing else

NOT word document

NOT programming

ONLY EXCEL PLZZZZZZ

not like these word below i submit.

just excel with shown formula.

thank you

print (f "production of C (Z): (Z.vaeValue)") print (f "Maximum Profit: \$\{pulp.value(model.objective)\}") This code sets up the problem, defines the objective function, adds constraints, and then uses the PuLP library to solve the integer programming problem. The optimal production quantities and maximum profit will be printed as the output. Explanation: To maximize profit, produce 400 units of A, 300 units of B, and 300 units of C, resulting in a maximum profit of $860,000 per week. Step 2/2 Here are the main key points: 1. Frigid Air company produces three types of refrigerators: A,B, and C. 2. The Plant capacity is 1000 units per week. 3. Unit prices: A=$1000,B=$1200,C=$1500 4. Manufacturing costs: A=200A+A2, B=250B+B2,C=350C+C2. 5. Maximize profit by finding integer production quantities. 6. Set up an objective function to maximize profit. 7. Subject to constraints: production capacity and non-negativity. 8. Use an integer programming solver to find optimal production quantities. Here is a simplified Python code using the PULP library to solve this problem: Import pulp \# Create a Linear Programming problem model = pulp.LpProblem("Maximize_Profit" , pulp.LpMaximize) \# Define decision variable (integer) X= pulp.LpVariable("X", lowBound=0, cat='Integer') Y= pulp.LpVariable("Y" lowBound=0, cat="Integer") Z= pulp.LpVariable("Z" lowBound=0, cat='Integer') # Define the objective function model+=(1000X+1200Y+1500Z)(200X+X2+250Y+Y2+350Z+Z2) \# Add constraints model+=X+Y+Z0,Y>0,Z>0 (you cannot produce a negative number of units). To solve these nonlinear optimization problems, you can use various optimization techniques, such as a numerical solver or optimization software. Since you mentioned that production numbers should be integers, you can use an integer programming solver to find the optimal integer values of X,Y and Z that maximize P