End item A has a planned lead time of 2 weeks. There are currently 120 units on hand and no scheduled receipts. Compute the planned order releases using lot-for-lot and the Master Production Schedule (MPS) shown here:
Week 1----2-- 3-- 4-- 5- 6--7-- 8- 9- 10
Demand 41 44 84 42 84 86 7 18 49 30
i) Compute number of units on hand for each week.
ii) Compute net demand for each week.
iii) Compute planned order receipts for each week.
iv) Compute planned order releases for each week.