Accession Number:

ADA480294

Title:

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

Descriptive Note:

Master thesis

Corporate Author:

AIR FORCE INST OF TECH WRIGHT-PATTERSON AFB OH GRADUATE SCHOOL OF ENGINEERING AND MANAGEMENT

Personal Author(s):

Report Date:

2008-03-01

Pagination or Media Count:

139.0

Abstract:

The United States Air Forces 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.

Subject Categories:

  • Humanities and History
  • Statistics and Probability
  • Logistics, Military Facilities and Supplies

Distribution Statement:

APPROVED FOR PUBLIC RELEASE