Question: Visualizing the results of ADA using Tableau screen shot below is presented the analysis of using clustering as an ADA technique to identify inventory that

Visualizing the results of ADA using Tableauscreen shot below is presented 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

Visualizing the results of ADA using Tableauscreen shot below is presented the

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

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!