6 2016 and 2017 comparing monthly commission amounts and % difference Sales Person Code Commission % JB, TD 3% FT 1% ONSO 5.75% SERV 1.25% All others 2.25% Reporting (20 marks) Using Microsoft Word, prepare a summary of your findings from a) to i). All your findings should be Make a comment on a) Sales each year b) Sales by Sales Type c) Sales by Seamless Product Group d) Sales by Seamless Product Type e) Commissions reports In your report include visuals to represent the data i.e. use an appropriate chart to show your comments in the above a) to e) Make a recommendation on the product types, gross margins, sales person commissions. Do you feel that the managers view of the data is appropriate or would you change something? Overall comments Be creative in your report creation. You are limited to 2 pages for the report in Word so put in the appropriate charts and data that you feel best represents the company data given. Marks will be given for being creative and providing value to the manager.