Question

Questions 9-11 Sales report for 8 groups of workers
by week
Week	Group 1	Group 2	Group 3	Group 4	Group 5	Group 6	Group 7	Group 8
1	983	983	914	744	967	711	131	827
2	951	10	229	725	339	809	48	664
3	568	503	364	540	258	881	702	280
4	96	976	406	704	475	405	881	471
5	919	619	781	194	240	844	753	341
6	650	890	782	402	970	542	640	10
7	127	742	25	532	428	168	635	807
8	899	109	632	635	859	671	676	172
9	275	925	13	311	778	623	879	502
10	917	565	891	856	687	615	765	58
11	575	156	691	101	286	322	658	217
12	726	707	173	778	469	260	277	642
13	681	918	40	996	822	894	805	191
14	799	806	611	494	167	31	30	156
15	733	116	514	604	253	682	811	643
16	0	255	107	331	797	917	713	339
17	567	206	874	744	158	537	127	548
18	865	950	285	990	52	633	979	176
19	753	499	271	847	230	994	242	933
20	372	752	223	639	718	17	181	177
21	268	872	59	940	443	264	88	290
22	318	104	298	95	345	250	13	232
23	937	676	23	494	384	141	564	421
24	110	217	473	673	363	879	388	729
25	405	974	77	980	57	658	606	215
26	172	640	497	976	108	860	294	56
27	153	946	930	333	432	240	481	585
28	647	604	79	571	953	284	943	301
29	90	866	149	403	994	8	659	922

Question 9 (21 points):

Data used: “Sales” sheet

This table report the sales for each group over a number of weeks.

You will have to create new tables that contain salary information for each group based on the below rules.

9a.          Each week, salary for each group is based on the schedule below:

   If Sales in a given week is less than 300 then salary for this week is 250

                If Sales in a given week is more than or equal to 300 then salary for this week is 450

Report the total dollar salary for all groups over the whole period. (5 points)

9b.          Each week, calculate the average Sales across 8 groups.

Each week, salary for each group is based on the schedule belo

If Sales in this week is More than 700 OR the average sales of this week (you just calculated) is more than 580 THEN salary for this week is 500.

                If not, salary is 300.

Report the total dollar salary for all groups over the whole period. (5 points)

9c.          Each week, calculate the average Sales across 8 groups.

Each week, salary for each group is based on the schedule below:

The Fix salary equal to 10% of sales

Also the Bonus/Penalty is determined following the rule below:

If Sales in this week is less than the average sales (you just calculated) OR less than 600 then penalty is -15% of the sales of this week. If not, bonus is 10% of the sales of this week.

Report the total dollar salary for all groups over the whole period. (5 points)

9d.          Each week, salary for each group is based on the schedule below:

                If sales less than 200 then salary is 10% of sales

                If sales more than or equal to 200 and less than 500 then salary is 15% of sales

                If sales more than or equal to 500 then salary is 20% of sales.

Report the total dollar salary for all groups over the whole period. (6 points)

Question10 (3 points):

Find the sum of all odd numbers from 1 to 1001. (3 points)

Question 11 (4 points):

Use https://finance.google.com/finance

For Walmart (WMT), what is the average gross profit margin over the most recent 4 years.

Remember to use annual data.

(4 points)

Answer 1

9 (a)

9 (b)

9 (c)

9 (d)

10)

Sum of first 4 odd numbers = 1+3+5+7= 16 = 4*4

Sum of first 5 odd numbers= 1+3+5+7+9 = 25 = 5*5

Similarly, Number of odd numbers from 1 to 1001 = (1001-1)/2 = 500

Sum of all odd numbers from 1 to 1001

= 500*500 = 250000

11)