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