ASAP. OPERATION MANAGEMENT

Clearly construct the Model with objective function and all the constraints. Solve the problem using excel solver. Write down the solution providing brief explanation of each step. You need to clearly write down the value of each variable including slack variables and optimum value of the objective function. Please as well indicate the binding constraints. Question 1 (40 pts): Bilim farms uses at least 800 lb of special feed daily. The special feed is a mixture of corn and soybean meal with the following compositions: Ib per lb of feedstuff Feedstuff Protein Fiber Cost ($/lb) 0.09 0.02 0.30 Corn 0.60 0.06 0.90 Soybean Meal The dietary requirements of the special feed are at least 30% protein and at most 5% fiber. Bilim Farms wishes to determine the daily minimum-cost feed mix. Please clearly fulfil the parts below: Decision Variables (5 pts): Objective Function (5 pts): Model Constraints (15 pts): Optimal solution with corresponding values of the variables (15 pts)