Excel work assignment
Sheial 234
EX2016-IndependentProject-2-4-solution.pdf
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
A B C D E F G
ID Last Name First Name Branch Commissions Bonus Rate Total Earnings
101 Lingle Bob Cameron Park $15,000 2.50% $15,375.00
102 McCartney Lanita Folsom $12,000 2.25% $12,270.00
103 Santos Eleesha Cameron Park $5,500 1.50% $5,582.50
104 Baxter Roy Granite Bay $4,500 1.50% $4,567.50
105 Alaro Jennifer Folsom $3,000 1.50% $3,045.00
115 Chan Tami Cameron Park $3,000 1.50% $3,045.00
117 Althouse Charlene Granite Bay $4,700 1.50% $4,770.50
119 Taylor Juan Granite Bay $4,000 1.50% $4,060.00
120 Reza Wayne Cameron Park $4,000 1.50% $4,060.00
125 Nevens Cheryl Cameron Park $12,000 2.25% $12,270.00
Cameron Park $40,332.50
Folsom $15,315.00
Granite Bay $13,398.00
Total $69,045.50
June 9, 2017
Central Sierra Insurance
Commission Sales and Bonuses
Branch Totals
S O
LU TI
O N
S
A M
P LE
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
A B C D E F G H
Central Sierra Insurance Family Day Community Fundraiser
ID Last Name First Name Branch Source Goal Amount
Goal
Reached?
101 Lingle Bob Cameron Park Raffle tickets $500 $750 Yes
102 McCartney Lanita Folsom Walk/run pledge $250 $225 No
103 Santos Eleesha Cameron Park Cash donation $500 $725 Yes
104 Baxter Roy Granite Bay Candy sales $300 $450 Yes
105 Alaro Jennifer Folsom Pedometer sales $500 $750 Yes
115 Chan Tami Cameron Park Raffle tickets $500 $275 No
117 Althouse Charlene Granite Bay Walk/run pledge $250 $275 Yes
119 Taylor Juan Granite Bay Walk/run pledge $250 $325 Yes
120 Reza Wayne Cameron Park Cash donation $500 $325 No
125 Nevens Cheryl Cameron Park Candy sales $300 $215 No
102 McCartney Lanita Folsom Candy sales $300 $350 Yes
103 Santos Eleesha Cameron Park Raffle tickets $500 $825 Yes
117 Althouse Charlene Granite Bay Raffle tickets $500 $900 Yes
104 Baxter Roy Granite Bay Pedometer sales $500 $825 Yes
105 Alaro Jennifer Folsom Cash donation $500 $1,000 Yes
S O
LU TI
O N
S
A M
P LE
1
2
3
4
5
6
A B
Candy_sales =Tables!$B$6
Cash_donation =Tables!$B$7
H_Rates =Tables!$B$1:$F$2
Pedometer_sales =Tables!$B$8
Raffle_tickets =Tables!$B$9
Walk_run_pledge =Tables!$B$10
S O
LU TI
O N
S
A M
P LE
1
2
3
4
5
6
7
8
9
10
A B C D E F
Commission $3,000 $6,000 $9,000 $12,000 $15,000
Bonus 1.50% 1.75% 1.90% 2.25% 2.50%
Source Goal
Candy sales $300
Cash donation $500
Pedometer sales $500
Raffle tickets $500
Walk/run pledge $250
S O
LU TI
O N
S
A M
P LE
