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 below:

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)