CKG Sales.xlsx - Jan June Sales Summary Actual Model VX207...

Info icon This preview shows pages 1–5. Sign up to view the full content.

View Full Document Right Arrow Icon
Jan - June Sales Summary - Actual Model Sales Volume Total Cost VX207 126 35608.14 $ 4,486,626 22% $ 4,494,459 VX212 159 35431.20 $ 5,633,561 21% $ 5,641,001 VX208 32476.92 $ - 23% $ 7,470 VX217 794 31837.44 $ 25,278,927 21% $ 25,285,613 VX220 1,485 31427.52 $ 46,669,867 20% $ 46,676,153 VX219 2,678 29167.59 $ 78,110,806 21% $ 78,116,931 VX201 2,831 29362.60 $ 83,125,521 21% $ 83,131,687 VX209 5,605 28247.82 $ 158,329,031 21% $ 158,334,963 VX204 669 27978.45 $ 18,717,583 22% $ 18,723,738 VX215 4,464 27998.08 $ 124,983,429 22% $ 124,989,589 VX210 4,923 26507.06 $ 130,494,256 20% $ 130,499,558 VX211 27334.60 $ - 20% $ 5,467 VX216 5,281 25198.81 $ 133,074,916 18% $ 133,079,451 VX214 5,415 24585.48 $ 133,130,374 18% $ 133,134,800 VX224 5,710 23899.15 $ 136,464,147 20% $ 136,468,926 VX218 5,891 18237.60 $ 107,437,702 19% $ 107,441,167 VX223 12,118 17184.68 $ 208,243,952 18% $ 208,247,045 VX213 6,462 17371.70 $ 112,255,925 15% $ 112,258,531 VX206 6,393 16774.66 $ 107,240,401 16% $ 107,243,085 VX202 9,308 16195.41 $ 150,746,876 12% $ 150,748,820 VX205 7,178 14523.84 $ 104,252,124 25% $ 104,255,754 VX222 7,493 13713.52 $ 102,755,405 23% $ 102,758,559 VX221 7,468 12926.70 $ 96,536,596 15% $ 96,538,535 VX203 7,704 12381.30 $ 95,385,535 16% $ 95,387,516 Total 110155 $ 2,163,353,560 $ 2,163,468,820 Average 5,007 24,015 $ 90,139,732 20% $ 90,144,534 Highest 12,118 Lowest 126 # models available for sale 24 Mfg. Cost per Vehicle Markup Percentage Total Sales to Dealers
Image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
0.11% 0.14% 0.00% 0.72% 1.35% 2.43% 2.57% 5.09% 0.61% 4.05% 4.47% 0.00% 4.79% 4.92% 5.18% 5.35% 11.00% 5.87% 5.80% 8.45% 6.52% 6.80% 6.78% 6.99% % of total Volume
Image of page 2
July - Dec Sales Summary - Actual Model Total Cost VX207 134 35608.14 $ 4,771,491 22% $ 5,821,219 0.13% VX212 35431.20 $ - 21% $ - 0.00% VX208 883 32476.92 $ 28,677,120 23% $ 35,272,858 0.85% VX217 782 31837.44 $ 24,896,878 21% $ 30,125,222 0.75% VX220 1385 31427.52 $ 43,527,115 20% $ 52,232,538 1.34% VX219 2682 29167.59 $ 78,227,476 21% $ 94,655,246 2.59% VX201 2842 29362.60 $ 83,448,509 21% $ 100,972,696 2.74% VX209 5526 28247.82 $ 156,097,453 21% $ 188,877,919 5.34% VX204 10 27978.45 $ 279,785 22% $ 341,337 0.01% VX215 4514 27998.08 $ 126,383,333 22% $ 154,187,666 4.36% VX210 3202 26507.06 $ 84,875,606 20% $ 101,850,727 3.09% VX211 16 27334.60 $ 437,354 20% $ 524,824 0.02% VX216 5321 25198.81 $ 134,082,868 18% $ 158,217,784 5.14% VX214 5390 24585.48 $ 132,515,737 18% $ 156,368,570 5.20% VX224 5738 23899.15 $ 137,133,323 20% $ 164,559,987 5.54% VX218 5906 18237.60 $ 107,711,266 19% $ 128,176,406 5.70% VX223 8996 17184.68 $ 154,593,381 18% $ 182,420,190 8.69% VX213 6398 17371.70 $ 111,144,137 15% $ 127,815,757 6.18% VX206 6473 16774.66 $ 108,582,374 16% $ 125,955,554 6.25% VX202 9332 16195.41 $ 151,135,566 12% $ 169,271,834 9.01% VX205 5432 14523.84 $ 78,893,499 25% $ 98,616,874
Image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern