Spreadsheet: 868812d1715519006-vlookup-test-12-05-24
Sheet: Stock Calculations

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | "OK", Within stock limits |  |  |  | Under Review
Inventory Quantities as at 31/05/2024 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | "Fully Stocked" |  |  |  | Complete
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | "Over Stock" |  |  |  | Do Not Place Order (DNPO)
 |  |  |  |  |  |  | Sales |  | Purchase
Code & Description |  | Unit | Barcode | Balance | Unposted | On Hand | Orders | Available | Orders | Website Category | Description | Supplier | Actual Status | Suplier Code | [NAME] | Min Order Calc | Min Qty | Calculate | PCM | 3 Month | Min | [NAME] | Order | Comments/PO Number | Expected Del Date | Unit Cost £ | Qty | Total Cost £
Inventory Category : 001 - Aluminuim Foil Containers
100F |  | 2500 | T18-1114 | 4 | -1 | 3 | 0 | 3 | 0
104F |  | 1000 | B0202001 | 18 | 0 | 18 | 0 | 18 | 0
1236 |  | 10k | T0602001 | 12 | 0 | 12 | 0 | 12 | 0 |  |  |  |  | 1
2014 |  | 1500 | T0802001 | 13 | 0 | 13 | 0 | 13 | 0 |  |  |  |  | 114
2038 |  | 1000 | T18-1114 | 3.99999999999995 | 0 | 3.99999999999995 | 0 | 3.99999999999995 | 0 |  |  |  |  | 114
2050-02 |  | 900 | M08-1001 | 13 | 0 | 13 | 0 | 13 | 0
2074 |  | 600 | T17-1114 | 1 | 0 | 1 | 0 | 1 | 0
2233 |  | 1000 | B0106001 | 17 | 0 | 17 | 0 | 17 | 0
2258PLPF |  | 500 | M0108001 | 22 | 0 | 22 | 0 | 22 | 0
2282 |  | 500 | M0601001 | 4 | 0 | 4 | 0 | 4 | 0
2364 |  | 300 | M0502001 | 11 | 0 | 11 | 0 | 11 | 0
2427PL |  | 2500 | T18-1114 | 2 | 0 | 2 | 0 | 2 | 0
2454 |  | 2200 | B0509001 | 14.0000000000002 | 0 | 14.0000000000002 | 0 | 14.0000000000002 | 0
2463 |  | 1000 | B0309001 | 17 | 0 | 17 | 0 | 17 | 0
2463PLPF |  | 1000 | B0411001 | 41 | 0 | 41 | 0 | 41 | 0
2472 |  | 1000 | M0402002 | 13 | 0 | 13 | 0 | 13 | 0
2618 |  | 2300 | M0204001 | 24 | 0 | 24 | 0 | 24 | 0
2650 |  | 1200 | T18-1114 | 3.00000000000001 | 0 | 3.00000000000001 | 0 | 3.00000000000001 | 0
2662 |  | 700 | T18-1114 | 3 | 0 | 3 | 0 | 3 | 0
2820 |  | 250 | B2002001 | 9.99999999999998 | 0 | 9.99999999999998 | 0 | 9.99999999999998 | 0
2824 |  | 200 | B1909001 | 35 | 0 | 35 | 0 | 35 | 0
3050 |  | 2000 | B1805001 | 24 | 0 | 24 | 0 | 24 | 0
3208 |  | 1000 | B1712001 | 34 | 0 | 34 | 0 | 34 | 0
3234 |  | 1000 | B2403001 | 6.00000000000004 | 0 | 6.00000000000004 | 0 | 6.00000000000004 | 0
3242 |  | 500 | B1614001 | 9 | 0 | 9 | 0 | 9 | 0
3260 |  | 430 | M1504001 | 10 | 0 | 10 | 0 | 10 | 0
3262 |  | 400 | T09-1999 | 4 | 0 | 4 | 0 | 4 | 0
3269 |  | 150 | B2316001 | 30 | 0 | 30 | 0 | 30 | 0
3278 |  | 125 | T2203001 | 44 | 0 | 44 | 0 | 44 | 0
3282 |  | 500 | B1216001 | -4 | 0 | -4 | 0 | -4 | 45
3286 |  | 560 | B1313002 | 5.99999999999999 | 0 | 5.99999999999999 | 0 | 5.99999999999999 | 16
35.87 |  | 250 | B2206001 | 30 | 0 | 30 | 0 | 30 | 0
365 |  | 480 | B1112001 | 22 | 0 | 22 | 0 | 22 | 0
365LID |  | 900 | T1701114 | 4 | 0 | 4 | 0 | 4 | 0
40C |  | 3800 | T0403001 | 26.9999999999999 | 0 | 26.9999999999999 | 0 | 26.9999999999999 | 0
511934-100 |  | 120 | M0702001 | 23 | 0 | 23 | 0 | 23 | 0
543RPL |  | 400 | T0703114 | 3.99999999999999 | 0 | 3.99999999999999 | 0 | 3.99999999999999 | 0
830420-108 |  | 1000 | B1518001 | 18 | 0 | 18 | 0 | 18 | 0
830570-105 |  | 500 | T1801114 | 5 | 0 | 5 | 0 | 5 | 0
830860-501 |  | 900 | B2104001 | 22 | 0 | 22 | 0 | 22 | 0
850820-100 |  | 800 | B1405002 | 4 | 0 | 4 | 0 | 4 | 0
913CPL |  | 7800 | T18-1114 | 7.105427357601e-15 | 0 | 7.105427357601e-15 | 0 | 7.105427357601e-15 | 0
F63 |  | 4500 | T09-1114 | 7 | 0 | 7 | 0 | 7 | 0
P73 |  | 2000 | M1804001 | 25.0000000000001 | 0 | 25.0000000000001 | 0 | 25.0000000000001 | 0
WN-057 |  | 2000 | B0606001 | 18.9999999999999 | 0 | 18.9999999999999 | 0 | 18.9999999999999 | 0
Inventory Category : 002 - Platters
DS14 |  | 50 | M2203107 | 8.99999999999999 | 0 | 8.99999999999999 | 0 | 8.99999999999999 | 0
DS14C |  | 25 | M2514107 | 26 | 0 | 26 | 0 | 26 | 0
DS14L |  | 50 | M2202107 | 0.999999999999993 | 0 | 0.999999999999993 | 0 | 0.999999999999993 | 0
[NAME] |  | 150 | T14-1107 | 1 | 0 | 1 | 0 | 1 | 0
DS17 |  | 50 | M2202107 | 7.99999999999999 | 0 | 7.99999999999999 | 0 | 7.99999999999999 | 0
DS17C |  | 25 | M2409107 | 13 | 0 | 13 | 0 | 13 | 0
[NAME] |  | 50 | M2202107 | 7.99999999999999 | 0 | 7.99999999999999 | 0 | 7.99999999999999 | 0
DS17P |  | 100 | T1401107 | 2 | 0 | 2 | 0 | 2 | 0
DS2 |  | 300 | M2302107 | 13 | 0 | 13 | 0 | 13 | 0
DS22 |  | 50 | T12-1107 | 3 | 0 | 3 | 0 | 3 | 0
DS22C |  | 25 | T1202107 | 6 | 0 | 6 | 0 | 6 | 0
DS22L |  | 50 | T12-1107 | 2 | 0 | 2 | 0 | 2 | 0
DS2L |  | 300 | M2302107 | 13 | 0 | 13 | 0 | 13 | 0
DS6 |  | 50 | [NAME] | 3 | 0 | 3 | 0 | 3 | 0
DS6L |  | 50 | T14-1107 | 2 | 0 | 2 | 0 | 2 | 0
[NAME] |  | 50 | M2614089 | 34 | 0 | 34 | 0 | 34 | 0
DSPL-B |  | 100 | [NAME] | 1.99999999999999 | 0 | 1.99999999999999 | 0 | 1.99999999999999 | 2
DSPL-C |  | 100 |  | -4 | 0 | -4 | 0 | -4 | 0
DSPLL |  | 100 | [NAME] | 2.00000000000001 | 0 | 2.00000000000001 | 0 | 2.00000000000001 | 2
DSPS-B |  | 100 | [NAME] | 2 | 0 | 2 | 0 | 2 | 1
DSPS-C |  | 100 | T3 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] |  | 100 | [NAME] | 2 | 0 | 2 | 0 | 2 | 1
DSR12 |  | 50 | T15-1107 | 3 | 0 | 3 | 0 | 3 | 0
DSR12L |  | 50 | T15-1107 | 3 | 0 | 3 | 0 | 3 | 0
DSR16 |  | 50 | T15-1107 | 3 | 0 | 3 | 0 | 3 | 0
DSR16L |  | 50 | T15-1107 | 0.999999999999999 | 0 | 0.999999999999999 | 0 | 0.999999999999999 | 0
DSR18 |  | 50 | T15-1107 | 3 | 0 | 3 | 0 | 3 | 0
[NAME] |  | 50 | T15-1107 | 3 | 0 | 3 | 0 | 3 | 0
PP7 |  | 500 | T25-1063 | 4 | 0 | 4 | 0 | 4 | 0
PP9 |  | 500 | T25-1063 | 3 | 0 | 3 | 0 | 3 | 0
Inventory Category : 003 - Salad Containers
DN1100 |  | 600 | M10-1063 | 3.99999999999999 | 0 | 3.99999999999999 | 0 | 3.99999999999999 | 0
DN1200 |  | 750 | M10-1063 | 3.00000000000001 | 0 | 3.00000000000001 | 0 | 3.00000000000001 | 0
DN1300 |  | 450 | M0909063 | 8.00000000000001 | 0 | 8.00000000000001 | 0 | 8.00000000000001 | 4
DN1400 |  | 500 | M1605063 | 8.00000000000002 | 0 | 8.00000000000002 | 0 | 8.00000000000002 | 0
DN1500 |  | 350 | M09-1063 | 4.77395900588817e-15 | 0 | 4.77395900588817e-15 | 0 | 4.77395900588817e-15 | 1
DN1600 |  | 300 | M09-1063 | 1 | 0 | 1 | 0 | 1 | 0
KR500 |  | 300 | T05-1063 | 3 | 0 | 3 | 0 | 3 | 0
KR750 |  | 300 | T05-1063 | 5 | 0 | 5 | 0 | 5 | 0
KRL |  | 300 | T05-1063 | 8 | 0 | 8 | 0 | 8 | 0
[NAME] |  | 400 | B2506092 | -7.105427357601e-15 | 0 | -7.105427357601e-15 | 0 | -7.105427357601e-15 | 12
L8003 |  | 400 | T21-1092 | 2 | 0 | 2 | 0 | 2 | 0
MWB812 |  | 400 | B2507092 | 2.00000000000001 | 0 | 2.00000000000001 | 0 | 2.00000000000001 | 10
V375 |  | 1000 |  | 7.21644966006352e-16 | 0 | 7.21644966006352e-16 | 0 | 7.21644966006352e-16 | 0
V375A |  | 1000 | T0101069 | 1 | 0 | 1 | 0 | 1 | 0
V500 |  | 200 | M1703114 | -1 | 0 | -1 | 0 | -1 | 0
V80B |  | 50 | T2404107 | 12 | 0 | 12 | 0 | 12 | 0
V80BL |  | 50 | T2404107 | 7 | 0 | 7 | 0 | 7 | 0
Inventory Category : 004 - Tamper Evident & Delipots
C400 |  | 500 | M13-1114 | -1 | 0 | -1 | 0 | -1 | 0
[NAME] |  | 1000 | T02-1057 | 5 | 0 | 5 | 0 | 5 | 0
CD121X |  | 1000 | M0305057 | 9 | 0 | 9 | 0 | 9 | 0
CD161X |  | 1000 | T0202057 | 2 | 0 | 2 | 0 | 2 | 0
TEP1000 |  | 240 | M11-1069 | 1 | 0 | 1 | 0 | 1 | 0
TEP180 |  | 768 | M11-1069 | 3 | 0 | 3 | 0 | 3 | 0
TEP280 |  | 744 | M1202069 | 3 | 0 | 3 | 0 | 3 | 1
TEP280RT |  | 500 | M11-1069 | 0 | 0 | 0 | 0 | 0 | 0
TEP375 |  | 696 | M11-1069 | -1 | 0 | -1 | 0 | -1 | 3
TEP520 |  | 575 | M12-1069 | 2 | 0 | 2 | 0 | 2 | 1
TEP670 |  | 462 | M1203069 | 2 | 0 | 2 | 0 | 2 | 1
TEP800 |  | 300 | M1102069 | 4 | 0 | 4 | 0 | 4 | 1
Inventory Category : 005 - Microwave & Oven Containers
2155-1D |  | 600 | T1302069 | 4 | 0 | 4 | 0 | 4 | 1
2187-1G |  | 456 | T1302069 | 4 | 0 | 4 | 0 | 4 | 1
2200-1B |  | 456 | T1303069 | 0 | 0 | 0 | 0 | 0 | 4
2200-1C |  | 464 | T13-1069 | 1 | 0 | 1 | 0 | 1 | 2
2227-1D |  | 360 | T1301069 | 3 | 0 | 3 | 0 | 3 | 1
C1000 |  | 250 | M1402114 | 4 | 0 | 4 | 0 | 4 | 0
C500 |  | 250 | M1302999 | 5 | 0 | 5 | 0 | 5 | 0
C650 |  | 250 | M1404114 | 5 | 0 | 5 | 0 | 5 | 0
J130 |  | 1 | S1E-1069 | 1 | 0 | 1 | 0 | 1 | 0
J140P |  | 1 | S1E-1069 | 1 | 0 | 1 | 0 | 1 | 0
J160 |  | 1 | S1E-1069 | 1 | 0 | 1 | 0 | 1 | 0
J180 |  | 1 | S1E-1069 | 1 | 0 | 1 | 0 | 1 | 0
J180P |  | 1 | S1E-1069 | 2 | 0 | 2 | 0 | 2 | 0
[NAME] |  | 400 | B2606092 | 4.99999999999998 | 0 | 4.99999999999998 | 0 | 4.99999999999998 | 7
MWB516S |  | 500 | T2102107 | 3 | 0 | 3 | 0 | 3 | 0
MWB5LS |  | 500 | T2102107 | 5 | 0 | 5 | 0 | 5 | 0
MWB700 |  | 500 | B25-1092 | 0.999999999999997 | 0 | 0.999999999999997 | 0 | 0.999999999999997 | 0
[NAME] |  | 500 | B25-1092 | 0.999999999999998 | 0 | 0.999999999999998 | 0 | 0.999999999999998 | 0
MWB810 |  | 400 | B2606092 | 5.00000000000001 | 0 | 5.00000000000001 | 0 | 5.00000000000001 | 7
MWB813 |  | 400 | T21-1092 | 2 | 0 | 2 | 0 | 2 | 0
RT12/40B |  | 840 | T1302069 | 3 | 0 | 3 | 0 | 3 | 1
Inventory Category : 006 - Sandwich Packaging
300/150LS |  | 1 | S1D-1069 | 3 | 0 | 3 | 0 | 3 | 1
400-200LS |  | 1 | S1E03069 | 4 | 0 | 4 | 0 | 4 | 1
600-300LS |  | 1 | S1D-1069 | 0 | 0 | 0 | 0 | 0 | 0
700-350LS |  | 1 | S1D-1069 | 1 | 0 | 1 | 0 | 1 | 0
900-450LS |  | 1 | S1D-1069 | 1 | 0 | 1 | 0 | 1 | 0
ES004B-A |  | 1200 | T1006114 | 3 | 0 | 3 | 0 | 3 | 0
F97M |  | 3 | T1001101 | 5 | 0 | 5 | 0 | 5 | 4
HS15/20 |  | 2000 | S5C-1075 | 2 | 0 | 2 | 0 | 2 | 0
HS15/25 |  | 2000 | S5C02075 | 9 | 0 | 9 | 0 | 9 | 0
HS15/35 |  | 2000 | S5D04075 | 4 | 0 | 4 | 0 | 4 | 0
HS20/25 |  | 2000 | S5D02075 | 3 | 0 | 3 | 0 | 3 | 0
HS25/30 |  | 2000 | S5E02075 | 7 | 0 | 7 | 0 | 7 | 0
HS25/35 |  | 2000 | S4C-1075 | 4 | 0 | 4 | 0 | 4 | 0
HS30/40 |  | 2000 | S4C-1075 | 4 | 0 | 4 | 0 | 4 | 0
RB1 |  | 300 | T1004999 | 2 | 0 | 2 | 0 | 2 | 0
SAND-QTR |  | 400 | T11-1114 | 2 | 0 | 2 | 0 | 2 | 0
TR7 |  | 500 | T01-1999 | 1 | 0 | 1 | 0 | 1 | 0
Inventory Category : 007 - Cups & Glasses
412SI |  | 1000 | T0302114 | 2 | 0 | 2 | 0 | 2 | 0
CUPWRAP |  | 2000 | T03-1057 | 7.99360577730113e-15 | 0 | 7.99360577730113e-15 | 0 | 7.99360577730113e-15 | 0
DFR12-C |  | 1000 | T25-1063 | 3 | 0 | 3 | 0 | 3 | 0
ST7 |  | 5000 | S6E-1999 | 2 | 0 | 2 | 0 | 2 | 0
[NAME] |  | 1000 | T03-1999 | 4 | 0 | 4 | 0 | 4 | 0
T900 |  | 800 | T2404063 | -3 | 0 | -3 | 0 | -3 | 6
Inventory Category : 008 - Bags
BBB14H |  | 250 | S5A12075 | 16 | 0 | 16 | 0 | 16 | 0
BBB35H |  | 250 | S5A03075 | 5 | 0 | 5 | 0 | 5 | 0
BBB7H |  | 250 | S5B04075 | 9 | 0 | 9 | 0 | 9 | 0
FF10 |  | 1000 | S5C02075 | 2 | 0 | 2 | 0 | 2 | 0
FF12 |  | 1000 | S5B-1075 | 4 | 0 | 4 | 0 | 4 | 0
FF14 |  | 1000 | S5B-1075 | 2 | 0 | 2 | 0 | 2 | 0
FF7 |  | 1000 | S5C02075 | 3 | 0 | 3 | 0 | 3 | 0
FF85 |  | 1000 | S4E04075 | 5 | 0 | 5 | 0 | 5 | 0
HDPS1418-10MU |  | 1000 |  | 0 | 0 | 0 | 0 | 0 | 0
HDPS1520 |  | 1 |  | 0 | 0 | 0 | 0 | 0 | 0
HDVC1117 |  | 2000 | S1C-1999 | 4 | 0 | 4 | 0 | 4 | 0
HDVC1319 |  | 1000 | S1C-1999 | 3 | 0 | 3 | 0 | 3 | 0
KPB150 |  | 250 | S4E04075 | 18 | 0 | 18 | 0 | 18 | 0
MGW10 |  | 1000 | S1A03075 | 7 | 0 | 7 | 0 | 7 | 0
MGW10-UNSTRUNG |  | 1000 | S1C-1075 | 5 | 0 | 5 | 0 | 5 | 0
MGW125 |  | 500 | S1A05075 | 9 | 0 | 9 | 0 | 9 | 0
MGW5 |  | 1000 | S1A-1075 | 2 | 0 | 2 | 0 | 2 | 0
MGW7 |  | 1000 | S1A02075 | 5 | 0 | 5 | 0 | 5 | 0
OWF-400 |  | 1 | S6B-1108 | 6 | 0 | 6 | 0 | 6 | 0
SILMB |  | 2 | [NAME] | 2 | 0 | 2 | 0 | 2 | 0
Inventory Category : 009 - Compostable & Biodegradable
152W |  | 1000 | S6E-1063 | 0 | 0 | 0 | 0 | 0 | 1
4MKITWDK |  | 500 | S6E-1063 | 1 | 0 | 1 | 0 | 1 | 0
5840W |  | 1000 | S6E02063 | 3 | 0 | 3 | 0 | 3 | 4
5844W |  | 1000 | S6E02063 | 3 | 0 | 3 | 0 | 3 | 4
AD0531 |  | 500 |  | 2 | 0 | 2 | 0 | 2 | 0
BT2 |  | 500 | T25-1063 | 2 | 0 | 2 | 0 | 2 | 2
ECT2 |  | 1000 | T25-1063 | 2 | 0 | 2 | 0 | 2 | 1
ECT3 |  | 500 | T2502063 | 2 | 0 | 2 | 0 | 2 | 5
ES004C-SUN |  | 500 | B1011116 | 31 | 0 | 31 | 0 | 31 | 0
HB2 |  | 250 | M2101063 | 2 | 0 | 2 | 0 | 2 | 2
HB3 |  | 250 | M2003063 | 10 | 0 | 10 | 0 | 10 | 0
HB6 |  | 500 | M1902063 | 8 | 0 | 8 | 0 | 8 | 0
HB8 |  | 250 | M20-1063 | 7 | 0 | 7 | 0 | 7 | 0
HB8/3 |  | 250 | M20-1063 | 1 | 0 | 1 | 0 | 1 | 0
KR8 |  | 500 | T05-1063 | 0 | 0 | 0 | 0 | 0 | 3
KR8L |  | 500 | T05-1063 | 0 | 0 | 0 | 0 | 0 | 3
QSB1 |  | 450 | T20-1999 | 1 | 0 | 1 | 0 | 1 | 0
QSB3 |  | 200 | T2002999 | 3 | 0 | 3 | 0 | 3 | 0
QSB4 |  | 160 | T2002999 | 2 | 0 | 2 | 0 | 2 | 0
QSB8 |  | 300 | T20-1999 | 1 | 0 | 1 | 0 | 1 | 0
TS2K |  | 1000 | T2403116 | 3 | 0 | 3 | 0 | 3 | 0
Inventory Category : 010 - Packing Machines
MTPA |  | 1 | S6C03069 | 2 | 0 | 2 | 0 | 2 | 2
Inventory Category : 011 - Lids
5215 |  | 500 | S3C-1001 | 9 | 0 | 9 | 0 | 9 | 1
5231 |  | 250 | S3AB08001 | 8.99999999999994 | -1 | 7.99999999999994 | 0 | 7.99999999999994 | 10
5251 |  | 1000 | [NAME] | 17 | 0 | 17 | 0 | 17 | 0
5254 |  | 400 | S2B11001 | 7 | 0 | 7 | 0 | 7 | 33
5256 |  | 500 | S4AB-1001 | 51 | 0 | 51 | 0 | 51 | 0
5259 |  | 100 | S4D02001 | 13 | 0 | 13 | 0 | 13 | 0
5261 |  | 500 | S3E15001 | 24 | 0 | 24 | 0 | 24 | 50
830420-300 |  | 1000 | [NAME] | 7 | 0 | 7 | 0 | 7 | 25
830570-309 |  | 500 | S3D-1001 | 7 | 0 | 7 | 0 | 7 | 0
830860-301 |  | 300 | S2CD06001 | 8.00000000000003 | 0 | 8.00000000000003 | 0 | 8.00000000000003 | 0
850820-300 |  | 300 | B1340001 | 12 | 0 | 12 | 0 | 12 | 0
850820-560 |  | 560 | B1310002 | -2 | 0 | -2 | 0 | -2 | 60
Inventory Category : 012 - Cutlery
5844 |  | 1000 | S6E-1114 | -5.99999999999999 | 0 | -5.99999999999999 | 0 | -5.99999999999999 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Net
Inventory Category : 013 - Cleaning Products |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | VAT
6.235V |  | 6 |  | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gross