Supply chain management

profileRust99
ABCcopia.xls
Home>Business & Finance homework help>Management homework help>Supply chain management

ORIGINAL

COMPONENT COST YEARLY DEMAND T.A.C.
A 100 70 7,000
AA 0.3 100 30
B 2 200 400
BB 0.2 200 40
C 40 130 5,200
CC 0.2 400 80
D 1.5 200 300
DD 0.1 1000 100
E 2 700 1,400
EE 0.15 160 24
F 2 100 200
FF 0.3 1300 390
G 80 150 12,000
H 3 700 2,100
I 4 100 400
J 2 200 400
K 2 60 120
L 1 1500 1,500
M 2 200 400
N 1 500 500
O 32 150 4,800
P 90 100 9,000
Q 1 300 300
R 18 70 1,260
S 60 20 1,200
T 5 50 250
U 2 200 400
V 3 100 300
W 0.5 300 150
X 1 200 200
Y 0.5 130 65
Z 0.3 100 30
50,539.0

ORDER

COMPONENT COST YEARLY DEMAND T.A.C.
G 80 150 12,000
P 90 100 9,000
A 100 70 7,000
C 40 130 5,200
O 32 150 4,800
H 3 700 2,100
L 1 1500 1,500
E 2 700 1,400
R 18 70 1,260
S 60 20 1,200
N 1 500 500
B 2 200 400
I 4 100 400
J 2 200 400
M 2 200 400
U 2 200 400
FF 0.3 1300 390
D 1.5 200 300
Q 1 300 300
V 3 100 300
T 5 50 250
F 2 100 200
X 1 200 200
W 0.5 300 150
K 2 60 120
DD 0.1 1000 100
CC 0.2 400 80
Y 0.5 130 65
BB 0.2 200 40
AA 0.3 100 30
Z 0.3 100 30
EE 0.15 160 24
50,539.0

ABC

COMPONENT COST YEARLY DEMAND T.A.C.
G 80 150 12,000
P 90 100 9,000
A 100 70 7,000
C 40 130 5,200
O 32 150 4,800
H 3 700 2,100
L 1 1500 1,500
E 2 700 1,400
R 18 70 1,260 GROUP % COMPONENTS % TAC
S 60 20 1,200 A 20 80
N 1 500 500 B 12 10
B 2 200 400 C 68 10
I 4 100 400
J 2 200 400
M 2 200 400
U 2 200 400
FF 0.3 1300 390
D 1.5 200 300
Q 1 300 300
V 3 100 300
T 5 50 250
F 2 100 200
X 1 200 200
W 0.5 300 150
K 2 60 120
DD 0.1 1000 100
CC 0.2 400 80
Y 0.5 130 65
BB 0.2 200 40
AA 0.3 100 30
Z 0.3 100 30
EE 0.15 160 24
50,539.0

INV. STRATEGY

COMPONENT COST YEARLY DEMAND T.A.C.
G 80 150 12,000
P 90 100 9,000
A 100 70 7,000 INVENTORY STRATEGY
C 40 130 5,200 SAFETY STOCK
O 32 150 4,800
H 3 700 2,100 GROUP MONTHLY COST MONTHS S.S. COST
L 1 1500 1,500 A 3342 2 6683
E 2 700 1,400 B 447 2 893
R 18 70 1,260 C 423 2 847
S 60 20 1,200 8423
N 1 500 500
B 2 200 400
I 4 100 400
J 2 200 400
M 2 200 400
U 2 200 400
FF 0.3 1300 390
D 1.5 200 300
Q 1 300 300
V 3 100 300
T 5 50 250
F 2 100 200
X 1 200 200
W 0.5 300 150
K 2 60 120
DD 0.1 1000 100
CC 0.2 400 80
Y 0.5 130 65
BB 0.2 200 40
AA 0.3 100 30
Z 0.3 100 30
EE 0.15 160 24
50,539.0