Add Cu Ft attribute to Stock Nbr Inquiry / Create a Real-Time report

Warehouse

DLA

New

Submitted: 2/9/2021

Description
DLA is implementing DPAS for supplies that are managed by COCOs.  The COCOs could have materiel that is warehoused with more than 1 owner.  DLA needs a way to determine warehouse utilization by owner.  To be effective, customer must be diligent in accurately reporting the Unit Cube(ft) of the Unit Of Issue Qty.

Recommended
Add Cu Ft to the Stock Nbr inquiry, and/or develop a real-time report that depicts the following attributes:

• warehouse name,
• stock nbr,
• item desc,
• owning dodaac,
• total on hand qty for Stock Nbr/Owning DoDAAC,
• unit cube,
• sum(qty) x unit cube.

Mission Critical
This is considered essential for managing warehouse utilization.  While nothing is perfect due to how materiel must be stored in the warehouse efficiently and effectively, it does provide a measure of utilization within a warehouse.

Benefits
It provides the customer with a way of looking at Warehouse Utilization / Space Utilization and in determining a cost allocation of the warehouse operations for COCO operations.

Users
This change is considered beneficial for all customers / users of the Warehouse module.