Fluent Essays

From the file “CanadianSalesData.xlsx”, generate the following ten results using pivot tables IDS 200 Spring 2021 Assignment 4 Due Friday 4/2/2021 45 points Instructions Deadline In order to receive full credit, this assignment must be submitted by Friday, April 2nd at 11:59pm. Submitting your assignment early is recommended. Late submissions will be accepted (but penalized 15pts) up to one week after the submission deadline. After that, assignments will not be accepted. Assignment From the file “CanadianSalesData.xlsx”, generate the following ten results using pivot tables. Each pivot table should appear on a separate worksheet. Within each pivot table, the cell(s) containing the required information should be highlighted, preferably in light orange. In the highlight tab, the theme colors block has “Orange, Accent 2, Lighter 60%” – you can hover your cursor over colors to see their names. But if you have trouble figuring it out, any non-obnoxious light color shade for highlighting is fine. 1) Show the sum of Sales for Product Category = Furniture and Province = Manitoba 2) Show the sum of Sales for Region = Prairie and Province = Manitoba, separately for each month from 1/2019 to 12/2019 (use Ship Date) 3) Show the 5 customers who have the highest sum of Sales during 2018 (use Order Date) 4) Show all orders (use Order ID) where Sales > $500 and the Product Category is Office Supplies 5) From the Province with the highest sum of Sales, show the three Product Sub-Categories with the highest sum of Sales 6) Show the average Sales value for each combination of Province and Order Priority 7) Show the average Sales value for each combination of Ship Mode and Customer Segment 8) Show the sum of Sales for each Province, separately for each month from 2/2020 to 8/2020 (use Ship Date) 9) For the entire year 2019, show each Province’s sum of Sales as a percentage of the sum of all Sales during the year (use Order Date) 10) Show the 5 largest Order Quantities where Product Container = Jumbo Box and Customer Segment = Corporate Sheet1 Row ID Order ID Order Date Order Priority Order Quantity Sales Discount Ship Mode Profit Unit Price Shipping Cost Customer Name Province Region Customer Segment Product Category Product Sub-Category Product Name Product Container Product Base Margin Ship Date 1 3 10/11/18 Low 6 261.54 0.04 Regular Air -213.25 38.94 35 Rosemarie Orkney Nunavut Nunavut Small Business Office Supplies Storage & Organization Eldon Base for stackable storage shelf, platinum Large Box 0.8 10/18/18 2 6 2/18/20 Not Specified 2 6.93 0.01 Regular Air -4.64 2.08 2.56 Sandra Broggetti Alberta West Corporate Office Supplies Scissors, Rulers and Trimmers Kleencut® Forged Office Shears by Acme United Corporation Small Pack 0.55 2/19/20 6 32 7/13/19 High 15 140.56 0.04 Regular Air -128.38 8.46 8.99 Leoine Reaman Saskatchewan Prairie Corporate Technology Computer Peripherals Imation 3.5 IBM Diskettes, 10/Box Small Pack 0.79 7/14/19 3 32 7/13/19 High 26 2808.08 0.07 Regular Air 1054.82 107.53 5.81 Maurie Domelow Alberta West Corporate Furniture Office Furnishings Tenex Contemporary Contur Chairmats for Low and Medium Pile Carpet, Computer, 39" x 49" Medium Box 0.65 7/15/19 4 32 7/13/19 High 24 1761.4 0.09 Delivery Truck -1748.56 70.89 89.3 Cinderella Radsdale Alberta West Corporate Furniture Tables KI Conference Tables Jumbo Box 0.72 7/14/19 5 32 7/13/19 High 23 160.2335 0.04 Regular Air -85.13 7.99 5.03 Maribel Ilieve Alberta West Corporate Technology Telephones and Communication Bell Sonecor JB700 Caller ID Medium Box 0.6 7/15/19 7 35 10/20/19 Not Specified 30 288.56 0.03 Regular Air 60.72 9.11 2.25 Kerwin Coaten British Columbia West Corporate Office Supplies Pens & Art Supplies Dixon Ticonderoga Core-Lock Colored Pencils Wrap Bag 0.52 10/21/19 8 35 10/20/19 Not Specified 14 1892.848 0.01 Regular Air 48.99 155.99 8.99 Rosemarie Orkney British Columbia West Corporate Technology Telephones and Communication CF 688 Small Box 0.58 10/22/19 9 36 10/31/19 Critical 46 2484.7455 0.1 Regular Air 657.48 65.99 4.2 Horatia Voyce Alberta West Home Office Technology Telephones and Communication 6162i Small Box 0.55 10/31/19 10 65 3/15/19 Critical 32 3812.73 0.02 Regular Air 1470.30 115.79 1.99 Sergio Nudds Ontario Ontario Corporate Technology Computer Peripherals Verbatim DVD-R, 4.7GB, Spindle, WE, Blank, Ink Jet/Thermal, 20/Spindle Small Pack 0.49 3/16/19 11 66 1/17/17 Low 41 108.15 0.09 Regular Air 7.57 2.88 0.7 Milicent Worthing Alberta West Consumer Office Supplies Pens & Art Supplies Newell 340 Wrap Bag 0.56 1/17/17 12 69 6/1/17 Not Specified 42 1186.06 0.09 Regular Air 511.69 30.93 3.92 Beltran Heyball Saskatchewan Prairie Corporate Furniture Office Furnishings Advantus Employee of the Month Certificate Frame, 11 x 13-1/2 Small Pack 0.44 6/3/17 13 69 6/1/17 Not Specified 28 51.53 0.03 Express Air 0.35 1.68 0.7 Sammy Balmforth Saskatchewan Prairie Corporate Office Supplies Pens & Art Supplies Newell 308 Wrap Bag 0.6 6/3/17 14 70 12/15/18 Low 48 90.05 0.03 Regular Air -107.00 1.86 2.58 Dorelle Idenden Quebec Quebec Home Office Office Supplies Rubber Bands Super Bands, 12/Pack Wrap Bag 0.82 12/20/18 15 70 12/15/18 Low 46 7804.53 0.05 Regular Air 2057.17 205.99 5.99 Wanda Heathcott Quebec Quebec Home Office Technology Telephones and Communication 3285 Small Box 0.59 12/20/18 16 96 4/14/17 High 37 4158.1235 0.01 Regular Air 1228.89 125.99 8.99 Ode Mallard Manitoba Prairie Home Office Technology Telephones and Communication SC7868i Small Box 0.55 4/16/17 17 97 1/26/18 Medium 26 75.57 0.03 Regular Air 28.24 2.89 0.5 Earvin Eccott Yukon Yukon Consumer Office Supplies Labels Avery 498 Small Box 0.38 1/27/18 18 129 11/16/20 Low 4 32.72 0.09 Regular Air -22.59 6.48 8.19 Jenn Gainsburgh Ontario Ontario Corporate Office Supplies Paper Xerox 217 Small Box 0.37 11/25/20 19 130 5/5/20 High 3 461.89 0.05 Express Air -309.82 150.98 13.99 Katee Giggie Saskatchewan Prairie Corporate Technology Office Machines Canon MP41DH Printing Calculator Medium Box 0.38 5/7/20 20 130 5/5/20 High 29 575.11 0.02 Regular Air 71.75 18.97 9.03 Cristina Fewlass Saskatchewan Prairie Corporate Office Supplies Paper Computer Printout Paper with Letter-Trim Perforations Small Box 0.37 5/6/20 21 130 5/5/20 High 23 236.46 0.05 Regular Air -134.31 9.71 9.45 Stanton Matei Saskatchewan Prairie Corporate Office Supplies Storage & Organization Filing/Storage Totes and Swivel Casters Small Box 0.6 5/8/20 23 132 6/8/18 Medium 30 4011.65 0.05 Delivery Truck -603.80 130.98 54.74 Jeri Dilleston Nova Scotia Atlantic Consumer Furniture Bookcases O'Sullivan Elevations Bookcase, Cherry Finish Jumbo Box 0.69 6/11/18 22 132 6/8/18 Medium 27 192.814 0.03 Regular Air -86.20 7.99 5.03 Livvie Nesterov Quebec Quebec Consumer Technology Telephones and Communication Bell Sonecor JB700 Caller ID Medium Box 0.6 6/9/18 24 134 4/28/20 Not Specified 11 1132.6 0.01 Regular Air -310.21 95.99 35 Mari Gossop Ontario Ontario Home Office Office Supplies Storage & Organization Safco Industrial Wire Shelving Large Box 4/30/20 25 135 10/18/19 Not Specified 25 125.85 0.09 Regular Air -89.25 4.98 4.62 Natalie Hasnney Quebec Quebec Consumer Technology Computer Peripherals Imation 3.5", DISKETTE 44766 HGHLD3.52HD/FM, 10/Pack Small Pack 0.64 10/20/19 26 166 9/9/19 High 10 567.936 0.02 Express Air -126.09 65.99 8.99 Elihu Spaice Manitoba Prairie Consumer Technology Telephones and Communication i270 Small Box 0.55 9/11/19 27 193 8/5/18 Critical 14 174.89 0.06 Regular Air -37.04 12.44 6.27 Zsazsa McCarver Quebec Quebec Consumer Office Supplies Storage & Organization Eldon Simplefile® Box Office® Medium Box 0.57 8/7/18 28 194 4/2/20 Medium 49 329.03 0.1 Regular Air -197.25 7.28 7.98 Waly Androletti Alberta West Corporate Furniture Office Furnishings Master Caster Door Stop, Large Neon Orange Wrap Bag 0.42 4/4/20 29 194 4/2/20 Medium 6 20.19 0.04 Regular Air -13.44 3.14 1.92 Maddy Poulden Alberta West Corporate Office Supplies Scissors, Rulers and Trimmers Serrated Blade or Curved Handle Hand Letter Openers Wrap Bag 0.84 4/4/20 30 195 12/25/18 Medium 34 1315.74 0.03 Regular Air 260.87 36.55 13.89 Adelaide Dax Yukon Yukon Home Office Office Supplies Pens & Art Supplies Dixon Ticonderoga Core-Lock Colored Pencils, 48-Color Set Wrap Bag 0.41 12/27/18 31 197 4/4/19 High 23 310.52 0.01 Regular Air 33.22 12.98 3.14 Merrielle Scrimshire Manitoba Prairie Home Office Office Supplies Scissors, Rulers and Trimmers Acme® 8" Straight Scissors Small Pack 0.6 4/6/19 32 224 6/15/17 Not Specified 25 184.86 0.09 Regular Air -33.95 7.38 5.21 Granville Frickey Yukon Yukon Corporate Furniture Office Furnishings Eldon® Expressions™ Wood Desk Accessories, Oak Small Box 0.56 6/16/17 33 224 6/15/17 Not Specified 44 267.85 0.04 Regular Air -65.43 5.98 5.15 Petr Jimeno Yukon Yukon Corporate Office Supplies Paper Xerox 193 Small Box 0.36 6/16/17 34 224 6/15/17 Not Specified 33 528.5 0.04 Regular Air -149.92 15.42 10.68 Barby Noades Yukon Yukon Corporate Office Supplies Storage & Organization Decoflex Hanging Personal Folder File, Blue Small Box 0.58 6/16/17 35 225 5/22/19 Critical 24 126.58 0.06 Regular Air 18.27 5.58 0.7 Iseabal Di Angelo Quebec Quebec Home Office Office Supplies Pens & Art Supplies Newell 314 Wrap Bag 0.6 5/23/19 36 225 5/22/19 Critical 1 23.7 0.05 Regular Air -8.97 19.84 4.1 Rancell Altree Quebec Quebec Home Office Office Supplies Pens & Art Supplies Prismacolor Color Pencil Set Wrap Bag 0.44 5/24/19 37 229 12/26/18 Critical 43 586.11 0.11 Regular Air 98.44 12.64 4.98 Ruperta Baccup Nova Scotia Atlantic Consumer Furniture Office Furnishings Nu-Dell Executive Frame Small Pack 0.48 12/28/18 38 229 12/26/18 Critical 24 599.1 0.02 Regular Air 3.82 24.92 12.98 Darb Binton Saskatchewan Prairie Consumer Office Supplies Binders and Binder Accessories GBC Standard Therm-A-Bind Covers Small Box 0.39 12/27/18 39 230 10/24/18 Critical 47 2029.75 0.06 Regular Air 320.37 43.98 8.99 Morton Castells Ontario Ontario Corporate Office Supplies Pens & Art Supplies Boston 1645 Deluxe Heavier-Duty Electric Pencil Sharpener Small Pack 0.58 10/26/18 40 230 10/24/18 Critical 11 1118.396 0.06 Regular Air -212.33 125.99 8.08 Gideon Barke Ontario Ontario Corporate Technology Telephones and Communication StarTAC ST7762 Small Box 0.57 10/26/18 41 231 9/26/17 High 2 689.74 0.06 Regular Air -490.84 363.25 19.99 Henry Rosenblatt Manitoba Prairie Small Business Office Supplies Appliances Hoover WindTunnel™ Plus Canister Vacuum Small Box 0.57 9/28/17 42 258 12/26/18 Critical 21 154.35 0 Regular Air -91.14 6.48 8.74 Gasparo Viall Nova Scotia Atlantic Home Office Office Supplies Paper Xerox 1984 Small Box 0.36 12/28/18 43 258 12/26/18 Critical 7 201.36 0 Delivery Truck -284.40 20.98 53.03 Dante Rehme Nova Scotia Atlantic Home Office Office Supplies Storage & Organization Tennsco Lockers, Gray Jumbo Drum 0.78 12/27/18 44 258 12/26/18 Critical 33 216.77 0.02 Regular Air -55.11 6.54 5.27 Moises Leuchars Quebec Quebec Home Office Office Supplies Binders and Binder Accessories Wilson Jones® Four-Pocket Poly Binders Small Box 0.36 12/28/18 45 261 6/26/18 Medium 47 5677.609 0.04 Regular Air 1680.79 140.99 4.2 Yanaton Bison British Columbia West Small Business Technology Telephones and Communication 7160 Small Box 0.59 6/27/18 46 263 5/14/17 High 25 136.77 0.09 Regular Air -136.25 5.4 7.78 Erika Wilkerson Yukon Yukon Corporate Office Supplies Binders and Binder Accessories 3M Organizer Strips Small Box 0.37 5/15/17 47 290 1/3/17 Not Specified 24 188.73 0.05 Regular Air -32.48 7.64 5.83 Meier Bumphrey Quebec Quebec Home Office Office Supplies Paper Rediform Wirebound "Phone Memo" Message Book, 11 x 5-3/4 Wrap Bag 0.36 1/4/17 48 292 1/10/20 High 43 412.62 0.08 Regular Air 175.54 9.9 1.39 Rex Haszard Saskatchewan Prairie Consumer Office Supplies Envelopes #6 3/4 Gummed Flap White Envelopes Small Box 0.37 1/11/20 49 293 9/29/20 High 49 10123.02 0.07 Delivery Truck 457.81 208.16 68.02 Samara Jimson Nunavut Nunavut Consumer Office Supplies Appliances 1.7 Cubic Foot Compact "Cube" Office Refrigerators Jumbo Drum 0.58 9/30/20 50 293 9/29/20 High 27 244.57 0.01 Regular Air 46.71 8.69 2.99 Bernelle Afonso Nunavut Nunavut Consumer Office Supplies Binders and Binder Accessories Cardinal Slant-D® Ring Binder, Heavy Gauge Vinyl Small Box 0.39 10/1/20 51 294 7/13/18 Medium 35 6375.28 0.06 Regular Air 489.02 193.17 19.99 Lulu Dyson British Columbia West Home Office Office Supplies Storage & Organization Fellowes Staxonsteel® Drawer Files Small Box 0.71 7/14/18 52 322 3/16/20 Critical 20 2634.8555 0.08 Regular Air 257.76 155.99 8.08 Sauveur Bowmen British Columbia West Corporate Technology Telephones and Communication I888 World Phone Small Box 0.6 3/18/20 53 322 3/16/20 Critical 46 281 0.1 Regular Air -291.59 6.48 10.05 Lesley Beetham British Columbia West Corporate Office Supplies Paper Xerox 1997 Small Box 0.37 3/18/20 54 323 3/23/17 Critical 20 108.09 0.07 Regular Air 25.76 5.68 1.39 Hewet Goodreid Yukon Yukon Small Business Office Supplies Envelopes Staples Standard Envelopes Small Box 0.38 3/25/17 55 323 3/23/17 Critical 2 55.34 0.06 Regular Air -31.24 22.84 11.54 Cosmo Lethley Yukon Yukon Small Business Office Supplies Paper Xerox 1964 Small Box 0.39 3/25/17 56 324 3/17/20 Critical 25 3872.634 0.02 Regular Air 667.33 179.99 13.99 Erika Height Saskatchewan Prairie Small Business Technology Telephones and Communication VTech VT20-2481 2.4GHz Two-Line Phone System w/Answering Machine Medium Box 0.57 3/19/20 57 325 10/14/18 Low 9 884.1275 0.06 Regular Air -178.71 115.99 4.23 Napoleon Rivilis Nova Scotia Atlantic Corporate Technology Telephones and Communication 282 Small Box 0.56 10/18/18 58 326 6/1/19 High 34 218.27 0.03 Regular Air -44.14 5.99 4.92 Jethro Sidaway Quebec Quebec Consumer Office Supplies Binders and Binder Accessories DXL™ Angle-View Binders with Locking Rings, Black Small Box 0.38 6/2/19 59 326 6/1/19 High 17 100.95 0.05 Regular Air -21.30 5.81 3.37 Blinnie Fass Quebec Quebec Consumer Office Supplies Rubber Bands Advantus Push Pins, Aluminum Head Wrap Bag 0.54 6/2/19 60 353 12/28/18 Low 21 46.94 0.02 Regular Air 3.88 2.21 1 Rebe Hanwright Yukon Yukon Home Office Office Supplies Pens & Art Supplies Quartet Alpha® White Chalk, 12/Pack Wrap Bag 0.38 3/30/19 61 355 6/11/17 Low 16 1239.6315 0 Regular Air -172.55 85.99 0.99 Sidonia Wrenn Ontario Ontario Small Business Technology Telephones and Communication Accessory4 Wrap Bag 0.85 6/16/17 62 358 9/17/18 High 33 1640.9 0.02 Delivery Truck -1348.06 48.58 54.11 Tremayne Edds Alberta West Corporate Furniture Bookcases O'Sullivan 2-Shelf Heavy-Duty Bookcases Jumbo Box 0.69 9/19/18 63 358 9/17/18 High 33 1235.87 0.07 Regular Air 269.27 39.48 1.99 Rock Brabyn Alberta West Corporate Technology Computer Peripherals 80 Minute CD-R Spindle, 100/Pack - Staples Small Pack 0.54 9/17/18 64 359 12/16/17 Medium 30 3659.66 0.08 Delivery Truck -500.38 124.49 51.94 Dur Lilburn Alberta West Corporate Furniture Tables Bevis 36 x 72 Conference Tables Jumbo Box 0.63 12/17/17 65 384 2/29/20 Low 50 7666.04 0.02 Delivery Truck -1820.84 146.05 80.2 Nolan Joskowicz Alberta West Corporate Furniture Tables BPI Conference Tables Jumbo Box 0.71 3/7/20 66 386 1/22/19 High 4 14.96 0.02 Regular Air -0.03 3.69 0.5 Ollie Gairdner Ontario Ontario Corporate Office Supplies Labels Avery 501 Small Box 0.38 1/24/19 67 386 1/22/19 High 4 15.69 0.09 Regular Air -1.59 3.85 0.7 Merrick Doleman Ontario Ontario Corporate Office Supplies Pens & Art Supplies Avery Hi-Liter Pen Style Six-Color Fluorescent Set Wrap Bag 0.44 1/24/19 68 388 12/13/20 Not Specified 46 517.93 0.06 Regular Air -94.73 11.7 6.96 Egbert Leathard Ontario Ontario Home Office Office Supplies Appliances Harmony HEPA Quiet Air Purifiers Medium Box 0.5 12/16/20 69 416 9/24/18 Low 20 1156.6715 0.01 Express Air 88.52 65.99 7.69 Frederich Crewe Ontario Ontario Consumer Technology Telephones and Communication 5190 Small Box 0.59 9/29/18 70 417 2/3/17 Medium 39 15260.78 0.07 Delivery Truck 8734.88 500.98 28.14 Cornela Bassingden Yukon Yukon Small Business Technology Office Machines Hewlett-Packard cp1700 [D, PS] Series Color Inkjet Printers Jumbo Drum 0.38 2/4/17 71 417 2/3/17 Medium 3 540.41 0.1 Regular Air -170.98 178.47 19.99 Horst Marchington Yukon Yukon Small Business Office Supplies Storage & Organization Hot File® 7-Pocket, Floor Stand Small Box 0.55 2/5/17 72 420 10/28/19 Not Specified 8 43.29 0.09 Regular Air -20.69 4.98 4.86 Jerry Batch Alberta West Small Business Office Supplies Paper Xerox 190 Small Box 0.38 10/28/19 73 420 10/28/19 Not Specified 6 41.7 0.03 Regular Air -14.56 5.78 5.37 Major Gronowe Alberta West Small Business Office Supplies Paper Xerox 1950 Small Box 0.36 10/30/19 74 448 8/18/19 Medium 22 1162.4005 0.09 Regular Air -284.63 65.99 19.99 Belva Hartgill Yukon Yukon Corporate Technology Telephones and Communication iDENi80s Small Box 0.59 8/20/19 75 449 7/17/19 High 45 356.7 0.02 Regular Air -48.97 7.38 5.21 Dyane Winkell Ontario Ontario Corporate Furniture Office Furnishings Eldon® Expressions™ Wood Desk Accessories, Oak Small Box 0.56 7/19/19 76 450 3/2/19 Not Specified 29 1000.78 0.05 Express Air 109.33 34.58 8.99 Ogden Sibille British Columbia West Consumer Office Supplies Pens & Art Supplies Panasonic KP-350BK Electric Pencil Sharpener with Auto Stop Small Pack 0.56 3/3/19 77 450 3/2/19 Not Specified 35 543.72 0.05 Regular Air -211.13 15.7 11.25 Garrek Athridge British Columbia West Consumer Office Supplies Storage & Organization Hanging Personal Folder File Small Box 0.6 3/4/19 78 454 12/24/19 Low 42 234.2 0.09 Regular Air 56.22 6.08 1.82 Laverne Suckling Ontario Ontario Small Business Office Supplies Rubber Bands Staples Bulk Pack Metal Binder Clips Wrap Bag 0.35 12/26/19 79 481 10/5/20 High 44 4509.3775 0.01 Regular Air 1426.26 115.99 5.26 Brandy Cornock British Columbia West Home Office Technology Telephones and Communication 636 Small Box 0.57 10/7/20 80 483 7/8/19 High 30 4965.7595 0.08 Regular Air 1198.97 195.99 3.99 Lorine Hawkridge Nunavut Nunavut Corporate Technology Telephones and Communication R380 Small Box 0.58 7/10/19 81 487 8/15/20 Critical 19 210.4 0.07 Regular Air -18.96 10.89 4.5 Camilla Leupold Manitoba Prairie Corporate Office Supplies Appliances Belkin 6 Outlet Metallic Surge Strip Small Box 0.59 8/16/20 82 512 5/17/19 Low 6 1309.53 0.06 Regular Air 19.18 218.08 18.06 Jolyn Guiu Saskatchewan Prairie Home Office Furniture Chairs & Chairmats Lifetime Advantage™ Folding Chairs, 4/Carton Large Box 0.57 5/17/19 83 512 5/17/19 Low 48 806.37 0.01 Express Air -166.40 15.42 10.68 Kaine Freiberg Saskatchewan Prairie Home Office Office Supplies Storage & Organization Decoflex Hanging Personal Folder File, Blue Small Box 0.58 5/19/19 84 513 4/28/19 High 33 5437.92 0 Delivery Truck -684.57 150.89 60.2 Cori Congreave Ontario Ontario Home Office Furniture Chairs & Chairmats Global Leather & Oak Executive Chair, Burgundy Jumbo Drum 0.77 4/28/19 85 515 8/26/18 Not Specified 19 394.27 0.08 Regular Air 30.94 21.78 5.94 Alexia Purcell Nunavut Nunavut Consumer Office Supplies Appliances Holmes HEPA Air Purifier Medium Box 0.5 8/28/18 86 515 8/26/18 Not Specified 21 146.69 0.05 Regular Air 4.43 6.64 4.95 Doralynn Trenaman Nunavut Nunavut Consumer Furniture Office Furnishings G.E. Longer-Life Indoor Recessed Floodlight Bulbs Small Pack 0.37 8/28/18 87 548 9/18/17 Critical 41 129.49 0.04 Regular Air 36.02 3.08 0.99 Aguste Keighly Saskatchewan Prairie Home Office Office Supplies Labels Avery 481 Small Box 0.37 9/19/17 88 548 9/18/17 Critical 29 202.95 0.02 Regular Air -50.64 6.48 5.9 Arthur Pizey Saskatchewan Prairie Home Office Office Supplies Paper Xerox 1976 Small Box 0.37 9/19/17 89 548 9/18/17 Critical 26 2753.1925 0.04 Regular Air 510.49 125.99 4.2 Lelia Havard Saskatchewan Prairie Home Office Technology Telephones and Communication V3682 Small Box 0.59 9/20/17 90 549 7/10/20 Critical 13 70.24 0.03 Regular Air -59.75 4.98 7.44 Brenden Bolstridge Ontario Ontario Consumer Office Supplies Paper Xerox 1922 Small Box 0.36 7/11/20 91 549 7/10/20 Critical 5 40.75 0.05 Regular Air -27.57 6.48 8.74 Flory Bootell Ontario Ontario Consumer Office Supplies Paper Xerox 1984 Small Box 0.36 7/11/20 92 549 7/10/20 Critical 30 1150.88 0.05 Express Air -911.56 38.94 35 Hercule Figin Ontario Ontario Consumer Office Supplies Storage & Organization Eldon Base for stackable storage shelf, platinum Large Box 0.8 7/10/20 93 610 7/30/19 Critical 38 283.65 0.02 Express Air -29.21 6.68 5.41 Molli Attlee Manitoba Prairie Home Office Office Supplies Paper Xerox 195 Small Box 0.37 8/1/19 94 611 1/24/18 Critical 47 840.04 0.04 Regular Air -131.27 17.7 9.47 Bethena Shute Ontario Ontario Home Office Office Supplies Storage & Organization Portfile® Personal File Boxes Small Box 0.59 1/26/18 95 612 10/18/20 Medium 50 262.87 0.1 Regular Air -166.29 5.28 6.26 Justinn Blindmann Manitoba Prairie Corporate Office Supplies Paper Xerox 1928 Small Box 0.4 10/20/20 96 612 10/18/20 Medium 43 2531.0875 0.01 Regular Air 881.68 65.99 2.5 Kerrin Fryett Manitoba Prairie Corporate Technology Telephones and Communication 6190 Small Box 0.55 10/20/20 97 613 6/15/19 High 12 93.54 0.03 Regular Air -54.04 7.3 7.72 Wallis Carnell Nunavut Nunavut Corporate Office Supplies Binders and Binder Accessories Angle-D Binders with Locking Rings, Label Holders Small Box 0.38 6/15/19 98 613 6/15/19 High 22 905.08 0.09 Regular Air 127.70 42.76 6.22 Gerrilee Dowse Nunavut Nunavut Corporate Office Supplies Storage & Organization SAFCO Mobile Desk Side File, Wire Frame Small Box 6/16/19 99 614 11/28/20 High 41 628.22 0 Regular Air 163.81 14.34 5 Starlin Stops Quebec Quebec Corporate Furniture Office Furnishings Nu-Dell Leatherette Frames Small Pack 0.49 11/30/20 100 614 11/28/20 High 24 3366.1 0.07 Delivery Truck -335.32 138.75 52.42 Mycah Simla Quebec Quebec Corporate Furniture Tables Balt Split Level Computer Training Table Jumbo Box 0.74 11/29/20 101 640 1/20/18 High 39 4913.69 0.02 Delivery Truck -1153.90 120.98 58.64 Ron Castro Ontario Ontario Consumer Furniture Bookcases O'Sullivan Living Dimensions 2-Shelf Bookcases Jumbo Box 0.75 1/21/18 102 640 1/20/18 High 24 464.77 0.01 Regular Air 29.42 18.97 9.54 Isahella Behan Ontario Ontario Consumer Office Supplies Paper Xerox 1939 Small Box 0.37 1/21/18 103 643 3/22/19 High 21 2781.82 0.07 Express Air -695.26 138.14 35 Maybelle Bartelet Nunavut Nunavut Corporate Office Supplies Storage & Organization SAFCO Commercial Wire Shelving, Black Large Box 3/23/19 104 644 4/28/20 Critical 5 1679.58 0.01 Delivery Truck -171.92 320.98 58.95 Leslie Burrows Quebec Quebec Corporate Furniture Chairs & Chairmats Hon 4070 Series Pagoda™ Round Back Stacking Chairs Jumbo Drum 0.57 4/29/20 105 645 11/30/17 High 42 557.85 0.05 Regular Air 89.45 12.95 4.98 Denver Ciciotti Prince Edward Island Atlantic Consumer Office Supplies Binders and Binder Accessories GBC Binding covers Small Box 0.4 12/2/17 106 646 11/19/17 High 18 173.2 0.01 Regular Air -10.90 9.31 3.98 Virginie Suche Ontario Ontario Small Business Office Supplies Scissors, Rulers and Trimmers Acme® Forged Steel Scissors with Black Enamel Handles Small Pack 0.56 11/20/17 107 678 2/24/18 Low 44 228.41 0.07 Regular Air -226.36 4.98 8.33 Dusty Spencers Nunavut Nunavut Home Office Office Supplies Paper Xerox 198 Small Box 0.38 2/24/18 108 706 9/6/19 Critical 42 75.14 0.05 Regular Air 0.82 1.76 0.7 Rici Loines Nova Scotia Atlantic Consumer Office Supplies Pens & Art Supplies Newell 326 Wrap Bag 0.56 9/8/19 109 710 12/30/17 Low 42 161.77 0.01 Regular Air -150.37 3.58 5.47 Anallise Lemmer Manitoba Prairie Corporate Office Supplies Binders and Binder Accessories Avery Poly Binder Pockets Small Box 0.37 1/3/18 110 710 12/30/17 Low 11 447.09 0.09 Regular Air 89.03 41.32 8.66 Alan Arbon Manitoba Prairie Corporate Furniture Office Furnishings Deflect-o EconoMat Studded, No Bevel Mat for Low Pile Carpeting Medium Box 0.76 1/1/18 111 710 12/30/17 Low 29 4192.88 0.02 Delivery Truck 731.32 145.45 17.85 Ado Kent Manitoba Prairie Corporate Technology Office Machines Panasonic KX-P1150 Dot Matrix Printer Jumbo Drum 0.56 1/3/18 112 738 2/27/18 Not Specified 7 560.51 0.04 Regular Air 32.60 80.98 4.5 Glenn Penwell Quebec Quebec Corporate Office Supplies Appliances Belkin 8 Outlet SurgeMaster II Gold Surge Protector with Phone Protection Small Box 0.59 3/1/18 113 738 2/27/18 Not Specified 31 189.95 0.08 Regular Air -56.68 6.48 5.14 Cameron Monery Quebec Quebec Corporate Office Supplies Paper Xerox 23 Small Box 0.37 2/28/18 114 740 7/13/19 Medium 6 28.01 0.09 Regular Air 3.46 4.98 0.49 Elianore Timmermann Ontario Ontario Corporate Office Supplies Labels Avery White Multi-Purpose Labels Small Box 0.39 7/13/19 115 769 5/30/18 Medium 37 4261.94 0.02 Delivery Truck 4.15 115.99 56.14 Calla Ghiotto Prince Edward Island Atlantic Consumer Technology Office Machines Hewlett-Packard Deskjet 5550 Color Inkjet Printer Jumbo Drum 0.4 5/31/18 116 771 6/14/19 Critical 18 88.84 0.08 Regular Air -38.35 4.98 4.72 Peder Langsbury Saskatchewan Prairie Home Office Office Supplies Paper Xerox 1949 Small Box 0.36 6/15/19 117 772 4/14/18 High 35 589.24 0.08 Regular Air -38.35 17.52 8.17 Bridie Crosseland Quebec Quebec Consumer Office Supplies Appliances Bionaire 99.97% HEPA Air Cleaner Medium Box 0.5 4/16/18 118 772 4/14/18 High 25 233.05 0.1 Regular Air 86.93 9.9 1.39 Reinaldo Siveter Quebec Quebec Consumer Office Supplies Envelopes #6 3/4 Gummed Flap White Envelopes Small Box 0.37 4/16/18 119 773 9/23/18 Medium 38 2071.3395 0.06 Regular Air 324.93 65.99 8.99 Cyrille Westgate Prince Edward Island Atlantic Home Office Technology Telephones and Communication Talkabout T8367 Small Box 0.56 9/24/18 120 774 12/1/19 Critical 17 126.57 0.03 Regular Air -752.13 4.48 49 Kippie Troy Alberta West Small Business Office Supplies Appliances Hoover Portapower™ Portable Vacuum Large Box 0.6 12/3/19 121 775 3/15/19 Critical 35 43.57 0.1 Regular Air -19.17 1.26 0.7 Egbert Hablet Nova Scotia Atlantic Small Business Office Supplies Rubber Bands Bagged Rubber Bands Wrap Bag 0.81 3/16/19 122 775 3/15/19 Critical 8 31.87 0.1 Regular Air -1.25 4.26 1.2 Bentley McNish Nova Scotia Atlantic Small Business Office Supplies Pens & Art Supplies Dixon Prang® Watercolor Pencils, 10-Color Set with Brush Wrap Bag 0.44 3/17/19 123 801 2/15/20 Critical 20 59.85 0.03 Regular Air -47.41 2.74 3.5 Letitia Oxborrow Manitoba Prairie Corporate Office Supplies Pens & Art Supplies Rogers Handheld Barrel Pencil Sharpener Small Pack 0.58 2/18/20 124 802 1/2/19 Critical 33 378.6 0.08 Regular Air 12.72 11.7 5.63 Keir Benoiton Ontario Ontario Corporate Office Supplies Binders and Binder Accessories Fellowes Binding Cases Small Box 0.4 1/4/19 125 802 1/2/19 Critical 2 38.5 0.09 Regular Air -52.14 15.99 9.4 Yardley Simoneschi Ontario Ontario Corporate Technology Office Machines AT&T Black Trimline Phone, Model 210 Small Box 0.49 1/2/19 126 805 7/2/19 Not Specified 39 197.56 0.02 Regular Air -119.86 4.97 5.71 Ferrell Espina Saskatchewan Prairie Small Business Furniture Office Furnishings DAX Value U-Channel Document Frames, Easel Back Medium Box 0.54 7/4/19 127 807 11/21/18 Medium 45 196.85 0.01 Regular Air -166.85 4.28 6.18 Derril Bilsford Nunavut Nunavut Home Office Office Supplies Paper Xerox 1980 Small Box 0.4 11/22/18 128 807 11/21/18 Medium 32 124.56 0.04 Regular Air -14.33 3.95 2 Kassey Cloney Nunavut Nunavut Home Office Office Supplies Rubber Bands Advantus Map Pennant Flags and Round Head Tacks Wrap Bag 0.53 11/22/18 129 832 4/16/20 Low 7 53.46 0.02 Regular Air -17.58 6.48 5.9 Yvonne Sparham Alberta West Corporate Office Supplies Paper Xerox 1976 Small Box 0.37 4/20/20 130 833 2/10/17 Medium 1 19.32 0.03 Regular Air -20.32 12.53 7.17 Jarred Francesc Ontario Ontario Home Office Office Supplies Binders and Binder Accessories GBC ProClick Spines for 32-Hole Punch Small Box 0.38 2/11/17 131 834 5/20/17 Medium 15 1813.04 0.01 Delivery Truck -164.40 115.99 56.14 Evangelin Bennis British Columbia West Home Office Technology Office Machines Hewlett-Packard Deskjet 5550 Color Inkjet Printer Jumbo Drum 0.4 5/21/17 132 835 10/5/19 Not Specified 18 125.16 0.02 Regular Air -23.48 6.48 5.14 Jules Yurenin Ontario Ontario Small Business Office Supplies Paper Xerox 23 Small Box 0.37 10/6/19 133 837 6/12/17 Not Specified 11 65.7 0.01 Regular Air 13.41 5.84 0.83 Ty Marlor Ontario Ontario Corporate Office Supplies Pens & Art Supplies Avery Hi-Liter® Smear-Safe Highlighters Wrap Bag 0.49 6/14/17 134 868 6/6/20 Not Specified 32 716.84 0 Regular Air 134.72 21.78 5.94 Bern Speck Nunavut Nunavut Home Office Office Supplies Appliances Holmes HEPA Air Purifier Medium Box 0.5 6/7/20 135 868 6/6/20 Not Specified 31 1474.33 0.04 Regular Air 114.46 47.98 3.61 Katrine Slaten Nunavut Nunavut Home Office Technology Computer Peripherals DS/HD IBM Formatted Diskettes, 200/Pack - Staples Small Pack 0.71 6/8/20 136 870 6/17/18 Not Specified 23 1661.04 0.04 Regular Air 475.54 70.97 3.5 Deanne Yokley Manitoba Prairie Corporate Office Supplies Appliances Tripp Lite Isotel 8 Ultra 8 Outlet Metal Surge Small Box 0.59 6/17/18 137 871 11/12/19 Low 17 104.94 0.06 Regular Air -34.97 6.24 5.22 Thomasina Treadwell Yukon Yukon Home Office Furniture Office Furnishings Eldon Expressions Mahogany Wood Desk Collection Small Box 0.6 11/12/19 138 896 3/6/18 Critical 50 1246.52 0.01 Regular Air 52.48 24.92 12.98 Malchy Geistbeck Ontario Ontario Home Office Office Supplies Binders and Binder Accessories GBC Standard Therm-A-Bind Covers Small Box 0.39 3/6/18 139 898 5/31/18 High 40 676.13 0.03 Regular Air 45.39 15.98 6.5 Lonnard Fere Quebec Quebec Consumer Technology Computer Peripherals Logitech Access Keyboard Small Box 0.48 6/2/18 140 898 5/31/18 High 26 7668.55 0.04 Delivery Truck -715.78 296.18 54.12 Wenonah Gethin Quebec Quebec Consumer Furniture Tables Hon 94000 Series Round Tables Jumbo Box 0.76 5/31/18 141 900 9/28/17 Not Specified 29 1193.65 0.07 Regular Air 507.58 40.98 2.99 Pammy Kliemchen Nova Scotia Atlantic Home Office Office Supplies Binders and Binder Accessories Avery Trapezoid Ring Binder, 3" Capacity, Black, 1040 sheets Small Box 0.36 9/29/17 142 902 7/24/17 Not Specified 10 1925.83 0.09 Regular Air 359.83 207.48 0.99 Shirlene Lince Manitoba Prairie Corporate Office Supplies Appliances Kensington 7 Outlet MasterPiece Power Center with Fax/Phone Line Protection Small Box 0.55 7/27/17 143 928 2/27/19 Low 21 1222.68 0.06 Express Air 300.97 59.98 3.99 Red Minnis British Columbia West Consumer Office Supplies Appliances Belkin 8 Outlet SurgeMaster II Gold Surge Protector Small Box 0.57 3/4/19 144 928 2/27/19 Low 26 390.2 0.02 Express Air 45.00 14.58 7.4 Georges Tribe British Columbia West Consumer Furniture Office Furnishings DAX Clear Channel Poster Frame Small Box 0.48 3/1/19 145 929 9/29/20 High 21 227.66 0.04 Regular Air -100.16 10.97 6.5 Martyn Cronchey Yukon Yukon Corporate Technology Computer Peripherals Micro Innovations 104 Keyboard Small Box 0.64 10/2/20 146 929 9/29/20 High 39 84.33 0.04 Regular Air -64.29 2.08 2.56 Ammamaria Cushworth Yukon Yukon Corporate Office Supplies Scissors, Rulers and Trimmers Kleencut® Forged Office Shears by Acme United Corporation Small Pack 0.55 10/1/20 147 930 12/14/17 Critical 22 922.39 0.03 Express Air -41.64 41.32 58.66