for this problem, provide the MRP schedule only for items A, B, D, and E

23. Figure 11.42 illustrates the BOM for product A. The MPS start row in the MPS for product A calls for 50 units in week 2, 65 units in week 5, and 80 units in week 8. Item C is produced to make A and to meet the forecasted demand for replacement parts. Past replacement part demand has been 20 units per week (add 20 units to Cs gross requirements). The lead times for items F and C are 1 week, and for the other items the lead time is 2 weeks. No safety stock is required for items B, C, D, E, and F. The L4L lot-sizing rule is used for items B and F; the POQ lot-sizing rule (P = 2) is used for C. Item E has an FOQ of 600 units, and D has an FOQ of 250 units. On-hand inventories are 50 units of B, 50 units of C, 120 units of D, 70 units of E, and 250 units of F. Item B has a scheduled receipt of 50 units in week 2. Develop a material requirements plan for the next 8 weeks for items B, C, D, E, and F.

Questions:

1) How to Calculate A table?

2) How are the numbers in B,D,E calculated?

A B (2) C (1) D (2) E (2) F (1) ) F (2) E (1) A FIGURE 11.42 BOM for Product A L4L 2 weeks 7 3 4 Lot Size: Lead Time: 5 6 130 2 100 50 0 Item: B Description: Week Gross requirements Scheduled receipts Projected on hand Planned receipts Planned order releases 8 160 50 50 0 0 0 0 0 130 0 160 130 160 Lot Size: Lead Time: 5 6 130 FOQ = 250 2 weeks 7 8 160 1 3 2 100 120 120 20 20 20 140 230 250 250 Item: D Description: Week Gross requirements Scheduled receipts Projected on hand Planned receipts Planned order releases Item: E Description: Week Gross requirements Scheduled receipts Projected on hand Planned receipts Planned order releases 140 140 250 250 Lot Size: Lead Time: 5 6 570 FOQ = 600 2 weeks 7 8 2 4 3 510 70 70 70 160 160 190 190 160 600 190 600 600 600