Formula needed for working coop

Question

I need to calculate differential financial bonuses in our working coop, and to have a spreadsheet formula that will calculate the individual members’ bonuses based on known variables.

Bonuses are allocated proportionally, based on whether a member worked full time (100%) or part time. This is expressed as a percentage in the excel spreadsheet.

In addition we have three levels of membership.
Level 1: basic bonus
Level 2: 3 times the basic bonus
Level 3: 5 times the basic bonus

This if member ‘A’ works half time (50%) and is a level 2 member, then she will receive half of the basic bonus times 3.

I need a formula for this, assuming the following is known:
- the total bonus amount to be shared -
the percentage of time a member has worked
- the level of membership

Can you help?

Answer 1

This looks more like a RFP (request for proposal) solicitation to obtain consultancy help, rather than an academic cry-for-assistance on a particular problem.

 

In other words, you need professional consulting in Excel or Accounting, or the like--what you're talking about here is normally a service for which you would pay to have a custom software product developed.