please showing the solving steps. thank u

Sensitivity analysis offers a variety of tools or methods that allow us to gauge what would happen to linear programming solutions given changes in certain parameters. This makes sensitivity analysis very valuable in an uncertain and volatile economy, where parameters are often not known with certainty. This will most likely be the case for many small businesses as they plan to reopen and restart operations after COVID-19 restrictions are eased. Small businesses in the Ottawa area will likely face many challenges as they attempt to make decisions on ordering more inventory, scheduling employees, marketing their business to rebuild the cliental, among others. As Telfer students, you're developing a unique skillset that can help these small businesses through these challenging times. Your task for the first part of this assignment is to apply what you have learned in class and propose a problem that a small business in Ottawa will face when they reopen (be creative and make something up - no need to contact a real business here). Your problem must be solvable using linear programming and you will be asked to apply sensitivity analysis methods to the problem The following conditions must be met. Have 4 or 5 decision variables Have 4 constraints (not counting non-negatives) and at least 2 of the 4 constraints must have non-zero coefficients for all decision variables There must be a unique optimal solution that is not the trivial solution (i.e., all Os) The problem you propose should not take more than half a page to communicate and you will be graded on the following. Difficulty: You should challenge yourself with the problem that you are developing. A challenging problem would be able to correctly integrate some of the formulation concepts discussed in class (e.g., percentage constraints, double subscript notation, a variety of s, 2,= constraints). Originality: You must make up the problem yourself and you may not use one that was presented in class or found on the internet. Your TA will search for your problem on the internet to see how original it is. If it is a copy paste from the internet, you will not receive any marks for this problem as that is plagiarism (advice: don't share what you're working on with other groups). Logical: Can it be solved using linear programming? Have you considered the assumptions of a linear programming problem? 1. Present the problem you are proposing to solve and all required information to solve it (max half a page of text - tables may exceed this) 2. Present the LP formulation for the problem you proposed. 3. Solve the problem using Excel and attach the Excel layout, answer report, and sensitivity report. 4. Communicate the solution using a managerial statement. 5. Explain how the following concepts apply to your problem. The idea here is to present information so that the manager of this small business can look at your sensitivity report and answer any questions they have after they're no longer your client. There is no need to present the definition for the concepts, instead the focus should be on how it applies to your problem. a. Reduced cost. Do any decision variables have a reduced cost? What does the reduced cost mean relative to the context of your problem? b. Explain what the range of optimality means for two of your decision variables. c. Explain what the range of feasibility means relative to your problem. d. Is there a shadow price? If so, what does it mean and how can the manager interpret this value? If not, why not? Sensitivity analysis offers a variety of tools or methods that allow us to gauge what would happen to linear programming solutions given changes in certain parameters. This makes sensitivity analysis very valuable in an uncertain and volatile economy, where parameters are often not known with certainty. This will most likely be the case for many small businesses as they plan to reopen and restart operations after COVID-19 restrictions are eased. Small businesses in the Ottawa area will likely face many challenges as they attempt to make decisions on ordering more inventory, scheduling employees, marketing their business to rebuild the cliental, among others. As Telfer students, you're developing a unique skillset that can help these small businesses through these challenging times. Your task for the first part of this assignment is to apply what you have learned in class and propose a problem that a small business in Ottawa will face when they reopen (be creative and make something up - no need to contact a real business here). Your problem must be solvable using linear programming and you will be asked to apply sensitivity analysis methods to the problem The following conditions must be met. Have 4 or 5 decision variables Have 4 constraints (not counting non-negatives) and at least 2 of the 4 constraints must have non-zero coefficients for all decision variables There must be a unique optimal solution that is not the trivial solution (i.e., all Os) The problem you propose should not take more than half a page to communicate and you will be graded on the following. Difficulty: You should challenge yourself with the problem that you are developing. A challenging problem would be able to correctly integrate some of the formulation concepts discussed in class (e.g., percentage constraints, double subscript notation, a variety of s, 2,= constraints). Originality: You must make up the problem yourself and you may not use one that was presented in class or found on the internet. Your TA will search for your problem on the internet to see how original it is. If it is a copy paste from the internet, you will not receive any marks for this problem as that is plagiarism (advice: don't share what you're working on with other groups). Logical: Can it be solved using linear programming? Have you considered the assumptions of a linear programming problem? 1. Present the problem you are proposing to solve and all required information to solve it (max half a page of text - tables may exceed this) 2. Present the LP formulation for the problem you proposed. 3. Solve the problem using Excel and attach the Excel layout, answer report, and sensitivity report. 4. Communicate the solution using a managerial statement. 5. Explain how the following concepts apply to your problem. The idea here is to present information so that the manager of this small business can look at your sensitivity report and answer any questions they have after they're no longer your client. There is no need to present the definition for the concepts, instead the focus should be on how it applies to your problem. a. Reduced cost. Do any decision variables have a reduced cost? What does the reduced cost mean relative to the context of your problem? b. Explain what the range of optimality means for two of your decision variables. c. Explain what the range of feasibility means relative to your problem. d. Is there a shadow price? If so, what does it mean and how can the manager interpret this value? If not, why not