Developing an Excel Decision Support System Using In-Transit Visibility to Decrease DoD Transportation Delays

The United States Air Force's Air Mobility Command (AMC) is responsible for efficiently transporting military personnel and cargo throughout the world. Organizations throughout the transportation system search for ways to decrease cargo transportation time as part of their ongoing mission to provide timely airlift services to the DoD. Decreasing the average time pallets wait for a transportation aircraft, called the port hold time (PHT), is a difficult problem which is currently receiving attention. The DoD has invested in radio frequency identification (RFID) technology to provide in-transit visibility (ITV) of all cargo moving through the transportation system. In many ways ITV has made cargo transportation much more efficient but its capability to measure and characterize cargo flow through the system has not been fully exploited. The purpose of this research is to create a Microsoft Excel application which utilizes RFID data to quantify and analyze cargo velocity in the Iraqi theater. The transportation system is analyzed at the pallet level to reveal which specific air bases and transportation methods cause lengthy cargo delays. Pallet PHT data is processed and reported using Statistical Process Control (SPC) methods including control and Pareto charts.

This work has been selected by scholars as being culturally important, and is part of the knowledge base of civilization as we know it. This work was reproduced from the original artifact, and remains as true to the original work as possible. Therefore, you will see the original copyright references, library stamps (as most of these works have been housed in our most important libraries around the world), and other notations in the work.

This work is in the public domain in the United States of America, and possibly other nations. Within the United States, you may freely copy and distribute this work, as no entity (individual or corporate) has a copyright on the body of the work.

As a reproduction of a historical artifact, this work may contain missing or blurred pages, poor pictures, errant marks, etc. Scholars believe, and we concur, that this work is important enough to be preserved, reproduced, and made generally available to the public. We appreciate your support of the preservation process, and thank you for being an important part of keeping this knowledge alive and relevant.