Coast Guard Academy First Class Cadets Lexi Laboy, Maral Toukhanian, Darius Adams, and Matt Grose pose for a photo before their capstone presentation.
U.S. Coast Guard photo by Petty Officer 2nd Class Lauren Laughlin
The purpose of this project is to give the U.S. Coast Guard Aviation Logistics Center a better understanding of what helicopter parts demonstrate a surge during a natural disaster. This project analyzes hurricane data from past Coast Guard natural disaster response to first identify if a correlation between surge operations and an increase in parts ordered exist. Then determine the type and number of parts ordered during surge operations, which quantifies the surge in terms of budget. Finally, determine the most important parts to preemptively stage in a natural disaster area. All of the data analysis methods used Excel.