BUAD 2020 Information Technology Management Assignment #1 - Using Excel's Functions for Data Analysis Due: Check Blackboard Course Site for Due Date Case Background: 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 4 D E 1 empFirst emplast rank departme sales hours the POS system that contains the employee name, rank, 2 Dorian Santana $2 Juniors $4058.62 17 3 Quyn Ryan Shoes $3431.16 17 department, sales and hours worked. That data is 4 Lucian Hendrix AM Infants $3200.22 32 5 Maryam Wright PT1 Juniors $1815.60 37 provided to you in the file named 6 Florence Terry Mens $4811.53 13 7 Grant Ballard PT1 Mens $2907.98 25 A1_MacysDeptStore.xIsx (and is available for download 8 Zelda Riley PT1 Childrens $4123.00 22 9 Dacey Gilmore PT1 Womens $70.83 16 on Blackboard - under the assignment course link) and 10 Sacha Short $1 Mens $4840.11 28 11 Burke Carrillo PT2 Cosmetics $5071.97 34 12 Phoebe Combs PT2 looks similar to the image below. Shoes $4208.62 28 13 Lacey Rosario Juniors $5082.76 31 14 Ori Sargent AM Housewar $374.27 15 15 Maggie England PT1 Childrens $5121.92 16 16 Sandra George PT1 Cosmetics $1556.65 16 17 Fay Meadows $2 Housewar $2536.79 31 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 hours worked, base pay earned, commission due and the salesman's gross pay for the week under review. He put together a sample of how he would like the report to look - use this layout - or your best judgement to produce a well laid out and easy to understand report