This preview has intentionally blurred sections. Sign up to view the full version.View Full Document
Unformatted text preview: UF-ESI-6314DMOR-02-02.xmcdpage 1 of 602-02.Model the following problem and display the optimal solution you obtain from Solver. Youdo not need to turn in your Excel files.This problem implies the following parameter definitions:variables:TP= volume of tidal pool waterto removeFW= volume of fresh rainwaterto removeFR= volume of farming runoff water to removeRW= volume of reservoir waterto moveEG= volume of Everglades waterto addOC= volume of ocean waterto addsubscripts:s= salinityp= pollutantst= totalE= EvergladesO= oceanR= reservoirThe Florida Water Management District has four water sourcevolumes to decrease:tidal poolvolume mustdecrease to zero1.fresh rainwatervolume mustdecrease to zero2.farming runoffvolume mustdecrease to zero3.reservoirvolume maydecrease to zero4.Each source's water has a percentage of salinityand a percentage of pollutantsas given in thefollowing table. The following table contains the knowninitialdata for water requiredfor removaland, additionally, the knowninitialdata for reservoir water remaining optionalfor removal.TPsFWsFRsRWs2013%:=TPpFWpFRpRWp141%:=TPvFWvFRvRWv2007011050:=Luther Setzer1 NASA Pkwy E Stop NEM3, Kennedy Space Center, FL 32899(321) 544-7435UF-ESI-6314DMOR-02-02.xmcdpage 2 of 6...
View Full Document
- Fall '09
- Seawater, Kennedy Space Center, Luther Setzer