Looking for the FORMULA for column % of Total Volume and # of models available for sale.

Also need the formulas to figure out these columns.

Annual Volume

% Total Sales to Dealers Jan-June

% Total Sales to Dealers July-Dec

% Total Sales to Dealers Annual

Jan - June Sales Summary - Actual Sales Volume 126 159 Total Sales to Dealers 5,473,683 6,816,609 $ $ Model VX207 VX212 VX208 VX217 VX220 VX219 VX201 VX209 VX204 VX215 VX210 VX211 VX216 VX214 VX224 VX218 VX223 VX213 794 1,485 2,678 2.831 5,605 669 4,464 4,923 30,587,502 56.003,841 94,514,075 100.581,880 191,578,128 22.835,451 152,479,784 156,593, 108 | Mfg. Cost per Vehicle $ 35,608 35,431 32.477 31,837 31,428 29,168 29,363 28,248 27,978 27,998 26,507 27,335 25,199 24,585 23,899 18,238 17.185 17,372 16.775 16,195 14,524 13,714 12.927 12,381 Markup Total Cost Percentage 4.486.626 22% 5 ,633,561 21% 23% 25,278.927 21% 46,669.867 20% 78,110,806 21% 83,125,521 21% 158,329,031 21% 18,717,583 22% 124,983,429 22% 130,494,256 20% 20% 133,074,916 18% 133, 130,374 18% 136,464,147 20% 107,437,702 19% 208,243,952 18% 112,255,925 15% 107,240,401 16% 150,746,876 12% 104,252,124 25% 102,755,405 23% 96,536,596 15% 95,385,535_ 16% % of total Volume 0.1% 0.1% 0.0% 0.7% 1.3% 2.4% 2.6% 5.1% 0.6%) 4.1% 4.5% 0.0% 4.8% 4.9% 5.2% 5.3% 11.0% 5.9% 5.8% 8.4% 6.5% 6.8% 6.8% 7.0% VX206 5,281 5,415 5,710 5,891 12.118 6,462 6.393 9,308 7,178 7,493 7,468 7,704 157,028,400 157,093,842 163,756,976 127,850,865 245,727,864 129,094,314 124,398,866 168,836,501 130,315,154 126,389,149 111,017,085 110,647,221 | VX202 VX205 VX222 VX221 VX2031 L $ total average 1 highest 110, 155 5 ,007 12.118 126 $ 24,015| 2.163,353,560 90,139,732 20% 2,569,620,296 107,067,512 lowest #models available for sale July-December Sales Summary - Estimated Total Sales to Dealers $ 5,821,219 $ $ % of total Volume 0.1% 0.0% 0.9% 0.8% 1.3% 2.6% 2.7% 5.3% 0.0% 4.4% 3.1% Model VX207 VX212 VX208 VX217 VX220 VX219 VX201 VX209 VX204 VX215 VX210 VX211 VX216 VX214 VX224 VX218 VX223 VX213 VX206 VX202 VX205 VX222 VX221 VX203 Sales Mfg. Cost per Volume Vehicle 134 $ 35,608 35,431 883 32,477 782 31,837 13851 31.428 26821 29,168 2842 29,363 5526 28,248 10 27,978 4514 27,998 32021 26,507 16 27,335 53211 25,199 53901 24,585 5738 23,899 5906 18,238 8996 17,185 6398 17,372 6473 16.775 9332 16,195 54321 14,524 7440 13,714 74801 12,927 7696 12,381 Markup Total Cost Percentage 4,771,491 22% - 21% 28,677,120 23% 24,896,878 21% 43,527,115 20% 78,227,476 21% 83,448,509 21% 156,097,453 21% 279,785 22% 126,383,333 22% 8 4,875,606 20% 437,354 20% 134,082,868 18% 132.515,737 18% 137,133,323 20% 107,711,266 19% 154,593,381 | 18% 111,144,137 108,582,374 16% 151,135,566 12% 78,893,499 25% 102,028,589 23% 96,691,716 15% 95,286,485 16% 0.0% 35,272,858 30,125,222 52,232,538 94,655,246 100,972,696 188,877,919 341,337 154,187,666 101,850,727 524,824 158,217,784 156,368,570 164,559,987 128, 176,406 182,420,190 127,815,757 125,955,554 169,271,834 | 98,616,874 125,495,164 111,195,473 110,532,322 15% 5.1% 5.2% 5.5% 5.7% 8.7% 6.2% 6.2% 9.0% 5.2% 7.2% 720 7.4% total average | highest lowest 103.578 4,503 $ 9,332 10 24,015 $ 2.041,421,061 $ 85,059,211 20% $ 2,423,488,170 $ 100,978,674 #models available for sale (24) Sales Summary - Estimated 2.17961 Model VX207 VX212 VX208 VX217 VX220 VX219 VX201 VX209 VX204 VX215 VX210 VX211 VX216 VX214 VX224 VX218 VX223 VX213 VX206 VX202 VX205 VX222 VX221 VX203 % Total % Total Sales % Total Sales Sales to Annual Jan-June Sales July-Dec Sales Total Sales to t o Dealers to Dealers Dealers Volume to Dealers to Dealers Dealers Jan-June July-Dec Annual 260 $ 5,473.683 $ 5,821,219 $ 11.294,902 0.21% 0.24% 0.23% 1596.816.809 6,816,609 0.27% 0.00% 0.14% 883 35,272,858 35,272,858 0.00% 1.46% 0.71% 1.570 30 5A7 En 30.587,502 30,125,222 60,712.725 1.19% 1.24% 1.22% 2,870 56.003.841 52.232.538 108.236.379 2.18% 2.1096 5,360 94,514,075 94,655,248 189,169,322 3.68% 3.01% 3.79% 5,673 100,581,880 201.554.576 3.91% 4.17% 4.04% 11.131 191,578,128 188,877,919 380.456,046 7.46% 7.79% 7.62% 679 22,835,451 341,337 23.176.788 0.89% 0.01% 0.46% 8.978 152,479,784 154.187.688 306,067,450 5.93% 6.36% 6.14% 8,125 156,593.108 101,850,727 | 258,443,835 6.09% 4.20% 5.18% 18 524.8241 524,824 | 0.00% 0.0296 0.01% 10.602 157,028,400 158.217.784 315,246,185 6.11% 6.53% 6.31% 10,805 157,093.842 156,368,570 313,462,411 6.11% 6.45%) 6.28% 11.448 163,756.976 164,559,987 328.316.963 6.37% 6.79% 6.58% 11.797 127.850.865 128.176.406 256,027,271 4.98% 5.29% 5.13% 21.114 245,727.884 182,420,190 428,148,054 9.56% 7.53% 8.57% 12.860 129,094,314 127,815,757 258,910,071 5.02% 5.27% 5.15% 12,866 124,398,866 125.955,554 250.354.420 4.84% 5.20% 5.01% 18,640 168,838,501 169,271,834 338,108,335 6.57% 6.98% 6.7796 12.610 130,315,154 | 98,616,874 228,932.028 5.07% 4.07% 4.58% 14.933 126,389,149 125.495,164 251,884,313 4.92% 5.18% 5.04% 14,948 111,017.085 111,195,473 | 222.212.558 4.32% 4.5996 4.45% 15,400 110.647.221 110,532,322 221,179,543 4.31% 4.56% 4.43% total 213.733 $2.569.620.296 2.423.488,170 S 4 ,993.108.466