Supply Chain Management Dashboard - Project Report

Supply Chain Management Dashboard - Project Report

Executive Summary
This project presents a comprehensive Supply Chain Management Dashboard developed using
Python. The dashboard analyzes and visualizes critical supply chain metrics including inventory
management, order fulfillment, supplier performance, transportation efficiency, and cost
analysis. The project generates multiple visualization dashboards and provides actionable
insights for supply chain optimization.

1. Project Overview

1.1 Project Description

The Supply Chain Management Dashboard is a data visualization project that transforms
complex supply chain data into meaningful insights through interactive dashboards and charts.
The project demonstrates end-to-end supply chain analytics including inventory tracking,
supplier evaluation, cost optimization, and transportation management.

1.2 Technology Stack

Component Technology
Programming Language Python 3.x
Data Processing Pandas
Data Visualization Matplotlib NumPy
Dashboard Creation GridSpec (Matplotlib)
Alternative Visualization Tableau (.twb file)

1.3 Project Files

Supply_chain_management_project/
├── supply_chain_dashboard.py # Main Python dashboard script
├── supply_chain_data.csv # Dataset with 100 products
├── supple_chain_management_01.twb # Tableau workbook
├── inventory_management.png # Inventory dashboard visualization
├── order_fulfillment.png # Order fulfillment visualization
├── supplier_performance.png # Supplier performance chart
├── supply_chain_costs.png # Cost analysis visualization
├── transportation_efficiency.png # Transportation metrics
└── supply_chain_main_dashboard.png # Main combined dashboard

---

pg. 1
 Supply Chain Management Dashboard - Project Report

2. Data Overview

2.1 Dataset Structure

The dataset contains 100 products (SKU0-SKU99) with 24 attributes covering various aspects of
the supply chain.

2.2 Data Attributes

# Product Information
Attribute Description Example Values
Product type Category of product haircare skincare cosmetics
SKU Stock Keeping Unit SKU0 SKU1 ... SKU99
Price Product price 1.70 - 99.17
Number of products sold Sales volume 1 - 996
Revenue generated Total revenue from product 1, 061.62 – 9 ,866.47

# Inventory Management

Attribute Description Example Values

Stock levels Current inventory quantity 0 - 100
Availability Product availability status 1 - 100
Stock Status Classification (Low/Sufficient) Low Stock- Sufficient Stock

# Customer & Sales

Attribute Description Example Values

Customer demographics Target customer segment Male Female Non-binary
Unknown
Order quantities Number of items per order 1 - 96

# Supplier Information

Attribute Description Example Values

Supplier name Supplier identifier Supplier 1 Supplier 2...
Supplier 5
Location Supplier location Mumbai Delhi Kolkata
Bangalore Chennai
Lead time Time from order to delivery 1 - 30
(days)
Manufacturing lead time Production time (days) 1 - 30
Manufacturing costs Cost of manufacturing 1.09 - 99.47
Production volumes Volume of production 104 - 985

pg. 2
 Supply Chain Management Dashboard - Project Report

# Quality Metrics
Attribute Description Example Values
Inspection results Quality check status Pass Fail Pending
Defect rates Percentage of defective 0.02% - 4.94%
products

# Shipping & Transportation

Attribute Description Example Values
Shipping carriers Shipping provider Carrier A Carrier B Carrier C
Shipping costs Cost of shipping 1.01 - 9.93
Shipping times Time for delivery (days) 1 - 10
Transportation modes Transport method Road Air Rail Sea
Routes Delivery route Route A Route B Route C

pg. 3
 Supply Chain Management Dashboard - Project Report

3. Data Analysis Summary

3.1 Key Metrics Overview

Metric Value
Total Records 100 products
Product Types 3 (haircare skincare cosmetics)
Suppliers 5 (Supplier 1-5)
Locations 5 (Mumbai Delhi Kolkata Bangalore Chennai)
Shipping Carriers 3 (Carrier A B C)
Transportation Modes 4 (Road Air Rail Sea)
Routes 3 (Route A B C)

3.2 Financial Metrics

Metric Value
Total Revenue $573 475.77 (calculated from sample)
Average Revenue per Product $5 734.76
Total Costs Variable by product type
Average Lead Time ~16.5 days
Average Manufacturing Lead Time ~14.5 days
Average Defect Rate ~2.32%

3.3 Inventory Status

Based on the stock levels analysis:
◻ **Low Stock** (< 50 units): Products requiring immediate restocking
◻ **Sufficient Stock** (≥ 50 units): Adequately stocked products

The dashboard visualizes inventory status using:

◻ Bar charts showing stock levels by SKU
◻ Pie charts for stock status distribution
◻ Scatter plots correlating stock levels with availability

pg. 4
 Supply Chain Management Dashboard - Project Report

---

4. Dashboard Components

4.1 Main Dashboard (supply_chain_main_dashboard.png)

Figure: supply_chain_main_dashboard.png

The main dashboard provides a comprehensive overview of the entire supply chain with the
following components:

1. Revenue by Product Type (Pie Chart)

◻ Distribution of revenue across haircare, skincare, and cosmetics
◻ Helps identify the most profitable product category

2. Stock Status (Pie Chart)

◻ Visual representation of low stock vs. sufficient stock products
◻ Critical for inventory management decisions

3. Top 5 Suppliers by Revenue (Horizontal Bar Chart)

◻ Identifies best-performing suppliers
◻ Supports supplier relationship management

4. Average Shipping Costs by Carrier (Bar Chart)

◻ Cost comparison across shipping providers
◻ Guides carrier selection decisions

pg. 5
 Supply Chain Management Dashboard - Project Report

5. Transportation Modes (Pie Chart)

◻ Distribution of shipping methods used
◻ Helps optimize transportation strategy

6. Average Lead Time by Location (Horizontal Bar Chart)

◻ Supplier location performance comparison
◻ Supports logistics planning

7. Cost Analysis by Product Type (Grouped Bar Chart)

◻ Manufacturing costs, shipping costs, and total costs comparison
◻ Enables cost optimization strategies

---

4.2 Inventory Management Dashboard (inventory_management.png)

Figure: inventory_management.png

This dashboard focuses on inventory tracking and management:

1. Stock Levels by SKU (Horizontal Bar Chart)

◻ Top 15 haircare products by stock levels
◻ Color-coded: Red (< 50), Green (≥ 50)
◻ Low stock threshold line at 50 units

2. Stock Levels vs Availability (Scatter Plot)

◻ Correlation between stock and availability
◻ Color intensity shows products sold

pg. 6
 Supply Chain Management Dashboard - Project Report

◻ Identifies inventory efficiency

3. Stock Status Distribution (Pie Chart)

◻ Overall inventory health visualization
◻ Percentage of low vs. sufficient stock

4. Average Stock Levels by Product Type (Bar Chart)

◻ Category-wise inventory comparison
◻ Identifies product types requiring attention

---

4.3 Order Fulfillment Dashboard (order_fulfillment.png)

Figure: order_fulfillment.png

This dashboard analyzes order processing and revenue generation:

1. Revenue by Product Type (Bar Chart)

◻ Total revenue comparison across categories
◻ Identifies most profitable product types

2. Products Sold vs Revenue (Scatter Plot)

◻ Correlation analysis between volume and revenue
◻ Price shown via color gradient

3. Top 10 SKUs by Revenue (Horizontal Bar Chart)

◻ Best-selling products identification
◻ Revenue contribution analysis

pg. 7
 Supply Chain Management Dashboard - Project Report

4. Average Order Quantity by Product Type (Bar Chart)

◻ Order size patterns by category
◻ Supports demand forecasting

---

4.4 Supplier Performance Dashboard (supplier_performance.png)

Figure: supplier_performance.png

This dashboard evaluates supplier performance metrics:

1. Average Lead Time by Supplier (Horizontal Bar Chart)

◻ Delivery performance comparison
◻ Time-to-delivery analysis

2. Average Manufacturing Costs by Supplier (Bar Chart)

◻ Cost efficiency comparison
◻ Supplier pricing analysis

3. Average Defect Rates by Supplier (Bar Chart)

◻ Quality performance metrics
◻ Supplier reliability assessment

4. Supplier Performance Comparison (Grouped Bar Chart)

◻ Multi-metric comparison: Lead Time, Manufacturing Lead Time, Defect Rate
◻ Comprehensive supplier evaluation

---

pg. 8
 Supply Chain Management Dashboard - Project Report

4.5 Supply Chain Costs Dashboard (supply_chain_costs.png)

Figure: supply_chain_costs.png

This dashboard provides detailed cost analysis:

1. Costs by Product Type (Pie Chart)

◻ Cost distribution across categories
◻ Category profitability analysis

2. Manufacturing Costs by Product Type (Bar Chart)

◻ Production cost comparison
◻ Cost optimization opportunities

3. Total Costs by Transportation Mode (Bar Chart)

◻ Shipping cost analysis by mode
◻ Mode selection guidance

4. Average Shipping Costs by Carrier (Bar Chart)

◻ Carrier cost comparison
◻ Contract negotiation insights

---

4.6 Transportation Efficiency Dashboard (transportation_efficiency.png)

pg. 9
 Supply Chain Management Dashboard - Project Report

Figure: transportation_efficiency.png

This dashboard analyzes logistics performance:

1. Average Shipping Times by Route (Horizontal Bar Chart)

◻ Route performance comparison
◻ Delivery time optimization

2. Average Shipping Times by Carrier (Bar Chart)

◻ Carrier delivery performance
◻ Service level assessment

3. Average Costs by Route (Bar Chart)

◻ Route cost analysis
◻ Cost-effective routing

4. Transportation Mode Efficiency (Combined Bar-Line Chart)

◻ Shipping time vs. cost comparison
◻ Mode selection optimization

---

5. Data Insights & Findings

5.1 Product Type Distribution

◻ **Skincare**: Largest product category with diverse pricing
◻ **Haircare**: Mid-range pricing and sales volume
◻ **Cosmetics**: Varied pricing from budget to premium

pg. 10
 Supply Chain Management Dashboard - Project Report

5.2 Supplier Analysis

◻ **5 Major Suppliers** operating across 5 locations
◻ **Performance Variation**: Significant differences in lead times, manufacturing costs, and
defect rates
◻ **Location Impact**: Different locations show varying lead times

5.3 Transportation Insights

◻ **4 Transportation Modes**: Road, Air, Rail, Sea
◻ **3 Shipping Carriers**: Carrier A, B, C with varying costs
◻ **3 Routes**: Route A, B, C with different performance metrics

5.4 Quality Metrics

◻ **Inspection Results**: Mix of Pass, Fail, and Pending
◻ **Defect Rates**: Range from 0.02% to 4.94%
◻ **Quality Variation**: Significant differences between suppliers

5.5 Cost Structure

◻ **Manufacturing Costs**: Major cost component
◻ **Shipping Costs**: Variable by carrier and mode
◻ **Total Costs**: Range from $103.92 to $996.78 per product

---

6. Implementation Details

6.1 Python Code Structure

The dashboard is implemented using a modular approach with the following

functions: python

Main Dashboard Functions

create_inventory_management() # Inventory
analytics create_order_fulfillment() #
Sales & revenue analysis
create_supplier_performance() # Supplier
evaluation create_supply_chain_costs()
# Cost analysis
create_transportation_efficiency() # Logistics
metrics create_main_dashboard()
# Combined overview
print_summary() # Data statistics

6.2 Visualization Techniques

pg. 11
 Supply Chain Management Dashboard - Project Report

◻ **Bar Charts**: Categorical comparisons

pg. 12
 Supply Chain Management Dashboard - Project Report

◻ **Pie Charts**: Distribution analysis

◻ **Scatter Plots**: Correlation analysis
◻ **Combined Charts**: Multi-metric visualization
◻ **Color Coding**: Status indication (green/red)

6.3 Key Python Libraries

python
import pandas as pd # Data manipulation
import [Link] as plt #
Visualization import numpy as np
# Numerical
operations
from [Link] import GridSpec # Layout management

---

7. Recommendations & Next Steps

7.1 Inventory Management

1. Implement real-time stock monitoring
2. Set up automatic reorder point alerts
3. Optimize stock levels based on demand patterns

7.2 Supplier Management

1. Establish supplier performance KPIs
2. Conduct regular quality audits
3. Develop supplier scorecards

7.3 Cost Optimization

1. Negotiate bulk shipping rates
2. Evaluate alternative transportation modes
3. Consolidate shipments for cost efficiency

7.4 Technology Enhancements

1. Integrate with real-time data sources
2. Add interactive dashboard features
3. Implement predictive analytics

---

8. Conclusion
This Supply Chain Management Dashboard project demonstrates a comprehensive approach
to analyzing
pg. 13
 Supply Chain Management Dashboard - Project Report

and visualizing supply chain data. The dashboard provides actionable insights across multiple
dimensions including inventory management, order fulfillment, supplier performance, cost
analysis, and transportation efficiency.

The project successfully:

◻ ◻ Processes 100 products with 24 attributes
◻ ◻ Generates 6 different dashboard visualizations
◻ ◻ Provides multi-dimensional analysis
◻ ◻ Supports data-driven decision making
◻ ◻ Offers both Python and Tableau implementations

The visualizations and analysis presented in this project can help organizations optimize their
supply chain operations, reduce costs, improve supplier relationships, and enhance overall
efficiency.

---

Appendix: Generated Visualizations

Dashboard File Name Description

Main Dashboard supply_chain_main_dashboard. Combined overview of all

png metrics

Inventory inventory_management.png Stock levels and availability

Order Fulfillment order_fulfillment.png Revenue and sales analysis

Supplier Performance supplier_performance.png Supplier metrics comparison

Costs supply_chain_costs.png Cost breakdown analysis

Transportation transportation_efficiency.png Logistics performance metrics

pg. 14