Please show the solution using Excel Solver, thanks!

1. Southern Sporting Goods Company makes basketballs and footballs. Each product is produced from two resources, rubber and leather. The resource requirements for each product is listed below as is the total resource. Product Rubber (lb.) Leather ft.2 Profit Basketball 3 4 $12 Football 2 5 $16 Total Resources Available 500 lb. 800 ft.2 a) Formulate the linear Programming model b) Graph the constraints c) Identify 2 points within the feasible region that are not on the border and determine the profit of each. d) Create a series of 3 parallel lines that represent changes in the z-value of the objective function. e) Identify the optimal solution. f) Add the marketing constraint that no more 100 basketballs. What is the impact on the optimal production plan