1a. Master Production Scheduling: complete the following table safety Stock = 0
ID: 452092 • Letter: 1
Question
1a. Master Production Scheduling: complete the following table
safety Stock = 0
Master Production Schedule
Beginning Inventory =
60
weeks
1
2
3
4
5
6
7
8
Forecast Orders
15
15
15
15
15
15
15
15
Actual Orders
17
20
16
15
15
5
5
Projected Inventory
MPS
Available to Promise
Order quantity lots of 10
Order Lead time = 3 week
Just need some help with the table. Thanks!
safety Stock = 0
Master Production Schedule
Beginning Inventory =
60
weeks
1
2
3
4
5
6
7
8
Forecast Orders
15
15
15
15
15
15
15
15
Actual Orders
17
20
16
15
15
5
5
Projected Inventory
MPS
Available to Promise
Order quantity lots of 10
Order Lead time = 3 week
Just need some help with the table. Thanks!
Explanation / Answer
Safety Stock = 0 Lead Time - 3 weeks Beginning Inventory = 60 Lot Size 10 units 1 2 3 4 5 6 7 8 Forecast Orders 15 15 15 15 15 15 15 15 Actual Orders 17 20 16 15 15 5 5 0 Projected Inventory 53 33 17 12 7 2 7 2 MPS 10 10 10 20 10 0 0 0 ATP 23 -21 -20 0 0 0 0 0 Projected on-hand inventory For Period 1 = Beginning Inventory + MPS (3 week earlier) - Max of Forecast or Customer orders For Subsequent periods = Projected on-hand inventory + MPS (3 week earlier) - Max of Forecast or Customer orders * As Lead time 3 weeks Available to promise For Period 1 = Beginning Inventory + MPS - Customer Order for Current and Next periods For Subsequent periods = If MPS>0, MPS - Customer Order for subsequent two periods For MPS = 0, ATP = 0
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.