AM PT1 PT2 51 $2 The report should be sorted to make it easy to identify the "best" salesperson dened by the % of Assrstant Manager $ Sales Assistant $ Sales Partner $ Sales Associate $ Sales Consultant $ Target Sales is calculated by multiplying the hours worked times the hourly sales quota of the designated Sales Rank. % of Target is calculated by dividing Sales by Target Saies. Base Pay is calculated by multiplying the hours worked times the hourly wage. Commission is calculated for employees whose Sales exceeds their Target Sales - by multiplying the weekly sales amount times the commission rate that corresponds to the employee's Sales Rank. 23.50 10.50 11.75 13.50 15.00 $ 200.00 $ 100.00 $ 125.00 $ 150.00 $ 175.00 Gross Pay is the sum of Base pay and Commission. target column. Part 2: Mr. McDougal would also like a summary report that will display the counts, sales and quotas (targets) by Rank. (The % of Target column in this summary report is calculated as Total Sales divided by Total Target.) 3.0% 1.0% 1.5% 2.0% 2.5%