Share
Explore BrainMass

Evaluation and analysis of the current implementation of oracle based Stockpile Resource planning (SRP) System and in consultation with Division of Strategic National Stockpile (DSNS)

Evaluation and analysis of the current implementation of oracle based Stockpile Resource planning (SRP) System and in consultation with Division of Strategic National Stockpile (DSNS)

Solution Preview

The existing SRP system has following problems:
Pricing issues: The system has two-way match of receiving and invoicing. Receipts are held when pricing issue occurs. Also, 20% of FMS items have Approved Suppliers but pricing data is not maintained.
Order Entry: During emergency events customer details and/or address is not known
Forecasting: There is no forecasting of products based on their expiration dates.
Inventory: DSNS manages FMS inventory locations and 3rd parties manage all other inventory locations. FMS warehouses cycles are counted while for all others annual physical inventory is maintained. Bar coding or RFID is not used at warehouses. Excessive time required for performing inventory adjustments, taking inventory counts, making corrections and updating financial records.
Tracking: FMS kits are stored in leased containers. There is no ability to track truck shipments. On a regular basis three carriers have contract- FedEx, UPS and Panther but during emergency numerous carriers are used.
Solution
DSNS owns inventory but does not have trailer tracking system.
The main source of problem is lack of synchronization between different systems and inventory. Since there is no separate inventory management system and inventory is mostly managed by third parties vendors, there is a lag between the points when shipment is dispatched to the time when it is reflected in SRP. There is a requirement for end-to-end inventory management system. As SRP is ...

Solution Summary

An evaluation and analysis of the current implementation of oracle based stockpile resource planning system is determined.

$2.19