I am a manager on a large private yacht that deals with close to 20 crew members, and i am looking for someone to create a spreadsheet (preferably Excel) to efficiently manage employee holiday, training and bonus allowances.
Crew members are divided in 2 categories, department heads and regular crew.
Department heads are entitled to an annual bonus starting at 30% of annual wage, and capping out at 60% after 7 years of employment.
Regular crew members start at 20% and cap at 40% after 5 years.
Holiday and training allowances are the same for department heads and regular crew members.
The allowance is 4 weeks of paid holiday within the first year, and capping at 8 weeks in the 5th year.
Training is 1 week of training AFTER the 1st year, and capping at 4 weeks after the 4th year.
I would like the spreadsheet to backdate to 2008, and for it to be able to track both paid and unpaid leave.
I have attached an example of the existing spreadsheet, but by no means does it have to resemble this at all other than the information it will contain.
39 freelancere byder i gennemsnit $302 på dette job
i am the most energetic and punctual girl and ill surely make my employer happy with my works and my deeds and ill surely make good relation with him or her as well