6. Excel Optimization: Multi-variable LP and Sensitivity Analysis Use MS Excel solver (with the LP Simplex method) to optimize the following problem and produce a Sensitivity Report. Provide a print out of your excel sheet results and the Sensitivity Report The Sanitation Department of a growing city has projected a need for increased landfill space. The cost of a new landfill will be a function of costs associated with transporting wastes from 3 different zones in the city. Each zone has a limit., which cannot be exceeded, on how much waste can be transported per day. Ir total, there must be exactly 2,500 tonnes/day of wastes taken from the three zones for the new landfill In addition to those constraints, there is a limit to the total Inorganic Content that the new landfill can take in. The total inorganic content for the new landfill cannot exceed 950 lbs/tonne. Data for the three zones costs, waste limits, and inorganic contents are given below Zone 1 Cost ($/tonne) Waste Limit (tonnes/da Inorganic Content (lbs/tonne Zone 2Zone 3 80 1450 95 1000 700 800 1200 1000 Using x1, X2, and x3 to represent the tonnes/day transported to the new landfill from zones 1, 2, and 3, respectively... (a) Write out an objective function to minimize the total landfill costs (b) Write out constraints for waste limits, total waste intake, and total inorganic content (all in terms of x1, X2, and x3). Pay attention to units and make sure that the units work out for the inorganic content constraint (c) Optimize for minimum costs using Excel and provide solution for x1, X2, X3, and total cost. (d) Provide the Sensitivity Report for the solver. 6. Excel Optimization: Multi-variable LP and Sensitivity Analysis Use MS Excel solver (with the LP Simplex method) to optimize the following problem and produce a Sensitivity Report. Provide a print out of your excel sheet results and the Sensitivity Report The Sanitation Department of a growing city has projected a need for increased landfill space. The cost of a new landfill will be a function of costs associated with transporting wastes from 3 different zones in the city. Each zone has a limit., which cannot be exceeded, on how much waste can be transported per day. Ir total, there must be exactly 2,500 tonnes/day of wastes taken from the three zones for the new landfill In addition to those constraints, there is a limit to the total Inorganic Content that the new landfill can take in. The total inorganic content for the new landfill cannot exceed 950 lbs/tonne. Data for the three zones costs, waste limits, and inorganic contents are given below Zone 1 Cost ($/tonne) Waste Limit (tonnes/da Inorganic Content (lbs/tonne Zone 2Zone 3 80 1450 95 1000 700 800 1200 1000 Using x1, X2, and x3 to represent the tonnes/day transported to the new landfill from zones 1, 2, and 3, respectively... (a) Write out an objective function to minimize the total landfill costs (b) Write out constraints for waste limits, total waste intake, and total inorganic content (all in terms of x1, X2, and x3). Pay attention to units and make sure that the units work out for the inorganic content constraint (c) Optimize for minimum costs using Excel and provide solution for x1, X2, X3, and total cost. (d) Provide the Sensitivity Report for the solver