ch06 - In-Class Assignment (ABC)

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

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

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

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

View Full DocumentRight Arrow Icon
Background image of page 2
Background image of page 3

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

View Full DocumentRight Arrow Icon
Background image of page 4
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

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 Right Arrow Icon
Ask a homework question - tutors are online