DATA MANAGEMENT GRID |
|
|
|
|
|
|
|
Category |
Type of
Measurement |
Where? |
How Often
to Measure? |
Special
considerations |
Applicable
Tolerances |
Minimum
Accuracy |
RELATED
STATISTICS/COMMENTS |
Inventory |
|
|
|
|
|
|
|
|
Stockroom
Accuracy |
By Item and
Location |
WEEKLY |
Statistics by
Stockroom or Warehouse or DC |
0 to 5% Count
Tolerance |
95% |
|
|
Work In
Process Accuracy |
Order or
schedule |
|
Statistics by
Manufacturing Area |
0 to 5% Count
Tolerance |
95% |
|
|
In Transit
Accuracy |
By Item and
In Transit Order |
|
Statistics by
Shipping Location |
0 to 5% Count
Tolerance |
95% |
|
|
|
|
|
|
|
|
|
Product
Definition |
|
|
|
|
|
|
|
|
BOM or
Formulation Accuracy |
Single Level
BOMs, By Item |
WEEKLY OR
MONTHLY |
All
Manufactured Items Have Bills Of Material? Reasonable Quantity Per? Correct units of
measure? All components? Correctly structured? |
Reasonable
based on type of process |
98% |
#Mfg items
w/No BOM, #Purchase items w/BOM, #Distribution items w/BOM, #Items w/ zero quantity per |
|
Process
Definition Accuracy |
By Item |
WEEKLY OR
MONTHLY |
All
Operations? Correct Sequence? Right Work Centers? Reasonable Standards? |
Consistent
standards |
98% |
#Mfg items
w/No Routing: #Pur items w/Routing: #Dist items w/Routing: #Yield Exceptions: #Subcontract
operations w/No Cost: #Subcontract operations w/Invalid Supplier: #Subcontract operations
w/No Lead Time: #Operations w/Zero Yield: |
|
Work Center
Definition |
Work Center |
WEEKLY OR
MONTHLY |
All Work
Centers Defined? |
|
98% |
#Work centers
with calendar exceptions: #Work centers with cost exceptions: |
|
Product
Planning Reasonableness |
By End
Item/Product |
WEEKLY OR
MONTHLY |
Consistent
planning parameters from level to level in BOM? No stacked safety stocks. |
|
98% |
#LT offset
exceptions (LT offset exceeds lead time), #Operation exceptions (BOM refers to invalid
operation): |
|
|
|
|
|
|
|
|
Supply Chain
Definition |
|
|
|
|
|
|
|
|
Supply
Sources |
Company or
Location |
MONTHLY |
All
Distribution Centers, Interplant Sources, Major Trading Partners Identified |
|
99%+ |
#Locations
with no ship calendar: |
|
Source
Network |
By End
Item/Product |
MONTHLY |
Correct
Sending and Receiving Locations, % Add up to 100% |
|
98% |
#Purchased
items w/ distribution network: #Mfg items w/ distribution network: #Dist items w/ no
network: |
|
Lead Times |
Source to
Destination |
MONTHLY |
Appropriate
based on transportation method |
|
98% |
|
|
|
|
|
|
|
|
|
Transportation
Data |
|
|
|
|
|
|
|
|
Transportation
Method |
|
MONTHLY |
All
Transportation Methods Defined |
|
98% |
|
|
Unit Capacity |
|
MONTHLY |
Reasonable
estimate of Weight, Cube, Number of Pallets for Transportation Planning |
|
98% |
|
|
|
|
|
|
|
|
|
Item Data |
|
|
|
|
|
|
|
|
Ordering
Rules |
By Item |
WEEKLY OR
MONTHLY |
Appropriate
based on manufacturing method? or purchasing considerations? |
|
99% |
#Items w/FOQ:
#Items w/POQ: #Items w/LFL: #Items w/Invalid OQ: #Items where POQ exceeds specified
coverage #Items where FOQ exceeds specified coverage #Items where MIN exceeds specified
coverage #Items where MULT exceeds specified coverage |
|
Lead Times -
Mfg/Purch |
|
WEEKLY OR
MONTHLY |
Appropriate
based on manufacturing method? or purchasing considerations? |
|
99% |
#Mfg LT
exceptions:
#Pur / supplier LT exceptions:
#Insp LT:
#Longer than specified value
Items with negative lead times #Phantoms w/LT: |
|
Safety Stock |
|
WEEKLY OR
MONTHLY |
Use where
necessary and justifiable. Legitimate variability of supply or demand. |
|
99% |
|
|
Weight, Cube,
# of Pallets |
By Item |
WEEKLY OR
MONTHLY |
Per unit. |
|
99% |
|
|
Item Type |
|
WEEKLY OR
MONTHLY |
Item coded
properly. Type: Manufactured, Purchased or Distribution/Interplant, and Planning method:
MPS, MRP |
|
99% |
#Inactive
Items: #Zero Cost: #Phantoms: |
|
|
|
|
|
|
|
|
Gray
Research