Bonus Calculation - Xls Download - Bonus Act

prashant1314
Dear All,
I have prepared the calulation of Bonus ( As per Bonus Act 1965 )please find the attachment if you like please convey the same!!!!
1 Attachment(s) [Login To View]

Prasad81
Dear Mr. Prashant,
Thanks for sharing the bonus calculation file.
But clarify me, what in case the basic is changed during the year?
I mean eg. If basic salary for april to june is Rs 3000/- and july onwards it is 5500/-.
Please clarify.
bishnu_jsr
Dear Prashant,
Its execellent, one querrey if any present during the year below 30 days than what happend. Its not shown in your formula.
Regds
Bishnu Deo Sharma.
vreddy_vhr
Dear Prasant
Please find attachement , the detailed Bonus calculation.
V.Venkatesh
1 Attachment(s) [Login To View]

sridhartas
Nice story ... enjoy

A king in Africa had a close friend with whom he had grown up. The friend had a habit of looking at every situation that occurred in his life, positive or negative, and remarking, "This is good!"

One day the king and his friend were out on a hunting expedition. The friend would load and prepare the guns for the king. The friend had apparently done something wrong in preparing one of the guns, for after taking the gun from his friend, the king fired it and his thumb was blown off. Examining the situation the friend remarked as usual, "This is good!" to which the king replied, "no, this is not good!" and proceeded to send his friend to jail.

About a year later, the king was hunting in an area wherein he should have known not to hunt. Cannibals captured him and took them to their village. They tied his hands, stacked some wood, set up a stake and bound him to the stake. As they came close to set fire to the wood, they noticed that the king was missing a thumb. Being superstitious, they never ate anyone who was less than whole. So untying the king, they sent him on his way.

As he returned home, he was reminded of the event that had taken his thumb and felt remorse for his treatment of his friend. He went immediately to the jail to speak with his friend. "You were right", he said, "It was good that my thumb was blown off." And he proceeded to tell the friend all that had just happened. "And so I am very sorry for sending you to jail for so long. It was bad for me to do this."

"No," his friend replied, "this is good!" "What do you mean, 'this is good!' How could it be good that I sent my friend to jail for a year?"

"If I had not been in jail, I would have been with you, and I would have been eaten!

Everything that happens, happens only for the good.
globaloverseas144
Dear Ranjit,
Why not try yourself,it is very simple,you use the formula bar in the attached excel sheet,if you still have problem,please let me know,i will send you our server bonus data sheet.
Best Regards
Sajid Ansari
If you are knowledgeable about any fact, resource or experience related to this topic - please add your views. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone. Join To Contribute