FOR CHECK

profilemasauda2020
staffturnover20201.xlsx

Sheet1

Coast of current employees
Payment per hour (SAR) Number of hours Average earning per day (SAR) per year per 2 years
for Nurses 112 8 896 322,500 645,000
for Physician 121.5 8 972 350,000 700,000
Costs Hiring New Staff
Factor Amount (SAR)/ nurse Amount (SAR)/ Physician
Marketing costs 19,000 19,000
Pay for relocation 19,000 19,000
Training per employee 35,000 35,000
Non productive costs 23,500 25,500
Total 96,500 98,500
Cost Retaining Employees/ Year- Salaried Employee
Nurses Employees
Factor Number of days Average earning per day (SAR) Amount (SAR)
Annual Salary 260 896 232,960
Paid Annual Leave 21 896 18,816
Eid Leave 15 896 13,440
Sick Leave 30 896 26,880
Total 292,096
Physician employees
Factor Number of days Average earning per day (SAR) Amount (SAR)
Annual Salary 260 972 252,720
Paid Annual Leave 21 972 20,412
Eid Leave 15 972 14,580
Sick Leave 30 972 29,160
Total 316,872
Cost Retaining Employees/ Year- Hourly Employee
Nurses Employees
Factor Number of days Average earning per day (SAR) Amount (SAR)
Annual Salary 224 896 200,704
Paid Annual Leave 21 896 18,816
Eid Leave 15 896 13,440
Sick Leave 30 896 26,880
Total 259,840
Physician employees
Factor Number of days Average earning per day (SAR) Amount (SAR)
Annual Salary 224 972 217,728
Paid Annual Leave 21 972 20,412
Eid Leave 15 972 14,580
Sick Leave 30 972 29,160
Total 281,880

Sheet2

Sheet3