Spreadsheet: 112099d1308248317-match-data-from-year-1-with-year-2-data-vlookup-inventory
Sheet: Summary_Slob

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Value Report | Value | Dec 09 | 2009
Cat-Div | QOH | Qty sales | Avg Cost | Value on | Annual | 1st Year | Adj | 2nd Year | 3rd Year | Total |  |  |  | Inventory | Obsolescence | Net | [NAME]
 |  | 1 yr |  | hand | usage | usage |  | usage | usage | Reserve |  |  |  | [NAME] | 18 months | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  | A | B | (A - B)
EH-WEB |  |  |  |  | 3197.0745 | 3197.0745 |  | 3197.0745 |  |  |  |  | EH-PRO | 1632 | 1106 |  | 41341
EO-RDC |  |  | 8727.947002630002 | 9242.531002630001 | 0 | 0 | 9242.531002630001 | 0 | 9242.531002630001 |  |  |  | EH-WEB | 95888 | 6986 |  | 136893
ET-CT |  |  | 267.004125 | 534.00825 | 0 | 0 | 534.00825 | 0 | 534.00825 |  |  |  | EO-ROC | 38827 | 27117 |  | 46806
PO-RDC |  |  | 6583.942176953948 | 14674.57333387143 | 978.3623706092802 | 978.3623706092802 | 13696.21096326215 | 978.3623706092802 | 12717.84859265287 |  |  |  | ER-CT | 59730 | 6526 |  | 433691
PO-RDD |  |  | 4568.735018391219 | 9668.98104464025 | 681.7473327160341 | 681.7473327160341 | 8987.233711924213 | 681.7473327160341 | 8305.486379208176 |  |  |  | ES-CT | 285195 |  |  | 529632
PT-COR |  |  | 9183.6787850783 | 18428.9644517433 | 272.414 | 272.414 | 18156.5504517433 | 272.414 | 17884.1364517433 |  |  |  | ET-CT | 201916 | 7376 |  | 1026632
PT-CT |  |  | 61098.36413013647 | 142208.3504086012 | 13355.88693211846 | 13355.88693211846 | 128852.4634764827 | 13355.88693211846 | 115496.5765443643 |  |  |  | EU-CT | 123074 | 11836 |  | 66705
PT-CT2 |  |  | 8957.50151226537 | 29065.44151730099 | 2320.095813748357 | 2320.095813748357 | 26745.34570355264 | 2320.095813748357 | 24425.24988980429 |  |  |  | EU-REN | 180115 | 0 |  | 0
PT-CTL |  |  | 280.786894210646 | 2856.801354672781 | 268.64344760316 | 268.64344760316 | 2588.15790706962 | 268.64344760316 | 2319.514459466461 |  |  |  | EU-MI | 4055 | 750 |  | 559
PT-CTP |  |  | 5602.66493585907 | 12337.9544167406 | 396.332411067933 | 396.332411067933 | 11941.62200567267 | 396.332411067933 | 11545.28959460473 |  |  |  | RENTAL | 370685 | 0 |  | 0
PT-LOC |  |  | 18388.16693754401 | 74384.12380166812 | 4057.580055196381 | 4057.580055196381 | 70326.54374647175 | 4057.580055196381 | 66268.9636912754 |  |  |  | PC-CT | 155004 | 282 |  | 200053
PT-PHG |  |  | 8614.398068613153 | 40630.3784867827 | 4533.291421947899 | 4533.291421947899 | 36097.08706483478 | 4533.291421947899 | 31563.7956428868 |  |  |  | PC-CTS | 13488 | 0 |  | 29348
PT-TK |  |  | 14974.46540944493 | 22425.62730157358 | 26.67 | 26.67 | 22398.95730157358 | 26.67 | 22372.28730157358 |  |  |  | PC-DKN | 80553 | 1529 |  | 152405
RD-RD |  |  | 265.78 | 268.865 | 0 | 0 | 268.865 | 0 | 268.865 |  |  |  | PC-ELE | 27986 | 543 |  | 13103
PR-WEB |  |  | 8497.31804699448 | 11550.8916780291 | 86.3529999998 | 86.3529999998 | 11464.5386780293 | 86.3529999998 | 11378.1856780295 |  |  |  | PC-KLN | 18360 | 18360 |  | 0
PF-FRE |  |  | 10.346 | 113.806 | 0 | 0 | 113.806 | 0 | 113.806 |  |  |  | PC-LOC | 42811 | 0 |  | 44081
PC-CT |  |  | 13235.0485256283 | 54028.23002284488 | 4941.28113144941 | 4941.28113144941 | 49086.94889139545 | 4941.28113144941 | 44145.66775994607 |  |  |  | PC-MHI | 93208 | 28085 |  | 28085
PC-DKN |  |  | 15963.14437185815 | 30053.62069665581 | 615.90209524562 | 615.90209524562 | 29437.71860141018 | 615.90209524562 | 28821.81650616456 |  |  |  | PC-MSP | 7614 | 7614 |  | 0
PC-ELE |  |  | 8727.465428910999 | 19131.242060161 | 413.157 | 413.157 | 18718.085060161 | 413.157 | 18304.928060161 |  |  |  | PC-SEA | 3421 | 3421 |  | 0
PC-KLN |  |  | 3765.92725 | 8106.648250000002 | 0 | 0 | 8106.648250000002 | 0 | 8106.648250000002 |  |  |  | PC-TK | 45867 | 0 |  | 8779
PC-LOC |  |  | 1648.897970960231 | 17828.72618786501 | 265.739696347776 | 265.739696347776 | 17562.98649151725 | 265.739696347776 | 17297.24679516947 |  |  |  | PC-TKS | 15151 | 0 |  | 4933
PC-MHI |  |  | 22096.91652253575 | 57567.36638065084 | 460.3144990667101 | 460.3144990667101 | 57107.05188158411 | 460.3144990667101 | 56646.7373825174 |  |  |  | PF-FRE | 120188 | 0 |  | 76345
PC-MSP |  |  | 1626.07894444 | 1626.07894444 | 0 | 0 | 1626.07894444 | 0 | 1626.07894444 |  |  |  | PO-ARA | 5340 | 1602 |  | 826
PC-SEA |  |  | 2080.219999999999 | 2188.809999999999 | 0 | 0 | 2188.809999999999 | 0 | 2188.809999999999 |  |  |  | PO-DH | 1319 | 229 |  | 12164
PC-STC |  |  | 906.412 | 1149.213 | 0 | 0 | 1149.213 | 0 | 1149.213 |  |  |  | PO-KAT | 18127 | 5921 |  | 24144
PC-TK |  |  | 11999.67580477754 | 36210.4058868701 | 1904.42623494627 | 1904.42623494627 | 34305.97965192384 | 1904.42623494627 | 32401.55341697757 |  |  |  | PO-KYS | 13915 | 2906 |  | 11623
PC-TKS |  |  | 4127.597 | 5843.608000000001 | 0 | 0 | 5843.608000000001 | 0 | 5843.608000000001 |  |  |  | PO-ROC | 53983 | 1859 |  | 56214
PO-ARA |  |  | 2553.58173196496 | 3965.136187281391 | 0 | 0 | 3965.136187281391 | 0 | 3965.136187281391 |  |  |  | PO-ROD | 38566 | 899 |  | 55066
PO-DH |  |  | 36.53 | 90.71000000000001 | 0 | 0 | 90.71000000000001 | 0 | 90.71000000000001 |  |  |  | PO-PDP | 197 | 0 |  | 196
PO-KAT |  |  | 5606.734648705509 | 9563.45774031862 | 0 | 0 | 9563.45774031862 | 0 | 9563.45774031862 |  |  |  | PR-AF | 7493 | 0 |  | 2702
PO-KYS |  |  | 6751.864226617591 | 8395.70748739394 | 0 | 0 | 8395.70748739394 | 0 | 8395.70748739394 |  |  |  | PR-PRO | 54270 | 1526 |  | 67440
PR-AF |  |  | 1441.741141267 | 4417.598288129 | 8.454 | 8.454 | 4409.144288129 | 8.454 | 4400.690288129 |  |  |  | PR-RIG | 122 | 122 |  | 0
PR-PRO |  |  | 9691.361722722375 | 28341.00070832982 | 1392.24645454546 | 1392.24645454546 | 26948.75425378435 | 1392.24645454546 | 25556.50779923889 |  |  |  | PR-WEB | 35137 | 4830 |  | 65460
PT-BHC |  |  | 325.31745763 | 797.8303490699999 | 0 | 0 | 797.8303490699999 | 0 | 797.8303490699999 |  |  |  | PT-BHC | 810 | 0 |  | 28
PT-REB |  |  | 11802.6795 | 14987.8615 | 0 | 0 | 14987.8615 | 0 | 14987.8615 |  |  |  | PT-BOD | 149 | 0 |  | 0
PT-TC |  |  | 35.86240800001 | 35.86240800001 | 0 | 0 | 35.86240800001 | 0 | 35.86240800001 |  |  |  | PT-COR | -1825 | 1700 |  | 0
PT-TKP |  |  | 14.214 | 85.284 | 0 | 0 | 85.284 | 0 | 85.284 |  |  |  | PT-CT | 333648 | 40510 |  | 817415
 |  |  |  |  |  |  |  |  |  |  |  |  | PT-CT2 | 59085 | 664 |  | 55401
 |  |  |  |  |  |  |  |  |  |  |  |  | PT-CTL | 3011 | 125 |  | 3477
 |  |  |  |  |  |  |  |  |  |  |  |  | PT-CTP | 23380 | 521 |  | 13758
 |  |  |  |  |  |  |  |  |  |  |  |  | PT-ITW | 4065 | 1115 |  | 12247
 |  |  |  |  |  |  |  |  |  |  |  |  | PT-LOC | 122093 | 3816 |  | 142702
 |  |  |  |  |  |  |  |  |  |  |  |  | PT-PHG | 91150 | 25 |  | 139375
 |  |  |  |  |  |  |  |  |  |  |  |  | PT-REB | 15778 | 1881 |  | 19681
 |  |  |  |  |  |  |  |  |  |  |  |  | PT-TK | 58182 | 890 |  | 5751
 |  |  |  |  |  |  |  |  |  |  |  |  | PT-TKP | 100 | 100 |  | 0