|Project Title||Create Inventory Tracking Database|
|Project Summary||Create a database to track IT software and hardware purchase requests and reconcile those PRs to the purchase orders and finally to the items received.|
|Agency||Department of State|
|Number of Interns||1|
This project will be a little more complicated than the summary may suggest. We have approximately 20 staff members who place requests and will need to input their PRs into the database. The procurement office creates purchase orders, which may be local, or go through our acquisitions office in DC. The reconciliation process will rarely correlate directly from the request, the order, the requisition, or the items received. There needs to be a way to prompt staff members to track external entities such as procurement and acquisitions. I would like for the interface to be a Google site.
IT inventory management is a challenge we face worldwide. If we can develope a solid functional solution for Colombo, we could potentially share this solution with other posts around the world.