Inventory Management Analysis.xlsx

	B	D	F	H	I	J	K	L	M
1	Inventory Management Dashboard
2	Inventory Management Dashboard
3	Period: 1 Jan 2026 to 30 Sep 2026 \| Currency: USD \| 30 SKUs, 1489 transactions
4	TOTAL SKUs	UNITS ON HAND	INVENTORY VALUE	REVENUE (SALES)		GROSS MARGIN %		INVENTORY TURNOVER
5	30	4,666	$60,693	$517,539		33.0%		5.9x
6
7	UNITS SOLD	PURCHASE SPEND	SKUs TO REORDER	STOCKOUTS		OVERSTOCKED SKUs		SUGGESTED PO VALUE
8	43,986	$312,175	10	3		3		$20,173
9
10	Product Lookup (choose a SKU from the dropdown)				Stock Status Summary
11	Select SKU	SKU-1011	<- change me		Status	SKUs	Stock Value	% of SKUs	% of Value
12	Product	Ergonomic Office Chair			OK	17	$33,996	56.7%	56.0%
13	Category	Furniture			Reorder	7	$6,779	23.3%	11.2%
14	Supplier	Urban Office Furniture			Stockout	3	-	10.0%	0.0%
15	Current Stock	2			Overstock	3	$19,917	10.0%	32.8%
16	Reorder Level	31			Total	30	$60,693	100.0%	100.0%
17	Days of Cover	1.7
18	Status	Reorder			Tip: Reorder_Alerts lists what to buy; ABC_Analysis ranks SKUs by revenue.
19	ABC Class	A
20
21
22
23
24
25
26
27
28
29
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