Fuel Inventory Manager - Development of Spreadsheet Models for Evaluating and Forecasting Inventory Positions and Net Inventories of Fuel for Navy Fuel Farms
NAVAL POSTGRADUATE SCHOOL MONTEREY CA
Pagination or Media Count:
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 ExcelTM 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 ExcelTM 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.
- Computer Programming and Software
- Logistics, Military Facilities and Supplies