Discuss the below in detail:
Q: One hundred twenty units of end item Z are needed at the beginning of week 7. Prepare a material requirements plan for component C. 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. Lead times are two weeks for Z and B, and 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 beginning of week 7. Prepare a material requirements plan for component D. Take into account that 5 units of E are currently on hand, as well as 50 units of B, 100 units of C, and 80 units of C, and 80 units of D. Also, 30 units of C have been outsourced and are expected to arrive in week 4. Lead times are two weeks for E and C, and one week for the other components. Assume lot-for-lot ordering except for D, where multiples of 40 must be used.