Question no 1

CASE 1: Sales Representatives 1a - Complete this sales report and indicate the steps you followed: profit Salesman Year Region Units sold Price Revenues Profit margin Robert 2018 Europe 650 780 60% Adrian 2019 Asia 950 620 55% Rudolf 2018 Africa 110 780 50% Kenny 2018 Caribbean 850 350 45% Adrian 2018 Asia 330 180 55% Robert 2019 Europe 750 500 60% 1b - Based on the previous data, create a bar chart showing the revenues per salesman in 2018, paste it here below, and explain how you did it. Then do a similar bar chart showing the profits per salesman in 2018. Finally compare the two charts (common elements and differences, if any) 1c - Sort the salesmen according to their profit in 2018, and explain how you did it (do it using the proper tools in a Spreadsheet, and then paste the solution in the Word file)