Question

Complete the following table. Lead time for the part is 2 weeks. The lot size is 50.

What is the projected available at the end of the week?

When is it planned to release the order?

Week 1 2 3 4
Gross Requirement 30 25 10 10
Scheduled Receipts 50
Projected Avalible 10
Net Requirements
Planned Order Receipt
Planned Order Release

Answer 1

At the end of Week 3, the projected available inventory is 10 units, meeting the gross requirements. No additional planned order is needed due to the net requirements being zero.

To fill in the missing values:

1. Week 3 Projected Available:

`\[ \text{Projected Available} = \text{Scheduled Receipts from Week 2} + \text{Projected Available from Week 2} \] \[ \text{Projected Available Week 3} = 0 + 10 = 10 \]`

2. Week 3 Net Requirements:

`\[ \text{Net Requirements} = \text{Gross Requirements} - \text{Projected Available} \] \[ \text{Net Requirements Week 3} = 10 - 10 = 0 \]`

3. Week 3 Planned Order Receipt:

Since there are no net requirements in Week 3, no planned order is needed.

4. Week 3 Planned Order Release:

If the net requirements are greater than zero, a planned order release is needed. However, since the net requirements are zero in Week 3, no planned order release is necessary.

The completed table is:

(attached)

So, at the end of Week 3, the projected available is 10 units, and no additional planned order is required.

The complete question is:

Complete the following table. The lead time for the part is 2 weeks. The lot size is 50. What is the project available at the end of the week 3? When is it planned to release an order?

Week 1 2 3 4

Gross Requirements 30 25 10 10

Scheduled Receipts 50

Projected Available 10

Net Requirements

Planned Order Receipt

Planned Order Release