In cells D2:D31, calculate the total cost of all vehicles sold for each model. You should use the ROUNDUP function to round the results of your formula up to next highest whole dollar amount. Make sure that cells D2:D31 are formatted as Currency with zero decimal places. Check Figure: Cell D2 = $83,125,521

19. In cells F2:F31, calculate the total sales to dealers of all vehicles sold for each model. You should use the ROUNDUP function to round the results of your formula up to the next highest whole dollar amount. Make sure that cells F2:F31 are formatted as Currency with zero decimal places. Hint: the formula in column F should increase the amounts in column D by the markup percentages in column E. Check Figure: Cell F2 = $100,581,881

20. In cells G2:G31, calculate the percentage of total sales volume that each model represents. This calculation is based on the volume for a particular model compared to the volume of all models sold. Make sure that cells G2:G31 are formatted as Percentage with two decimal places. Check Figure: Cell G4 = 5.87%

21. Sort the data in cells A1:G31 in descending order by percentage of total sales volume (i.e. column G). Note: the data in cells A1:G31 is not an official Excel table, and you should not convert it to one. The data for Model VX223 should now be in row 2, and the data for Model VX219 should now be in row 20.

AutoSave OIF OF ABES Abuoudehbassamexcel3 Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments v 14 v Insert v ab Wrap Text Cerera 28 4 v Paste X Calibri (Body LE BIU 2x Xfx Merge Center $ % Conditional Format Cell Formattingss Table Styles 2X Delete Format v Sarta O filler Find Select Analyze Dale G2 D E G H 1 L M N 0 % of Total Sales Volume Total Cost $83, 125,521 $150,746,876 $95,385,535 $18,717,583 1 Model Sales Volume 2 VX201 2,831 3 VX202 9,308 1 VX203 7,704 S VX204 669 6 VX205 7,178 7 VX206 6,393 8 VX207 125 9 VX208 1,980 10 VX209 5,605 11 VX210 4,923 12 VX211 3,650 13 VX212 159 14 VX213 6,462 15 VX214 5,415 16 VX215 4,464 17 VX216 5,281 18 VX217 794 19 VX218 5,891 20 VX219 2,678 21 VX220 1,485 22 VX221 7,468 23 VX222 7,493 24 VX223 12,118 25 VX224 5,710 26 VX225 630 27 VX226 1,520 28 VX227 269 29 VX228 8,965 30 VX229 2.300 31 VX230 1,874 32 33 Manufacturing Cost per Vehicle $29,362.60 $16.195.41 $12,381.30 $27,978.45 $14,523.84 $16,774.66 $35,608.14 $32,476.92 $28,247.82 $26,507.06 $27,334.60 $35,431.20 $17,371.70 $24,585.48 $27,998.08 $25,198.81 $31,837,44 $18.237.60 $29,167.59 $31,427.52 $12,926.70 $13,713.52 $17,184.68 $23,899.15 $25,362.35 $30,582.40 $412,358.28 $19,652.57 $18,784.15 $20,650.63 $104,252,124 $107,240,401 $4,451,018 $64,304,302 $158,329,031 $130,494,256 $99,771,290 $5,633.561 $112,255,925 $133,130,374 $124,983,429 $133,074,916 $25,278,927 $107,437,702 $78,110,806 $46,669,867 $96,536,596 $102,755,405 $208,243,952 $136,464,147 $15,978,281 $46,485,248 $110,924,377 $177,978,290 $43,203,545 $39,074,081 Markup Percentage 21% 12% 16% 22% 25% 16% 22% 23% 21% 20% 20% 21% 15% 18% 22% 1846 21% 19%. 21% 20%. 15% 23% 18% 20% 19% 20% 20% 22%. 16% 21% Total Sales to Dealers $100,581,880 $168,836,501 $110,647,221 $22,835,451 $130,315,154 $124,398,866 $5,430,241 $79,094,291 $191,578,128 $156,593,108 $119,725,548 $6,816,609 $129,094,314 $157,093,842 $152,479,784 $157,028,400 $30,587,502 $127,850,865 $94,514,075 $56,003,841 $111,017,085 $126,389,149 $245,727,864 $163,756,976 $19,014,154 $55,782,298 $133,109,253 $217,133,514 $50,116,112 $47,279,638 34 Job Analysis Vehicle Sales + Edit + 100%