# 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

Tietoa työnantajasta:
( 227 arvostelua ) United States

Projektin tunnus: #4300481

## 37 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön

jaylancer43

\$35 USD 2 päivässä
(537 arvostelua)
8.1
seaanddream

\$49 USD 3 päivässä
(232 arvostelua)
7.4
koolsidz

Excel Whiz here. Please see PMB :)

\$45 USD 0 päivässä
(148 arvostelua)
6.5
rohitpithisaria

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

\$50 USD 5 päivässä
(99 arvostelua)
6.2
funnyhoney

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

\$250 USD 4 päivässä
(11 arvostelua)
5.6
ethicalboy

I like to do this project.

\$30 USD 1 päivässä
(60 arvostelua)
5.2
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ä
(21 arvostelua)
4.7
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ä
(30 arvostelua)
4.2
Usmanwaheed

I have experience of working with similar data in excel. You will get 100% result of project as required.

\$100 USD 2 päivässä
(6 arvostelua)
4.2
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ä
(11 arvostelua)
4.4

lets start the work immediately

\$50 USD 1 päivässä
(15 arvostelua)
3.8
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ä
(2 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ä
(1 arvostelu)
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ä
(1 arvostelu)
1.0
olizer

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

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

Hi! I would be able to complete given work to the best of my ability, type quickly and efficiently.

\$30 USD 2 päivässä
(0 arvostelua)
0.0
ihtasham

Dear Hiring Manager, I'm a student of Management Sciences with a lot of experience in business activities. I am very interested in your job. I have done a lot of work on Microsoft word, Excel, PowerPoint for example Lisää

\$30 USD 15 päivässä
(0 arvostelua)
0.0
hbtmarathon

I can do the task with my skills.

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

I would like to start on this project. Thanks

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

Hi I am working in excel for about 5 years and I assure you the best one as you are expecting.

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