complete in excell format

cuments Planned receipts Planned orders 11. (**) Republic Tool and Manufactur e lool and Manufacturing Company of Carlsbad, California, makes a wide variety of care products. One of Republic's products is the Model Number 540 Broadcast Spreader: Broadcast spreader kit Hopper Cotter Frame assembly Gear & rotor plate assembly Wheels pin *2 needed U-frame legs plate pin Frame Drive Rotor Cotter gear *2 needed Complete the following MRP records. Note the following: Republic intends to start assembling 2,000 broadcast spreader kits in weeks 2, 4, and 6. The gross requirements for the gear and rotor plate assembly have already been given to you For the remaining items, you will need to figure out the gross requirements. All scheduled receipts, lead times, and beginning inventory levels are shown. . Note that cotter pins appear twice in the bill of material. Gear and rotor plate assembly: Lead time = 1 week; Minimum order quantity = 2,500 WEEK 1 2 3 4 5 6 Gross requirements 2,000 2,000 2,000 Scheduled receipts Projected ending inventory: 1,000 Net requirements Planned receipts Planned orders AND CONTROLLING OPERATIONS AND SUPPLY CHAINS 4 5 6 Wheels: Lead time = 1 week; Minimum order quantity = 1 WEEK 1 2 3 Gross requirements Scheduled receipts Projected ending inventory: 0 Net requirements Planned receipts Planned orders 5 6 Cotter pins: Lead time = 3 weeks; Minimum order quantity = 15,000 WEEK 1 2 3 4 Gross requirements Scheduled receipts Projected ending inventory: 11,000 Net requirements Planned receipts Planned orders (**) Each Triam Deluxe gamer computer system consists of two speakers, a monitor, unit a keyboard, and an installation kit The