You are preparing salary for this team. Follow the rule in each question to find the right number

Note: Each question rules are totally independent.

Question 1

For each member, if Sales in a given week is more than 500, then salary is 15% of Sales

If not, salary is 7% of Sales

Report the Total dollar Salary the company has to pay the whole team during this 20-week period

(sum salary of everyone and every week)

Question 2

For each member, Fixed salary is 10% of sales in a give week

Ff sales in a give weekis more than 400, then bonus is 5% of sales

If not, penalty is -5% of sales

Report the Total dollar Salary the company has to pay the whole team during this 20-week period

(sum salary of everyone and every week)

Question 3

Each week, calculate the average Sales. (so you have 20 different averages associated with 20 weeks/columns)

For each member, if sales in a give week is more than the average of the team for this week, give a bonus/penalty of 15% of sales

If not, bonus/penalty is -5% of sales

Report the Total Dollar BONUS/Penalty the company has to pay the whole team during this 20-week period

For a given person/week, this Bonus/Penalty could be positive (bonus) or negative (penalty)

(sum bonus of everyone and every week)

Careful with absolute reference. $B$5 vs. $B5 vs. B$5

You need to manually check few numbers to make sure that Excel calculation is correct

Question 4

For the whole data, calculate the average weekly Sales. In other words, calculate the average of the whole original table (so you should have only 1 average number)

For each member, if sales in a give week is more than the overal average, give a bonus/penalty of 15% of sales

If not, bonus/penalty is -5% of sales

Report the Total Dollar BONUS/Penalty the company has to pay the whole team during this 20-week period

For a given person/week, this Bonus/Penalty could be positive (bonus) or negative (penalty)

(sum bonus of everyone and every week)

Careful with absolute reference. $B$5 vs. $B5 vs. B$5

You need to manually check few numbers to make sure that Excel calculation is correct

NOTE: For Question 4, the method of evaluating performance is similar to Rule4 in the handout/Video of Simple IF

You can watch the video to see how that Overal Weekly Average is calculated.

Rule 4:

You calculate the average weekly sales across the whole team and the whole time.

Texas Spectrum Wireless
Sales by Team Mmbers: San Antonio
Month Eding February 28
	Week 1	Week 2	Week 3	Week 4	Week 5	Week 6	Week 7	Week 8	Week 9	Week 10	Week 11	Week 12	Week 13	Week 14	Week 15	Week 16	Week 17	Week 18	Week 19	Week 20
Brooks, A.	2523.00	3555.00	2945.00	3689.00	3762.78	3838.04	3914.80	3993.09	4072.95	4154.41	4237.50	4322.25	4408.70	4496.87	4586.81	4678.54	4772.11	4867.56	4964.91	5064.21
Davis, J.	2,687	200	3,654	100	102.00	104.04	106.12	108.24	110.41	112.62	114.87	117.17	119.51	121.90	124.34	126.82	129.36	131.95	134.59	137.28
Garcia, R.	1,865	100	3,003	3,266	3331.32	3397.95	3465.91	3535.22	3605.93	3678.05	3751.61	3826.64	3903.17	3981.24	4060.86	4142.08	4224.92	4309.42	4395.61	4483.52
Lee, D.	1,423	1,958	2,566	3,230	3294.60	6000.00	400.00	408.00	416.16	424.48	432.97	441.63	450.46	459.47	468.66	478.04	487.60	497.35	507.30	517.44
Taylor, L.	2,587	2,563	2,842	4,254	4339.08	4425.86	4514.38	4604.67	4696.76	4790.69	4886.51	4984.24	5083.92	5185.60	5289.31	5395.10	5503.00	5613.06	5725.32	5839.83
Wilson, N.	1,987	3,016	3,584	5,288	5393.76	5501.64	5611.67	5723.90	5838.38	10000.00	10200.00	10404.00	10612.08	5000.00	5100.00	3000.00	3060.00	5000.00	5100.00	5202.00