Description  
Each Program Office/Commodity Type has a responsibility to maintain a complete inventory of all government owned ST/STE property. Periodically, complete Physical Inventories are conducted at each storage location. This inventory is managed in excel documents, identifying the tool id, condition, and physical storage location. The Program Office manages tens of thousands of production ST/STE for each weapon system, it would be physically impossible and costly to manually update the DPAS database with the current condition and physical storage location for each item after a physical inventory. An automated solution is needed to mass update lists of ST/STE in a timely, cost effective manner.

Recommended  
Need to create an import program to upload the Physical Inventories and update the condition and physical location of each tool.

Mission Critical  
Mission Critical. In order to be FIAR audit compliant, the program office must be able to reconcile their inventories within DPAS.

Benefits  
This correction will reduce Time/Cost for updating physical inventory lists and ensures/improves Accuracy and Accountability of DoD owned ST/STE. It is mandated that the complete list of all DoD owned ST/STE property be managed in DPAS. Currently, it is cost prohibitive to manually update the location and condition of all tooling located at a storage facility after a physical inventory. 

Users  
All users, it is vital to know where tooling is stored to support the maintainability of the weapon system.