Answered step by step
Verified Expert Solution
Question
1 Approved Answer
The provided data file presented the analysis using clustering as an ADA technique to identify inventory that was at a high risk of not being
The provided data file presented the analysis using clustering as an ADA technique to identify inventory that was at a high risk of not being properly valued at the inventorys net realizable value. Using Tableau, develop visualizations to present the client illustrating the potential problems and risks associated with slow-moving inventory.
\begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline Decile & Quantity Sold & Quantity on Hand & % of Inventory on Hand & EstimateofHowLongItWillTaketoSellEachDecileGroupofExistingInventory & Cost of Inventory on Hand & % of Inventory Value & Cumulative % & CostofGoodsSoldperunauditedfinancialstatements & Estimatednumberofdaystosellinventory \\ \hline Decile 1 & 6,954 & 6,667 & 10% & 349.9 & $7,947,064 & 16.40% & 16.40% & $232,541,934 & 76.1 \\ \hline Decile 2 & 9,023 & 6,682 & 10% & 270.3 & $6,334,536 & 13.10% & 29.50% & & \\ \hline Decile 3 & 22,523 & 6,720 & 10% & 108.9 & $5,591,040 & 11.50% & 41.00% & & \\ \hline Decile 4 & 25,047 & 6,680 & 10% & 97.3 & $4,883,080 & 10.10% & 51.10% & & \\ \hline Decile 5 & 29,953 & 6,703 & 10% & 81.7 & $5,536,678 & 11.40% & 62.50% & & \\ \hline Decile 6 & 39,602 & 6,685 & 10% & 61.6 & $4,973,640 & 10.30% & 72.80% & & \\ \hline Decile 7 & 51,500 & 6,710 & 10% & 47.6 & $4,623,190 & 9.50% & 82.30% & & \\ \hline Decile 8 & 58,201 & 6,690 & 10% & 42.0 & $3,652,740 & 7.50% & 89.80% & & \\ \hline Decile 9 & 65,318 & 6,705 & 10% & 37.5 & $3,345,795 & 6.90% & 96.70% & & \\ \hline \multirow[t]{2}{*}{ Decile 10} & 100,385 & 6,755 & 10% & 24.6 & $1,587,425 & 3.30% & 100.00% & & \\ \hline & 408,506 & 66,997 & 100% & 59.9 & $48,475,188 & 100.00% & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|} \hline Decile & Quantity Sold & Quantity on Hand & % of Inventory on Hand & EstimateofHowLongItWillTaketoSellEachDecileGroupofExistingInventory & Cost of Inventory on Hand & % of Inventory Value & Cumulative % & CostofGoodsSoldperunauditedfinancialstatements & Estimatednumberofdaystosellinventory \\ \hline Decile 1 & 6,954 & 6,667 & 10% & 349.9 & $7,947,064 & 16.40% & 16.40% & $232,541,934 & 76.1 \\ \hline Decile 2 & 9,023 & 6,682 & 10% & 270.3 & $6,334,536 & 13.10% & 29.50% & & \\ \hline Decile 3 & 22,523 & 6,720 & 10% & 108.9 & $5,591,040 & 11.50% & 41.00% & & \\ \hline Decile 4 & 25,047 & 6,680 & 10% & 97.3 & $4,883,080 & 10.10% & 51.10% & & \\ \hline Decile 5 & 29,953 & 6,703 & 10% & 81.7 & $5,536,678 & 11.40% & 62.50% & & \\ \hline Decile 6 & 39,602 & 6,685 & 10% & 61.6 & $4,973,640 & 10.30% & 72.80% & & \\ \hline Decile 7 & 51,500 & 6,710 & 10% & 47.6 & $4,623,190 & 9.50% & 82.30% & & \\ \hline Decile 8 & 58,201 & 6,690 & 10% & 42.0 & $3,652,740 & 7.50% & 89.80% & & \\ \hline Decile 9 & 65,318 & 6,705 & 10% & 37.5 & $3,345,795 & 6.90% & 96.70% & & \\ \hline \multirow[t]{2}{*}{ Decile 10} & 100,385 & 6,755 & 10% & 24.6 & $1,587,425 & 3.30% & 100.00% & & \\ \hline & 408,506 & 66,997 & 100% & 59.9 & $48,475,188 & 100.00% & & & \\ \hline \end{tabular}Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started