of Week 7 For Question 4 1) Click Pay Policy tab, and increase every quota in Hourly Quota column by $75. $200 is $275 now, $100 is $175 now, and so on and so forth, as shown in the picture below: 2) Save the change in the Pay Policy. Note: You must save the change to make the change take effect. 3) Now click Weekly tab. Click cell F1, which is the title cell of Weekly Commissions, and then add a Filter onto this table. (The way of adding Filter is click Data tab, and then click Filter, as shown in the red circle below). 4) Click the little triangle of the Weekly Commission Filter, choose Number Filters > Equals... 5) Type 0 in the box and then click OK. The reason we type 0 is because we want to see whose commissions are zero last week. 6) The list in the table now shows the employees who didn't receive commissions. Copy and paste the list into a Word document. For Question 5 1) Restore the Hourly Quota first. Because we have changed Hourly Quota for question 4, we have to restore the original values before answering question 5. Now, $275 is $200, $175 is $100.... 2) Save the change in the Pay Policy. 3) Now add half percent to each commission rate. Note that half percent is 0.5%, which is 0.005. So, we need to add 0.005 to each commission rate, as shown in the picture below: 4) Save the change in the Pay Policy. 5) Now click Weekly tab. Click cell F1, which is the title cell of Weekly Commissions, and then add a Filter onto this table. (The way of adding Filter is click Data tab, and then click Filter, as shown in the red circle below). 6) Click the little triangle of the Weekly Commission Filter, choose Number Filters > Greater than... 7) Type 2000 in the box and click OK. The reason we type 2000 is because we want to see who received more than $2000 commissions last week. 8) Copy and paste the list into the Word document. Excel Assignment 2 Note: You need the Madison4.xls file to complete this assignment. Madison4.xls records the employee's names, job title code, daily actual sales, and actual hours he or she worked from Monday to Sunday. Business Scenario: A human resource manager is analyzing the employee's weekly base pay and weekly commission in the Madison4.xls file. The company has the following pay policies: (1) Each employee's weekly base pay is the total of the employee's daily base pays from Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, to Sunday. Each employee's weekly commission is the total of the employee's daily sales commissions from Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, to Sunday. (2) Daily Base Pay An employee's daily base pay = Hours the employee worked in a day * Hourly base pay wage according to the employee's job title code. For instance, if an employee's job title code is PT1, his hourly base pay wage is $10.50 as shown in Table 1 below. If he worked 10 hours on Monday, his daily base pay should be $10.50 * 10 = $105 on Monday. (3) Daily Sales Commissions An employee may receive daily sales commissions; however, he can only receive the daily sales commissions, if his daily actual sales are greater than or equal to the daily sales quota (i.e., daily sales requirements). An employee's daily sales quota = Hours the employee worked in a day * Hourly sales quota according to the employee's job title code. For instance, if an employee's job title code is PT1, his hourly sales quota is $100 as shown in Table 1 below. If he worked 10 hours on Monday, his daily sales quota should be $100 * 10 = $1000 on Monday. This employee can only receive sales commissions, if his made at least $1000 in sales. If his actual sales are less than $1000, he can't receive daily sales commissions on Monday. If the employee's daily actual sales are greater than or equal to the daily sales quota, then An employee's daily sales commissions = The employee's daily actual sales * Sales commission rate according to the employee's job title code. Table 1: Madison Pay Policy Job Title Code Job Title Code Annotation Hourly Base Pay Wage Hourly Sales Quota Sales Commission Rate AM Assistant Manager $23.50 $200.00 0.03 PT1 Sales Assistant $10.50 $100.00 0.01 PT2 Sales Partner $11.75 $125.00 0.15 S1 Sales Associate $13.50 $150.00 0.02 S2 Sales Consultant $15.00 $175.00 0.025 Questions: (1) In the Weekly spreadsheet of Madison4.xls, create two new columns, Weekly Base Pay and Weekly Commissions. (2) Calculate the Weekly Base Pay and Weekly Commissions for each employee, and use filter to analyze which salespersons received more than $1500 in commissions last week. Note: Create a new Microsoft Word file with a file name Assignment2Report. Copy your analysis results from Madison4, and paste them into the Assignment2Report. (3) Use filter to analyze which salespersons did not receive a commission last week. Copy your analysis results and paste them into the Assignment2Report. (4) If the human resource manager increased the sales quota for each position by $75 per hour, use filter to analyze which salespersons did not receive a commission last week. Copy and paste the analysis results into the Assignment2Report. Hint for Question 4: Notice that we use the external reference in the Weekly spreadsheet to refer to the cells in "Pay Policy" spreadsheet. Therefore, when the manager increases/decreases hourly quota or commission rates in the "Pay Policy" spreadsheet, the "Weekly Base Pay" and "Weekly Commissions" will change accordingly. When we make the report, we only need to change the values in the "Pay Policy" spreadsheet, and then go back to "Weekly" spreadsheet to find the answer by using filters. For instance, the manager wants to know what would happen if he increased the sales quota for each position by $75 per hour. Obviously, when the sales quota increases, employees need to make more sales to get commissions, it raises the requirements for employees, therefore, fewer employees will get commissions. However, we want to know who didn't receive the commissions. We need to go to the "Pay Policy" spreadsheet, and add 75 to each cell in column D (i.e., the Hourly Quota column). Click the save button in the upper left corner of Excel, as shown in the red circle below: Now the values in Weekly Commissions and Weekly Pay Base column of the Weekly spreadsheet will change automatically. Now we apply filter on the Weekly Commissions column, the rule of the filter is \"equals to 0\". The Weekly spreadsheet will show us the employees who didn't receive any commissions last week. We need to copy and paste the information of these employees into the word file. After this operation, we go back to "Pay Policy", restore all values in column D to the original data (as shown \"Madison Pay Policy\" above), and get ready for the next question. This is how we make the report for the manager. (5) If the human resource manager increased each sales position's commission rate by a half of a percent, use filter to analyze which salespersons received more than $2000 in commissions last week. Copy and paste the analysis results into the Assignment2Report. Please turn in both Madison4 with filters and Assignment2Report word file. How to Make the Report Fit the Word Document Please note: The data shown in the pictures below are just example. 1) Copy the answers in Excel after the filter analyses 2) Open a Word document, and paste the range from Excel into the Word document. The table could be very large and goes beyond the document's limit. Now move the mouse over the table in the Word document. Note: Please don't click on the table, just move the mouse over the table. You will see a little cross show up in the upper left corner of the table (as shown in the red circle below) 3) Right click the cross, and choose Autofit >Autofit to Window in the menu Last Name First Name Classification Department Sales Hours Worked Allbaugh Joshua AM Men's 4000 8 Bibb Robin PT2 Men's 10065.23 8 Blake Barney Bolyard Pat Bourque Elizabeth Craddock David Cronk June Crouse Aleta Deyoe Rayundo Duarte Shawn Dubben Pamela Duck Kelee Fetchik Vearl Fiddes Rick Freeman Jerry Gauger Samone Harpole Frank Hauch Joann Henning Patricia Hornbeek Kent Huang Woody Hughes Frank Hulsman Russell Jwang Buyung Ketakea Loraine Lax Rafael Lenfestey Kionna Lessert Linda Mallouf Pedro Mazza Pamela McMath Olivia Monac Levitica Montague Carmen Nigel Emmett Picazo Luciano Plumbtree Leslie Pomales Oseas Pomura Joaquin Porterfield Jimmy Reyes Rayna Rodman Johnny Roselius Reginald Ruaz Monica Schoemann Dale Stanton Catrina Stephens Lacretia Stone David Vandrey Yvonne Walker Donny Watts Kelly Wilson Jay Yu 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 456.76 450.98 650.75 250.78 1500 0 500 1402.98 0 873.08 4500.67 356.26 1500.25 250 1469.78 7502.03 0 890.47 0 1000 1100 1202.02 199.99 802.46 50 1502.96 0 2500 0 0 0 196.89 0 250.75 850.63 251.36 0 2399 1546.78 1908 2159.69 0 821.36 345.96 1766 0 0 234.45 0 2225 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 A 1 B C D Last Name Allbaugh First Name Joshua Classification AM Department Men's Bibb Robin PT2 Men's 5 Blake Bolyard Barney Pat S2 S2 Cosmetics Housewares 6 Bourque Elizabeth AM Linens 7 8 9 Craddock Cronk David June PT1 PT1 Crouse Deyoe Aleta Rayundo 2 3 4 10 11 E F Sales 1315.86 Hours Worked 6 0 0 1318.97 943.17 6 6 686.57 7 Furniture Children's 4502.33 0 4 0 S1 PT1 Children's Men's 649.27 0 8 0 Duarte Shawn PT1 Children's 0 0 12 13 Dubben Duck Pamela Kelee PT2 S2 Cosmetics Children's 556 1798.88 4 5 14 Fetchik Vearl S1 Furniture 4925.96 8 15 16 Fiddes Freeman Rick Jerry S1 S1 Cosmetics Housewares 1900.54 891.19 9 5 17 18 Gauger Harpole Samone Frank PT1 PT1 Women's Furniture 0 3228.87 0 4 19 20 21 Hauch Henning Hornbeek Joann Patricia Kent PT2 S1 AM Furniture Cosmetics Housewares 1251.02 1788.34 2654.44 4 7 8 22 23 24 25 26 Huang Hughes Hulsman Jwang Ketakea Woody Frank Russell Buyung Loraine PT2 PT2 S1 AM PT2 Furniture Cosmetics Children's Women's Children's 0 375.52 474.44 0 350.45 0 4 2 0 4 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 Lax Lenfestey Lessert Mallouf Mazza Rafael Kionna Linda Pedro Pamela S1 S1 S2 PT1 AM Housewares Linens Linens Housewares Furniture 3789.21 133.98 4114.09 1195.42 0 8 8 6 4 0 McMath Monac Montague Nigel Picazo Plumbtree Pomales Pomura Porterfield Reyes Rodman Roselius Ruaz Schoemann Stanton Stephens Stone Vandrey Walker Watts Wilson Yu Olivia Levitica Carmen Emmett Luciano Leslie Oseas Joaquin Jimmy Rayna Johnny Reginald Monica Dale Catrina Lacretia David Yvonne Donny Kelly Jay William PT2 S1 S1 S2 S2 PT1 S1 PT1 S1 AM PT2 PT2 S2 S2 S1 PT1 AM S2 S2 S1 S1 PT2 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 1745.9 2822.5 657.56 1398.88 0 0 3519.79 2810.02 6768.68 1047.66 0 0 1532.87 0 1486.22 0 0 2719.75 1994.48 2127.32 0 0 2 6 8 6 0 0 4 5 6 5 0 0 5 8 5 0 0 6 8 8 2 0 A 1 B C D Last Name Allbaugh Bibb First Name Joshua Robin Classification AM PT2 Department Men's Men's Blake Barney S2 Cosmetics 5 Bolyard Pat S2 6 7 Bourque Craddock Elizabeth David 8 9 Cronk Crouse 10 11 12 E F 1927.74 145.02 Hours Worked 8 2 1674.25 8 Housewares 718.63 5 AM PT1 Linens Furniture 1501.8 5600 8 4 June Aleta PT1 S1 Children's Children's 0 1565.72 0 6 Deyoe Rayundo PT1 Men's 640.89 5 Duarte Dubben Shawn Pamela PT1 PT2 Children's Cosmetics 0 2489.42 0 8 13 14 15 Duck Fetchik Kelee Vearl S2 S1 Children's Furniture 0 0 0 0 Fiddes Rick S1 Cosmetics 1349.77 8 16 17 18 19 20 Freeman Gauger Harpole Hauch Henning Jerry Samone Frank Joann Patricia S1 PT1 PT1 PT2 S1 Housewares Women's Furniture Furniture Cosmetics 784.67 1208.96 5414.32 10031.4 800.36 4 6 7 2 8 21 22 23 24 25 Hornbeek Huang Hughes Hulsman Jwang Kent Woody Frank Russell Buyung AM PT2 PT2 S1 AM Housewares Furniture Cosmetics Children's Women's 1631.42 0 888.98 2994.38 3565.69 8 0 4 6 8 26 27 28 29 30 Ketakea Lax Lenfestey Lessert Mallouf Loraine Rafael Kionna Linda Pedro PT2 S1 S1 S2 PT1 Children's Housewares Linens Linens Housewares 0 2440.4 0 1549.63 1296.12 0 8 2 8 4 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 Mazza McMath Monac Montague Nigel Picazo Plumbtree Pomales Pomura Porterfield Reyes Rodman Roselius Ruaz Schoemann Stanton Stephens Stone Vandrey Walker Watts Wilson Yu Pamela Olivia Levitica Carmen Emmett Luciano Leslie Oseas Joaquin Jimmy Rayna Johnny Reginald Monica Dale Catrina Lacretia David Yvonne Donny Kelly Jay William AM PT2 S1 S1 S2 S2 PT1 S1 PT1 S1 AM PT2 PT2 S2 S2 S1 PT1 AM S2 S2 S1 S1 PT2 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 13354.9 393.54 2221.51 367.89 861.81 0 0 1564.52 0 9999.29 1117.46 199.91 597.49 3593.96 3385.26 4864.47 0 490.64 3389.92 2080.44 1967.8 456.98 0 5 4 8 2 5 0 0 8 0 8 8 2 4 8 10 8 0 4 8 8 8 2 0 2 3 4 Sales A 1 B C D 2 3 4 5 Last Name Allbaugh Bibb Blake Bolyard First Name Joshua Robin Barney Pat Classification AM PT2 S2 S2 Department Men's Men's Cosmetics Housewares E F Sales 0 791.85 0 0 Hours Worked 0 2 0 0 6 Bourque Elizabeth AM Linens 1866.99 7 7 8 Craddock Cronk David June PT1 PT1 Furniture Children's 369.87 4369.22 4 8 9 10 Crouse Deyoe Aleta Rayundo S1 PT1 Children's Men's 0 0 0 0 11 Duarte Shawn PT1 Children's 3865.87 8 12 13 Dubben Duck Pamela Kelee PT2 S2 Cosmetics Children's 2336.66 1522.64 5 5 14 15 Fetchik Fiddes Vearl Rick S1 S1 Furniture Cosmetics 7726.69 0 6 0 16 Freeman Jerry S1 Housewares 1846.25 8 17 18 Gauger Harpole Samone Frank PT1 PT1 Women's Furniture 0 27746.32 0 8 19 20 21 Hauch Henning Hornbeek Huang Hughes Joann Patricia Kent Woody Frank PT2 S1 AM PT2 PT2 Furniture Cosmetics Housewares Furniture Cosmetics 12324.11 0 0 0 0 0 0 0 0 0 Hulsman Jwang Ketakea Russell Buyung Loraine S1 AM PT2 Children's Women's Children's 2693.21 2461.87 150 8 4 4 27 28 29 30 31 Lax Lenfestey Lessert Mallouf Mazza Rafael Kionna Linda Pedro Pamela S1 S1 S2 PT1 AM Housewares Linens Linens Housewares Furniture 0 263.23 2113.09 2275.95 8632.72 0 6 5 4 8 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 McMath Monac Montague Nigel Picazo Plumbtree Pomales Pomura Porterfield Reyes Rodman Roselius Ruaz Schoemann Stanton Stephens Stone Vandrey Walker Watts Wilson Yu Olivia Levitica Carmen Emmett Luciano Leslie Oseas Joaquin Jimmy Rayna Johnny Reginald Monica Dale Catrina Lacretia David Yvonne Donny Kelly Jay William PT2 S1 S1 S2 S2 PT1 S1 PT1 S1 AM PT2 PT2 S2 S2 S1 PT1 AM S2 S2 S1 S1 PT2 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 1228.73 3492.55 986.25 1080.15 999.36 1313.6 1590.69 0 0 0 790.53 3494.11 0 456.36 2506.07 3870.88 1768.87 1698.97 2889.7 1352.79 0 2699.63 4 8 3 8 8 7 8 0 0 0 2 8 0 8 4 7 8 8 8 5 0 8 22 23 24 25 26 A 1 B C D Last Name Allbaugh Bibb First Name Joshua Robin Classification AM PT2 Department Men's Men's Blake Bolyard Barney Pat S2 S2 Cosmetics Housewares 7 8 Bourque Craddock Cronk Elizabeth David June AM PT1 PT1 9 Crouse Aleta 10 11 Deyoe Duarte 12 13 E F 0 1211.44 Hours Worked 0 4 2604.92 0 8 0 Linens Furniture Children's 0 0 0 0 0 0 S1 Children's 5667.64 12 Rayundo Shawn PT1 PT1 Men's Children's 0 1254.76 0 4 Dubben Duck Pamela Kelee PT2 S2 Cosmetics Children's 0 924.38 0 8 14 Fetchik Vearl S1 Furniture 7857.44 8 15 16 Fiddes Freeman Rick Jerry S1 S1 Cosmetics Housewares 778.26 0 8 0 17 18 Gauger Harpole Samone Frank PT1 PT1 Women's Furniture 2506.25 0 4 0 19 20 21 Hauch Henning Hornbeek Joann Patricia Kent PT2 S1 AM Furniture Cosmetics Housewares 25447.82 2214.27 2470.54 4 8 8 22 23 24 25 26 27 28 29 Huang Hughes Hulsman Jwang Ketakea Woody Frank Russell Buyung Loraine PT2 PT2 S1 AM PT2 Furniture Cosmetics Children's Women's Children's 54447.87 3600.23 2261.34 1535.36 0 7 6 4 4 0 Lax Lenfestey Lessert Rafael Kionna Linda S1 S1 S2 Housewares Linens Linens 1546.31 4500.79 3684.97 4 5 7 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 Mallouf Mazza McMath Monac Montague Nigel Picazo Plumbtree Pomales Pomura Porterfield Reyes Rodman Roselius Ruaz Schoemann Stanton Stephens Stone Vandrey Walker Watts Wilson Yu Pedro Pamela Olivia Levitica Carmen Emmett Luciano Leslie Oseas Joaquin Jimmy Rayna Johnny Reginald Monica Dale Catrina Lacretia David Yvonne Donny Kelly Jay William PT1 AM PT2 S1 S1 S2 S2 PT1 S1 PT1 S1 AM PT2 PT2 S2 S2 S1 PT1 AM S2 S2 S1 S1 PT2 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 1438.21 4492.35 1134.12 0 0 0 657.63 1694.59 1550.01 0 16693.99 2134.47 1962.75 4 5 4 0 0 0 4 8 8 0 8 8 4 0 5 5 0 0 8 4 6 0 0 0 2 3 4 5 6 Sales 552.94 328.56 0 0 930.9 311.63 1905.72 0 0 0 A 1 B C D 2 Last Name Allbaugh First Name Joshua Classification AM Department Men's 3 Bibb Robin PT2 Men's Blake Barney S2 5 6 Bolyard Bourque Pat Elizabeth 7 Craddock 8 9 E F 1120.32 Hours Worked 8 0 0 Cosmetics 508.72 8.5 S2 AM Housewares Linens 921.86 1698.2 8 12 David PT1 Furniture 19836.36 4 Cronk Crouse June Aleta PT1 S1 Children's Children's 0 1324.25 0 6 10 11 Deyoe Duarte Rayundo Shawn PT1 PT1 Men's Children's 0 0 0 0 12 Dubben Pamela PT2 Cosmetics 35.02 3 13 14 Duck Fetchik Kelee Vearl S2 S1 Children's Furniture 2558.96 0 12 0 15 16 17 Fiddes Freeman Rick Jerry S1 S1 Cosmetics Housewares 383.84 1455.57 7.5 8 Gauger Samone PT1 Women's 3609.65 4 18 19 20 21 22 Harpole Hauch Henning Hornbeek Huang Frank Joann Patricia Kent Woody PT1 PT2 S1 AM PT2 Furniture Furniture Cosmetics Housewares Furniture 0 969.52 1298.4 1643.02 2969.97 0 8 8 8 8 23 24 25 26 27 Hughes Hulsman Jwang Ketakea Lax Frank Russell Buyung Loraine Rafael PT2 S1 AM PT2 S1 Cosmetics Children's Women's Children's Housewares 0 945.39 991.07 1987.25 886.95 0 8 8 3 4 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 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 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 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 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 1605.78 569.44 1400.55 29704.21 0 2215.55 1408.98 5896.94 256.48 1436.1 4478.31 5964.47 13060.67 2499.15 0 0 2598.86 4508.98 4456.11 3633.11 3844.13 2781.36 0 4673.92 1508.88 0 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 4 Sales 1 2 3 4 A Last Name Allbaugh Bibb Blake B First Name Joshua Robin Barney C Classification AM PT2 S2 D Department Men's Men's Cosmetics 5 6 Bolyard Bourque Pat Elizabeth S2 AM Housewares Linens 7 Craddock David PT1 Furniture 8 9 Cronk Crouse June Aleta PT1 S1 10 11 Deyoe Duarte Rayundo Shawn 12 Dubben 13 14 Duck Fetchik 15 16 17 Sales E F Hours Worked 2366.77 8 759.32 4 1459.98 7 3422.17 0 8 0 0 0 Children's Children's 1455.09 3241.17 8 8 PT1 PT1 Men's Children's 1408.87 1349.96 4 4 Pamela PT2 Cosmetics 0 0 Kelee Vearl S2 S1 Children's Furniture 1875.93 23336.05 5 5 Fiddes Freeman Rick Jerry S1 S1 Cosmetics Housewares 0 2488.39 0 8 Gauger Samone AM Women's 1568.63 4 18 19 20 21 22 Harpole Hauch Henning Hornbeek Huang Frank Joann Patricia Kent Woody PT1 PT2 S1 AM PT2 Furniture Furniture Cosmetics Housewares Furniture 0 0 1310.22 0 2566.47 0 0 9 0 5 23 24 25 26 27 Hughes Hulsman Jwang Ketakea Lax Frank Russell Buyung Loraine Rafael AM S1 AM PT2 S1 Cosmetics Children's Women's Children's Housewares 2598.32 1588.87 2201.07 985.39 1189.92 4 6 4 5 8 28 29 30 31 32 Lenfestey Lessert Mallouf Mazza McMath Kionna Linda Pedro Pamela Olivia S1 S2 PT1 AM PT2 Linens Linens Housewares Furniture Housewares 0 620.45 0 0 0 0 3 0 0 0 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 Monac Montague Nigel Picazo Plumbtree Pomales Pomura Porterfield Reyes Rodman Roselius Ruaz Schoemann Stanton Stephens Stone Vandrey Walker Watts Wilson Yu Levitica Carmen Emmett Luciano Leslie Oseas Joaquin Jimmy Rayna Johnny Reginald Monica Dale Catrina Lacretia David Yvonne Donny Kelly Jay William S1 S1 S2 S2 PT1 S1 PT1 S1 AM PT2 PT2 S2 S2 S1 PT1 AM S2 S2 S1 S1 PT2 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 4711.672 0 2917.79 987.26 0 0 0 2589.33 0 1661.35 0 394.48 982.75 1934.88 0 0 1293.44 2309.66 267.41 698.14 780.25 10 10 10 5 0 0 0 8 0 4 0 2 2 8 0 0 6 8 4.5 5 4 Last Name First Name Classification Department Allbaugh Joshua AM Men's Bibb Robin PT2 Men's Blake Barney S2 Cosmetics Bolyard Pat S2 Housewares Bourque Elizabeth AM Linens Craddock David PT1 Furniture Cronk June PT1 Children's Crouse Aleta S1 Children's Deyoe Rayundo PT1 Men's Duarte Shawn PT1 Children's Dubben Pamela PT2 Cosmetics Duck Kelee S2 Children's Fetchik Vearl S1 Furniture Fiddes Rick S1 Cosmetics Freeman Jerry S1 Housewares Gauger Samone AM Women's Harpole Frank PT1 Furniture Hauch Joann PT2 Furniture Henning Patricia S1 Cosmetics Hornbeek Kent AM Housewares Huang Woody PT2 Furniture Hughes Frank AM Cosmetics Hulsman Russell S1 Children's Jwang Buyung AM Women's Ketakea Loraine PT2 Children's Lax Rafael S1 Housewares Lenfestey Kionna S1 Linens Lessert Linda S2 Linens Mallouf Pedro PT1 Housewares Mazza Pamela AM Furniture McMath Olivia PT2 Housewares Monac Levitica S1 Men's Montague Carmen S1 Men's Nigel Emmett S2 Linens Picazo Luciano S2 Men's Plumbtree Leslie PT1 Women's Pomales Oseas S1 Linens Pomura Joaquin PT1 Linens Porterfield Jimmy S1 Furniture Reyes Rayna AM Children's Rodman Johnny PT2 Men's Roselius Reginald PT2 Linens Ruaz Monica S2 Men's Schoemann Dale S2 Women's Stanton Catrina S1 Women's Stephens Lacretia PT1 Women's Stone David AM Cosmetics Vandrey Yvonne S2 Women's Walker Donny S2 Men's Watts Kelly S1 Women's Wilson Jay S1 Furniture Yu William PT2 Cosmetics Sales Code Sales Title Hourly Wage Hourly Quota Commision Rate AM Assistant Manager $23.50 $200.00 0.03 PT1 Sales Assistant $10.50 $100.00 0.01 PT2 Sales Partner $11.75 $125.00 0.15 S1 Sales Associate $13.50 $150.00 0.02 S2 Sales Consultant $15.00 $175.00 0.025