{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

# CH12Ex1 - 00.52 99.35 C 8 01036 8.5 100 \$850.00 8 01036 8.5...

This preview shows page 1. Sign up to view the full content.

CHAPTER 12: Example 1 Inventory ABC Analysis Data Results - sorted by dollar volume Item Unit Cost Volume Dollar volume Item Volume Unit Cost Dollar Volume Category 1 10286 90 1000  \$90,000.00  1 10286 90 1000  \$90,000.00  38.78% 38.78% A 2 11526 154 500  \$77,000.00  2 11526 154 500  \$77,000.00  33.18% 71.97% A 3 12760 17 1550  \$26,350.00  3 12760 17 1550  \$26,350.00  11.35% 83.32% B 4 10867 42.86 350  \$15,001.00  4 10867 42.86 350  \$15,001.00  06.46% 89.78% B 5 10500 12.5 1000  \$12,500.00  5 10500 12.5 1000  \$12,500.00  05.39% 95.17% B 6 12572 14.17 600  \$8,502.00  6 12572 14.17 600  \$8,502.00  03.66% 98.83% C 7 14075 0.6 2000  \$1,200.00  7 14075 0.6 2000  \$1,200.00
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 00.52% 99.35% C 8 01036 8.5 100 \$850.00 8 01036 8.5 100 \$850.00 00.37% 99.72% C 9 01307 0.42 1200 \$504.00 9 01307 0.42 1200 \$504.00 00.22% 99.94% C 10 10572 0.6 250 \$150.00 10 10572 0.6 250 \$150.00 00.06% 100.00% C Total \$232,057.00 Dollar Volume Rank Dollar Volume Rank Percent of Dollar Volume Cum Percent of Dollar Volume Enter the unit costs and the unit volumes into the shaded data area. NOTE: The dollar volume in column F (but not in column L) is adjusted to prevent ties....
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online