Question

Result from Excel.

I have Weekly sales data for Q1 and Q2. I am tasked in finding which week of Q2 had the biggest increase in total dollars between the same week in Q1. I created 2 tables One for Q1 and one for Q2. 1st I calculated the % increase. I then calculated the Dollar amt. All went well and the data lined up for 3 of my customers. My one customer is showing a larger dollar amount in week 9 but a higher % change in week 7. How is this possible? I have highlighted the numbers in question. Any help is appreciated!

Sum of Dollars Week of Q1 13 Grand Total Customer 1 2 3 4 6 7 9 10 11 12 5463.12 3252.18 CT-5191 4356.12 9614.34 4667.88 4790.64 4783.44 9532.44 8717.46 8407.56 6459.84 5003.16 24000.7 99048.9 3047.94 5598.36 MA-3511 4173.84 14123.4 25316.7 6791.88 4752.36 6565.2 4437.3 5976.78 4874.28 10010.8 5038.92 100707.78 9602.28 12492.6 MA-6693 8460.9 6774.12 7185 13706 6397.62 7785.36 8334.84 8420.22 7494.12 14253.5 6946.26 117852.78 9416.1 9722.22 ME-6399 17230.1 6722.1 7427.1 6176.16 14109.7 8067.36 7161.78 12681.7 10880.5 7723.26 7468.92 124786.98 Grand Total 32220.7 28550.5 442396.44 35327.9 30871.8 44284.92 36288.4 29927.6 27208.6 24595.4 40305.1 32370.1 36990.7 43454.8 Sum of Dollars Week of Q2 10 12 13 Grand Total Customer 2 3 4 6 7 11 6076.2 16417.6 7362.66 8761.8 16225.9 110248.92 CТ-5191 4537.2 3852.42 8385.36 11734,4 10086.3 8617,38 8191.68 12236.2 8542.2 7862.16 98029.92 MA-3511 9335.04 5292.24 8256.78 8317.2 11189.8 6433.44 7758.72 6146.16 6660 14561.8 10336.3 MA-6693 7815.06 7804.98 12477.54 17428.1 6522.66 9157.14 7110.96 12031.6 10109.3 16240.4 131595.78 ME-6399 15297.9 18265.2 9355.38 7840.08 17245.2 12087.1 16184.1 20287.6 29876.3 29089.7 22547.8 19795.2 28590.2 246461.7 Grand Total 44812.5 67716.5 35214.8 28979.6 26927 55705.7 45848.7 60309.5 586336.32 36985.2 36165.9 45889.7 51251.5 50529.7 Wk1 Wk4 wk2 Wk3 Wk5 Wk6 wkz Wk8 Wk9 Wk10 Wk 11 Wk12 Wk13 Customer % change found by = ( B12/B3)-1 18% 2% 27% CT-5191 -17 % 39% -13 % 151% -100% 243% -23% 16% 75% -32 % 8% -39 % 124% -8 % -63% -100% 180% 152% 59% MA-3511 -67% 80% 27% 40% 32% -16% 15% MA-6693 74% 27% 100% 16% 52% 179 10% 61% -29% 134% 172% 50% 209% МЕ6399 -11% 26% 27% 22% 126% 60% 175% 132% 156% 283% Wk2 Wk3 Wk5 Wk6 7066.50 -4790.64 11634.18 -2169.78 -4752.36 1752.00 Wk Wk8 Wk9 Wk10 Wk 11 Wk12 Wk13 Wk1 Wk4 Customer dollar amt found from subtraction CT-5191 -925.92 600.24 1720.08 -1228.98 1368.84 209.82 1731.84 3758.64 -7774.80 B12-B3 5494,26 2263.80 2884.44 -3864.66 1621.08 5161.20 -8831.16 -17059.92 -645.84 1030.86 -1932.18 11543.10 1928.28 1663.92 456.66 MA-3511 5444,28 6752.52 MA-6693 5292.54 3722.16 -6397.62 -1262.70 4959.48 -2156.34 822.30 -1309.26 4537.44-4144.14 9294.12 3135.48 4019.76 9022.32 7605.96 18995.76 19673.58 12825.54 12071.94 21121.26 МЕ6399

Answer 1

beaceatange much posible becaute This is Vey absukute Change Change is 6 ginal value Where Cas is absolut change (o ditfesene Change two values belwiin Fox examph Canides Price of oap ζ(e nas 6ς Paice of Charmpao tíme 1 D0 200 120 235 time 2

1ICA of np foom tmt anl-ol Similady ta hampoo it i-2ar- 003 time 2 is pucintage Change in Pace of Jap When 100-100 20 1 100 100 pencentage Change in Pice of thampao is 35-200 3S foxPrice ofJonp biagh gbrokut change (difunce)imoe ih (ase nake but As yau Can tmat of shamp than is highes of Seap Ovidrog Changr by onginal pice t 7nis be cause diffince kje Ose 35 because shampoo which is 200 2X100 brat of Jhampos is Soa H ths clanies your duubt twice as much as