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

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

View Full Document Right Arrow Icon
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 
Background image of page 1
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

This note was uploaded on 11/24/2010 for the course QUANT DSCI taught by Professor B during the Fall '10 term at Fairleigh Dickinson.

Ask a homework question - tutors are online