2. Do in excel and show all steps

Problem 2. Sports Products, Inc. wants to determine the number of All-Pro (A) and College (C) footballs to produce in order to maximize profit over the next four-week planning horizon. Constraints affecting the production quantities are the production capacities in three departments: cutting and dyeing (CD); sewing (S); and inspection and packaging (IP). For the four-week planning period, 340 hours of cutting and dyeing time, 420 hours of sewing time, and 200 hours of inspection and packaging time are available. All-Pro footballs provide a profit of \$5 per unit and College footballs provide a profit of $4 per unit. The linear programming model with production times expressed in minutes is as follows: Maximize Z=5A+4C Subject to: 12A+6C20,4009A+15C25,2006A+6C12,000A,C0CuttinganddyeingSewingInspectionandpackaging a. Graph the constraints and show the region of feasible solutions. b. Solve the problem and find the optimum solution. Give the results in the following table. SHOW YOUR GRAPH BELOW, a. Graph the constraints and show the region of feasible solutions. b. Solve the problem and find the optimum solution. Give the results in the following table. SHOW YOUR GRAPH BELOW. a. Determine the coordinates of each extreme point and the corresponding profit. Write your answers in the following table