Fuel Inventory Manager - Development of Spreadsheet Models for Evaluating and Forecasting Inventory Positions and Net Inventories of Fuel for Navy Fuel Farms

This is a NAVAL POSTGRADUATE SCHOOL MONTEREY CA report procured by the Pentagon and made available for public release. It has been reproduced in the best form available to the Pentagon. It is not spiral-bound, but rather assembled with Velobinding in a soft, white linen cover. The Storming Media report number is A023953. The abstract provided by the Pentagon follows: This thesis addresses the non-standardization of manual Navy fuel farm recordskeeping inventory procedures. It also addresses the errors in calculations and the man-hours required with current procedures. The errors in calculations lead to inventory inaccuracies which increase the possibility of the following: running out of fuel, spills due to overfilling or not being able to detect fuel loss due to leakage in a timely manner. A computerized spreadsheet using Microsoft Excel(TM) has been developed that will incorporate the formulas and tables used in these calculations in order to eliminate errors. A Users Guide was developed to familiarize the user with the versatility of Microsoft Excel(TM) to keep track of fuel inventories. This guide provides step- by-step instructions on how to construct the databases and models as discussed in the thesis. In summary, this thesis provides a quick accurate fuel inventory system. This system warrants the possibility of standardization throughout the Navy without an increase in government spending. Also, this system is simple, user-friendly and saves time. By reducing man-hours and labor, it also saves the government money. Information can be downloaded and e-mailed to higher commands as needed for strategic planning and allocation usage.