Inventory manager's workstation for the Aviation Supply Office

Abstract

Each inventory manager at the Aviation Supply Office Philadelphia, PA is presently required to manage approximately 700 line items. To allow the inventory manager a more efficient method of reviewing and using the data and reports from the Uniform Inventory Control Point (UICP) computer system, a distributed computer system is necessary. By downloading the the appropriate inventory data from UICP to a local computer system, a decision support system (DSS) can be be implemented using existing off the shelf hardware and software. The ability to replace the present copious paper reports with concise computerized information and import that data into electronic spreadsheets for further analysis can greatly improve the inventory manager's effectiveness. To this end, this thesis provides inventory managers at ASO with access to the following functions: Interactive access to the main UICP database. The ability to use UICP data with a decision support system. A user interface that is easy to understand and learn. A local data base which supports working group requirements. Basic office automation. This thesis will cover the selection of the hardware and software, data identification and management and DSS development. A prototype system called the IM Workstation was developed for this thesis and used to produce the thesis document. COBOL and ALIS ELF macro program listings are provided.