please step by steo or with excel formulas

One hundred twenty units of end item Z are needed at the beginning of week 7 . Take into account that on hand there are 40 units of Z, 70 units of A,100 units of B, and 30 units of C. Also, there is a scheduled receipt of 20 units of component C in week 4 , Lesad times are two weeks for Z and B, ans one week for the other components. Lot-for-lot ordering will be used for all items. Ninety-five units of end item E are needed at the beginniny of week 7 . Take into sccount that 5 units of E are currentiy on hand, as wrin as 50 units of B, 100 units of C, and 80 units of D. Also, 30 units of C have been outsourced and are expected to arive in woek 4 . Leag times are two weeks for E and C, and one week for the other components. Assume lot-for-tot crdering except for D. where militiples of 40 must be used. . Prepare a material requirements plan for component D. (Do not leave any empty spaces; input a 0 wherever it is required)