0% found this document useful (0 votes)
16 views4 pages

Filtering Lab

The document presents sales data for Durango Business Solutions by sales representatives across various Australian territories, detailing quarterly sales figures. Additionally, it includes an April sales report for Tim's Tools and Hardware, listing products sold, units sold, and returns by location and region. The data highlights performance trends and product popularity in different areas.

Uploaded by

deckykurniawan56
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
16 views4 pages

Filtering Lab

The document presents sales data for Durango Business Solutions by sales representatives across various Australian territories, detailing quarterly sales figures. Additionally, it includes an April sales report for Tim's Tools and Hardware, listing products sold, units sold, and returns by location and region. The data highlights performance trends and product popularity in different areas.

Uploaded by

deckykurniawan56
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 4

Durango Business Solutions

Sales by Rep
Australian Territory

Sales Rep Location 1st Qtr. Sales 2nd Qtr. Sales 3rd Qtr. Sales 4th Qtr. Sales
Julia Western Australia $ 15,623.00 $ 14,555.00 $ 26,352.00 $ 25,412.00
Farrow South Australia $ 20,154.00 $ 19,456.00 $ 18,541.00 $ 25,674.00
Hall Tasmania $ 21,333.00 $ 25,449.00 $ 20,369.00 $ 24,785.00
Harrod Western Australia $ 25,321.00 $ 20,154.00 $ 19,542.00 $ 21,452.00
Nagy Australian Capital Territory $ 26,365.00 $ 33,652.00 $ 25,412.00 $ 21,450.00
Harris Victoria $ 30,132.00 $ 25,412.00 $ 22,654.00 $ 20,487.00
Martinez New South Wales $ 33,654.00 $ 69,565.00 $ 50,145.00 $ 41,254.00
Miller New South Wales $ 42,121.00 $ 43,256.00 $ 40,545.00 $ 39,999.00
Lopez Northern Territory $ 45,263.00 $ 30,256.00 $ 20,145.00 $ 49,874.00
Adler Victoria $ 45,632.00 $ 66,501.00 $ 55,410.00 $ 59,657.00
Torrie Victoria $ 50,258.00 $ 45,219.00 $ 46,359.00 $ 51,365.00
Becker South Australia $ 55,655.00 $ 50,247.00 $ 58,474.00 $ 60,014.00
Turner Western Australia $ 55,698.00 $ 45,301.00 $ 63,541.00 $ 33,345.00
Bowlby Northern Territory $ 56,445.00 $ 45,262.00 $ 49,655.00 $ 51,236.00
Barr Australian Capital Territory $ 56,986.00 $ 66,985.00 $ 78,547.00 $ 99,652.00
Elems Queensland $ 57,469.00 $ 87,456.00 $ 60,154.00 $ 70,136.00
Mahler South Australia $ 63,547.00 $ 60,458.00 $ 77,152.00 $ 70,452.00
Ainsworth Queensland $ 65,874.00 $ 70,257.00 $ 88,524.00 $ 60,458.00
Ansley Queensland $ 66,354.00 $ 60,456.00 $ 64,258.00 $ 69,452.00
James Queensland $ 75,422.00 $ 70,154.00 $ 69,565.00 $ 65,420.00
Collins Australian Capital Territory $ 90,574.00 $ 80,563.00 $ 88,497.00 $ 75,163.00
Simpson Tasmania $ 99,541.00 $ 80,547.00 $ 77,548.00 $ 81,569.00
Total
$ 81,942.00
$ 83,825.00
$ 91,936.00
$ 86,469.00
$ 106,879.00
$ 98,685.00
$ 194,618.00
$ 165,921.00
$ 145,538.00
$ 227,200.00
$ 193,201.00
$ 224,390.00
$ 197,885.00
$ 202,598.00
$ 302,170.00
$ 275,215.00
$ 271,609.00
$ 285,113.00
$ 260,520.00
$ 280,561.00
$ 334,797.00
$ 339,205.00
Tim's Tools and Hardware
April Sales Report

Location Region Product Product Group Month Units Sold Returns


Albany Northeast Electric Screwdriver Hardware APR 688 22
Albany Northeast Electric Drill Hardware APR 634 24
Albany Northeast Aerator Lawn & Garden APR 65 2
Boston Northeast Electric Edger Lawn & Garden APR 199 2
Boston Northeast Aerator Lawn & Garden APR 674 15
Buffalo Northeast Gas Weed Trimmer Lawn & Garden APR 458 10
Buffalo Northeast Electric Drill Hardware APR 1205 19
Buffalo Northeast Sander Hardware APR 872 58
Columbus Midwest Sander Hardware APR 805 22
Columbus Midwest Gas Weed Trimmer Lawn & Garden APR 241 31
Columbus Midwest Air Gun Automotive APR 124 3
Dallas Southeast Gas Edger Lawn & Garden APR 830 27
Dallas Southeast Air Gun Automotive APR 201 19
Dallas Southeast Electric Drill Hardware APR 999 45
Miami Southeast Air Gun Automotive APR 954 30
Nashua Northeast Leaf blower Lawn & Garden APR 655 29
New Orleans Southeast Mower (6 HP) Lawn & Garden APR 1322 22
Portland Northeast Air Gun Automotive APR 568 17
Richmond Southeast Sander Hardware APR 120 5
Richmond Southeast Mower (6 HP) Lawn & Garden APR 985 14
Sacramento West Electric Drill Hardware APR 933 99
Sacramento West Leaf blower Lawn & Garden APR 265 12
Sacramento West Gas Weed Trimmer Lawn & Garden APR 654 10
San Francisco West Mower Lawn & Garden APR 455 20
San Francisco West Electric Edger Lawn & Garden APR 854 20
Seattle West Table Saw Hardware APR 744 65
St. Louis Midwest Gas Weed Trimmer Lawn & Garden APR 854 23
St. Louis Midwest Engine Steamer Automotive APR 1548 16
St. Paul Midwest Aerator Lawn & Garden APR 402 30
St. Paul Midwest Sander Hardware APR 698 30
Ratio
3.20%
3.79%
3.08%
1.01%
2.23%
2.18%
1.58%
6.65%
2.73%
12.86%
2.42%
3.25%
9.45%
4.50%
3.14%
4.43%
1.66%
2.99%
4.17%
1.42%
10.61%
4.53%
1.53%
4.40%
2.34%
8.74%
2.69%
1.03%
7.46%
4.30%

You might also like