Final answer:
An MRP schedule for Product Z requires backward calculation from the due date, considering lead times of Z, A, B, C, D, and E to determine when each component needs to be ordered or manufactured. E needs to be ordered by Period 4, components of A by Period 7, and the assembly of Product Z starts by Period 8.
Step-by-step explanation:
To develop an MRP (Material Requirements Planning) schedule for Product Z, given the consumption rates and lead times for each component and sub-component, we must work backward from the due date for Product Z. The lead times indicate how long before the due date each component and sub-component must be ordered or manufactured to ensure timely completion.
- Product Z requires two units of A and three units of B.
- Component A is composed of three units of C and four of D.
- Component D requires two units of E for completion.
Now, considering the lead times:
- Product Z takes two weeks to assemble.
- Components A, B, C, and D each take one week.
- Component E takes three weeks.
Since we need 68 units of Product Z by Period 10, we must start assembling them by Period 8 (taking into account the two-week assembly time for Z). Therefore, we need all units of A and B at the latest by Period 8. The components of A (C and D) thus must be ordered by Period 7, and since D is made of E which takes three weeks, we need to order E by Period 4.
The MRP schedule will show the gross and net requirements for each component by period, as well as the order release and receipt dates to meet the demand for 68 units of Product Z by Period 10. This includes the calculation of quantities required, considering no initial inventory is on hand.