5. Consider a common stapler, the BOM for which is given in the figure below. STAPLER Base Assembly Top Jaw Bottom Jaw Top Assembly Pin Spring Assembly Base Base Jaw plate Molding Support Stake Rivet Tension Plate Pin Copper Spring Slide Pin Slide Housing Top Plate Top cover Locator Plate Stake Rivet The MPS record calls for releasing PORs for 1000 staplers a week for the next three weeks, 500 staplers in the fourth and fifth week followed by a POR for 1500 staplers in the sixth week. Do a detailed MRP explosion and prepare the MRP records that determine the planned order releases for all items in the stapler's BOM over the planning horizon. The current time is the start of week 1. Relevant information pertaining to current on-hand 2 inventory, outstanding orders (scheduled receipts), along with when they are due to arrive, and lead times to acquire (produce) for each item are given in Table 1. All items follow a Lot-For-Lot (LFL) ordering policy, except the Pin (1135-42-50) and the Slide Pin (1135-42-60-28) which are ordered in lot sizes of 1400 and 850 respectively. There is no safety stock requirement. Table 1: Status at beginning of Week 1 Level Item ID Item Description OH inventory Scheduled receipts Due to Lead time arrive (weeks) (week no) 0 398 1 1 1135-42 Stapler 4.2" 1135-42-10 Base Assembly 1135-42-10-81 Base Plate 852 535 1 1 2 750 1200 2 2 2 780 980, 450 2, 3 3 1135-42-10-93 Base Molding 1135-42-10-84 Jaw Support 2 885 1 2 8142-09 Stake Rivet 3012 1 2 1296-11 Tension Plate 750 1 1 1135-42-20 Top Jaw 1080 1000 2 2 1 1135-42-30 Bottom Jaw 580 1200, 800, 650* 1, 2, 3* 3 1 1212 2 700 550 1 1 2 850 1 2 600 1200 1 2. 1, 2 1135-42-40 Top Assembly 1135-42-40-11 Top Plate 1135-42-40-17 Top Cover 1135-42-40-19 Locator Plate 1135-42-50 Pin 1135-42-60 Spring 1135-42-60-18 Copper Spring 1135-42-60-28 Slide Pin 1135-42-60-33 Slide Housing 366 1 1 1150 80 1 2 950 1 2 558 650 1 1 2 1213 1 #980 and 450 units are due to arrive in weeks 2 and 3 respectively. *1200, 800 and 600 units are due to arrive in weeks 1, 2 and 3 respectively