caculate the MRP

QUESTION 1 Case: The production manager at Yanbu Manufacturing wishes to develop a materials requirements plan for producing chairs over an 8-week period. He estimates that the lead time between releasing an order to the shop floor and producing a finished chair is 2 weeks. The company currently has 170 chairs in stock and no safety stock (safety stock is stock held in reserve to meet customer demand if necessary). The forecast customer demand is for 90 chairs in week 1,75 in week 2,50 in week 4,80 in week 6,70 in week 7 and 10 in week 8. Question 1: MRP 1. How many stocks on-hand at the end of week 2 ? 2. How many stocks on-hand at the end of week 4 ? 3. How many chairs to order in week 1 ? 4. How many chairs to order in week 2 ? 5. When to order 80 chairs? Question 2: MPR L4L with FPR of 3 weeks 1. How many stocks on-hand at the end of week 3 ? 2. How many stocks on-hand at the end of week 6 ? 3. When to order 50 chairs? 4. How many chairs to order in week 4 ? 5. How many chairs to order in week 5