Warehouse_Management_System.xlsx

	A	B	C	D	E	G	I	K
1	🏭 WAREHOUSE MANAGEMENT SYSTEM — DASHBOARD
2	Auto-calculated from all module sheets
3
4	📦 Total SKUs		✅ Inventory Accuracy		🚚 Open Orders	📬 Shipped Today	⚠️ Low Stock Items	📥 Pending Receiving
5	-182		98.7%		0	0	1	0
6
7
8
9
10	📈 KEY PERFORMANCE INDICATORS
11	KPI	Formula	Current Value	Target	Status
12	Inventory Accuracy %	Correct Inventory / Total × 100	98.5	>99%	🟡 Near
13	Order Accuracy %	Correct Orders / Total × 100	99.1	>98%	🟢 Met
14	On-Time Delivery %	On-Time / Total Deliveries × 100	0.0	>95%	🟢 Met
15	Space Utilization %	Used Space / Available × 100	0.0	80-90%	🟢 Met
16	Picking Accuracy %	Correct Picks / Total Picks × 100	99.3	>99%	🟢 Met
17	Dock-to-Stock Time (hr)	Avg time from dock to put-away	2.5	<4 hrs	🟢 Met
18	Inventory Turnover	COGS / Average Inventory	0.0	Industry	🟡 Review
19	Damage/Loss Rate %	Damaged / Total Handled × 100	0.3	<1%	🟢 Met
20
21	🗂️ MODULE NAVIGATION
22	📊 Dashboard	This sheet — live KPIs & overview
23	📦 Inventory	SKU master, stock levels, ABC analysis, reorder alerts
24	📥 Receiving	GRN log, supplier receipts, quality inspection
25	📤 Put-Away	Bin assignments, storage locations, putaway tasks
26	🛒 Orders	Sales orders, picking lists, order status tracking
27	🚚 Shipping	Dispatch log, delivery tracking, carrier management
28	🔄 Returns	Return authorization, inspection, restock decisions
29	📋 Reports	Automated summary reports and analytics
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100