Answered step by step
Verified Expert Solution
Question
1 Approved Answer
IS there a way to add excel table doc here? 1) Create a PivotTable using the raw data table to the left. Make sure the
IS there a way to add excel table doc here?
1) Create a PivotTable using the raw data table to the left. Make sure the PivotTable is in Exercise 1 Pivot 1. Do not put the PivotTable in a different worksheet or you will not receive credit.
2) For each region, find the total sales, average profit and total shipping cost. The "Region" field should be in the "Rows" field. Do not change any of the header labels in your pivot table.
A B D E F G H J K L 1 Customer Name State 2 Rick Hansen New York 3 Justin Ritter New South Wales 4 Craig Reiter Queensland 5 Katherine Murray Berlin 6 Rick Hansen Dakar 7 Jim Mitchum New South Wales 8 Toby Swindell Wellington 9 Mick Brown Waikato 10 Jane Waco California 11 Joseph Holt North Carolina 12 Greg Maxwell Virginia 13 Anthony Jacobs Kabul 14 Magdelene Morse Jizan 15 Vicky Freymann Parana 16 Peter Fuller Heilongjiang 17 Ben Peterman Ile-de-France 18 Thomas Boland Kentucky 19 Patrick Jones Tuscany 20 Jim Sink Queensland 21 Ritsa Hightower 22 Ann Blume Silesia 23 Sue Ann Reed Illinois 24 Jason Klamczynski Anhui 25 Laurel Beltran Scotland 26 Naresj Patel Chihuahua 27 Valerie Dominguez San Salvador 28 Phillip Breyer Taipei City 29 Eugene Barchas Saxony 30 Karen Ferguson California 31 Benjamin Patterson Gujarat 32 Rick Reed Santo Domingo 33 Bill Shonely Brittany 34 Joel Eaton Texas 35 Dave Poirier Queensland 36 Nora Preis California 37 Aaron Hawkins Katanga 38 Darrin Martin New York 39 Grant Thornton North Carolina 40 Patrick O'Donnell England 41 Dan Lawera Queensland Kigoma Country Market United Sta US Australia APAC Australia APAC Germany EU Senegal Africa Australia APAC New Zeala APAC New Zeala APAC United Sta US United Sta US United Sta US Afghanista APAC Saudi Arab EMEA Brazil LATAM China APAC France EU United Sta US Italy EU Australia APAC Tanzania Africa Poland EMEA United Sta US China APAC United Kin EU Mexico LATAM El Salvado LATAM Taiwan APAC Germany EU United Sta US India APAC Dominican LATAM France EU United Sta US Australia APAC United Sta US DemocratiAfrica United Sta US United Sta US United Kin EU Australia APAC Region Product Name Sales Quantity Discount Profit Shipping Cost East Plantronics CS510 - Over-the-Head monaural Wireless Headset System 2309.65 7 0 762. 1845 933.57 Oceania Novimex Executive Leather Armchair, Black 3709.395 9 0.1 -288.765 923.63 Oceania Nokia Smart Phone, with Caller ID 5175. 171 9 0.1 919.971 915.49 Central Motorola Smart Phone, Cordless 2892.51 5 0.1 -96.54 910.16 Africa Sharp Wireless Fax, High-Speed 2832.96 8 0 311.52 903.04 Oceania Samsung Smart Phone, with Caller ID 2862.675 5 0.1 763.275 897.35 Oceania Novimex Executive Leather Armchair, Adjustable 1822.08 4 0 564.84 894.77 Oceania Chromcraft Conference Table, Fully Assembled 5244.84 6 0 996.48 878.38 West Fellowes PB500 Electric Punch Plastic Comb Binding Machine with Manual Bind 5083.96 5 0.2 1906.485 867.69 South Chromcraft Bull-Nose Wood Oval Conference Tables & Bases 4297.644 13 0.4 -1862.312 865.74 South Martin Yale Chadless Opener Electric Letter Opener 4164.05 5 0 83.281000 846.54 Central As Bevis Conference Table, Fully Assembled 4626.15 5 0 647.55 835.57 EMEA Cisco Smart Phone, with Caller ID 2616.96 4 0 1151.4 832.41 South Harbour Creations Executive Leather Armchair, Adjustable 2221.8 7 0 622.02 810.25 North Asia KitchenAid Microwave, White 3701.52 12 0 1036.08 804.54 Central Breville Refrigerator, Red 1869.588 4 0.1 186.948 801.66 South Logitech diNovo Edge Keyboard 2249.91 9 0 517.4793 780.7 South Hoover Stove, Red 7958.58 14 0 3979.08 778.32 Oceania Brother Fax Machine, High-Speed 2565.594 9 0.1 28.403999 766.93 Africa KitchenAid Stove, White 3409.74 6 0 818.28 763.38 EMEA Hon Computer Table, with Bottom Storage 1977.72 4 0 276.84 759.47 Central Apple iPhone 5S 2735.952 6 0.2 341.994 752.51 North Asia SAFCO Executive Leather Armchair, Black 2754 6 0 358.02 752.47 North KitchenAid Refrigerator, Black 5273.7 10 0 1898.4 730.91 North Motorola Smart Phone, Full Size 1713.84 4 0 445.52 728.968 Central Hon Computer Table, Fully Assembled 2106.496 8 0.2 526.496 728.389 North Asia Lesro Conference Table, with Bottom Storage 1715.16 2 0 720.36 725.57 Central Hoover Stove, Red 3069.738 6 0.1 1364.238 725.34 West Apple iPhone 4158.912 8 0.2 363.9048 714.66 Central As Office Star Executive Leather Armchair, Red 1878.72 4 0 582.36 704.08 Caribbean Samsung Smart Phone, VoIP 1696.64 5 0.2 - 148.46 704.056 Central Okidata Inkjet, Wireless 2402.865 9 0.15 763.155 699.55 Central HON 5400 Series Task Chairs for Big and Tall 2453.43 5 0.3 -350.49 690.42 Oceania Breville Stove, Red 2526.93 5 0.1 561.48 689.8 West Bretford Rectangular Conference Table Tops 3610.848 12 0.2 135.4068 683.12 Africa Apple Smart Phone, Full Size 3817.26 6 0 1068.66 678.15 East Ativa V4110MDD Micro-Cut Shredder 2799.96 4 0 1371.9804 675.15 South Cubify CubeX 3D Printer Triple Head Print 7999.98 4 0.5 -3839.990 674.82 North Brother Fax Machine, Laser 4141.02 13 0 1697.67 668.96 Oceania Nokia Smart Phone, with Caller ID 2875.095 5 0.1 511.095 665.27 1 Customer Name State 2 Rick Hansen New York 3 Justin Ritter New South Wales 4 Craig Reiter Queensland 5 Katherine Murray Berlin 6 Rick Hansen Dakar 7 Jim Mitchum New South Wales 8 Toby Swindell Wellington 9 Mick Brown Waikato 10 Jane Waco California 11 Joseph Holt North Carolina 12 Greg Maxwell Virginia 13 Anthony Jacobs Kabul 14 Magdelene Morse Jizan 15 Vicky Freymann Parana 16 Peter Fuller Heilongjiang 17 Ben Peterman Ile-de-France 18 Thomas Boland Kentucky 19 Patrick Jones Tuscany 20 Jim Sink Queensland 21 Ritsa Hightower Kigoma 22 Ann Blume Silesia 23 Sue Ann Reed Illinois 24 Jason Klamczynski Anhui 25 Laurel Beltran Scotland 26 Naresj Patel Chihuahua 27 Valerie Dominguez San Salvador 28 Phillip Breyer Taipei City 29 Eugene Barchas Saxony 30 Karen Ferguson California 31 Benjamin Patterson Gujarat 32 Rick Reed Santo Domingo 33 Bill Shonely Brittany 34 Joel Eaton Texas 35 Dave Poirier Queensland 36 Nora Preis California 37 Aaron Hawkins Katanga 38 Darrin Martin New York 39 Grant Thornton North Carolina 40 Patrick O'Donnell England 41 Dan Lawera Queensland Country Market United Sta US Australia APAC Australia APAC Germany EU Senegal Africa Australia APAC New Zeala APAC New Zeala APAC United Sta US United Sta US United Sta US Afghanista APAC Saudi Arab EMEA Brazil LATAM China APAC France EU United Sta US Italy EU Australia APAC Tanzania Africa Poland EMEA United Sta US China APAC United Kin EU Mexico LATAM El Salvado LATAM Taiwan APAC Germany EU United Sta US India APAC Dominican LATAM France EU United Sta US Australia APAC United Sta US Democrati Africa United Sta US United Sta US United Kin EU Australia APAC Region Product Name Sales Quantity Discount Profit Shipping Cost East Plantronics CS510 - Over-the-Head monaural Wireless Headset System 2309.65 7 0762. 1845 933.57 Oceania Novimex Executive Leather Armchair, Black 3709.395 9 0.1 -288.765 923.63 Oceania Nokia Smart Phone, with Caller ID 5175. 171 9 0.1 919.971 915.49 Central Motorola Smart Phone, Cordless 2892.51 5 0.1 -96.54 910.16 Africa Sharp Wireless Fax, High-Speed 2832.96 8 0 311.52 903.04 Oceania Samsung Smart Phone, with Caller ID 2862.675 5 0.1 763.275 897.35 Oceania Novimex Executive Leather Armchair, Adjustable 1822.08 4 0 564.84 894.77 Oceania Chromcraft Conference Table, Fully Assembled 5244.84 6 0 996.48 878.38 West Fellowes PB500 Electric Punch Plastic Comb Binding Machine with Manual Bind 5083.96 5 0.2 1906.485 867.69 South Chromcraft Bull-Nose Wood Oval Conference Tables & Bases 4297.644 13 0.4 -1862.312 865.74 South Martin Yale Chadless Opener Electric Letter Opener 4164.05 5 0 83.281000 846.54 Central As Bevis Conference Table, Fully Assembled 4626.15 5 0 647.55 835.57 EMEA Cisco Smart Phone, with Caller ID 2616.96 4 0 1151.4 832.41 South Harbour Creations Executive Leather Armchair, Adjustable 2221.8 7 0 622.02 810.25 North Asia KitchenAid Microwave, White 3701.52 12 0 1036.08 804.54 Central Breville Refrigerator, Red 1869.588 4 0.1 186.948 801.66 South Logitech diNovo Edge Keyboard 2249.91 9 0 517.4793 780.7 South Hoover Stove, Red 7958.58 14 0 3979.08 778.32 Oceania Brother Fax Machine, High-Speed 2565.594 9 0.1 28.403999 766.93 Africa KitchenAid Stove, White 3409.74 6 0 818.28 763.38 EMEA Hon Computer Table, with Bottom Storage 1977.72 4 0 276.84 759.47 Central Apple iPhone 55 2735.952 6 0.2 341.994 752.51 North Asia SAFCO Executive Leather Armchair, Black 2754 6 0 358.02 752.47 North KitchenAid Refrigerator, Black 5273.7 10 0 1898.4 730.91 North Motorola Smart Phone, Full Size 1713.84 4 0 445.52 728.968 Central Hon Computer Table, Fully Assembled 2106.496 8 0.2 526.496 728.389 North Asia Lesro Conference Table, with Bottom Storage 1715.16 2 0 720.36 725.57 Central Hoover Stove, Red 3069.738 6 0.1 1364.238 725.34 West Apple iPhone 5 4158.912 8 0.2 363.9048 714.66 Central As Office Star Executive Leather Armchair, Red 1878.72 4 0 582.36 704.08 Caribbean Samsung Smart Phone, VoIP 1696.64 5 0.2 - 148.46 704.056 Central Okidata Inkjet, Wireless 2402.865 9 0.15 763.155 699.55 Central HON 5400 Series Task Chairs for Big and Tall 2453.43 5 0.3 -350.49 690.42 Oceania Breville Stove, Red 2526.93 5 0.1 561.48 689.8 West Bretford Rectangular Conference Table Tops 3610.848 12 0.2 135.4068 683.12 Africa Apple Smart Phone, Full Size 3817.26 6 0 1068.66 678.15 East Ativa V4110MDD Micro-Cut Shredder 2799.96 4 0 1371.9804 675.15 South Cubify CubeX 3D Printer Triple Head Print 7999.98 4 0.5 -3839.990 674.82 North Brother Fax Machine, Laser 4141.02 13 0 1697.67 668.96 Oceania Nokia Smart Phone, with Caller ID 2875.095 5 0.1 511.095 665.27 APAC Joy Bell. Nusa Tenggara Barat Indonesia APAC Barry Franz Haryana India APAC Vivek Grady Kerala India Greg Tran England United Kin EU Zuschuss Carroll Berlin Germany EU Sanjit Chand Minnesota United Sta US Ellis Ballard Ile-de-France France EU Arthur Prichep Shandong China APAC Scott Williamson Jharkhand India APAC John Huston Paysand Uruguay LATAM Lena Creighton New York United Sta US Trudy Glocke Mazandaran Iran EMEA Harold Ryan California United Sta US Phillip Breyer Taipei City Taiwan APAC Deirdre Greer Cidade De Maputo Mozambiq Africa Sheri Gordon Madhya Pradesh India APAC Fred Hopkins Washington United Sta US Guy Phonely Delhi India APAC Mitch Webber Western Australia Australia APAC Patrick O'Brill Florida United Sta US Chuck Sachs Dhaka Banglades APAC Keith Dawkins New York USA US Michael Stewart Lower Saxony Germany EU Kimberly Carter Lower Saxony Germany EU Denny Blanton Jiangsu China APAC Jonathan Doherty Virginia United Sta US Dave Kipp Andalusia Spain EU Cari Sayre Uttarakhand India APAC Evan Minnotte Durango Mexico LATAM Dianna Wilson Kharkiv Ukraine EMEA Alan Schoenberger Shandong APAC Shui Tom Chinandega Nicaragua LATAM Barry Weirich Kasai-Occidental Democrati Africa Laura Armstrong Sumatera Selatan Indonesia APAC Aimee Bixby England United Kin EU John Huston Victoria Australia APAC Christopher Martinez Georgia United Sta US Bobby Elias North Rhine-Westphalia Germany EU Sam Zeldin Sichuan China APAC Raymond Messe West Bengal India APAC Harry Greene Nord-Pas-de-Calais France EU Dave Poirier Mekns - Tafilalet Morocco Africa Southeast Motorola Smart Phone, Full Size 3200.5962 Central As Motorola Smart Phone, with Caller ID 4518.78 Central As Sauder Classic Bookcase, Traditional 5667.87 North Motorola Smart Phone, Cordless 5785.02 Central Cuisinart Stove, Silver 3018.624 Central Ibico EPK-21 Electric Binding System 9449.95 Central Office Star Executive Leather Armchair, Adjustable 2092.5 North Asia Novimex Executive Leather Armchair, Red 2761.2 Central As Konica Inkjet, White 2174.13 South Harbour Creations Executive Leather Armchair, Black 3473.14 East Fellowes PB500 Electric Punch Plastic Comb Binding Machine with Manual Bind 3050.376 EMEA Canon Copy Machine, Color 2108.64 West Hewlett Packard LaserJet 3310 Copier 2399.96 North Asia Safco Classic Bookcase, Pine 2197.5 Africa Motorola Smart Phone, with Caller ID 2582.16 Central As Hewlett Wireless Fax, Color 1526.52 West Canon PC940 Copier 3149.93 Central As Chromcraft Conference Table, with Bottom Storage 1745.34 Oceania Breville Refrigerator, White 4191.507 South Samsung Galaxy Mega 6.3 4367.896 Central As Safco Classic Bookcase, Metal 3063.27 East Zebra ZM400 Thermal Label Printer 4643.8 Central Samsung Smart Phone, Cordless 4473 Central Apple Audio Dock, with Caller ID 1502.01 North Asia SAFCO Executive Leather Armchair, Black 5049 South Honeywell Enviracaire Portable HEPA Air Cleaner for 17' x 22' Room 2104.55 Safco Classic Bookcase, Metal 2188.05 Central As Chromcraft Wood Table, Rectangular 1920.36 North Samsung Smart Phone, Cordless 1704 EMEA Chromcraft Round Table, Rectangular 1858.68 North Asia Harbour Creations Executive Leather Armchair, Adjustable 3298.26 Central Hamilton Beach Microwave, Black 2443.48 Africa Harbour Creations Executive Leather Armchair, Adjustable 3808.8 Southeast Bevis Conference Table, with Bottom Storage 3427.1496 North Nokia Smart Phone, Full Size 3441.69 Oceania Apple Smart Phone, Cordless 2863.35 South Fellowes PB500 Electric Punch Plastic Comb Binding Machine with Manual Bind 6354.95 Central Brother Ink, Color 1487.4 North Asia Sharp Wireless Fax, Digital 3200.04 Central As Novimex Executive Leather Armchair, Red 2301 Central Hon Executive Leather Armchair, Adjustable 5729.346 Africa Canon Wireless Fax, Laser 5301.24 6 7 13 9 7 5 5 6 7 11 3 8 5 5 4 4 7 2 9 13 7 4 7 9 0.17 -77.20379 0 632.52 0 2097.03 0 404.73 0.2 377.244 0 4630.4755 0.1 720.75 0 110.34 0 500.01 0 868.12 0.2 1143.891 0 527.04 0.2 839.986 0 153.75 0 593.88 0 732.72 0 1480.4671 0 226.86 0.1 1164.267 0.2 327.5922 0 581.91 0 2229.024 0 313.11 0 225.18 0 656.37 0 694.5015 0 1050.15 0 652.92 0 119.28 0 130.08 0 1055.25 0 121.94 0 1523.52 0.47 -452.8104 0.1 38.07 0.1 858.9 03177.475 0 728.7 0 1183.95 0 91.95 0.1 63.546000 0 2597.28 660.87 658.69 658.35 656.73 655.91 655.61 652.98 644.75 637.86 634.529 632.05 630.97 630.05 627.27 627.17 625.77 617.92 616.27 614.34 609.44 609.24 607.34 604.4 600.21 595.5 594.02 593.91 592.77 592.726 590.56 589.36 589.293 588.13 586.57 585.25 581.88 581.12 580.98 576.71 573.27 572.95 568.45 South China 11 7 5 4 4 4 7 13 8 7 6 5 5 10 9 5 14 14 A B D E F G H J K L 1 Customer Name State 2 Rick Hansen New York 3 Justin Ritter New South Wales 4 Craig Reiter Queensland 5 Katherine Murray Berlin 6 Rick Hansen Dakar 7 Jim Mitchum New South Wales 8 Toby Swindell Wellington 9 Mick Brown Waikato 10 Jane Waco California 11 Joseph Holt North Carolina 12 Greg Maxwell Virginia 13 Anthony Jacobs Kabul 14 Magdelene Morse Jizan 15 Vicky Freymann Parana 16 Peter Fuller Heilongjiang 17 Ben Peterman Ile-de-France 18 Thomas Boland Kentucky 19 Patrick Jones Tuscany 20 Jim Sink Queensland 21 Ritsa Hightower 22 Ann Blume Silesia 23 Sue Ann Reed Illinois 24 Jason Klamczynski Anhui 25 Laurel Beltran Scotland 26 Naresj Patel Chihuahua 27 Valerie Dominguez San Salvador 28 Phillip Breyer Taipei City 29 Eugene Barchas Saxony 30 Karen Ferguson California 31 Benjamin Patterson Gujarat 32 Rick Reed Santo Domingo 33 Bill Shonely Brittany 34 Joel Eaton Texas 35 Dave Poirier Queensland 36 Nora Preis California 37 Aaron Hawkins Katanga 38 Darrin Martin New York 39 Grant Thornton North Carolina 40 Patrick O'Donnell England 41 Dan Lawera Queensland Kigoma Country Market United Sta US Australia APAC Australia APAC Germany EU Senegal Africa Australia APAC New Zeala APAC New Zeala APAC United Sta US United Sta US United Sta US Afghanista APAC Saudi Arab EMEA Brazil LATAM China APAC France EU United Sta US Italy EU Australia APAC Tanzania Africa Poland EMEA United Sta US China APAC United Kin EU Mexico LATAM El Salvado LATAM Taiwan APAC Germany EU United Sta US India APAC Dominican LATAM France EU United Sta US Australia APAC United Sta US DemocratiAfrica United Sta US United Sta US United Kin EU Australia APAC Region Product Name Sales Quantity Discount Profit Shipping Cost East Plantronics CS510 - Over-the-Head monaural Wireless Headset System 2309.65 7 0 762. 1845 933.57 Oceania Novimex Executive Leather Armchair, Black 3709.395 9 0.1 -288.765 923.63 Oceania Nokia Smart Phone, with Caller ID 5175. 171 9 0.1 919.971 915.49 Central Motorola Smart Phone, Cordless 2892.51 5 0.1 -96.54 910.16 Africa Sharp Wireless Fax, High-Speed 2832.96 8 0 311.52 903.04 Oceania Samsung Smart Phone, with Caller ID 2862.675 5 0.1 763.275 897.35 Oceania Novimex Executive Leather Armchair, Adjustable 1822.08 4 0 564.84 894.77 Oceania Chromcraft Conference Table, Fully Assembled 5244.84 6 0 996.48 878.38 West Fellowes PB500 Electric Punch Plastic Comb Binding Machine with Manual Bind 5083.96 5 0.2 1906.485 867.69 South Chromcraft Bull-Nose Wood Oval Conference Tables & Bases 4297.644 13 0.4 -1862.312 865.74 South Martin Yale Chadless Opener Electric Letter Opener 4164.05 5 0 83.281000 846.54 Central As Bevis Conference Table, Fully Assembled 4626.15 5 0 647.55 835.57 EMEA Cisco Smart Phone, with Caller ID 2616.96 4 0 1151.4 832.41 South Harbour Creations Executive Leather Armchair, Adjustable 2221.8 7 0 622.02 810.25 North Asia KitchenAid Microwave, White 3701.52 12 0 1036.08 804.54 Central Breville Refrigerator, Red 1869.588 4 0.1 186.948 801.66 South Logitech diNovo Edge Keyboard 2249.91 9 0 517.4793 780.7 South Hoover Stove, Red 7958.58 14 0 3979.08 778.32 Oceania Brother Fax Machine, High-Speed 2565.594 9 0.1 28.403999 766.93 Africa KitchenAid Stove, White 3409.74 6 0 818.28 763.38 EMEA Hon Computer Table, with Bottom Storage 1977.72 4 0 276.84 759.47 Central Apple iPhone 5S 2735.952 6 0.2 341.994 752.51 North Asia SAFCO Executive Leather Armchair, Black 2754 6 0 358.02 752.47 North KitchenAid Refrigerator, Black 5273.7 10 0 1898.4 730.91 North Motorola Smart Phone, Full Size 1713.84 4 0 445.52 728.968 Central Hon Computer Table, Fully Assembled 2106.496 8 0.2 526.496 728.389 North Asia Lesro Conference Table, with Bottom Storage 1715.16 2 0 720.36 725.57 Central Hoover Stove, Red 3069.738 6 0.1 1364.238 725.34 West Apple iPhone 4158.912 8 0.2 363.9048 714.66 Central As Office Star Executive Leather Armchair, Red 1878.72 4 0 582.36 704.08 Caribbean Samsung Smart Phone, VoIP 1696.64 5 0.2 - 148.46 704.056 Central Okidata Inkjet, Wireless 2402.865 9 0.15 763.155 699.55 Central HON 5400 Series Task Chairs for Big and Tall 2453.43 5 0.3 -350.49 690.42 Oceania Breville Stove, Red 2526.93 5 0.1 561.48 689.8 West Bretford Rectangular Conference Table Tops 3610.848 12 0.2 135.4068 683.12 Africa Apple Smart Phone, Full Size 3817.26 6 0 1068.66 678.15 East Ativa V4110MDD Micro-Cut Shredder 2799.96 4 0 1371.9804 675.15 South Cubify CubeX 3D Printer Triple Head Print 7999.98 4 0.5 -3839.990 674.82 North Brother Fax Machine, Laser 4141.02 13 0 1697.67 668.96 Oceania Nokia Smart Phone, with Caller ID 2875.095 5 0.1 511.095 665.27 1 Customer Name State 2 Rick Hansen New York 3 Justin Ritter New South Wales 4 Craig Reiter Queensland 5 Katherine Murray Berlin 6 Rick Hansen Dakar 7 Jim Mitchum New South Wales 8 Toby Swindell Wellington 9 Mick Brown Waikato 10 Jane Waco California 11 Joseph Holt North Carolina 12 Greg Maxwell Virginia 13 Anthony Jacobs Kabul 14 Magdelene Morse Jizan 15 Vicky Freymann Parana 16 Peter Fuller Heilongjiang 17 Ben Peterman Ile-de-France 18 Thomas Boland Kentucky 19 Patrick Jones Tuscany 20 Jim Sink Queensland 21 Ritsa Hightower Kigoma 22 Ann Blume Silesia 23 Sue Ann Reed Illinois 24 Jason Klamczynski Anhui 25 Laurel Beltran Scotland 26 Naresj Patel Chihuahua 27 Valerie Dominguez San Salvador 28 Phillip Breyer Taipei City 29 Eugene Barchas Saxony 30 Karen Ferguson California 31 Benjamin Patterson Gujarat 32 Rick Reed Santo Domingo 33 Bill Shonely Brittany 34 Joel Eaton Texas 35 Dave Poirier Queensland 36 Nora Preis California 37 Aaron Hawkins Katanga 38 Darrin Martin New York 39 Grant Thornton North Carolina 40 Patrick O'Donnell England 41 Dan Lawera Queensland Country Market United Sta US Australia APAC Australia APAC Germany EU Senegal Africa Australia APAC New Zeala APAC New Zeala APAC United Sta US United Sta US United Sta US Afghanista APAC Saudi Arab EMEA Brazil LATAM China APAC France EU United Sta US Italy EU Australia APAC Tanzania Africa Poland EMEA United Sta US China APAC United Kin EU Mexico LATAM El Salvado LATAM Taiwan APAC Germany EU United Sta US India APAC Dominican LATAM France EU United Sta US Australia APAC United Sta US Democrati Africa United Sta US United Sta US United Kin EU Australia APAC Region Product Name Sales Quantity Discount Profit Shipping Cost East Plantronics CS510 - Over-the-Head monaural Wireless Headset System 2309.65 7 0762. 1845 933.57 Oceania Novimex Executive Leather Armchair, Black 3709.395 9 0.1 -288.765 923.63 Oceania Nokia Smart Phone, with Caller ID 5175. 171 9 0.1 919.971 915.49 Central Motorola Smart Phone, Cordless 2892.51 5 0.1 -96.54 910.16 Africa Sharp Wireless Fax, High-Speed 2832.96 8 0 311.52 903.04 Oceania Samsung Smart Phone, with Caller ID 2862.675 5 0.1 763.275 897.35 Oceania Novimex Executive Leather Armchair, Adjustable 1822.08 4 0 564.84 894.77 Oceania Chromcraft Conference Table, Fully Assembled 5244.84 6 0 996.48 878.38 West Fellowes PB500 Electric Punch Plastic Comb Binding Machine with Manual Bind 5083.96 5 0.2 1906.485 867.69 South Chromcraft Bull-Nose Wood Oval Conference Tables & Bases 4297.644 13 0.4 -1862.312 865.74 South Martin Yale Chadless Opener Electric Letter Opener 4164.05 5 0 83.281000 846.54 Central As Bevis Conference Table, Fully Assembled 4626.15 5 0 647.55 835.57 EMEA Cisco Smart Phone, with Caller ID 2616.96 4 0 1151.4 832.41 South Harbour Creations Executive Leather Armchair, Adjustable 2221.8 7 0 622.02 810.25 North Asia KitchenAid Microwave, White 3701.52 12 0 1036.08 804.54 Central Breville Refrigerator, Red 1869.588 4 0.1 186.948 801.66 South Logitech diNovo Edge Keyboard 2249.91 9 0 517.4793 780.7 South Hoover Stove, Red 7958.58 14 0 3979.08 778.32 Oceania Brother Fax Machine, High-Speed 2565.594 9 0.1 28.403999 766.93 Africa KitchenAid Stove, White 3409.74 6 0 818.28 763.38 EMEA Hon Computer Table, with Bottom Storage 1977.72 4 0 276.84 759.47 Central Apple iPhone 55 2735.952 6 0.2 341.994 752.51 North Asia SAFCO Executive Leather Armchair, Black 2754 6 0 358.02 752.47 North KitchenAid Refrigerator, Black 5273.7 10 0 1898.4 730.91 North Motorola Smart Phone, Full Size 1713.84 4 0 445.52 728.968 Central Hon Computer Table, Fully Assembled 2106.496 8 0.2 526.496 728.389 North Asia Lesro Conference Table, with Bottom Storage 1715.16 2 0 720.36 725.57 Central Hoover Stove, Red 3069.738 6 0.1 1364.238 725.34 West Apple iPhone 5 4158.912 8 0.2 363.9048 714.66 Central As Office Star Executive Leather Armchair, Red 1878.72 4 0 582.36 704.08 Caribbean Samsung Smart Phone, VoIP 1696.64 5 0.2 - 148.46 704.056 Central Okidata Inkjet, Wireless 2402.865 9 0.15 763.155 699.55 Central HON 5400 Series Task Chairs for Big and Tall 2453.43 5 0.3 -350.49 690.42 Oceania Breville Stove, Red 2526.93 5 0.1 561.48 689.8 West Bretford Rectangular Conference Table Tops 3610.848 12 0.2 135.4068 683.12 Africa Apple Smart Phone, Full Size 3817.26 6 0 1068.66 678.15 East Ativa V4110MDD Micro-Cut Shredder 2799.96 4 0 1371.9804 675.15 South Cubify CubeX 3D Printer Triple Head Print 7999.98 4 0.5 -3839.990 674.82 North Brother Fax Machine, Laser 4141.02 13 0 1697.67 668.96 Oceania Nokia Smart Phone, with Caller ID 2875.095 5 0.1 511.095 665.27 APAC Joy Bell. Nusa Tenggara Barat Indonesia APAC Barry Franz Haryana India APAC Vivek Grady Kerala India Greg Tran England United Kin EU Zuschuss Carroll Berlin Germany EU Sanjit Chand Minnesota United Sta US Ellis Ballard Ile-de-France France EU Arthur Prichep Shandong China APAC Scott Williamson Jharkhand India APAC John Huston Paysand Uruguay LATAM Lena Creighton New York United Sta US Trudy Glocke Mazandaran Iran EMEA Harold Ryan California United Sta US Phillip Breyer Taipei City Taiwan APAC Deirdre Greer Cidade De Maputo Mozambiq Africa Sheri Gordon Madhya Pradesh India APAC Fred Hopkins Washington United Sta US Guy Phonely Delhi India APAC Mitch Webber Western Australia Australia APAC Patrick O'Brill Florida United Sta US Chuck Sachs Dhaka Banglades APAC Keith Dawkins New York USA US Michael Stewart Lower Saxony Germany EU Kimberly Carter Lower Saxony Germany EU Denny Blanton Jiangsu China APAC Jonathan Doherty Virginia United Sta US Dave Kipp Andalusia Spain EU Cari Sayre Uttarakhand India APAC Evan Minnotte Durango Mexico LATAM Dianna Wilson Kharkiv Ukraine EMEA Alan Schoenberger Shandong APAC Shui Tom Chinandega Nicaragua LATAM Barry Weirich Kasai-Occidental Democrati Africa Laura Armstrong Sumatera Selatan Indonesia APAC Aimee Bixby England United Kin EU John Huston Victoria Australia APAC Christopher Martinez Georgia United Sta US Bobby Elias North Rhine-Westphalia Germany EU Sam Zeldin Sichuan China APAC Raymond Messe West Bengal India APAC Harry Greene Nord-Pas-de-Calais France EU Dave Poirier Mekns - Tafilalet Morocco Africa Southeast Motorola Smart Phone, Full Size 3200.5962 Central As Motorola Smart Phone, with Caller ID 4518.78 Central As Sauder Classic Bookcase, Traditional 5667.87 North Motorola Smart Phone, Cordless 5785.02 Central Cuisinart Stove, Silver 3018.624 Central Ibico EPK-21 Electric Binding System 9449.95 Central Office Star Executive Leather Armchair, Adjustable 2092.5 North Asia Novimex Executive Leather Armchair, Red 2761.2 Central As Konica Inkjet, White 2174.13 South Harbour Creations Executive Leather Armchair, Black 3473.14 East Fellowes PB500 Electric Punch Plastic Comb Binding Machine with Manual Bind 3050.376 EMEA Canon Copy Machine, Color 2108.64 West Hewlett Packard LaserJet 3310 Copier 2399.96 North Asia Safco Classic Bookcase, Pine 2197.5 Africa Motorola Smart Phone, with Caller ID 2582.16 Central As Hewlett Wireless Fax, Color 1526.52 West Canon PC940 Copier 3149.93 Central As Chromcraft Conference Table, with Bottom Storage 1745.34 Oceania Breville Refrigerator, White 4191.507 South Samsung Galaxy Mega 6.3 4367.896 Central As Safco Classic Bookcase, Metal 3063.27 East Zebra ZM400 Thermal Label Printer 4643.8 Central Samsung Smart Phone, Cordless 4473 Central Apple Audio Dock, with Caller ID 1502.01 North Asia SAFCO Executive Leather Armchair, Black 5049 South Honeywell Enviracaire Portable HEPA Air Cleaner for 17' x 22' Room 2104.55 Safco Classic Bookcase, Metal 2188.05 Central As Chromcraft Wood Table, Rectangular 1920.36 North Samsung Smart Phone, Cordless 1704 EMEA Chromcraft Round Table, Rectangular 1858.68 North Asia Harbour Creations Executive Leather Armchair, Adjustable 3298.26 Central Hamilton Beach Microwave, Black 2443.48 Africa Harbour Creations Executive Leather Armchair, Adjustable 3808.8 Southeast Bevis Conference Table, with Bottom Storage 3427.1496 North Nokia Smart Phone, Full Size 3441.69 Oceania Apple Smart Phone, Cordless 2863.35 South Fellowes PB500 Electric Punch Plastic Comb Binding Machine with Manual Bind 6354.95 Central Brother Ink, Color 1487.4 North Asia Sharp Wireless Fax, Digital 3200.04 Central As Novimex Executive Leather Armchair, Red 2301 Central Hon Executive Leather Armchair, Adjustable 5729.346 Africa Canon Wireless Fax, Laser 5301.24 6 7 13 9 7 5 5 6 7 11 3 8 5 5 4 4 7 2 9 13 7 4 7 9 0.17 -77.20379 0 632.52 0 2097.03 0 404.73 0.2 377.244 0 4630.4755 0.1 720.75 0 110.34 0 500.01 0 868.12 0.2 1143.891 0 527.04 0.2 839.986 0 153.75 0 593.88 0 732.72 0 1480.4671 0 226.86 0.1 1164.267 0.2 327.5922 0 581.91 0 2229.024 0 313.11 0 225.18 0 656.37 0 694.5015 0 1050.15 0 652.92 0 119.28 0 130.08 0 1055.25 0 121.94 0 1523.52 0.47 -452.8104 0.1 38.07 0.1 858.9 03177.475 0 728.7 0 1183.95 0 91.95 0.1 63.546000 0 2597.28 660.87 658.69 658.35 656.73 655.91 655.61 652.98 644.75 637.86 634.529 632.05 630.97 630.05 627.27 627.17 625.77 617.92 616.27 614.34 609.44 609.24 607.34 604.4 600.21 595.5 594.02 593.91 592.77 592.726 590.56 589.36 589.293 588.13 586.57 585.25 581.88 581.12 580.98 576.71 573.27 572.95 568.45 South China 11 7 5 4 4 4 7 13 8 7 6 5 5 10 9 5 14 14Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started