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

Download
Author
Denman, Dane A.
Date
1998-12Advisor
Feitler, Jane N.
Liao, Shu S.
Second Reader
NA
Metadata
Show full item recordAbstract
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.
Collections
Related items
Showing items related by title, author, creator and subject.
-
The cost of maintaining a naval inventory system with inaccurate records
Burch, Gerald F. (Monterey, California. Naval Postgraduate School, 2003-03);Management of the Naval integrated supply system depends on data to provide reliable information on the quantities of items in stock at any given time. Because of the high volume of transactions that continually alter data ... -
A steady state longitudinal manpower planning model with several classes by manpower
Grinold, Richard C. (Monterey, California. Naval Postgraduate School, 1979-08); NPS55-79-025In the Navy's officer system there are several classes of manpower (e.g. pilots and submariners) that perform specialized jobs and also can perform several types of non-specialized jobs (e.g. military training, personnel ... -
An analysis of the impact of data errors on backorder rates in the F404 engine system
Burson, Patrick A. R. (Monterey, California. Naval Postgraduate School, 2003-03);In the management of the U.S. Naval inventory, data quality is of critical importance. Errors in major inventory databases contribute to increased operational costs, reduced revenue, and loss of confidence in the reliability ...