Network Analysis Worksheet
Diagnostic tool for mapping current distribution structure and identifying bottlenecks before applying Murray's Law optimization.
Diagnostic tool for mapping current distribution structure and identifying bottlenecks before applying Murray's Law optimization.
When to Use Network Analysis Worksheet
Use as first step before any distribution network optimization. Maps current state to identify gaps and opportunities.
How to Apply
Current State Mapping
List all facilities with location, size (sq ft), capacity (orders/day), current utilization (%). Map customer density by region. Calculate average facility-to-customer distance.
Outputs
- Facility inventory
- Customer density map
- Distance metrics
Bottleneck Identification
Identify facilities >90% utilized (expansion candidates). Find regions with longest delivery times (new facility candidates). Calculate % of orders traveling >500 miles (network under-branched if >30%). Determine last-mile % of shipping costs (should be <40%).
Questions to Ask
- Which facilities are >90% utilized?
- Which regions have longest delivery times?
- What % of orders travel >500 miles?
- What % of shipping costs go to last-mile?
Outputs
- Bottleneck list
- Expansion candidates
- Network health assessment
Network Health Scorecard
Score current vs. target for: Average delivery distance (<150 miles target), Facility utilization (75-85% target), Last-mile cost share (<40% target), 2-day delivery rate (>90% target).
Outputs
- Gap analysis
- Priority improvements