A B C D E 1 itemid category location datadate qty F inventory management cost for the year 2345 1 Part Chicago 20201231 1915 $ 2 Part Dallas 20201231 8692 $ 3 Part Detriot 20201231 6173 $ 580,812.44 2,612,063.13 1,886,965.00 4 Part Los Angeles 20201231 8605 $ 6 5 Part Memphis 20201231 1272 $ 7 6 Part New York 20201231 2600 $ 2,670,328.60 366,546.54 799,942.51 8 7 Part San Francisco 20201231 8942 $ 2,798,359.79 9 10 8 Part Memphis 20201231 7868 $ 2,291,957.61 9 Part San Francisco 20201231 249 $ 76,923.27 11 10 Part Memphis 20201231 1785 $ 12 11 Part Memphis 20201231 1150 $ 544,712.79 344,965.24 13 12 Part Dallas 20201231 5772 $ 1,813,328.48 14 13 Part Detriot 20201231 9573 $ 2,750,476.54 15 14 Part Los Angeles 20201231 8750 $ 2,544,620.54 16 15 Part Chicago 20201231 8275 $ 2,515,762.85 17 16 Part Memphis 20201231 4888 $ 1,484,250.25 18 17 Part New York 20201231 3031 $ 958,231.22 19 18 Part San Francisco 20201231 2514 $ 20 19 Part Memphis 20201231 2827 $ 776,323.20 842,670.56 21 20 Part Los Angeles 20201231 8039 $ 2,557,014.13 22 21 Part Memphis 20201231 4233 $ 1,316,315.95 23 22 Part New York 20201231 4297 $ 24 23 Part San Francisco 20201231 1695 $ 25 24 Part Memphis 20201231 4489 $ 26 25 Part Memphis 20201231 857 $ 27 26 Part Chicago 20201231 4077 $ 28 27 Part Dallas 20201231 1962 $ 29 28 Part Detriot 20201231 8879 $ 30 29 Part Los Angeles 20201231 1138 $ 1,317,887.77 509,969.60 1,360,328.26 257,945.75 1,253,127.49 588,043.71 2,546,416.69 349,071.56 31 30 Part Memphis 20201231 5292 $ 1,597,429.47 32 31 Part New York 20201231 8477 $ 2,584,401.60 33 32 Part San Francisco 20201231 8113 $ 2,386,376.79 34 33 Part Memphis 20201231 6704 $ 2,062,749.55 35 34 Part Memphis 20201231 752 $ 36 35 Part Memphis 20201231 6295 $ 37 36 Part Chicago 20201231 8166 $ 38 37 Part Dallas 20201231 1495 $ 39 38 Part Detriot 20201231 9309 $ 40 39 Part Los Angeles 20201231 9434 $ 41 40 Part Memphis 20201231 2736 $ 42 41 Part New York 20201231 5961 $ 226,902.78 1,947,807.33 2,436,688.92 450,706.34 2,955,720.56 2,909,536.53 853,228.18 1.792.424.00