Explore BrainMass
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)

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    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)

    © BrainMass Inc. brainmass.com October 10, 2019, 6:27 am ad1c9bdddf
    https://brainmass.com/business/strategic-planning/current-implementation-oracle-based-stockpile-resource-plan-544918

    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