mgt 325 case

User Generated

Qnanr

Business Finance

Description

3. Excluding the Furniture Department and its employees, which sales representatives received commissions above average last week?

4. If sales staff must make their quotas at least 60 percent of the time, which sales staff did not achieve this goal?

Unformatted Attachment Preview

Last Name Allbaugh Bibb First Name Joshua Robin Classification AM PT2 Department Men's Men's Blake Bolyard Bourque Craddock Cronk Crouse Deyoe Duarte Dubben Duck Fetchik Fiddes Freeman Gauger Harpole Hauch Henning Hornbeek Huang Hughes Hulsman Jwang Ketakea Lax Lenfestey Lessert Mallouf Mazza McMath Monac Montague Nigel Picazo Plumbtree Pomales Pomura Porterfield Reyes Rodman Roselius Ruaz Schoemann Stanton Stephens Stone Vandrey Walker Watts Wilson Yu Barney Pat Elizabeth David June Aleta Rayundo Shawn Pamela Kelee Vearl Rick Jerry Samone Frank Joann Patricia Kent Woody Frank Russell Buyung Loraine Rafael Kionna Linda Pedro Pamela Olivia Levitica Carmen Emmett Luciano Leslie Oseas Joaquin Jimmy Rayna Johnny Reginald Monica Dale Catrina Lacretia David Yvonne Donny Kelly Jay William S2 S2 AM PT1 PT1 S1 PT1 PT1 PT2 S2 S1 S1 S1 PT1 PT1 PT2 S1 AM PT2 PT2 S1 AM PT2 S1 S1 S2 PT1 AM PT2 S1 S1 S2 S2 PT1 S1 PT1 S1 AM PT2 PT2 S2 S2 S1 PT1 AM S2 S2 S1 S1 PT2 Cosmetics Housewares Linens Furniture Children's Children's Men's Children's Cosmetics Children's Furniture Cosmetics Housewares Women's Furniture Furniture Cosmetics Housewares Furniture Cosmetics Children's Women's Children's Housewares Linens Linens Housewares Furniture Housewares Men's Men's Linens Men's Women's Linens Linens Furniture Children's Men's Linens Men's Women's Women's Women's Cosmetics Women's Men's Women's Furniture Cosmetics Sales $4.000,00 $10.065,23 $456,76 $450,98 $650,75 $250,78 $1.500,00 $0,00 $500,00 $1.402,98 $0,00 $873,08 $4.500,67 $356,26 $1.500,25 $250,00 $1.469,78 $7.502,03 $0,00 $890,47 $0,00 $1.000,00 $1.100,00 $1.202,02 $199,99 $802,46 $50,00 $1.502,96 $0,00 $2.500,00 $0,00 $0,00 $0,00 $196,89 $0,00 $250,75 $850,63 $251,36 $0,00 $2.399,00 $1.546,78 $1.908,00 $2.159,69 $0,00 $821,36 $345,96 $1.766,00 $0,00 $0,00 $234,45 $0,00 $2.225,00 Hours Worked Base pay Commission Gross Pay Quota Met? Worked Today? 8 $188,00 $72,00 $260,00 1 1 8 $94,00 $135,98 $229,98 1 1 2,5 3 6 4 4 0 4 4 0 5 5 7,5 5 4 5 2 0 8 0 5 6 12 4 8 8 4 0 12 0 0 0 1 0 2 6,5 3 0 12 8 8 12 0 7 2 10 0 0 6,5 0 8 $37,50 $45,00 $141,00 $42,00 $42,00 $0,00 $42,00 $42,00 $0,00 $75,00 $67,50 $101,25 $67,50 $42,00 $52,50 $23,50 $0,00 $188,00 $0,00 $58,75 $81,00 $282,00 $47,00 $108,00 $108,00 $60,00 $0,00 $282,00 $0,00 $0,00 $0,00 $15,00 $0,00 $21,00 $87,75 $31,50 $0,00 $282,00 $94,00 $94,00 $180,00 $0,00 $94,50 $21,00 $235,00 $0,00 $0,00 $87,75 $0,00 $94,00 $0,48 $0,00 $0,00 $0,00 $11,00 $0,00 $1,00 $10,03 $0,00 $0,00 $75,01 $0,00 $15,01 $0,00 $9,70 $108,78 $0,00 $0,00 $0,00 $5,63 $4,00 $0,00 $0,00 $0,00 $0,00 $20,07 $0,00 $3,00 $0,00 $0,00 $0,00 $0,55 $0,00 $0,51 $0,00 $0,00 $0,00 $0,00 $8,20 $13,62 $1,49 $0,00 $0,00 $1,46 $0,00 $0,00 $0,00 $0,00 $0,00 $18,38 $37,98 $45,00 $141,00 $42,00 $53,00 $0,00 $43,00 $52,03 $0,00 $75,00 $142,51 $101,25 $82,51 $42,00 $62,20 $132,28 $0,00 $188,00 $0,00 $64,38 $85,00 $282,00 $47,00 $108,00 $108,00 $80,07 $0,00 $285,00 $0,00 $0,00 $0,00 $15,55 $0,00 $21,51 $87,75 $31,50 $0,00 $282,00 $102,20 $107,62 $181,49 $0,00 $94,50 $22,46 $235,00 $0,00 $0,00 $87,75 $0,00 $112,38 1 0 0 0 1 0 1 1 0 0 1 0 1 0 1 1 0 0 0 1 1 0 0 0 0 1 0 1 0 0 0 1 0 1 0 0 0 0 1 1 1 0 0 1 0 0 0 0 0 1 1 1 1 1 1 0 1 1 0 1 1 1 1 1 1 1 0 1 0 1 1 1 1 1 1 1 0 1 0 0 0 1 0 1 1 1 0 1 1 1 1 0 1 1 1 0 0 1 0 1 A B C D E F G H I J K 1 2 3 Last Name 4 Allbaugh First Name Joshua Classification AM Department Men's 5 Bibb Robin PT2 Men's 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 Barney Pat Elizabeth David June Aleta Rayundo Shawn Pamela Kelee Vearl Rick Jerry Samone Frank Joann Patricia Kent Woody Frank Russell Buyung Loraine Rafael Kionna Linda Pedro Pamela Olivia Levitica Carmen Emmett Luciano Leslie Oseas Joaquin Jimmy Rayna Johnny Reginald Monica Dale Catrina Lacretia David Yvonne Donny Kelly Jay William S2 S2 AM PT1 PT1 S1 PT1 PT1 PT2 S2 S1 S1 S1 PT1 PT1 PT2 S1 AM PT2 PT2 S1 AM PT2 S1 S1 S2 PT1 AM PT2 S1 S1 S2 S2 PT1 S1 PT1 S1 AM PT2 PT2 S2 S2 S1 PT1 AM S2 S2 S1 S1 PT2 Cosmetics Housewares Linens Furniture Children's Children's Men's Children's Cosmetics Children's Furniture Cosmetics Housewares Women's Furniture Furniture Cosmetics Housewares Furniture Cosmetics Children's Women's Children's Housewares Linens Linens Housewares Furniture Housewares Men's Men's Linens Men's Women's Linens Linens Furniture Children's Men's Linens Men's Women's Women's Women's Cosmetics Women's Men's Women's Furniture Cosmetics Blake Bolyard Bourque Craddock Cronk Crouse Deyoe Duarte Dubben Duck Fetchik Fiddes Freeman Gauger Harpole Hauch Henning Hornbeek Huang Hughes Hulsman Jwang Ketakea Lax Lenfestey Lessert Mallouf Mazza McMath Monac Montague Nigel Picazo Plumbtree Pomales Pomura Porterfield Reyes Rodman Roselius Ruaz Schoemann Stanton Stephens Stone Vandrey Walker Watts Wilson Yu Sales $1.315,86 Hours Worked Base pay Commission Gross Pay Quota Met? Worked Today? 6 $141,00 $3,48 $144,48 1 1 $0,00 0 $0,00 $0,00 $0,00 0 0 $1.318,97 $943,17 $686,57 $4.502,33 $0,00 $649,27 $0,00 $0,00 $556,00 $1.798,88 $4.925,96 $1.900,54 $891,19 $0,00 $3.228,87 $1.251,02 $1.788,34 $2.654,44 $0,00 $375,52 $474,44 $0,00 $350,45 $3.789,21 $133,98 $4.114,09 $1.195,42 $0,00 $1.745,90 $2.822,50 $657,56 $1.398,88 $0,00 $0,00 $3.519,79 $2.810,02 $6.768,68 $1.047,66 $0,00 $0,00 $1.532,87 $0,00 $1.486,22 $0,00 $0,00 $2.719,75 $1.994,48 $2.127,32 $0,00 $0,00 6 6 7 4 0 8 0 0 4 5 8 9 5 0 4 4 7 8 0 4 2 0 4 8 8 6 4 0 2 6 8 6 0 0 4 5 6 5 0 0 5 8 5 0 0 6 8 8 2 0 $90,00 $90,00 $164,50 $42,00 $0,00 $108,00 $0,00 $0,00 $47,00 $75,00 $108,00 $121,50 $67,50 $0,00 $42,00 $47,00 $94,50 $188,00 $0,00 $47,00 $27,00 $0,00 $47,00 $108,00 $108,00 $90,00 $42,00 $0,00 $23,50 $81,00 $108,00 $90,00 $0,00 $0,00 $54,00 $52,50 $81,00 $117,50 $0,00 $0,00 $75,00 $120,00 $67,50 $0,00 $0,00 $90,00 $120,00 $108,00 $27,00 $0,00 $6,72 $0,00 $0,00 $41,02 $0,00 $0,00 $0,00 $0,00 $0,84 $23,10 $74,52 $11,01 $2,82 $0,00 $28,29 $11,27 $14,77 $31,63 $0,00 $0,00 $3,49 $0,00 $0,00 $51,78 $0,00 $76,60 $7,95 $0,00 $22,44 $38,45 $0,00 $8,72 $0,00 $0,00 $58,40 $23,10 $117,37 $1,43 $0,00 $0,00 $16,45 $0,00 $14,72 $0,00 $0,00 $41,74 $14,86 $18,55 $0,00 $0,00 $96,72 $90,00 $164,50 $83,02 $0,00 $108,00 $0,00 $0,00 $47,84 $98,10 $182,52 $132,51 $70,32 $0,00 $70,29 $58,27 $109,27 $219,63 $0,00 $47,00 $30,49 $0,00 $47,00 $159,78 $108,00 $166,60 $49,95 $0,00 $45,94 $119,45 $108,00 $98,72 $0,00 $0,00 $112,40 $75,60 $198,37 $118,93 $0,00 $0,00 $91,45 $120,00 $82,22 $0,00 $0,00 $131,74 $134,86 $126,55 $27,00 $0,00 1 0 0 1 0 0 0 0 1 1 1 1 1 0 1 1 1 1 0 0 1 0 0 1 0 1 1 0 1 1 0 1 0 0 1 1 1 1 0 0 1 0 1 0 0 1 1 1 0 0 1 1 1 1 0 1 0 0 1 1 1 1 1 0 1 1 1 1 0 1 1 0 1 1 1 1 1 0 1 1 1 1 0 0 1 1 1 1 0 0 1 1 1 0 0 1 1 1 1 0 A B C D E F G H I J K 1 2 3 Last Name 4 Allbaugh 5 Bibb First Name Joshua Robin Classification AM PT2 Department Men's Men's 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 Barney Pat Elizabeth David June Aleta Rayundo Shawn Pamela Kelee Vearl Rick Jerry Samone Frank Joann Patricia Kent Woody Frank Russell Buyung Loraine Rafael Kionna Linda Pedro Pamela Olivia Levitica Carmen Emmett Luciano Leslie Oseas Joaquin Jimmy Rayna Johnny Reginald Monica Dale Catrina Lacretia David Yvonne Donny Kelly Jay William S2 S2 AM PT1 PT1 S1 PT1 PT1 PT2 S2 S1 S1 S1 PT1 PT1 PT2 S1 AM PT2 PT2 S1 AM PT2 S1 S1 S2 PT1 AM PT2 S1 S1 S2 S2 PT1 S1 PT1 S1 AM PT2 PT2 S2 S2 S1 PT1 AM S2 S2 S1 S1 PT2 Cosmetics Housewares Linens Furniture Children's Children's Men's Children's Cosmetics Children's Furniture Cosmetics Housewares Women's Furniture Furniture Cosmetics Housewares Furniture Cosmetics Children's Women's Children's Housewares Linens Linens Housewares Furniture Housewares Men's Men's Linens Men's Women's Linens Linens Furniture Children's Men's Linens Men's Women's Women's Women's Cosmetics Women's Men's Women's Furniture Cosmetics Blake Bolyard Bourque Craddock Cronk Crouse Deyoe Duarte Dubben Duck Fetchik Fiddes Freeman Gauger Harpole Hauch Henning Hornbeek Huang Hughes Hulsman Jwang Ketakea Lax Lenfestey Lessert Mallouf Mazza McMath Monac Montague Nigel Picazo Plumbtree Pomales Pomura Porterfield Reyes Rodman Roselius Ruaz Schoemann Stanton Stephens Stone Vandrey Walker Watts Wilson Yu Sales $1.927,74 $145,02 $1.674,25 $718,63 $1.501,80 $5.600,00 $0,00 $1.565,72 $640,89 $0,00 $2.489,42 $0,00 $0,00 $1.349,77 $784,67 $1.208,96 $5.414,32 $10.031,40 $800,36 $1.631,42 $0,00 $888,98 $2.994,38 $3.565,69 $0,00 $2.440,40 $0,00 $1.549,63 $1.296,12 $13.354,90 $393,54 $2.221,51 $367,89 $861,81 $0,00 $0,00 $1.564,52 $0,00 $9.999,29 $1.117,46 $199,91 $597,49 $3.593,96 $3.385,26 $4.864,47 $0,00 $490,64 $3.389,92 $2.080,44 $1.967,80 $456,98 $0,00 Hours Worked Base pay Commission Gross Pay Quota Met? Worked Today? 8 $188,00 $9,83 $197,83 1 1 2 $23,50 $0,00 $23,50 0 1 8 5 8 4 0 6 5 0 8 0 0 8 4 6 7 2 8 8 0 4 6 8 0 8 2 8 4 5 4 8 2 5 0 0 8 0 8 8 2 4 8 10 8 0 4 8 8 8 2 0 $120,00 $75,00 $188,00 $42,00 $0,00 $81,00 $52,50 $0,00 $94,00 $0,00 $0,00 $108,00 $54,00 $63,00 $73,50 $23,50 $108,00 $188,00 $0,00 $47,00 $81,00 $188,00 $0,00 $108,00 $27,00 $120,00 $42,00 $117,50 $47,00 $108,00 $27,00 $75,00 $0,00 $0,00 $108,00 $0,00 $108,00 $188,00 $23,50 $47,00 $120,00 $150,00 $108,00 $0,00 $94,00 $120,00 $120,00 $108,00 $27,00 $0,00 $6,86 $0,00 $0,00 $52,00 $0,00 $13,31 $1,41 $0,00 $22,34 $0,00 $0,00 $3,00 $3,69 $6,09 $47,14 $146,72 $0,00 $0,94 $0,00 $5,83 $41,89 $58,97 $0,00 $24,81 $0,00 $3,74 $8,96 $370,65 $0,00 $20,43 $1,36 $0,00 $0,00 $0,00 $7,29 $0,00 $175,99 $0,00 $0,00 $1,46 $54,85 $40,88 $73,29 $0,00 $0,00 $49,75 $17,01 $15,36 $3,14 $0,00 $126,86 $75,00 $188,00 $94,00 $0,00 $94,31 $53,91 $0,00 $116,34 $0,00 $0,00 $111,00 $57,69 $69,09 $120,64 $170,22 $108,00 $188,94 $0,00 $52,83 $122,89 $246,97 $0,00 $132,81 $27,00 $123,74 $50,96 $488,15 $47,00 $128,43 $28,36 $75,00 $0,00 $0,00 $115,29 $0,00 $283,99 $188,00 $23,50 $48,46 $174,85 $190,88 $181,29 $0,00 $94,00 $169,75 $137,01 $123,36 $30,14 $0,00 1 0 0 1 0 1 1 0 1 0 0 1 1 1 1 1 0 1 0 1 1 1 0 1 0 1 1 1 0 1 1 0 0 0 1 0 1 0 0 1 1 1 1 0 0 1 1 1 1 0 1 1 1 1 0 1 1 0 1 0 0 1 1 1 1 1 1 1 0 1 1 1 0 1 1 1 1 1 1 1 1 1 0 0 1 0 1 1 1 1 1 1 1 0 1 1 1 1 1 0 A B C D E F G H I J K 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 Last Name Allbaugh Bibb Blake Bolyard Bourque Craddock Cronk Crouse Deyoe Duarte Dubben Duck Fetchik Fiddes Freeman Gauger Harpole Hauch Henning Hornbeek Huang Hughes Hulsman Jwang Ketakea Lax Lenfestey Lessert Mallouf Mazza McMath Monac Montague Nigel Picazo Plumbtree Pomales Pomura Porterfield Reyes Rodman Roselius Ruaz Schoemann Stanton Stephens Stone Vandrey Walker Watts Wilson Yu First Name Joshua Robin Barney Pat Elizabeth David June Aleta Rayundo Shawn Pamela Kelee Vearl Rick Jerry Samone Frank Joann Patricia Kent Woody Frank Russell Buyung Loraine Rafael Kionna Linda Pedro Pamela Olivia Levitica Carmen Emmett Luciano Leslie Oseas Joaquin Jimmy Rayna Johnny Reginald Monica Dale Catrina Lacretia David Yvonne Donny Kelly Jay William Classification AM PT2 S2 S2 AM PT1 PT1 S1 PT1 PT1 PT2 S2 S1 S1 S1 PT1 PT1 PT2 S1 AM PT2 PT2 S1 AM PT2 S1 S1 S2 PT1 AM PT2 S1 S1 S2 S2 PT1 S1 PT1 S1 AM PT2 PT2 S2 S2 S1 PT1 AM S2 S2 S1 S1 PT2 Department Men's Men's Cosmetics Housewares Linens Furniture Children's Children's Men's Children's Cosmetics Children's Furniture Cosmetics Housewares Women's Furniture Furniture Cosmetics Housewares Furniture Cosmetics Children's Women's Children's Housewares Linens Linens Housewares Furniture Housewares Men's Men's Linens Men's Women's Linens Linens Furniture Children's Men's Linens Men's Women's Women's Women's Cosmetics Women's Men's Women's Furniture Cosmetics Sales $0,00 $791,85 $0,00 $0,00 $1.866,99 $369,87 $4.369,22 $0,00 $0,00 $3.865,87 $2.336,66 $1.522,64 $7.726,69 $0,00 $1.846,25 $0,00 $27.746,32 $12.324,11 $0,00 $0,00 $0,00 $0,00 $2.693,21 $2.461,87 $150,00 $0,00 $263,23 $2.113,09 $2.275,95 $8.632,72 $1.228,73 $3.492,55 $986,25 $1.080,15 $999,36 $1.313,60 $1.590,69 $0,00 $0,00 $0,00 $790,53 $3.494,11 $0,00 $456,36 $2.506,07 $3.870,88 $1.768,87 $1.698,97 $2.889,70 $1.352,79 $0,00 $2.699,63 Hours Worked Base pay Commission Gross Pay Quota Met? Worked Today? 0 $0,00 $0,00 $0,00 0 0 2 $23,50 $8,13 $31,63 1 1 0 $0,00 $0,00 $0,00 0 0 0 $0,00 $0,00 $0,00 0 0 7 $164,50 $14,01 $178,51 1 1 4 $42,00 $0,00 $42,00 0 1 8 $84,00 $35,69 $119,69 1 1 0 $0,00 $0,00 $0,00 0 0 0 $0,00 $0,00 $0,00 0 0 8 $84,00 $30,66 $114,66 1 1 5 $58,75 $25,67 $84,42 1 1 5 $75,00 $16,19 $91,19 1 1 6 $81,00 $136,53 $217,53 1 1 0 $0,00 $0,00 $0,00 0 0 8 $108,00 $12,93 $120,93 1 1 0 $0,00 $0,00 $0,00 0 0 8 $84,00 $269,46 $353,46 1 1 0 $0,00 $184,86 $184,86 1 0 0 $0,00 $0,00 $0,00 0 0 0 $0,00 $0,00 $0,00 0 0 0 $0,00 $0,00 $0,00 0 0 0 $0,00 $0,00 $0,00 0 0 8 $108,00 $29,86 $137,86 1 1 4 $94,00 $49,86 $143,86 1 1 4 $47,00 $0,00 $47,00 0 1 0 $0,00 $0,00 $0,00 0 0 6 $81,00 $0,00 $81,00 0 1 5 $75,00 $30,95 $105,95 1 1 4 $42,00 $18,76 $60,76 1 1 8 $188,00 $210,98 $398,98 1 1 4 $47,00 $10,93 $57,93 1 1 8 $108,00 $45,85 $153,85 1 1 3 $40,50 $10,73 $51,23 1 1 8 $120,00 $0,00 $120,00 0 1 8 $120,00 $0,00 $120,00 0 1 7 $73,50 $6,14 $79,64 1 1 8 $108,00 $7,81 $115,81 1 1 0 $0,00 $0,00 $0,00 0 0 0 $0,00 $0,00 $0,00 0 0 0 $0,00 $0,00 $0,00 0 0 2 $23,50 $8,11 $31,61 1 1 8 $94,00 $37,41 $131,41 1 1 0 $0,00 $0,00 $0,00 0 0 8 $120,00 $0,00 $120,00 0 1 4 $54,00 $38,12 $92,12 1 1 7 $73,50 $31,71 $105,21 1 1 8 $188,00 $5,07 $193,07 1 1 8 $120,00 $7,47 $127,47 1 1 8 $120,00 $37,24 $157,24 1 1 5 $67,50 $12,06 $79,56 1 1 0 $0,00 $0,00 $0,00 0 0 8 $94,00 $25,49 $119,49 1 1 A B C D E F G H I J K 1 2 3 Last Name 4 Allbaugh 5 Bibb First Name Joshua Robin Classification AM PT2 Department Men's Men's 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 Barney Pat Elizabeth David June Aleta Rayundo Shawn Pamela Kelee Vearl Rick Jerry Samone Frank Joann Patricia Kent Woody Frank Russell Buyung Loraine Rafael Kionna Linda Pedro Pamela Olivia Levitica Carmen Emmett Luciano Leslie Oseas Joaquin Jimmy Rayna Johnny Reginald Monica Dale Catrina Lacretia David Yvonne Donny Kelly Jay William S2 S2 AM PT1 PT1 S1 PT1 PT1 PT2 S2 S1 S1 S1 PT1 PT1 PT2 S1 AM PT2 PT2 S1 AM PT2 S1 S1 S2 PT1 AM PT2 S1 S1 S2 S2 PT1 S1 PT1 S1 AM PT2 PT2 S2 S2 S1 PT1 AM S2 S2 S1 S1 PT2 Cosmetics Housewares Linens Furniture Children's Children's Men's Children's Cosmetics Children's Furniture Cosmetics Housewares Women's Furniture Furniture Cosmetics Housewares Furniture Cosmetics Children's Women's Children's Housewares Linens Linens Housewares Furniture Housewares Men's Men's Linens Men's Women's Linens Linens Furniture Children's Men's Linens Men's Women's Women's Women's Cosmetics Women's Men's Women's Furniture Cosmetics Blake Bolyard Bourque Craddock Cronk Crouse Deyoe Duarte Dubben Duck Fetchik Fiddes Freeman Gauger Harpole Hauch Henning Hornbeek Huang Hughes Hulsman Jwang Ketakea Lax Lenfestey Lessert Mallouf Mazza McMath Monac Montague Nigel Picazo Plumbtree Pomales Pomura Porterfield Reyes Rodman Roselius Ruaz Schoemann Stanton Stephens Stone Vandrey Walker Watts Wilson Yu Sales $0,00 $1.211,44 $2.604,92 $0,00 $0,00 $0,00 $0,00 $5.667,64 $0,00 $1.254,76 $0,00 $924,38 $7.857,44 $778,26 $0,00 $2.506,25 $0,00 $25.447,82 $2.214,27 $2.470,54 $54.447,87 $3.600,23 $2.261,34 $1.535,36 $0,00 $1.546,31 $4.500,79 $3.684,97 $1.438,21 $4.492,35 $1.134,12 $0,00 $0,00 $0,00 $657,63 $1.694,59 $1.550,01 $0,00 $16.693,99 $2.134,47 $1.962,75 $552,94 $328,56 $0,00 $0,00 $930,90 $311,63 $1.905,72 $0,00 $0,00 $0,00 Hours Worked Base pay Commission Gross Pay Quota Met? Worked Today? 0 $0,00 $0,00 $0,00 0 0 4 $47,00 $10,67 $57,67 1 1 8 0 0 0 0 12 0 4 0 8 8 8 0 4 0 4 8 8 7 6 4 4 0 4 5 7 4 5 4 0 0 0 4 8 8 0 8 8 4 0 5 5 0 0 8 4 6 0 0 0 $120,00 $0,00 $0,00 $0,00 $0,00 $162,00 $0,00 $42,00 $0,00 $120,00 $108,00 $108,00 $0,00 $42,00 $0,00 $47,00 $108,00 $188,00 $82,25 $70,50 $54,00 $94,00 $0,00 $54,00 $67,50 $105,00 $42,00 $117,50 $47,00 $0,00 $0,00 $0,00 $60,00 $84,00 $108,00 $0,00 $108,00 $188,00 $47,00 $0,00 $75,00 $75,00 $0,00 $0,00 $188,00 $60,00 $90,00 $0,00 $0,00 $0,00 $30,12 $0,00 $0,00 $0,00 $0,00 $77,35 $0,00 $8,55 $0,00 $0,00 $133,15 $0,00 $0,00 $21,06 $0,00 $374,22 $20,29 $26,12 $803,59 $42,75 $33,23 $22,06 $0,00 $18,93 $75,02 $61,50 $10,38 $104,77 $9,51 $0,00 $0,00 $0,00 $0,00 $8,95 $7,00 $0,00 $309,88 $16,03 $21,94 $0,00 $0,00 $0,00 $0,00 $0,00 $0,00 $0,00 $21,39 $0,00 $0,00 $0,00 $150,12 $0,00 $0,00 $0,00 $0,00 $239,35 $0,00 $50,55 $0,00 $120,00 $241,15 $108,00 $0,00 $63,06 $0,00 $421,22 $128,29 $214,12 $885,84 $113,25 $87,23 $116,06 $0,00 $72,93 $142,52 $166,50 $52,38 $222,27 $56,51 $0,00 $0,00 $0,00 $60,00 $92,95 $115,00 $0,00 $417,88 $204,03 $68,94 $0,00 $75,00 $75,00 $0,00 $0,00 $188,00 $60,00 $111,39 $0,00 $0,00 $0,00 1 0 0 0 0 1 0 1 0 0 1 0 0 1 0 1 1 1 1 1 1 1 0 1 1 1 1 1 1 0 0 0 0 1 1 0 1 1 1 0 0 0 0 0 0 0 1 0 0 0 1 0 0 0 0 1 0 1 0 1 1 1 0 1 0 1 1 1 1 1 1 1 0 1 1 1 1 1 1 0 0 0 1 1 1 0 1 1 1 0 1 1 0 0 1 1 1 0 0 0 A B C D E F G H I J K 1 2 3 Last Name 4 Allbaugh First Name Joshua Classification AM Department Men's 5 Bibb Robin PT2 Men's 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 Barney Pat Elizabeth David June Aleta Rayundo Shawn Pamela Kelee Vearl Rick Jerry Samone Frank Joann Patricia Kent Woody Frank Russell Buyung Loraine Rafael Kionna Linda Pedro Pamela Olivia Levitica Carmen Emmett Luciano Leslie Oseas Joaquin Jimmy Rayna Johnny Reginald Monica Dale Catrina Lacretia David Yvonne Donny Kelly Jay William S2 S2 AM PT1 PT1 S1 PT1 PT1 PT2 S2 S1 S1 S1 PT1 PT1 PT2 S1 AM PT2 PT2 S1 AM PT2 S1 S1 S2 PT1 AM PT2 S1 S1 S2 S2 PT1 S1 PT1 S1 AM PT2 PT2 S2 S2 S1 PT1 AM S2 S2 S1 S1 PT2 Cosmetics Housewares Linens Furniture Children's Children's Men's Children's Cosmetics Children's Furniture Cosmetics Housewares Women's Furniture Furniture Cosmetics Housewares Furniture Cosmetics Children's Women's Children's Housewares Linens Linens Housewares Furniture Housewares Men's Men's Linens Men's Women's Linens Linens Furniture Children's Men's Linens Men's Women's Women's Women's Cosmetics Women's Men's Women's Furniture Cosmetics Blake Bolyard Bourque Craddock Cronk Crouse Deyoe Duarte Dubben Duck Fetchik Fiddes Freeman Gauger Harpole Hauch Henning Hornbeek Huang Hughes Hulsman Jwang Ketakea Lax Lenfestey Lessert Mallouf Mazza McMath Monac Montague Nigel Picazo Plumbtree Pomales Pomura Porterfield Reyes Rodman Roselius Ruaz Schoemann Stanton Stephens Stone Vandrey Walker Watts Wilson Yu Sales $1.120,32 Hours Worked Base pay Commission Gross Pay Quota Met? Worked Today? 8 $188,00 $0,00 $188,00 0 1 $0,00 0 $0,00 $508,72 $921,86 $1.698,20 $19.836,36 $0,00 $1.324,25 $0,00 $0,00 $35,02 $2.558,96 $0,00 $383,84 $1.455,57 $3.609,65 $0,00 $969,52 $1.298,40 $1.643,02 $2.969,97 $0,00 $945,39 $991,07 $1.987,25 $886,95 $1.605,78 $569,44 $1.400,55 $29.704,21 $0,00 $2.215,55 $1.408,98 $5.896,94 $256,48 $1.436,10 $4.478,31 $5.964,47 $13.060,67 $2.499,15 $0,00 $0,00 $2.598,86 $4.508,98 $4.456,11 $3.633,11 $3.844,13 $2.781,36 $0,00 $4.673,92 $1.508,88 $0,00 8,5 8 12 4 0 6 0 0 3 12 0 7,5 8 4 0 8 8 8 8 0 8 8 3 4 8 7 4 10 0 8 6 10 4 3 5,5 8 8 7 0 0 8 7 8 11 10 8 0 8 12 0 $127,50 $120,00 $282,00 $42,00 $0,00 $81,00 $0,00 $0,00 $35,25 $180,00 $0,00 $101,25 $108,00 $42,00 $0,00 $94,00 $108,00 $188,00 $94,00 $0,00 $108,00 $188,00 $35,25 $54,00 $108,00 $105,00 $42,00 $235,00 $0,00 $108,00 $81,00 $150,00 $60,00 $31,50 $74,25 $84,00 $108,00 $164,50 $0,00 $0,00 $120,00 $105,00 $108,00 $115,50 $235,00 $120,00 $0,00 $108,00 $162,00 $0,00 $0,00 $0,00 0 0 $0,00 $127,50 $0,00 $120,00 $0,00 $282,00 $194,36 $236,36 $0,00 $0,00 $8,49 $89,49 $0,00 $0,00 $0,00 $0,00 $0,00 $35,25 $11,47 $191,47 $0,00 $0,00 $0,00 $101,25 $5,11 $113,11 $32,10 $74,10 $0,00 $0,00 $0,00 $94,00 $1,97 $109,97 $1,29 $189,29 $29,55 $123,55 $0,00 $0,00 $0,00 $108,00 $0,00 $188,00 $24,18 $59,43 $5,74 $59,74 $8,12 $116,12 $0,00 $105,00 $10,01 $52,01 $831,13 $1.066,13 $0,00 $0,00 $20,31 $128,31 $10,18 $91,18 $103,67 $253,67 $0,00 $60,00 $11,36 $42,86 $73,07 $147,32 $51,64 $135,64 $237,21 $345,21 $32,97 $197,47 $0,00 $0,00 $0,00 $0,00 $29,97 $149,97 $82,10 $187,10 $65,12 $173,12 $25,33 $140,83 $55,32 $290,32 $34,53 $154,53 $0,00 $0,00 $69,48 $177,48 $0,00 $162,00 $0,00 $0,00 0 0 0 1 0 1 0 0 0 1 0 0 1 1 0 0 1 1 1 0 0 0 1 1 1 0 1 1 0 1 1 1 0 1 1 1 1 1 0 0 1 1 1 1 1 1 0 1 0 0 1 1 1 1 0 1 0 0 1 1 0 1 1 1 0 1 1 1 1 0 1 1 1 1 1 1 1 1 0 1 1 1 1 1 1 1 1 1 0 0 1 1 1 1 1 1 0 1 1 0 A 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 Last Name Allbaugh Bibb Blake Bolyard Bourque Craddock Cronk Crouse Deyoe Duarte Dubben Duck Fetchik Fiddes Freeman Gauger Harpole Hauch Henning Hornbeek Huang Hughes Hulsman Jwang Ketakea Lax Lenfestey Lessert Mallouf Mazza McMath Monac Montague Nigel Picazo Plumbtree Pomales Pomura Porterfield Reyes Rodman Roselius Ruaz Schoemann Stanton Stephens Stone Vandrey Walker Watts Wilson Yu B First Name Joshua Robin Barney Pat Elizabeth David June Aleta Rayundo Shawn Pamela Kelee Vearl Rick Jerry Samone Frank Joann Patricia Kent Woody Frank Russell Buyung Loraine Rafael Kionna Linda Pedro Pamela Olivia Levitica Carmen Emmett Luciano Leslie Oseas Joaquin Jimmy Rayna Johnny Reginald Monica Dale Catrina Lacretia David Yvonne Donny Kelly Jay William C Classification AM PT2 S2 S2 AM PT1 PT1 S1 PT1 PT1 PT2 S2 S1 S1 S1 AM PT1 PT2 S1 AM PT2 AM S1 AM PT2 S1 S1 S2 PT1 AM PT2 S1 S1 S2 S2 PT1 S1 PT1 S1 AM PT2 PT2 S2 S2 S1 PT1 AM S2 S2 S1 S1 PT2 D Department Men's Men's Cosmetics Housewares Linens Furniture Children's Children's Men's Children's Cosmetics Children's Furniture Cosmetics Housewares Women's Furniture Furniture Cosmetics Housewares Furniture Cosmetics Children's Women's Children's Housewares Linens Linens Housewares Furniture Housewares Men's Men's Linens Men's Women's Linens Linens Furniture Children's Men's Linens Men's Women's Women's Women's Cosmetics Women's Men's Women's Furniture Cosmetics E Sales $2.366,77 $759,32 $1.459,98 $3.422,17 $0,00 $0,00 $1.455,09 $3.241,17 $1.408,87 $1.349,96 $0,00 $1.875,93 $23.336,05 $0,00 $2.488,39 $1.568,63 $0,00 $0,00 $1.310,22 $0,00 $2.566,47 $2.598,32 $1.588,87 $2.201,07 $985,39 $1.189,92 $0,00 $620,45 $0,00 $0,00 $0,00 $4.711,67 $0,00 $2.917,79 $987,26 $0,00 $0,00 $0,00 $2.589,33 $0,00 $1.661,35 $0,00 $394,48 $982,75 $1.934,88 $0,00 $0,00 $1.293,44 $2.309,66 $267,41 $698,14 $780,25 F G H I J K Hours Worked Base pay Commission Gross Pay Quota Met? Worked Today? 8 188 $23,00 $211,00 1 1 4 47 $3,89 $50,89 1 1 7 105 $5,87 $110,87 1 1 8 120 $50,55 $170,55 1 1 0 0 $0,00 $0,00 0 0 0 0 $0,00 $0,00 0 0 8 84 $6,55 $90,55 1 1 8 108 $40,82 $148,82 1 1 4 42 $10,09 $52,09 1 1 4 42 $9,50 $51,50 1 1 0 0 $0,00 $0,00 0 0 5 75 $25,02 $100,02 1 1 5 67,5 $451,72 $519,22 1 1 0 0 $0,00 $0,00 0 0 8 108 $25,77 $133,77 1 1 4 94 $23,06 $117,06 1 1 0 0 $0,00 $0,00 0 0 0 0 $0,00 $0,00 0 0 9 121,5 $0,00 $121,50 0 1 0 0 $0,00 $0,00 0 0 5 58,75 $29,12 $87,87 1 1 4 94 $53,95 $147,95 1 1 6 81 $13,78 $94,78 1 1 4 94 $42,03 $136,03 1 1 5 58,75 $5,41 $64,16 1 1 8 108 $0,00 $108,00 0 1 0 0 $0,00 $0,00 0 0 3 45 $2,39 $47,39 1 1 0 0 $0,00 $0,00 0 0 0 0 $0,00 $0,00 0 0 0 0 $0,00 $0,00 0 0 10 135 $64,23 $199,23 1 1 10 135 $0,00 $135,00 0 1 10 150 $29,19 $179,19 1 1 5 75 $2,81 $77,81 1 1 0 0 $0,00 $0,00 0 0 0 0 $0,00 $0,00 0 0 0 0 $0,00 $0,00 0 0 8 108 $27,79 $135,79 1 1 0 0 $0,00 $0,00 0 0 4 47 $17,42 $64,42 1 1 0 0 $0,00 $0,00 0 0 2 30 $1,11 $31,11 1 1 2 30 $15,82 $45,82 1 1 8 108 $14,70 $122,70 1 1 0 0 $0,00 $0,00 0 0 0 0 $0,00 $0,00 0 0 6 90 $6,09 $96,09 1 1 8 120 $22,74 $142,74 1 1 4,5 60,75 $0,00 $60,75 0 1 5 67,5 $0,00 $67,50 0 1 4 47 $4,20 $51,20 1 1 Last Name Allbaugh Bibb Blake Bolyard Bourque Craddock Cronk Crouse Deyoe Duarte Dubben Duck Fetchik Fiddes Freeman Gauger Harpole Hauch Henning Hornbeek Huang Hughes Hulsman Jwang Ketakea Lax Lenfestey Lessert Mallouf Mazza McMath Monac Montague Nigel Picazo Plumbtree Pomales Pomura Porterfield Reyes Rodman Roselius Ruaz Schoemann Stanton Stephens Stone Vandrey Walker Watts Wilson First Name Joshua Robin Barney Pat Elizabeth David June Aleta Rayundo Shawn Pamela Kelee Vearl Rick Jerry Samone Frank Joann Patricia Kent Woody Frank Russell Buyung Loraine Rafael Kionna Linda Pedro Pamela Olivia Levitica Carmen Emmett Luciano Leslie Oseas Joaquin Jimmy Rayna Johnny Reginald Monica Dale Catrina Lacretia David Yvonne Donny Kelly Jay Classification AM PT2 S2 S2 AM PT1 PT1 S1 PT1 PT1 PT2 S2 S1 S1 S1 AM PT1 PT2 S1 AM PT2 AM S1 AM PT2 S1 S1 S2 PT1 AM PT2 S1 S1 S2 S2 PT1 S1 PT1 S1 AM PT2 PT2 S2 S2 S1 PT1 AM S2 S2 S1 S1 Department Men's Men's Cosmetics Housewares Linens Furniture Children's Children's Men's Children's Cosmetics Children's Furniture Cosmetics Housewares Women's Furniture Furniture Cosmetics Housewares Furniture Cosmetics Children's Women's Children's Housewares Linens Linens Housewares Furniture Housewares Men's Men's Linens Men's Women's Linens Linens Furniture Children's Men's Linens Men's Women's Women's Women's Cosmetics Women's Men's Women's Furniture Sales Hours Worked Base pay Commission $10.730,69 38 $893,00 $108,31 $12.972,86 20 $235,00 $158,67 $8.023,60 40 $600,00 $50,06 $6.456,81 30 $450,00 $50,55 $6.404,31 40 $940,00 $14,01 $30.559,34 20 $210,00 $287,39 $7.324,31 20 $210,00 $53,24 $12.448,05 40 $540,00 $139,98 $2.549,76 13 $136,50 $12,50 $7.873,57 20 $210,00 $58,74 $5.417,10 20 $235,00 $48,86 $9.553,87 40 $600,00 $75,79 $48.346,81 32 $432,00 $870,94 $4.768,67 40 $540,00 $14,01 $8.966,32 38 $513,00 $65,33 $9.143,49 22 $283,00 $82,31 $37.859,29 24 $252,00 $354,59 $57.525,90 20 $235,00 $825,85 $7.411,59 40 $540,00 $37,02 $9.289,89 40 $940,00 $59,98 $59.984,31 20 $235,00 $862,26 $8.463,05 23 $317,25 $108,16 $12.057,63 40 $540,00 $126,24 $11.957,08 40 $940,00 $172,92 $3.673,08 20 $235,00 $29,59 $10.655,25 40 $540,00 $101,26 $6.553,78 37 $499,50 $83,13 $14.154,63 40 $600,00 $195,25 $7.606,25 20 $210,00 $56,06 $58.684,18 40 $940,00 $1.520,53 $4.502,29 14 $164,50 $42,88 $15.463,78 40 $540,00 $189,28 $3.420,68 29 $391,50 $22,26 $12.352,46 40 $600,00 $142,14 $2.900,73 21 $315,00 $2,81 $4.695,04 20 $210,00 $26,95 $13.553,95 40 $540,00 $153,57 $9.025,85 16 $168,00 $74,74 $49.111,96 38 $513,00 $868,24 $9.197,74 40 $940,00 $50,44 $6.161,32 20 $235,00 $55,67 $5.999,60 20 $235,00 $52,49 $10.832,80 40 $600,00 $103,87 $9.661,91 40 $600,00 $138,80 $16.069,11 40 $540,00 $205,96 $7.849,95 20 $210,00 $58,50 $8.800,54 40 $940,00 $60,39 $12.195,07 40 $600,00 $139,59 $11.180,00 38 $570,00 $113,25 $10.623,69 40 $540,00 $115,44 $2.664,00 21 $283,50 $3,14 Yu William PT2 Cosmetics $5.704,88 20 $235,00 $48,07 Gross Pay Quota Met? Days Worked Average Quota $1.001,31 4 5 80,00% $393,67 4 5 80,00% $650,06 5 6 83,33% $500,55 1 5 20,00% $954,01 1 5 20,00% $497,39 3 5 60,00% $263,24 3 3 100,00% $679,98 4 5 80,00% $149,00 3 3 100,00% $268,74 4 4 100,00% $283,86 3 4 75,00% $675,79 4 6 66,67% $1.302,94 5 5 100,00% $554,01 2 5 40,00% $578,33 6 6 100,00% $365,31 4 5 80,00% $606,59 4 4 100,00% $1.060,85 5 5 100,00% $577,02 3 5 60,00% $999,98 4 5 80,00% $1.097,26 3 3 100,00% $425,41 4 5 80,00% $666,24 6 7 85,71% $1.112,92 4 6 66,67% $264,59 2 5 40,00% $641,26 4 6 66,67% $582,63 2 6 33,33% $795,25 6 7 85,71% $266,06 5 5 100,00% $2.460,53 5 5 100,00% $207,38 3 4 75,00% $729,28 5 5 100,00% $413,76 3 5 60,00% $742,14 4 6 66,67% $317,81 1 4 25,00% $236,95 4 4 100,00% $693,57 5 6 83,33% $242,74 2 3 66,67% $1.381,24 5 5 100,00% $990,44 3 5 60,00% $290,67 4 5 80,00% $287,49 3 3 100,00% $703,87 5 6 83,33% $738,80 3 6 50,00% $745,96 5 6 83,33% $268,50 3 3 100,00% $1.000,39 2 5 40,00% $739,59 5 6 83,33% $683,25 5 5 100,00% $655,44 4 6 66,67% $286,64 1 4 25,00% $283,07 3 3 100,00% Sales Code AM PT1 PT2 S1 S2 Sales Title Hourly Wage Quota Commission Rate Assistant Manager $ 23,50 $ 200,00 0,030 Sales Assistant $ 10,50 $ 100,00 0,010 Sales Partner $ 11,75 $ 125,00 0,015 Sales Associate $ 13,50 $ 150,00 0,020 Sales Consultant $ 15,00 $ 175,00 0,025
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

hi buddy I'm through with the paper. Thank you

Surname [1]
Student’s Name
Professor’s Name
Management
30 March 2017
1....


Anonymous
Really useful study material!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags