HI System would not let me upload excel file, So I have screen shoot, It is total for four questions.s

Screen shoot is data file and I have attached questions below the screes shoot, and answer it

Thank you

Question 8 (27 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.

8a. 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 350

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

8b. 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. (7 points)

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. (8 points)

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. (8 points)

Question 9 (3 points):

Find the sum of all odd numbers from 1 to 1001 (the list of odd will be 1,3,5,7, all the way to 1001) (3 points)

I Sales report for youp of people - Excel Page Layout Formulas Data Remem View Help Acrobat 9 Tell me what you want to do KL/ F Sales report for groups of workers by week Group 3 Group 4 Groups Group 6 Group 7 Group roup Group - 9 | | TT