D. R. Rice Company

Helping You Manage Your Supply Chain More Effectively!


DATA MANAGEMENT GRID

Created by Chris Gray

Partners for Excellence

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:

Click here to see some detailed ideas on how to link these performance measurements to root causes of business problems.


Home  Education  Consulting  Software  Articles  Partners  Bio

D. R. Rice Company

9326 Lake Shore Drive Brentwood, TN 37027 615-221-2196 riceco@riceco.us