Please Answer the question below :

PT Pijar Pijar 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 Week 1 2 3 4 5 6 7 8 g 10 11 12 VX-1234 87 94 78 96 105 86 75 38 98 110 100 BX-1010 250 280 301 312 290 300 275 286 310 334 350 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 Light Socket On Hand 185 125 20 Lot Size 325 600 500 (purchase quantity) Lead time ( week) 1 1 3 Safety Stock 0 10 20 On Order 50 (week 5) 150 (week 4) a. Develop and complete the material requirement planning to plan the production of the lights and purchases of the socket. Refer to Exhibit 21.12 on page 570. 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 items (10 points)