ch06 - In-Class Assignment (ABC)

# ch06 - In-Class Assignment (ABC) - cumulative ABC Item Cost...

This preview shows pages 1–4. Sign up to view the full content.

OPERATIONS MANAGEMENT I ABC analysis problem #2 pg 196. Perform an ABC analysis on the following inventory items. Annual Unit Annual \$ % of annual Items % of annual cumulative ABC Item Demand Cost Volume \$ volume Reclassified \$ volume percent Classification A2 3000 \$50 \$150,000 13.79% G2 41.38% 41.38% A B8 4000 \$12 \$48,000 4.41% F3 22.99% 64.37% A C7 1500 \$45 \$67,500 6.21% A2 13.79% 78.16% A D1 6000 \$10 \$60,000 5.52% C7 6.21% 84.37% B E9 1000 \$20 \$20,000 1.84% D1 5.52% 89.89% B F3 500 \$500 \$250,000 22.99% B8 4.41% 94.30% B G2 300 \$1,500 \$450,000 41.38% E9 1.84% 96.14% C H2 600 \$20 \$12,000 1.10% I5 1.61% 97.75% C I5 1750 \$10 \$17,500 1.61% J8 1.15% 98.90% C J8 2500 \$5 \$12,500 1.15% H2 1.10% 100.00% C \$1,087,500 In-class work : perform an ABC analysis on the following… Unit Annual \$ % of annual Items % of annual

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: cumulative ABC Item Cost Demand Volume \$ volume Reclassified \$ volume percent Classification E102 \$4.00 800 \$3,200 8.94% D23 26.82% 26.82% A D23 \$8.00 1200 \$9,600 26.82% V75 16.76% 43.58% A D27 \$3.00 700 \$2,100 5.87% U11 15.64% 59.22% A R02 \$2.00 1000 \$2,000 5.59% E102 8.94% 68.16% A R19 \$8.00 200 \$1,600 4.47% S107 8.38% 76.54% A S107 \$6.00 500 \$3,000 8.38% D27 5.87% 82.40% B S123 \$1.00 1200 \$1,200 3.35% R02 5.59% 87.99% B U11 \$7.00 800 \$5,600 15.64% R19 4.47% 92.46% B U23 \$1.00 1500 \$1,500 4.19% U23 4.19% 96.65% C V75 \$4.00 1500 \$6,000 16.76% S123 3.35% 100.00% C \$35,800 ....
View Full Document

• Fall '05
• RobShepherd
• Following, Christopher Nolan, cumulative ABC Volume, annual cumulative ABC, volume percent Classification

{[ snackBarMessage ]}

### Page1 / 4

ch06 - In-Class Assignment (ABC) - cumulative ABC Item Cost...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online