Non linear programming. Specify decision variables, objective function and constraints.

Solve in Excel using solver very clearly and give optimal ordering plan

2) A manufacturer stocks four items, each requiring a certain amount of floor space in the warehouse. A limited number of square feet of floor space is available to store the total quantity of the four products that are ordered. Develop a model based on the economic order quantity to minimize the total cost and meet the floor space limitation. Assume that the carrying charge rate is 20% and that 500 square feet of floor space are available for storage. A. Provide the complete nonlinear programming formulation. Clearly specify decision variables, objective function and constraints. B. Create a spreadsheet model for the problem and use Solver to find the optimal solution. Separate input data from calculations. Include all the input data provided in the Word problem and use Excel to perform calculations. a. Provide a screenshot of the model. Use '=FORMULATEXT' to show the calculation for the objective function and the left hand side of the constraints. b. Provide a screenshot of the Answer Report including the top section with the log from Solver. C. What is the optimal ordering plan and the minimum total cost? Communicate the recommendation in plain English. It is acceptable to use tables for clarity. 2) A manufacturer stocks four items, each requiring a certain amount of floor space in the warehouse. A limited number of square feet of floor space is available to store the total quantity of the four products that are ordered. Develop a model based on the economic order quantity to minimize the total cost and meet the floor space limitation. Assume that the carrying charge rate is 20% and that 500 square feet of floor space are available for storage. A. Provide the complete nonlinear programming formulation. Clearly specify decision variables, objective function and constraints. B. Create a spreadsheet model for the problem and use Solver to find the optimal solution. Separate input data from calculations. Include all the input data provided in the Word problem and use Excel to perform calculations. a. Provide a screenshot of the model. Use '=FORMULATEXT' to show the calculation for the objective function and the left hand side of the constraints. b. Provide a screenshot of the Answer Report including the top section with the log from Solver. C. What is the optimal ordering plan and the minimum total cost? Communicate the recommendation in plain English. It is acceptable to use tables for clarity