Sumproduct to find monthly bonuses
Brand new user.
I have a list of employees production values (In row A). From this, how do I equate the highest value to be 100% and each value below to be a percentage OF this 100%?
I will be using this monthly where the employee with 100% would get $500 each month, for example, and each employee below would get a percentage of $500. Each month the highest value would be different based on how fast they worked
Im trying to create a formula to calculate bonuses for my employees and I cant figure it out.*
Here is what im trying to do.
One cell to state:
(specs $30,00-$50,00 @ .5%)
I need this cell to calculate .5% for the total from cell C13 if total is from $30K-$50K
And another cell to state:
(specs $50,001+ @ 1%)
I need this cell to calculate 1% for the total from cell C13 if total is from $5001 and above
I am attaching a workbook and there are two worksheets contained.
The first sheet has some staff ID numbers and $ amounts for product sold. This is just an idea - in reality it will be longer and have more staff member's ID noted.
The second sheet is for calculation of the staff bonus. The top two staff members for a month are paid a bonus. At the moment the bonus is 3.5% of the total sold for that staff member, but the total must be over the current amount of $100. These figures (bonus percentage and amount to exceed) can change so I need to be able to change these as required on sheet 2 and the calculations will work.
I am creating an asset purchase/capitalization plan and in the interest of space and calculation count I have chosen to do a summary monthly depreciation row. I have the first half of the concept down, but how do I get it to Stop after the designated time period (useful life) - Say 3 years (and asset purchased in May 2012 will be done Der. in May 2015 if it is a three year asset)
Need to create an excel formula to calculate bonus based on a percent of revenue. Here is what I am looking to do in "pseudo-code":
$0 - $500,00 - bonus = x% of revenue
$500,00 - $1,00,00 - bonus = y% of revenue
$1,00,00 - $1,500,00 - bonus = z% of revenue
The tricky part is that while this is a tiered scale, it still needs to continually calculate revenue to date. Example, the company does $1,250,00 in revenue. The calculation would be something like:
The first $500K in revenue is bonuses at x%, the second $500K is bonuses at y% and the last $250K is bonuses at z percent.
Related Applications & Scripts
As you may already know, matrix programs have been very popular online and rapidly gaining popularity over the last decade. Now you can run your own matrix from your site and attract new members to pay a monthly subscription to join. With full flexibility, you set the monthly joining fee, and the commission payouts on each level down to 10 levels. The matrix can be up to 10 times wide, or as narrow as you wish. Either way, with the inclusion of matching bonuses, banner impressions, text ads and a huge download package on offer, your prospects will quickly decide to become members of your program. There's very little effort required to setup this script, and you can be launching within days of installation, and generating revenue!
Additional payment calculator
How much do you save by paying more or making additional payments than your initial mortgage terms?
Monthly payment calculator
Want to know how much your monthly payment is for your mortgage?
How much do I have to earn?
Not sure how much money you'll have to earn to afford your house payment and accompanying expenses?
How much can I borrow?
Want to know how big of a mortgage you can take on?
Should I pay discount points?
Not sure if you should pay discount points on your mortgage loan?
How much will I save by refinancing my loan?
How long will it take to recoup the costs of refinancing my home mortgage?
How much will my tax deduction be?
Want to know how much your home mortgage will save you in taxes?
Bi-weekly mortgage calculator
Want to know how much time and money you'll save paying off your loan on a bi-weekly payment plan?
To find out the annual percentage rate of your loan, enter the loan amount, interest rate, points, other costs
and year-length term.
Interest only monthly payment calculator
To find out the monthly savings you could gain from an interest-only payment plan.
Calculate your monthly mortgage payment with this simple calculator. Installation and setup is very easy. You only need to upload the files to your webserver and set the payment periods. Use monthly, bimonthly, weekly, biweekly or any other non standard option. The style changes of the payment calculator is easy with CSS.
Use this PHP class to create a monthly calendar. It's easy to use and highly customizable, supports multiple languages, and you can choose whether weeks start with Saturday, Sunday, Monday, or any other day. Of course you can create as many calendars as you like.
Sleek, simple, lightweight, liquid, glass, reflected, shadow, vector, animated with percentage preloader. Added bonuses load-out animation upon 100% load completion. Comes in 3 pre-selected colors for you to start with. to modify instructions included along with the how to use instruction.