a. Develop and complete the material requirement planning to plan the production of the lights and purchases of the socket. . You need to make a total of 3 MRP tables. (15 points) 1 MRP table for VX-1234s. 1 MRP table for BX-1010s 1 MRP table for the light sockets required for VX-1234s and BX-1010s. b. Determine the planned order release for those 3 item

PT Pintu Pintar Utama (PT. PPU) makes special lights that are popular in new homes. PT. PPU demand for two popular lights (VX-1234 and BX-1010) to be the following over the next 12 weeks, as listed in Table 3. Table 3. Demand data 1 2 3 4 8 9 10 12 Week 6 7 90 86 300 275 82 94 78 96 5 105 290 75 88 VX-1234 BX-1010 100 11 110 350 98 334 250 280 301 312 286 310 318 A key component in both lights is a light socket that the bulb is screwed into in the base fixture. Each light has one of these sockets. Given the following information (Table 4). Table 4. Information VX-1234 BX-1010 185 425 Light Socket 620 500 (purchase quantity) 3 325 On Hand Lot Size Lead time (week) Safety Stock On Order 600 1 1 0 10 20 50 (week 5) 150 (week 4)