Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribed \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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Principles Of Auditing And Other Assurance Services

Authors: Ray Whittington, Kurt Pany

13th Edition

007232726X, 9780072327267

More Books

Students also viewed these Accounting questions

Question

=+ Interviews with key people. Which people?

Answered: 1 week ago

Question

=+ Judgmental assessment: personal experience or outside experts?

Answered: 1 week ago

Question

=+ On what criteria should the program be judged? 9

Answered: 1 week ago