Create a master schedule for a bicycle using the following data: Week 1 2 3 4 5 6 Customer Orders 70 70 20 40 10 MPS Opening Inventory 100 Use a three month moving average to calculate demand for period 6 (round to nearest digit) If you want to level production for weeks 1-6, how much should you produce? (round to the nearest digit) If you need your inventory to be at its least (25 units or below) by period 6, in what weeks should you schedule bicycle production? Note: negative inventory in week 6 should not exist