Distribution of quantities

Hello friends:

I'm stuck! and i really needs your help.‬‏
in this table i have 4 column, the third column
contine the formula Opening multiplie by A1-A15.

the sum of column D must be the same sum as column C
column D is round of column c.

Constraints
Column D Must be round number (Integer)
The Sum Of Column D Needs to be the same number as Column C
if not ( like this situation) the difference or the Add (2 in this situation (29-27)) will
added or reduced only from mar, jun, sep,dec in Column D
in this situation we will reduce 2, so we reduce 1 from march and 1 from june


????.png
this is the excel sheets:Excel.xlsx

Appreciate your Help