Please show how to calculate this within Excel with formulas.

Problem 2. Ahmadi, Inc. wants to determine the amount of each of three products to produce over the coming planning period. The following information regarding labor availability, labor utilization, and product profitability are provided. Departments A B D Profit per unit ($) Required Time (minutes/unit) Product 1 Product 2 Product 3 Labor - Minute Available 22 28 30 48000 20 22 32 40000 25 30 30000 25 35 28 50000 200 240 190 22 Develop a linear programming model for Ahmadi, Inc. b. Solve the model and determine the optimal production quantities of products. Give the values of the decision variables, slacks, and the value of the objective function. C. Suppose that 2500, and 4000 minutes of overtime may be scheduled in departments B, and C, respectively. The cost per hour of overtime is $30 in department B, and $120 in department C. Formulate a linear programming model that can be used to determine the optimal production quantities if overtime is made available. d. Solve the new model and determine the optimal production quantities of products. Give the values of the decision variables, slacks, and the value of the objective function. Problem 2. Ahmadi, Inc. wants to determine the amount of each of three products to produce over the coming planning period. The following information regarding labor availability, labor utilization, and product profitability are provided. Departments A B D Profit per unit ($) Required Time (minutes/unit) Product 1 Product 2 Product 3 Labor - Minute Available 22 28 30 48000 20 22 32 40000 25 30 30000 25 35 28 50000 200 240 190 22 Develop a linear programming model for Ahmadi, Inc. b. Solve the model and determine the optimal production quantities of products. Give the values of the decision variables, slacks, and the value of the objective function. C. Suppose that 2500, and 4000 minutes of overtime may be scheduled in departments B, and C, respectively. The cost per hour of overtime is $30 in department B, and $120 in department C. Formulate a linear programming model that can be used to determine the optimal production quantities if overtime is made available. d. Solve the new model and determine the optimal production quantities of products. Give the values of the decision variables, slacks, and the value of the objective function