Spreadsheet decision support model for training exercise material requirements planning

dc.contributor.advisorFields, Paul J.
dc.contributor.advisorGue, Kevin R.
dc.contributor.authorTringali, Arthur M
dc.contributor.departmentManagement
dc.date.accessioned2012-08-09T19:23:51Z
dc.date.available2012-08-09T19:23:51Z
dc.date.issued1997-06
dc.description.abstractThis 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 modelen_US
dc.description.distributionstatementApproved for public release; distribution is unlimited.
dc.description.serviceMajor, United States Marine Corpsen_US
dc.description.urihttp://archive.org/details/spreadsheetdecis00trin
dc.identifier.urihttps://hdl.handle.net/10945/9000
dc.language.isoeng
dc.publisherMonterey, California. Naval Postgraduate Schoolen_US
dc.subject.authorSpreadsheet Decision Support Modelen_US
dc.subject.authorTraining Exercise Material Requirements Planningen_US
dc.titleSpreadsheet decision support model for training exercise material requirements planningen_US
dspace.entity.typePublication
etd.thesisdegree.disciplineManagementen_US
etd.thesisdegree.grantorNaval Postgraduate Schoolen_US
etd.thesisdegree.levelMastersen_US
etd.thesisdegree.nameM.S. in Managementen_US
Files
Original bundle
Now showing 1 - 1 of 1
Loading...
Thumbnail Image
Name:
spreadsheetdecis00trin.pdf
Size:
6.77 MB
Format:
Adobe Portable Document Format
Collections