excel question 2,2
Instructions
| EMPLOYEE LIST |
| On Employee List-Department |
| Add new column after Department called "Location" |
| Use Vlookup to add Location to the new column (from Employee List- Location tab) |
| Add new column after Department called "Employee ID" |
| Use Vlookup to add Employee ID to the new column (from Employee List- Location tab) |
| Copy/Paste Values and rearrange columns into the following: Employee ID, Employee, Location, Department |
| Use Countif to calculate the number of employees in each Department |
| Note- some Employees may not be on both lists, we will discuss how to clean this up |
| SALES ORDERS |
| On Sales Orders-Data |
| Spend some time cleaning up the data (formating cells, columns, etc) |
| Add new column "Total Sales" and calculate total sales |
| Make two new tabs making copies of this data set and label Sales Orders- Pivot Tables and Sales Orders-Charts |
| Sales Orders- Pivot Tables |
| Pivot Table to show Sales by Region sort in descending order of sales |
| Pivot Table to show Sales by Item Name sort in alpha order |
| Pivot Table to show quantity of Items sold |
| Pivot Table to show Sales by Product by Year by Quarter |
| Sales Orders- Charts |
| Create Pie Chart to show Sales by Item |
| Create Bar Chart to show Sales by Region |
| Create a Line Chart to show Sales by Quarter for 2018 and 2019 |
Employee List-Department
| Employee | Department |
| Al Grubbs | Finance |
| Alan Hudson | Marketing |
| Alan Ruley | Operations |
| Alec Dunbar | HR |
| Alfred Glenn | Finance |
| Alice J. Guerra | Finance |
| Allison Mcewen | HR |
| Alma Cruz | Marketing |
| Alphonso F. Gordon | Operations |
| Amos Bowes | Operations |
| Amy Fetter | Marketing |
| Amy Majors | Operations |
| Anne Boyd | Marketing |
| Annie Chaidez | Finance |
| Anthony Gary | Marketing |
| Anthony Guyette | Finance |
| Anthony Taylor | Finance |
| Amelia Taylor | Operations |
| Antonio Taylor | Operations |
| Arthur Clayson | Operations |
| Arthur Werner | Operations |
| Arthur Williams | Finance |
| Ashley Miller | Marketing |
| Audrey Vogel | HR |
| Austin Stone | Marketing |
| Barbara Roark | HR |
| Barbara Stolz | Operations |
| Bennie Evans | Operations |
| Betsy D. Kelly | Marketing |
| Betty Myers | Marketing |
| Beverly B. Gray | Finance |
| Beverly Escobar | HR |
| Beverly Soares | Finance |
| Bob Hunsberger | Operations |
| Booker Dunmire | Operations |
| Brandi Reynolds | Operations |
| Brandon Cutter | Operations |
| Brandy Walker | Marketing |
| Brenda White | Finance |
| Brian Bass | Finance |
| Bruce Burke | Finance |
| Bryan Demarco | Marketing |
| Caleb Ham | HR |
| Carl Dexter | Finance |
| Carly Iorio | Operations |
| Carol Wood | Operations |
| Carrie Bryan | Marketing |
| Cassandra Jackson | HR |
| Charles Bingham | Operations |
| Charles Head | HR |
| Charles S. Billings | Marketing |
| Charles S. Billings | Finance |
| Charles S. Billings | Finance |
| Charles Seeley | Finance |
| Chase Mcnamara | Operations |
| Cheryl Cory | HR |
| Cheryl Gaymon | Marketing |
| Christian Moye | HR |
| Christian Reynolds | Finance |
| Christine Poundsworth | Finance |
| Christopher Hudson | Operations |
| Christopher Huff | Operations |
| Christopher J. Polzin | Finance |
| Cindy Chow | Operations |
| Clarice Longenecker | Marketing |
| Clarissa Christiansen | HR |
| Clark Bickerson | Finance |
| Carl Bickerson | HR |
| Clarkson Bickerson | Finance |
| Clint Suarez | Finance |
| Clinton Soto | HR |
| Connie Combs | Operations |
| Cora Soto | Finance |
| Corinna Beltran | HR |
| Cristobal Lopez | Operations |
| Curtis Miller | Finance |
| Cynthia Beard | Operations |
| Cynthia Naskers | HR |
| Daniel Desantis | Marketing |
| Daniel Sandy | Operations |
| Danny Salinas | HR |
| David Adam | Finance |
| David Arellano | HR |
| David B. Ortiz | Finance |
| David Hare | Marketing |
| David Keller | Operations |
| David Pearce | HR |
| Dawn Purvis | Marketing |
| Dawne Thompson | Operations |
| Debbie Barlow | Finance |
| Deborah Sherman | Operations |
| Dennis R. Waxman | Finance |
| Devin Lear | HR |
| Diane Delgado | Operations |
| Diane Mcmahon | HR |
| Dianne Wong | Marketing |
| Donald Jackson | Operations |
| Donna Couch | Finance |
| Donna Wallace | Operations |
| Dorothy Herrera | Finance |
| Douglas Williams | Finance |
| Dustin Myres | HR |
| Dustin Tate | Marketing |
| Earnest Hale | Finance |
| Eddie Mangual | Operations |
| Edward Bryant | Operations |
| Elidia Bode | Finance |
| Elinor Love | Operations |
| Elise Bedgood | Operations |
| Elizabeth Cole | HR |
| Elmer Clifton | HR |
| Elmer Tompkins | Marketing |
| Elsie Haines | HR |
| Elsie Truong | Finance |
| Emily Jorden | HR |
| Enid Gilbert | Finance |
| Eric V. White | Marketing |
| Erica Gentile | Marketing |
| Erica Marshall | Finance |
| Esther Rice | Marketing |
| Ethel Blaylock | Finance |
| Ethel Sexton | Finance |
| Evelyn Mcmurry | HR |
| Filomena Jordan | Marketing |
| Francine H. Dundas | Finance |
| Frank Austin | Finance |
| Fred Dickison | Marketing |
| Fred Martin | Operations |
| Fred Moua | HR |
| Gary Harrison | HR |
| Gary Lees | Operations |
| Geoffrey Dant | Finance |
| George Elmore | Operations |
| Gerald Castro | HR |
| Glenda Phillips | Operations |
| Gloria Brown | Operations |
| Goldie Almond | HR |
| Goldie Lahr | Finance |
| Gregg Rhoades | Finance |
| Gregory Sperber | HR |
| Gregory Steiger | Marketing |
| Guillermo W. Phillips | HR |
| Heather Lichtenstein | Operations |
| Hosea Pierson | Marketing |
| Howard Keach | Finance |
| Humberto Hoosier | Operations |
| Irene Schreiber | Operations |
| Irving Kim | Finance |
| Jaime Williamson | Marketing |
| James Deluna | Marketing |
| James Millen | Marketing |
| Jack Millen | Operations |
| Jamie Millen | Finance |
| Jamie Banks | HR |
| Jamie Stowe | Operations |
| Jan Jones | Operations |
| Janet D. Donegan | Operations |
| Janet Silberstein | Marketing |
| Janet Silver | Finance |
| Janet Singleton | Marketing |
| Janet Stewart | Operations |
| Janet Woodson | Finance |
| Janice Reynolds | Operations |
| Janie Little | Operations |
| Jarrod Faith | HR |
| Jason Hadlock | HR |
| Jason J. Marshall | Marketing |
| Jason Joseph | Finance |
| Jason Sullivan | Operations |
| Jean Rose | Operations |
| Jeff Brooks | HR |
| Jeff Ryan | Operations |
| Jeffrey Jones | Marketing |
| Jeffrey P. Jones | Marketing |
| Jeffrey Proulx | Finance |
| Jennifer Jones | Finance |
| Jeffrey Ritter | Operations |
| Jeffrey Sharp | Operations |
| Jeffrey Vaughn | HR |
| Jeffrey Walters | Operations |
| Jennifer Brown | Finance |
| Jennifer D. Heath | Operations |
| Jerry Olivo | HR |
| Jessica Aten | Finance |
| Jesus Farrington | Operations |
| Jesus Gascon | Operations |
| Jillian Koster | Operations |
| Jim Martin | Marketing |
| Joan Morrison | Operations |
| Jodie Crowley | Operations |
| Jodie Tindall | Finance |
| Joel Maser | HR |
| Joel Thomas | Operations |
| John Clarke | Marketing |
| John Edwards | Finance |
| John Ohara | HR |
| John T. Foster | Operations |
| John Vaughan | Marketing |
| Jonas Green | Finance |
| Jonathan J. Conte | Finance |
| Jose D. Skaggs | Operations |
| Joseph Christensen | Marketing |
| Joseph Oliveros | Operations |
| Joseph Ramos | Finance |
| Josh Chiu | Marketing |
| Joyce Cotton | Finance |
| Juan Law | Finance |
| Judith Graham | HR |
| Karen Coles | Marketing |
| Karyn Hernandez | Finance |
| Katherine J. Smith | Marketing |
| Kathy Weatherby | Operations |
| Keith Bennett | Marketing |
| Kellie Witherspoon | Finance |
| Kelly Dollinger | Finance |
| Kelly J. Sousa | Marketing |
| Kendal Alford | Operations |
| Kendra Weber | Marketing |
| Kenneth Credle | Marketing |
| Kenneth Williams | Finance |
| Kenny H. Mcqueen | Operations |
| Kevin E. Wishart | Operations |
| Kevin Grant | Marketing |
| Kevin Whited | HR |
| Kimberly Barefoot | Finance |
| Kimberly Vos | Operations |
| Korey Davis | HR |
| Krista Orcutt | HR |
| Kristin Beaton | Finance |
| Kurt Decker | Finance |
| Kurt Kamichoff | Finance |
| Kyle Kamichoff | Marketing |
| Larry Kiel | Operations |
| Laura Wood | Finance |
| Lawrence Friedrich | Operations |
| Leah Clancy | HR |
| Lewis Liptak | Operations |
| Linda Boston | Operations |
| Linda Carbajal | Marketing |
| Linda Perez | HR |
| Lisa Golden | HR |
| Lois Mcwilliams | Marketing |
| Loretta Alvarez | Marketing |
| Lori Q. Waters | Finance |
| Lowell Harrison | HR |
| Lucile Sexton | Marketing |
| Lupe Spicer | HR |
| Madge Jackson | Operations |
| Manuel Cannon | HR |
| Marc Weaver | Operations |
| Marcus Eoff | Finance |
| Margaret Clark | Operations |
| Margaret Sirois | Operations |
| Maria Silva | Finance |
| Marie Doyle | HR |
| Marina W. Fuller | HR |
| Martha Welborn | Operations |
| Mary Brinkmann | Operations |
| Mary G. Brittain | HR |
| Matthew Silvia | Finance |
| Melinda Stokes | HR |
| Melvin Jordan | HR |
| Merlin Owens | Operations |
| Michael Atwood | Finance |
| Michael Hayden | Operations |
| Michael Lindsey | Finance |
| Micheal Belt | HR |
| Micheal Chadwick | HR |
| Michelle French | Marketing |
| Michelle Noonan | Marketing |
| Miranda Bassett | Marketing |
| Morgan Houchens | Marketing |
| Nadine Blankenship | Finance |
| Nancy Garcia | Operations |
| Nicholas N. Cagle | Finance |
| Nicholas Trejo | Finance |
| Olive Arsenault | Finance |
| Oscar Lee | Finance |
| Otis Ballenger | Finance |
| Pat Fisher | Operations |
| Patrick Angell | Operations |
| Paul Carlson | HR |
| Pearl Lippert | Marketing |
| Pedro H. Nicholson | Marketing |
| Peggy Craig | Marketing |
| Penny Philbrick | HR |
| PhyllisTodd | Operations |
| Rachel Armstrong | Marketing |
| Rae Walton | HR |
| Randy Pruitt | Marketing |
| Ray Bortz | Operations |
| Raymond Cyr | HR |
| Raymond Kruger | HR |
| Raymond Oneal | Marketing |
| Reina Shuffler | Operations |
| Renae Burns | Finance |
| Richard Curtis | Finance |
| Richard E. Card | Finance |
| Richard Guard | Finance |
| Richard L. Anderson | HR |
| Rick Fogerty | Finance |
| Ricky Penman | Operations |
| Robert Alexander | Marketing |
| Robert Ballard | Operations |
| Robert Cipriani | Marketing |
| Robert Farmer | Marketing |
| Robert H. Miller | Marketing |
| Robert Nipper | HR |
| Robert Pelkey | Operations |
| Rochelle Quick | Operations |
| Rodney Guerra | Operations |
| Rodney Sharpe | Marketing |
| Roland Pastrana | Marketing |
| Ronald Rouse | HR |
| Ronald Warren | Marketing |
| Rosa Johnson | Operations |
| Rosemary O. Richards | Operations |
| Rosemary Vaughn | Finance |
| Roy Greene | HR |
| Roy Hilliker | Finance |
| Roy Lindsey | Marketing |
| Royce Gilbert | Operations |
| Ruby Smith | Finance |
| Ruth Peel | Finance |
| Ruth Roberts | Finance |
| Salvatore Henderson | HR |
| Sam Axtell | HR |
| Samuel Mcdonald | Finance |
| Sandra Clarke | HR |
| Sandra Cotta | HR |
| Sarah Parks | HR |
| Sarah Silva | HR |
| Scott Palen | Operations |
| Scott Yeldell | Operations |
| Sean Grantham | Marketing |
| Sharon Henry | Marketing |
| Sharon Pineda | Operations |
| Sheila Wigfall | Finance |
| Sherrie Landry | Operations |
| Sherry F. Bennett | Operations |
| Shirley Henderson | HR |
| Shirley Hill | Finance |
| Shirley Miller | Operations |
| Stella Larue | Finance |
| Stephanie Hill | Operations |
| Stephen C. Carter | HR |
| Stephenie Carter | HR |
| Stephen Foster | Operations |
| Steven Cervantez | Marketing |
| Steven H. Katz | Operations |
| Steven Yarbrough | Marketing |
| Susan Morgan | HR |
| Susan Orosco | Finance |
| Susan Sikes | HR |
| Sylvia Saenz | Marketing |
| Tammy Baker | HR |
| Tara Applewhite | Finance |
| Tasha Williams | Operations |
| Teresa Allen | Operations |
| Terry Gross | Operations |
| Terry Rasmussen | HR |
| Thomas E. Abbott | Finance |
| Thomas Feather | Finance |
| Thomas H. Metz | Operations |
| Tom Brown | Operations |
| Tom Brown | Marketing |
| Tom Brown | HR |
| Tomasa Speer | Operations |
| Vada Mcintosh | Operations |
| Virginia Okeefe | Finance |
| Walter Thompson | Operations |
| Whitney Johnson | Finance |
| William N. Campbell | Operations |
| William Patterson | Operations |
| Willie Paris | Finance |
| Zenaida Jeon | Marketing |
Employee List-Locations
| Employee | Location | Employee ID Number |
| Pedro H. Nicholson | Arizona | 370 |
| Janet Woodson | Arizona | 349 |
| Cassandra Jackson | Arizona | 307 |
| Peggy Craig | Arizona | 414 |
| Richard E. Card | Arizona | 304 |
| Douglas Williams | Arizona | 170 |
| Jose D. Skaggs | Arizona | 79 |
| Tom Brown | Arizona | 418 |
| Richard L. Anderson | Arizona | 253 |
| Stephen C. Carter | Arizona | 312 |
| Steven Cervantez | Arizona | 350 |
| Curtis Miller | Arizona | 265 |
| Elmer Clifton | Arizona | 29 |
| Lewis Liptak | Arizona | 41 |
| Jason Sullivan | Arizona | 144 |
| Joseph Oliveros | Arizona | 451 |
| Joan Morrison | Arizona | 225 |
| Robert Alexander | Arizona | 364 |
| Ruth Roberts | Arizona | 20 |
| Anthony Gary | Arizona | 260 |
| Al Grubbs | California | 278 |
| Cheryl Cory | California | 466 |
| Gregory Steiger | California | 473 |
| Sheila Wigfall | California | 238 |
| Howard Keach | California | 153 |
| Margaret Sirois | California | 116 |
| Donald Jackson | California | 361 |
| Steven H. Katz | California | 86 |
| Paul Carlson | California | 226 |
| Sean Grantham | California | 22 |
| Michael Lindsey | California | 404 |
| Susan Sikes | California | 62 |
| Marc Weaver | California | 197 |
| Kenny H. Mcqueen | California | 92 |
| Elinor Love | California | 481 |
| Vada Mcintosh | California | 163 |
| Michelle French | California | 182 |
| Thomas Feather | California | 446 |
| Fred Dickison | California | 169 |
| Clark Bickerson | California | 164 |
| Gregory Sperber | California | 121 |
| Robert H. Miller | California | 314 |
| Kurt Kamichoff | California | 72 |
| Christine Poundsworth | California | 493 |
| Daniel Sandy | California | 222 |
| Barbara Stolz | California | 466 |
| Jarrod Faith | California | 287 |
| Micheal Chadwick | California | 269 |
| Kenneth Credle | California | 464 |
| Marcus Eoff | California | 418 |
| Salvatore Henderson | California | 50 |
| Richard E. Card | California | 264 |
| Janet Stewart | California | 496 |
| Reina Shuffler | California | 368 |
| Brandi Reynolds | California | 178 |
| Keith Bennett | California | 363 |
| Donna Couch | California | 328 |
| Austin Stone | California | 202 |
| Joyce Cotton | California | 125 |
| Alec Dunbar | California | 216 |
| Cheryl Gaymon | California | 98 |
| Virginia Okeefe | California | 78 |
| Jonas Green | California | 401 |
| Irene Schreiber | California | 6 |
| Walter Thompson | California | 289 |
| Danny Salinas | California | 472 |
| Terry Rasmussen | California | 313 |
| Jeffrey P. Jones | California | 55 |
| Renae Burns | California | 310 |
| Joel Maser | California | 410 |
| Michael Hayden | California | 427 |
| Alan Ruley | California | 227 |
| Eddie Mangual | California | 25 |
| Elise Bedgood | California | 188 |
| Karen Coles | California | 171 |
| Kimberly Barefoot | California | 254 |
| Robert Farmer | California | 496 |
| Brenda White | California | 380 |
| Jerry Olivo | California | 287 |
| Tom Brown | California | 45 |
| Dennis R. Waxman | California | 195 |
| Ruby Smith | California | 140 |
| Teresa Allen | California | 255 |
| Ray Bortz | California | 421 |
| Lowell Harrison | California | 33 |
| Michael Hayden | California | 162 |
| Michael Hayden | California | 200 |
| Anthony Guyette | California | 296 |
| Penny Philbrick | California | 339 |
| Patrick Angell | California | 131 |
| Fred Martin | California | 416 |
| Douglas Williams | California | 201 |
| Gloria Brown | California | 382 |
| Zenaida Jeon | California | 288 |
| Tara Applewhite | California | 171 |
| Rachel Armstrong | California | 206 |
| Susan Orosco | California | 139 |
| Thomas E. Abbott | California | 214 |
| Loretta Alvarez | California | 350 |
| Michael Atwood | California | 323 |
| David Adam | California | 188 |
| Arthur Werner | California | 402 |
| Scott Palen | California | 346 |
| Guillermo W. Phillips | California | 328 |
| Judith Graham | California | 325 |
| John Clarke | California | 243 |
| Debbie Barlow | California | 19 |
| Caleb Ham | California | 10 |
| Edward Bryant | California | 432 |
| Cynthia Beard | California | 371 |
| Deborah Sherman | California | 31 |
| Kathy Weatherby | California | 18 |
| Janet Silberstein | California | 397 |
| Clint Suarez | California | 48 |
| Roy Lindsey | California | 97 |
| Olive Arsenault | California | 403 |
| David Arellano | California | 348 |
| Sharon Henry | California | 354 |
| Goldie Lahr | California | 214 |
| Kenneth Williams | California | 72 |
| Charles Bingham | California | 41 |
| Tomasa Speer | California | 454 |
| Barbara Roark | California | 153 |
| Gerald Castro | California | 346 |
| Kelly J. Sousa | California | 279 |
| Christopher J. Polzin | California | 359 |
| Clarissa Christiansen | California | 114 |
| John T. Foster | California | 384 |
| PhyllisTodd | Massachusetts | 266 |
| Janie Little | Massachusetts | 76 |
| PhyllisTodd | Massachusetts | 408 |
| Joseph Christensen | Massachusetts | 133 |
| Anthony Taylor | Massachusetts | 376 |
| Josh Chiu | Massachusetts | 459 |
| David B. Ortiz | Massachusetts | 136 |
| Shirley Henderson | Massachusetts | 359 |
| Michelle Noonan | Massachusetts | 239 |
| Nicholas N. Cagle | Massachusetts | 500 |
| Charles Seeley | Massachusetts | 337 |
| Shirley Miller | Massachusetts | 426 |
| Joan Morrison | Massachusetts | 466 |
| Manuel Cannon | Massachusetts | 227 |
| Tom Brown | Massachusetts | 487 |
| Kendra Weber | Massachusetts | 414 |
| Oscar Lee | Massachusetts | 72 |
| Goldie Almond | Massachusetts | 267 |
| Rosa Johnson | Massachusetts | 210 |
| Ricky Penman | Massachusetts | 13 |
| Jodie Crowley | Massachusetts | 109 |
| John T. Foster | Massachusetts | 290 |
| Steven Yarbrough | Massachusetts | 458 |
| Richard Curtis | Massachusetts | 121 |
| Esther Rice | Massachusetts | 102 |
| Jason Joseph | Massachusetts | 480 |
| Diane Mcmahon | Massachusetts | 404 |
| Charles S. Billings | Massachusetts | 444 |
| Christian Reynolds | Massachusetts | 278 |
| Beverly Soares | Massachusetts | 1 |
| Tasha Williams | Massachusetts | 135 |
| Jillian Koster | Massachusetts | 483 |
| Jamie Banks | Massachusetts | 45 |
| Audrey Vogel | Massachusetts | 488 |
| Linda Carbajal | Massachusetts | 162 |
| Richard Guard | Massachusetts | 480 |
| Stephen C. Carter | Massachusetts | 243 |
| Robert Ballard | Massachusetts | 142 |
| Royce Gilbert | Massachusetts | 276 |
| Amy Majors | Massachusetts | 34 |
| Kevin E. Wishart | Massachusetts | 57 |
| Daniel Desantis | Massachusetts | 464 |
| Joseph Ramos | Massachusetts | 475 |
| Katherine J. Smith | Massachusetts | 443 |
| Irving Kim | Massachusetts | 345 |
| Joan Morrison | Massachusetts | 480 |
| Robert H. Miller | Massachusetts | 238 |
| Lori Q. Waters | Massachusetts | 440 |
| Brian Bass | Massachusetts | 31 |
| Kimberly Vos | Massachusetts | 325 |
| Dawne Thompson | Massachusetts | 6 |
| Kevin Whited | Massachusetts | 302 |
| Ronald Rouse | Massachusetts | 55 |
| Filomena Jordan | Massachusetts | 437 |
| Jodie Tindall | Massachusetts | 437 |
| Leah Clancy | Massachusetts | 318 |
| Larry Kiel | Massachusetts | 5 |
| Jan Jones | Massachusetts | 355 |
| Arthur Clayson | Massachusetts | 21 |
| Thomas H. Metz | Massachusetts | 483 |
| John T. Foster | Massachusetts | 369 |
| Cora Soto | Massachusetts | 180 |
| Christine Poundsworth | Massachusetts | 295 |
| Karyn Hernandez | Massachusetts | 28 |
| John Ohara | Massachusetts | 134 |
| Erica Gentile | Massachusetts | 195 |
| Stella Larue | Massachusetts | 144 |
| Jeffrey P. Jones | Massachusetts | 403 |
| Carol Wood | Massachusetts | 370 |
| David Keller | Massachusetts | 202 |
| Jeffrey Vaughn | Massachusetts | 187 |
| Sandra Cotta | Massachusetts | 385 |
| Elmer Tompkins | Massachusetts | 402 |
| Juan Law | Massachusetts | 336 |
| Devin Lear | Massachusetts | 347 |
| Linda Boston | Massachusetts | 476 |
| Carly Iorio | Massachusetts | 52 |
| Stephanie Hill | Massachusetts | 303 |
| Robert Pelkey | Massachusetts | 65 |
| Amy Fetter | Massachusetts | 306 |
| Geoffrey Dant | Massachusetts | 15 |
| Rodney Sharpe | Massachusetts | 40 |
| Jonathan J. Conte | Massachusetts | 1 |
| Micheal Belt | Massachusetts | 476 |
| Robert Cipriani | Massachusetts | 419 |
| Ethel Sexton | Massachusetts | 2 |
| Kelly Dollinger | Massachusetts | 291 |
| Jean Rose | Massachusetts | 425 |
| Terry Gross | Massachusetts | 372 |
| Allison Mcewen | Massachusetts | 187 |
| Sarah Parks | New York | 484 |
| Hosea Pierson | New York | 345 |
| Nadine Blankenship | New York | 248 |
| Roy Greene | New York | 158 |
| William N. Campbell | New York | 388 |
| Stephen Foster | New York | 471 |
| Mary Brinkmann | New York | 157 |
| Gary Lees | New York | 231 |
| Sylvia Saenz | New York | 486 |
| Ruth Peel | New York | 346 |
| Roland Pastrana | New York | 301 |
| Dorothy Herrera | New York | 204 |
| Clinton Soto | New York | 293 |
| Carrie Bryan | New York | 110 |
| Earnest Hale | New York | 23 |
| Willie Paris | New York | 50 |
| Booker Dunmire | New York | 271 |
| Madge Jackson | New York | 165 |
| Clark Bickerson | New York | 112 |
| Marina W. Fuller | New York | 226 |
| Raymond Oneal | New York | 301 |
| Rosemary Vaughn | New York | 95 |
| Charles Head | New York | 491 |
| Janet D. Donegan | New York | 390 |
| Scott Yeldell | New York | 263 |
| Amos Bowes | New York | 361 |
| William Patterson | New York | 227 |
| Kurt Kamichoff | New York | 31 |
| Samuel Mcdonald | New York | 463 |
| Anne Boyd | New York | 194 |
| Jessica Aten | New York | 373 |
| Fred Moua | New York | 2 |
| Lois Mcwilliams | New York | 376 |
| Ethel Blaylock | New York | 363 |
| Whitney Johnson | New York | 262 |
| Jeff Ryan | New York | 342 |
| Rochelle Quick | New York | 245 |
| Raymond Kruger | New York | 205 |
| Lisa Golden | New York | 190 |
| Betty Myers | New York | 35 |
| Frank Austin | New York | 413 |
| Linda Perez | New York | 261 |
| Rosemary O. Richards | New York | 122 |
| Merlin Owens | New York | 56 |
| Rodney Guerra | New York | 141 |
| Sherry F. Bennett | New York | 46 |
| Dawn Purvis | New York | 58 |
| Annie Chaidez | New York | 319 |
| Dianne Wong | New York | 283 |
| Jeffrey P. Jones | New York | 272 |
| Elsie Haines | New York | 355 |
| Alan Hudson | New York | 375 |
| Elidia Bode | New York | 180 |
| Carl Dexter | New York | 36 |
| Jesus Farrington | New York | 213 |
| Joel Thomas | New York | 467 |
| Gary Harrison | New York | 444 |
| Lupe Spicer | New York | 233 |
| Kevin Grant | New York | 438 |
| Janet Silberstein | New York | 369 |
| Jeff Brooks | New York | 82 |
| Chase Mcnamara | New York | 272 |
| Rick Fogerty | New York | 235 |
| Margaret Clark | New York | 64 |
| Jennifer D. Heath | New York | 465 |
| Alma Cruz | New York | 328 |
| Otis Ballenger | New York | 86 |
| Miranda Bassett | New York | 487 |
| Kurt Kamichoff | New York | 491 |
| Christian Moye | New York | 413 |
| Janet Silberstein | New York | 373 |
| Laura Wood | New York | 28 |
| Beverly B. Gray | New York | 463 |
| Connie Combs | New York | 188 |
| Glenda Phillips | New York | 84 |
| Marie Doyle | New York | 263 |
| Sarah Silva | New York | 123 |
| David Hare | New York | 208 |
| Alfred Glenn | New York | 48 |
| Tammy Baker | New York | 306 |
| Cindy Chow | New York | 403 |
| Christine Poundsworth | New York | 469 |
| Jeffrey Sharp | New York | 445 |
| Janice Reynolds | New York | 220 |
| Ashley Miller | New York | 189 |
| Elsie Truong | New York | 50 |
| Jason J. Marshall | New York | 493 |
| Enid Gilbert | New York | 50 |
| Melinda Stokes | New York | 215 |
| Betsy D. Kelly | New York | 79 |
| Jennifer Brown | New York | 412 |
| Charles S. Billings | Pennsylvania | 361 |
| Bob Hunsberger | Pennsylvania | 294 |
| Christopher Hudson | Pennsylvania | 25 |
| Cynthia Naskers | Pennsylvania | 156 |
| Sandra Clarke | Pennsylvania | 279 |
| Bryan Demarco | Pennsylvania | 44 |
| Gregg Rhoades | Pennsylvania | 13 |
| Krista Orcutt | Pennsylvania | 158 |
| Anthony Taylor | Pennsylvania | 363 |
| Donna Wallace | Pennsylvania | 296 |
| Jamie Stowe | Pennsylvania | 249 |
| Jeffrey Ritter | Pennsylvania | 189 |
| Clarice Longenecker | Pennsylvania | 68 |
| Matthew Silvia | Pennsylvania | 85 |
| Steven H. Katz | Pennsylvania | 382 |
| Nicholas Trejo | Pennsylvania | 298 |
| Raymond Cyr | Pennsylvania | 302 |
| Jim Martin | Pennsylvania | 69 |
| Bruce Burke | Pennsylvania | 201 |
| Roy Hilliker | Pennsylvania | 500 |
| Richard E. Card | Pennsylvania | 368 |
| Sherrie Landry | Pennsylvania | 407 |
| Emily Jorden | Pennsylvania | 93 |
| Korey Davis | Pennsylvania | 86 |
| Dustin Tate | Pennsylvania | 349 |
| John Edwards | Pennsylvania | 339 |
| Beverly Escobar | Pennsylvania | 186 |
| Diane Delgado | Pennsylvania | 248 |
| Steven H. Katz | Pennsylvania | 389 |
| Brandon Cutter | Pennsylvania | 123 |
| Pat Fisher | Pennsylvania | 377 |
| Eric V. White | Pennsylvania | 153 |
| PhyllisTodd | Pennsylvania | 423 |
| Ronald Warren | Pennsylvania | 92 |
| Arthur Williams | Pennsylvania | 190 |
| Susan Morgan | Pennsylvania | 225 |
| Pearl Lippert | Pennsylvania | 247 |
| Charles S. Billings | Pennsylvania | 314 |
| Kristin Beaton | Pennsylvania | 56 |
| Nancy Garcia | Pennsylvania | 309 |
| Cristobal Lopez | Pennsylvania | 422 |
| Dustin Myres | Pennsylvania | 499 |
| Mary G. Brittain | Pennsylvania | 9 |
| James Millen | Pennsylvania | 199 |
| Erica Marshall | Pennsylvania | 62 |
| David Pearce | Pennsylvania | 145 |
| Heather Lichtenstein | Washington | 318 |
| Kendal Alford | Washington | 69 |
| James Millen | Washington | 141 |
| Lawrence Friedrich | Washington | 312 |
| Thomas E. Abbott | Washington | 328 |
| Kurt Decker | Washington | 488 |
| Rick Fogerty | Washington | 121 |
| Francine H. Dundas | Washington | 496 |
| Rae Walton | Washington | 240 |
| Jeffrey Jones | Washington | 176 |
| Stephen C. Carter | Washington | 137 |
| Maria Silva | Washington | 250 |
| Jesus Gascon | Washington | 206 |
| Robert H. Miller | Washington | 129 |
| Elizabeth Cole | Washington | 228 |
| Jason Hadlock | Washington | 265 |
| Jaime Williamson | Washington | 299 |
| Shirley Hill | Washington | 100 |
| Sam Axtell | Washington | 68 |
| Christopher Huff | Washington | 350 |
| Alphonso F. Gordon | Washington | 444 |
| Anthony Taylor | Washington | 224 |
| Bennie Evans | Washington | 7 |
| Morgan Houchens | Washington | 333 |
| Thomas E. Abbott | Washington | 384 |
| John Vaughan | Washington | 451 |
| James Millen | Washington | 280 |
| Evelyn Mcmurry | Washington | 35 |
| James Deluna | Washington | 35 |
| Kellie Witherspoon | Washington | 304 |
| Clark Bickerson | Washington | 340 |
| Sharon Pineda | Washington | 92 |
| Douglas Williams | Washington | 477 |
| Melvin Jordan | Washington | 166 |
| Robert Nipper | Washington | 483 |
| Brandy Walker | Washington | 27 |
| Alice J. Guerra | Washington | 177 |
| Corinna Beltran | Washington | 401 |
| Martha Welborn | Washington | 124 |
| Humberto Hoosier | Washington | 242 |
| Jeffrey Walters | Washington | 38 |
| George Elmore | Washington | 242 |
| Randy Pruitt | Washington | 81 |
| Rick Fogerty | Washington | 453 |
| Lucile Sexton | Washington | 126 |
Sales Orders- Data
| Order Date | Region | Rep Name | Item Name | Quantity | Price per Unit |
| 9/1/18 | Central | Smith | Desk | 2 | 125 |
| 8/24/19 | West | Sorvino | Desk | 3 | 275 |
| 2/18/19 | East | Jones | Binder | 4 | 4.99 |
| 6/17/19 | Central | Kivell | Desk | 5 | 125 |
| 3/7/19 | West | Sorvino | Binder | 7 | 19.99 |
| 9/10/19 | Central | Gill | Pencil | 7 | 1.29 |
| 11/17/19 | Central | Jardine | Binder | 11 | 4.99 |
| 10/31/19 | Central | Andrews | Pencil | 14 | 1.29 |
| 11/8/18 | East | Parent | Pen | 15 | 19.99 |
| 9/18/18 | East | Jones | Pen Set | 16 | 15.99 |
| 2/26/18 | Central | Gill | Pen | 27 | 19.99 |
| 10/5/18 | Central | Morgan | Binder | 28 | 8.99 |
| 12/21/19 | Central | Andrews | Binder | 28 | 4.99 |
| 7/12/18 | East | Howard | Binder | 29 | 1.99 |
| 5/22/18 | West | Thompson | Pencil | 32 | 1.99 |
| 8/15/18 | East | Jones | Pencil | 35 | 4.99 |
| 2/9/18 | Central | Jardine | Pencil | 36 | 4.99 |
| 8/7/19 | Central | Kivell | Pen Set | 42 | 23.95 |
| 1/15/19 | Central | Gill | Binder | 46 | 8.99 |
| 1/23/18 | Central | Kivell | Binder | 50 | 19.99 |
| 3/24/19 | Central | Jardine | Pen Set | 50 | 4.99 |
| 5/14/19 | Central | Gill | Pencil | 53 | 1.29 |
| 7/21/19 | Central | Morgan | Pen Set | 55 | 12.49 |
| 3/15/18 | West | Sorvino | Pencil | 56 | 2.99 |
| 10/14/19 | West | Thompson | Binder | 57 | 19.99 |
| 4/1/18 | East | Jones | Binder | 60 | 4.99 |
| 6/8/18 | East | Jones | Binder | 60 | 8.99 |
| 7/4/19 | East | Jones | Pen Set | 62 | 4.99 |
| 10/22/18 | East | Jones | Pen | 64 | 8.99 |
| 4/10/19 | Central | Andrews | Pencil | 66 | 1.99 |
| 12/12/18 | Central | Smith | Pencil | 67 | 1.29 |
| 12/29/18 | East | Parent | Pen Set | 74 | 15.99 |
| 4/18/18 | Central | Andrews | Pencil | 75 | 1.99 |
| 9/27/19 | West | Sorvino | Pen | 76 | 1.99 |
| 5/31/19 | Central | Gill | Binder | 80 | 8.99 |
| 7/29/18 | East | Parent | Binder | 81 | 19.99 |
| 2/1/19 | Central | Smith | Binder | 87 | 15 |
| 5/5/18 | Central | Jardine | Pencil | 90 | 4.99 |
| 6/25/18 | Central | Morgan | Pencil | 90 | 4.99 |
| 12/4/19 | Central | Jardine | Binder | 94 | 19.99 |
| 1/6/18 | East | Jones | Pencil | 95 | 1.99 |
| 4/27/19 | East | Howard | Pen | 96 | 4.99 |
| 11/25/18 | Central | Kivell | Pen Set | 96 | 4.99 |