please answer with excel file screenshots and steps
Compared to the optimal solution of the first case, what would be the additional cost, that can be considered as the social contribution of PetroRefine SA to support Lagos as part of its Corporate Social Responsibility. Formulate a Mixed Integer Program ad solve it using Excel Solver. As part of an environmental policy, PetroRefine SA would like to explore the possibilities of minimizing the CO2 emissions from its production and transportation operations, while satisfying its demand, regardless of the impact on its cost. Propose a supply chain network design that minimizes the CO2 emissions of the company while satisfying the demand while using the same capacity options as above, including the site of Lagos. Use the data provided in the table below. Formulate a Mixed Integer Program ad solve it using Excel Solver. Calculate the total emissions per year from the economic solution (in (1)) and the total cost of the environmental solution (in (3)). Discuss these results. Compared to the optimal solution of the first case, what would be the additional cost, that can be considered as the social contribution of PetroRefine SA to support Lagos as part of its Corporate Social Responsibility. Formulate a Mixed Integer Program ad solve it using Excel Solver. As part of an environmental policy, PetroRefine SA would like to explore the possibilities of minimizing the CO2 emissions from its production and transportation operations, while satisfying its demand, regardless of the impact on its cost. Propose a supply chain network design that minimizes the CO2 emissions of the company while satisfying the demand while using the same capacity options as above, including the site of Lagos. Use the data provided in the table below. Formulate a Mixed Integer Program ad solve it using Excel Solver. Calculate the total emissions per year from the economic solution (in (1)) and the total cost of the environmental solution (in (3)). Discuss these results