# Excel Compensation Form

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

Taidot: Excel

( 227 reviews ) United States

Projektin tunnus: #4300481

## 38 freelanceria on tarjonnut keskimäärin 55 \$ tähän työhön

koolsidz

Excel Whiz here. Please see PMB :)

45 \$ USD 0 päivässä
(1 arvostelu)
5.5
Nhcuong

Hi, i can do it. You can simply input sale data with date and amount. Macro will take the rest. time span may not be limited by 2 years span. Best regards, Cuong NH

50 \$ USD 2 päivässä
(0 arvostelua)
4.8
ethicalboy

I like to do this project.

30 \$ USD 1 päivässä
(0 arvostelua)
4.3
funnyhoney

Excel pro here. Ready to start. Submission in 3 days.

250 \$ USD 4 päivässä
(0 arvostelua)
4.0

lets start the work immediately

50 \$ USD 1 päivässä
(0 arvostelua)
3.5
vgrichards

Very Good at Excel 2003-2010 and Excel VBA Macros. Please allow me to do it. Will ensure everything is as per your requirement

30 \$ USD 2 päivässä
(0 arvostelua)
3.4
rohitpithisaria

Hi... I would like to apply for the job.

50 \$ USD 5 päivässä
(0 arvostelua)
2.9
seaanddream

49 \$ USD 3 päivässä
(0 arvostelua)
2.8
jaylancer43

35 \$ USD 2 päivässä
(0 arvostelua)
2.7
epdailo

I would like to work on this with you. I have lots of experience on these types of spreadsheets.

30 \$ USD 7 päivässä
(0 arvostelua)
2.2
sokhom168

I am expert of excel and macro. That is part of my daily jobs. Your task will done as soon as you expected.

30 \$ USD 2 päivässä
(0 arvostelua)
1.3
ramona12

Hello! I am working a lot in Excel and can do this job fast and accurate as I am a very responsible person. Thank you. Regards, Ramona

30 \$ USD 1 päivässä
(0 arvostelua)
1.0
darshinisk

Hi I am expert in excel and can do your job for \$35 within a day. Also I am finance professional so I am aware of those bonus, commission etc. regards DSK

35 \$ USD 1 päivässä
(0 arvostelua)
1.0
carloztr1k3r

I would like to start on this project. Thanks

30 \$ USD 1 päivässä
(0 arvostelua)
0.0
anupagarwal06

Hi, Expect quality work and time. 100% accurate, fully scalable results.

40 \$ USD 1 päivässä
(0 arvostelua)
0.0
skf786

Hi, if i get this, this will be my first project. i am an excel specialist, working everyday on excel for the last 15 years. i have already prepared performance management templates for my employers where actual sal Lisää

100 \$ USD 3 päivässä
(0 arvostelua)
0.0
dd888

Very Good at Excel 2007 and Excel VBA Macros. Please allow me to do it. Will ensure everything is as per your requirement

40 \$ USD 6 päivässä
(0 arvostelua)
0.0
Midlander

Sending you a sample Excel 2010 spreadsheet that does eveything you want. If you like what you see you can have the full version within 24 hours of paying the funds into the site. More details on Private Message Lisää

56 \$ USD 1 päivässä
(0 arvostelua)
0.0
olizer

Excel expert. Looking forward to working with you...

30 \$ USD 1 päivässä
(0 arvostelua)
0.0
gujaratisms

Dear Sir I understand your requirements. You may trust me. No question about knowledge of excel i got top 10 excel master certificate from o-desk

45 \$ USD 3 päivässä
(0 arvostelua)
0.0