Write a formula for calculating the production and supply plan

Good afternoon, colleagues.
Please help me write a formula that takes into account all the limitations.


Write a formula for calculating a production plan in lines 12-13 based on the following introductory statements:

1. Checking for the possibility of production at the plant according to the data on the sheet "Matrix"

2. Production alignment to cyclicality, column J. For example, 3 - production every three days, with substitution 5, the cyclicity changes accordingly.

3. Volume is considered to ensure sales in line 6-7, subject to column K, production cannot be less than the minimum lot, and the rounding step to ensure sales must correspond to the minimum lot.

4. The volume of production should cover the number of days in cycle + at the beginning of the next production, the stock in lines 14-15 must be at least the minimum number of days of sales established in lines 20-21.

5. If the minimum batch provides a period greater than the prescribed cyclicality, the next batch shall be made on the day when the stock is reduced to the minimum specified in lines 20-21.
The description is attached in the file.
Thank you.