Application of Available-To-Promise Logic to Jag's Instant Coffee Production
Beginning Inventory on hand 50 stappen plan voor order promising
MPS Production Quantity 120 Stap 1 bereken de prjected availible inventory
PA(t) = PA(t-1) + MPS – Max (customer orders ; Forecast)
period
Now 1 2 3 4 5 check Stap 2 wanneer de voorraad negatief wordt moeten we een MPS production order
nu weten we dat alle bestellingen kunnen worden ingevuld maar we weten niet hoeveel we aan de klant kunnen beloven
Forecast 60 60 60 60 60
Customers Orders 90 80 50 20 0 demand -240 Stap 3 Voor dit moeten we de ATP berekenen
Projected Available Inventory 50 80 0 60 0 60 Supply 50 beginvoorraad ATP in period 1 = (Beginning Inventory + MPS in period 1) – sum (CO until the next period of planned production)
Master Production Schedule 120 120 120 360 ATP in period n= (MPS in period - sum (CO until the next period of planned production)
Available to Promise-discrete 0 50 120
Cumulative ATP Without Lookahead 0 0 50 50 170 170 Stap 4 berekening checken
Projected Available Inventory Master Production Schedule Available to Promise-discrete
90 140 140
80
120 120
70
60 100 100
50 80 80
40 60 60
30 40
20 40
10 20 20
0 0 0
1 2 3 4 5 6 1 2 3 4 5 6 1 2 3 4 5 6
,ATP without lookahead
Beginning Inventory on hand 110
Standard production lot size 125
May June
Week Now 10 11 12 13 14 15
Forecast 50 50 50 50 75 75
Customer Orders 45 25 105 20 110 15
Projected Available Inventory 110 60 10 30 105 120 45
Master Production Schedule 0 0 125 125 125 0
Available to Promise-discrete 40 20 105 0
Cumulative ATP Without Lookahead 40 40 60 165 165 165
Master Production Schedule Available to Prom
140 140
120 120
100 100
80 80
60 60
40 40
20 20
0 0
10 11 12 13 14 15 16 17 18 19 20 21 10 11 12 13 14 15 16
, July
16 17 18 19 20 21
75 75 50 50 50 50
0 50 10 0 0 40
demand -420
95 20 95 45 120 70
supply 110
125 125 125
geproduce 750
75 115 0 85
240 240 355 355 440 440 440
in 12F doen we enkel - 20 omdat we de volgende periode oo
Available to Promise-discrete
11 12 13 14 15 16 17 18 19 20 21
Beginning Inventory on hand 50 stappen plan voor order promising
MPS Production Quantity 120 Stap 1 bereken de prjected availible inventory
PA(t) = PA(t-1) + MPS – Max (customer orders ; Forecast)
period
Now 1 2 3 4 5 check Stap 2 wanneer de voorraad negatief wordt moeten we een MPS production order
nu weten we dat alle bestellingen kunnen worden ingevuld maar we weten niet hoeveel we aan de klant kunnen beloven
Forecast 60 60 60 60 60
Customers Orders 90 80 50 20 0 demand -240 Stap 3 Voor dit moeten we de ATP berekenen
Projected Available Inventory 50 80 0 60 0 60 Supply 50 beginvoorraad ATP in period 1 = (Beginning Inventory + MPS in period 1) – sum (CO until the next period of planned production)
Master Production Schedule 120 120 120 360 ATP in period n= (MPS in period - sum (CO until the next period of planned production)
Available to Promise-discrete 0 50 120
Cumulative ATP Without Lookahead 0 0 50 50 170 170 Stap 4 berekening checken
Projected Available Inventory Master Production Schedule Available to Promise-discrete
90 140 140
80
120 120
70
60 100 100
50 80 80
40 60 60
30 40
20 40
10 20 20
0 0 0
1 2 3 4 5 6 1 2 3 4 5 6 1 2 3 4 5 6
,ATP without lookahead
Beginning Inventory on hand 110
Standard production lot size 125
May June
Week Now 10 11 12 13 14 15
Forecast 50 50 50 50 75 75
Customer Orders 45 25 105 20 110 15
Projected Available Inventory 110 60 10 30 105 120 45
Master Production Schedule 0 0 125 125 125 0
Available to Promise-discrete 40 20 105 0
Cumulative ATP Without Lookahead 40 40 60 165 165 165
Master Production Schedule Available to Prom
140 140
120 120
100 100
80 80
60 60
40 40
20 20
0 0
10 11 12 13 14 15 16 17 18 19 20 21 10 11 12 13 14 15 16
, July
16 17 18 19 20 21
75 75 50 50 50 50
0 50 10 0 0 40
demand -420
95 20 95 45 120 70
supply 110
125 125 125
geproduce 750
75 115 0 85
240 240 355 355 440 440 440
in 12F doen we enkel - 20 omdat we de volgende periode oo
Available to Promise-discrete
11 12 13 14 15 16 17 18 19 20 21
