Solve the fallowing MRP Problem... it is based on the same aggregate planning and MPS data as used in the worked-out example. For each problem, use the blank Excel spreadsheet provided to write down the MRP calculations, in the same format as shown in the provious slide (Slide 2T). Problem 2 Material requirements are to be planned for component C2 Assembly lead time for products and subassemblies (P and S levels) Manufacturing lead times for components (C level)- 2 weeks, Determine the time-phased requirements for M2, C2, and SI . - 1 week and ordering lead time for raw materials (M level) -3 wecks. Assume there are no common use items other than those specified by the product structures for Pl and P2, and that all on-hand inventories and scheduled receipts are zero Ignore demand beyond period 10. Solve the fallowing MRP Problem... it is based on the same aggregate planning and MPS data as used in the worked-out example. For each problem, use the blank Excel spreadsheet provided to write down the MRP calculations, in the same format as shown in the provious slide (Slide 2T). Problem 2 Material requirements are to be planned for component C2 Assembly lead time for products and subassemblies (P and S levels) Manufacturing lead times for components (C level)- 2 weeks, Determine the time-phased requirements for M2, C2, and SI . - 1 week and ordering lead time for raw materials (M level) -3 wecks. Assume there are no common use items other than those specified by the product structures for Pl and P2, and that all on-hand inventories and scheduled receipts are zero Ignore demand beyond period 10