Subject: Operation Research/ Management Science/Data Science

Please screenshot every process. If not possible, please attach the link for the spreadsheet (can be google sheets). Please read every steps. I will surely upvote for you effort Please read #1, #2, and #4 for the way on how the problem should be solved. Thank you.

Muir Manufacturing produces two popular grades of commercial carpeting among its many other products. In the coming production period, Muir needs to decide how many rolls of each grade should be produced to maximize profit. Each roll of Grade X carpet uses 50 units of synthetic fiber, requires 25 hours of production time, and needs 20 units of foam backing. Each roll of Grade Y carpet uses 40 units of synthetic fiber, requires 28 hours of production time, and needs 15 units of foam backing. The profit per roll of Grade X carpet 1s $200 and the profit per roll of Grade Y carpet 1s $160. In the coming production period, Muir has 3000 units of synthetic fiber available for use. Workers have been scheduled to provide at least 1800 hours of production time (overtime is a possibility). The company has 1500 units of foam backing available for use. 1. Develop the mathematical model: Objective Function and Constraints. 2. Solve the problem using Graphical Method - Use Excel to graph the model and show the feasible region. Label the graph completely and properly. - Determine the optimal point and give the optimal solution and the value of the Objective Function. - Identify the binding constraints. - Perform the sensitivity analysis indicating the coordinates of the points used. - Calculate the dual values. 4. Solve using Excel Solver. Include a separate table showing all the equations in the exact cell used