Date: 20-Nov-22
Inventory Management Templa
WH1 WH2
Product Code Product Name Opening Closing Opening
Stock IN Stock Out Transfer IN Transfer Out Stock IN
Stock Stock Stock
10001 Product1 24 20 10 0 0 34 37 0
10002 Product2 28 0 0 0 0 28 25 0
10003 Product3 44 0 0 0 0 44 35 0
10004 Product4 11 0 0 0 0 11 37 0
10005 Product5 31 0 0 0 0 31 28 0
10006 Product6 42 0 0 0 0 42 44 0
10007 Product7 23 0 0 0 0 23 29 0
10008 Product8 42 0 0 0 0 42 21 0
10009 Product9 46 0 0 0 0 46 33 0
10010 Product10 31 0 0 0 0 31 27 0
SOMME.SI.ENS('Input Data'!$F:$F;'Input Data'!$A:$A;"<"&Summary!$B$2;'Input Data'!$B:$B;Summary!$A6;'Input Data'!$
+ SOMME.SI.ENS('Input Data'!$F:$F;'Input Data'!$A:$A;"<"&Summary!$B$2;'Input Data'!$B:$B;Summary!$A6;'Input Data'!$
- SOMME.SI.ENS('Input Data'!$F:$F;'Input Data'!$A:$A;"<"&Summary!$B$2;'Input Data'!$B:$B;Summary!$A6;'Input Data'!$
- SOMME.SI.ENS('Input Data'!$F:$F;'Input Data'!$A:$A;"<"&Summary!$B$2;'Input Data'!$B:$B;Summary!$A6;'Input Data'!$
ent Template for Multiple Locations
WH2 WH3
Transfer Closing Opening Transfer Closing Opening
Stock Out Transfer Out Stock IN Stock Out Transfer Out
IN Stock Stock IN Stock Stock
0 0 0 37 31 0 0 0 0 31 16
0 0 0 25 36 0 0 0 0 36 43
0 0 0 35 31 0 0 0 0 31 25
0 0 0 37 29 0 0 0 0 29 37
0 0 0 28 33 0 0 0 0 33 40
0 0 0 44 24 0 0 0 0 24 31
0 0 0 29 47 0 0 0 0 47 48
0 0 0 21 22 0 0 0 0 22 50
0 0 0 33 24 0 0 0 0 24 37
0 0 0 27 37 0 0 0 0 37 21
B;Summary!$A6;'Input Data'!$D:$D;Summary!$C$4;'Input Data'!$E:$E;"IN")
B;Summary!$A6;'Input Data'!$E:$E;"Transfer";'Input Data'!$G:$G;Summary!$C$4)
B;Summary!$A6;'Input Data'!$D:$D;Summary!$C$4;'Input Data'!$E:$E;"Out")
B;Summary!$A6;'Input Data'!$D:$D;Summary!$C$4;'Input Data'!$E:$E;"Transfer")
WH4 Total
Closing Closing
Stock IN Stock Out Transfer IN Transfer Out
Stock Stock
0 0 0 0 16 118
0 0 0 0 43 132
0 0 0 0 25 135
0 0 0 0 37 114
0 0 0 0 40 132
0 0 0 0 31 141
0 0 0 0 48 147
0 0 0 0 50 135
0 0 0 0 37 140
0 0 0 0 21 116
Month
November
Year
2022
Daily Trend
10-Nov
11-Nov
12-Nov
13-Nov
14-Nov
15-Nov
16-Nov
17-Nov
1-Nov
2-Nov
3-Nov
4-Nov
5-Nov
6-Nov
7-Nov
8-Nov
9-Nov
WH/Date
### Product1 0 0 24 24 24 24 24 24 24 24 24 4 4 4 4 4 4
### Product2 0 0 48 48 48 28 28 28 28 28 28 28 28 28 28 28 28
### Product3 0 0 26 26 16 16 16 16 16 16 16 16 16 16 44 44 44
### Product4 0 0 21 21 21 21 21 21 21 21 21 21 21 21 11 11 11
### Product5 0 0 31 31 31 31 31 31 31 31 31 31 31 31 31 31 31
### Product6 0 0 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42
### Product7 0 0 23 23 23 23 23 23 23 23 23 23 23 23 23 23 23
### Product8 0 0 42 42 42 42 42 42 42 42 42 42 42 42 42 42 42
### Product9 0 0 46 46 46 46 46 46 46 46 46 46 46 46 46 46 46
### Product10 0 0 31 31 31 31 31 31 31 31 31 31 31 31 31 31 31
y Trend Warehouse
WH1
18-Nov
19-Nov
20-Nov
21-Nov
22-Nov
23-Nov
24-Nov
25-Nov
26-Nov
27-Nov
28-Nov
29-Nov
30-Nov
1-Dec
4 4 14 14 14 14 14 29 29 29 29 29 29 29
28 28 28 28 28 28 28 28 28 28 28 28 28 28
44 44 44 44 44 44 44 44 44 44 44 44 44 44
11 11 11 11 11 11 11 11 11 11 11 11 11 11
31 31 31 31 31 31 31 31 31 31 31 31 31 31
42 42 42 42 42 42 42 42 42 42 42 42 42 42
23 23 23 23 23 23 23 23 23 23 23 23 23 23
42 42 42 42 42 42 42 42 42 42 42 42 42 42
46 46 46 46 46 46 46 46 46 46 46 46 46 46
31 31 31 31 31 31 31 31 31 31 31 31 31 31
Date Product Code Product Name Warehouse Transaction Type
1-Nov-22 10001 Product1 WH1 IN
1-Nov-22 10002 Product2 WH1 IN
1-Nov-22 10003 Product3 WH1 IN
1-Nov-22 10004 Product4 WH1 IN
1-Nov-22 10005 Product5 WH1 IN
1-Nov-22 10006 Product6 WH1 IN
1-Nov-22 10007 Product7 WH1 IN
1-Nov-22 10008 Product8 WH1 IN
1-Nov-22 10009 Product9 WH1 IN
1-Nov-22 10010 Product10 WH1 IN
1-Nov-22 10001 Product1 WH2 IN
1-Nov-22 10002 Product2 WH2 IN
1-Nov-22 10003 Product3 WH2 IN
1-Nov-22 10004 Product4 WH2 IN
1-Nov-22 10005 Product5 WH2 IN
1-Nov-22 10006 Product6 WH2 IN
1-Nov-22 10007 Product7 WH2 IN
1-Nov-22 10008 Product8 WH2 IN
1-Nov-22 10009 Product9 WH2 IN
1-Nov-22 10010 Product10 WH2 IN
1-Nov-22 10001 Product1 WH3 IN
1-Nov-22 10002 Product2 WH3 IN
1-Nov-22 10003 Product3 WH3 IN
1-Nov-22 10004 Product4 WH3 IN
1-Nov-22 10005 Product5 WH3 IN
1-Nov-22 10006 Product6 WH3 IN
1-Nov-22 10007 Product7 WH3 IN
1-Nov-22 10008 Product8 WH3 IN
1-Nov-22 10009 Product9 WH3 IN
1-Nov-22 10010 Product10 WH3 IN
1-Nov-22 10001 Product1 WH4 IN
1-Nov-22 10002 Product2 WH4 IN
1-Nov-22 10003 Product3 WH4 IN
1-Nov-22 10004 Product4 WH4 IN
1-Nov-22 10005 Product5 WH4 IN
1-Nov-22 10006 Product6 WH4 IN
1-Nov-22 10007 Product7 WH4 IN
1-Nov-22 10008 Product8 WH4 IN
1-Nov-22 10009 Product9 WH4 IN
1-Nov-22 10010 Product10 WH4 IN
5-Nov-22 10003 Product3 WH1 OUT
6-Nov-22 10002 Product2 WH1 OUT
7-Nov-22 10001 Product1 WH4 TRANSFER
12-Nov-22 10001 Product1 WH1 OUT
15-Nov-22 10003 Product3 WH1 IN
15-Nov-22 10003 Product3 WH1 OUT
15-Nov-22 10004 Product4 WH1 TRANSFER
15-Nov-22 10005 Product5 WH2 IN
20-Nov-22 10001 Product1 WH1 IN
20-Nov-22 10001 Product1 WH1 OUT
25-Nov-22 10001 Product1 WH1 IN
25-Nov-22 10001 Product1 WH1 TRANSFER
Qty Transfer To
24
48
26
21
31
42
23
42
46
31
37
25
35
27
23
44
29
21
33
27
31
36
31
29
33
24
47
22
24
37
36
43
25
37
40
31
48
50
37
21
10
20
20 WH1
20
40
12
10 WH2
5
20
10
25
10 WH4
Product Code Product Name Re-order Level for each warehouse
10001 Product1 25
10002 Product2 33
10003 Product3 32
10004 Product4 29
10005 Product5 34
10006 Product6 21
10007 Product7 23
10008 Product8 18
10009 Product9 38
10010 Product10 15
WH Name
WH1
WH2
WH3
WH4
Resource Links
Download our free Excel utility Tool and improve your productivity:
https://www.pk-anexcelexpert.com/products/pks-utility-tool-v2-0/
See our Excel Products:
https://www.pk-anexcelexpert.com/products/
Visit to learn more:
Chart and Visualizations: https://www.pk-anexcelexpert.com/category/blogs/charts-and-visualization/
VBA Course: https://www.pk-anexcelexpert.com/vba/
Download useful Templates: https://www.pk-anexcelexpert.com/category/templates/
Dashboards: https://www.pk-anexcelexpert.com/excel-dashboard/
Watch the best info-graphics and dynamic charts from below link:
https://www.youtube.com/playlist?list=PLbDvAYjpWJ7CEAHn-iuGSeLbUtFnYekHr
Learn and free download best excel Dashboard template:
https://www.youtube.com/playlist?list=PLbDvAYjpWJ7CpupRYMRkXSN0L92t7nUuF
Learn Step by Step VBA:
https://www.youtube.com/playlist?list=PLbDvAYjpWJ7BcoaFQD-syOrZzNSLZycwH
Links
YouTube Channel:
https://www.youtube.com/c/PKAnExcelExpert
Website:
https://WWW.PK-AnExcelExpert.com
Facebook:
sualization/ https://www.facebook.com/PKAnExcelExpert
Telegram:
https://t.me/joinchat/AAAAAE2OnviiEk5o1o8i4w
Pinterest:
https://www.pinterest.com/PKAnExcelExpert/
LinkedIn:
https://www.linkedin.com/company/pk-anexcelexpert
Instagram:
https://www.instagram.com/pkanexcelexpert
Visit our Amazon Store
https://www.amazon.in/shop/PKAnExcelExpert
