Operations Research Optimization Please answer 5,6,7,8, and 9 Thanks l, will upvote

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. Jackets Back Bags Wallets Availability 300 85 65 Price ($) Leather (m) 9 10 5 750 Labor (hours) 11 4 2 850 Machining (hours) 2 1 1 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) 6. (5 points) If the company is studying the option of reducing the availability of leather or labor working hours because of financial issues, which resource would you recommend and why? (Explain your answer based on sensitivity report only) 7. (5 points) If the company is studying to reduce one of the products prices on a sale offer, which product do you recommend and why? (Explain your answer based on sensitivity report only) 8. (20 points) What is the effect on the Z values if the company: a. Increase the price of the Back Bag by 35$ b. Increase the price of the Back Bag by 60$ Increase the price of the Jackets by 25$ C. d. Increase the price of the bracelet by 15$ e. Increase the availability of labor by 35 hours f. Decrease the availability of machining hours by 15 hours g. Decrease the availability of leather to 690 h. Decrease the availability of labor hours to 600 i. Increase the availability of leather by 100 j. Increase the availability of inspection by 150 (Explain your answer based on sensitivity report only) 9. (15 points) Assuming that cost of one unit of any additional resource (1 m leather, 1 labor hour, and 1 machine hour) is $15, answer to the questions below. (Explain your answer based on sensitivity report only) a. What is the net profit of the company if it buys extra 1-unit of each resource? Show calculations. b. If the company can buy only extra 1-unit of the mentioned resources, which one would you recommend to buy? Why