Closed

Excel Compensation Form

This project received 41 bids from talented freelancers with an average bid price of $57 USD.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
N/A
Total Bids
41
Project Description

This will be a very easy project for a person that is an Excel expert or professional. If you are new to Freelancer or need a better ranking. . . if you do this project for a low price and do a good job, I will give you the highest rank possible.

Scope of Work

I have a compensation plan that I need made into an Excel macro/template so when sales information is entered, this Excel file will calculate the:

1. Base Pay
2. Sales for each month with 2% commissions
12 Months - Jan - Dec for year 1 with month/year ending totals
12 Months - Jan - Dec for year 2 with month/year ending totals
3. Bonuses (See chart below)
If quarterly sales are 10% or more from same quarter last year, a bonus will be paid (I have $ amount for 10%, 11%, 12% through 50%)
Example: if Jan, Feb Mar 2012 quarterly sales are $10,000 and Jan, Feb, Mar 2013 sales are $14,000 this will be a 40% increase and will result in a bonus $ for that percentage increase (see below example showing 40% = $12,125).
4. % increase over last year
5. % increase over same quarter last year
6. % increase over same month last year
7. For a quarter, when months 1, 2, & 3 amounts are entered for year 1, and months 1 or 1 and 2 amounts are entered for year 2, I need to know how much $ sales are needed to get a 50% quarterly bonus (see below - 50% sales increase = $21,000)

Below is the bonus schedule

BONUS Sales Quarterly Annual
Versus PY or PQ BONUS BONUS
10% $500 $2,000
1 11% $525 $2,100
2 12% $575 $2,300
3 13% $650 $2,600
4 14% $750 $3,000
5 15% $875 $3,500
6 16% $1,025 $4,100
7 17% $1,200 $4,800
8 18% $1,400 $5,600
9 19% $1,625 $6,500
10 20% $1,875 $7,500
11 21% $2,150 $8,600
12 22% $2,450 $9,800
13 23% $2,775 $11,100
14 24% $3,125 $12,500
15 25% $3,500 $14,000
16 26% $3,900 $15,600
17 27% $4,325 $17,300
18 28% $4,775 $19,100
19 29% $5,250 $21,000
20 30% $5,750 $23,000
21 31% $6,275 $25,100
22 32% $6,825 $27,300
23 33% $7,400 $29,600
24 34% $8,000 $32,000
25 35% $8,625 $34,500
26 36% $9,275 $37,100
27 37% $9,950 $39,800
28 38% $10,650 $42,600
29 39% $11,375 $45,500
30 40% $12,125 $48,500
31 41% $12,900 $51,600
32 42% $13,700 $54,800
33 43% $14,525 $58,100
34 44% $15,375 $61,500
35 45% $16,250 $65,000
36 46% $17,150 $68,600
37 47% $18,075 $72,300
38 48% $19,025 $76,100
39 49% $20,000 $80,000
40 50% $21,000 $84,000

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online