How Can Prepaire Schedule 4 Of Bonus Act - XLS Download

Dear All,
I'm in need of your help to calculate the bonus payable amount as per Schedule - 4
For your reference data is given as below of Schedule - 2 & 3
Available Surplus is
For 2006-07 Rs. (72,34,297) (Negative)
For 2007-08 Rs. (62,60,609) (Negative)
For 2008-09 Rs. 64,57,07,265 (Positive)
For 2009-10 Rs. (88,034,052) (Negative)
For 2010-11 Rs. (80,118,070) (Negative)
For 2011-12 Rs. 10,020,416 (Positive)
Bonus Paid
In 2006-07 Rs. Nil
In 2007-08 Rs.77,161
In 2008-09 Rs.104,942
In 2009-10 Rs.186,023
In 2010-11 Rs.276,429
In 2011-12 Rs.226,284
Please give me detail Schedule 4 form 2006-07 to 2011-12
for your detail reference I am attaching hearwith schedule 2 and 3 calculation sheet in excel format.
Thanks,

Would like to know as what are legal procedure to be followed for removal of surplus manpower due to continious loss of the Company.