Inventory Management
Total Value
$465,316.50
Total Items
8,980
Low Stock Alerts
8
SKU
Description
Category
Location
On Hand
Allocated
Available
Reorder Pt
Value
RM-001-A
Steel Plate 1/4 inch
Raw Material
A-01-01
450
200
250
300
$20,475.00
RM-002-B
Aluminum Extrusion
Raw Material
A-02-02
1200
400
800
600
$27,300.00
RM-003-C
Copper Wire 10 AWG
Raw Material
A-03-01
280
150
130
400
$24,990.00
WIP-001-D
Welded Frame Assembly
WIP
B-01-03
85
85
0
30
$18,275.00
WIP-002-E
Machined Housing
WIP
B-02-01
120
80
40
50
$15,060.00
FG-001-F
Control Panel Assembly
Finished Goods
C-01-01
220
180
40
80
$106,700.00
FG-002-G
Hydraulic Pump Unit
Finished Goods
C-02-02
145
120
25
60
$108,750.00
FG-003-H
Electric Motor 5HP
Finished Goods
C-03-01
65
55
10
40
$78,000.00
MRO-001-I
Hydraulic Fluid ISO 46
MRO
D-01-02
320
80
240
150
$9,120.00
MRO-002-J
Bearing Set 6005
MRO
D-02-01
540
180
360
250
$8,505.00
PKG-001-K
Cardboard Box 12x12x12
Packaging
E-01-05
2400
800
1600
1000
$5,160.00
PKG-002-L
Foam Padding 1 inch
Packaging
E-02-03
1800
600
1200
800
$6,300.00
RM-004-M
Stainless Steel Bolts
Raw Material
A-04-02
850
350
500
400
$722.50
FG-004-N
Pressure Relief Valve
Finished Goods
C-04-01
95
70
25
50
$30,875.00
MRO-003-O
Drive Belt Type A
MRO
D-03-02
410
160
250
200
$5,084.00