Question: Problem setting: -- Bill of material for A (lead time of 1 week): Part Number Low-level Code Quantity Required Lead Time (weeks) B 1 3
| Problem setting: | ||||||||||||||
| -- Bill of material for A (lead time of 1 week): | ||||||||||||||
| Part Number | Low-level Code | Quantity Required | Lead Time (weeks) | |||||||||||
| B | 1 | 3 | 1 | |||||||||||
| C | 2 | 1 | 1 | |||||||||||
| D | 2 | 1 | 2 | |||||||||||
| D | 2 | 2 | 2 | |||||||||||
| -- Requirement in week 5: | 150 | |||||||||||||
| -- Projected available prior week 1: | ||||||||||||||
| A | 20 | |||||||||||||
| B | 30 | |||||||||||||
| C | 120 | |||||||||||||
| D | 80 | |||||||||||||
| -- Order lot size: no restriction | ||||||||||||||
| Question: | ||||||||||||||
| Complete the following table: | ||||||||||||||
| Low-level Code | Part Number | Week | ||||||||||||
| 1 | 2 | 3 | 4 | 5 | ||||||||||
| 0 | A | Gross Requirements | 150 | |||||||||||
| Scheduled Receipts | ||||||||||||||
| Projected Available | 20 | |||||||||||||
| Net Requirements | ||||||||||||||
| Planned Order Receipt | ||||||||||||||
| Planned Order Release | ||||||||||||||
| 1 | B | Gross Requirements | ||||||||||||
| Scheduled Receipts | ||||||||||||||
| Projected Available | 30 | |||||||||||||
| Net Requirements | ||||||||||||||
| Planned Order Receipt | ||||||||||||||
| Planned Order Release | ||||||||||||||
| 2 | C | Gross Requirements | ||||||||||||
| Scheduled Receipts | ||||||||||||||
| Projected Available | 120 | |||||||||||||
| Net Requirements | ||||||||||||||
| Planned Order Receipt | ||||||||||||||
| Planned Order Release | ||||||||||||||
| 2 | D | Gross Requirements | ||||||||||||
| Scheduled Receipts | ||||||||||||||
| Projected Available | 80 | |||||||||||||
| Net Requirements | ||||||||||||||
| Planned Order Receipt | ||||||||||||||
| Planned Order Release | ||||||||||||||
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
