Please Need Help Asap!

B&R Oil and Gas maintains many waste disposal tanks to serve sites across 20 counties as noted in the figure below. Each tank needs to serve production sites either from the residing county or from the adjacent counties. Primary logistics management question: a. What is the minimum number of disposal tanks needed to cover all 20 counties?

Provide a thorough analysis that explains the result from the excel run. The analysis should provide each process (step) through the analysis including: 1. Identify the objective and decision variables. Identify each. 2. Create the objective function 3. Find all the constraints for each county and find the counties identified with the minimum number per question a above. 4. Any additional statistically relevant constraints. Provide a final, detailed result that answers the question based on the above. Please save your answers into a Word document. Also, attach the excel worksheet as part of the objective evidence as to how you derived your responses.

This is the link to the full document with information above and more: http://www.filedropper.com/project3421fall2018

This is the link for the data excel worksheet portion: http://www.filedropper.com/binarylogisticsmanagementp