Product X is made of two units of Y and three of Z. Y is made of one unit of A and two units of B. Z is made of two units of A and four units of C.
Lead time for X is one week; Y, two weeks; Z, three weeks; A, two weeks; B, one week; and C, three weeks. Current on-hand inventories of 22 X, 45 Y, 33 Z, 52 A, 90 B, and 800 C.
If 95 units of X are needed in week 10, develop a planning schedule showing when each item should be ordered and in what quantity. (Leave no cells blank - be certain to enter "0" wherever required.)