Requirements are to be planned for component C5 in product P1. Required deliveries for P1 are given in Table 41.1. Ordering, manufacturing, and assembly lead times are as follows: forP1 and S2, thelead timeis one week; for C5, the lead time is three weeks; and for M5, the lead time is 2 weeks. Given the product structure in Figure 41.4, determine the time-phased requirements for M5, C5, and S2 to meet the master schedule for P1. Assume no common use items. Onhandinventories are 200 units forM5 and 100 units for C5, zero for S2. Use a format similar to Table 41.2 and develop a spreadsheet calculator to solve. Ignore demand for P1 beyond period 10.