automated excel to track inventory r for a solar company
ITEM CODE ITEM NAME
HDS101
555watt Solar Panel
HDS102
585 watt Solar Panel
UNIT PRICE
INITIAL STOCK QUANTITY USED
REMAINING
TOTAL VALUE QUANTITY
FROM STOCK
STOCK-
Total
Quantity
Recieved
(NEW)
25
4
LOW
STOCK
ITEMS
25 No
0 Yes
HDI201
10kw Inverter SRNE
0.00
4
1
3
0 Yes
HDB301
HDB302
HDB303
HDB304
HDB305
JINKO Battery
Mega Tank Battery
WECCO Battery
Durable Force Battery
BEN battery
-
-
0
0
0
0
12
-
0
0
0
0
0
No
Yes
Yes
Yes
No
HDR401
HDR402
HDR403
HDR404
HDR405
HDR406
Regular Battery (8 sets) rack
TUBULAR Battery (8 sets) Rack
Regular Battery (12 sets) Rack
JINKO Battery (7 sets) Rack
JINKO Battery (9 sets) Rack
Solar Rails
-
-
-
-
0
0
0
0
0
0
Yes
Yes
Yes
Yes
Yes
No
CSE101
CSE102
CSE103
CSE104
CSE105
CSE106
CSE107
CSE108
CSE109
CSE110
CSE111
CSE112
Seanro SR-40C AC surge
Seanro SR-40C DC surge
Seanro SR-125A Solar Breaker
ABB C 32 Breaker
ABB C 63 Breaker
ABB C 20 Breaker
250A DC Breaker
Rotary Switch
3-phase AVS
20Amps Proton breaker
12 way Enclosure
9-way Enclosure
-
-
-
-
-
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
Yes
CSC101
CSC102
CSC104
Earth Cable 4mm
Solar Cable 150mm
Cable 12mtrs 50mm
-
1
0
1
0
0
0
1
0
1
0 Yes
0 Yes
0 Yes
CSS101
cable lug 50mm
0.00
1
0
1
0 Yes
ITEM CODE
CSS102
CSS103
CSS104
CSS105
CSS106
CSS107
CSS108
CSS109
CSS110
CSS111
CSS112
ITEM NAME
Cable Tie
Busbar
Flex pipe
Insulation Tape
Enclamp Lots
Silicone
Flashband
Nails
Rails washer
Screw
Peg size 8
UNIT PRICE
TOTAL VALUE
2,000.00
6,-,-,-,-,000.00
1,000.00
5,-,-,000.00
5,-,000.00
2,000.00
8,-,-,-,500.00
INITIAL STOCK QUANTITY USED
QUANTITY
FROM STOCK
3
2
1
5
-
Total
Quantity
Recieved
(NEW)
REMAINING
STOCK
-
-
-
LOW
STOCK
ITEMS
Yes
Yes
Yes
Yes
Yes
No
Yes
Yes
No
No
Yes