Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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 Zone 2 Zone 3 Cost ($/tonne) Waste Limit (tonnes/da Inorganic Content (lbs/tonne 800 1200 80 1450 1000 95 1000 700 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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started