Spreadsheet decision support model for MK 16 underwater breathing apparatus repair parts inventory management

Abstract

This thesis proposes a spreadsheet-based decision support model for determining the most effective repair parts inventory for the MK 16 Underwater Breathing Apparatus (MK 16). Incorporating U.S. Navy demand information, the model provides the inventory manager the ability to modify repair parts inventories as changes occur to the order and shipping times, tempo of operations, or the number of MK 16 assigned. The thesis explores the current methods of MK 16 repair parts inventory design and recommends changes that permit the inventory manager to model an improved inventory within the constraints of each specific scenario. While providing inventory managers the ability to experiment with 'what if' scenarios, the spreadsheet also provides the commanding officer greater control over unit readiness.