Question: Barney Industries has manufacturing 5 manufacturing facilities (1,2,3,4,5). Manufactured products are shipped to four customer markets, A, B, C, and D. Demands in these markets (D_), capacities (K_i) and fixed costs at each manufacturing facility (G_i) are given. Fixed costs are incurred only if a manufacturing facility is open. The fixed costs for shipping from a manufacturing facility to a customer market (F_ij) and variable costs per unit shipped from a manufacturing facility to a customer market (C_ij) are also provided.Fixed costs for shipping are incurred only if non-zero units are shipped from a manufacturing facility to a customer market. Where fixed costs for shipping are blank, assume that those routes are not Part 1: Scenario A: Develop an Excel implementation of a mixed integer linear programming formulation that will minimize total variable costs only subject to constraints on demand and capacities at various facilities. Find the optimal plan and associated cost. Part 2: Scenario B: Revise your formulation for Scenario A to minimize sum of total variable and fixed costs subject to constraints on demand and capacities at various facilities. Find the optimal plan and Part 3: Scenario C: Leadership is negotiating opening some of the unavailable shipping routes. The fixed costs of shipping that would be incured if the unavailable routes were opened are given in Table 3 . Assuming these additional routes were available, revise your formulation for Scenario B to minimize sum of total variable and fixed costs subject to constraints on demand and capacities at various facilities. Which of these routes (if any) should the leadership consider opening? Part 4: Provide a mathematical formulation for Scenario C. Define all sets, parameters, variables, objective, and constraints. Part 5: Discuss your findings from the analysis in Parts 1 through 3. Question: Barney Industries has manufacturing 5 manufacturing facilities (1,2,3,4,5). Manufactured products are shipped to four customer markets, A, B, C, and D. Demands in these markets (D_), capacities (K_i) and fixed costs at each manufacturing facility (G_i) are given. Fixed costs are incurred only if a manufacturing facility is open. The fixed costs for shipping from a manufacturing facility to a customer market (F_ij) and variable costs per unit shipped from a manufacturing facility to a customer market (C_ij) are also provided.Fixed costs for shipping are incurred only if non-zero units are shipped from a manufacturing facility to a customer market. Where fixed costs for shipping are blank, assume that those routes are not Part 1: Scenario A: Develop an Excel implementation of a mixed integer linear programming formulation that will minimize total variable costs only subject to constraints on demand and capacities at various facilities. Find the optimal plan and associated cost. Part 2: Scenario B: Revise your formulation for Scenario A to minimize sum of total variable and fixed costs subject to constraints on demand and capacities at various facilities. Find the optimal plan and Part 3: Scenario C: Leadership is negotiating opening some of the unavailable shipping routes. The fixed costs of shipping that would be incured if the unavailable routes were opened are given in Table 3 . Assuming these additional routes were available, revise your formulation for Scenario B to minimize sum of total variable and fixed costs subject to constraints on demand and capacities at various facilities. Which of these routes (if any) should the leadership consider opening? Part 4: Provide a mathematical formulation for Scenario C. Define all sets, parameters, variables, objective, and constraints. Part 5: Discuss your findings from the analysis in Parts 1 through 3