The firm produces a line of automotive electrical components. It supplies about 75 auto parts stores. The companys two most profitable products are the automotive front sidelamp and the headlamp. there were too many complaints about late shipments... required information about the side- and headlamps (shown in Tables 1 - 5 and Figure 1)

your answer should consider the following parameters: on-hand inventory level, lead time, safety stocks, and lot-sizing policy with appropriate checking for infeasibility. Though Table 4 shows a standard lot-size as (FOQ), the user should be able to select which lot size policy (such as L4L, POQ, FOQ) to use for any item in the inventory.

Develop MRP explosion model for the two products using the given MPS data provided in Table 2, the current inventory level provided in Table 4 and respond to the following questions/issues:

TABLE 1 Part Numbers and Descriptions C206P 310P HL200E HL211A HL212P HL222P: HL223F SL100E SL111P SL112A: SL113P SL121F SL122A: SL123A: SL131F SL132P SL133F SL134P Screw Back rubber gasket Headlanm Head frame subassem Head lens Headlamp module Head frame Sidelam Side lens Side frame subassembl Side lens rubber gasket Side frame subassembl Side bulb subassembl Flasher bulb subassembl Side cable grommet and r Side bulb subassemb Flasher cable grommet and rece Flasher bulb acle TABLE 2 Master Producton Schedule The following data show the MRP start dates ITEM DESCRIPTION AND PART NUMBER QUANT 100 80 110 120 90 MPS DAT Week 14 Week 16 Week 17 Week 15 Week 16 Sidelamp (SL100E) Headlamp (HL200E) 75 Week 17 TABLE 3 Replacement Part Demand ITEM DESCRIPTION AND PART NUMBER QUANTITY DATE Side lens (SL111P) 40 35 Week 13 Week 16 TABLE 1 Part Numbers and Descriptions C206P 310P HL200E HL211A HL212P HL222P: HL223F SL100E SL111P SL112A: SL113P SL121F SL122A: SL123A: SL131F SL132P SL133F SL134P Screw Back rubber gasket Headlanm Head frame subassem Head lens Headlamp module Head frame Sidelam Side lens Side frame subassembl Side lens rubber gasket Side frame subassembl Side bulb subassembl Flasher bulb subassembl Side cable grommet and r Side bulb subassemb Flasher cable grommet and rece Flasher bulb acle TABLE 2 Master Producton Schedule The following data show the MRP start dates ITEM DESCRIPTION AND PART NUMBER QUANT 100 80 110 120 90 MPS DAT Week 14 Week 16 Week 17 Week 15 Week 16 Sidelamp (SL100E) Headlamp (HL200E) 75 Week 17 TABLE 3 Replacement Part Demand ITEM DESCRIPTION AND PART NUMBER QUANTITY DATE Side lens (SL111P) 40 35 Week 13 Week 16