A manufacturing company decides to plan the assembly of an end product over a 12-month long planning horizon, so that inventory levels of the product over time to be kept as low as possible. Gross requirements for this product are shown in MPS forms from below. Maximum production capacity of assembly department of the company amounts to 200 product units/month.

Fill the table and show calculation please, thank you!

Si 0 1 2 Planning MPS for product assembly at a capacity of maximum 200 units/month 3 4 5 6 7 8 9 10 11 65 44 54 69 52 64 48 53 49 12 Month NB TOTAL 65 72 62 708 S 0 NN L