Inventory_Management_System-1.xlsx

	B	C	D	E	F	G	H
1	📦 INVENTORY MANAGEMENT SYSTEM
2	Real-time stock control · Auto-alerts · KPI tracking
3
4	TOTAL SKUs	LOW STOCK	OUT OF STOCK	TOTAL VALUE (₱)	AVG TURNOVER
5	9	0	0	₱125,407.00	0.0x
6
7	🚨 STOCK ALERTS — Items Needing Attention
8	SKU	Item Name	Category	On Hand	Reorder Lvl	Status	Action
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23	📊 ABC CLASSIFICATION SUMMARY
24	Class	# of SKUs	Total Value (₱)	% of Value	Control Level
25	A – High Value	2	₱102,600.00	81.8%	Tight control · Daily monitoring
26	B – Medium Value	3	₱6,802.00	5.4%	Regular review · Weekly check
27	C – Low Value	5	₱16,005.00	12.8%	Bulk order · Periodic review
28
29	📌 HOW TO USE THIS SYSTEM
30	1️⃣ Inventory Sheet	Enter all your stock items in '📋 Inventory'. Fill in SKU, name, category, unit cost, qty on hand, and reorder level.
31	2️⃣ Auto-Calculations	Status, ABC class, reorder point, safety stock, EOQ, and total value are AUTOMATICALLY calculated.
32	3️⃣ Stock Movements	Log every stock in/out in '🔄 Stock Movement'. Running balance updates automatically.
33	4️⃣ Purchase Orders	When stock is low, go to '🛒 Purchase Orders' to create and track orders.
34	5️⃣ Dashboard	This sheet auto-refreshes alerts and KPIs. No manual updates needed.
35	6️⃣ Google Sheets	This file is fully compatible. Upload to Google Drive > Open with Sheets.
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