Spreadsheet: 805765d1668897356-if-statements-to-show-expiry-date-values-inventory-reserve-valuation-as-of-103122-copy-if-statements-
Sheet: Detail

 |  |  |  | Exported By: AT
Lot | Lot [NAME] | BoM Inventory | Total Received | [NAME] | Total Adjustments | Cycle Count Exception | Total Shipped | Destruciton Units | [NAME] | Unit Price | Value | [NAME] 100% | Inventory expiring within 6 months @ 75% | Inventory Expiring between 6 to 9 months @ 50% | Inventory Expiring within 1 year @ 25% | Special Reserve | Total Reserve
[NAME] | 2023-01-31 00:00:00 | 22 | 0 |  | 0 | 0 | 0 |  |  | 0
ZLNTA2102A | 2023-01-31 00:00:00 | 5 | 0 |  | 0 | 0 | 0 |  |  | 0
ZLNTA2103A | 2023-01-31 00:00:00 | 7 | 0 |  | 0 | 0 | 0 |  |  | 0
P321016 | 2023-04-30 00:00:00 | 5 | 0 |  | 0 | 0 | 0 |  |  | 75.72861207721631
P321045 | 2023-10-31 00:00:00 |  |  |  |  |  |  |  |  | 75.64229999999999
P321046 | 2023-10-31 00:00:00 |  |  |  |  |  |  |  |  | 73.70457356382978
P321047 | 2023-10-31 00:00:00 |  |  |  |  |  |  |  |  | 73.41626663101603
P321048 | 2023-10-31 00:00:00 |  |  |  |  |  |  |  |  | 73.65352707986109
P321049 | 2023-10-31 00:00:00 |  |  |  |  |  |  |  |  | 74.99980626329787
P321054 | 2023-11-30 00:00:00 |  |  |  |  |  |  |  |  | 73.46085344058642
P321055 | 2023-11-30 00:00:00 |  |  |  |  |  |  |  |  | 77.7792931875
[NAME] | 2023-11-30 00:00:00 |  |  |  |  |  |  |  |  | 74.85551977513228
P321057 | 2023-11-30 00:00:00 |  |  |  |  |  |  |  |  | 75.7429944148936
P321058 | 2023-11-30 00:00:00 |  |  |  |  |  |  |  |  | 73.82319392592593
P322008 | 2024-04-30 00:00:00 |  | 2172 |  | 0 | 0 | 2172 |  |  | 71.18954183931862
P322009 | 2024-04-30 00:00:00 |  | 2100 |  | 0 | 0 | 2100 |  |  | 71.0595619047619
S320018 | 2022-12-31 00:00:00 |  |  |  |  |  |  |  |  | 60.74148834437086
S321007 | 2023-07-31 00:00:00 |  |  |  |  |  |  |  |  | 57.77952764596274
S321008 | 2023-07-31 00:00:00 |  |  |  |  |  |  |  |  | 57.17486008800341
S321010 | 2023-07-31 00:00:00 |  |  |  |  |  |  |  |  | 57.73408535749589
S321011 | 2023-07-31 00:00:00 |  |  |  |  |  |  |  |  | 58.10474541039912
S321012 | 2023-07-31 00:00:00 |  |  |  |  |  |  |  |  | 58.11776902830147
S321013 | 2023-07-31 00:00:00 | 8 | 0 |  | 0 | 0 | 0 |  |  | 58.06602488770504
S321014 | 2024-10-26 00:00:00 |  |  |  |  |  |  |  |  | 59.02103870647286
S321017 | 2023-09-30 00:00:00 | 22 | 0 |  | 0 | 0 | 0 |  |  | 56.73231929515418
S321018 | 2023-09-30 00:00:00 | 12 | 0 |  | 0 | 0 | 0 |  |  | 56.73164958686277
S321019 | 2023-09-30 00:00:00 | 8 | 0 |  | 0 | 0 | 0 |  |  | 56.75152369088209
S321020 | 2023-09-30 00:00:00 | 1 | 0 |  | 0 | 0 | 0 |  |  | 0
S322008 | 2024-03-31 00:00:00 | 7 | 0 |  | 0 | 0 | 0 |  |  | 53.78842915346805
S322009 | 2024-03-31 00:00:00 |  |  |  |  |  |  |  |  | 53.74923092105264
S322010 | 2024-03-31 00:00:00 | 6 | 0 |  | 0 | 0 | 0 |  |  | 54.26021052779902
S322011 | 2024-03-31 00:00:00 |  |  |  |  |  |  |  |  | 54.25632464060404
S322012 | 2024-03-31 00:00:00 |  |  |  |  |  |  |  |  | 54.25034207817286
S322013 | 2024-03-31 00:00:00 | 7 | 0 |  | 0 | 0 | 0 |  |  | 54.27064211426212
S322014 | 2024-03-31 00:00:00 | 4 | 0 |  | 0 | 0 | 0 |  |  | 0
S322015 | 2024-04-30 00:00:00 | 16 | 0 |  | 0 | 0 | 0 |  |  | 52.40084132158589
S322016 | 2024-04-30 00:00:00 | 5 | 0 |  | 0 | 0 | 0 |  |  | 52.32899232367414
S322020 | 2024-06-30 00:00:00 | 60 | 0 |  | 0 | 0 | 48 |  |  | 52.18468
S322021 | 2024-06-30 00:00:00 | 61 | 0 |  | 0 | 0 | 48 |  |  | 52.18468
S322022 | 2024-06-30 00:00:00 | 575 | 0 |  | 0 | 0 | 552 |  |  | 50.88255267142073
S322023 | 2024-06-30 00:00:00 |  | 1821 |  | 0 | 0 | 1728 |  |  | 51.54547997803405
HD2062 | 2022-11-30 00:00:00 | -13 | 0 |  | 0 | 0 | 0 |  |  | 0
HD2105 | 2023-01-31 00:00:00 |  |  |  |  |  |  |  |  | 0
HD2123 | 2023-04-30 00:00:00 | 1 | 0 |  | 0 | 0 | 0 |  |  | 0
HD2131 | 2023-06-30 00:00:00 |  |  |  |  |  |  |  |  | 0
HD2202 | 2023-12-31 00:00:00 | 13 | 0 |  | 0 | 0 | 0 |  |  | 16
HD2203 | 2023-12-31 00:00:00 | 1 | 0 |  | 0 | 0 | 0 |  |  | 16
HD2204 | 2023-12-31 00:00:00 | 1682 | 0 |  | 1 | 0 | 1415 |  |  | 16
HD2208 | 2024-02-29 00:00:00 | 4644 | 0 |  | 0 | 0 | 0 |  |  | 16
HD2209 | 2024-02-29 00:00:00 | 4536 | 0 |  | 0 | 0 | 0 |  |  | 16
HD2009 | 2022-01-30 00:00:00 | -73 | 0 |  | 0 | 0 | 0 |  |  | 0
HD2047 | 2022-07-31 00:00:00 | 12 | 0 |  | 0 | 0 | 0 |  |  | 40
HD2127 | 2023-05-31 00:00:00 | 2 | 0 |  | 0 | 0 | 0 |  |  | 40
HD2129 | 2023-05-31 00:00:00 |  |  |  |  |  |  |  |  | 40
HD2132 | 2023-06-30 00:00:00 | -9 | 0 |  | 0 | 0 | 0 |  |  | 0
HD2133 | 2023-06-30 00:00:00 |  |  |  |  |  |  |  |  | 40
HD2134 | 2023-06-30 00:00:00 |  |  |  |  |  |  |  |  | 40
HD2135 | 2023-07-31 00:00:00 |  |  |  |  |  |  |  |  | 40
HD2136 | 2023-07-31 00:00:00 |  |  |  |  |  |  |  |  | 40
HD2137 | 2023-08-31 00:00:00 |  |  |  |  |  |  |  |  | 40
[NAME] | 2023-08-31 00:00:00 |  |  |  |  |  |  |  |  | 40
HD2139 | 2023-09-30 00:00:00 | 1 | 0 |  | 0 | 0 | 0 |  |  | 40
HD2140 | 2023-10-31 00:00:00 |  |  |  |  |  |  |  |  | 0
HD2141 | 2023-10-31 00:00:00 |  |  |  |  |  |  |  |  | 40
HD2201 | 2023-12-31 00:00:00 |  |  |  |  |  |  |  |  | 40
HD2205 | 2024-01-31 00:00:00 |  |  |  |  |  |  |  |  | 40
HD2206 | 2024-01-31 00:00:00 | 0 | 0 |  | 48 | 0 | 48 |  |  | 40
HD2207 | 2024-01-31 00:00:00 | 9 | 0 |  | 0 | 0 | 0 |  |  | 0
HD2210 | 2024-02-29 00:00:00 | 13 | 0 |  | 4 | 0 | 4 |  |  | 40
HD2211 | 2024-02-29 00:00:00 |  |  |  |  |  |  |  |  | 40
HD2212 | 2024-03-31 00:00:00 | 823 | 0 |  | 2 | 0 | 825 |  |  | 40
HD2213 | 2024-03-31 00:00:00 | 1824 | 0 |  | 0 | -2 | 1798 |  |  | 40
HD2214 | 2024-04-30 00:00:00 | 1824 | 0 |  | 0 | 0 | 178 |  |  | 40
HD2215 | 2024-04-30 00:00:00 | 1824 | 0 |  | 0 | 0 | 0 |  |  | 40
HD2216 | 2024-05-31 00:00:00 | 1835 | 0 |  | 0 | 0 | 0 |  |  | 40
HD2217 | 2024-05-31 00:00:00 | 1863 | 0 |  | 0 | 0 | 0 |  |  | 40
365908 | 2022-05-31 00:00:00 |  |  |  |  |  |  |  |  | 0
376908 | 2023-02-28 00:00:00 | 1447 | 0 |  | 0 | 0 |  | 1447 |  | 0
365918P40 | 2022-05-31 00:00:00 | 263 | 0 |  | 0 | 0 | 0 |  |  | 115.1074773082942
367750P40 | 2022-08-31 00:00:00 | 1722 | 0 |  | 0 | 0 | 0 |  |  | 115.3195239488133
375555P40 | 2023-01-31 00:00:00 |  |  |  |  |  |  |  |  | 119.8157303884795
376908P100 | 2023-02-28 00:00:00 | 0 | 0 |  | 0 | 0 |  |  |  | 295.7015372033115
376908P40 | 2023-02-28 00:00:00 | 53 | 0 |  | 10 | 0 | 0 | 53 |  | 0
380500P40 | 2023-06-30 00:00:00 | 2 | 0 |  | 0 | 0 | 0 |  |  | 121.3686149358541
382554P40 | 2023-08-31 00:00:00 | 144 | 0 |  | 0 | 0 | 138 |  |  | 139.802424573355 |  |  |  |  |  | 629
383768P40 | 2023-11-30 00:00:00 | 432 | 0 |  | 0 | 0 | 0 |  |  | 140.8302272727273
365918P100 | 2022-05-31 00:00:00 | 24 | 0 |  | 0 | 0 | 0 |  |  | 268.7906932707355
367750P100 | 2022-08-31 00:00:00 | 4 | 0 |  | 0 | 0 | 0 |  |  | 288.2965839642119
375555P100 | 2023-01-30 00:00:00 | 1 | 0 |  | 0 | 0 | 0 |  |  | 299.6786923122045
376908 | 2023-02-28 00:00:00 |  |  |  |  |  |  |  |  | 0
376908P100 | 2023-02-28 00:00:00 | 168 | 0 |  | 0 | 0 | 0 | 168 |  | 295.7015372033115
380500P100 | 2023-06-30 00:00:00 | 1 | 0 |  | 0 | 0 | 0 |  |  | 303.4215373396353
382554P100 | 2023-08-31 00:00:00 |  |  |  |  |  |  |  |  | 309.2005888546244
383768P100 | 2025-05-11 00:00:00 | 286 | 0 |  | 0 | 0 | 286 |  |  | 316.2401366341991
366684P100 | 2023-01-31 00:00:00 | 10 | 0 |  | 0 | 0 | 0 |  |  | 55.6014995571302
375079P100 | 2023-08-31 00:00:00 | 6 | 0 |  | 0 | 0 | 0 |  |  | 38.52669619131975
375768P100 | 2023-08-31 00:00:00 |  |  |  |  |  |  |  |  | 0
377561P100 | 2023-10-31 00:00:00 | 686 | 0 |  | 2 | 0 | 476 |  |  | 35.87823685608073
376908 | 2023-02-28 00:00:00 | 0 | 0 |  | 0 | 0 |  |  |  | 0
382157P100 | 2024-08-01 00:00:00 | 1800 | 0 |  | 0 | 0 | 0 |  |  | 37.63269444444445
364034 | 2022-08-31 00:00:00 | 66 | 0 |  | 0 | 0 |  |  |  | 40.97425632098766
364035 | 2022-08-31 00:00:00 | 88 | 0 |  | 0 | 0 |  |  |  | 40.73366340350878
367590P100 | 2023-01-31 00:00:00 |  |  |  |  |  |  |  |  | 40.07884580022962
368337P100 | 2023-01-31 00:00:00 | 582 | 0 |  | 0 | 0 | 0 |  |  | 40.42460020768432
378379P100 | 2023-11-30 00:00:00 |  |  |  |  |  |  |  |  | 41.51505285412262
380001P100 | 2024-01-31 00:00:00 | 263 | 0 |  | 0 | 0 | 218 |  |  | 40.36277196652719
382159P100 | 2024-03-31 00:00:00 | 852 | 0 |  | 0 | 0 | 147 |  |  | 41.46907494145199
364795 | 2022-08-31 00:00:00 | 2 | 0 |  | 0 | 0 |  |  |  | 0
366378P40 | 2022-12-31 00:00:00 | 220 | 0 |  | 0 | 0 | 0 |  |  | 15.98153546216373
368850P40 | 2023-07-31 00:00:00 | 1654 | 0 |  | 0 | -2 | 84 |  |  | 14.50828244796521
364795 | 2022-08-31 00:00:00 | 2 | 0 |  | -1 | 0 |  |  |  | 0
366378P100 | 2022-12-31 00:00:00 | 259 | 0 |  | 0 | 0 | 0 |  |  | 39.95383865540933
368850P100 | 2023-07-31 00:00:00 | 786 | 0 |  | 0 | 0 | 29 |  |  | 36.27070611991302
366222P40 | 2022-12-31 00:00:00 | 264 | 0 |  | 0 | 1 | 0 |  |  | 15.95851325326834
369509P40 | 2023-07-31 00:00:00 | 449 | 0 |  | 0 | 1 | 14 |  |  | 14.72657793388416
366222P100 | 2022-12-31 00:00:00 | 293 | 0 |  | 0 | 0 | 0 |  |  | 39.89628313317085
369509P100 | 2023-07-31 00:00:00 | 548 | 0 |  | 0 | 0 | 17 |  |  | 36.81438913179263
376222P40 | 2023-05-31 00:00:00 | 501 | 0 |  | 0 | 0 | 0 |  |  | 19.68310490693739
384689P40 | 2024-03-31 00:00:00 | 505 | 0 |  | 0 | 0 | 114 |  |  | 20.00528205128205
373928P40 | 2023-05-31 00:00:00 | 305 | 0 |  | 0 | 0 | 0 |  |  | 23.51430010070494
376105P40 | 2023-05-31 00:00:00 | 567 | 0 |  | 0 | 0 | 10 |  |  | 33.11288659793814 |  |  |  |  |  | 348
380288P40 | 2023-11-30 00:00:00 | 1298 | 0 |  | 0 | 0 | 707 |  |  | 22.75422208663819
2061407 | 2023-04-30 00:00:00 | 330 | 0 |  | 0 | 0 |  |  |  | 17.59816914191419
2066911 | 2023-05-31 00:00:00 | 5112 | 0 |  | 0 | 0 |  |  |  | 16.70096011816839 |  |  |  |  |  | 2004
2066958 | 2023-05-31 00:00:00 | 5064 | 0 |  | 0 | 0 |  |  |  | 16.70096011816839
2091725 | 2024-01-31 00:00:00 | 0 | 6696 |  | 0 | 0 | 2688 |  |  | 14.85208930704898
379078P40 | 2023-10-31 00:00:00 |  | 0 |  |  |  |  |  |  | 294.476067961165
384385P40 | 2024-03-31 00:00:00 | 183 | 0 |  | 0 | 0 | 0 |  |  | 297.0014705882353
4550025 | 2024-08-31 00:00:00 |  | 59 |  | 531 | 0 |  |  |  | 162.8135084745763
7466231 | 2024-08-31 00:00:00 |  | 1130 |  | 0 | 0 |  |  |  | 155.2047610619469
 |  | 48885 | 13978 | 0 | 597 | -2 | 15844 | 1668 | 45945