Chat with us, powered by LiveChat tableau | Economics Write
+1(978)310-4246 credencewriters@gmail.com
  

please read the pdf.
student email: [email protected]

Orders

Order ID Order Date Order Quantity Sales Profit Unit Price Customer Name Customer State Zip Code Region Product Category Product Sub-Category Ship Date

46597 1/1/17 42 8231.58 4660.93 195.99 Michael Chen Nebraska 68717 NorthCentral Technology Telephones and Communication 1/1/17

46597 1/1/17 2 245.98 123.96 122.99 Michael Chen Nebraska 68717 NorthCentral Furniture Chairs & Chairmats 1/3/17

46597 1/1/17 10 129.5 -46.92 12.95 Michael Chen Nebraska 68717 NorthCentral Office Supplies Binders and Binder Accessories 1/3/17

57253 1/1/17 45 12576.6 887.81 279.48 Darren Budd Texas 73301 Southwest Office Supplies Storage & Organization 1/1/17

57253 1/1/17 22 2771.78 808.87 125.99 Darren Budd Texas 73301 Southwest Technology Telephones and Communication 1/1/17

57253 1/1/17 43 77.83 57.22 1.81 Darren Budd Texas 73301 Southwest Technology Networking Devices 1/2/17

57253 1/1/17 49 240.59 61.01 4.91 Darren Budd Texas 73301 Southwest Office Supplies Binders and Binder Accessories 1/2/17

57253 1/1/17 31 650.38 174.91 20.98 Darren Budd Texas 73301 Southwest Office Supplies Storage & Organization 1/3/17

59232 1/1/17 23 712.54 64.08 30.98 Robert Waldorf Northwest Virginia 23018 East Office Supplies Paper 1/3/17

710 1/2/17 11 454.52 324.32 41.32 Susan MacKendrick Indiana 43002 NorthCentral Furniture Office Furnishings 1/4/17

710 1/2/17 29 4218.05 -705.57 145.45 Susan MacKendrick Indiana 43002 NorthCentral Technology Office Machines 1/6/17

710 1/2/17 45 161.1 10.17 3.58 Susan MacKendrick Indiana 43002 NorthCentral Office Supplies Binders and Binder Accessories 1/6/17

39841 1/2/17 44 293.92 29.79 6.68 Benjamin Venier Maryland 21794 East Office Supplies Paper 1/4/17

59174 1/2/17 6 1224.6 648.56 204.1 Emily Ducich Illinois 62999 NorthCentral Technology Office Machines 1/4/17

25860 1/3/17 9 755.82 281.06 83.98 Elpida Rittenbach Illinois 62541 NorthCentral Office Supplies Envelopes 1/5/17

25860 1/3/17 20 1319.8 -595.55 65.99 Elpida Rittenbach Illinois 62541 NorthCentral Technology Telephones and Communication 1/12/17

38215 1/3/17 36 755.64 362.36 20.99 Dennis Pardue Indiana 44197 NorthCentral Technology Telephones and Communication 1/4/17

38215 1/3/17 35 3669.75 2432.87 104.85 Dennis Pardue Indiana 44197 NorthCentral Office Supplies Paper 1/5/17

44069 1/3/17 41 616.64 421.07 15.04 Elizabeth Moffitt Connecticut 6928 Northeast Office Supplies Paper 1/3/17

44069 1/3/17 15 136.65 -2.71 9.11 Elizabeth Moffitt Connecticut 6928 Northeast Office Supplies Paper 1/5/17

48480 1/3/17 30 11129.4 -3089.29 370.98 Sean Wendt Mass 1059 Northeast Office Supplies Storage & Organization 1/6/17

54145 1/3/17 34 70.72 43.87 2.08 Joni Blumstein Connecticut 6817 Northeast Furniture Office Furnishings 1/3/17

8998 1/4/17 12 266.88 159.82 22.24 Linda Southwestworth Iowa 53001 NorthCentral Technology Computer Peripherals 1/6/17

8998 1/4/17 35 1784.3 1272.56 50.98 Linda Southwestworth Iowa 53001 NorthCentral Office Supplies Lamps and Lighting 1/8/17

8998 1/4/17 13 174.59 14.48 13.43 Linda Southwestworth Iowa 53001 NorthCentral Office Supplies Storage & Organization 1/9/17

20449 1/4/17 18 1211.04 699.14 67.28 Nora Paige Texas 88595 Southwest Office Supplies Binders and Binder Accessories 1/5/17

29058 1/4/17 40 999.2 220.79 24.98 Valerie Takahito Utah 84001 NorthWest Office Supplies Storage & Organization 1/4/17

29058 1/4/17 22 128.48 78.42 5.84 Valerie Takahito Utah 84001 NorthWest Office Supplies Pens & Art Supplies 1/5/17

29058 1/4/17 44 285.12 139.21 6.48 Valerie Takahito Utah 84001 NorthWest Office Supplies Paper 1/6/17

29058 1/4/17 32 28191.36 18498.33 880.98 Valerie Takahito Utah 84001 NorthWest Furniture Bookcases 1/6/17

40354 1/4/17 3 637.8 -198.18 212.6 Patrick Jones Alabama 36344 Southwest Furniture Tables 1/5/17

40354 1/4/17 31 172.98 118.95 5.58 Patrick Jones Alabama 36344 Southwest Office Supplies Binders and Binder Accessories 1/5/17

57606 1/4/17 35 296.1 195.34 8.46 Darren Budd Texas 73301 Southwest Technology Computer Peripherals 1/5/17

46050 1/5/17 5 2249.95 -269.59 449.99 Julie Prescott Iowa 53006 NorthCentral Technology Copiers and Printers 1/6/17

46050 1/5/17 50 4771.5 3445.26 95.43 Julie Prescott Iowa 53006 NorthCentral Office Supplies Storage & Organization 1/8/17

46050 1/5/17 3 868.59 -53.03 289.53 Julie Prescott Iowa 53006 NorthCentral Office Supplies Lamps and Lighting 1/8/17

49730 1/5/17 3 1052.94 173.61 350.98 Dave Hallsten Texas 78702 Southwest Furniture Chairs & Chairmats 1/6/17

5504 1/6/17 9 52.02 26.54 5.78 Anna Andreadi Alabama 35245 Southwest Office Supplies Paper 1/8/17

5504 1/6/17 13 597.87 110.90 45.99 Anna Andreadi Alabama 35245 Southwest Technology Telephones and Communication 1/8/17

14755 1/6/17 29 111.65 100.74 3.85 Steve Nguyen Maryland 21230 East Office Supplies Pens & Art Supplies 1/6/17

14755 1/6/17 35 2309.65 606.13 65.99 Steve Nguyen Maryland 21230 East Technology Telephones and Communication 1/8/17

52386 1/6/17 6 725.82 31.52 120.97 Susan Vittorini New Jersey 7837 Northeast Technology Office Machines 1/8/17

56293 1/6/17 35 699.65 535.12 19.99 Michelle Arnett Michigan 49971 NorthCentral Furniture Office Furnishings 1/6/17

56293 1/6/17 42 710.22 511.13 16.91 Michelle Arnett Michigan 49971 NorthCentral Office Supplies Storage & Organization 1/7/17

33218 1/7/17 30 484.8 67.17 16.16 Eric Hoffmann Illinois 62560 NorthCentral Furniture Office Furnishings 1/8/17

33218 1/7/17 25 114.25 -9.48 4.57 Eric Hoffmann Illinois 62560 NorthCentral Office Supplies Binders and Binder Accessories 1/9/17

41094 1/7/17 46 298.08 -24.24 6.48 Maribeth Schnelling Illinois 62924 NorthCentral Office Supplies Paper 1/9/17

41094 1/7/17 8 162.72 84.99 20.34 Maribeth Schnelling Illinois 62924 NorthCentral Office Supplies Storage & Organization 1/11/17

44133 1/7/17 34 179.52 -60.39 5.28 Mark Packer California 91188 NorthWest Furniture Office Furnishings 1/8/17

48226 1/7/17 23 2322.54 1146.14 100.98 Corey Roper Washington 98103 NorthWest Furniture Bookcases 1/7/17

5510 1/8/17 12 116.16 113.62 9.68 Denise Leinenbach Maryland 21022 East Office Supplies Paper 1/11/17

12708 1/8/17 49 160.72 93.93 3.28 Yana Sorensen California 93456 NorthWest Office Supplies Pens & Art Supplies 1/13/17

40704 1/8/17 7 12.32 -1.07 1.76 Julie Kriz Illinois 62444 NorthCentral Office Supplies Pens & Art Supplies 1/13/17

43909 1/8/17 46 735.54 347.40 15.99 Chloris Kastensmidt New York 14210 Northeast Office Supplies Binders and Binder Accessories 1/9/17

47171 1/8/17 32 6971.2 2314.99 217.85 Sandra Glassco New Mexico 87001 Southwest Furniture Tables 1/8/17

47171 1/8/17 19 50.73 31.55 2.67 Sandra Glassco New Mexico 87001 Southwest Office Supplies Pens & Art Supplies 1/9/17

47171 1/8/17 23 149.04 -26.01 6.48 Sandra Glassco New Mexico 87001 Southwest Office Supplies Paper 1/9/17

48935 1/8/17 22 108.02 103.24 4.91 Jill Matthias Maryland 21022 East Office Supplies Labels 1/10/17

2244 1/9/17 23 87.4 70.62 3.8 Elpida Rittenbach Illinois 62541 NorthCentral Office Supplies Binders and Binder Accessories 1/11/17

13447 1/9/17 21 440.79 81.94 20.99 Pamela Coakley Maryland 21290 East Technology Telephones and Communication 1/11/17

37668 1/9/17 34 475.66 146.79 13.99 Victoria Pisteka Texas 88595 Southwest Technology Office Machines 1/9/17

58053 1/9/17 43 287.24 252.25 6.68 Susan Gilcrest Georgia 31733 Southwest Office Supplies Paper 1/11/17

4611 1/10/17 32 16031.36 15728.51 500.98 Steven Ward Indiana 43270 NorthCentral Technology Office Machines 1/10/17

32932 1/10/17 50 29999.5 -10606.40 599.99 Karen Carlisle Florida 34997 Southwest Technology Copiers and Printers 1/14/17

40097 1/10/17 45 117 -30.97 2.6 Olvera Toch Colorado 80621 NorthWest Office Supplies Pens & Art Supplies 1/15/17

47138 1/10/17 1 125.99 20.72 125.99 Benjamin Patterson Arizona 85301 Southwest Technology Telephones and Communication 1/17/17

58343 1/10/17 37 121.73 25.71 3.29 Yana Sorensen California 93456 NorthWest Technology Networking Devices 1/12/17

1280 1/11/17 39 817.83 -401.03 20.97 Harold Dahlen Nebraska 68717 NorthCentral Technology Computer Peripherals 1/11/17

8227 1/11/17 34 162.18 -52.35 4.77 Christina Vanderzanden New Mexico 88044 Southwest Technology Computer Peripherals 1/12/17

10247 1/11/17 22 109.56 68.13 4.98 Edward Becker Utah 84014 NorthWest Office Supplies Paper 1/12/17

10247 1/11/17 24 234.72 167.22 9.78 Edward Becker Utah 84014 NorthWest Technology Computer Peripherals 1/13/17

23782 1/11/17 43 21542.14 16304.18 500.98 Justin MacKendrick North Carolina 28609 East Furniture Chairs & Chairmats 1/11/17

23782 1/11/17 8 162.72 113.07 20.34 Justin MacKendrick North Carolina 28609 East Office Supplies Storage & Organization 1/16/17

24740 1/11/17 34 111.52 12.55 3.28 Logan Haushalter Nebraska 68770 NorthCentral Office Supplies Pens & Art Supplies 1/11/17

24740 1/11/17 12 1106.76 602.15 92.23 Logan Haushalter Nebraska 68770 NorthCentral Furniture Office Furnishings 1/12/17

44391 1/11/17 17 110.16 7.43 6.48 Ann Steele Idaho 83810 NorthWest Office Supplies Paper 1/12/17

55367 1/11/17 30 2129.4 1500.83 70.98 Kristina Nunn Arizona 86409 Southwest Furniture Bookcases 1/12/17

55367 1/11/17 49 565.95 256.67 11.55 Kristina Nunn Arizona 86409 Southwest Office Supplies Pens & Art Supplies 1/13/17

57318 1/11/17 32 157.12 154.98 4.91 Eric Barreto Maryland 21230 East Office Supplies Labels 1/13/17

57318 1/11/17 12 80.16 15.28 6.68 Eric Barreto Maryland 21230 East Office Supplies Paper 1/13/17

42567 1/12/17 13 1902.42 -400.33 146.34 Tom Prescott Texas 77474 Southwest Furniture Tables 1/14/17

48487 1/12/17 28 363.16 301.58 12.97 Carol Triggs Indiana 43317 NorthCentral Office Supplies Binders and Binder Accessories 1/14/17

56327 1/12/17 43 1762.57 309.28 40.99 Victoria Brennan New York 14210 Northeast Office Supplies Paper 1/13/17

56327 1/12/17 44 1283.92 -92.61 29.18 Victoria Brennan New York 14210 Northeast Furniture Office Furnishings 1/13/17

56327 1/12/17 12 2171.76 -211.17 180.98 Victoria Brennan New York 14210 Northeast Office Supplies Lamps and Lighting 1/14/17

59270 1/12/17 5 614.95 534.69 122.99 Deborah Brumfield Colorado 81221 NorthWest Furniture Chairs & Chairmats 1/12/17

59270 1/12/17 15 2142.9 -551.32 142.86 Deborah Brumfield Colorado 81221 NorthWest Office Supplies Storage & Organization 1/13/17

59270 1/12/17 49 25356.52 2382.16 517.48 Deborah Brumfield Colorado 81221 NorthWest Technology Office Machines 1/14/17

59270 1/12/17 50 1589 37.68 31.78 Deborah Brumfield Colorado 81221 NorthWest Technology Computer Peripherals 1/14/17

1857 1/13/17 36 200.88 104.87 5.58 Roy Phan New York 10501 Northeast Office Supplies Pens & Art Supplies 1/14/17

19494 1/13/17 39 866.97 -79.79 22.23 Clytie Kelty Southwest Carolina 29001 East Furniture Office Furnishings 1/15/17

19494 1/13/17 3 8.22 7.93 2.74 Clytie Kelty Southwest Carolina 29001 East Office Supplies Pens & Art Supplies 1/16/17

34948 1/13/17 15 1032.15 909.89 68.81 Catherine Glotzbach Southwest Carolina 29374 East Office Supplies Lamps and Lighting 1/13/17

38369 1/13/17 3 214.11 -9.29 71.37 Eric Barreto Maryland 21230 East Furniture Tables 1/14/17

43362 1/13/17 35 58.8 -22.62 1.68 Rick Reed Idaho 83555 NorthWest Office Supplies Pens & Art Supplies 1/15/17

43362 1/13/17 45 15794.1 8218.95 350.98 Rick Reed Idaho 83555 NorthWest Furniture Chairs & Chairmats 1/16/17

12580 1/14/17 46 7957.54 2494.57 172.99 Dave Poirier Florida 32003 Southwest Office Supplies Binders and Binder Accessories 1/16/17

12580 1/14/17 43 141.04 65.07 3.28 Dave Poirier Florida 32003 Southwest Office Supplies Pens & Art Supplies 1/16/17

17825 1/14/17 26 981.76 814.43 37.76 Larry Hughes Delaware 19885 Northeast Office Supplies Storage & Organization 1/17/17

51623 1/14/17 19 39.52 -13.65 2.08 Michelle Huthwaite Idaho 83552 NorthWest Furniture Office Furnishings 1/14/17

59552 1/14/17 42 312.9 57.94 7.45 Pierre Wener California 96061 NorthWest Office Supplies Binders and Binder Accessories 1/15/17

2213 1/15/17 7 40.46 -0.54 5.78 Sam Zeldin Maryland 21290 East Office Supplies Paper 1/16/17

19524 1/15/17 9 92.07 17.37 10.23 Amy Cox Washington 98625 NorthWest Office Supplies Scissors, Rulers and Trimmers 1/16/17

20961 1/15/17 33 6599.67 -1916.35 199.99 Lela Donovan Mass 5544 Northeast Technology Copiers and Printers 1/17/17

23586 1/15/17 33 213.84 -79.35 6.48 Anthony Garverick Florida 34997 Southwest Office Supplies Paper 1/18/17

28289 1/15/17 33 164.34 -37.74 4.98 Carl Ludwig Michigan 48001 NorthCentral Office Supplies Paper 1/16/17

37125 1/15/17 49 72.52 46.30 1.48 Sanjit Jacobs Idaho 83877 NorthWest Technology Networking Devices 1/16/17

37250 1/15/17 13 467.22 -193.59 35.94 Grant Thornton Connecticut 6439 Northeast Office Supplies Envelopes 1/16/17

43911 1/15/17 29 579.71 -66.65 19.99 Tamara Manning Southwest Carolina 29808 East Furniture Office Furnishings 1/15/17

43911 1/15/17 37 9804.26 1657.63 264.98 Tamara Manning Southwest Carolina 29808 East Technology Office Machines 1/16/17

43911 1/15/17 23 7382.54 5379.56 320.98 Tamara Manning Southwest Carolina 29808 East Furniture Chairs & Chairmats 1/17/17

58599 1/15/17 47 5357.06 2442.76 113.98 Dianna Wilson Georgia 31569 Southwest Furniture Chairs & Chairmats 1/16/17

58599 1/15/17 19 2298.62 2239.18 120.98 Dianna Wilson Georgia 31569 Southwest Furniture Chairs & Chairmats 1/16/17

2852 1/16/17 12 77.76 34.04 6.48 Luke Schmidt Florida 32122 Southwest Office Supplies Paper 1/16/17

2852 1/16/17 34 3943.66 1436.09 115.99 Luke Schmidt Florida 32122 Southwest Technology Telephones and Communication 1/17/17

15079 1/16/17 23 1124.93 414.39 48.91 Erica Hackney Southwest Carolina 29941 East Office Supplies Paper 1/17/17

15079 1/16/17 46 3725.08 3577.36 80.98 Erica Hackney Southwest Carolina 29941 East Technology Computer Peripherals 1/19/17

21574 1/16/17 37 78.44 1.48 2.12 Eric Barreto Maryland 21230 East Technology Computer Peripherals 1/17/17

48773 1/16/17 7 49.28 11.81 7.04 Amy Cox Washington 98625 NorthWest Office Supplies Paper 1/18/17

4545 1/17/17 5 32.4 3.92 6.48 Pauline Chand Connecticut 6439 Northeast Office Supplies Paper 1/18/17

4545 1/17/17 32 128 -5.55 4 Pauline Chand Connecticut 6439 Northeast Office Supplies Paper 1/19/17

8642 1/17/17 13 134.55 128.17 10.35 Patrick Ryan North Carolina 28909 East Office Supplies Labels 1/18/17

8642 1/17/17 26 150.8 62.85 5.8 Patrick Ryan North Carolina 28909 East Office Supplies Binders and Binder Accessories 1/18/17

26182 1/17/17 4 803.92 507.64 200.98 Doug Bickford Alabama 36925 Southwest Furniture Chairs & Chairmats 1/17/17

26182 1/17/17 31 4680.38 -1096.92 150.98 Doug Bickford Alabama 36925 Southwest Furniture Bookcases 1/20/17

36161 1/17/17 7 31.43 12.31 4.49 Chad McGuire Nebraska 69367 NorthCentral Office Supplies Binders and Binder Accessories 1/18/17

39173 1/17/17 2 358.58 359.55 179.29 Jason Klamczynski Nebraska 69367 NorthCentral Furniture Tables 1/19/17

39173 1/17/17 35 76.3 64.61 2.18 Jason Klamczynski Nebraska 69367 NorthCentral Technology Networking Devices 1/19/17

49541 1/17/17 38 510.34 167.84 13.43 Joe Elijah Texas 77037 Southwest Office Supplies Storage & Organization 1/18/17

18853 1/18/17 34 227.12 196.46 6.68 Gary Hwang Illinois 62444 NorthCentral Office Supplies Pens & Art Supplies 1/20/17

43620 1/18/17 12 50.4 25.93 4.2 Joel Eaton New Jersey 7001 Northeast Office Supplies Paper 1/20/17

43620 1/18/17 13 192.53 93.83 14.81 Joel Eaton New Jersey 7001 Northeast Office Supplies Lamps and Lighting 1/21/17

46884 1/18/17 24 277.2 43.47 11.55 Paul Prost Florida 32119 Southwest Office Supplies Pens & Art Supplies 1/19/17

46884 1/18/17 17 129.88 95.50 7.64 Paul Prost Florida 32119 Southwest Office Supplies Envelopes 1/20/17

46884 1/18/17 3 377.97 225.75 125.99 Paul Prost Florida 32119 Southwest Technology Telephones and Communication 1/20/17

55139 1/18/17 41 569.9 531.17 13.9 Bobby Elias Georgia 31811 Southwest Office Supplies Scissors, Rulers and Trimmers 1/19/17

55139 1/18/17 26 85.28 -6.34 3.28 Bobby Elias Georgia 31811 Southwest Office Supplies Pens & Art Supplies 1/19/17

24610 1/19/17 4 803.92 231.15 200.98 Dean Katz Florida 34997 Southwest Furniture Chairs & Chairmats 1/21/17

34753 1/19/17 6 125.94 105.78 20.99 Barbara Fisher Alabama 35062 Southwest Technology Telephones and Communication 1/21/17

35139 1/19/17 30 260.7 -107.80 8.69 Lauren Leatherbury New Jersey 8989 Northeast Office Supplies Binders and Binder Accessories 1/20/17

35139 1/19/17 3 10506.42 1583.39 3502.14 Lauren Leatherbury New Jersey 8989 Northeast Technology Office Machines 1/20/17

35139 1/19/17 25 864.5 -318.19 34.58 Lauren Leatherbury New Jersey 8989 Northeast Office Supplies Pens & Art Supplies 1/21/17

35139 1/19/17 32 390.72 11.73 12.21 Lauren Leatherbury New Jersey 8989 Northeast Office Supplies Storage & Organization 1/21/17

39267 1/19/17 43 1216.04 -54.96 28.28 Sam Craven Georgia 31569 Southwest Office Supplies Storage & Organization 1/20/17

39267 1/19/17 24 426.72 67.90 17.78 Sam Craven Georgia 31569 Southwest Furniture Office Furnishings 1/21/17

48199 1/19/17 43 676.82 -193.18 15.74 Erica Bern Michigan 49971 NorthCentral Office Supplies Envelopes 1/22/17

50048 1/19/17 2 13.68 9.06 6.84 Chad Sievert New Jersey 8823 Northeast Office Supplies Scissors, Rulers and Trimmers 1/21/17

50048 1/19/17 14 36.12 20.42 2.58 Chad Sievert New Jersey 8823 Northeast Office Supplies Pens & Art Supplies 1/21/17

58784 1/19/17 28 1369.48 -498.70 48.91 Kristen Hastings New Jersey 7981 Northeast Office Supplies Paper 1/19/17

58784 1/19/17 18 279.18 -86.18 15.51 Kristen Hastings New Jersey 7981 Northeast Office Supplies Storage & Organization 1/20/17

58784 1/19/17 12 138.96 4.41 11.58 Kristen Hastings New Jersey 7981 Northeast Office Supplies Envelopes 1/20/17

58784 1/19/17 25 8774.75 5603.79 350.99 Kristen Hastings New Jersey 7981 Northeast Furniture Chairs & Chairmats 1/21/17

58784 1/19/17 21 335.79 -11.74 15.99 Kristen Hastings New Jersey 7981 Northeast Technology Office Machines 1/21/17

54497 1/20/17 1 142.86 -69.36 142.86 Philip Fox Florida 32046 Southwest Office Supplies Storage & Organization 1/23/17

20934 1/21/17 5 1324.9 -436.84 264.98 Bill Eplett North Carolina 28633 East Technology Office Machines 1/22/17

25155 1/21/17 6 29.88 6.40 4.98 John Dryer Southwest Carolina 29808 East Office Supplies Paper 1/26/17

25155 1/21/17 17 113.73 87.61 6.69 John Dryer Southwest Carolina 29808 East Office Supplies Paper 1/28/17

25155 1/21/17 52 1036.88 806.09 19.94 John Dryer Southwest Carolina 29808 East Furniture Office Furnishings 1/28/17

29185 1/21/17 8 455.68 -88.80 56.96 Rob Dowd Arizona 85071 Southwest Office Supplies Lamps and Lighting 1/22/17

29185 1/21/17 53 443.61 -160.06 8.37 Rob Dowd Arizona 85071 Southwest Furniture Office Furnishings 1/23/17

29185 1/21/17 5 204.95 -69.62 40.99 Rob Dowd Arizona 85071 Southwest Office Supplies Paper 1/23/17

34661 1/21/17 25 849.5 -153.84 33.98 Nathan Mautz Alabama 35077 Southwest Furniture Office Furnishings 1/23/17

44197 1/21/17 28 3947.44 2987.99 140.98 Cynthia Arntzen Texas 79080 Southwest Furniture Bookcases 1/24/17

55398 1/21/17 22 46.2 -18.61 2.1 Lena Radford Iowa 53554 NorthCentral Office Supplies Pens & Art Supplies 1/22/17

55398 1/21/17 35 156.8 -4.67 4.48 Lena Radford Iowa 53554 NorthCentral Office Supplies Lamps and Lighting 1/23/17

42405 1/22/17 14 83.72 18.82 5.98 Skye Norling New Jersey 7010 Northeast Office Supplies Paper 1/24/17

49505 1/22/17 34 332.52 188.24 9.78 Harold Ryan Connecticut 6928 Northeast Technology Computer Peripherals 1/23/17

49505 1/22/17 12 94.08 -6.61 7.84 Harold Ryan Connecticut 6928 Northeast Office Supplies Binders and Binder Accessories 1/24/17

52608 1/22/17 37 147.26 84.96 3.98 Thea Hudgings Illinois 62444 NorthCentral Office Supplies Pens & Art Supplies 1/26/17

58759 1/22/17 4 32.04 -8.59 8.01 Andrew Allen Illinois 60001 NorthCentral Office Supplies Paper 1/29/17

640 1/23/17 41 4960.18 3046.91 120.98 Tamara Chand Delaware 19895 Northeast Furniture Bookcases 1/24/17

640 1/23/17 25 474.25 -111.48 18.97 Tamara Chand Delaware 19895 Northeast Office Supplies Paper 1/24/17

24135 1/23/17 11 334.84 77.29 30.44 Ed Ludwig Utah 84001 NorthWest Office Supplies Binders and Binder Accessories 1/25/17

35812 1/23/17 24 2735.52 2018.79 113.98 Barbara Fisher Alabama 35062 Southwest Furniture Chairs & Chairmats 1/25/17

35812 1/23/17 2 61.46 51.22 30.73 Barbara Fisher Alabama 35062 Southwest Technology Computer Peripherals 1/25/17

35812 1/23/17 18 862.2 464.33 47.9 Barbara Fisher Alabama 35062 Southwest Office Supplies Paper 1/25/17

44999 1/23/17 17 110.16 -22.74 6.48 Mike Kennedy Mass 1001 Northeast Office Supplies Paper 1/24/17

49925 1/23/17 1 2.88 2.11 2.88 Adam Hart Connecticut 6001 Northeast Office Supplies Pens & Art Supplies 1/24/17

53891 1/23/17 37 563.14 468.43 15.22 Nathan Mautz Alabama 35077 Southwest Office Supplies Binders and Binder Accessories 1/23/17

53891 1/23/17 44 4058.12 3259.67 92.23 Nathan Mautz Alabama 35077 Southwest Furniture Office Furnishings 1/24/17

53891 1/23/17 22 2551.78 -425.25 115.99 Nathan Mautz Alabama 35077 Southwest Technology Telephones and Communication 1/24/17

53891 1/23/17 25 4499.75 328.43 179.99 Nathan Mautz Alabama 35077 Southwest Technology Computer Peripherals 1/24/17

55270 1/23/17 1 29.17 0.92 29.17 Edward Nazzal Northwest Virginia 20101 East Office Supplies Binders and Binder Accessories 1/24/17

55360 1/23/17 41 8931.85 5991.42 217.85 Russell Applegate Illinois 62541 NorthCentral Furniture Tables 1/24/17

55360 1/23/17 47 135.83 84.43 2.89 Russell Applegate Illinois 62541 NorthCentral Office Supplies Labels 1/25/17

13958 1/24/17 9 773.91 274.61 85.99 Jill Matthias Maryland 21022 East Technology Telephones and Communication 2/2/17

41472 1/24/17 52 279.76 108.13 5.38 Helen Wasserman North Carolina 27006 East Office Supplies Binders and Binder Accessories 1/31/17

44295 1/24/17 39 4523.61 -108.93 115.99 Alex Russell Southwest Carolina 29808 East Technology Telephones and Communication 1/26/17

14661 1/25/17 37 1323.49 -552.92 35.77 Lauren Leatherbury New Jersey 8989 Northeast Technology Computer Peripherals 1/26/17

38048 1/25/17 34 2243.66 577.02 65.99 Ted Butterfield Nebraska 69367 NorthCentral Technology Telephones and Communication 1/25/17

38048 1/25/17 48 276.96 191.11 5.77 Ted Butterfield Nebraska 69367 NorthCentral Furniture Office Furnishings 1/26/17

40162 1/25/17 28 1567.44 -583.75 55.98 Penelope Sewall Indiana 45999 NorthCentral Office Supplies Paper 1/27/17

58277 1/25/17 25 292.5 130.51 11.7 Michael Dominguez Colorado 81221 NorthWest Office Supplies Lamps and Lighting 1/27/17

1253 1/26/17 15 479.7 -25.04 31.98 Tanja Norvell Utah 84631 NorthWest Office Supplies Storage & Organization 1/26/17

2305 1/26/17 11 1323.63 -120.65 120.33 Maribeth Dona Illinois 60001 NorthCentral Office Supplies Storage & Organization 1/26/17

2305 1/26/17 2 13.36 9.08 6.68 Maribeth Dona Illinois 60001 NorthCentral Office Supplies Paper 1/27/17

2305 1/26/17 31 3130.38 1297.57 100.98 Maribeth Dona Illinois 60001 NorthCentral Furniture Bookcases 1/28/17

14819 1/26/17 27 1569.78 48.23 58.14 Carl Jackson Michigan 49634 NorthCentral Furniture Bookcases 1/27/17

14819 1/26/17 44 9129.12 1239.54 207.48 Carl Jackson Michigan 49634 NorthCentral Office Supplies Lamps and Lighting 1/28/17

34785 1/26/17 39 15638.22 -3275.83 400.98 Jim Sink Southwest Carolina 29684 East Furniture Tables 1/29/17

611 1/27/17 47 831.9 74.19 17.7 Arthur Prichep California 91188 NorthWest Office Supplies Storage & Organization 1/29/17

24961 1/27/17 8 465.12 -128.13 58.14 Ken Black Texas 88595 Southwest Furniture Bookcases 2/3/17

27680 1/27/17 30 326.7 84.88 10.89 Delfina Latchford Mass 1001 Northeast Office Supplies Lamps and Lighting 1/28/17

27680 1/27/17 21 136.08 -35.61 6.48 Delfina Latchford Mass 1001 Northeast Office Supplies Paper 1/28/17

27808 1/27/17 9 188.01 180.41 20.89 Michelle Ellison Colorado 81655 NorthWest Technology Computer Peripherals 2/3/17

55937 1/27/17 19 7146.47 -883.65 376.13 Stefanie Holloman North Carolina 27010 East Furniture Tables 1/29/17

55937 1/27/17 10 399.8 125.86 39.98 Stefanie Holloman North Carolina 27010 East Technology Computer Peripherals 1/29/17

44098 1/28/17 2 6.28 -1.62 3.14 John Grady New York 14709 Northeast Office Supplies Scissors, Rulers and Trimmers 2/1/17

97 1/29/17 26 75.14 -2.27 2.89 Craig Yedwab Arizona 85354 Southwest Office Supplies Labels 1/30/17

5381 1/29/17 29 63.22 -3.21 2.18 Edward Nazzal Northwest Virginia 20101 East Office Supplies Paper 2/5/17

5381 1/29/17 45 4838.85 4847.12 107.53 Edward Nazzal Northwest Virginia 20101 East Furniture Office Furnishings 2/5/17

27810 1/29/17 34 214.2 -0.59 6.3 Julia Dunbar New Mexico 88044 Southwest Office Supplies Labels 1/31/17

6279 1/30/17 49 3296.72 -640.22 67.28 Katrina Willman Nebraska 68155 NorthCentral Office Supplies Binders and Binder Accessories 2/1/17

13413 1/30/17 30 149.4 -59.71 4.98 Karen Daniels California 91188 NorthWest Office Supplies Paper 2/1/17

30336 1/30/17 27 5215.59 3809.40 193.17 Caroline Jumper Indiana 43567 NorthCentral Office Supplies Storage & Organization 2/1/17

31780 1/30/17 17 730.66 -72.73 42.98 Max Ludwig Northwest Virginia 23664 East Office Supplies Lamps and Lighting 2/1/17

3461 1/31/17 28 3247.72 599.62 115.99 Susan Gilcrest Georgia 31733 Southwest Technology Telephones and Communication 2/2/17

3461 1/31/17 37 2071.63 -415.08 55.99 Susan Gilcrest Georgia 31733 Southwest Technology Telephones and Communication 2/2/17

52196 1/31/17 1 3.08 2.60 3.08 Adam Hart Connecticut 6001 Northeast Office Supplies Labels 2/1/17

52196 1/31/17 8 527.92 -222.88 65.99 Adam Hart Connecticut 6001 Northeast Technology Telephones and Communication 2/2/17

12449 2/1/17 35 1399.3 361.02 39.98 Anthony Rawles Illinois 62999 NorthCentral Technology Computer Peripherals 2/3/17

14338 2/1/17 33 6632.01 -1629.45 200.97 Mike Kennedy Mass 1001 Northeast Technology Office Machines 2/8/17

14375 2/1/17 46 46.24 17.59 5.78 Rick Duston Texas 76246 Southwest Office Supplies Paper 2/2/17

14375 2/1/17 36 3860.78 -69.36 83.93 Rick Duston Texas 76246 Southwest Office Supplies Envelopes 2/2/17

16166 2/1/17 36 78.48 63.24 2.18 Anthony Rawles Illinois 62999 NorthCentral Technology Networking Devices 2/2/17

40101 2/1/17 44 2199.56 1765.59 49.99 John Lee Texas 79080 Southwest Technology Computer Peripherals 2/6/17

50304 2/1/17 22 879.56 -91.69 39.98 Jonathan Doherty Indiana 43567 NorthCentral Office Supplies Envelopes 2/3/17

50304 2/1/17 5 76.15 55.08 15.23 Jonathan Doherty Indiana 43567 NorthCentral Furniture Tables 2/3/17

52416 2/1/17 42 9187.5 941.16 218.75 Dave Brooks Illinois 62924 NorthCentral Furniture Tables 2/2/17

52416 2/1/17 7 53.48 -7.16 7.64 Dave Brooks Illinois 62924 NorthCentral Office Supplies Paper 2/3/17

8292 2/2/17 19 299.06 126.94 15.74 Ellis Ballard Florida 32099 Southwest Office Supplies Envelopes 2/3/17

27524 2/2/17 53 343.44 -63.09 6.48 Jay Fine Florida 34997 Southwest Office Supplies Paper 2/4/17

48642 2/2/17 38 111.72 71.39 2.94 Matt Collister Idaho 83877 NorthWest Office Supplies Pens & Art Supplies 2/2/17

48642 2/2/17 43 4127.57 3454.39 95.99 Matt Collister Idaho 83877 NorthWest Technology Telephones and Communication 2/2/17

48642 2/2/17 5 504.9 273.42 100.98 Matt Collister Idaho 83877 NorthWest Technology Computer Peripherals 2/3/17

48642 2/2/17 4 34.68 3.02 8.67 Matt Collister Idaho 83877 NorthWest Office Supplies Lamps and Lighting 2/4/17

58788 2/2/17 32 991.36 896.47 30.98 Christopher Schild Michigan 48001 NorthCentral Technology Computer Peripherals 2/4/17

3687 2/3/17 24 78.96 46.38 3.29 Marc Harrigan Mass 2180 Northeast Technology Networking Devices 2/3/17

18307 2/3/17 35 247.8 29.30 7.08 Dennis Pardue Indiana 44197 NorthCentral Office Supplies Pens & Art Supplies 2/3/17

18307 2/3/17 22 439.56 -11.67 19.98 Dennis Pardue Indiana 44197 NorthCentral Office Supplies Paper 2/7/17

32164 2/3/17 34 111.52 49.13 3.28 Erica Smith Iowa 54990 NorthCentral Office Supplies Pens & Art Supplies 2/4/17

32164 2/3/17 22 6515.96 3681.67 296.18 Erica Smith Iowa 54990 NorthCentral Furniture Tables 2/4/17

32164 2/3/17 13 75.14 31.14 5.78 Erica Smith Iowa 54990 NorthCentral Office Supplies Paper 2/4/17

39904 2/3/17 45 364.05 -142.85 8.09 Alejandro Grove California 90835 NorthWest Furniture Office Furnishings 2/4/17

43781 2/3/17 45 492.3 -153.35 10.94 Claudia Miner Delaware 19936 Northeast Office Supplies Envelopes 2/3/17

43781 2/3/17 22 901.56 555.50 40.98 Claudia Miner Delaware 19936 Northeast Office Supplies Binders and Binder Accessories 2/4/17

52322 2/3/17 1 3.95 -1.95 3.95 Joni Blumstein Connecticut 6817 Northeast Technology Networking Devices 2/10/17

55713 2/3/17 46 5657.54 702.15 122.99 Alan Schoenberger Colorado 80001 NorthWest Furniture Chairs & Chairmats 2/5/17

55877 2/3/17 21 125.58 45.85 5.98 Erin Mull Alabama 36922 Southwest Office Supplies Paper 2/4/17

55877 2/3/17 47 144.76 140.28 3.08 Erin Mull Alabama 36922 Southwest Office Supplies Labels 2/5/17

24197 2/4/17 42 2349.48 -909.45 55.94 David Smith Maryland 20601 East Technology Computer Peripherals 2/11/17

24197 2/4/17 2 41.98 -17.78 20.99 David Smith Maryland 20601 East Technology Telephones and Communication 2/11/17

56931 2/4/17 29 231.71 94.92 7.99 Dionis Lloyd North Carolina 27010 East Technology Telephones and Communication 2/6/17

1222 2/5/17 49 258.72 -93.64 5.28 Nicole Brennan California 95503 NorthWest Office Supplies Paper 2/5/17

10630 2/5/17 48 2790.72 -45.68 58.14 Pauline Johnson New York 11769 Northeast Furniture Bookcases …

Orders

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/13/10 Low 6 261.54 0.04 Regular Air -213.25 38.94 35 Muhammed MacIntyre Nunavut Nunavut Small Business Office Supplies Storage & Organization Eldon Base for stackable storage shelf, platinum Large Box 0.8 10/20/10

2 6 2/20/12 Not Specified 2 6.93 0.01 Regular Air -4.64 2.08 2.56 Ruben Dartt Alberta West Corporate Office Supplies Scissors, Rulers and Trimmers Kleencut® Forged Office Shears by Acme United Corporation Small Pack 0.55 2/21/12

3 32 7/15/11 High 26 2808.08 0.07 Regular Air 1054.82 107.53 5.81 Liz Pelletier 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/17/11

4 32 7/15/11 High 24 1761.4 0.09 Delivery Truck -1748.56 70.89 89.3 Liz Pelletier Alberta West Corporate Furniture Tables KI Conference Tables Jumbo Box 0.72 7/16/11

5 32 7/15/11 High 23 160.2335 0.04 Regular Air -85.13 7.99 5.03 Liz Pelletier Alberta West Corporate Technology Telephones and Communication Bell Sonecor JB700 Caller ID Medium Box 0.6 7/17/11

6 32 7/15/11 High 15 140.56 0.04 Regular Air -128.38 8.46 8.99 Liz Pelletier Saskachewan Prarie Corporate Technology Computer Peripherals Imation 3.5 IBM Diskettes, 10/Box Small Pack 0.79 7/16/11

7 35 10/22/11 Not Specified 30 288.56 0.03 Regular Air 60.72 9.11 2.25 Julie Creighton British Columbia West Corporate Office Supplies Pens & Art Supplies Dixon Ticonderoga Core-Lock Colored Pencils Wrap Bag 0.52 10/23/11

8 35 10/22/11 Not Specified 14 1892.848 0.01 Regular Air 48.99 155.99 8.99 Julie Creighton British Columbia West Corporate Technology Telephones and Communication CF 688 Small Box 0.58 10/24/11

9 36 11/2/11 Critical 46 2484.7455 0.1 Regular Air 657.48 65.99 4.2 Sample Company A Alberta West Home Office Technology Telephones and Communication 6162i Small Box 0.55 11/2/11

10 65 3/17/11 Critical 32 3812.73 0.02 Regular Air 1470.30 115.79 1.99 Tamara Dahlen Ontario Ontario Corporate Technology Computer Peripherals Verbatim DVD-R, 4.7GB, Spindle, WE, Blank, Ink Jet/Thermal, 20/Spindle Small Pack 0.49 3/18/11

11 66 1/19/09 Low 41 108.15 0.09 Regular Air 7.57 2.88 0.7 Arthur Gainer Alberta West Consumer Office Supplies Pens & Art Supplies Newell 340 Wrap Bag 0.56 1/19/09

12 69 6/3/09 Not Specified 42 1186.06 0.09 Regular Air 511.69 30.93 3.92 Jonathan Doherty Saskachewan Prarie Corporate Furniture Office Furnishings Advantus Employee of the Month Certificate Frame, 11 x 13-1/2 Small Pack 0.44 6/5/09

13 69 6/3/09 Not Specified 28 51.53 0.03 Express Air 0.35 1.68 0.7 Jonathan Doherty Saskachewan Prarie Corporate Office Supplies Pens & Art Supplies Newell 308 Wrap Bag 0.6 6/5/09

14 70 12/17/10 Low 48 90.05 0.03 Regular Air -107.00 1.86 2.58 Helen Wasserman Quebec Quebec Home Office Office Supplies Rubber Bands Super Bands, 12/Pack Wrap Bag 0.82 12/22/10

15 70 12/17/10 Low 46 7804.53 0.05 Regular Air 2057.17 205.99 5.99 Helen Wasserman Quebec Quebec Home Office Technology Telephones and Communication 3285 Small Box 0.59 12/22/10

16 96 4/16/09 High 37 4158.1235 0.01 Regular Air 1228.89 125.99 8.99 Keith Dawkins Manitoba Prarie Home Office Technology Telephones and Communication SC7868i Small Box 0.55 4/18/09

17 97 1/28/10 Medium 26 75.57 0.03 Regular Air 28.24 2.89 0.5 Craig Yedwab Yukon Yukon Consumer Office Supplies Labels Avery 498 Small Box 0.38 1/29/10

18 129 11/18/12 Low 4 32.72 0.09 Regular Air -22.59 6.48 8.19 Pauline Chand Ontario Ontario Corporate Office Supplies Paper Xerox 217 Small Box 0.37 11/27/12

19 130 5/7/12 High 3 461.89 0.05 Express Air -309.82 150.98 13.99 Roy Collins Saskachewan Prarie Corporate Technology Office Machines Canon MP41DH Printing Calculator Medium Box 0.38 5/9/12

20 130 5/7/12 High 29 575.11 0.02 Regular Air 71.75 18.97 9.03 Roy Collins Saskachewan Prarie Corporate Office Supplies Paper Computer Printout Paper with Letter-Trim Perforations Small Box 0.37 5/8/12

21 130 5/7/12 High 23 236.46 0.05 Regular Air -134.31 9.71 9.45 Roy Collins Saskachewan Prarie Corporate Office Supplies Storage & Organization Filing/Storage Totes and Swivel Casters Small Box 0.6 5/10/12

22 132 6/10/10 Medium 27 192.814 0.03 Regular Air -86.20 7.99 5.03 Emily Phan Quebec Quebec Consumer Technology Telephones and Communication Bell Sonecor JB700 Caller ID Medium Box 0.6 6/11/10

23 132 6/10/10 Medium 30 4011.65 0.05 Delivery Truck -603.80 130.98 54.74 Emily Phan Nova Scotia Atlantic Consumer Furniture Bookcases O’Sullivan Elevations Bookcase, Cherry Finish Jumbo Box 0.69 6/13/10

24 134 4/30/12 Not Specified 11 1132.6 0.01 Regular Air -310.21 95.99 35 Michael Dominguez Ontario Ontario Home Office Office Supplies Storage & Organization Safco Industrial Wire Shelving Large Box 5/2/12

25 135 10/20/11 Not Specified 25 125.85 0.09 Regular Air -89.25 4.98 4.62 Anne Pryor Quebec Quebec Consumer Technology Computer Peripherals Imation 3.5″, DISKETTE 44766 HGHLD3.52HD/FM, 10/Pack Small Pack 0.64 10/22/11

26 166 9/11/11 High 10 567.936 0.02 Express Air -126.09 65.99 8.99 Valerie Takahito Manitoba Prarie Consumer Technology Telephones and Communication i270 Small Box 0.55 9/13/11

27 193 8/7/10 Critical 14 174.89 0.06 Regular Air -37.04 12.44 6.27 Justin Hirsh Quebec Quebec Consumer Office Supplies Storage & Organization Eldon Simplefile® Box Office® Medium Box 0.57 8/9/10

28 194 4/4/12 Medium 49 329.03 0.1 Regular Air -197.25 7.28 7.98 Maria Zettner Alberta West Corporate Furniture Office Furnishings Master Caster Door Stop, Large Neon Orange Wrap Bag 0.42 4/6/12

29 194 4/4/12 Medium 6 20.19 0.04 Regular Air -13.44 3.14 1.92 Maria Zettner Alberta West Corporate Office Supplies Scissors, Rulers and Trimmers Serrated Blade or Curved Handle Hand Letter Openers Wrap Bag 0.84 4/6/12

30 195 12/27/10 Medium 34 1315.74 0.03 Regular Air 260.87 36.55 13.89 Brad Thomas Yukon Yukon Home Office Office Supplies Pens & Art Supplies Dixon Ticonderoga Core-Lock Colored Pencils, 48-Color Set Wrap Bag 0.41 12/29/10

31 197 4/6/11 High 23 310.52 0.01 Regular Air 33.22 12.98 3.14 Penelope Sewall Manitoba Prarie Home Office Office Supplies Scissors, Rulers and Trimmers Acme® 8″ Straight Scissors Small Pack 0.6 4/8/11

32 224 6/17/09 Not Specified 25 184.86 0.09 Regular Air -33.95 7.38 5.21 Bart Folk Yukon Yukon Corporate Furniture Office Furnishings Eldon® Expressions™ Wood Desk Accessories, Oak Small Box 0.56 6/18/09

33 224 6/17/09 Not Specified 44 267.85 0.04 Regular Air -65.43 5.98 5.15 Bart Folk Yukon Yukon Corporate Office Supplies Paper Xerox 193 Small Box 0.36 6/18/09

34 224 6/17/09 Not Specified 33 528.5 0.04 Regular Air -149.92 15.42 10.68 Bart Folk Yukon Yukon Corporate Office Supplies Storage & Organization Decoflex Hanging Personal Folder File, Blue Small Box 0.58 6/18/09

35 225 5/24/11 Critical 24 126.58 0.06 Regular Air 18.27 5.58 0.7 Karen Ferguson Quebec Quebec Home Office Office Supplies Pens & Art Supplies Newell 314 Wrap Bag 0.6 5/25/11

36 225 5/24/11 Critical 1 23.7 0.05 Regular Air -8.97 19.84 4.1 Karen Ferguson Quebec Quebec Home Office Office Supplies Pens & Art Supplies Prismacolor Color Pencil Set Wrap Bag 0.44 5/26/11

37 229 12/28/10 Critical 43 586.11 0.11 Regular Air 98.44 12.64 4.98 Matt Abelman Nova Scotia Atlantic Consumer Furniture Office Furnishings Nu-Dell Executive Frame Small Pack 0.48 12/30/10

38 229 12/28/10 Critical 24 599.1 0.02 Regular Air 3.82 24.92 12.98 Peter Fuller Saskachewan Prarie Consumer Office Supplies Binders and Binder Accessories GBC Standard Therm-A-Bind Covers Small Box 0.39 12/29/10

39 230 10/26/10 Critical 47 2029.75 0.06 Regular Air 320.37 43.98 8.99 Erin Creighton Ontario Ontario Corporate Office Supplies Pens & Art Supplies Boston 1645 Deluxe Heavier-Duty Electric Pencil Sharpener Small Pack 0.58 10/28/10

40 230 10/26/10 Critical 11 1118.396 0.06 Regular Air -212.33 125.99 8.08 Erin Creighton Ontario Ontario Corporate Technology Telephones and Communication StarTAC ST7762 Small Box 0.57 10/28/10

41 231 9/28/09 High 2 689.74 0.06 Regular Air -490.84 363.25 19.99 Sean Braxton Manitoba Prarie Small Business Office Supplies Appliances Hoover WindTunnel™ Plus Canister Vacuum Small Box 0.57 9/30/09

42 258 12/28/10 Critical 21 154.35 0 Regular Air -91.14 6.48 8.74 Liz Willingham Nova Scotia Atlantic Home Office Office Supplies Paper Xerox 1984 Small Box 0.36 12/30/10

43 258 12/28/10 Critical 7 201.36 0 Delivery Truck -284.40 20.98 53.03 Liz Willingham Nova Scotia Atlantic Home Office Office Supplies Storage & Organization Tennsco Lockers, Gray Jumbo Drum 0.78 12/29/10

44 258 12/28/10 Critical 33 216.77 0.02 Regular Air -55.11 6.54 5.27 Liz Willingham Quebec Quebec Home Office Office Supplies Binders and Binder Accessories Wilson Jones® Four-Pocket Poly Binders Small Box 0.36 12/30/10

45 261 6/28/10 Medium 47 5677.609 0.04 Regular Air 1680.79 140.99 4.2 Sonia Sunley British Columbia West Small Business Technology Telephones and Communication 7160 Small Box 0.59 6/29/10

46 263 5/16/09 High 25 136.77 0.09 Regular Air -136.25 5.4 7.78 Paul Lucas Yukon Yukon Corporate Office Supplies Binders and Binder Accessories 3M Organizer Strips Small Box 0.37 5/17/09

47 290 1/5/09 Not Specified 24 188.73 0.05 Regular Air -32.48 7.64 5.83 Dorris Love Quebec Quebec Home Office Office Supplies Paper Rediform Wirebound “Phone Memo” Message Book, 11 x 5-3/4 Wrap Bag 0.36 1/6/09

48 292 1/12/12 High 43 412.62 0.08 Regular Air 175.54 9.9 1.39 Valerie Takahito Saskachewan Prarie Consumer Office Supplies Envelopes #6 3/4 Gummed Flap White Envelopes Small Box 0.37 1/13/12

49 293 10/1/12 High 49 10123.02 0.07 Delivery Truck 457.81 208.16 68.02 Barry French Nunavut Nunavut Consumer Office Supplies Appliances 1.7 Cubic Foot Compact “Cube” Office Refrigerators Jumbo Drum 0.58 10/2/12

50 293 10/1/12 High 27 244.57 0.01 Regular Air 46.71 8.69 2.99 Barry French Nunavut Nunavut Consumer Office Supplies Binders and Binder Accessories Cardinal Slant-D® Ring Binder, Heavy Gauge Vinyl Small Box 0.39 10/3/12

51 294 7/15/10 Medium 35 6375.28 0.06 Regular Air 489.02 193.17 19.99 Sanjit Chand British Columbia West Home Office Office Supplies Storage & Organization Fellowes Staxonsteel® Drawer Files Small Box 0.71 7/16/10

52 322 3/18/12 Critical 20 2634.8555 0.08 Regular Air 257.76 155.99 8.08 Giulietta Weimer British Columbia West Corporate Technology Telephones and Communication I888 World Phone Small Box 0.6 3/20/12

53 322 3/18/12 Critical 46 281 0.1 Regular Air -291.59 6.48 10.05 Giulietta Weimer British Columbia West Corporate Office Supplies Paper Xerox 1997 Small Box 0.37 3/20/12

54 323 3/25/09 Critical 20 108.09 0.07 Regular Air 25.76 5.68 1.39 Dario Medina Yukon Yukon Small Business Office Supplies Envelopes Staples Standard Envelopes Small Box 0.38 3/27/09

55 323 3/25/09 Critical 2 55.34 0.06 Regular Air -31.24 22.84 11.54 Dario Medina Yukon Yukon Small Business Office Supplies Paper Xerox 1964 Small Box 0.39 3/27/09

56 324 3/19/12 Critical 25 3872.634 0.02 Regular Air 667.33 179.99 13.99 Frank Gastineau Saskachewan Prarie Small Business Technology Telephones and Communication VTech VT20-2481 2.4GHz Two-Line Phone System w/Answering Machine Medium Box 0.57 3/21/12

57 325 10/16/10 Low 9 884.1275 0.06 Regular Air -178.71 115.99 4.23 Craig Yedwab Nova Scotia Atlantic Corporate Technology Telephones and Communication 282 Small Box 0.56 10/20/10

58 326 6/3/11 High 34 218.27 0.03 Regular Air -44.14 5.99 4.92 Michelle Tran Quebec Quebec Consumer Office Supplies Binders and Binder Accessories DXL™ Angle-View Binders with Locking Rings, Black Small Box 0.38 6/4/11

59 326 6/3/11 High 17 100.95 0.05 Regular Air -21.30 5.81 3.37 Michelle Tran Quebec Quebec Consumer Office Supplies Rubber Bands Advantus Push Pins, Aluminum Head Wrap Bag 0.54 6/4/11

60 353 12/30/10 Low 21 46.94 0.02 Regular Air 3.88 2.21 1 Dean Percer Yukon Yukon Home Office Office Supplies Pens & Art Supplies Quartet Alpha® White Chalk, 12/Pack Wrap Bag 0.38 4/1/11

61 355 6/13/09 Low 16 1239.6315 0 Regular Air -172.55 85.99 0.99 Henry MacAllister Ontario Ontario Small Business Technology Telephones and Communication Accessory4 Wrap Bag 0.85 6/18/09

62 358 9/19/10 High 33 1640.9 0.02 Delivery Truck -1348.06 48.58 54.11 Ricardo Block Alberta West Corporate Furniture Bookcases O’Sullivan 2-Shelf Heavy-Duty Bookcases Jumbo Box 0.69 9/21/10

63 358 9/19/10 High 33 1235.87 0.07 Regular Air 269.27 39.48 1.99 Ricardo Block Alberta West Corporate Technology Computer Peripherals 80 Minute CD-R Spindle, 100/Pack – Staples Small Pack 0.54 9/19/10

64 359 12/18/09 Medium 30 3659.66 0.08 Delivery Truck -500.38 124.49 51.94 Cari Sayre Alberta West Corporate Furniture Tables Bevis 36 x 72 Conference Tables Jumbo Box 0.63 12/19/09

65 384 3/2/12 Low 50 7666.04 0.02 Delivery Truck -1820.84 146.05 80.2 Sonia Cooley Alberta West Corporate Furniture Tables BPI Conference Tables Jumbo Box 0.71 3/9/12

66 386 1/24/11 High 4 14.96 0.02 Regular Air -0.03 3.69 0.5 Tracy Poddar Ontario Ontario Corporate Office Supplies Labels Avery 501 Small Box 0.38 1/26/11

67 386 1/24/11 High 4 15.69 0.09 Regular Air -1.59 3.85 0.7 Tracy Poddar Ontario Ontario Corporate Office Supplies Pens & Art Supplies Avery Hi-Liter Pen Style Six-Color Fluorescent Set Wrap Bag 0.44 1/26/11

68 388 12/15/12 Not Specified 46 517.93 0.06 Regular Air -94.73 11.7 6.96 Jennifer Halladay Ontario Ontario Home Office Office Supplies Appliances Harmony HEPA Quiet Air Purifiers Medium Box 0.5 12/18/12

69 416 9/26/10 Low 20 1156.6715 0.01 Express Air 88.52 65.99 7.69 Stuart Calhoun Ontario Ontario Consumer Technology Telephones and Communication 5190 Small Box 0.59 10/1/10

70 417 2/5/09 Medium 39 15260.78 0.07 Delivery Truck 8734.88 500.98 28.14 Robert Barroso Yukon Yukon Small Business Technology Office Machines Hewlett-Packard cp1700 [D, PS] Series Color Inkjet Printers Jumbo Drum 0.38 2/6/09

71 417 2/5/09 Medium 3 540.41 0.1 Regular Air -170.98 178.47 19.99 Robert Barroso Yukon Yukon Small Business Office Supplies Storage & Organization Hot File® 7-Pocket, Floor Stand Small Box 0.55 2/7/09

72 420 10/30/11 Not Specified 8 43.29 0.09 Regular Air -20.69 4.98 4.86 Tony Sayre Alberta West Small Business Office Supplies Paper Xerox 190 Small Box 0.38 10/30/11

73 420 10/30/11 Not Specified 6 41.7 0.03 Regular Air -14.56 5.78 5.37 Tony Sayre Alberta West Small Business Office Supplies Paper Xerox 1950 Small Box 0.36 11/1/11

74 448 8/20/11 Medium 22 1162.4005 0.09 Regular Air -284.63 65.99 19.99 Brad Thomas Yukon Yukon Corporate Technology Telephones and Communication iDENi80s Small Box 0.59 8/22/11

75 449 7/19/11 High 45 356.7 0.02 Regular Air -48.97 7.38 5.21 Candace McMahon Ontario Ontario Corporate Furniture Office Furnishings Eldon® Expressions™ Wood Desk Accessories, Oak Small Box 0.56 7/21/11

76 450 3/4/11 Not Specified 29 1000.78 0.05 Express Air 109.33 34.58 8.99 Matt Collins British Columbia West Consumer Office Supplies Pens & Art Supplies Panasonic KP-350BK Electric Pencil Sharpener with Auto Stop Small Pack 0.56 3/5/11

77 450 3/4/11 Not Specified 35 543.72 0.05 Regular Air -211.13 15.7 11.25 Matt Collins British Columbia West Consumer Office Supplies Storage & Organization Hanging Personal Folder File Small Box 0.6 3/6/11

78 454 12/26/11 Low 42 234.2 0.09 Regular Air 56.22 6.08 1.82 Darrin Martin Ontario Ontario Small Business Office Supplies Rubber Bands Staples Bulk Pack Metal Binder Clips Wrap Bag 0.35 12/28/11

79 481 10/7/12 High 44 4509.3775 0.01 Regular Air 1426.26 115.99 5.26 Art Foster British Columbia West Home Office Technology Telephones and Communication 636 Small Box 0.57 10/9/12

80 483 7/10/11 High 30 4965.7595 0.08 Regular Air 1198.97 195.99 3.99 Clay Rozendal Nunavut Nunavut Corporate Technology Telephones and Communication R380 Small Box 0.58 7/12/11

81 487 8/17/12 Critical 19 210.4 0.07 Regular Air -18.96 10.89 4.5 Valerie Dominguez Manitoba Prarie Corporate Office Supplies Appliances Belkin 6 Outlet Metallic Surge Strip Small Box 0.59 8/18/12

82 512 5/19/11 Low 6 1309.53 0.06 Regular Air 19.18 218.08 18.06 Sam Craven Saskachewan Prarie Home Office Furniture Chairs & Chairmats Lifetime Advantage™ Folding Chairs, 4/Carton Large Box 0.57 5/19/11

83 512 5/19/11 Low 48 806.37 0.01 Express Air -166.40 15.42 10.68 Sam Craven Saskachewan Prarie Home Office Office Supplies Storage & Organization Decoflex Hanging Personal Folder File, Blue Small Box 0.58 5/21/11

84 513 4/30/11 High 33 5437.92 0 Delivery Truck -684.57 150.89 60.2 Arthur Prichep Ontario Ontario Home Office Furniture Chairs & Chairmats Global Leather & Oak Executive Chair, Burgundy Jumbo Drum 0.77 4/30/11

85 515 8/28/10 Not Specified 19 394.27 0.08 Regular Air 30.94 21.78 5.94 Carlos Soltero Nunavut Nunavut Consumer Office Supplies Appliances Holmes HEPA Air Purifier Medium Box 0.5 8/30/10

86 515 8/28/10 Not Specified 21 146.69 0.05 Regular Air 4.43 6.64 4.95 Carlos Soltero Nunavut Nunavut Consumer Furniture Office Furnishings G.E. Longer-Life Indoor Recessed Floodlight Bulbs Small Pack 0.37 8/30/10

87 548 9/20/09 Critical 41 129.49 0.04 Regular Air 36.02 3.08 0.99 Sung Chung Saskachewan Prarie Home Office Office Supplies Labels Avery 481 Small Box 0.37 9/21/09

88 548 9/20/09 Critical 29 202.95 0.02 Regular Air -50.64 6.48 5.9 Sung Chung Saskachewan Prarie Home Office Office Supplies Paper Xerox 1976 Small Box 0.37 9/21/09

89 548 9/20/09 Critical 26 2753.1925 0.04 Regular Air 510.49 125.99 4.2 Sung Chung Saskachewan Prarie Home Office Technology Telephones and Communication V3682 Small Box 0.59 9/22/09

90 549 7/12/12 Critical 13 70.24 0.03 Regular Air -59.75 4.98 7.44 Ken Brennan Ontario Ontario Consumer Office Supplies Paper Xerox 1922 Small Box 0.36 7/13/12

91 549 7/12/12 Critical 5 40.75 0.05 Regular Air -27.57 6.48 8.74 Ken Brennan Ontario Ontario Consumer Office Supplies Paper Xerox 1984 Small Box 0.36 7/13/12

92 549 7/12/12 Critical 30 1150.88 0.05 Express Air -911.56 38.94 35 Ken Brennan Ontario Ontario Consumer Office Supplies Storage & Organization Eldon Base for stackable storage shelf, platinum Large Box 0.8 7/12/12

93 610 8/1/11 Critical 38 283.65 0.02 Express Air -29.21 6.68 5.41 Joe Elijah Manitoba Prarie Home Office Office Supplies Paper Xerox 195 Small Box 0.37 8/3/11

94 611 1/26/10 Critical 47 840.04 0.04 Regular Air -131.27 17.7 9.47 Arthur Prichep Ontario Ontario Home Office Office Supplies Storage & Organization Portfile® Personal File Boxes Small Box 0.59 1/28/10

95 612 10/20/12 Medium 50 262.87 0.1 Regular Air -166.29 5.28 6.26 Sheri Gordon Manitoba Prarie Corporate Office Supplies Paper Xerox 1928 Small Box 0.4 10/22/12

96 612 10/20/12 Medium 43 2531.0875 0.01 Regular Air 881.68 65.99 2.5 Sheri Gordon Manitoba Prarie Corporate Technology Telephones and Communication 6190 Small Box 0.55 10/22/12

97 613 6/17/11 High 12 93.54 0.03 Regular Air -54.04 7.3 7.72 Carl Jackson Nunavut Nunavut Corporate Office Supplies Binders and Binder Accessories Angle-D Binders with Locking Rings, Label Holders Small Box 0.38 6/17/11

98 613 6/17/11 High 22 905.08 0.09 Regular Air 127.70 42.76 6.22 Carl Jackson Nunavut Nunavut Corporate Office Supplies Storage & Organization SAFCO Mobile Desk Side File, Wire Frame Small Box 6/18/11

99 614 11/30/12 High 41 628.22 0 Regular Air 163.81 14.34 5 Dave Hallsten Quebec Quebec Corporate Furniture Office Furnishings Nu-Dell Leatherette Frames Small Pack 0.49 12/2/12

100 614 11/30/12 High 24 3366.1 0.07 Delivery Truck -335.32 138.75 52.42 Dave Hallsten Quebec Quebec Corporate Furniture Tables Balt Split Level Computer Training Table Jumbo Box 0.74 12/1/12

101 640 1/22/10 High 39 4913.69 0.02 Delivery Truck -1153.90 120.98 58.64 Tamara Chand Ontario Ontario Consumer Furniture Bookcases O’Sullivan Living Dimensions 2-Shelf Bookcases Jumbo Box 0.75 1/23/10

102 640 1/22/10 High 24 464.77 0.01 Regular Air 29.42 18.97 9.54 Tamara Chand Ontario Ontario Consumer Office Supplies Paper Xerox 1939 Small Box 0.37 1/23/10

103 643 3/24/11 High 21 2781.82 0.07 Express Air -695.26 138.14 35 Monica Federle Nunavut Nunavut Corporate Office Supplies Storage & Organization SAFCO Commercial Wire Shelving, Black Large Box 3/25/11

104 644 4/30/12 Critical 5 1679.58 0.01 Delivery Truck -171.92 320.98 58.95 Bill Eplett Quebec Quebec Corporate Furniture Chairs & Chairmats Hon 4070 Series Pagoda™ Round Back Stacking Chairs Jumbo Drum 0.57 5/1/12

105 645 12/2/09 High 42 557.85 0.05 Regular Air 89.45 12.95 4.98 Harold Engle Prince Edward Island Atlantic Consumer Office Supplies Binders and Binder Accessories GBC Binding covers Small Box 0.4 12/4/09

106 646 11/21/09 High 18 173.2 0.01 Regular Air -10.90 9.31 3.98 Duane Huffman Ontario Ontario Small Business Office Supplies Scissors, Rulers and Trimmers Acme® Forged Steel Scissors with Black Enamel Handles Small Pack 0.56 11/22/09

107 678 2/26/10 Low 44 228.41 0.07 Regular Air -226.36 4.98 8.33 Dorothy Badders Nunavut Nunavut Home Office Office Supplies Paper Xerox 198 Small Box 0.38 2/26/10

108 706 9/8/11 Critical 42 75.14 0.05 Regular Air 0.82 1.76 0.7 Sarah Jordon Nova Scotia Atlantic Consumer Office Supplies Pens & Art Supplies Newell 326 Wrap Bag 0.56 9/10/11

109 710 1/1/10 Low 42 161.77 0.01 Regular Air -150.37 3.58 5.47 Susan MacKendrick Manitoba Prarie Corporate Office Supplies Binders and Binder Accessories Avery Poly Binder Pockets Small Box 0.37 1/5/10

110 710 1/1/10 Low 11 447.09 0.09 Regular Air 89.03 41.32 8.66 Susan MacKendrick Manitoba Prarie Corporate Furniture Office Furnishings Deflect-o EconoMat Studded, No Bevel Mat for Low Pile Carpeting Medium Box 0.76 1/3/10

111 710 1/1/10 Low 29 4192.88 0.02 Delivery Truck 731.32 145.45 17.85 Susan MacKendrick Manitoba Prarie Corporate Technology Office Machines Panasonic KX-P1150 Dot Matrix Printer Jumbo Drum 0.56 1/5/10

112 738 3/1/10 Not Specified 7 560.51 0.04 Regular Air 32.60 80.98 4.5 Caroline Jumper Quebec Quebec Corporate Office Supplies Appliances Belkin 8 Outlet SurgeMaster II Gold Surge Protector with Phone Protection Small Box 0.59 3/3/10

113 738 3/1/10 Not Specified 31 189.95 0.08 Regular Air -56.68 6.48 5.14 Caroline Jumper Quebec Quebec Corporate Office Supplies Paper Xerox 23 Small Box 0.37 3/2/10

114 740 7/15/11 Medium 6 28.01 0.09 Regular Air 3.46 4.98 0.49 Thomas Boland Ontario Ontario Corporate Office Supplies Labels Avery White Multi-Purpose Labels Small Box 0.39 7/15/11

115 769 6/1/10 Medium 37 4261.94 0.02 Delivery Truck 4.15 115.99 56.14 Roy French Prince Edward Island Atlantic Consumer Technology Office Machines Hewlett-Packard Deskjet 5550 Color Inkjet Printer Jumbo Drum 0.4 6/2/10

116 771 6/16/11 Critical 18 88.84 0.08 Regular Air -38.35 4.98 4.72 Darrin Van Huff Saskachewan Prarie Home Office Office Supplies Paper Xerox 1949 Small Box 0.36 6/17/11

117 772 4/16/10 High 35 589.24 0.08 Regular Air -38.35 17.52 8.17 Pamela Stobb Quebec Quebec Consumer Office Supplies Appliances Bionaire 99.97% HEPA Air Cleaner Medium Box 0.5 4/18/10

118 772 4/16/10 High 25 233.05 0.1 Regular Air 86.93 9.9 1.39 Pamela Stobb Quebec Quebec Consumer Office Supplies Envelopes #6 3/4 Gummed Flap White Envelopes Small Box 0.37 4/18/10

119 773 9/25/10 Medium 38 2071.3395 0.06 Regular Air 324.93 65.99 8.99 Helen Abelman Prince Edward Island Atlantic Home Office Technology Telephones and Communication Talkabout T8367 Small Box 0.56 9/26/10

120 774 12/3/11 Critical 17 126.57 0.03 Regular Air -752.13 4.48 49 Sibella Parks Alberta West Small Business Office Supplies Appliances Hoover Portapower™ Portable Vacuum Large Box 0.6 12/5/11

121 775 3/17/11 Critical 35 43.57 0.1 Regular Air -19.17 1.26 0.7 Peter McVee Nova Scotia Atlantic Small Business Office Supplies Rubber Bands Bagged Rubber Bands Wrap Bag 0.81 3/18/11

122 775 3/17/11 Critical 8 31.87 0.1 Regular Air -1.25 4.26 1.2 Peter McVee Nova Scotia Atlantic Small Business Office Supplies Pens & Art Supplies Dixon Prang® Watercolor Pencils, 10-Color Set with Brush Wrap Bag 0.44 3/19/11

123 801 2/17/12 Critical 20 59.85 0.03 Regular Air -47.41 2.74 3.5 Thais Sissman Manitoba Prarie Corporate Office Supplies Pens & Art Supplies Rogers Handheld Barrel Pencil Sharpener Small Pack 0.58 2/20/12

124 802 1/4/11 Critical 33 378.6 0.08 Regular Air 12.72 11.7 5.63 Kean Nguyen Ontario Ontario Corporate Office Supplies Binders and Binder Accessories Fellowes Binding Cases Small Box 0.4 1/6/11

125 802 1/4/11 Critical 2 38.5 0.09 Regular Air -52.14 15.99 9.4 Kean Nguyen Ontario Ontario Corporate Technology Office Machines AT&T Black Trimline Phone, Model 210 Small Box 0.49 1/4/11

126 805 7/4/11 Not Specified 39 197.56 0.02 Regular Air -119.86 4.97 5.71 Toby Swindell Saskachewan Prarie Small Business Furniture Office Furnishings DAX Value U-Channel Document Frames, Easel Back Medium Box 0.54 7/6/11

127 807 11/23/10 Medium 45 196.85 0.01 Regular Air -166.85 4.28 6.18 Neola Schneider Nunavut Nunavut Home Office Office Supplies Paper Xerox 1980 Small Box 0.4 11/24/10

128 807 11/23/10 Medium 32 124.56 0.04 Regular Air -14.33 3.95 2 Neola Schneider Nunavut Nunavut Home Office Office Supplies Rubber Bands Advantus Map Pennant Flags and Round Head Tacks Wrap Bag 0.53 11/24/10

129 832 4/18/12 Low 7 53.46 0.02 Regular Air -17.58 6.48 5.9 Alice McCarthy Alberta West Corporate Office Supplies Paper Xerox 1976 Small Box 0.37 4/22/12

130 833 2/12/09 Medium 1 19.32 0.03 Regular Air -20.32 12.53 7.17 Olvera Toch Ontario Ontario Home Office Office Supplies Binders and Binder Accessories GBC ProClick Spines for 32-Hole Punch Small Box 0.38 2/13/09

131 834 5/22/09 Medium 15 1813.04 0.01 Delivery Truck -164.40 115.99 56.14 Eugene Moren British Columbia West Home Office Technology Office Machines Hewlett-Packard Deskjet 5550 Color Inkjet Printer Jumbo Drum 0.4 5/23/09

132 835 10/7/11 Not Specified 18 125.16 0.02 Regular Air -23.48 6.48 5.14 Duane Huffman Ontario Ontario Small Business Office Supplies Paper Xerox 23 Small Box 0.37 10/8/11

133 837 6/14/09 Not Specified 11 65.7 0.01 Regular Air 13.41 5.84 0.83 Sean O’Donnell Ontario Ontario Corporate Office Supplies Pens & Art Supplies Avery Hi-Liter® Smear-Safe Highlighters Wrap Bag 0.49 6/16/09

134 868 6/8/12 Not Specified 32 716.84 0 Regular Air 134.72 21.78 5.94 Carlos Daly Nunavut Nunavut Home Office Office Supplies Appliances Holmes HEPA Air Purifier Medium Box 0.5 6/9/12

135 868 6/8/12 Not Specified 31 1474.33 0.04 Regular Air 114.46 47.98 3.61 Carlos Daly Nunavut Nunavut Home Office Technology Computer Peripherals DS/HD IBM Formatted Diskettes, 200/Pack – Staples Small Pack 0.71 6/10/12

136 870 6/19/10 Not Specified 23 1661.04 0.04 Regular Air 475.54 70.97 3.5 Valerie Dominguez Manitoba Prarie Corporate Office Supplies Appliances Tripp Lite Isotel 8 Ultra 8 Outlet Metal Surge Small Box 0.59 6/19/10

137 871 11/14/11 Low 17 104.94 0.06 Regular Air -34.97 6.24 5.22 David Kendrick Yukon Yukon Home Office Furniture Office Furnishings Eldon Expressions Mahogany Wood Desk Collection Small Box 0.6 11/14/11

138 896 3/8/10 Critical 50 1246.52 0.01 Regular Air 52.48 24.92 12.98 Edward Nazzal Ontario Ontario Home Office Office Supplies Binders and Binder Accessories GBC Standard Therm-A-Bind Covers Small Box 0.39 3/8/10

139 898 6/2/10 High 40 676.13 0.03 Regular Air 45.39 15.98 6.5 Sanjit Jacobs Quebec Quebec Consumer Technology Computer Peripherals Logitech Access Keyboard Small Box 0.48 6/4/10

140 898 6/2/10 High 26 7668.55 0.04 Delivery Truck -715.78 296.18 54.12 Sanjit Jacobs Quebec Quebec Consumer Furniture Tables Hon 94000 Series Round Tables Jumbo Box 0.76 6/2/10

141 900 9/30/09 Not Specified 29 1193.65 0.07 Regular Air 507.58 40.98 2.99 Karen Carlisle Nova Scotia Atlantic Home Office Office Supplies Binders and Binder Accessories Avery Trapezoid Ring Binder, 3″ Capacity, Black, 1040 sheets Small Box 0.36 10/1/09

142 902 7/26/09 Not Specified 10 1925.83 0.09 Regular Air 359.83 207.48 0.99 Meg O’Connel Manitoba Prarie Corporate Office Supplies Appliances Kensington 7 Outlet MasterPiece Power Center with Fax/Phone Line Protection Small Box 0.55 7/29/09

143 928 3/1/11 Low 21 1222.68 0.06 Express Air 300.97 59.98 3.99 Anthony O’Donnell British Columbia West Consumer Office Supplies Appliances Belkin 8 Outlet SurgeMaster II Gold Surge Protector Small Box 0.57 3/6/11

144 928 3/1/11 Low 26 390.2 0.02 Express Air 45.00 14.58 7.4 Anthony O’Donnell British Columbia West Consumer Furniture Office Furnishings DAX Clear Channel Poster Frame Small Box 0.48 3/3/11

145 929 10/1/12 High 21 227.66 0.04 Regular Air -100.16 10.97 6.5 Luke Foster Yukon Yukon Corporate Technology Computer Peripherals Micro Innovations 104 Keyboard Small Box 0.64 10/4/12

146 929 10/1/12 High 39 84.33 0.04 Regular Air -64.29 2.08 2.56 Luke Foster Yukon Yukon Corporate Office Supplies Scissors, Rulers and Trimmers Kleencut® Forged Office Shears by Acme United Corporation Small Pack 0.55 10/3/12

147 930 12/16/09 Critical 22 922.39 0.03 Express Air -41.64 41.32 58.66 Phillina Ober New Brunswick Atlantic Small Business Furniture Office Furnishings Deflect-o EconoMat Studded, No Bevel Mat for Low Pile Carpeting Medium Box 0.76 12/17/09

148 930 12/16/09 Critical 11 79.19 0 Regular Air 13.91 6.88 2 Phillina Ober New Brunswick Atlantic Small Business Office Supplies Paper Adams Phone Message Book, 200 …

ACCT 3303

Tableau Assignment

Spring 2021

Data Visualization Assignment Using Tableau Business Analytics Software [footnoteRef:1] [1: Adapted from Janvrin, D. R. Raschke, and W. Dilla. Making sense of complex data using interactive data visualization, Journal of Accounting Education 32 (2014) 31-48.]

Accounting information systems produce large amounts of data about a company’s business processes. Data visualization tools are one way of helping managers make sense of these data. The purpose of this assignment is to give you hands-on experience building a data visualization application using Tableau. Tableau is a leading software application for business intelligence. Tableau has interactive real-time functionality allowing users to build data viewing applications within an easy drag and drop interface.
This assignment contains two parts. First, you will complete a tutorial designed to get you familiar with the basics of Tableau. Next, your task will be to design a data viewing application in Tableau to help a manager make sense of sales and profit data for an office supply superstore. Detailed information regarding this assignment and using Tableau follow the tutorial on page 15.

Following are general instructions (a tutorial) for a sample dataset (Sample – Superstore Sales (Excel).xls) to get you started. Please note that there are two different Excel files: one for the following tutorial (Sample Superstore Sales (Excel).xls) and one for the assignment you turn in (SuperBrokeSales 2017-2020.xlsx).

Part 1. Tableau Basic Instructions

Note: These instructions show you the functionality of the software and provide an example of the functionality. For your assignment, you need to decide what information is useful and how to best present that information, meaning that you should not create chart(s)/graph(s) exactly like these examples. Instead, you need to create your own chart(s)/graph(s).

Tableau 2020.x is available in the COB labs (Rooms 339 and 349). It is strongly suggested that you download Tableau to use on your own personal computer. Please go to the landing page to download the software and enter the activation key. Note: the key below is for your use only. Please don’t share as we have enough licenses for this course only. You can download both programs, but only Tableau Desktop will be used for this assignment.
1. Download the latest version of Tableau Desktop and Tableau Prep Builder here

1. Click on the link above and select “Download Tableau Desktop”and“Download Tableau Prep Builder”. On the form, enter your school email address for Business E-mail and enter the name of your school for Organization.
1. Activate with your product key:  TCGV-455F-7D60-6E02-5BC5 
1. Already have a copy of Tableau Desktop installed? Update your license in the application: Help menu → Manage Product Keys
Are your students new to Tableau? Share our free Data Analytics for University Students guide to help them get started.
Students can continue using Tableau after the class is over by individually requesting their own one-year license through the Tableau for Students program. If you are interested in using Tableau after this key has expired, I recommend requesting a one-year Desktop key through the Tableau for Students program. Each year you are enrolled as a full-time student, you can request a new one-year key.
Need additional help? Check out the FAQs.
Tableau offers several training videos at http://www.tableau.com/learn/training. Select any of the On-Demand Training, specifically the Getting Started and The Tableau Interface. You may have to enter your data again to view the videos.

The above videos are also available from within Tableau from the Discover panel on the right side of your Tableau window when you first open Tableau (See Figure 1) or from the Help menu.
Even if you choose not to watch the videos, you definitely want to learn a little more about the terminology used in Tableau. Select Help from the Menu and select Open Help. Choose the Getting Started option from the Navigation pane on the left. From there, click on The Tableau Environment and finally, The Tableau Workspace. See the screenshot and explanations below for a quick overview of the Tableau workspace.

The following are the major components of the Sheet view of the Tableau workspace:

14
15
13
6
5
4
7
12
11
10
9
8
3
2
1

1. Workbook name 2. Menu bar 3. Toolbar
2. Go to the start page
3. Side bar: contains the Data pane and the Analytics pane. Other panes such as the Format pane will temporarily open here.
4. List of data sources (may be more than one)
5. Dimensions and Measures (available fields to be used in the data visualization)
6. Show Me card (shown opened): shows applicable visualization types for selected fields
7. Columns and Rows shelves (used to group headers [Dimensions] and axes [Measures])
8. Pages and Filters shelves: Pages shelf filters visualization by stepping or animating based on a particular field and Filters shelf filters visualizations by Dimension or Measure
9. Marks card: used to control mark properties, color, size, label, detail, tooltip, shape and angle
10. View: the work area where the visualizations appear
11. Sheet tabs: shows available sheets, dashboards and stories as well as the ability to create new ones
12. Status bar
13. Go to data source page

Import Data File

When you first open Tableau (See Figure 1) you want to connect to your data source.

Figure 1. Initial Tableau window
Choose the type of data source file, Excel, browse to find the Sample – Superstore Sales (Excel).xls file, select the file and click Open (See Figure 2).

Figure 2. Data Source File Type
Select Orders worksheet to analyze (See Figure 3). Either double-click Orders or click and drag Orders to the area that shows Drag sheets here.

Figure 3. Select Worksheet

Your screen should now look like Figure 4. If for some reason, the field names are not showing, click the down arrow on Orders pill shape and select Field names are in first row.

Figure 4. Connected to Data Source
Click Sheet 1 as shown in Figure 4, to move to the Tableau workspace (see Figure 5).

Figure 5. Workspace for Creating Chart

To create charts, drag dimensions and measures to “Drop Field Here” table or to the Column and Row shelves above the table in the Data Pane. For example, to create a bar chart showing total profits for each product category, drag the dimension Product Category to the Columns shelf and the measure Profit to the Row shelf (see Figure 6).

Figure 6. Profit by Product Category Bar Chart

Change Colors and Formatting

To add data labels, select the Label control from the Marks card of the
as shown in Figure 6.

Select the Show mark labels check box as shown in Figure 7.

Figure 7. Marks Task Bar
To change the color of the bars, select the Color control from the Marks card as shown in Figure 6. Choose a color of your choice. There is also an option for More Colors… if none of the colors speak to you.
You can also color by product category. Drag Product Category from the Dimensions pane to the Color control. The three bars are now uniquely colored and your graph should look like Figure 8.

Figure 8. Profit by Product Category Bar Chart with Unique Colors
The Product Category legend can be moved to the Marks section, by simply dragging and dropping the legend.

Figure 8a. Profit by Product Category Bar Chart with Unique Colors after
moving the Product Category Legend

To add a title to your chart, double-click on the Sheet 1 tab or in the Sheet 1 box at the top of your graph. Name the chart “Profit by Product Category.”

Filter Data and Create Drill Down Data

To filter data, drag the desired filter dimension to filter shelf. For our example, drag Order Date to the Filter shelf. The menu shown in Figure 9 should appear.
Select Years and click Next. Next, you can select years individually. Check 2010 and 2011 and click OK. Your screen should look Figure 10.

Figure 9. Filter Field Menu

Figure 10. Profit by Product Category for 2010 and 2011
If you want to hide the title, you can either select Worksheet from the Menu bar and uncheck Show Title or click on the down arrow by Title and select Hide Title (see Figure 11).
To add two more filters, drag the Region dimension to the Filters shelf, select Atlantic in the pop up window, and click OK. Drag the Product Category dimension to Filter area, select Furniture and Technology, then click OK. Your screen should look like Figure 11. Note that you can hover your mouse cursor over any bar and the tooltip text will appear.

Figure 11. Profit by Product Category for 2010 and 2011 for Furniture and Technology

Create Drill Down Data

As you have been working through this example, you have probably been making changes to the bar chart in your original worksheet. You can continue on the Profit by Product Category for the remainder of the tutorial or you can start creating new worksheets. Be sure to name your worksheets with more descriptive names than Sheet 1, etc. To rename a worksheet, double-click and type in the name or right-click on the worksheet tab and select Rename Sheet.

If you wish to start a new sheet, just click the icon to the right of the sheet tabs as show below:

Start from Figure 12 to drill down to show yearly profit of Office Supplies. You can clear all the filters by dragging the dimension out of the shelf or by clicking the down arrow on each blue shape and selecting Clear Filter (see screenshot below). In the case of the color control, selecting Remove. Alternatively, you can click the Clear Sheet icon on the Toolbar. Be aware that this will completely clear your sheet. It’s a good way to start over.

Figure 12. Illustration – Drill Down Starting Point
To drill down to show yearly profit, drag the Order Date dimension to the Detail control. If anything other than Year (Order Date) shows in the blue pill shape in the Marks card, click on the down arrow in the blue pill and select Year. Click the Label control and check the Show mark labels box. You might need to change the font size to 8 pr. Yearly profits show up on each bar. To make the chart more appealing, color the bars by dragging the Order Date dimension to the Color control (see Figure 13). Once again make sure you select Year if anything other than Year (Order Date) is showing in the Marks card.

Figure 13. Illustration –Bar Chart Color by Order Date Dimension

To drill down to show yearly profit of the Office Supplies product category, drag the Product Category dimension from the Columns shelf to the Filters shelf, select Office Supplies, and then click OK. Drag the Order Date dimension (Year(Order Date) ) to the Columns shelf. Remove the Year(Order Date) associated with the Detail control from the Marks card (see Figure 13). Drag the Product Category dimension to the Rows shelf. You may need to select the Bar option from the drop-down list in the Marks card. When completed, your bar chart should look like Figure 14.

Figure 14. Illustration – Drill Down for Yearly Profit of Office Supplies
To drill down further to show regional profit, simply drag the Region dimension to the Detail control in the Marks card, causing regional profit to show up on each bar. To make regional details more obvious, we can color bars by region. As you hover your cursor over regional profit, regional profit details are shown (see Figure 15).
We can also add one more Filter (Year(Order Date)), and manipulate the Columns and Rows shelves to show a clear drilled down chart showing only 2009’s regional office supply profit chart (see Figure 16).

Figure 15. Illustration – Drill Down Office Supplies Profit by Region

Figure 16. Illustration – Drill Down for 2009 Office Supply Profit by Region

To Save the File

· If you are working on a Lab computer, I recommend you save to a USB drive or to your J Drive. To save your data, select File Save As, select where you want to save your file and click save.
· If you are working on your own computer, do the following:
To insert new page to file, click Worksheet on toolbar and New Worksheet.
To save your data, select File Save As and save your file to your hard drive or to a USB drive. The next time you open Tableau on the computer you are currently working on, your project will appear on the Open pane on the Tableau start page.
If you work on different computer (i.e., in the Lab) you will need to connect to your data as described in these instructions.
To Save to a Packaged Workbook
You can either File Save As from the Menu bar and select Tableau Packaged Workbook (*.twbx) from the Save as type: drop-down list or you can select File Export Packaged Workbook from the Menu bar.

Part 2. Main Assignment

Scenario

The Super Big Company is a fictitious conglomerate with divisions in the retailing, manufacturing, and insurance industries. The retailing division consists of a chain of office supply stores known as Super Stores. You are the divisional controller of Super Stores. Pricing and product-line strategy decisions at Super Broke are made by the CEO, Steve Rogers, with input from the Vice President of Marketing. Super Store’s VP of Marketing has just resigned, and the CEO wants to reevaluate the pricing and product-line strategy decisions for each division. Super Big’s CFO has asked you to complete this assignment for Super Stores without her assistance. To decide about pricing and product-line strategy at Super Stores, you will provide the CEO with an interactive report presenting the various sales, profit, division, and product related information of Super Stores for the last three years. Be sure to compare multiple years of sales and profits side-by-side in the data view. You want the CEO to get
the best impression of Super Stores performance
.

Deliverables

1. Use Tableau data visualization software to produce
at least

five data views of various sales, profit, division, and product related information contained in the SuperStoresSales 2017-2020.xlsx workbook. Make sure you do not duplicate the graphs you do in the following tutorial. You need to come up with your own. Save these in a packaged workbook (.twbx) for Super Big’s CEO to use.

2. Write a one to two page memo to the CEO describing the data and how Tableau can be used to assist management in making additional pricing and product line strategy decisions. Note – The memo should not read like a marketing piece for Tableau. The focus of the memo is the output of your review of the data, your recommendations to the CEO, and how Tableau could be used to make decisions related to pricing and product-line strategy. Your memo will be stronger when you use specific examples of how changes to pricing or product-line strategy can help the organization.

Please upload your Tableau workbook file saved as your first_last name.twbx, and the memo saved as your first_last name.docx to Canvas via the Tableau Assignment. Note: the two files must be submitted at the same time.
15

error: Content is protected !!