You are the district manager for Hyundai Automobile. You need to evaluate the quarterly sales for the Stony Brook dealership and have the 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 that 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 cars 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). Model of car Regular Sonata $22,000 Elantra $24,000 Tucson $28,000 Accent $26,000 Kona $20,000 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.

AMS 104 Homework #2 You are the district manager for Hyundai Automobile. You need to evaluate the quarterly sales for the Stony Brook dealership and have the 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 that 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). Model of car Regular Sonata Elantra Tucson Accent Kona $22,000 $24,000 $28,000 $26,000 $20,000 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. AMS 104 Homework #2 The sales figures for each representative are below: Representative Model Number sold Regular Deluxe Luxury Fred Janowski Sonata Elantra Tucson Accent Kona 4 6 5 5 3 2 1 5 2 3 4 2 2 2 4 2 Sasha Babahanova Sonata Elantra Tucson Accent Kona no 4 5 4 3 5 1 3 5 2 2 5 2 2 0 Kristopher Chen Sonata Elantra Tucson Accent Kona 2 3 0 2 8 4 1 4 5 4 5 4 2 3 1 Donny Atoian 6 5 Sonata Elantra Tucson Accent Kona 6 3 4 1 2 4 3 1 aWN 2 3 1 3 5 Jared Schaefer 5 2 Sonata Elantra Tucson Accent Kona 0 2 7 2 3 NWON 3 4 2 2 4 3 2