BUAD 2020 Information Technology Management Assignment #2 - Using Excel's Functions for Data Analysis Case Background Due: Check Blackboard Course Site for Due Date You have been hired by John McDougal, sales manager of Macy's Franklin Park store, to help him better understand the productivity of his sales force. Mr. McDougal has provided you with a download from the POS system that contains the employee name, rank, department, sales and hours worked. That data is provided to you in the file named A1 MacysDeptStore.xlsx (and is available for download on Blackboard) and looks similar to the image below. TempFirst emplast rank. Dorian Santana $2 Ryan 52 4 Lucian Hendrix AM Maryam Wright PT1 6 Florence Terry 52 Ballard PT1 Riley PTL Gilmore P 7 Grant Zelda Dacey 10 Sasha 12 Phoebe Tatey C D hours 17 departme sales Juniors 5405862 Shoes $3411.16 17 Infants $3200.22 Juniors $1815.60 37 Mens Mens 32 13 2907.58 25 Childrens $4123.00 22 Womens 570.83 16 Meng 34040.11 28 31 14 On Short 51 Camille PT2 Combs PT2 Rosario 2 Sargent AM 13 Maggie England PTS 16 Sandra George P Meadows 52 Cosmetic $3071.97 Shoes 64208.62 28 34 Auniors 308276 Housewa$174.27 15 Childrens $5121.92 Cosmetic $1556 65 Housewar$2536.79 14 16 31 Using the file given (Do NOT copy into another Excel file), Mr. McDougal would like you to produce a series of reports that will let him know how well the sales force is performing - where performance is defined by how many employees meet their targeted sales quotas and the overall percentage of the sales quota obtained by the cumulative efforts of all salesmen. Mr. McDougal has identified two ways that he would like the analysis of each week presented. Each part is detailed below. Part 1: Mr. McDougal would like a weekly recap of sales by salesman that displays information regarding weekly sales, the salesman's sales quota, the percent of the quota met, number of