10. XYZ Manufacturing Company has collected 10 periods of data for two of its products, A and B.

Using the two data sets as gross requirements data, construct MRP time-phased records. Using a spreadsheet program, create four time-phased records, two for each data set. For one case, use a lot size of 150 units, and for the other use an order quantity equal to the total net requirements for the next three periods. In all four records, start with a beginning inventory of 150 units and compute the average inventory level held over the 10 periods. What do the results mean?

Period Demand 1 2 3 4 5 6 7 8 9 10 A 71 46 49 55 52 47 51 48 56 51 B 77 83 90 22 10 10 16 19 27 79