Can someone please offer help with these problems below?

QUESTION 16 Given the following Master Schedule Data: Assume we are currently in Week 16. Calculate the Available to Promise for Week 18. Available to Promise First Week ATP Subsequent Weeks ATP (MPS > 0) ATP, = E1,-1 + MPS, - OB; ATP, = MPS, - OB; where: ATP, = available to promise in week EL-= ending inventory in week t - 1 MPS, = master production schedule quantity in weekt SOB, = sum of all orders booked from week 1 until week z (when the next positive MPS quantity is due) IT D ID 17 18 19 20 ATP, = available to promise in week EL-1 = ending inventory in week t - 1 MPS, = master production schedule quantity in week OB: = sum of all orders booked from week t until week z (when the next positive MPS quantity is due) Week 16 | 17 18 | Forecasted Demand 20 20 20 19 50 20 40 10 | 70 Booked Orders Master Production Schedule | (Planned Production) 20 60 30 | 20 0 Projected Ending Inventory 100100 Available to Promise Available to Promise . 110 C. 30 D. 20 . 40 . 80 G. 80 . 10 . 130 OJ. 160 . 140 Given the following Master Schedule Data: Calculate the Projected Ending Inventory for week 18: Ending Inventory EI, = EI-, + MPS, - max(F,,OB) where: EI, = ending inventory in time period MPS, = master production schedule quantity available in time period 1 F, = forecasted demand for time period OB, = orders booked for time period Week | 16 | 17 | 18 Forecasted Demand 70 Booked Orders 40 Master Production Schedule (Planned Production) 80 80 Booked Orders 40 Master Production Schedule (Planned Production) 80 Projected Ending Inventory 10 O OA. 60 B. go OC. 30 OD.70 O E. 20 OF. 10 O 6.50 OH. 40 01. go