Answer:
Please find the detailed answer as follows:
Explanation:
Consider the table attached in the excel.
The above are the requirements of the units of material if demand of 8080 units of S has to be completed.
The requirement of units of U for maintenance is given in the second table.
As the lead time for S is two weeks the components should be ready by the fifth week.
As the lead time for components T and U both is 2 weeks their components should be ready by the third week.
Hence in the first week the required number of units of V, W, Y and Z are to be ordered as all of them are required in the third week.
The required number of units of X are to be ordered in the second week to be ready in third week.
The required units of U, Y and Z are to be ordered considering the requirement to make S plus the maintenance requirements.