Please someone help me to solve this with steps and show calculation. Please. Qs no is 5 and it has part a and b. This is full question. Please don't post unnecessary comment jparsad. I will report you.

5. Consider the greeting card company described below. a. Complete the following MPS time phased record. WEEK ITEM: MUSICAL BIRTHDAY CARD 1 2 3 4 5 6 7 8 40 60 60 60 60 60 40 6 40 4 10 Forecast Orders Available Available to promise MPS On hand = 40; MPS lot size = 50 50 50 50 50 The following events occurred during week 1: Actual demand during week 1 was 35 units. Marketing forecasted that 80 units would be needed for week 9. An order for 40 in week 4 was accepted. An order for 12 in week 3 was accepted. The MPS in week 1 was produced as planned. b. Update the record below after rolling through time. Please calculate the beginning on-hand inventory for week 2. WEEK ITEM: MUSICAL BIRTHDAY CARD 2 3 4 5 6 7 8 9 Forecast Orders Available Available to promise MPS On hand MPS lot Size = 50 5. Consider the greeting card company described below. a. Complete the following MPS time phased record. WEEK ITEM: MUSICAL BIRTHDAY CARD 1 2 3 4 5 6 7 8 40 60 60 60 60 60 40 6 40 4 10 Forecast Orders Available Available to promise MPS On hand = 40; MPS lot size = 50 50 50 50 50 The following events occurred during week 1: Actual demand during week 1 was 35 units. Marketing forecasted that 80 units would be needed for week 9. An order for 40 in week 4 was accepted. An order for 12 in week 3 was accepted. The MPS in week 1 was produced as planned. b. Update the record below after rolling through time. Please calculate the beginning on-hand inventory for week 2. WEEK ITEM: MUSICAL BIRTHDAY CARD 2 3 4 5 6 7 8 9 Forecast Orders Available Available to promise MPS On hand MPS lot Size = 50