It's the homework of production planning and control course

Problem 1. The demand for a particular item for the next 12 weeks is 45 units in weeks 2, 5, 11 and 12: 50 units in weeks 1, 3, 4, 6, 7 and 8; and 60 units in weeks 9 and 10. Initial on-hand inventory is 100 units. Another 100 units are scheduled for receipt in period 2. The lot size is 100 units and the lead-time is 2 weeks. Also, there is a safety stock requirement of 20 units. (a) (b) Develop the gross and net requirements report for the 12-week period. If the ordering cost is $80 per order and the carrying cost is $0.5/unit week, determine the total cost of this arrangement