Question
Need help solving and understanding! B&R Oil and Gas maintains many waste disposal tanks to serve sites across 20 counties as noted in the figure
Need help solving and understanding!
B&R Oil and Gas maintains many waste disposal tanks to serve sites across 20 counties as noted in the figure below (should look familiar). Each tank needs to serve production sites either from the residing county or from the adjacent counties. Please respond to the logistics management questions below.
Provide a thorough analysis that explains the result set from the Excel run. The analysis should provide each process (step) through the analysis including: 1. Identify the objective variable and explain what it means. 2. Identify the decision variables and explain each. 3. Create and provide the objective function. 4. Determine and note all of the constraints for each county and find the counties identified with the minimum number based on the objective function. 5. What is the minimum number of disposal tanks needed to cover all 20 counties and note which counties are those?
Dii posal Tank Location Note that the dia soralelemets Paramete r means share a border, 0 not are 1 5 1 20 Ashtabula Lake 0 0 0 Cuyaho ga 0 Lora in 0 Huron ** Ashland - 1 0 0 Wayne 0 0 1 Medina 0 1 1 0 0 0 0 0 0 Summit 10 0 0 0 11 Sark Geauga Cotumbiana 14 0 0 0 0 0 0 0 0 Mahoning 15 0 0 1 0 Trumbul 16 1 0 0 0 0 0 0 1 1 0 Kox 17 1 0 1 Holmes 18 0 0 T 0 1 1 awas Ca Model Nunberof Disposal ak ons Caro Ashabula Lake Cuyahoga Lorain Huron RicHand Ashla nd Medina Summit Sark Geauga Porage Cotmbiana Mahoning Trumbul Wavne Knox otmes uarawa Disposal Tark Location? Covered? Ashabua Cuahoga Lora in Huron Richbnd Ashland Madies Summit Sark Geaug Portaze Columbiara Truntul Holmes Tuscarawas Camo Dii posal Tank Location Note that the dia soralelemets Paramete r means share a border, 0 not are 1 5 1 20 Ashtabula Lake 0 0 0 Cuyaho ga 0 Lora in 0 Huron ** Ashland - 1 0 0 Wayne 0 0 1 Medina 0 1 1 0 0 0 0 0 0 Summit 10 0 0 0 11 Sark Geauga Cotumbiana 14 0 0 0 0 0 0 0 0 Mahoning 15 0 0 1 0 Trumbul 16 1 0 0 0 0 0 0 1 1 0 Kox 17 1 0 1 Holmes 18 0 0 T 0 1 1 awas Ca Model Nunberof Disposal ak ons Caro Ashabula Lake Cuyahoga Lorain Huron RicHand Ashla nd Medina Summit Sark Geauga Porage Cotmbiana Mahoning Trumbul Wavne Knox otmes uarawa Disposal Tark Location? Covered? Ashabua Cuahoga Lora in Huron Richbnd Ashland Madies Summit Sark Geaug Portaze Columbiara Truntul Holmes Tuscarawas CamoStep 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