ustranscom l.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
USTRANSCOM PowerPoint Presentation
Download Presentation
USTRANSCOM

Loading in 2 Seconds...

play fullscreen
1 / 21

USTRANSCOM - PowerPoint PPT Presentation


  • 220 Views
  • Uploaded on

USTRANSCOM. Distribution Data Analysis SDDB Example 2-3 Aug. UNCLASSIFIED. UNCLASSIFIED. Agenda. Background – SDDB history Distribution process SDDB: DORRA Maintained Systems SDDB: J5/4 Maintained Systems How TCJ5/4 measures distribution data for TDD SDDB data examples

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'USTRANSCOM' - bjorn


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
ustranscom

USTRANSCOM

Distribution Data Analysis

SDDB Example

2-3 Aug

UNCLASSIFIED

UNCLASSIFIED

agenda
Agenda

Background – SDDB history

Distribution process

SDDB: DORRA Maintained Systems

SDDB: J5/4 Maintained Systems

How TCJ5/4 measures distribution data for TDD

SDDB data examples

Discussion/Way Ahead

UNCLASSIFIED

UNCLASSIFIED

sddb history
SDDB History

UNCLASSIFIED

  • Early 2000, Leaders of USTRANSCOM & DLA developed the Strategic Distribution Management Initiative
  • RAND Corporation integrated DoD and non-DoD data sources to diagnose enterprise problems in support of this effort
  • RAND’s enterprise data repository became the Strategic Distribution Database (SDDB)
  • Transitioned database maintenance to DORRA and performance reporting/analysis to USTRANSCOM in 2006
  • Today the SDDB is a fundamental basis for distribution performance management for the DPO mission

UNCLASSIFIED

distribution process
Distribution Process

UNCLASSIFIED

UNCLASSIFIED

distribution data analysis
Distribution Data Analysis

Document number level

Slice/dice…tailored analysis/reporting

Attributes include…

Source of Fill

Mode/Nodal network

Customer location

Commodity

Transaction time stamps

E.g. pick, pack, ship,

Port receipt/lift

TCSP receipt/ship

Delivered to customer (e.g. TK6) /Receipt processing

UNCLASSIFIED

UNCLASSIFIED

example
Example

UNCLASSIFIED

UNCLASSIFIED

backup slides
Backup Slides

UNCLASSIFIED

UNCLASSIFIED

sddb j5 4 maintained systems
SDDB: J5/4 Maintained Systems

UNCLASSIFIED

TCJ5/4-LM

DAASC/LMARS (DLA)

Logistics Response Time

DORRA Maintained

Manual Feeds

GSA

DAASC/LCAV

CTASC/LIW

  • iSDDC
  • PAT
  • TCSP DSS
  • AV
  • GATES
  • Carrier Rpts
  • Ref Tables

IGC/EDW

  • 214EDI
  • 856EDI
  • DAAS
  • CMOS
  • GFM/858
  • GDSS
  • IRRIS
  • GATES
  • WPS
  • IBS/CSS
  • IBS
  • AMS-TAC
  • TRDM

MIS/DSS

GATES

WPS &

IBS-CSS

MPH/GBL

UNCLASSIFIED

daasc lmars dla
DAASC/LMARS (DLA)

UNCLASSIFIED

MIS/DSS (DLA)

Supply - Requistion

CONUS GSA (GSA)

Supply - Requistion

GATES (AMC)

Transportation - Air

WPS/IBS-CSS (SDDC)

Transportation - Surface

  • DAASC/LMARS (DLA)
  • Logistics Metrics Analysis Reporting System
  • Cornerstone of SDDB in that the requisition must appear in LRT for it to be included in the SDDB
  • Requisition MUST be in LRT to be reported
  • Other data sources are used to validate and fill in holes
  • Food and prime vendor medical excluded

MPH/GBL (DORRA)

Transportation - Surface

DAAS/LCAV (USTRANSCOM)

Supply - Requistion

CTASC/LIW (Army)

Supply - Requistion

DAASC/LMARS (DLA)

Supply - Requisition

UNCLASSIFIED

mis dss dla
MIS/DSS (DLA)

UNCLASSIFIED

MIS/DSS (DLA)

Supply - Requistion

CONUS GSA (GSA)

Supply - Requistion

GATES (AMC)

Transportation - Air

WPS/IBS-CSS (SDDC)

Transportation - Surface

  • MIS/DSS (DLA)
  • Management Information System
  • Distribution Standard System
  • Provides details on distribution center activities, including cargo consolidation, shipping mode detail, and cost information
  • Navy CRIF Data

MPH/GBL (DORRA)

Transportation - Surface

DAAS/LCAV (USTRANSCOM)

Supply - Requistion

CTASC/LIW (Army)

Supply - Requistion

DAASC/LMARS (DLA)

Supply - Requisition

UNCLASSIFIED

conus gsa gsa
CONUS GSA (GSA)

UNCLASSIFIED

MIS/DSS (DLA)

Supply - Requistion

CONUS GSA (GSA)

Supply - Requistion

GATES (AMC)

Transportation - Air

WPS/IBS-CSS (SDDC)

Transportation - Surface

  • CONUS GSA (GSA)
  • Supplements info for GSA shipments (Burlington, Stockton)
  • - Parallels to some extent what the DLA Issues data do for shipments from DDC’s distribution centers
  • - Includes MRO date, depot RIC, depot ship date, seavan “CCP” ship date for issues from GSA depots

MPH/GBL (DORRA)

Transportation - Surface

DAAS/LCAV (USTRANSCOM)

Supply - Requistion

CTASC/LIW (Army)

Supply - Requistion

DAASC/LMARS (DLA)

Supply - Requisition

UNCLASSIFIED

ctasc liw logsa army
CTASC/LIW (LOGSA Army)

UNCLASSIFIED

MIS/DSS (DLA)

Supply - Requistion

CONUS GSA (GSA)

Supply - Requistion

GATES (AMC)

Transportation - Air

WPS/IBS-CSS (SDDC)

Transportation - Surface

  • CTASC/LIW (LOGSA Army)
  • Corps Theater Automatic Service Center
  • CTASC sites are repository for Army tactical stockage transactions transmitted from SARSS
  • CTASC receipt dates for DRA/D6K transactions replace Pseudo receipts
  • Logistics Integrated Warehouse
  • Maintained by US Army LOGSA
  • Corrects Pseudo-receipt dates for units not covered by CTASC

MPH/GBL (DORRA)

Transportation - Surface

DAAS/LCAV (USTRANSCOM)

Supply - Requistion

CTASC/LIW (Army)

Supply - Requistion

DAASC/LMARS (DLA)

Supply - Requisition

UNCLASSIFIED

daas lcav ustranscom
DAAS/LCAV (USTRANSCOM)

UNCLASSIFIED

MIS/DSS (DLA)

Supply - Requistion

CONUS GSA (GSA)

Supply - Requistion

GATES (AMC)

Transportation - Air

WPS/IBS-CSS (SDDC)

Transportation - Surface

  • DAAS/LCAV (USTRANSCOM)
  • Logistics Support Center Customer Asset Visibility
  • Provides visibility over the Navy’s Material Processing Centers (MPC).
  • Captures MPC Receipt/Departure dates

MPH/GBL (DORRA)

Transportation - Surface

DAAS/LCAV (USTRANSCOM)

Supply - Requistion

CTASC/LIW (Army)

Supply - Requistion

DAASC/LMARS (DLA)

Supply - Requisition

UNCLASSIFIED

mph gbl dorra
MPH/GBL (DORRA)

UNCLASSIFIED

MIS/DSS (DLA)

Supply - Requistion

CONUS GSA (GSA)

Supply - Requistion

GATES (AMC)

Transportation - Air

WPS/IBS-CSS (SDDC)

Transportation - Surface

  • MPH/GBL (DORRA)
  • Manifest Print History /
  • Government Bill of Lading
  • Contain critical information on 2nd and 3rd destination costs and corresponding weights
  • Supplemental data include customer DODAAC (destination), ZIP code, ship mode

MPH/GBL (DORRA)

Transportation - Surface

DAAS/LCAV (USTRANSCOM)

Supply - Requistion

CTASC/LIW (Army)

Supply - Requistion

DAASC/LMARS (DLA)

Supply - Requisition

UNCLASSIFIED

gates ustranscom
GATES (USTRANSCOM)

UNCLASSIFIED

MIS/DSS (DLA)

Supply - Requistion

CONUS GSA (GSA)

Supply - Requistion

GATES (AMC)

Transportation - Air

WPS/IBS-CSS (SDDC)

Transportation - Surface

  • GATES (USTRANSCOM)
  • Global Air Transportation Execution System
  • Information on channel airlift, including TCN, weight, cube, handling code, APOE/APOD, missions, time stamps

MPH/GBL (DORRA)

Transportation - Surface

DAAS/LCAV (USTRANSCOM)

Supply - Requistion

CTASC/LIW (Army)

Supply - Requistion

DAASC/LMARS (DLA)

Supply - Requisition

UNCLASSIFIED

gates wps amc ibs css sddc
GATES-WPS (AMC)/IBS-CSS (SDDC)

UNCLASSIFIED

MIS/DSS (DLA)

Supply - Requistion

CONUS GSA (GSA)

Supply - Requistion

GATES (AMC)

Transportation - Air

WPS/IBS-CSS (SDDC)

Transportation - Surface

  • GATES-WPS (AMC)/IBS-CSS (SDDC)
  • Worldwide Port System
  • Used for surface (seavan) shipment to OCONUS customer
  • Extract data on port of embarkation and delivery, port dates, weight, cube
  • Integrated Booking System -
  • Commercial Sealift Solutions
  • - Supplements GATES/WPS data for some records

MPH/GBL (DORRA)

Transportation - Surface

DAAS/LCAV (USTRANSCOM)

Supply - Requistion

CTASC/LIW (Army)

Supply - Requistion

DAASC/LMARS (DLA)

Supply - Requisition

UNCLASSIFIED

slide17

UNCLASSIFIED

UNCLASSIFIED

Ocean Measurements

Supplier

Transporter

Theater

MRO

MRO

D6S

D6S

Carrier Pickup

aRFID CCP Outgate

Carrier Pickup EDI

Arrived at POE

Ready for Carrier

Carrier Dropoff

Carrier Dropoff

POD Outgate

TCSPr

MPCr

aRFID TK6

Warehouse/Depot

Activities

CCP Activities

POE/POD Activities

TCSP

Activties

Arrived at POE

Ready for Pickup

Vessel Departed POE

Customer Receipt

TCSP Receipt

Arrived at CCP

Ready for Carrier

Picked Up By Carrier

Vessel Arrived POD

TCSP Ship

Customer Available

Container Booked

POD Outgate

Carrier Dropoff

Material Release Order

LMARS

(MRO)

LMARS

(ShippedDt)

LMARS

(CCPr)

PAT

(BookingDt)

LMARS

(CCPs)

aRFID

(Last Ping)

PAT

(MinI)

PAT

(MinVD)

PAT

(MaxVD)

PAT

(MaxOA)

PAT

(MaxX1)

DSS

(Receipt)

aRFID

(TK6)

LMARS

(DRA,DRB,D6S)

aRFID

(Last Ping)

POD Outgate

DSS

(Ship)

MIS

(MRO)

GSA

(ShipDt)

MIS

(CCPr)

GSA

(CCPs)

PAT

(MinW)

WPS/GATES

(Receipt)

WPS/GATES

(Disposition)

aRFID

(First Ping)

pRFID

(Dest)

CTASC

(D6S)

WPS/GATES

(POEs)

WPS/GATES

(PODr)

MIS

(ShipDt)

MIS

(CCPs)

WPS/GATES

(POEr)

LMARS

(POEs)

LMARS

(PODr)

WPS/GATES

(PODs)

DAAS

(NL,BA)

LIW

(D6S)

LMARS

(POEr)

LMARS

(PODs)

Seg

3

Seg 4

Seg

5

Seg

6

Seg

7

Seg

8

Seg

9

Seg

10

Seg

11

slide18

UNCLASSIFIED

Military Air Measurements

Supplier

Transporter

Theater

MRO

MRO

D6S

D6S

Ready for Mvmt to POE

CCPs (MILALOC/CCP Divert)

WHSEs (MILAIR)

Ready for Mvmt to Customer

Last AMC Controlled PODs

Ready for Pickup

(MILAIR)

Ready for Pickup

(CCP Divert/MILALOC)

POD Process Dt

Warehouse/Depot

Activities

CCP Activities

(CCP Divert/MILALOC)

POE/POD Activities

TCSP

Activties

Receipted at POE

Ready for Pickup

POE Lift/Depart

Customer Receipt

TCSP Receipt

Arrived at CCP

Ready for Carrier

Receipted at POD

TCSP Ship

Customer Available

POD Lift/Depart

Material Release Order

LMARS

(MRO)

LMARS

(ShippedDt)

LMARS

(CCPr)

LMARS

(CCPs)

GATES

(Receipt)

GATES

(Lift/Dpt)

GATES

(Receipt)

GATES

(Lift/Dpt)

DSS

(Receipt)

aRFID

(TK6)

LMARS

(DRA,DRB,D6S)

aRFID

(Last Ping)

DSS

(Ship)

MIS

(MRO)

GSA

(ShipDt)

MIS

(CCPr)

GSA

(CCPs)

aRFID

(First Ping)

pRFID

(Dest)

CTASC

(D6S)

LMARS

(POEr)

LMARS

(POEs)

LMARS

(PODr)

LMARS

(PODs)

MIS

(ShipDt)

MIS

(CCPs)

DAAS

(NL,BA)

LIW

(D6S)

Seg

3

Seg 4

Seg

5

Seg

6

Seg

7

Seg

8

Seg

9

Seg

10

Seg

11

slide19

UNCLASSIFIED

Commercial Air Measurements

Supplier

Transporter

Theater

MRO

MRO

D6S

D6S

Ready for Mvmt to Customer

CCPs (Shipmt from CCP)

WHSEs (Shpmt from WHSE)

Delivered to Customer

Carrier Provided EDI

Ready for Pickup

(WHSE Origin)

Ready for Pickup

(COMALOC/CCP Origin)

Warehouse/Depot

Activities

CCP Activities

(COMALOC/CCP Origin)

Carrier Controlled Activities

TCSP

Activties

Carrier Pickup

Ready for Pickup

Customer Receipt

TCSP Receipt

Arrived at CCP

Ready for Carrier

TCSP Ship

Customer Available

Carrier Dropoff

Material Release Order

LMARS

(MRO)

LMARS

(ShippedDt)

LMARS

(CCPr)

LMARS

(CCPs)

214 EDI

(AF)

214 EDI

(X1/D1)

DSS

(Receipt)

aRFID

(TK6)

LMARS

(DRA,DRB,D6S)

aRFID

(Last Ping)

DSS

(Ship)

MIS

(MRO)

GSA

(ShipDt)

MIS

(CCPr)

GSA

(CCPs)

aRFID

(First Ping)

pRFID

(Dest)

CTASC

(D6S)

MIS

(ShipDt)

MIS

(CCPs)

DAAS

(NL,BA)

LIW

(D6S)

Seg

3

Seg 4

Seg

5

Seg

6-10

Seg

11

slide20

UNCLASSIFIED

Truck Measurements

Supplier

Theater

MRO

MRO

D6S

D6S

Ready for Mvmt to Customer

CCPs (Shipmt from CCP)

WHSEs (Shpmt from WHSE)

Ready for Pickup

(WHSE Origin)

Ready for Pickup

(CCP Origin)

Warehouse/Depot

Activities

CCP Activities

(CCP Origin)

TCSP

Activties

Ready for Pickup

Customer Receipt

TCSP Receipt

Arrived at CCP

Ready for Carrier

TCSP Ship

Customer Available

Material Release Order

LMARS

(MRO)

LMARS

(ShippedDt)

LMARS

(CCPr)

LMARS

(CCPs)

DSS

(Receipt)

aRFID

(TK6)

LMARS

(DRA,DRB,D6S)

aRFID

(Last Ping)

DSS

(Ship)

MIS

(MRO)

GSA

(ShipDt)

MIS

(CCPr)

GSA

(CCPs)

aRFID

(First Ping)

pRFID

(Dest)

CTASC

(D6S)

MIS

(ShipDt)

MIS

(CCPs)

DAAS

(NL,BA)

LIW

(D6S)

Seg

3

Seg 4

Seg

5

Seg

6-10

Seg

11

slide21

UNCLASSIFIED

Subsegment Measurements

Source

Supplier

Transporter

Theater

MILALOC/Truck

Comm Air

MILAIR/Truck/

Comm Air

Ocean

Theater POD

Activities

Transportation

To Theater Loc

CCP Activities

POE

Activities

TCSP/BBP

Activties

Inventory

Control Pt

Warehouse/Depot

Activities

POD Outgate

Arrived at POE

Departed POE

Arrived at CCP

Available to Carrier

Arrived at Theater POD

Departed Depot

Customer Receipt/Acknowledgement

Established Date

Back Order Start

Back Order End

Ship Date

Departed CCP

Arrived at Strategic POD

Departed Theater POE

Departed Theater POD

Arrived at BBP/TCSP

Departed BBP/TCSP

Pallet Build Process Complete

Booking Date

Pack Date

Pick Date

Strategic/Theater Transition Point

Document Date

CCP Receipt

Material Release Order

Customer Available/Theater Transportation End

CCP Ship

21