this is the solution that i received

but i am unable to solve the graph please help me solve the graph on excel

Question 2: A company manufactures two types of products, Product A and Product B. Each unit of Product A contributes a profit of $8, and each unit of Product B contributes a profit of $10. The company has limited resources: 100 hours of labor and 80 units of raw material. Product A requires 2 hours of labor and 4 units of raw material per unit, while Product B requires 3 hours of labor and 2 units of raw material per unit. The company wants to determine how many units of each product to produce to maximize their total profit. Using the graphical method, answer the following questions: 1- Formulate the objective function for this problem. 2- Write down the constraints for the company's resources (labor and raw material). 3- Create a graph with Product A on the x-axis and Product B on the y-axis. Plot the feasible region based on the resource constraints. 4- Identify the corner points of the feasible region. 5- Calculate the objective function value at each corner point. 6- Determine which combination of Product A and Product B should be produced to maximize the company's profit. 7- What is the maximum profit the company can achieve? need this to be solved in excel please Certainly, I can guide you on how to set up the linear programming problem in Excel. Let's go step by step: Explanation: 1. ObJectlve Function: The objective is to maximize the total profit, which is given by: MaximizeZ=8A+10B Here, Z is the total profit, A is the number of units of Product A, and B is the number of units of Product B. 2 Constralnts: - Labor constraint: 2A+3B100 - Raw material constraint: 4A+2B80 3. Create a Graph: In Excel, create a table with columns for A,B,Z, and the constraints. Plot the constraints on a graph using the scatter plot. Shade the feasible region. 4. Identlfy Corner Polnts: The corner points are the intersections of the lines representing the constraints within the feasible region. 5. Calculate Objectlve Function at Corner Polnts: Evaluate the objective function (Z) at each corner point. This involves substituting the values of A and B into the objective function. 6. Determine OptImal Comblnation: Identify the combination of A and B that gives the highest Z, indicating the optimal production quantity. 7. Maximum Profit: The maximum profit is the value of Z at the optimal combination of A and B