[go: up one dir, main page]
Scribd
Upload
76 views6 pages

Inventory Management Data

The document summarizes inventory information for various components (A, Q, B, C, D, E) with on-hand inventory levels, lot sizes, lead times, and safety stock. It notes that component A has an order for 103 units in period 8 and Q has an order for 200 units in period 7. Lot-for-lot ordering is used except for D and E, which have lot sizes of 200 and 500 units respectively.

Uploaded by

Amit Admune
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
76 views6 pages

Inventory Management Data

The document summarizes inventory information for various components (A, Q, B, C, D, E) with on-hand inventory levels, lot sizes, lead times, and safety stock. It notes that component A has an order for 103 units in period 8 and Q has an order for 200 units in period 7. Lot-for-lot ordering is used except for D and E, which have lot sizes of 200 and 500 units respectively.

Uploaded by

Amit Admune
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 6

A

LT=4

ORDER FOR A=103units at period 8 and Q=200 units at


period 7 B(1) C(2)
safety stock maintained for A is 5units and Q is 6units
LT=3 LT=2
there is no safety stock on other componet
the lot size for A,Q,B,C is lot-for-lot ordering
where lot size for D is 200 units and E is 500units
10 of 18units on hand of product A is allocated
D(1) E(2)
LT=1 LT=1
on-hand inventory
A 18
Q 6
B 10
C 20
D 0
E 30

lot size lead time on hand safety stockallocated low level c item

1 4 18 5 10 0A

lot size lead time on hand safety stockallocated low level c item

1 2 6 6 0 0Q

lot size lead time on hand safety stockallocated low level c item
1 3 10 0 0 1B

lot size lead time on hand safety stockallocated low level c item

1 2 20 0 0 1C

lot size lead time on hand safety stockallocated low level c item

200 1 0 0 0 2D

lot size lead time on hand safety stockallocated low level c item

500 1 30 0 0 2E
Q
LT=2

C(1) E(2)
LT=2 LT=1

2) D(1) E(2)
=1 LT=1 LT=1

period
PD 1 2 3 4 5 6

Gross requiremnets
Schedule receipt
projected-on-hand 3 3 3 3 3 3 3
Net requiremnets
planned order receipts
planned order releases 100

period
PD 1 2 3 4 5 6

Gross requiremnets
Schedule receipt
projected-on-hand 0 0 0 0 0 0 0
Net requiremnets
planned order receipts
planned order releases 200

period
PD 1 2 3 4 5 6
Gross requiremnets 100
Schedule receipt
projected-on-hand 10 10 10 10 0
Net requiremnets 90
planned order receipts 90
planned order releases 90

period
PD 1 2 3 4 5 6

Gross requiremnets 200 200


Schedule receipt
projected-on-hand 20 20 20 20 0 0
Net requiremnets 180 200
planned order receipts 180 200
planned order releases 180 200

period
PD 1 2 3 4 5 6

Gross requiremnets 180 200


Schedule receipt
projected-on-hand 0 0 20 20
Net requiremnets 180 180
planned order receipts 200 200
planned order releases 200 200

period
PD 1 2 3 4 5 6

Gross requiremnets 360 400 400


Schedule receipt
projected-on-hand 30 30 170 270 270 370 370
Net requiremnets 330 230 130
planned order receipts 500 500 500
planned order releases 500 500 500
7 8

103

3 0
100
100

7 8

200

0
200
200

7 8
7 8

7 8

7 8

370 370

You might also like