Complete the following master schedule record EEB Click the icon to view the mas
ID: 423972 • Letter: C
Question
Complete the following master schedule record EEB Click the icon to view the master schedule record Complete the master production schedule (enter your responses as whole numbers) On-hand inventory at end of week 1: 130 Week Forecasted demand Booked orders Projected ending inventory Master production schedule Available to promise 6 290 205 520 740 290 250 430 590 400 155 30 290 255 350 610 280 105 70 400 310 485 710 190 250 345 175 340 210 145 More Info On-hand inventory at end of week 1: 130 Week Forecasted demand Booked orders Projected ending inventory Master production schedule Available to promise 290 250 400 155 290 255 280 105 6 290 205 250 345 400 310 340 210 710 190 590 610 740 Enter your answer in theExplanation / Answer
Available to promise ATP
Week 2 = On hand inventory +Master production schedule – Booked orders on week 2 - - Booked orders on week 3 = 140 + 760 – 260-265 = 375
Week3: there is no MPS in week 3. So ATP is not available so it is zero
Week4: MPS – booked orders on week 4 – booked orders on week 5= 570-315-195 = 60
Week 5: No MPS no ATP = 0
Week 6 =530-170-145 = 215
Week 7 =0
Week 8 = 630-310-140 = 180
Week 9 =0