Excel sheet project

User Generated

Qenan2727

Business Finance

Description

If you're really good at excel this shouldn't be hard. Ill send you my saved excel sheet, whereI have done 1st step of the work. You just have to continue with the instructions and complete the following Excel Sheet. I've uploaded all the instructions and the excel sheet.

Unformatted Attachment Preview

BU-250 Excel-1 Assignment – Check Figures for PART 1 Dr. Pamela Schmidt Part 1: For Sunday Worksheet: Check figures for bottom of the worksheet: * Note that the BLUE fields are for use in the initial Sunday worksheet as you learn how the Commission calculation is done. You are not required to complete the Blue columns of H to L for the other worksheets. (Columns J to L will not graded on the Summary worksheet.) CAREFUL: Be sure that you column “Nested Calc Commission” (Yellow heading in Column M) contains a single complete formula which contains only use of cell references to columns E, F and G along with VLookup() to return data from WageInfo reference table. (“Nested Calc Commission” should not reference any fields in Blue columns H to L) Part 1: For “Summary” Worksheet (where you add up all data from Sunday to Saturday (totally 7 days): Check figures for bottom of the worksheet: Excel Case #2 –Babbage Auto Part Sales (v8) BU-250 High Level of Difficulty – This Excel-2 case: introduces several advanced Excel Features. It is several times longer than the prior assignment (start today). It is to be completed in two parts, submit to D2L when due. Learning Goals: This case presents a multi-worksheet, weekly analysis of pay Salary and commission based on sales per employee. It introduces Pivot Tables where are powerful data manipulation and data analysis features of Excel. You should learn how to structure a time series analysis, and how to create a set of different data analysis and ‘what-if’ business analysis to support decision making in the company. Key aspects of Excel design and feature use include: • Structuring a time-based data analysis • Creating complex nested functions (using a function with another function inside of it to calculate a parameter) for example: Using an IF() function which includes Vlookups() inside to obtain parameters. • Use Absolute and Relative Cell Referencing so you can copy formulas correctly to other adjoining cells (to quickly do work). • Hiding cells (when no longer needed, or to reduce visible work area) • Data menu to do sorting or filtering • Pivot Tables – create work areas that a) link back to original source data, and b) support quickly building categorizing and subtotaling. • Macros – Automate frequently repeated actions in Excel. (Extra Credit) Excel-2 Case Overview: This project looks at two auto part stores in Detroit Michigan; operated by the Babbage brothers Mick and Tom. The Detroit market is lucrative and competitive. The brothers have recently revamped their business that provides auto parts to the greater metro area. The business model was recently changed to incorporate a sales commission to motivate sales associate and increase gross sales per customer. First: You create the daily reports from Sunday to Saturday, then create a Weekly summary sheet. After that, the brothers need you to create several pivot tables (Q1-Q10) that can be used over time to evaluate different sub-sets of the data, alternately grouped variously by store, by category and by sales position performance. These pivot tables will be used for “point in time” evaluations and performance benchmarks. The brothers have established several KPI (key performance indicators) for their business; sales generated per payroll dollar and sales generated per associate hour worked. 1 This project will start by importing 7 raw text files provided in a .zip file (Sunday to Saturday) as the starting place to calculate sales and salary data. You will enter the “wageinfo” table (provided below) into a new Excel file creating the “Wage” worksheet. create business information concerning Weekly sales and salaries for the two Babbage Stores. Ensure Worksheet tabs are in order: For the resulting project will have the following worksheets in this order: Wage, Sunday, Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Summary(Weekly), Manual, Q1, Q2, Q3, Q4, Q5, Q6, Q7, Q8, Q9, Q10. Key: Yellow start with individual imported text files (in different text files) Blue are pivot tables-based on Summary in Weekly. Notes: You type in the data pm the first “wage” worksheet from instructions below. You will create the summary worksheet by entering only Formulas, which reference back to prior 7 worksheets (for each day: Sunday, … Saturday) Manual worksheet is created by using formula and Filter-Sort features. Pivot tables are only created after all prior worksheets are completed. When completed, your Excel project tabs will look as follows: Part 1: Part 2: Open a Blank worksheet in Excel application. Name your Excel Workbook using this format (need .xlsm for Macros later): Babbage_Auto__V#.xlsm 2 PART 1 – Sales salaries and commissions Wage Worksheet: The first step is to create the worksheet for Wage, on a separate (new) worksheet. Create the Wage worksheet in a blank worksheet, using the data below (you can copy from below, and paste into new worksheet). Name the worksheet tab “Wage”. Then, setup a named table (i.e. assign a one word name to this table to be used in the Vlookup command). A good name for the table is wageinfo. Sales Code Sales Title Hourly Wage Hourly Quota Commission Rate MGR Manager $25.50 $300.00 5.25% AM Assistant Manager $22.50 $240.00 4.20% PT Sales Assistant $11.50 $120.00 2.63% SP Sales Partner $16.00 $120.00 2.63% SA Sales Associate $13.50 $180.00 3.94% SC Sales Consultant $18.00 $210.00 3.15% The command called VLOOKUP will use this ‘wageinfo’ named table to calculate Base Pay and Commission in each daily worksheet. Naming the table (named range) must be done before creating the Vlookup command. Reminder: one way to name the table is do highlight the rows and columns (data not heading) you keyed from above. Next click on the white area above Column A and enter wageinfo as a one word name for your table. Import Seven Daily Worksheets from individual Text files (.txt): The imported text files each start with cells containing labels: Store, Daily employee and sales information. Each Day (Sunday thru Saturday) is a separate text file (in D2L) and will need to be imported into the Excel spreadsheet. There will be 7 imports, one for each day. Each day’s information will be placed on a separate and different Worksheet. Open the import ZIP file from D2L, then save each day’s Text file. When all are saved, then you can import them. Data tab -- get external data -- text data. Start with the first worksheet: Sunday. Then, do these steps: 1. First, you need to place your name in the table. Go to line 14 and replace “Student” with your last name. 2. Base pay. Use Vlookup() to find hourly wage and calculate base pay by multiplying the wage by hours worked. VLookup definition: The VLOOKUP has 4 parameters in parenthesis, the parameters are separated by commas. The Vlookup works with wageinfo table that you created above. VLOOKUP( Param1, Param2, Param3, Param4) 3 Param1: Cell in this row to match column 1 of reference table. Param2: Name of table range (ex wageinfo) as reference table Param3: Index# of column you want to select in reference table and return to replace VLook(). Param4: FALSE means param1 must match exactly (use this) (TRUE param1 will only partially match table column 1) 3. Then, calculate commission following these Rules: • Commission is only paid if the full day’s Sales Quota is met and is only paid on the amount of sales above the daily Sales Quota. • Daily Sales Quota is (Hours Worked * Sales Quota). • The formula used for Commission calculation will be an IF() that contains two VLOOKUP commands. HINT: Under Columns H to K, first create each separate formula using any needed Vlookup() separately to get format correct on each separate part of the complex commission formula. In Column L you can put a ‘Step-Calc-Commission’ where you can reference prior cells to get Commission calculated and verified. Columns H to L are not filled out in Summary or Manual worksheets. 4. Then, in Column M build your full, self-contained ‘Nested Calc Commission’ where the full formula should be placed (one that does not reference cells in area of Column H to L). This allows you to build up the ‘Nested Calc Commission’ containing the full IF () statement containing all nested functions. The following “Commission Calculation: is the logic for the commission formula in English (you convert to a complex function in Excel). You will use IF statement containing nested VLOOKUP() to find data in the table. Nested-Commission Calculation: IF the daily sales [E2] are greater than (Hours Worked[F2] times Hourly Quota) [from table] then TRUE = Calculate commission using this formula: (Daily sales E2 minus the (Hours Worked F2 times Hourly Quota)) multiplied by the commission rate [from table] FALSE (i.e. not true) = zero (0) commission 4 5. Calculate gross pay by adding base pay and commission In addition to the information on the daily sheet, The Babbage brother’s wants to know how many days each employee worked and how many days they made quota. Therefore: 6. Calculate “Days Worked”. If the employee worked, the field should have a 1, if they did not work, the field should be a 0, so they can be added at the end of the week (weekly summary sheet). 7. Calculate “Quote Made” the same way as you did with ‘days worked’. 8. Summary Data: At the bottom for each daily worksheet provide overall totals (sum, average, minimum and maximum) for columns E to K. You are now done with Sunday. Now, you need to repeat all seven steps manually* for Monday to Saturday. Copy and paste of formulas will work if done very carefully and properly. *ADVANCED Alternative: is using linked worksheets (but any errors caused will show up in all linked worksheets). Best to complete one full day’s worksheet “Sunday” before considering this advanced step. See Excel functionality of “Linked worksheets” - which allows several linked worksheet to all be edited at one time (search help for information on this capability) “SUMMARY” of Week Worksheet: After all 7 daily sheets are complete then create a new worksheet for the Summary and label the worksheet TAB as “Summary”. 1. Summarize all numeric fields from the daily sheets to the Weekly sheet for each employee (i.e. add up Sunday through Saturday data from prior worksheets so totals show up in similar cell location on Summary worksheet). 2. Add a new column to the weekly summary, “% of quota met”. (HINT: % of quota meet is calculated: “number of days where quota was met “ divided by ‘total days worked’ this week). 3. Add a new column, “productivity” to show labor productivity. (HINT: labor productivity equals to daily sales divided by hours worked) 4. Additionally, add totals to the weekly summary similar to the daily sheet totals. (HINT: notice the headings in A column, below the data, at the bottom of imported worksheets. Create the same headings and calculate these for SUMMARY worksheet). PART 2 – Analysis: Manual, Pivot Table & Pivot Chart 5 Part 2 – A - New Worksheet - MANUAL Tables: Top Performer Analysis. Copy the completed (and checked) “summary” worksheet. Rename the new worksheet tab (copy (2) to be “Manual” on tab. Goal: to manually create a report that only shows: Categories of Accessories, Fluids, and Replacement Parts alphabetically Grouped by store name within category, also ordered alphabetically Display only the top three sales associate, based on productivity (sorted high to low). Modify that new “manual” worksheet by using the Data menu to do sorting or filtering to list only Top-3 performers in each store of 3 categories below. a) There are only three (3) categories of interest: Accessories, Fluids, and Replacement Parts. So ensure that you only display these categories, in alphabetic order: Accessories, Fluids, and Replacement Parts. b) In each category, display only 3 performers, ordered from highest to lowest in term of productivity. Part 2 – B – PREPARE for doing Pivot Tables. PREP – read all the following 10 Questions which you should address by creating pivot tables (and a pivot chart, if also specifically requested). Look over the following questions and make sure all the information you will need is on the Weekly Summary. Additional data may be needed. NOTE: do not try to do mathematical calculations within a pivot table. For any calculations, go back and make additions to prior worksheets containing the data which can them be used for creating the pivot table needed. PIVOT TABLE & Chart WORKSHEETS - Use Pivot tables or pivot chart to answer all the following questions, placing each Pivot table answer on a separate worksheet. Label each worksheet with Question # (e.g. Question 1–label worksheet Q1), and put a title heading on the top of the spreadsheet itself (above or to the right of pivot table in top row). Question 1 – Create a Pivot table displaying overall sales by category for the all Auto Parts stores together (“Summary” Worksheet). Then build a pivot chart (a Pie Chart with a key, and showing sales numbers labeling each Pie section). This pie chart should be linked to the Pivot table you built. Question 2 – For each store and within each category, which sales associate had the one highest sales? Question 3 – For each store and category, which 3 sales associates earned the highest commission? Which 3 sales associates had Highest productivity? Show on same worksheet, one on far left, and one to right of it. 6 When these two pivot tables are completed, and placed on same worksheet, think about the effort involved. Do you recall how much work it was to manually create the earlier MANUAL worksheet, where you sorted and filtered view of ‘highest productivity’?) Question 4 – The Babbage brothers would like to understand the sales generated per hour worked by store and category. Question 5 – The Babbage brothers would like to understand the commission earned per hour worked by store and category. Question 6 – The Babbage brothers would like to understand the sales generated per dollar of payroll spent by store and category. Question 7 – Provide a pivot table summarizing all data by store, and sales code. Question 8 – (put two pivot tables on same worksheet, and include titles above each at top) Which category met its quotas more often than other categories? Which category met its quotas the least of all categories? Question 9 – Which sales associates received commission above average last week? Create report by store and category. HINT: Use a cell to do calculation using the function =Average() that refers back to appropriate cells in SUMMARY worksheet. Then you can type in that number (as calculated) to use as a comparison value for a pivot table ‘value comparison’. Question 10 - What would the impact on commissions be if the Babbage’s increased the hourly quota by 25% and increased commission percent by 50%? Compare the commission and proposed commission by Sales Code using pivot table and chart. (Hint – add a new table with calculated ‘Proposed_wageinfo’ on the “wage” worksheet, create this new “propose” named array, and then use that data to add columns with new calculation on the 7 daily sheets and weekly summary.) Calculate the difference between the two values (calculated using original ‘wageinfo’ with that using “Proposed_wageinfo” for each sales code, and calculate the impact. Hint: for what-if analysis, you can create a new ‘What-if” set of salary data based on the data in the original wageinfo table. Put it below original WageInfo table (skill two rows) and name this table array ‘WageInfo2’ See below (Do not type numbers directly into new table, use formulas). 7 Advanced skill: Macros (Extra credit) - (make sure to continue to SAVE AS this file as .xlsm to retain macros you built.) You want to polish presentation for daily worksheet so that it can be easily read. However, there are 7 daily worksheets and you don’t want to manually change each sheet. Macros can help you with repetitive tasks by recording actions in Excel such as applying style/ formatting, manipulating data and text, etc. (See tutorial videos posted on D2L under Tutorial: Excel menu) MACROS - Instructions: • To activate macros, choose ‘View’ ribbon and click “Macros” on the very far right. Then, choose “Record Macro…” • Name each Macro “Pres_#” (where # is a capital letter) and assign “Ctrl+Shift+#” for each shortcut. Record each new macro on the Sunday sheet, to create the three recorded Macros described below. Make sure to create appropriate shortcut names, so you can use these on the rest of the worksheets after recording/performing actions on Sunday worksheet. • Macro with Shortcut “Ctrl+Shift+A: (Remember: Get into worksheet, in VIEW Macros menu, click ‘start Recording’, then perform needed steps. When you are done, click “Stop 8 recording” under “Macros” button, or click square button at bottom page next to word Ready.) 1. Rename first associate (Anderson) on cell A2 as “Macro” 2. Calculate “Wages to sales ratio” on a new column (column N) for all associates by dividing wages over sales. • Macro with Shortcut “Ctrl+Shift+B: 3. Change the header title on row 1 to Bold font, and give yellow background to the cells. 4. Change cell format to “currency” to sales, base pay, commission, gross pay, proposed commission. • Macro with Shortcut “Ctrl+Shift+C: 5. Change cell format to “percentage” to wages to sales ratio. Run Macro for Monday to Saturday by going to each worksheet, • click “view Macros”, select “Presentation”, and click “run” • or press “Ctrl+Shift+#” until you have completed all of the above actions on all 7 daily worksheets. IMPORTANT: when you save your workbook use the excel with macro enabled file type .xlsm • SUBMITTING – Submit the Excel Workbook to the Second Excel Case drop box in D2L before the deadline. Note: • If you do not have macro in your file, save as regular excel file .xlsx • If you have macro in your file, save your workbook as excel with macro enabled file type .xlsm) Name your Excel Workbook using this format (need .xlsm to have Macros): Babbage_Auto__V#.xlsm (example: Jane-Doe_Babbage_Auto_v#.xlsm) 9 Associate Anderson Brick Blake Boles Bourque Craddock Crane Crouse Deyoe Duarte Dubben Duck Student Film Freeman Gauger Harp Hauch Henning Hornback Huang Hughes Hulsman Jwang Ketty Lax Len Lessert Mall Mazza McMath Monac Montague Nigel Pike Plumber Pomales Pomura Porterfield Reyes Rodman Roselius Ruaz Schoemann Stanton Stephens SalesCode AM PT SA SA AM PT SC SP PT SC PT SA MGR SP SP PT SC PT SP AM PT SC SP AM PT SP SP SA SC AM PT SP SP SA SA PT SP SC SP AM PT SA SA SA SP PT Category Store Specialty Town West Specialty Town West Accessories Town West Tools & ShopTown West Fluids Town West ReplacementTown parts West PerformanceTown West PerformanceTown West Specialty Town West PerformanceTown West Accessories Town West PerformanceTown West ReplacementTown parts West Accessories Town West Tools & ShopTown West Clearance Town West ReplacementTown parts West ReplacementTown parts West Accessories Town West Tools & ShopTown West ReplacementTown parts West Accessories Town West PerformanceTown West Clearance Town West PerformanceTown West Tools & ShopTown West Fluids Town West Fluids Town West Tools & ShopTown West ReplacementTown parts West Tools & ShopTown West Specialty Town West Specialty Town West Fluids Town West Specialty Town West Clearance Town West Fluids Town West Fluids Town West ReplacementTown parts West PerformanceTown West Specialty Town West Fluids Town West Specialty Town West Clearance Town West Clearance Town West Clearance Town West Sales 4500 10065.23 456.76 450.98 650.75 250.78 1500 0 500 1502.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 2200 0 196.89 0 250.75 850.63 251.36 0 3399 1546.78 1908 2159.69 0 821.36 345.96 Hours Worked Base Pay Hourly Quota 8 180 8 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 5 0 1 0 2 6.5 3 0 12 8 8 12 0 7 2 Stone Vandrey Walker Watts Wilson Zeon Argentine Box Bing Bolyard Bourque Crad Cronk Course Keyoe Muarte Gibb Lucky Sims Fiddes Beeman Auger Harpole Linch Ben Hornel AM SA SA SP SP SC AM PT SA SA AM PT SC SP SC SA PT SA MGR SP SP SC PT SC SP AM Accessories Town West Clearance Town West Specialty Town West Clearance Town West ReplacementTown parts West Accessories Town West Specialty Town East Specialty Town East Accessories Town East Tools & ShopTown East Fluids Town East ReplacementTown parts East PerformanceTown East PerformanceTown East Specialty Town East PerformanceTown East Accessories Town East PerformanceTown East ReplacementTown parts East Accessories Town East Tools & ShopTown East Clearance Town East ReplacementTown parts East ReplacementTown parts East Accessories Town East Tools & ShopTown East 1766 0 0 234.45 0 2225 3500 10065.23 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 10 0 0 6.5 0 8 7 7 4.5 4 5 3 3 0 3 3 0 4 4 6.5 4 5 4 3 0 9 Quote*Hrs-Worked Commission Rate Max-Sales-for-commission Step-Calc-Commission Nested Calc Commission Gross Pay Days Worked Quota Met Associate SalesCode Anderson AM Brick PT Blake SA Boles SA Bourque AM Craddock PT Crane SC Crouse SP Deyoe PT Duarte SC Dubben PT Duck SA Student MGR Film SP Freeman SP Gauger PT Harp SC Hauch PT Henning SP Hornback AM Huang PT Hughes SC Hulsman SP Jwang AM Ketty PT Lax SP Len SP Lessert SA Mall SC Mazza AM McMath PT Monac SP Montague SP Nigel SA Pike SA Plumber PT Pomales SP Pomura SC Porterfield SP Reyes AM Rodman PT Roselius SA Ruaz SA SchoemannSA Stanton SP Stephens PT Category Store Sales Hours Worked Base Pay Hourly Quota Quote*Hrs-Worked Commission Rate Specialty Town West 2725.25 6 Specialty Town West 0 0 AccessoriesTown West 1318.97 6 Tools & Shop Town West 943.17 6 Fluids Town West 686.57 7 Replacement Town parts West 4502.33 4 Performance Town West 0 0 Performance Town West 649.27 8 Specialty Town West 0 0 Performance Town West 0 0 AccessoriesTown West 556 4 Performance Town West 2798.88 5 Replacement Town parts West 4925.96 8 AccessoriesTown West 1900.54 9 Tools & Shop Town West 891.19 5 Clearance Town West 0 0 Replacement Town parts West 3228.87 4 Replacement Town parts West 1251.02 4 AccessoriesTown West 1788.34 7 Tools & Shop Town West 2654.44 8 Replacement Town parts West 0 0 AccessoriesTown West 375.52 4 Performance Town West 474.44 2 Clearance Town West 0 0 Performance Town West 650.45 4 Tools & Shop Town West 3789.21 8 Fluids Town West 133.98 8 Fluids Town West 4114.09 6 Tools & Shop Town West 1195.42 4 Replacement Town parts West 0 0 Tools & Shop Town West 1745.9 2 Specialty Town West 2822.5 6 Specialty Town West 657.56 8 Fluids Town West 1398.88 6 Specialty Town West 0 0 Clearance Town West 0 0 Fluids Town West 3519.79 4 Fluids Town West 3810.02 5 Replacement Town parts West 9768.68 6 Performance Town West 1047.66 5 Specialty Town West 0 0 Fluids Town West 0 0 Specialty Town West 1532.87 5 Clearance Town West 664.32 8 Clearance Town West 1486.22 5 Clearance Town West 0 0 Stone AM Vandrey SA Walker SA Watts SP Wilson SP Zeon SC Argentine AM Box PT Bing SA Bolyard SA Bourque AM Crad PT Cronk SC Course SP Keyoe SC Muarte SA Gibb PT Lucky SA Sims MGR Fiddes SP Beeman SP Auger SC Harpole PT Linch SC Ben SP Hornel AM Hall PT Huxly PT Hull SP Wang AM Ketakea PT Ladder SP Lenfestey SC Less SA Mallouf SC Mass AM Math PT Manny SP Montty SP North SA Picazo SA Plumbtree PT Pom SA Pommy PT Porter SC Ray AM Rodden SC AccessoriesTown West Clearance Town West Specialty Town West Clearance Town West Replacement Town parts West AccessoriesTown West Specialty Town East Specialty Town East AccessoriesTown East Tools & Shop Town East Fluids Town East Replacement Town parts East Performance Town East Performance Town East Specialty Town East Performance Town East AccessoriesTown East Performance Town East Replacement Town parts East AccessoriesTown East Tools & Shop Town East Clearance Town East Replacement Town parts East Replacement Town parts East AccessoriesTown East Tools & Shop Town East Replacement Town parts East AccessoriesTown East Performance Town East Clearance Town East Performance Town East Tools & Shop Town East Fluids Town East Fluids Town East Tools & Shop Town East Replacement Town parts East Tools & Shop Town East Specialty Town East Specialty Town East Fluids Town East Specialty Town East Clearance Town East Fluids Town East Fluids Town East Replacement Town parts East Performance Town East Specialty Town East 0 2719.75 1994.48 2127.32 0 0 1725.25 0 1318.97 943.17 686.57 4502.33 0 649.27 0 0 556 1798.88 4925.96 1900.54 891.19 0 3228.87 1251.02 1788.34 2654.44 0 375.52 474.44 0 350.45 3789.21 133.98 4114.09 1195.42 0 1745.9 2822.5 657.56 1398.88 0 0 3519.79 2810.02 6768.68 1047.66 0 0 6 8 8 2 0 5 0 5 5 6 3.5 0 7 0 0 3.5 6 7 8 4 0 3 3 6 7 0 3 2 0 4 8 7 6 3 0 2 6 8 5 0 0 4 4 6 3 0 Rose Rual Schmidt Stanly Steph Stonebull Vandyke Walk Water Wilow Yule TOTAL Avg Min Max PT SA SA SP PT AM SA SA SA SP SC Fluids Town East Specialty Town East Clearance Town East Clearance Town East Clearance Town East AccessoriesTown East Clearance Town East Specialty Town East Clearance Town East Replacement Town parts East AccessoriesTown East 0 1532.87 664.32 1486.22 0 0 2719.75 1994.48 2127.32 0 0 0 5 7 5 0 0 6 7 6 2 0 Max-Sales-for-commission Step-Calc-Commission Nested CalcGross Commission Pay Days Worked Quota Met Associate SalesCode Anderson AM Brick PT Blake SA Boles SA Bourque AM Craddock PT Crane SC Crouse SP Deyoe PT Duarte SC Dubben PT Duck SA Student MGR Film SP Freeman SP Gauger PT Harp SC Hauch PT Henning SP Hornback AM Huang PT Hughes SC Hulsman SP Jwang AM Ketty PT Lax SP Len SP Lessert SA Mall SC Mazza AM McMath PT Monac SP Montague SP Nigel SA Pike SA Plumber PT Pomales SP Pomura SC Porterfield SP Reyes AM Rodman PT Roselius SA Ruaz SA SchoemannSA Stanton SP Stephens PT Category Store Sales Hours Worked Base Pay Hourly Quota Quote*Hrs-Worked Commission Rate Specialty Town West 2927.74 8 Specialty Town West 145.02 2 AccessoriesTown West 1674.25 8 Tools & Shop Town West 718.63 6 Fluids Town West 1501.8 8 Replacement Town parts West 5600 4 Performance Town West 0 0 Performance Town West 1565.72 6 Specialty Town West 840.89 5 Performance Town West 0 0 AccessoriesTown West 2489.42 8 Performance Town West 0 0 Replacement Town parts West 0 0 AccessoriesTown West 1349.77 8 Tools & Shop Town West 784.67 4 Clearance Town West 1208.96 6 Replacement Town parts West 5414.32 8 Replacement Town parts West 10031.4 2 AccessoriesTown West 1800.36 8 Tools & Shop Town West 1631.42 8 Replacement Town parts West 2500 4 AccessoriesTown West 888.98 4 Performance Town West 2994.38 6 Clearance Town West 3565.69 8 Performance Town West 0 0 Tools & Shop Town West 2440.4 8 Fluids Town West 0 2 Fluids Town West 1549.63 8 Tools & Shop Town West 1296.12 4 Replacement Town parts West 13354.9 5 Tools & Shop Town West 393.54 4 Specialty Town West 2221.51 8 Specialty Town West 367.89 2 Fluids Town West 861.81 5 Specialty Town West 0 0 Clearance Town West 0 0 Fluids Town West 1564.52 8 Fluids Town West 0 0 Replacement Town parts West 9999.29 8 Performance Town West 1117.46 8 Specialty Town West 199.91 2 Fluids Town West 597.49 4 Specialty Town West 3593.96 8 Clearance Town West 3385.26 10 Clearance Town West 4864.47 8 Clearance Town West 0 0 Stone AM Vandrey SA Walker SA Watts SP Wilson SP Zeon SC Argentine AM Box PT Bing SA Bolyard SA Bourque AM Crad PT Cronk SC Course SP Keyoe SC Muarte SA Gibb PT Lucky SA Sims MGR Fiddes SP Beeman SP Auger SC Harpole PT Linch SC Ben SP Hornel AM Hall PT Huxly PT Hull SP Wang AM Ketakea PT Ladder SP Lenfestey SC Less SA Mallouf SC Mass AM Math PT Manny SP Montty SP North SA Picazo SA Plumbtree PT Pom SA Pommy PT Porter SC Ray AM Rodden SC AccessoriesTown West 490.64 Clearance Town West 3389.92 Specialty Town West 2080.44 Clearance Town West 1967.8 Replacement Town parts West 456.98 AccessoriesTown West 0 Specialty Town East 2900 Specialty Town East 145.02 AccessoriesTown East 1700 Tools & Shop Town East 718.63 Fluids Town East 1300 Replacement Town parts East 4500 Performance Town East 0 Performance Town East 1500 Specialty Town East 650 Performance Town East 0 AccessoriesTown East 2300 Performance Town East 0 Replacement Town parts East 0 AccessoriesTown East 1300 Tools & Shop Town East 768 Clearance Town East 1200 Replacement Town parts East 5499 Replacement Town parts East 9999 AccessoriesTown East 600 Tools & Shop Town East 1500 Replacement Town parts East 0 AccessoriesTown East 777 Performance Town East 2880 Clearance Town East 3300 Performance Town East 0 Tools & Shop Town East 2500 Fluids Town East 0 Fluids Town East 1600 Tools & Shop Town East 1300 Replacement Town parts East 14000 Tools & Shop Town East 458 Specialty Town East 2234 Specialty Town East 367 Fluids Town East 900 Specialty Town East 0 Clearance Town East 0 Fluids Town East 1600 Fluids Town East 0 Replacement Town parts East 9999.29 Performance Town East 1200 Specialty Town East 200 4 8 8 7 2 0 8 2 8 5 8 4 0 6 5 0 7 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 Rose Rual Schmidt Stanly Steph Stonebull Vandyke Walk Water Wilow Yule Total Average Minimum Maximum PT SA SA SP PT AM SA SA SA SP SC Fluids Town East Specialty Town East Clearance Town East Clearance Town East Clearance Town East AccessoriesTown East Clearance Town East Specialty Town East Clearance Town East Replacement Town parts East AccessoriesTown East 600 4500 2400 4900 0 490.64 3200 2200 1578 540 0 4 8 10 8 0 4 8 8 8 2 0 Max-Sales-for-commission Step-Calc-Commission Nested CalcGross Commission Pay Days Worked Quota Met Associate SalesCode Anderson AM Brick PT Blake SA Boles SA Bourque AM Craddock PT Crane SC Crouse SP Deyoe PT Duarte SC Dubben PT Duck SA Student MGR Film SP Freeman SP Gauger PT Harp SC Hauch PT Henning SP Hornback AM Huang PT Hughes SC Hulsman SP Jwang AM Ketty PT Lax SP Len SP Lessert SA Mall SC Mazza AM McMath PT Monac SP Montague SP Nigel SA Pike SA Plumber PT Pomales SP Pomura SC Porterfield SP Reyes AM Rodman PT Roselius SA Ruaz SA SchoemannSA Stanton SP Stephens PT Category Store Sales Hours Worked Base Pay Hourly Quota Quote*Hrs-Worked Commission Rate Specialty Town West 0 0 Specialty Town West 791.85 2 AccessoriesTown West 0 0 Tools & Shop Town West 0 0 Fluids Town West 1866.99 7 Replacement Town parts West 369.87 4 Performance Town West 4369.22 8 Performance Town West 0 0 Specialty Town West 0 0 Performance Town West 3865.87 8 AccessoriesTown West 2336.66 5 Performance Town West 1522.64 5 Replacement Town parts West 7726.69 6 AccessoriesTown West 0 0 Tools & Shop Town West 1846.25 8 Clearance Town West 0 0 Replacement Town parts West 27746.32 8 Replacement Town parts West 12324.11 6 AccessoriesTown West 0 0 Tools & Shop Town West 0 0 Replacement Town parts West 0 0 AccessoriesTown West 0 0 Performance Town West 2693.21 8 Clearance Town West 2461.87 4 Performance Town West 150 4 Tools & Shop Town West 0 0 Fluids Town West 263.23 6 Fluids Town West 2113.09 5 Tools & Shop Town West 2275.95 4 Replacement Town parts West 8632.72 8 Tools & Shop Town West 1228.73 4 Specialty Town West 3492.55 8 Specialty Town West 986.25 3 Fluids Town West 1080.15 8 Specialty Town West 999.36 8 Clearance Town West 1313.6 7 Fluids Town West 1590.69 8 Fluids Town West 0 0 Replacement Town parts West 0 0 Performance Town West 0 0 Specialty Town West 790.53 2 Fluids Town West 3494.11 8 Specialty Town West 0 0 Clearance Town West 456.36 8 Clearance Town West 2506.07 4 Clearance Town West 3870.88 7 Stone AM Vandrey SA Walker SA Watts SP Wilson SP Zeon SC Argentine AM Box PT Bing SA Bolyard SA Bourque AM Crad PT Cronk SC Course SP Keyoe SC Muarte SA Gibb PT Lucky SA Sims MGR Fiddes SP Beeman SP Auger SC Harpole PT Linch SC Ben SP Hornel AM Hall PT Huxly PT Hull SP Wang AM Ketakea PT Ladder SP Lenfestey SC Less SA Mallouf SC Mass AM Math PT Manny SP Montty SP North SA Picazo SA Plumbtree PT Pom SA Pommy PT Porter SC Ray AM Rodden SC AccessoriesTown West 1768.87 Clearance Town West 1698.97 Specialty Town West 2889.7 Clearance Town West 1352.79 Replacement Town parts West 0 AccessoriesTown West 2699.63 Specialty Town East 0 Specialty Town East 791.85 AccessoriesTown East 0 Tools & Shop Town East 0 Fluids Town East 1866.99 Replacement Town parts East 369.87 Performance Town East 4369.22 Performance Town East 0 Specialty Town East 0 Performance Town East 3865.87 AccessoriesTown East 2336.66 Performance Town East 1522.64 Replacement Town parts East 7726.69 AccessoriesTown East 0 Tools & Shop Town East 1846.25 Clearance Town East 0 Replacement Town parts East 27746.32 Replacement Town parts East 12324.11 AccessoriesTown East 0 Tools & Shop Town East 0 Replacement Town parts East 0 AccessoriesTown East 0 Performance Town East 2693.21 Clearance Town East 2461.87 Performance Town East 150 Tools & Shop Town East 1300 Fluids Town East 263.23 Fluids Town East 2113.09 Tools & Shop Town East 2275.95 Replacement Town parts East 8632.72 Tools & Shop Town East 1228.73 Specialty Town East 4492.55 Specialty Town East 986.25 Fluids Town East 1080.15 Specialty Town East 999.36 Clearance Town East 1313.6 Fluids Town East 1590.69 Fluids Town East 0 Replacement Town parts East 0 Performance Town East 0 Specialty Town East 790.53 8 8 8 5 0 8 0 2 0 0 7 4 8 0 0 8 5 5 6 0 8 0 8 6 0 0 0 0 8 4 4 5 6 5 4 7 4 8 3 8 8 7 6 0 0 0 2 Rose Rual Schmidt Stanly Steph Stonebull Vandyke Walk Water Wilow Yule Total Average Minimum Maximum PT SA SA SP PT AM SA SA SA SP SC Fluids Town East Specialty Town East Clearance Town East Clearance Town East Clearance Town East AccessoriesTown East Clearance Town East Specialty Town East Clearance Town East Replacement Town parts East AccessoriesTown East 4494.11 0 456.36 2506.07 3870.88 1768.87 1498.97 2889.7 1352.79 0 2699.63 8 0 8 4 7 8 8 7 5 0 8 Max-Sales-for-commission Step-Calc-Commission Nested CalcGross Commission Pay Days Worked Quota Met Associate SalesCode Anderson AM Brick PT Blake SA Boles SA Bourque AM Craddock PT Crane SC Crouse SP Deyoe PT Duarte SC Dubben PT Duck SA Student MGR Film SP Freeman SP Gauger PT Harp SC Hauch PT Henning SP Hornback AM Huang PT Hughes SC Hulsman SP Jwang AM Ketty PT Lax SP Len SP Lessert SA Mall SC Mazza AM McMath PT Monac SP Montague SP Nigel SA Pike SA Plumber PT Pomales SP Pomura SC Porterfield SP Reyes AM Rodman PT Roselius SA Ruaz SA SchoemannSA Stanton SP Stephens PT Category Store Sales Hours Worked Base Pay Hourly Quota Quote*Hrs-Worked Commission Rate Specialty Town West 0 0 Specialty Town West 1211.44 4 AccessoriesTown West 2604.92 8 Tools & Shop Town West 0 0 Fluids Town West 0 0 Replacement Town parts West 0 0 Performance Town West 0 0 Performance Town West 5667.64 12 Specialty Town West 0 0 Performance Town West 1254.76 4 AccessoriesTown West 0 0 Performance Town West 924.38 8 Replacement Town parts West 7857.44 8 AccessoriesTown West 778.26 8 Tools & Shop Town West 0 0 Clearance Town West 2506.25 4 Replacement Town parts West 0 0 Replacement Town parts West 25447.82 4 AccessoriesTown West 2214.27 8 Tools & Shop Town West 2470.54 8 Replacement Town parts West 54447.87 7 AccessoriesTown West 3600.23 6 Performance Town West 2261.34 4 Clearance Town West 1535.36 4 Performance Town West 0 0 Tools & Shop Town West 1546.31 4 Fluids Town West 4500.79 5 Fluids Town West 3684.97 7 Tools & Shop Town West 1438.21 4 Replacement Town parts West 4492.35 5 Tools & Shop Town West 1134.12 4 Specialty Town West 0 0 Specialty Town West 0 0 Fluids Town West 0 0 Specialty Town West 657.63 4 Clearance Town West 1694.59 8 Fluids Town West 1550.01 8 Fluids Town West 0 0 Replacement Town parts West 16693.99 8 Performance Town West 2134.47 8 Specialty Town West 1962.75 4 Fluids Town West 800.26 4 Specialty Town West 552.94 5 Clearance Town West 328.56 5 Clearance Town West 0 0 Clearance Town West 0 0 Stone AM Vandrey SA Walker SA Watts SP Wilson SP Zeon SC Argentine AM Box PT Bing SA Bolyard SA Bourque AM Crad PT Cronk SC Course SP Keyoe SC Muarte SA Gibb PT Lucky SA Sims MGR Fiddes SP Beeman SP Auger SC Harpole PT Linch SC Ben SP Hornel AM Hall PT Huxly PT Hull SP Wang AM Ketakea PT Ladder SP Lenfestey SC Less SA Mallouf SC Mass AM Math PT Manny SP Montty SP North SA Picazo SA Plumbtree PT Pom SA Pommy PT Porter SC Ray AM Rodden SC AccessoriesTown West 930.9 Clearance Town West 311.63 Specialty Town West 1905.72 Clearance Town West 0 Replacement Town parts West 0 AccessoriesTown West 0 Specialty Town East 0 Specialty Town East 1211.44 AccessoriesTown East 4604.92 Tools & Shop Town East 0 Fluids Town East 0 Replacement Town parts East 0 Performance Town East 0 Performance Town East 5667.64 Specialty Town East 0 Performance Town East 3254.76 AccessoriesTown East 1600 Performance Town East 924.38 Replacement Town parts East 7857.44 AccessoriesTown East 778.26 Tools & Shop Town East 0 Clearance Town East 2506.25 Replacement Town parts East 0 Replacement Town parts East 25447.82 AccessoriesTown East 2214.27 Tools & Shop Town East 2470.54 Replacement Town parts East 54447.87 AccessoriesTown East 3600.23 Performance Town East 5261.34 Clearance Town East 1535.36 Performance Town East 0 Tools & Shop Town East 1546.31 Fluids Town East 4500.79 Fluids Town East 3684.97 Tools & Shop Town East 1438.21 Replacement Town parts East 4492.35 Tools & Shop Town East 1134.12 Specialty Town East 0 Specialty Town East 0 Fluids Town East 0 Specialty Town East 657.63 Clearance Town East 1694.59 Fluids Town East 1550.01 Fluids Town East 0 Replacement Town parts East 16693.99 Performance Town East 2134.47 Specialty Town East 1300 8 4 6 0 0 0 0 4 8 0 0 0 0 12 0 4 5 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 Rose Rual Schmidt Stanly Steph Stonebull Vandyke Walk Water Wilow Yule Totals Averages Minimums Maximums PT SA SA SP PT AM SA SA SA SP SC Fluids Town East Specialty Town East Clearance Town East Clearance Town East Clearance Town East AccessoriesTown East Clearance Town East Specialty Town East Clearance Town East Replacement Town parts East AccessoriesTown East 800.26 552.94 328.56 0 0 930.9 311.63 1800 0 0 0 4 5 5 0 0 8 4 6 0 0 0 Max-Sales-for-commission Step-Calc-Commission Nested CalcGross Commission Pay Days Worked Quota Met Associate SalesCode Anderson AM Brick PT Blake SA Boles SA Bourque AM Craddock PT Crane SC Crouse SP Deyoe PT Duarte SC Dubben PT Duck SA Student MGR Film SP Freeman SP Gauger PT Harp SC Hauch PT Henning SP Hornback AM Huang PT Hughes SC Hulsman SP Jwang AM Ketty PT Lax SP Len SP Lessert SA Mall SC Mazza AM McMath PT Monac SP Montague SP Nigel SA Pike SA Plumber PT Pomales SP Pomura SC Porterfield SP Reyes AM Rodman PT Roselius SA Ruaz SA SchoemannSA Stanton SP Stephens PT Category Store Sales Hours Worked Base Pay Hourly Quota Quote*Hrs-Worked Commission Rate Specialty Town West 1120.32 8 Specialty Town West 0 0 AccessoriesTown West 508.72 8.5 Tools & Shop Town West 921.86 8 Fluids Town West 1698.2 12 Replacement Town parts West 17836.36 4 Performance Town West 0 0 Performance Town West 1324.25 6 Specialty Town West 0 0 Performance Town West 0 0 AccessoriesTown West 35.02 3 Performance Town West 2558.96 12 Replacement Town parts West 0 0 AccessoriesTown West 383.84 7.5 Tools & Shop Town West 1455.57 7 Clearance Town West 4000 4 Replacement Town parts West 0 0 Replacement Town parts West 969.52 8 AccessoriesTown West 1298.4 8 Tools & Shop Town West 1643.02 8 Replacement Town parts West 2969.97 8 AccessoriesTown West 1200 4 Performance Town West 945.39 8 Clearance Town West 991.07 8 Performance Town West 1987.25 3 Tools & Shop Town West 1886.95 4 Fluids Town West 1605.78 8 Fluids Town West 600 6 Tools & Shop Town West 1400.55 4 Replacement Town parts West 29704.21 10 Tools & Shop Town West 0 0 Specialty Town West 2215.55 8 Specialty Town West 1408.98 6 Fluids Town West 5896.94 10 Specialty Town West 256.48 4 Clearance Town West 1436.1 3 Fluids Town West 4478.31 5.5 Fluids Town West 5964.47 8 Replacement Town parts West 13060.67 8 Performance Town West 2499.15 7 Specialty Town West 0 0 Fluids Town West 0 0 Specialty Town West 2598.86 8 Clearance Town West 4508.98 7 Clearance Town West 4456.11 8 Clearance Town West 3633.11 11 Stone AM Vandrey SA Walker SA Watts SP Wilson SP Zeon SC Argentine AM Box PT Bing SA Bolyard SA Bourque AM Crad PT Cronk SC Course SP Keyoe SC Muarte SA Gibb PT Lucky SA Sims MGR Fiddes SP Beeman SP Auger SC Harpole PT Linch SC Ben SP Hornel AM Hall PT Huxly PT Hull SP Wang AM Ketakea PT Ladder SP Lenfestey SC Less SA Mallouf SC Mass AM Math PT Manny SP Montty SP North SA Picazo SA Plumbtree PT Pom SA Pommy PT Porter SC Ray AM Rodden SC AccessoriesTown West 3844.13 Clearance Town West 2781.36 Specialty Town West 0 Clearance Town West 4673.92 Replacement Town parts West 1508.88 AccessoriesTown West 0 Specialty Town East 1120.32 Specialty Town East 0 AccessoriesTown East 508.72 Tools & Shop Town East 921.86 Fluids Town East 1698.2 Replacement Town parts East 19836.36 Performance Town East 0 Performance Town East 1324.25 Specialty Town East 0 Performance Town East 0 AccessoriesTown East 35.02 Performance Town East 2558.96 Replacement Town parts East 0 AccessoriesTown East 383.84 Tools & Shop Town East 1455.57 Clearance Town East 3609.65 Replacement Town parts East 0 Replacement Town parts East 969.52 AccessoriesTown East 1298.4 Tools & Shop Town East 1643.02 Replacement Town parts East 2969.97 AccessoriesTown East 0 Performance Town East 945.39 Clearance Town East 991.07 Performance Town East 1987.25 Tools & Shop Town East 886.95 Fluids Town East 1605.78 Fluids Town East 569.44 Tools & Shop Town East 1400.55 Replacement Town parts East 29704.21 Tools & Shop Town East 0 Specialty Town East 2215.55 Specialty Town East 1408.98 Fluids Town East 5896.94 Specialty Town East 256.48 Clearance Town East 1436.1 Fluids Town East 4478.31 Fluids Town East 5964.47 Replacement Town parts East 13060.67 Performance Town East 2499.15 Specialty Town East 0 10 8 0 8 12 0 8 0 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 Rose Rual Schmidt Stanly Steph Stonebull Vandyke Walk Water Wilow Yule Total Average Minimum Maximum PT SA SC SP PT AM SA SA SA SP SC Fluids Town East Specialty Town East Clearance Town East Clearance Town East Clearance Town East AccessoriesTown East Clearance Town East Specialty Town East Clearance Town East Replacement Town parts East AccessoriesTown East 0 2598.86 3508.98 4456.11 3633.11 3844.13 2781.36 0 4673.92 1508.88 0 0 8 7 8 11 10 8 0 8 12 0 Max-Sales-for-commission Step-Calc-Commission Nested CalcGross Commission Pay Days Worked Quota Met ssociate SalesCode Anderson AM Brick PT Blake SA Boles SA Bourque AM Craddock PT Crane SC Crouse SP Deyoe PT Duarte SC Dubben PT Duck SA Student MGR Film SP Freeman SP Gauger PT Harp SC Hauch PT Henning SP Hornback AM Huang PT Hughes SC Hulsman SP Jwang AM Ketty PT Lax SP Len SP Lessert SA Mall SC Mazza AM McMath PT Monac SP Montague SP Nigel SA Pike SA Plumber PT Pomales SP Pomura SC Porterfield SP Reyes AM Rodman PT Roselius SA Ruaz SA SchoemannSA Stanton SP Stephens PT Category Store Sales Hours Worked Base Pay Hourly Quota Quote*Hrs-Worked Commission Rate Specialty Town West 2366.77 8 Specialty Town West 759.32 4 AccessoriesTown West 1459.98 7 Tools & Shop Town West 3422.17 8 Fluids Town West 0 0 Replacement Town parts West 0 0 Performance Town West 1455.09 8 Performance Town West 3241.17 8 Specialty Town West 1408.87 4 Performance Town West 1349.96 4 AccessoriesTown West 0 0 Performance Town West 1875.93 5 Replacement Town parts West 13000 5 AccessoriesTown West 0 0 Tools & Shop Town West 2488.39 8 Clearance Town West 1568.63 4 Replacement Town parts West 0 0 Replacement Town parts West 0 0 AccessoriesTown West 1310.22 9 Tools & Shop Town West 0 0 Replacement Town parts West 2566.47 5 AccessoriesTown West 2598.32 4 Performance Town West 1588.87 6 Clearance Town West 2201.07 4 Performance Town West 985.39 5 Tools & Shop Town West 1189.92 8 Fluids Town West 0 0 Fluids Town West 620.45 3 Tools & Shop Town West 0 0 Replacement Town parts West 0 0 Tools & Shop Town West 0 0 Specialty Town West 4711.672 10 Specialty Town West 0 0 Fluids Town West 2917.79 10 Specialty Town West 987.26 5 Clearance Town West 0 0 Fluids Town West 0 0 Fluids Town West 0 0 Replacement Town parts West 2589.33 8 Performance Town West 0 0 Specialty Town West 1661.35 4 Fluids Town West 0 0 Specialty Town West 394.48 2 Clearance Town West 982.75 2 Clearance Town West 1934.88 8 Clearance Town West 0 0 Stone AM Vandrey SA Walker SA Watts SP Wilson SP Zeon SC Argentine AM Box PT Bing SA Bolyard SA Bourque AM Crad PT Cronk SC Course SP Keyoe SC Muarte SA Gibb PT Lucky SA Sims MGR Fiddes SP Beeman SP Auger SC Harpole PT Linch SC Ben SP Hornel AM Hall PT Huxly PT Hull SP Wang AM Ketakea PT Ladder SP Lenfestey SC Less SA Mallouf SC Mass AM Math PT Manny SP Montty SP North SA Picazo SA Plumbtree PT Pom SA Pommy PT Porter SC Ray AM Rodden SC AccessoriesTown West Clearance Town West Specialty Town West Clearance Town West Replacement Town parts West AccessoriesTown West Specialty Town East Specialty Town East AccessoriesTown East Tools & Shop Town East Fluids Town East Replacement Town parts East Performance Town East Performance Town East Specialty Town East Performance Town East AccessoriesTown East Performance Town East Replacement Town parts East AccessoriesTown East Tools & Shop Town East Clearance Town East Replacement Town parts East Replacement Town parts East AccessoriesTown East Tools & Shop Town East Replacement Town parts East AccessoriesTown East Performance Town East Clearance Town East Performance Town East Tools & Shop Town East Fluids Town East Fluids Town East Tools & Shop Town East Replacement Town parts East Tools & Shop Town East Specialty Town East Specialty Town East Fluids Town East Specialty Town East Clearance Town East Fluids Town East Fluids Town East Replacement Town parts East Performance Town East Specialty Town East 0 1293.44 2309.66 267.41 698.14 780.25 2366.77 759.32 1459.98 3422.17 0 0 1455.09 3241.17 1408.87 1349.96 0 1875.93 24000 0 2488.39 1568.63 0 0 1310.22 0 2566.47 2598.32 1588.87 2201.07 985.39 1189.92 0 620.45 0 1100 0 4600 0 2917.79 987.26 0 0 0 2589.33 0 1661.35 0 6 8 4.5 5 4 8 4 7 8 0 0 8 8 4 4 0 5 7 0 8 4 0 0 9 0 5 4 6 4 5 8 0 3 0 6 0 9 0 10 6 0 0 0 8 0 4 Rose Rual Schmidt Stanly Steph Stonebull Vandyke Walk Water Wilow Yule Total Average Minimum Maximum PT SA SA SP PT AM SA SA SA SP SC Fluids Town East Specialty Town East Clearance Town East Clearance Town East Clearance Town East AccessoriesTown East Clearance Town East Specialty Town East Clearance Town East Replacement Town parts East AccessoriesTown East 0 394.48 1100 1934.88 0 0 1293.44 2309.66 267.41 698.14 980.25 0 2 3 8 0 0 6 8 4.5 5 4 Max-Sales-for-commission Step-Calc-Commission Nested CalcGross Commission Pay Days Worked Quota Met Sales Code MGR AM PT SP SA SC Sales Titles Manager Assistance Manager sales Assistance sales partner Sales associate Sales Consultant Hourl Wage Hourly Quota Commision Rate $25.50 $300.00 5.25% $22.50 $240.00 4.20% $11.50 $120.00 2.63% $16.00 $120.00 2.63% $13.50 $180.00 3.94% $18.00 $210.00 3.15%
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

Sorry for late response. I'm through with the work. Uploading in a moment.
Attached.

1
Sales Code
MGR
AM
PT
SP
SA
SC

2
Sales Titles
Manager
Assistance Manager
sales Assistance
sales partner
Sales associate
Sales Consultant

3
4
5
Hourl Wage
Hourly Quota
Commision Rate
$25.50
$300.00
5.25%
$22.50
$240.00
4.20%
$11.50
$120.00
2.63%
$16.00
$120.00
2.63%
$13.50
$180.00
3.94%
$18.00
$210.00
3.15%

Sales Code
MGR
AM
PT
SP
SA
SC

Sales Titles
Manager
Assistance Manager
sales Assistance
sales partner
Sales associate
Sales Consultant

Hourl Wage
25.5
22.5
11.5
16
13.5
18

Hourly Quota
Commision Rate
$375.00
7.88%
$300.00
6.30%
$150.00
3.95%
$150.00
3.95%
$225.00
5.91%
$262.50
4.73%

Associate
Macro
Brick
Blake
Boles
Bourque
Craddock
Crane
Crouse
Deyoe
Duarte
Dubben
Duck
Student
Film
Freeman
Gauger
Harp
Hauch
Henning
Hornback
Huang
Hughes
Hulsman
Jwang
Ketty
Lax
Len
Lessert
Mall
Mazza
McMath
Monac
Montague
Nigel
Pike
Plumber
Pomales
Pomura
Porterfield
Reyes
Rodman
Roselius

Sales
Code
AM
PT
SA
SA
AM
PT
SC
SP
PT
SC
PT
SA
MGR
SP
SP
PT
SC
PT
SP
AM
PT
SC
SP
AM
PT
SP
SP
SA
SC
AM
PT
SP
SP
SA
SA
PT
SP
SC
SP
AM
PT
SA

Category
Specialty
Specialty
Accessories
Tools & Shop
Fluids
Replacement parts
Performance
Performance
Specialty
Performance
Accessories
Performance
Replacement parts
Accessories
Tools & Shop
Clearance
Replacement parts
Replacement parts
Accessories
Tools & Shop
Replacement parts
Accessories
Performance
Clearance
Performance
Tools & Shop
Fluids
Fluids
Tools & Shop
Replacement parts
Tools & Shop
Specialty
Specialty
Fluids
Specialty
Clearance
Fluids
Fluids
Replacement parts
Performance
Specialty
Fluids

Store
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West

Sales
$ 4,500.00
$ 10,065.23
$
456.76
$
450.98
$
650.75
$
250.78
$ 1,500.00
$
$
500.00
$ 1,502.98
$
$
873.08
$ 4,500.67
$
356.26
$ 1,500.25
$
250.00
$ 1,469.78
$ 7,502.03
$
$
890.47
$
$ 1,000.00
$ 1,100.00
$ 1,202.02
$
199.99
$
802.46
$
50.00
$ 1,502.96
$
$ 2,500.00
$
$ 2,200.00
$
$
196.89
$
$
250.75
$
850.63
$
251.36
$
$ 3,399.00
$ 1,546.78
$ 1,908.00

Hours
Worked
8
8
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
5
0
1
0
2
6.5
3
0
12
8
8

Base Pay
$ 180.00
$ 92.00
$ 33.75
$ 40.50
$ 135.00
$ 46.00
$ 72.00
$
$ 46.00
$ 72.00
$
$ 67.50
$ 127.50
$ 120.00
$ 80.00
$ 46.00
$ 90.00
$ 23.00
$
$ 180.00
$
$ 90.00
$ 96.00
$ 270.00
$ 46.00
$ 128.00
$ 128.00
$ 54.00
$
$ 270.00
$
$ 80.00
$
$ 13.50
$
$ 23.00
$ 104.00
$ 54.00
$
$ 270.00
$ 92.00
$ 108.00

Ruaz
Schoemann
Stanton
Stephens
Stone
Vandrey
Walker
Watts
Wilson
Zeon
Argentine
Box
Bing
Bolyard
Bourque
Crad
Cronk
Course
Keyoe
Muarte
Gibb
Lucky
Sims
Fiddes
Beeman
Auger
Harpole
Linch
Ben
Hornel
Hall
Huxly
Hull
Wang
Ketakea
Ladder
Lenfestey
Less
Mallouf
Mass
Math
Manny
Montty
North
Picazo
Plumbtree
Pom

SA
SA
SP
PT
AM
SA
SA
SP
SP
SC
AM
PT
SA
SA
AM
PT
SC
SP
SC
SA
PT
SA
MGR
SP
SP
SC
PT
SC
SP
AM
PT
PT
SP
AM
PT
SP
SC
SA
SC
AM
PT
SP
SP
SA
SA
PT
SA

Specialty
Clearance
Clearance
Clearance
Accessories
Clearance
Specialty
Clearance
Replacement parts
Accessories
Specialty
Specialty
Accessories
Tools & Shop
Fluids
Replacement parts
Performance
Performance
Specialty
Performance
Accessories
Performance
Replacement parts
Accessories
Tools & Shop
Clearance
Replacement parts
Replacement parts
Accessories
Tools & Shop
Replacement parts
Accessories
Performance
Clearance
Performance
Tools & Shop
Fluids
Fluids
Tools & Shop
Replacement parts
Tools & Shop
Specialty
Specialty
Fluids
Specialty
Clearance
Fluids

Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town West
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East

$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$

2,159.69
821.36
345.96
1,766.00
234.45
2,225.00
3,500.00
10,065.23
456.76
450.98
650.75
250.78
1,500.00
500.00
1,402.98
873.08
4,500.67
356.26
1,500.25
250.00
1,469.78
7,502.03
890.47
-

12
0
7
2
10
0
0
6.5
0
8
7
7
4.5
4
5
3
3
0
3
3
0
4
4
6.5
4
5
4
3
0
9
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$

162.00
112.00
23.00
225.00
104.00
144.00
157.50
80.50
60.75
54.00
112.50
34.50
54.00
54.00
40.50
54.00
102.00
104.00
64.00
90.00
46.00
54.00
202.50
-

Pommy
Porter
Ray
Rodden
Rose
Rual
Schmidt
Stanly
Steph
Stonebull
Vandyke
Walk
Water
Wilow
Yule
Total
Average
Minimum
Maximum

PT
SC
AM
SC
PT
SA
SA
SP
PT
AM
SA
SA
SA
SP
SC

Fluids
Replacement parts
Performance
Specialty
Fluids
Specialty
Clearance
Clearance
Clearance
Accessories
Clearance
Specialty
Clearance
Replacement parts
Accessories

Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East
Town East

$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$

99,853.34
99,853.34
99,853.34
99,853.34

0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
314.00
314.00
314.00
314.00

$
$
$
$
$
$
$
$
$
$
$
$
$
$
$

-

$ 5,412.50
$ 5,412.50
$ 5,412.50
$ 5,412.50

Hourly
Quota
240
120
180
180
240
120
210
120
120
210
120
180
300
120
120
120
210
120
120
240
120
210
120
240
120
120
120
180
210
240
120
120
120
180
180
120
120
210
120
240
120
180

Quote*HrsWorked
1920
960
450
540
1440
480
840
0
480
840
0
900
1500
900
600
480
1050
240
0
1920
0
1050
720
2880
480
960
960
720
0
2880
0
600
0
180
0
240
780
630
0
2880
960
1440

Commission Max-Sales-forStep-CalcRate
commission
Commission
$
0.0420
2580.00
$
0.0263
9105.23
$
0.0394
6.76
$
0.0394
-89.02
$
0.0420
-789.25
$
0.0263
-229.22
$
0.0315
660.00
$
0.0263
0.00
$
0.0263
20.00
$
0.0315
662.98
$
0.0263
0.00
$
0.0394
-26.92
$
0.0525
3000.67
$
0.0263
-543.74
$
0.0263
900.25
$
0.0263
-230.00
$
0.0315
419.78
$
0.0263
7262.03
$
0.0263
0.00
$
0.0420
-1029.53
$
0.0263
0.00
$
0.0315
-50.00
$
0.0263
380.00
$
0.0420
-1677.98
$
0.0263
-280.01
$
0.0263
-157.54
$
0.0263
-910.00
$
0.0394
782.96
$
0.0315
0.00
$
0.0420
-380.00
$
0.0263
0.00
$
0.0263
1600.00
$
0.0263
0.00
$
0.0394
16.89
$
0.0394
0.00
$
0.0263
10.75
$
0.0263
70.63
$
0.0315
-378.64
$
0.0263
0.00
$
0.0420
519.00
$
0.0263
586.78
$
0.0394
468.00

108.36
239.47
0.27
0.00
0.00
0.00
20.79
0.00
0.53
20.88
0.00
0.00
157.54
0.00
23.68
0.00
13.22
190.99
0.00
0.00
0.00
0.00
9.99
0.00
0.00
0.00
0.00
30.85
0.00
0.00
0.00
42.08
0.00
0.67
0.00
0.28
1.86
0.00
0.00
21.80
15.43
18.44

Nested Calc
Commission
$
108.36
$
239.47
$
0.27
$
$
$
$
20.79
$
$
0.53
$
20.88
$
$
$
157.54
$
$
23.68
$
$
13.22
$
190.99
$
$
$
$
$
9.99
$
$
$
$
$
30.85
$
$
$
$
42.08
$
$
0.67
$
$
0.28
$
1.86
$
$
$
21.80
$
15.43
$
18.44

180
180
120
120
240
180
180
120
120
210
240
120
180
180
240
120
210
120
210
180
120
180
300
120
120
210
120
210
120
240
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

2160
0
840
240
2400
0
0
780
0
1680
1680
840
810
720
1200
360
630
0
630
540
0
720
1200
780
480
1050
480
630
0
2160
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$

0.0394
0.0394
0.0263
0.0263
0.0420
0.0394
0.0394
0.0263
0.0263
0.0315
0.0420
0.0263
0.0394
0.0394
0.0420
0.0263
0.0315
0.0263
0.0315
0.0394
0.0263
0.0394
0.0525
0.0263
0.0263
0.0315
0.0263
0.0315
0.0263
0.0420
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

-0.31
0.00
-18.64
105.96
-634.00
0.00
0.00
-545.55
0.00
545.00
1820.00
9225.23
-353.24
-269.02
-549.25
-109.22
870.00
0.00
-130.00
862.98
0.00
153.08
3300.67
-423.74
1020.25
-800.00
989.78
6872.03
0.00
-1269.53
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

0.00
0.00
0.00
2.79
0.00
0.00
0.00
0.00
0.00
17.17
76.44
242.62
0.00
0.00
0.00
0.00
27.41
0.00
0.00
34.00
0.00
6.03
173.29
0.00
26.83
0.00
26.03
216.47
0.00
0.00
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$

2.79
17.17
76.44
242.62
27.41
34.00
6.03
173.29
26.83
26.03
216.47
-

0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
12,090.00
12,090.00
12,090.00
12,090.00

0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
56,910.00
56,910.00
56,910.00
56,910.00

0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
2.36
2.36
2.36
2.36

0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
42,943.34
42,943.34
42,943.34
42,943.34

0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
1,766.19
1,766.19
1,766.19
1,766.19

$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$

1,766.19
1,766.19
1,766.19
1,766.19

Wages to Sales
Ratio
6.41%
3.29%
7.45%
8.98%
20.75%
18.34%
6.19%
9.31%
6.18%
7.73%
6.33%
33.68%
6.91%
18.40%
7.02%
2.85%
20.21%
9.00%
9.64%
22.46%
23.00%
15.95%
256.00%
5.65%
10.80%
5.55%
7.19%
9.29%
12.44%
21.48%
8.58%
6.95%
6.63%

Gross Pay
$
288.36
$
331.47
$
34.02
$
40.50
$
135.00
$
46.00
$
92.79
$
$
46.53
$
92.88
$
$
67.50
$
285.04
$
120.00
$
103.68
$
46.00
$
103.22
$
213.99
$
$
180.00
$
$
90.00
$
105.99
$
270.00
$
46.00
$
128.00
$
128.00
$
84.85
$
$
270.00
$
$
122.08
$
$
14.17
$
$
23.28
$
105.86
$
54.00
$
$
291.80
$
107.43
$
126.44

Days
Worked

Quota
Met
1
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
1
0
1
0
1
1
1
0
1
1
1

1
1
1
0
0
0
1
0
1
1
0
0
1
0
1
0
1
1
0
0
0
0
1
0
0
0
0
1
0
0
0
1
0
1
0
1
1
0
0
1
1
1

Proposed Proposed
Proposed
Hourly
Commission
Nested Calc
Quota
Rate
Commission
$ 300.00
0.0630
132.30
$ 150.00
0.0395
349.73
$ 225.00
0.0591
$ 225.00
0.0591
$ 300.00
0.0630
$ 150.00
0.0395
$ 262.50
0.0473
21.26
$ 150.00
0.0395
$ 150.00
0.0395
$ 262.50
0.0473
21.40
$ 150.00
0.0395
$ 225.00
0.0591
$ 375.00
0.0788
206.77
$ 150.00
0.0395
$ 150.00
0.0395
29.60
$ 150.00
0.0395
$ 262.50
0.0473
7.43
$ 150.00
0.0395
284.12
$ 150.00
0.0395
$ 300.00
0.0630
$ 150.00
0.0395
$ 262.50
0.0473
$ 150.00
0.0395
7.89
$ 300.00
0.0630
$ 150.00
0.0395
$ 150.00
0.0395
$ 150.00
0.0395
$ 225.00
0.0591
35.63
$ 262.50
0.0473
$ 300.00
0.0630
$ 150.00
0.0395
$ 150.00
0.0395
57.20
$ 150.00
0.0395
$ 225.00
0.0591
$ 225.00
0.0591
$ 150.00
0.0395
$ 150.00
0.0395
$ 262.50
0.0473
$ 150.00
0.0395
$ 300.00
0.0630
$ 150.00
0.0395
13.68
$ 225.00
0.0591
6.38

7.50% $
$
13.64% $
7.45% $
12.74% $
$
$
44.36% $
$
7.24% $
6.68% $
3.21% $
13.30% $
11.97% $
17.29% $
13.76% $
5.43% $
$
10.80% $
5.31% $
$
6.88% $
6.12% $
29.19% $
6.05% $
36.00% $
4.90% $
3.61% $
$
22.74% $
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$

162.00
112.00
25.79
225.00
104.00
161.17
233.94
323.12
60.75
54.00
112.50
34.50
81.41
54.00
74.50
60.03
275.29
104.00
90.83
90.00
72.03
270.47
202.50
-

1
0
1
1
1
0
0
1
0
1
1
1
1
1
1
1
1
0
1
1
0
1
1
1
1
1
1
1
0
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

0
0
0
1
0
0
0
0
0
1
1
1
0
0
0
0
1
0
0
1
0
1
1
0
1
0
1
1
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$

225.00
225.00
150.00
150.00
300.00
225.00
225.00
150.00
150.00
262.50
300.00
150.00
225.00
225.00
300.00
150.00
262.50
150.00
262.50
225.00
150.00
225.00
375.00
150.00
150.00
262.50
150.00
262.50
150.00
300.00
150.00
150.00
150.00
300.00
150.00
150.00
262.50
225.00
262.50
300.00
150.00
150.00
150.00
225.00
225.00
150.00
225.00

0.0591
0.0591
0.0395
0.0395
0.0630
0.0591
0.0591
0.0395
0.0395
0.0473
0.0630
0.0395
0.0591
0.0591
0.0630
0.0395
0.0473
0.0395
0.0473
0.0591
0.0395
0.0591
0.0788
0.0395
0.0395
0.0473
0.0395
0.0473
0.0395
0.0630
0.0395
0.0395
0.0395
0.0630
0.0395
0.0395
0.0473
0.0591
0.0473
0.0630
0.0395
0.0395
0.0395
0.0591
0.0591
0.0395
0.0591

1.81
5.91
88.20
355.65
33.67
43.02
236.30
35.51
34.31
317.26
-

$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$

7,178.69
7,178.69
7,178.69
7,178.69

0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

0
0
0
0
0
0
0
0
0
0
0
0
0
0
0

$
$
$
$
$
$
$
$
$
$
$
$
$
$
$

150.00
262.50
300.00
262.50
150.00
225.00
225.00
150.00
150.00
300.00
225.00
225.00
225.00
150.00
262.50

0.0395
0.0473
0.0630
0.0473
0.0395
0.0591
0.0591
0.0395
0.0395
0.0630
0.0591
0.0591
0.0591
0.0395
0.0473

-

Differences
Between
Commissions
23.94
110.27
(0.27)
0.47
(0.53)
0.52
49.24
5.92
(5.79)
93.13
(2.10)
4.79
15.12
(0.67)
(0.28)
(1.86)
(21.80)
(1.75)
(12.06)

(0.97)
(11.26)
11.76
113.03
6.26
9.02
(6.03)
63.02
8.68
8.28
100.79
-

-

Associate
Macro
Brick
Blake
Boles
Bourque
Craddock
Crane
Crouse
Deyoe
Duarte
Dubben
Duck
Student
Film
Freeman
Gauger
Harp
Hauch
Henning
Hornback
Huang
Hughes
Hulsman
Jwang
Ketty
Lax
Len
Lessert
Mall
Mazza
McMath
Monac
Montague
Nigel
Pike
Plumber
Pomales
Pomura
Porterfield
Reyes
Rodman
Roselius

Sales
Code
AM
PT
SA
SA
AM
PT
SC
SP
PT
SC
PT
SA
MGR
SP
SP
PT
SC
PT
SP
AM
PT
SC
SP
AM
PT
SP
SP
SA
SC
AM
PT
SP
SP
SA
SA
PT
SP
SC
SP
AM
PT
SA

Category Store
Sales
Specialty Town West $ 2,725.25
Specialty Town West $
AccessoriesTown West $ 1,318.97
Tools & Shop
Town West $
943.17
Fluids
Town West $
686.57
Replacement
Town
parts
West $ 4,502.33
Performance
Town West $
Performance
Town West $
649.27
Specialty Town West $
Performance
Town West $
AccessoriesTown West $
556.00
Performance
Town West $ 2,798.88
Replacement
Town
parts
West $ 4,925.96
AccessoriesTown West $ 1,900.54
Tools & Shop
Town West $
891.19
Clearance Town West $
Replacement
Town
parts
West $ 3,228.87
Replacement
Town
parts
West $ 1,251.02
AccessoriesTown West $ 1,788.34
Tools & Shop
Town West $ 2,654.44
Replacement
Town
parts
West $
AccessoriesTown West $
375.52
Performance
Town West $
474.44
Clearance Town West $
Performance
Town West $
650.45
Tools & Shop
Town West $ 3,789.21
Fluids
Town West $
133.98
Fluids
Town West $ 4,114.09
Tools & Shop
Town West $ 1,195.42
Replacement
Town
parts
West $
Tools & Shop
Town West $ 1,745.90
Specialty Town West $ 2,822.50
Specialty Town West $
657.56
Fluids
Town West $ 1,398.88
Specialty Town West $
Clearance Town West $
Fluids
Town West $ 3,519.79
Fluids
Town West $ 3,810.02
Replacement
Town
parts
West $ 9,768.68
Performance
Town West $ 1,047.66
Specialty Town West $
Fluids
Town West $
-

Hours
Worked
6
0
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

Base Pay
$ 135.00
$
$
81.00
$
81.00
$ 157.50
$
46.00
$
$ 128.00
$
$
$
46.00
$
67.50
$ 204.00
$ 144.00
$
80.00
$
$
72.00
$
46.00
$ 112.00
$ 180.00
$
$
72.00
$
32.00
$
$
46.00
$ 128.00
$ 128.00
$
81.00
$
72.00
$
$
23.00
$
96.00
$ 128.00
$
81.00
$
$
$
64.00
$
90.00
$
96.00
$ 112.50
$
$
-

Nested Calc
Commission
$
53.98
$
$
9.42
$
$
$
105.79
$
$
$
$
$
2.00
$
74.82
$
132.61
$
21.58
$
7.66
$
$
75.25
$
20.28
$
24.94
$
30.85
$
$
$
6.17
$
$
4.48
$
74.41
$
$
119.54
$
11.20
$
$
39.61
$
55.30
$
$
12.56
$
$
$
79.95
$
86.94
$
237.98
$
$
$
-

Ruaz
Schoemann
Stanton
Stephens
Stone
Vandrey
Walker
Watts
Wilson
Zeon
Argentine
Box
Bing
Bolyard
Bourque
Crad
Cronk
Course
Keyoe
Muarte
Gibb
Lucky
Sims
Fiddes
Beeman
Auger
Harpole
Linch
Ben
Hornel
Hall
Huxly
Hull
Wang
Ketakea
Ladder
Lenfestey
Less
Mallouf
Mass
Math
Manny
Montty
North
Picazo
Plumbtree
Pom

SA
SA
SP
PT
AM
SA
SA
SP
SP
SC
AM
PT
SA
SA
AM
PT
SC
SP
SC
SA
PT
SA
MGR
SP
SP
SC
PT
SC
SP
AM
PT
PT
SP
AM
PT
SP
SC
SA
SC
AM
PT
SP
SP
SA
SA
PT
SA

Specialty Town West $
Clearance Town West $
Clearance Town West $
Clearance Town West $
AccessoriesTown West $
Clearance Town West $
Specialty Town West $
Clearance Town West $
Replacement
Town
parts
West $
AccessoriesTown West $
Specialty Town East $
Specialty Town East $
AccessoriesTown East $
Tools & Shop
Town East $
Fluids
Town East $
Replacement
Town
parts
East $
Performance
Town East $
Performance
Town East $
Specialty Town East $
Performance
Town East $
AccessoriesTown East $
Performance
Town East $
Replacement
Town
parts
East $
AccessoriesTown East $
Tools & Shop
Town East $
Clearance Town East $
Replacement
Town
parts
East $
Replacement
Town
parts
East $
AccessoriesTown East $
Tools & Shop
Town East $
Replacement
Town
parts
East $
AccessoriesTown East $
Performance
Town East $
Clearance Town East $
Performance
Town East $
Tools & Shop
Town East $
Fluids
Town East $
Fluids
Town East $
Tools & Shop
Town East $
Replacement
Town
parts
East $
Tools & Shop
Town East $
Specialty Town East $
Specialty Town East $
Fluids
Town East $
Specialty Town East $
Clearance Town East $
Fluids
Town East $

1,532.87
664.32
1,486.22
2,719.75
1,994.48
2,127.32
1,725.25
1,318.97
943.17
686.57
4,502.33
649.27
556.00
1,798.88
4,925.96
1,900.54
891.19
3,228.87
1,251.02
1,788.34
2,654.44
375.52
474.44
350.45
3,789.21
133.98
4,114.09
1,195.42
1,745.90
2,822.50
657.56
1,398.88
3,519.79

5
8
5
0
0
6
8
8
2
0
5
0
5
5
6
3.5
0
7
0
0
3.5
6
7
8
4
0
3
3
6
7
0
3
2
0
4
8
7
6
3
0
2
6
8
5
0
0
4

$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$

67.50
108.00
80.00
81.00
108.00
128.00
32.00
112.50
67.50
67.50
135.00
40.25
112.00
40.25
81.00
178.50
128.00
64.00
34.50
54.00
96.00
157.50
34.50
32.00
46.00
128.00
126.00
81.00
54.00
23.00
96.00
128.00
67.50
54.00

$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$

24.94
23.31
64.61
21.85
30.70
22.06
16.51
1.70
107.37
3.58
28.32
148.36
24.74
10.81
75.45
19.56
28.10
40.93
0.41
6.17
74.41
119.54
17.81
39.61
55.30
19.66
110.31

Pommy
Porter
Ray
Rodden
Rose
Rual
Schmidt
Stanly
Steph
Stonebull
Vandyke
Walk
Water
Wilow
Yule
TOTAL
Avg
Min
Max

PT
SC
AM
SC
PT
SA
SA
SP
PT
AM
SA
SA
SA
SP
SC

Fluids
Town East
Replacement
Town
parts
East
Performance
Town East
Specialty Town East
Fluids
Town East
Specialty Town East
Clearance Town East
Clearance Town East
Clearance Town East
AccessoriesTown East
Clearance Town East
Specialty Town East
Clearance Town East
Replacement
Town
parts
East
AccessoriesTown East

$
$
$
$
$
$
$
$
$
$
$
$
$
$
$

2,810.02
6,76...


Anonymous
Really great stuff, couldn't ask for more.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags