# 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

Skills: Excel

( 227 reviews ) United States

Project ID: #4300481

## 38 freelancers are bidding on average \$55 for this job

koolsidz

Excel Whiz here. Please see PMB :)

\$45 USD in 0 days
(1 Review)
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 in 2 days
(0 Reviews)
4.8
ethicalboy

I like to do this project.

\$30 USD in 1 day
(0 Reviews)
4.3
funnyhoney

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

\$250 USD in 4 days
(0 Reviews)
4.0

lets start the work immediately

\$50 USD in 1 day
(0 Reviews)
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 in 2 days
(0 Reviews)
3.4
rohitpithisaria

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

\$50 USD in 5 days
(0 Reviews)
2.9
seaanddream

\$49 USD in 3 days
(0 Reviews)
2.8
jaylancer43

\$35 USD in 2 days
(0 Reviews)
2.7
epdailo

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

\$30 USD in 7 days
(0 Reviews)
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 in 2 days
(0 Reviews)
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 in 1 day
(0 Reviews)
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 in 1 day
(0 Reviews)
1.0
carloztr1k3r

I would like to start on this project. Thanks

\$30 USD in 1 day
(0 Reviews)
0.0
anupagarwal06

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

\$40 USD in 1 day
(0 Reviews)
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 More

\$100 USD in 3 days
(0 Reviews)
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 in 6 days
(0 Reviews)
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 More

\$56 USD in 1 day
(0 Reviews)
0.0
olizer

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

\$30 USD in 1 day
(0 Reviews)
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 in 3 days
(0 Reviews)
0.0