80.2K

Verified Solution

Link Copied!

Excel

017 fo TYPE B INVENTORY NUMBER 9589-00276-1 6021-00310-Y 3220-00390-P MINIVAN 1 2 3 4 5 6 SUV PICK-UP 21 2210-00420-Z MINIVAN 2131-00432-R | cOMPACT 7 7077-00519-A CROSSOVER 3553-00558-0 H DAYS ON LOT ASKING PRICE MAX DISCOUNT 35 $11,900 $1,000 37 $11,900 $500 $12,700 $900 23 $11,800 $700 36 $10,400 $1,000 18 $14,700 $500 22 $13,300 $800 25 $11,000 $900 32 $12,100 $900 57 $10,800 $600 32 $14,700 $700 33 $11,700 $500 17 $12,700 $800 SEDAN 8 9 8226-00630-V E F COLOR MILES LOCATION SILVER 51,666 SOUTHWEST RED 62,084 EAST RED 33,868 NORTH SILVER 49,883 NORTHEAST BLACK 72.561 EAST BLACK 63,219 SOUTHWEST RED 43,220 NORTH BLACK 32,884 EAST WHITE 68,092 NORTHEAST BLACK 82,783 EAST RED 23,463 SOUTH BLACK 88,527 WEST SILVER 64,196 EAST SILVER 90,000 NORTHEAST BLUE 61,466 NORTHEAST BLUE 28,098 SOUTHWEST BLACK 32,297 SOUTHWEST BLUE 33,571 NORTHEAST COMPACT 10 6470-00662-N SEDAN 9872-00711-N COUPE 11 12 6130-00733-W PICK-UP 13 9718-00758-M COUPE 3624-00790-X COMPACT 14 15 5746-00821-Y SEDAN 29 16 32 3097-00889-K 7786-00909-1 COMPACT CROSSOVER 17 30 $13,700 $12,700 $11,600 $10,500 $10,500 $15,000 $600 $1,000 $1,000 $1,000 $1,000 18 7145-00948-1 COUPE 41 19 4976-01019-V COUPE 40 20 3173-01065-Y MINIVAN SILVER 49,131 NORTH 41 $600 INVENTORY REPORT LOCATION HOF VORLESUNDER OF VEHICLES THAT AR TOTAL VALUE RAMD THIS MILLADE TIES.COLOR TOTALLIGEVEE ONALAK VERSION WER - VALVES WILL CHARICES YOU FORMULAS MOW. NORTH 40 SOLROO 00 201606662 SOUTH 40 363.700.00 1067460 EAN 2 5517.000.00! 10.35714286 WE 34 $421.500.00 21.79411785 NORTHEAST 451 5547.600.00 3051111111 SOUTHWEST 57 $711.500.00 30.10526316 TOTALS 2751 53439.100.00 COLE INSTOCK BLACK BED NOFTOTAL SEDANG COUPE is talle should contain the NUMBERS of units in stare ALL HOW MANY donde weh. The bottom rol should contain PERCENTAGES What percentage of all rest What percentage of oweckvedete PICK suv MINIVAN CROSSOVER COMPACT NOFTOTAL AVISOR TV SEDAN BV MOYVAN LOCATION son LASI WEST MONTANT What is the ratio of BLUE vehicles to WHITE vehicles What is the average number of miles on all in-stock SEDANS: What is the longest amount of time fin daya) that any in-stock vehicle has been on a lot: What is the average discount for all SILVER vehicles with more than 50,000 miles 017 fo TYPE B INVENTORY NUMBER 9589-00276-1 6021-00310-Y 3220-00390-P MINIVAN 1 2 3 4 5 6 SUV PICK-UP 21 2210-00420-Z MINIVAN 2131-00432-R | cOMPACT 7 7077-00519-A CROSSOVER 3553-00558-0 H DAYS ON LOT ASKING PRICE MAX DISCOUNT 35 $11,900 $1,000 37 $11,900 $500 $12,700 $900 23 $11,800 $700 36 $10,400 $1,000 18 $14,700 $500 22 $13,300 $800 25 $11,000 $900 32 $12,100 $900 57 $10,800 $600 32 $14,700 $700 33 $11,700 $500 17 $12,700 $800 SEDAN 8 9 8226-00630-V E F COLOR MILES LOCATION SILVER 51,666 SOUTHWEST RED 62,084 EAST RED 33,868 NORTH SILVER 49,883 NORTHEAST BLACK 72.561 EAST BLACK 63,219 SOUTHWEST RED 43,220 NORTH BLACK 32,884 EAST WHITE 68,092 NORTHEAST BLACK 82,783 EAST RED 23,463 SOUTH BLACK 88,527 WEST SILVER 64,196 EAST SILVER 90,000 NORTHEAST BLUE 61,466 NORTHEAST BLUE 28,098 SOUTHWEST BLACK 32,297 SOUTHWEST BLUE 33,571 NORTHEAST COMPACT 10 6470-00662-N SEDAN 9872-00711-N COUPE 11 12 6130-00733-W PICK-UP 13 9718-00758-M COUPE 3624-00790-X COMPACT 14 15 5746-00821-Y SEDAN 29 16 32 3097-00889-K 7786-00909-1 COMPACT CROSSOVER 17 30 $13,700 $12,700 $11,600 $10,500 $10,500 $15,000 $600 $1,000 $1,000 $1,000 $1,000 18 7145-00948-1 COUPE 41 19 4976-01019-V COUPE 40 20 3173-01065-Y MINIVAN SILVER 49,131 NORTH 41 $600 INVENTORY REPORT LOCATION HOF VORLESUNDER OF VEHICLES THAT AR TOTAL VALUE RAMD THIS MILLADE TIES.COLOR TOTALLIGEVEE ONALAK VERSION WER - VALVES WILL CHARICES YOU FORMULAS MOW. NORTH 40 SOLROO 00 201606662 SOUTH 40 363.700.00 1067460 EAN 2 5517.000.00! 10.35714286 WE 34 $421.500.00 21.79411785 NORTHEAST 451 5547.600.00 3051111111 SOUTHWEST 57 $711.500.00 30.10526316 TOTALS 2751 53439.100.00 COLE INSTOCK BLACK BED NOFTOTAL SEDANG COUPE is talle should contain the NUMBERS of units in stare ALL HOW MANY donde weh. The bottom rol should contain PERCENTAGES What percentage of all rest What percentage of oweckvedete PICK suv MINIVAN CROSSOVER COMPACT NOFTOTAL AVISOR TV SEDAN BV MOYVAN LOCATION son LASI WEST MONTANT What is the ratio of BLUE vehicles to WHITE vehicles What is the average number of miles on all in-stock SEDANS: What is the longest amount of time fin daya) that any in-stock vehicle has been on a lot: What is the average discount for all SILVER vehicles with more than 50,000 miles

Answer & Explanation Solved by verified expert

See Answer