LP problem, submit a detail Answer and Sensitivity report. You are to provide written explanation for each of the answers.

Winco sells four types of products. The resources needed to produce one unit of each and the sales prices are given in the table.Currently, 4600 units of raw material and 5000 labor hours are available. To meet customer demands, exactly 950 total units must be produced. Customers also demand that at least 400 units of product 4 be produced.

Costs and Resource Requirements for Winco

Resource	Product 1	Product 2	Product 3	Product 4
Raw Material	2	3	4	7
Hours of labor	3	4	5	6
Sales price($)	4	6	7	8

Formulate an LP that can be used to maximize Wincos sales revenue.

1. Provide a verbal statement of a linear programming model than can be used by the accounting department.

2. Convert the verbal statement to an algebraic model

3. Obtain an optimal solution for the model and discuss the followings:

i) Reduced Costs

ii) Range of Optimality

iii) Shadow Prices and Ranges of Feasibility

4. Submit both the Report and the Excel spreadsheet.