The beginning stock of a product is 200 units (On hand stock =200 unites). Safety Stock level is 50 unites. It is desirable to prepare a 12-week Master Production Schedule. MPS is 400 units. The Demand forecast and Customer order quantities for the 12 periods are given in the table below. Determine the Master Production Schedule and Available to promise amount (ATP) in a way that maintains the amount of safety stock. Demand Forecast Customer Order 1 70 120 2 60 120 3 80 110 4 90 110 5 110 100 6 120 90 7 130 80 8 150 50 9 140 40 10 145 0 11 180 0 12 190 0

Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter3: Introduction To Optimization Modeling
Section3.8: A Multiperiod Production Model
Problem 22P
icon
Related questions
Question
The beginning stock of a product is 200 units (On hand stock =200 unites). Safety Stock level is 50 unites. It is desirable to prepare a
12-week Master Production Schedule. MPS is 400 units. The Demand forecast and Customer order quantities for the 12 periods are
given in the table below. Determine the Master Production Schedule and Available to promise amount (ATP) in a way that maintains
the amount of safety stock.
Demand
Forecast
Customer
Order
1
2
3
4
5
6
70 60 90 90 110 120
80
120
120
110
110
100
90
7
130
80
8
150
50
9
140
40
10
145
0
11
180
0
12
190
0
Transcribed Image Text:The beginning stock of a product is 200 units (On hand stock =200 unites). Safety Stock level is 50 unites. It is desirable to prepare a 12-week Master Production Schedule. MPS is 400 units. The Demand forecast and Customer order quantities for the 12 periods are given in the table below. Determine the Master Production Schedule and Available to promise amount (ATP) in a way that maintains the amount of safety stock. Demand Forecast Customer Order 1 2 3 4 5 6 70 60 90 90 110 120 80 120 120 110 110 100 90 7 130 80 8 150 50 9 140 40 10 145 0 11 180 0 12 190 0
Expert Solution
steps

Step by step

Solved in 4 steps with 3 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,