Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

and in une table below, update projected available balance iven the information

ID: 380015 • Letter: A

Question

and in une table below, update projected available balance iven the information ear (demand promised for delivery in Week 5? P. If MPS lot sizes can be increased by 50 percent beyond the frozen period time tence) of the schedule, what is the largest new order quantity that can be Item: X Lead Time: 0 On-hand: 15 Lot Size: 20 Safety Stock: 3 Demand Time Fence: 4 Planning Time Fence: 7 Period Forecast Customer Orders 4 10 7 10 2 10 15 10 5 Projected available balance Available-to-Promise MPS 20 20 20

Explanation / Answer

For 1st week, ATP will also include On hand stock

ATP of week 1 = 15+20-(5+2) - 3 = 25

If MPS is increased by 50% for Week 5, new MPS = 30

Thus, new quantity for delivery promise = 30 -3 = 27

Projected on hand = Inventory from previous week - Current week requirement + MPS Current week requirement = Max(Forecast,Customer orders) MPS is done when on hand inventory is less than current week requirement ATP = MPS - next week commited orders - current week committed orders - Safety stock