answer the question briefly

tof MATERIAL REQUIREMENT PLANNING (FROM MRP TO ERP) Philips Lighting makes special lights that are popular in new homes. Philips expects demand for two popular lights to be the following over the next eight weeks. W-1 W-2 W-3 W-4 W-5 W-6 W-7 W-8 estion 4W 43 35 33 26 E27 48 32 56 31 120 9W E27 108 135 122 147 156 168 129 A key component in both lights is a socket that the bulb is screwed into the base fixture. Each light has one of these sockets. Given the following information, plan the production of the lights and purchases of the socket. 4W E27 9W E27 LIGHT SOCKET ON HAND 67 437 454 Q 150(Production 350(Production 500(Purchase Lot) Lot) Qty) 1 Week 1 Week 3 Weeks LEAD TIME SAFETY STOCK OUnits 25Units 30Units Provide a materials requirements plan that defines the number of units of each component and when they will be needed