bonus

Hello, i need help from you guys to build a form for calculating bonus. attached is an excel and the required is described below: 1- the target is to get a bonus for a person based on the activity 2- each cell under Bonus Column must equals quantity X value for the selected task 3- the value...

Hello, i need help from you guys to build a form for calculating bonus. attached is an excel and the required is described below: 1- the target is to get a bonus for a person based on the activity 2- each cell under Bonus Column must equals quantity X value for the selected task 3- the value...

New to the forum (Hello!), please forgive me if I am posting my question(s) incorrectly. I have been working on this all day and have hit a wall. The table that I am building is below: <tbody> A B C D E F G H I J K L M N O P Q R 1 Property Target Price Actual...

Insert a monthly column for a bonus scheme where if a salesperson equals or exceeds 12% commission for the month then they receive an additional $1,250, (This can be achieved by combining the IF and a VLOOKUP statement.) The % of commission and the amount of bonus on offer will vary every...

Hello, 1. Salaries are reported annually. However, they can change each month. 2. Bonuses are paid irregularly over different months. I am trying to achieve: Show in the table "Yearly Salary Vs Bonus" the correct results for Salary and Bonus while selecting a specific Month. OR if Selecting...

I am working on building a formula that calculates a bonus based on multiple criteria: number of units, total volume and fixed cost per unit. I can easily create one based on the volume and fixed cost per unit, but adding the units portion is giving me difficulty. Below is the chart in which the...

I have a list of employees with their names and corresponding departments, and their annual bonus amount. I need to find all matches by department, and return employee name and the bonus. There may be multiple matches per department. If the department number to lookup is in D1, the...

Newb here, I have found similar functions when searching here but nothing which includes the multiple functions I am looking for. See illustration below. Sales Goal $90,000 = Comission 1% of gross profit Sales Goal Bonus $1500 @ $100,000 Sales Cost Of Goods Profit The results in one...

Hi! I'm designing a new promotion and i'm thinking how to determine the quantity for each tier as well as how to determine what tiers i should create? e.g. Tier 1 = 1 to 5 units purchase = 2x bonus points Tier 2 = 6 to 50 units purchase = 5 x bonus points Tier 3 = 51 units and above = 10 x...

Hi all, I'm having an issue with conditional formatting, hope you can help. I'm doing some work on the gender pay gap, and need to use Red, Amber & Green to indicate good, ok, and bad. For example if the % of males and females to receive a bonus is below; I need to show the values in green, as...

I'm trying to find a max value within 4 cells and then award bonus points for highest. The max value in BD19:BD22 should then result in 5 points in BE19. since the results will be different everytime, thats why I'm looking for a formula to produce this result. example of what it should look...

my pivot table below has filters on column a and b but I need to filter by c and d. I can't figure out how to add the filter at the top of the column like a & b and the filter icon is greyed out. <colgroup><col><col><col><col></colgroup><tbody> A B C D EE# LS2 Values 10 1 BONUS...

I am trying to figure out a way to create a sheet for calculating bonus allocations from a sheet of data used to allocate payroll. Here is what the payroll sheet looks like: <strike></strike>And the formulas I need would produce a list of employee ids and their entity allocation like this: I...

I am struggling to put a formula together for the below set of inputs: <tbody> Target achievement % payout 90% 0 95% 50% 100% 100% 110% 150% 120% 200% </tbody> So if the target was £1000, and they achieved £900 they get nothing, if they got £1100 they get 150%. I need to know the...

Mr. Excel Forum, I have a sales team that gets paid based on units sold not dollars sold and then a percentage for bonus. I'm trying to figure out a formula that would allow them to track sales and see potential commissions. For basic math sake they need to sell 60 units a quarter. They only...

Hey Guys, I'm stuck and need some help. I need a formula to calculate a sales Bonus Here's the Pay plan & Qualifier: 14 UNITS = $500 BONUS*<o:p></o:p> 18 UNITS = $750 BONUS*<o:p></o:p> 20 UNITS = $1,000 BONUS*<o:p></o:p> 22 UNITS = $1,250 BONUS*<o:p></o:p> 25 UNITS = $1,500...

I have searched all over and can't find the right formula. I need to calculate a bonus based on the percent earned. Below 95%: No Bonus 95%: 500 96%: 700 97%: 900 98%: 1,100 99%: 1,300 100%: 1,500 For every 1% over 100% gets a $100 (1% = $100) example 101% gets 1,600, 102% gets $1,700 There...

Status B & C: commission + 3% bonus ; Status A: commission only Status A is calculating correctly, but B & C is not. I'd appreciate any help with this. If StatusCode <> "A" Then Bonus = 0.03 Commission = CommissionRate * Bonus * SalesAmount Else Bonus = 1 Commission =...