Operations Research, Systems Engineering and Industrial Engineering Commons^™

Optimizing Distribution Sensor Placement For Border Patrol Interdiction Using Microsoft Excel, Adrian C. Patrascu

Theses and Dissertations

The purpose of this research was to develop an electronic sensor placement model for border security. A model was developed using Microsoft Excel, with some add-on capabilities, to optimize the placement of electronic sensors on a border network given a pre-determined budgetary constraint. The model is capable of handling multiple sensor types, which are placed together as packages, and allows for daytime, nighttime, or 24 hour operation of each sensor type. Additionally, each sensor can be assigned a specific range and detection probability curve within the given range. The model is capable of optimizing either average coverage, or minimum coverage, …