Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The table below contains supply chain data for a batch of parts from a warehouse. They need to be classified into three buckets: High Sales

image text in transcribed
The table below contains supply chain data for a batch of parts from a warehouse. They need to be classified into three buckets: High Sales Value (A), Medium Sales Value (B), and Low Sales Value (C). Generate a pareto chart with SKU as the x-axis label and $ as the y-axis (you are not defining a bin size). Include a second y-axis that shows cumulative % of sales. Use the pareto chart and % of sales to determine the A/B/C classification Class Stock-keeping unit Annual Sales Cumulative % of Cumulative % of (SKU) (8) SKUS Sales J-625 $904,366 4.17% 15.8% Z-454 $838,481 8.33% 30.4% W-681 $757,060 12.50% 43.6% J-909 $635,764 16.67% 54.7% T-988 $596,075 20.83% 65.1% B-570 S482,492 25.00% 73.5% M-117 $390,553 29.17% 80.3% H-033 $262,363 33.33% 84.9% W-998 $212,713 37.50% 88.6% C-841 $151,413 41.67% 91.2% R-596 $125,234 45.83% 93.4% Y-764 $81,392 50.00% 94.8% F-496 $48,131 54.17% 95.7% M-154 $37,409 58.33% 96.3% M-615 $30,011 62.50% 96.8% A-620 $29,830 66.67% 97.4% K-388 $27,592 70.83% 97.8% B-237 $24,633 75.00% 98.3% K-778 $22,551 79.17% 98.7% Y-319 $19,836 83.33% 99.0% T-670 $16,058 87.50% 99.3% S-802 $14,996 91.67% 99.6% T-172 $10,106 95.83% 99.7% G-676 $8,783 100.00% 99.9% M-687 $6,624 104.17% 100.0%

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

More Books

Students also viewed these Accounting questions

Question

4. Describe the role of narratives in constructing history.

Answered: 1 week ago

Question

1. Identify six different types of history.

Answered: 1 week ago