Problem $14-14($Static$)$

Given the BOM and the MPS for end item A$,$ complete the MRP schedule for items A$,$ C$,$ D$,$ and E$.$

Note: Leave no cells blank $-$ be certain to enter $"0"$ wherever required.

In the BOM, at the top is A$,1$ week. Below it we have the following three. B $(1),3$ weeks. C $(4),1$ week. D $(2),2$ weeks. Below C $(4),1$ week are the following two. E $(2),1$ week. F $(6),2$ weeks. Below D $(2),2$ weeks are the following three. E $(4),1$ week. G $(4),1$ week. H $(1),3$ weeks.

MPS

Item $12345678$

A: $602050120100508040$

Click here for the Excel Data File

Item A C D E

Lot size rule L$4$L L$4$L L$4$L Multiples FOQ $=500$

Safety stock $000100$

Beginning inventory $000300$

Week $1$ scheduled receipts $6080401,500$