Part 1: to be completed in Excel®
You manage the inventory for a car dealership. Data on current inventory can be found in the Week 2 Data Set. Management would like you to assess current inventory on the dealership lot.
Using the Week 2 Data Set, create and calculate the following in Excel®:
This is the information for the Data Set
Sample Car # | Color | MPG | Suggest Retail Price | Option Package | Days in Inventory |
1 | Grey | 27.6 | $ 24,390.00 | LX | 1 |
2 | Grey | 32.4 | $ 21,780.00 | Touring | 10 |
3 | Blue | 33.2 | $ 21,149.00 | Touring | 28 |
4 | Black | 34.7 | $ 22,069.00 | LX | 21 |
5 | Blue | 27.2 | $ 22,532.00 | Touring | 16 |
6 | Blue | 26.6 | $ 20,345.00 | Touring | 22 |
7 | Red | 37.3 | $ 22,112.00 | EX | 12 |
8 | Silver | 34.9 | $ 21,289.00 | Touring | 23 |
9 | Silver | 29.6 | $ 24,871.00 | LX | 15 |
10 | Silver | 32.3 | $ 25,389.00 | EX | 8 |
11 | Grey | 31.9 | $ 25,998.00 | EX | 28 |
12 | Red | 26.4 | $ 19,713.00 | LX | 55 |
13 | Black | 34.8 | $ 25,213.00 | EX | 2 |
14 | Silver | 35.9 | $ 24,467.00 | Touring | 33 |
15 | Black | 34.6 | $ 21,402.00 | LX | 17 |
16 | Black | 33.3 | $ 20,351.00 | LX | 14 |
17 | Grey | 33.1 | $ 23,732.00 | Touring | 1 |
18 | Red | 37.5 | $ 24,558.00 | Touring | 2 |
19 | Red | 27.8 | $ 19,167.00 | LX | 18 |
20 | Red | 36.1 | $ 19,903.00 | Touring | 22 |
21 | Blue | 28.8 | $ 22,140.00 | Touring | 19 |
22 | Red | 26.2 | $ 22,180.00 | EX | 41 |
23 | Silver | 27.4 | $ 23,120.00 | Touring | 33 |
24 | Black | 34.9 | $ 19,837.00 | Touring | 21 |
25 | Red | 36.5 | $ 24,666.00 | EX | 31 |
26 | Red | 26.3 | $ 19,446.00 | EX | 35 |
27 | Blue | 31.4 | $ 23,954.00 | Touring | 11 |
28 | Blue | 30.9 | $ 21,201.00 | LX | 3 |
29 | Red | 27.4 | $ 21,346.00 | EX | 26 |
30 | Red | 36 | $ 19,406.00 | EX | 31 |
WhatsApp us