Linear ProgrammingExcel SolverFacilities DesignOperations Research
Site Selection using Set Covering Method
Led team optimizing facility layout and site selection for micro composting centers in Chennai, India. Analyzed 10 zones (200 wards) across 2.1M households. Applied a set-covering LP model in Excel Solver to identify 42 optimal sites covering all demand zones — minimizing costs to $11.1M while meeting 5 MT/day processing requirements per facility.
View Project