Prepare a table like Figure 13-12 using the following information: The forecast for each week of an eight-week schedule is 50 units. The master production scheduling rule is to schedule production if the projected on-hand inventory would be negative without it. Customer orders (committed) are:
Week Customer Orders
1€¦€¦€¦€¦€¦€¦€¦€¦€¦52
2€¦€¦€¦€¦€¦€¦€¦€¦€¦35
3€¦€¦€¦€¦€¦€¦€¦€¦€¦20
4€¦€¦€¦€¦€¦€¦€¦€¦€¦12
Use a production lot size of 75 units and no beginning inventory.
Figure 13-12

Transcribed Image Text:

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