Sales Analysis need in 24 hours

Sales for Company A www.microsoft.com

Quarter Sales Person Region Quarterly Sales Average quarterly sales

31-Mar Smith East $750

31-Mar Williams East $800

31-Mar Jones South $765

31-Mar White West $456

31-Mar Johnson North $987

31-Mar Taylor West $443

31-Mar Young South $368

31-Mar Hall East $159

Total Quarter 1 sales $4,728

Average quarter 1 sales $591

30-Jun Smith East $1,200

30-Jun Williams East $369

30-Jun Jones South $980

30-Jun White West $650

30-Jun Johnson North $760

30-Jun Taylor West $278

30-Jun Young South $780

30-Jun Hall East $547

Total 2nd Quarter sales $5,564

Average 2nd Quarter sales $696

30-Sep Smith East $698

30-Sep Williams East $467

30-Sep Jones South $983

30-Sep White West $237

30-Sep Johnson North $469

30-Sep Taylor West $740

30-Sep Young South $749

30-Sep Hall East $345

Total 3rd Quarter sales $4,688

Average 3rd Quarter sales $586

Total Sales $14,980

0

1000

2000

3000

4000

5000

6000

East North South West

Sum of Quarterly Sales by Region

Region

Sum of Quarterly Sales