Formula / model

%3CLINGO-SUB%20id%3D%22lingo-sub-377681%22%20slang%3D%22en-US%22%3EFormula%20%2F%20model%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-377681%22%20slang%3D%22en-US%22%3E%3CP%3EWe%20are%20looking%20at%20ways%20to%20pay%20employees%20a%20bonus%20based%20on%20service%2C%20we%20have%20the%20maximum%20amount%20we%20want%20to%20pay%20out.%20What%20would%20be%20the%20best%20model%20to%20work%20out%20what%20we%20should%20pay%20per%20person%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20the%20staffs%20current%20annual%20salary%2C%20the%20days%2C%20months%20and%20years%20they%20have%20worked%20for%20the%20business.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20a%20model%20that%20can%20be%20played%20with%2C%20currently%20we%20are%20looking%20at%20depending%20on%20the%20category%20you%20fall%20in%20to%20you%20will%20get%20a%20%25%20of%20you%20current%20annual%20salary%20paid%20but%20this%20%25%20might%20change%20so%20I%20need%20a%20formula%20%2F%20model%20that%20has%20room%20for%20these%20changes.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-377681%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-377790%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20%2F%20model%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-377790%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F304490%22%20target%3D%22_blank%22%3E%40Nancy_Kelleher1%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESorry%2C%20that%20was%20an%20answer%20for%20another%20question.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-377785%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20%2F%20model%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-377785%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1639%22%20target%3D%22_blank%22%3E%40Detlef%20Lewin%3C%2FA%3E%26nbsp%3Bcan%20you%20explain%20what%20result%20this%20would%20give%3F%20As%20I%20got%20a%20little%20lost%20on%20the%20second%20part.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-377722%22%20slang%3D%22en-US%22%3ERe%3A%20Formula%20%2F%20model%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-377722%22%20slang%3D%22en-US%22%3E%3CP%3EAnswer%20deleted.%20I%20posted%20on%20the%20wrong%20question.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

We are looking at ways to pay employees a bonus based on service, we have the maximum amount we want to pay out. What would be the best model to work out what we should pay per person? 

 

I have the staffs current annual salary, the days, months and years they have worked for the business. 

 

I need a model that can be played with, currently we are looking at depending on the category you fall in to you will get a % of you current annual salary paid but this % might change so I need a formula / model that has room for these changes. 

3 Replies
Highlighted

Answer deleted. I posted on the wrong question.

 

Highlighted

@Detlef Lewin can you explain what result this would give? As I got a little lost on the second part. 

Highlighted

@Nancy_Kelleher1 

Sorry, that was an answer for another question.