Solve in excel with formulas if possible

Complete the MPS record below for a single item. (Enter your responses as integers. A response of "O" is equivalent to being not applicable.) Item: A Order Policy: 100 units Lead Time: 1 week February January Quantity Week on Hand: 70 1 2 3 4 5 o 6 7 8 70 70 60 40 50 50 55 55 40 15 90 0 35 75 O 0 Forecast Customer orders (booked) Projected on-hand inventory MPS quantity MPS start