% CHANGE FORMULA - A 3-STEP PROCESS Step #1: PV YEAR - BASE YEAR = X Step #1: X
ID: 2913165 • Letter: #
Question
% CHANGE FORMULA - A 3-STEP PROCESS Step #1: PV YEAR - BASE YEAR = X Step #1: X / BASE YEAR = Y Step #3: Y multipied by 100 = % Change 2014 SALES (ACTUAL "Category" 2015 SALES (ACTUAL 2016 SALES (ACTUAL 2017 SALES (ACTUAL) "Brand "Category" W 18-49 Sales "Category" W 18-49 Sales "Brand" W 18-49 Sales "Category" W 18-49 Sales "Brand" "Brand" TV DMA NORTH CAROLINA Charlotte Greensboro Raleigh-Durham W 18-49 Sales W 18-49 Sales W 18-49 Sales W 18-49 Sales $ 1,137,120.00 $ 238,795.00 5.00 1,163,273.76 249,540.78 $ 1,186,539.24 272,498.53 $ 1,213,236.37 $ 281,490.98 $ 590,495.00$ 183,053.00 $ 558,017.78 182,686.89 570,294.17 $ 188,715.56 571,662.87 195,641.42 $ 910,966.20227,072.58$920,986.82 234,361.61 932,314.96 $ 243,267.36 NC. TOTAI SALFS$2,606,926.00 632,882.00$2,632,257.73 659,300.25 2,677,820.23 695,575.70 2,717,214.20 $ 720,399.76 879,311.00211,034.00 SOUTH CAROLINA Charlestorn Columbia Greenville Myrtle Beach $ 298,932.00$83,701.00 $ 295,942.68 82,69659 $302,453.42 83,606.25$ 309,198.13 $ 86,281.65 $ 291,465.90 $97,436.14 291,757.37 99,969.48 $ 298,205.20 $ 103,068.53 $ 241,286.70 $ 5,6245247,318.87 87,979.24 257,458.94 $90,803.37 261,484.006406300 255,469.87 62,461.43258,407.77 63,198.47 264,506.19 67,306.37 SC.TOTAL SALFS$1,106,452.00 331,512.00 $ 1,084,165.15 328,218.711,099,937.42 334,753.43 1,129,368.47 $ 347,459.92 292,05 0.00 96,376.00 253,986.0087,372.00Explanation / Answer
1)(720399-632882)/632882 *100% = 13.82%
2)(241286-253986)/253986*100% = -5.00%
3)(188715-182686)/182686*100% =3.30%
4)(63198-64063)/64063*100%= -1.35%
5)(1213236-1137120)/1137120*100%=6.69%
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.