4.5. Given the following product tree, explode, offset, and determine the gross and net requirements. All lead times are 1 week, and the quantities required are shown in parentheses. The master production schedule calls for 100 As to be available in week 5. There are 20 Bs available. All other on-hand balances = 0.

Part Number

Week

Part Number

Quantity

1

2

3

4

5

B

2

A LT = 1

Gross Requirements

100

D

1

Scheduled Receipts

E

1

Projected Available

0

C

1

Net Requirements

D

2

Planned Order Receipt

F

1

Planned Order Release

B LT = 1

Gross Requirements

Projected available = previous projected available + scheduled receipt + planned order receipt gross requirement

Scheduled Receipts

Net requirements = max(0, gross requirements scheduled receipts previous projected available)

Projected Available

20

The gross requirement of component = the planned order release of parent * number of components per parent

Net Requirements

Planned Order Receipt

Planned Order Release

C LT = 1

Gross Requirements

Scheduled Receipts

Projected Available

0

Net Requirements

Planned Order Receipt

Planned Order Release

D LT = 1

Gross Requirements

Scheduled Receipts

Projected Available

0

Net Requirements

Planned Order Receipt

Planned Order Release

E LT = 1

Gross Requirements

Scheduled Receipts

Projected Available

0

Net Requirements

Planned Order Receipt

Planned Order Release

F LT = 1

Gross Requirements

Scheduled Receipts

Projected Available

0

Net Requirements

Planned Order Receipt

Planned Order Release