Fuel inventory manager - development of spreadsheet models for evaluating and forecasting inventory positions and net inventories of fuel for Navy fuel farms

Abstract

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.