please solve *all*

with clear writing and corect

Background Gallo manufacturer Co. produces leather Jackets, Back Bags, and Wallets. Price and resource requirements of each product along with resource availability are given in the table below. Price ($) Leather (m) Labor (hours) Machining (hours) Jackets 300 9 11 2 Back Bags 85 10 4 1 Wallets 65 5 2 1 Availability 750 850 200 Analyses 1. (5 points) Define the LP model. 2. (10 points) Use EXCEL Solver to determine the optimum production mix, show your steps with Excel screenshots, and explain the solution. 3. (5 points) Based on the optimal solution of your LP model, which resource availability do you recommend reducing in the storage? Explain your answer. 4. (15 points) Obtain the sensitivity report of EXCEL Solver and explain the report in detail. Use the Sensitivity Report to answer questions (5 to 9) 5. (10 points) (A) What is the effect of increasing leather availability by 40m2, (B) is it feasible to decrease labor hours to be 350 hours? If feasible, provide the new total revenue; if not feasible explain the reason? (Explain your answer based on sensitivity report only)