The Problem: 11 Bus/Econ 309, Fall 2022 Linear Programming using Excel Solver and GeoGebra The EverSure Footwear Company wants to determine the number of All Pro (A) and Jogger (J) shoes to produce to maximize profit over the month planning period. 11 Constraints affecting the production quantities are the production capacities in three departments: cutting and dyeing; sewing; and inspection and packaging. For the planning period, 340 hours of cutting and dyeing time, 420 hours of sewing time, and 200 hours of inspection and packaging time are available. The All Pro shoe (A) provides a profit of $5 per shoe, and the Jogger shoe (J) provides a profit of $4 per shoe. Operation (minutes per shoe) Shoe Model Cut and dye Sew Inspect & package 33 All Pro (A) 12 Jogger (J) 9 6m 6mm 15 6m Note: convert all times to minutes T T Your Assignment: a) Use Excel Solver to determine the number of All Pro and Jogger shoes that will maximize profit? Tum in a printout of your final Solver spreadsheet, with all relevant data and formulas. Use the recorded lecture to guide your work. b) Use GeoGebra to identify the feasible region and solution to the problem. Turn in a graphic copy of the GeoGebra graphic solution. On the graph, identify the optimal (XX) solution point