Spreadsheet: 703073d1604735171-inventory-tracking-formulas-and-formula-for-discounts-or-bulk-buying-example
Sheet: Master 

S No. | Product ID | Product Name | Product Category | Unit Price | Ideal Inventory | Available Stock
1 | 00-BM-A-1A | 00-BM-A-1A | Bookmarks | 7
2 | 00-BM-A-1B | 00-BM-A-1B | Bookmarks | 7
3 | 00-BM-A-1C | 00-BM-A-1C | Bookmarks | 7
4 | 00-BM-B-1A | 00-BM-B-1A | Bookmarks | 7
5 | 00-BM-B-1B | 00-BM-B-1B | Bookmarks | 7
6 | 00-BM-B-1C | 00-BM-B-1C | Bookmarks | 7
7 | 00-BM-B-2A | 00-BM-B-2A | Bookmarks | 7
8 | 00-BM-B-2B | 00-BM-B-2B | Bookmarks | 7
9 | 00-BM-B-2C | 00-BM-B-2C | Bookmarks | 7
10 | 00-BM-C-1A | 00-BM-C-1A | Bookmarks | 7
11 | 00-BM-C-1B | 00-BM-C-1B | Bookmarks | 7
12 | 00-BM-C-1C | 00-BM-C-1C | Bookmarks | 7
13 | 00-BM-C-2A | 00-BM-C-2A | Bookmarks | 7
14 | 00-BM-C-2B | 00-BM-C-2B | Bookmarks | 7
15 | 00-BM-C-2C | 00-BM-C-2C | Bookmarks | 7
16 | 00-BM-D-1A | 00-BM-D-1A | Bookmarks | 7
17 | 00-BM-D-1B | 00-BM-D-1B | Bookmarks | 7
18 | 00-BM-D-1C | 00-BM-D-1C | Bookmarks | 7
19 | 00-BM-D-2A | 00-BM-D-2A | Bookmarks | 7
20 | 00-BM-D-2B | 00-BM-D-2B | Bookmarks | 7
21 | 00-BM-D-2C | 00-BM-D-2C | Bookmarks | 7
22 | 00-BM-E-1A | 00-BM-E-1A | Bookmarks | 7
23 | 00-BM-E-1B | 00-BM-E-1B | Bookmarks | 7
24 | 00-BM-E-1C | 00-BM-E-1C | Bookmarks | 7
25 | 00-BM-E-2A | 00-BM-E-2A | Bookmarks | 7
26 | 00-BM-E-2B | 00-BM-E-2B | Bookmarks | 7
27 | 00-BM-E-2C | 00-BM-E-2C | Bookmarks | 7
28 | 00-BM-F-1A | 00-BM-F-1A | Bookmarks | 7
29 | 00-BM-F-1B | 00-BM-F-1B | Bookmarks | 7
30 | 00-BM-F-1C | 00-BM-F-1C | Bookmarks | 7
31 | 00-BM-F-2A | 00-BM-F-2A | Bookmarks | 7
32 | 00-BM-F-2B | 00-BM-F-2B | Bookmarks | 7
33 | 00-BM-F-2C | 00-BM-F-2C | Bookmarks | 7
34 | 00-BM-F-2C | 00-BM-F-2C | Bookmarks | 7
35 | 00-BM-G-1A | 00-BM-G-1A | Bookmarks | 7
36 | 00-BM-G-1B | 00-BM-G-1B | Bookmarks | 7
37 | 00-BM-G-1C | 00-BM-G-1C | Bookmarks | 7
38 | 00-BM-G-2A | 00-BM-G-2A | Bookmarks | 7
39 | 00-BM-G-2B | 00-BM-G-2B | Bookmarks | 7
40 | 00-BM-G-2C | 00-BM-G-2C | Bookmarks | 7
41 | 00-BM-G-2D | 00-BM-G-2D | Bookmarks | 7
42 | 00-BM-H-1A | 00-BM-H-1A | Bookmarks | 7
43 | 00-BM-H-1B | 00-BM-H-1B | Bookmarks | 7
44 | 00-CH-1-S | 00-CH-1-S | CHOKER | 10
45 | 00-CH-1-M | 00-CH-1-M | CHOKER | 10
46 | 00-CH-2-S | 00-CH-2-S | CHOKER | 10
47 | 00-CH-3-S | 00-CH-3-S | CHOKER | 10
48 | 00-CH-3-L | 00-CH-3-L | CHOKER | 10
49 | 00-CH-4-S | 00-CH-4-S | CHOKER | 10
50 | 00-CH-4-M | 00-CH-4-M | CHOKER | 10
51 | 00-CH-4-L | 00-CH-4-L | CHOKER | 10
52 | 00-CH-5-S | 00-CH-5-S | CHOKER | 10
53 | 00-CH-5-M | 00-CH-5-M | CHOKER | 10
54 | 00-CH-5-L | 00-CH-5-L | CHOKER | 10
55 | 00-CH-6-L | 00-CH-6-L | CHOKER | 10
56 | 00-CH-7-M | 00-CH-7-M | CHOKER | 10
57 | 00-CH-8-L | 00-CH-8-L | CHOKER | 10
58 | 00-CH-9-M | 00-CH-9-M | CHOKER | 10
59 | 00-CH-10-L | 00-CH-10-L | CHOKER | 10
60 | 00-CH-11-S | 00-CH-11-S | CHOKER | 10
61 | 00-CH-12-S | 00-CH-12-S | CHOKER | 10
62 | 00-CH-13-L | 00-CH-13-L | CHOKER | 10
63 | 00-CH-14-S | 00-CH-14-S | CHOKER | 10
64 | 00-CH-15-S | 00-CH-15-S | CHOKER | 10
65 | 00-CH-16-M | 00-CH-16-M | CHOKER | 10
66 | 00-CH-17-S | 00-CH-17-S | CHOKER | 10
67 | 00-CH-18-S | 00-CH-18-S | CHOKER | 10
68 | 00-CH-19-S | 00-CH-19-S | CHOKER | 10
69 | 00-CH-20-S | 00-CH-20-S | CHOKER | 10
70 | 00-CH-21-S | 00-CH-21-S | CHOKER | 10
71 | 00-CH-22-S | 00-CH-22-S | CHOKER | 10
72 | 00-CH-23-S | 00-CH-23-S | CHOKER | 10
73 | 00-CH-24-S | 00-CH-24-S | CHOKER | 10
74 | 00-CH-25-18 | 00-CH-25-19 | CHOKER | 10
75 | 00-CH-26-S | 00-CH-26-S | CHOKER | 10
76 | 00-CH-27-S | 00-CH-27-S | CHOKER | 10
77 | 00-CH-28-S | 00-CH-28-S | CHOKER | 10
78 | 00-CH-29-18 | 00-CH-29-19 | CHOKER | 10
79 | 00-CH-30-S | 00-CH-30-S | CHOKER | 10
80 | 00-CH-31-M | 00-CH-31-M | CHOKER | 10
81 | 00-CH-32-S | 00-CH-32-S | CHOKER | 10
82 | 00-CH-33-S | 00-CH-33-S | CHOKER | 10
83 | 00-CH-34-M | 00-CH-34-M | CHOKER | 10
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100