In this problem you will have to organize the data for the owner of two Honda Dealers located in Gainesville and Ocala. The raw data is in Auto Sales worksheet (shown below). Car Model CMC Civic Accord CIVIC Accord Accord Civic Accord Civic Civic Civic Accord Accord Civic Accord Accord Civic CNC Civic Accord Civic Accord Accord Used Auto Sales in Year 2009 Dealer Make Year Month Sold Ocala 2005 December Ocala 2008 February Gainesville 2008 June Ocala 2005 Lady Gainesville 2005 November Oct 2007 June Gainesville 2002anuary Gainesville 2003 February Gainesville 2005 December Ocala 2007 May Gainesville 2005 Ocala 2004 December Ocala 2007 April Gainesville 2002 April Gainesville 2003 Ocala 2004 January Tocala 2004 November Gainesville 2007 May Ocala 2005 Januar Ocala 2007 October Gainesville 2009 December Ocala 2004 October Gainesville 2005 September Ocala 2007 September Buy Price Sale Price 5 15.000.00 23 300 00 S 7.800.00 S 8.550.00 $ 12 000.00 S 16 400.00 S 3.650.0015 6.100.00 $ 15 000 00S 18.700 00 s 8900 00S 12 500 00 S 9350 00$ 14220 00 S 11 200.00 14 570 00 5 500 000 12 40000 $ 9.90000 15,550 00 S 12 600 005 15 200 00 S 10 56000 17 300.00 $ 3 900.00 $ 13.450 00 5 1 600 0015 5.540 00 5 15 350.00 S 17.540 00 5 2.560.00 4.999.00 176005 2450000 S 18 230.005 23,760.00 5 14.670.0951220.00 S 13.490.00 S 16. 510.00 ES 14 140.00 $ 17 560 00 $ 15 230 005 18.770 00 $ 12.670.00 $15.990.00 S 9.870.00 S 14 53000 You are asked to create a Pivot Table in Pivot Table worksheet in order to organize this data. The final pivot table should look and be formatted like the one shown in the picture below. Data Dealer Cars' Buy Price Cars Sale Price Dealer Profit Car Model Make Year Gainesville Ocala Gainesville Ocate Ganesvit Oesla Accord 2002-2003 $ 11,200.00 $ 54 670.00 $ 3.470.00 2004-2005 12 670 005 28 350.00 15.990.00 5 41.069 00 3.320 00 S 12.719.00 2006-2000 $ 43.350.00 S 31.290.001S 32.540.00 $ 12.450,00 15 9.290.00 $ 11.170.00 Accord Average 13.444.00 $ 9.940.005 16.660 00 S 13.92150 CNC 2002-2003 5 25.090.00 $ 37 320.00 $ 12 230.00 5 2004-2005 $ 12 600 00 $ 36.320.00 $ 15.200.00 $ 47 650 00 3,600 00 $ 11.330.00 2006-2008 26.730.00 $ 46 330 005 25,150.00 563.170.00 S 943000 S 16.840.00 Civic Average $ 10,736.67 $ 11 307 145 14.965 57 15.831 43 Grand Total S 131 640 005 142 290 00 S 12.980.60 S 134 349 00 41 340005 52 059 00 $ S s Notice that you have to create a calculated field called Dealer Profit