Generalized optimization modeling for defense capital planning and equipment replacement.
Bradley, Gordon H.
Brown, Gerald G.
MetadataShow full item record
Recurring issues for Navy and DoD analysts are decisions on the upgrade, purchase, and retirement of equipment with high capital cost and long useful life. Since the PHOENIX model was developed in the late eighties a number of theses addressing different equipment procurement and modernization problems have been written at the Naval Postgraduate School. Those models have a common thread of purpose data, and methods that suggest the possibility of building a common model subsuming those previous efforts. The model developed is a mixed- integer linear program written in GAMS, and its most appealing characteristic is the spreadsheet application that allows the user to enter data, solve the model, analyze its output, enter user feedback in the process of finding a new solution, and also to manage a collection of candidate solutions. With this approach difficulties are hidden from the user who interacts only with the spreadsheet and does not have to build his own model. The combination of a generic model and the visual programming capability of the spreadsheet provides the user with a tool to accomplish more complete, complex and sophisticated analysis.
Approved for public release; distribution in unlimited.
Showing items related by title, author, creator and subject.
Bausch, Dan; Brown, Gerald G.; Ronen, David (1998);A multinational company uses a personal computer to schedule a fleet of coastal tankers and barges transporting liquid bulk products among plants, distribution centres (tank farms), and industrial customers. A simple ...
Morris, David K. (Monterey, California. Naval Postgraduate School, 1995-06);The focus of this thesis is to examine the extent of electronic spreadsheet software usage in Navy budgeting; to discuss who is using electronic spreadsheets and how they are being used; and to evaluate the adequacy of ...
Draftsmans displays for contingency tables using a full-screen, scrollable APL2 spreadsheet input/output editor with application to the PERSEREC database of Special Background Investigation Steinfeld, Uwe H. (Monterey, California. Naval Postgraduate School, 1990-03);A full-screen, scrollable spreadsheet-like editor written in the APL2 language is described for inputting, examining and outputting data. Mixed numeric and character arrays can be read into or read out to formatted DOS ...