Spreadsheet decision support model for training exercise material requirements planning
Tringali, Arthur M
Fields, Paul J.
Gue, Kevin R.
MetadataShow full item record
This thesis focuses on developing a spreadsheet decision support model that can be used by combat engineer platoon and company commanders in determining the material requirements and estimated costs associated with military training exercises. The model combines the business practice of Material Requirements Planning and the commercial spreadsheet software capabilities of Lotus 1-2-3 to calculate the requirements for food, consumable supplies, petroleum products, and major end items of equipment. The demand for these materials are directly dependent on the quantities of personnel and equipment items to participate in the training exercise. The model takes into consideration existing on hand and on order supplies and materials, and the anticipated effects of lead times, in determining the net requirement and time period an item must be placed on order to ensure its availability for the training exercise. The capability of this model to enhance planning through what if analysis and the investigation of variability and stochastic influence on the model is also explored. The add in program Crystal Ball is used to simulate the effects of lead time variability on the model
Approved for public release; distribution is unlimited
Showing items related by title, author, creator and subject.
McCauley, Michael E. (Monterey, California. Naval Postgraduate School, 2006-02);This report reviews the arguments and the evidence regarding the need for simulator motion bases in training helicopter pilots. It discusses flight simulators, perceptual fidelity, history of motion bases, disturbance ...
McLaughlin, J. Ryan (Monterey, California: Naval Postgraduate School, 2013-09);Simulation of threat aircraft tactics and capabilities during training is an integral component of maintaining the combat readiness of the United States Navy. A dedicated adversary air force supports the majority of adversary ...
The forecasting of future inventory and the optimization of training requirements within the airborne community Chung, Donald B. (1983);In an era of modernization, new weapons systems generate new manpower requirements for the airborne community within the United States Army. The problem of forecasting yearly requirements and inventories has become ...