Build a report on the sales associates' productivity for the current year to date.This report should include each associate's total of sales revenue, total of gross profit, average gross profit per sale, and average of gross profit margin.Report all revenues to the nearest dollar (e.g. $1,234).Report average gross profit margin as a percent with two decimal places (e.g. 12.34%).Use the information in thefollowing screenshot.

Please fill in x's using excel. Thanks!

YTD - Sales Associate Report (alphabetized by first name):

Sales Associate Total Revenue Total gross profit Average gross profit Average gross profit margin

Art Monk x x x x

George Preston x x x x

Jason Taylor x x x x

Joe Gibbs x x x x

John Riggins x x x x

Ken Houston x x x x

Paul Krause x x x x

Ray Flaherty x x x x

Russ Grimm x x x x

Sam Huff x x x x

Sammy Baugh x x x x

Sonny Jurgensen x x x x

Boat World Data - HW Only Q v Search Sheet '+ Share ~ Home Insert Formulas Review Calibri (Body) * 11 Sort & Merge & Center Delete Format Formatting as Table Styles Filter Paste G11 X 1 Transaction N Customer First Name Customer Last Name Customer State Sales Person First Sales Person Last 80,130 $ 11.62% 2 B10001 Roaf Paul Preston 1/4/20 Yes 36,720 6,469 17.62% 3 B10002 Monk A 1/16/20 Yes 81,730 68,082 16.70% A Paul 38,970 S 8 , 38 21.52% Thomas A 1/23/20 No Jurgensen 1/28/20 Yes 17,113 3,137 IL |Monk 19,355 $ 6,145 24.10% Doug IA 2/4/20 No 11,160 s 2,489 Sanders 12,722 Battles SD 56-75 Russ Grimm 120 Yes 16,494 23.94% 10 B10009 Green IL Baug IA Riggins 2/17/20 No 2/18/20 No 63,932 $ 16,118 20.13% 12 B10011 Hank Stram Sam Huff 1A 46-55 George Preston 2/21/20 Yes 42,260 8,073 19.10% Ken 29,290 24,190 $ David Hanburger MN Monk 16.71% Garcia Paul Krause 3/2/20 Yes 50,658 15 B10014 36-45 Sam Huff 1/20 No 38,130 29,057 23.79% 16 B10015 A Flaherty 46,800 11,238 24.01% 17 B10016 David Ray 3/15/20 Yes 6,762 Morten Andersen 36-45 29,964 $ 19 B10018 Hernandez Monk 9,116 23.33% Art 3/19/20 No 52,409 10,101 16.16% 20 B10019 Jackson IA Ker Houston IA 66-75 3/29/20 No 35,420 26,618 24.85% Smith Ken Houston 4/2/20 No 1.237 24.99% 4/3/20 Yes 524 16.43% Jim SD 26-35 Sammy 15,583 22.80% 24 B10023 George IA John Riggins 4/11/20 No 68,340 52,757 5,570 25 B10024 Allen A Ray 4/25/20 Yes /26/20 Yes 61,820 51,748 $ SD Russ 5/12/20 Yes 69,300 12,510 15.29% 27 B10026 Charles mith IA 46-55 Ray Flaherty John IA 46-55 Sammy Baugh 29 B10028 George IA 46-55 Jason Taylor 69,245 17,355 20.04% 52,600 13,510 30 B10029 Beathard MN 46-55 Ken 7/20 No Grimm 6/20/20 No 12,820 10,096 $ 2,724 21.25% 31 B10030 Earl Campbell A Russ 28,055 7,565 21.24% mith Jason 7/11/20 No 34,190 Joseph Bailey MN Joe Gibbs 7/13/20 No 34 B10033 Deacon MN Preston 57,373 S 18,137 24.02% Ann 6,010 $ 4,586 $ 23.69% Jane 66-75 Sonny Jurgensen 7/21/20 No 3, 730 20.17% 36 B10035 Jim MN 30,454 7,106 18.92% 37 B10036 Preston A Joe 7/24/20 Yes 50,520 41,876 38 B10037 Margaret Stanfel Houston 6,04 15.47% 39 B10038 Taylor 66-75 John Riggins 66-75 Huff 15,061 8/26/20 Yes 85,560 S 16,086 18.80% 41 B10040 William Reed 46-55 Jurgensen Sales Data Dictionary