* PLEASE do with a Microsoft Excel !

You are the district manager for Hyundai Automobile. You need to evaluate the quarterly sales information below. Please create a spreadsheet that will calculate: 1) the number of cars sold by each model of car, 2) the number of cars sold by each sales representative, 3) the total dollar sales for each sales representative, both by model and overall, 4) the profit that each sales representative created, 5) the commission for each representative, and 6) a ranking of the sales representatives from most to least productive. Your analysis may differ from other teams. We will leave it to you to determine how to rank the sales representatives. Although accuracy of calculations is important, part of your grade will be based on the quality of your presentation. In addition, if you can think of other calculations tha will be useful to the manager, please do them. Each model of car comes in a Regular, Deluxe, and Luxury style. Here are the selling prices of each car's Regular model. The Deluxe model costs 22% more than the Regular model and the Luxury model costs 26% more than the Deluxe model. (Assume all customers pay the selling price). The profit for the dealership on each car is 18% of the selling price: A sales representative receives a commission of 20% of the profit for each regular model sold, 25% of the profit for each deluxe model sold, and 30% of the profit for each luxury model sold