Sheet3
mrp
mps
Master Production Schedule
On Hand
Forecast Orders
Actual Orders
Available to Promise
weeks
Materials Requirements Planning (MRP)
Gross Requirements
Lead Time
Safety Stock
Order Size/Rule
Schedule Receipt
100/fq

lfl
BOM
A
B (3)
300/fq
Note: Lumpy demand
Note Order move up
Note: quality problem
Planned Reciept
Planned Order
MPS
Projected Inventory
Beginning Inventory =
Order quantity lots of 10
Order Lead time = 1 week

Order quantity lots of 50
Order Lead time = 2 week
safety Stock = 0
Question: Customer call requesting to place an order for 10 units in week 2, What is your response?
Question: Customer call requesting to place an order for 25 units in week 2, What is your response?
Class assignment: MPS
Question: Customer calls and wants 10 in weeks 3 and 6. What is your response?
2.00
125.00
1.00
2.00
3.00
4.00
5.00
6.00
7.00
8.00
650.00
550.00
600.00
600.00
575.00
625.00
625.00
600.00
600.00
500.00
234.00
0.00
1.00
0.00
1.00
2.00
3.00
4.00
5.00
6.00
7.00
8.00
1000.00
1100.00
1200.00
1100.00
1000.00
900.00
1000.00
1200.00
900.00
144.00
2.00
125.00
1.00
2.00
3.00
4.00
5.00
6.00
7.00
8.00
650.00
0.00
600.00
0.00
600.00
0.00
1000.00
0.00
300.00
0.00
500.00
0.00
2.00
100.00
1.00
2.00
3.00
4.00
5.00
6.00
7.00
8.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
0.00
1900.00
0.00
25.00
1.00
2.00
3.00
4.00
5.00
6.00
7.00
8.00
20.00
20.00
20.00
20.00
20.00
20.00
20.00
20.00
21.00
15.00
15.00
10.00
5.00
5.00
200.00
1.00
2.00
3.00
4.00
5.00
6.00
7.00
8.00
100.00
100.00
110.00
110.00
110.00
120.00
120.00
110.00
90.00
80.00
80.00
60.00
50.00
10.00
Sheet3
mrp
mps
Master Production Schedule
On Hand
Forecast Orders
Actual Orders
Available to Promise
weeks
Materials Requirements Planning (MRP)
Gross Requirements
Lead Time
Safety Stock
Order Size/Rule
Schedule Receipt
100/fq

lfl
BOM
A
B…