8c. 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.

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

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

If sales more than or equal to 250 and less than 430 then salary is 15% of sales

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

Report the total dollar salary for all groups over the whole period.

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