Spreadsheet: 677389d1589330119-assignment-assistance-formulas-sales-manager-excel-assignment
Sheet: Q1

Item Description | Gross Sales Value (GSV)
 | numbers in thousand(K)
 | 2014 | 2015 | Growth% | Cont.%
HZ. KETCHUP  9 GM 1000 | 27178.97645000032 | 32862.83980000042
HZ. KETCHUP  9 GM 150 BOX - Hot | 1364.684499999989 | 1543.726499999992 |  |  | Question 1: | Please calculate the growth  and the contribution of items in 2015.
HZ. KETCHUP  9 GM 200 BOX | 35595.7258000008 | 41773.37749999932
HZ. Ketchup 20 GM | 349.5256000000009 | 1103.517100000002 |  |  | Question 2: | Metion the top ten items "SKU's" in 2015 and 2014
HZ. Ketchup 50 GM | 0 | 1211.176879999998
HZ. KETCHUP  200 GM | 14316.49448999976 | 17200.72624000009
HZ. KETCHUP  200 GM F.S | 1747.34761 | 1473.82593
HZ. KETCHUP  200 GM-HOT | 5005.97896999998 | 5795.48721000003
HZ. KETCHUP Doya 285 GM | 2134.019129999959 | 5174.817190000064
HZ. KETCHUP  300 GM-HOT | 695.4427100000004 | 922.8977000000014
CATCHY. KETCHUP 335 GM | 2339.13517 | 2589.04366
CATCHY. KETCHUP 335 GM-Hot | 1095.45622 | 1334.34772
HZ. KETCHUP  340 GM | 13356.89045499984 | 14388.22582000015
HZ. KETCHUP  340 GM F.S | 2086.84797 | 1896.70232
AM.  KETCHUP California Garden 340 GM | 65.65038 | 136.56769
HZ. KETCHUP 460 GM | 1359.76764 | 1238.861900000001
HZ. KETCHUP  513 GM | 3523.836900000002 | 3502.16404999997
HZ. KETCHUP 570 GM | 1236.78231 | 1859.59324
HZ. KETCHUP  850 GM | 4591.449810000036 | 4259.640859999978
HZ. KETCHUP 910 GM | 1259.63009 | 1901.74374
HZ. KETCHUP 1.350 KG | 514.7568100000001 | 550.45236
CATCHY. KETCHUP 4.250 KG | 2914.833110000005 | 3370.927540000001
CATCHY. KETCHUP 10 KG | 9392.918899999988 | 9992.184399999986
HZ. KETCHUP  13 KG | 156.19855 | 117.8471
HZ. KETCHUP Doya 285 GM-HOT | 0 | 0
TOTAL TOMATO KETCHUP
HZ. MAYONNAIS 10 GM | 7075.444999999868 | 9306.355400000053
HZ. MAYONNAIS 40 GM | 0 | 1120.571100000004
HZ. MAYONNAIS  180 GM | 5346.970459999996 | 6248.177779999923
HZ. MAYONNAIS Doya 285 GM | 855.7251099999999 | 4547.358869999985
HZ. MAYONNAIS [NAME] 285 GM | 0 | 873.3243299999987
HZ. Mayo Ketchup Doya 285 GM | 0 | 999.0140999999994
HZ. MAYONNAIS  310 GM | 28667.15696999984 | 30639.63867000006
HZ. MAYONNAIS  310 GM -LOW FAT | 3131.021460000017 | 2808.432479999993
HZ. MAYONNAIS KETCHUP 310 GM | 202.9235300000005 | 309.3749800000002
HZ. MAYONNAIS CHILI 310 GM | 156.6930800000005 | 290.30222
HZ. MAYONNAIS [NAME] GM | 37.18081999999995 | 327.99486
HZ. MAYONNAIS TD 400 GM | 706.6103499999997 | 887.7678
HZ. MAYONNAIS  940 GM | 1741.583690000002 | 2261.275390000001
HZ. MAYONNAIS 3.290 KG | 10925.58662999999 | 15765.82489999999
CATCHY. MAYONNAIS 3.75 KG | 0 | 187.7142
AM. MAYONNAIS Coleslaw 8.850 KG | 1417.6654 | 2057.4825
HZ. MAYONNAIS [NAME] 285 GM | 0 | 894.6295799999995
TOTAL MAYONNAISE
HZ. PASTE Pouch 50 GM | 0 | 3829.238699999957
HZ. PASTE 135 GM | 4295.664720000002 | 7036.320699999993
HZ. PASTE 200 GM | 797.5611399999995 | 221.4762900000009
HZ. PASTE 360 GM | 38536.84486999989 | 50665.96544
CATCHY. PASTE 360 GM | 3839.881540000008 | 5110.803489999993
CATCHY. PASTE 360 GM Dist | 1656.96686 | 2857.42949
AM. [NAME] GM | 0 | 0
TOTAL TOMATO PASTE
HZ. MUSTARD  235 GM | 13609.38109499977 | 15827.93278000004
HZ. MUSTARD Doya 285 GM | 0 | 322.1601599999997
HZ. MUSTARD  5 KG | 4403.395600000007 | 5382.5548
TOTAL MUSTARD
HZ. VINEGAR 1/2 LTR | 2343.091519999999 | 2289.15003
HZ. VINEGAR 1 LTR | 18096.50930999982 | 22547.37318000008
TOTAL VINEGAR
[NAME] Tuna 140 GM | 0 | 428.30011
[NAME] Tuna 140 GM | 0 | 344.4579
[NAME] Tuna 170 GM | 0 | 679.29572
Catchy Shreded Hot Tuna 170 GM | 0 | 408.67179
HZ. Fragmented tuna in Sunflower oil 185 GM | 33.96042000000001 | 0
HZ. Light meat tuna cut in water 185 GM | 336.77991 | 207.23051
HZ. Cut tuna in sunflower oil 185 GM | 512.0168299999999 | 546.9010199999999
HZ. One piece of tuna in sunflower oil 185 GM | 686.0101999999999 | 768.3867200000002
TOTAL Meat, [NAME] and Seafood
HZ. BBQ SAUCE 9 GM 1000 | 415.8296 | 460.95062
HZ. BBQ SAUCE 200 GM | 1613.288369999999 | 1950.34324000002
HP.BBQ Sauce 250 GM | 0 | 0
HZ. [NAME] 285 GM | 0 | 0
HZ. BBQ SAUCE 300 GM | 840.9561199999988 | 1114.566669999997
HZ. BBQ SAUCE 500 GM | -0.6700699999999999 | 0
HZ. BBQ SAUCE 5 KG | 1167.842399999999 | 1565.562000000002
HZ. HOT SAUCE 88 GM | 1156.917070000002 | 1548.675259999999
HZ. HOT SAUCE 165 GM | 3941.332819999982 | 4605.446569999979
HZ. HOT SAUCE 5 KG | 946.9458000000005 | 1146.1081
HZ. CHILI SAUCE 195 GM | 760.5946299999983 | 758.4252900000035
HZ. CHILI SAUCE 300 GM | 315.5499100000003 | 252.2383600000002
HZ. Garlic Chili Sauce 300 GM | 358.4760500000004 | 302.3790800000001
HZ.Chilli Sauce GSF Bulk 1 KG | 486.3985 | 249.655
HZ. PIZZA SAUCE 350 GM | 1446.047850000001 | 1807.220960000005
HZ. PIZZA SAUCE 13 KG | 712.9460000000001 | 681.8366
HZ. Harissa 170 GM | 167.2851899999999 | 619.3482300000019
HZ.ABC [NAME] 135 ML Pet | 84.01929999999997 | 0
HZ.ABC [NAME] 600 ML Pet | 0.5292 | 0
HZ.ABC [NAME] 600 ML Pet | 0 | 0
HZ. Worcestershire sauce L&P 150 ML | 3.2674 | 0
HZ.Andalouse Sauce TD 395 GM | 254.9208 | 105.72438
HZ.Tartare Sauce TD 395 GM | 124.35695 | 12.77319
HZ.Cesar TD 400 GM | 73.44996000000006 | 0
HZ.Cocktail Sauce TD 475 GM | 0 | 0
HZ. Soup 400 GM | 0 | 0
HZ. Beans in tomato sauce 415 GM | 0 | 0
HZ.Frite Sauce TD 500 GM | 94.2668 | 0.19074
HZ. TOMATO JUICE 250 GM | 505.31972 | 463.41533
HZ. PASTA SAUCE 365 GM | 1877.98031999999 | 2210.187090000006
HP.Fruity Sauce 255 GM | -1.1304 | 0
HP.Steak Sauce 255 GM | 0 | 0
HZ.PASTA | 163.13057 | 0
HZ. HOT SAUCE  Premium 165  GM | 0 | 113.9816999999999
TOTAL OTHERS
Grand Total