Visualizing the results of ADA using TableauIllustration 7.6presented the analysis of using clustering as an ADA technique to identify inventory that was at a high risk of notbeing properly valued at the inventory's net realizable value.The information contained in this illustration is presented in an Excel file (Illustration 7.6.xls),

Estimate of How Long It Will Take to Sell Each Decile % of Group of Cost of % of Quantity Quantity Inventory Existing Inventory Sold Inventory Cumulative on Hand on Hand Inventory on Hand Value % 6,954 6,667 10% 349.9 $7,947,064 16.4% 16.4% 9,023 6,682 10% 270.3 $6,334,536 13.1% 29.5% 22,523 6,720 10% 108.9 $5,591,040 11.5% 41.0% 25,047 6,680 10% 97-3 $4,883,080 10.1% 51.1% 29,953 6,703 10% 81.7 $5,536,678 11.4% 62.5% 39,602 6,685 10% 61.6 $4,973,640 10.3% 72.8% 51,500 6,710 10% 47.6 $4,623,190 9.5% 82.3% 58,201 6,690 10% 42.0 $3,652,740 7.5% 89.8% 65,318 6,705 10% 37.5 $3,345,795 6.9% 96.7% 100,385 6,755 10% 24.6 $1,587,425 3.3% 100.0% 408,506 66,997 100% 59.9 $48,475,188 100% Cost of goods sold per unaudited financial statements $232,541,934 Estimated number of days to sell inventory 76.1