Prepare a table like Figure 13-12 for the following situation: The forecast is 80 units for each of the first two weeks and 60 units for each of the next three weeks. The starting inventory is 30 units. The company uses the lot size of 150 units. Also, the desired safety stock is 20 units. Committed orders are:

Week               Customer orders

1………………………………...82

2………………………………...80

3………………………………...60

4………………………………...40

5………………………………...20

Figure 13-12

Weeks June July 64 1 3 6 7 Forecast 30 30 30 30 40 40 Customer orders (committ 33 2010 Projected on-hand inventory Planned production Available-to- promise inventory 1 (uncommitted) 11 41 31 01 31 70 70 70 56 68 070