Turnover Calculations - Xls Download

saber
Hello,
I have calculated turnover in the below table. Average per year turnover is 1.55 and Sum of whole year is 18.63.
My question is: when someone asks me what is your company turnover?which figure I should state.
Emphirefiretotalturnover1st-Jan500574981.40End of Jan turnover1st-Feb498635010.60End of Feb turnoverMar50111334796.59Apr47915234714.80May471324720.42Jun472324730.42Jul473524760.42Aug476634790.63Sep479524820.42Oct4820124702.49Nov4702224900.43Dec4902205120.00Average1.55Sum18.63
Thanks,
Saber
1 Attachment(s) [Login To View]

Rashid Ahmed
Hi Saber,
You are to state average of whole year, that is 18.63 % in your case. Besides, you can state 1.55 monthly turnover as now a days it is supposed better to calculate turnover in months.
Let's examine,
If you say your turnover is 1.55 % , it will mean- 500 or 512/100 x 1.55= about 8 employees are leaving the company. This could be state only for a month and not seems correct for whole year.
Apart from it, if you say your turnover is 18.63 %, it will mean- 500 or 512/100 x 18.63 = about 95 employees left the company within 1 year. This is something what your table is showing. Remember, the higher is turnover, the more employees are leaving the company.
For more information about Turnover calculation please, read the attached DOC.
Regards,
Rashid
1 Attachment(s) [Login To View]

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