Assume that you are the manager of a shop that assembles powertools. You have just received an order for 50 chain saws, which areto be shipped at the start of week 8. Pertinent information on thesaws is
| Item | | Lead Time (weeks) | | On Hand | | Components |
| Saw | | 2 | | 15 | | A(2), B(1), C(4) |
| A | | 1 | | 10 | | E(3), D(1) |
| B | | 2 | | 5 | | D(2), F(3) |
| C | | 2 | | 65 | | E(2), D(2) |
| D | | 1 | | 20 | | |
| E | | 1 | | 10 | | |
| F | | 2 | | 30 | | |
|
b. Develop the material requirements plan forcomponent E using lot-for-lot ordering. (Leave no cellsblank - be certain to enter \"0\" wherever required.)
| Item: E(3) & E(2) LT = 1 wk. | Beg. Inv. | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |
| Gross requirements | | | | | | | | | |
| Scheduled receipts | | | | | | | | | |
| Projected on hand | | | | | | | | | |
| Net requirements | | | | | | | | | |
| Planned order receipt | | | | | | | | | |
| Planned order release | | | | | | | | | |
|
Please help me super confused on this problem
