SUMMARY We currently have no efficient way of tracking our inventory. 

Currently, some of our vendors do not ship orders with a purchase order or a shipping tracking number. Accordingly, we have no definitive way of keeping track of transit times per vendor nor are we able to confirm that we are receiving all orders we place. Finally, due to the multiple vendors we purchase from, we do not have a way of efficiently checking our purchase price for every SKU. This system is a solution to this problem.

This system will have three interfaces: 

1. order input interface 

2. order receiving interface 

3. historical order data reporting interface 

ORDER INPUT INTERFACE

When we place an order, we want to have an interface where we can manually enter the vendor name, the items purchased, the date of purchase, shipment date (if applicable) and the purchase order (if applicable). Fields: Purchase Order # Vendor Item (Auto-complete based on list) SKU (Lookup based on list) Quantity Cost Shipping Exchange Rate Adj Cost (USD) Average Cost per Item Unit ORDER RECEIVING INTERFACE 

When shipments are received to our warehouse, we want to be able to check-in orders properly based upon the previously entered purchase order from the ORDER INPUT INTERFACE. The warehouse employee should be able to select a vendor, and then select an open purchase order from this vendor. Since we receive several partial orders, the warehouse employee should be able to select partial quantities of items from the open purchase orders for that vendor. 

Also, the interface should have autocomplete to simplify order receiving. Finally, the warehouse employee needs to be able to enter a date of check-in for the order. This way, we can verify that we are receiving orders that we place, and we can also gain historical shipping time averages per vendor. HISTORICAL ORDER DATA REPORTING INTERFACE For this interface, we want to be able to see average order processing times per vendor. We also want to be able to see a historical 30, 60, and 90 day cost price per SKU. This way, we may make more accurate purchasing decisions based on our trailing costs. Finally, we want a notification system in this interface that lets us know which orders we have not received in full after 30, 60, 90 days, so we may contact the vendor and receive refunds or replacement orders when appropriate.