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,
1st December 2012 From India, New Delhi

Attached Files (Download Requires Membership)

Available surplus-1.xls (35.5 KB, 1239 views)

Would like to know as what are legal procedure to be followed for removal of surplus manpower due to continious loss of the Company.
28th June 2014 From India, New Delhi