{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["May Slides","October Pipeline Internal Full","July Slides","June Pipeline","FC3 R&O Schedule","Act v FC3","Act v FC2","FC3","Final Format","List","Column descriptions","data"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":4,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"May Slides","index":0,"n_rows":91,"n_cols":5,"rows_kept":91,"cut":false,"hidden":true,"merged":[[50,1,50,4],[1,1,1,4],[36,1,36,4]]}
[]
[null,"Full Year Gains & Losses FC2 v Budget"]
[]
[null,"2015 Budget",147930,23876,0.16140066247549517]
[]
[null,"Gains","Net Sales £000’s","£ GP2","% GP2"]
[null,"Australia",5511,1056,0.19161676646706588]
[null,"Co-Op (Loved by Us Range)",1156,210,0.18166089965397925]
[null,"Internal (USA, Germany, Korea & Denmark)",1082,356,0.32902033271719039]
[null,"Aryzta",985,-56,-5.685279187817259E-2]
[null,"Lidl (Pain Choc)",538,-99,-0.18401486988847585]
[null,"M&S",410,111,0.27073170731707319]
[null,"Greene King",367,42,0.11444141689373297]
[null,3663,323,191,0.59133126934984526]
[null,"TRG",321,176,0.54828660436137067]
[null,"Greggs",134,45,0.33582089552238809]
[null,"Total Gains",10827,2032,0.1876789507712201]
[null,"Losses","Net Sales £000’s","£ GP2","% GP2"]
[null,"Tesco (Ranging & Delists)",-6081,-2267,0.37280052622923859]
[null,"KFC (Brioche & DWS)",-2468,-987,0.39991896272285249]
[null,"Lidl (H&S Roll)",-2171,-427,0.1966835559649931]
[null,"Asda (Danish)",-1322,-310,0.23449319213313161]
[null,"Other",-531,-258,0.48587570621468928]
[null,"South Africa",-523,-119,0.22753346080305928]
[null,"Morrisons",-490,70,-0.14285714285714285]
[null,"Hopwells",-340,-107,0.31470588235294117]
[null,"JDW",-335,76,-0.22686567164179106]
[null,"Aldi",-252,-50,0.1984126984126984]
[null,"Brakes",-168,-334,1.9880952380952381]
[null,"Total Losses",-14681,-4713,0.3210271779851509]
[]
[null,"Net Movement",-3854,-2681,0.69564089257913853]
[]
[null,"2015 FC2 (GL)",144076,21195,0.14710985868569365]
[]
[]
[null,"Summary R&O to FC2"]
[]
[null,"Opportunities","Net Sales £000’s","£ GP2","% GP2"]
[null,"Morrisons (2nd Seasonal Line)",84,12,0.14285714285714285]
[null,"Greene King (Brioche Hot Dog Roll)",13.333333333333334,2.8,0.20999999999999996]
[null,"Total Opportunity",97.333333333333329,14.8,0.15205479452054796]
[null,"Risks","Net Sales £000’s","£ GP2","% GP2"]
[null,"Lidl (MPP)",-327,-48.1,0.14709480122324159]
[null,"FSC Tender",-145.89999999999998,-32.9,0.225496915695682]
[null,"Total Risk",-472.9,-81,0.17128356946500317]
[]
[null,"Net Movement",-375.56666666666666,-66.2,0.17626697434987132]
[]
[]
[null,"Total Full Year R&O Impact"]
[]
[null,"2015 Budget",147930,23876,0.16140066247549517]
[]
[null,"Opportunities","Net Sales £000’s","£ GP2","% GP2"]
[null,"Australia",5511,1056,0.19161676646706588]
[null,"Co-Op (Loved by Us Range)",1156,210,0.18166089965397925]
[null,"Internal (USA, Germany, Korea & Denmark)",1082,356,0.32902033271719039]
[null,"Aryzta",985,-56,-5.685279187817259E-2]
[null,"Lidl (Pain Choc)",538,-99,-0.18401486988847585]
[null,"M&S",410,111,0.27073170731707319]
[null,"Greene King",367,42,0.11444141689373297]
[null,3663,323,191,0.59133126934984526]
[null,"TRG",321,176,0.54828660436137067]
[null,"Greggs",134,45,0.33582089552238809]
[null,"Morrisons (2nd Seasonal Line)",84,12,0.14285714285714285]
[null,"Greene King (Brioche Hot Dog Roll)",13.333333333333334,2.8,0.20999999999999996]
[null,"Total Opportunity",10924.333333333334,2046.8,0.18736154761541512]
[null,"Risks","Net Sales £000’s","£ GP2","% GP2"]
[null,"Tesco (Ranging & Delists)",-6081,-2267,0.37280052622923859]
[null,"KFC (Brioche & DWS)",-2468,-987,0.39991896272285249]
[null,"Lidl (H&S Roll)",-2171,-427,0.1966835559649931]
[null,"Asda (Danish)",-1322,-310,0.23449319213313161]
[null,"Other",-531,-258,0.48587570621468928]
[null,"South Africa",-523,-119,0.22753346080305928]
[null,"Morrisons",-490,70,-0.14285714285714285]
[null,"Hopwells",-340,-107,0.31470588235294117]
[null,"JDW",-335,76,-0.22686567164179106]
[null,"Aldi",-252,-50,0.1984126984126984]
[null,"Brakes",-168,-334,1.9880952380952381]
[null,"Lidl (MPP)",-327,-48.1,0.14709480122324159]
[null,"FSC Tender",-145.89999999999998,-32.9,0.225496915695682]
[null,"Total Risk",-15153.9,-4794,0.31635420584799956]
[]
[null,"Net Movement",-4229.5666666666657,-2747.2,0.64952280375452187]
[]
[null,"2014 FC3 (GL)",143700.43333333335,21128.799999999999,0.14703365543086971]
[]
[null,"2014 FC2 (GL)",144076,21195,0.14710985868569365]
[]
[null,"Movement",-375.56666666665114,-66.200000000000728,0.17626697434988053]

{"sheet":"October Pipeline Internal Full","index":1,"n_rows":43,"n_cols":18,"rows_kept":43,"cut":false,"hidden":true,"merged":[[1,1,1,4]]}
[]
[null,"Pipeline"]
[null,"As identified at 31st October 2015"]
[]
[null,"Opportunities","Net Sales £000’s","GP1 £000's","GP1 %","Probability %","Budget","FC3","Launch Date","Volume Pieces","Tonnage","Piece Weight (g)","NPD","Forecasted SO99","Product Category","Product(s)","Production Site","Comments"]
[null,"Morrisons",100,15,{"$f":"+D6/C6","v":0.15},1,"N","N","Jan",500000,{"$f":"SUM(J6*L6)/1000000","v":45},90,"N","Y","French and Danish Pastry","Various","LUB / BD","Additional volume Q1 only"]
[null,"Aldi",150,18,0.12,1,"N","N","Jan",790000,71.099999999999994,90,"N","Y","Wheat Bread and Danish Pastry","Kaiser Roll and Danish Lattice","KL / BD","Aldi store trial - AYR business value"]
[null,"Peacocks",150,45,0.3,1,"N","N","Jan",680000,61.2,90,"N","N","Various","Bread and Sweet Pastry","MK / BD / LUB","Additional business secured across 7 STD LUUK products."]
[null,"Asda",100,20,0.2,0.75,"N","N","Jan",415000,39.424999999999997,95,"N","N","Danish Pastry","Chocolate Danish","BD","Opportunity to launch as a trial and long term if a success"]
[null,"Spirit Group",500,60,0.12,0.5,"N","N","Mar",5500000,412.5,75,"Y","N","Fast Food Bread","Brioche","MK","New business target"]
[null,"Pret a Manger",2500,560,{"$f":"+D11/C11","v":0.224},0.05,"N","N","Mar",10500000,{"$f":"SUM(J11*L11)/1000000","v":945},90,"Y","N","French Pastry","Chocolate and Almond Croissants","LUB","Products currently supplied by Deli-France"]
[null,"Cooperative",150,37.5,0.25,0.6,"N","N","Sept",625000,61.25,98,"Y","N","Danish Pastry","Raspberry Crown","BD","New business target - Co-op range extension"]
[null,"Vestey Foods",300,24,0.08,1,"N","N","Jan",2000000,150,75,"N","Y","Fast Food Bread & Cake/Soft Dough","Hot Dog Roll & Donuts","MK / EP","New business"]
[null,"TRG",250,50,0.2,0.5,"N","N","Feb",2000000,190,95,"Y","N","Fast Food Other","Tortilla Pucks","MK","New business"]
[null,"Greene King",300,54,0.18,0.7,"N","N","Mar",2300000,264.5,115,"N","N","Wheat Bread   ","Express baguette & Ciabatta roll","MK","New business"]
[null,"Country Range",500,148,0.29599999999999999,0.6,"N","N","Jan",7250000,652.5,90,"N","N","Fast Food Bread","Floured Bap","MK","PL business currently supplied by Kara"]
[null,"Booker",100,24,0.24,0.5,"N","N","Apr",900000,81,90,"N","N","Danish Pastry","Royal Danish Selection","MK","New business"]
[null,"Booker",50,12.5,0.25,0.15,"N","N","Apr",415000,33.200000000000003,80,"N","N","Fast Food Bread","Brioche HDR","MK","New business"]
[null,"Australia"]
[null,"Woolworths",3000,{"$f":"+C20*0.23","v":690},{"$f":"+D20/C20","v":0.23},0.7,"N","N","2016-01-01",9000000,810,90,"N","N","French Pastry/Danish","Squares, Pain Choc, Pain Raisin","LUB/BD","Incremental Business (LUB, LUUK)"]
[null,"South Africa"]
[null,"Nando's",160,67,{"$f":"+D22/C22","v":0.41875000000000001},0.2,"N","N","2016-06-01",600000,54,90,"N","N","Other Sweet","PCT","Panpor","Quoted on new business.  PCT main area of interest  "]
[null,"KFC",98,41,{"$f":"+D23/C23","v":0.41836734693877553},0.2,"N","N","2016-06-01",900000,67.5,75,"N","N","Fast Food Bread","Burger Buns","MK","Quoted on new business.  Assuming 2 Buns"]
[null,"Bidvest",50,21,{"$f":"+D24/C24","v":0.42},0.3,"N","N","2016-03-01",440000,33,75,"N","N","Fast Food Bread","Burger Buns and Hot Dog Rolls","MK","Range of fast food breads to be presented."]
[null,"Woolworths",40,6,{"$f":"+D25/C25","v":0.15},0.8,"N","Y","2016-03-01",150000,13.5,90,"N","N","Other Sweet","FRE Portuguese Custard Tart","Panpor","PCT to be relisted now it's FRE"]
[null,"New Zealand",2000,500,{"$f":"+D26/C26","v":0.25},0.3,"N","N","2016-05-01",6000000,540,90,"N","N","French Pastry/Danish","Crowns, Plaits, Croissants","LUB / BD","New business"]
[null,"Internal"]
[null,"Germany",13,{"$f":"+C28*0.025","v":0.32500000000000001},{"$f":"+D28/C28","v":2.5000000000000001E-2},1,"N","N","2015-12-01",{"$f":"40*56*5*12","v":134400},{"$f":"SUM(J28*L28)/1000000","v":14.784000000000001},110,"N","N","Wheat Bread","7105 - Grill Marked Panini"]
[null,"Korea",{"$f":"+J29/120*10/1000","v":360},{"$f":"+C29*0.12","v":43.199999999999996},{"$f":"+D29/C29","v":0.11999999999999998},0.75,"N","N","2016-03-01",{"$f":"2160000*2","v":4320000},194.4,45,"N","N","Danish Pastry","Minis x2"]
[null,"Denmark",{"$f":"6.25*4.97","v":31.0625},{"$f":"+C30*0.025","v":0.77656250000000004},{"$f":"+D30/C30","v":2.5000000000000001E-2},0.9,"N","N","2016-01-01",{"$f":"6250*48","v":300000},22.5,75,"N","N","Fast Food Bread","Americana Brioche Hotdog Roll"]
[null,"Total Op",{"$f":"SUM(C6:C30)","v":10902.0625},{"$f":"SUM(D6:D30)","v":2437.3015624999998},{"$f":"+D31/C31","v":0.22356334523857296},null,null,null,null,{"$f":"SUM(J6:J30)","v":55719400},{"$f":"SUM(K6:K30)","v":4756.3589999999986}]
[null,"Risks","Net Sales £000’s","GP1 £000's","GP1 %","Probability %","Budget","FC3","De-list Date","Volume Pieces","Tonnage","Piece Weight (g)","NPD","Forecasted SO99","Product Category","Product(s)","Production Site","Comments"]
[null,"The Co-operative",-500,-100,{"$f":"+D33/C33","v":0.2},1,"Y","N","Jan",-2000000,{"$f":"SUM(J33*L33)/1000000","v":-180},90,"N","Y","Danish Pastry","Cinnamon Swirl","BD","Lost business on quality"]
[null,"Costco",-80,-26,0.32500000000000001,1,"Y","N","Jan",-570000,-42.75,75,"N","Y","Fast Food Bread","Brioche","MK","Now a rotation line rather than AYR listing"]
[null,"Iceland",-200,-44,0.22,1,"Y","N","Mar",-1350000,-101.25,75,"Y","N","Fast Food Bread","Brioche","MK","Incremental Business - Premium bun offer"]
[null,"KFC France",-200,-60,0.3,0.5,"Y","N","May",-2500000,-187.5,75,"Y","N","Fast Food Bread","Bun","MK","LTO"]
[null,"Lidl",-1300,-481,0.37,0.4,"Y","N","Jan",-6720000,-638.4,95,"N","N","Danish Pastry","Maple Pecan Plait","BD","Risk of not winning back business"]
[null,"Marks & Spencers",-350,-120,0.34285714285714286,1,"Y","N","Jan",-800000,-72,90,"N","Y","Danish Pastry","Raspberry & Lemon Fan","LUD","Seasonal line replaced"]
[null,"Peters",-417,6,-1.4388489208633094E-2,1,"Y","N","Jan",-3100000,-279,90,"N","Y","Wheat Bread","French bread and Panini","MK","Lost on price"]
[null,"Tesco",-3300,-916,0.27757575757575759,1,"Y","N","March",-17500000,-1750,100,"N","Y","Wheat Bread","Ciabatta loaf and roll","LUB","Lost on price and product"]
[null,"Total Risk",{"$f":"SUM(C33:C40)","v":-6347},{"$f":"SUM(D33:D40)","v":-1741},{"$f":"+D41/C41","v":0.27430282023002994},null,null,null,null,{"$f":"SUM(J33:J40)","v":-34540000},{"$f":"SUM(K33:K40)","v":-3250.9}]
[]
[null,"Net Movement",{"$f":"+C31+C41","v":4555.0625},{"$f":"+D31+D41","v":696.30156249999982},{"$f":"+D43/C43","v":0.1528632290994909},null,null,null,null,{"$f":"SUM(J31+J41)","v":21179400},{"$f":"SUM(K31+K41)","v":1505.4589999999985}]

{"sheet":"July Slides","index":2,"n_rows":55,"n_cols":5,"rows_kept":55,"cut":false,"hidden":true,"merged":[[1,1,1,4],[36,1,36,4]]}
[]
[null,"Full Year Gains & Losses FC2 v Budget"]
[]
[null,"2015 Budget (GL)",147930,23876,0.16140066247549517]
[]
[null,"Gains","Net Sales £000’s","£ GP2","% GP2"]
[null,"Australia",6435,995,0.15462315462315462]
[null,"Lidl (Pain Choc)",1761,112,6.3600227143668364E-2]
[null,"Internal (USA, Germany, Korea & Denmark)",1482,366,0.24696356275303644]
[null,"Co-Op (Loved by Us Range)",1156,210,0.18166089965397925]
[null,"Aryzta",985,-56,-5.685279187817259E-2]
[null,"M&S",410,111,0.27073170731707319]
[null,"Greene King",367,42,0.11444141689373297]
[null,3663,323,191,0.59133126934984526]
[null,"TRG",282,137,0.48581560283687941]
[null,"Greggs",134,45,0.33582089552238809]
[null,"Total Gains",13335,2153,0.16145481814773152]
[null,"Losses","Net Sales £000’s","£ GP2","% GP2"]
[null,"Tesco (Ranging & Delists)",-5637,-2273,0.40322866773106264]
[null,"Lidl (H&S Roll & Pain Raisin)",-3393,-688,0.20277040966696139]
[null,"KFC (Brioche & DWS)",-2368,-944,0.39864864864864863]
[null,"Asda (Danish)",-1322,-310,0.23449319213313161]
[null,"Morrisons",-603,-27,4.4776119402985072E-2]
[null,"South Africa",-524,-27,5.1526717557251911E-2]
[null,"Hopwells",-340,-107,0.31470588235294117]
[null,"JDW",-335,76,-0.22686567164179106]
[null,"Aldi",-252,-50,0.1984126984126984]
[null,"Brakes",-168,-334,1.9880952380952381]
[null,"Other",-110,-198,1.8]
[null,"Total Losses",-15052,-4882,0.32434228009566834]
[]
[null,"Net Movement",-1717,-2729,1.5894001164822364]
[]
[null,"2015 FC2 (GL)",146213,21147,0.14463146231867208]
[]
[]
[null,"Summary R&O to FC2"]
[]
[null,"Opportunities","Net Sales £000’s","£ GP2","% GP2"]
[null,"Lidl (VCC)",474,89,{"$f":"+D40/C40","v":0.18776371308016879}]
[null,"Tesco",600,92,{"$f":"+D41/C41","v":0.15333333333333332}]
[null,"Other",85,10,{"$f":"+D42/C42","v":0.11764705882352941}]
[null,"Morrisons",190,18,9.4736842105263161E-2]
[null,"Greene King (Brioche Hot Dog Roll)",13.333333333333334,2.8,0.20999999999999996]
[null,"Total Opportunity",{"$f":"SUM(C40:C44)","v":1362.3333333333333},{"$f":"SUM(D40:D44)","v":211.8},{"$f":"+D45/C45","v":0.15546855884511868}]
[null,"Risks","Net Sales £000’s","£ GP2","% GP2"]
[null,"Australia",-344,-68,{"$f":"+D47/C47","v":0.19767441860465115}]
[null,"Other",-91,-55,{"$f":"+D48/C48","v":0.60439560439560436}]
[null,"South Africa",-73,-20,{"$f":"+D49/C49","v":0.27397260273972601}]
[null,"Hopwells",-47,-3,6.3829787234042548E-2]
[null,"Lidl (MPP)",-327,-48.1,0.14709480122324159]
[null,"FSC Tender",-100,-100,1]
[null,"Total Risk",{"$f":"SUM(C47:C52)","v":-982},{"$f":"SUM(D47:D52)","v":-294.10000000000002},{"$f":"+D53/C53","v":0.29949083503054991}]
[]
[null,"Net Movement",{"$f":"+C45+C53","v":380.33333333333326},{"$f":"+D45+D53","v":-82.300000000000011},{"$f":"+D55/C55","v":-0.21638913234005266}]

{"sheet":"June Pipeline","index":3,"n_rows":42,"n_cols":15,"rows_kept":42,"cut":false,"hidden":true,"merged":[[1,1,1,4]]}
[]
[null,"2015 Sales Pipeline"]
[]
[null,"Opportunities","Net Sales £000’s","GP1 £000's","GP1 %","Probability %","FC2","Launch Date","Volume Pieces","NPD","Forecasted SO99","Product Category","Product(s)","Production Site","Comments"]
[null,"Lidl",3000,660,{"$f":"+D5/C5","v":0.22},0.6,"Y","October",10000000,"Y","N","Danish Pastry","Hero Maple Pecan Plait","BD","Possible alternative to existing MPP "]
[null,"Pret a Manger",2500,560,0.224,0.45,"N","September",10500000,"Y","N","French Pastry","Chocolate and Almond Croissants","LUB","Products currently supplied by Deli-france"]
[null,"Joe & the Juice",1175,29.375,2.5000000000000001E-2,0.4,"N","September",9000000,"Y","N","Wheat Bread","Ciabatta shaped product","MK","Incremental Business. Majority of volume subject to ICP"]
[null,"Lidl",630,150,0.23809523809523808,0.5,"N","July",3600000,"Y","N","Danish Pastry","NPD - TBC","BD","Replacement for Vanilla Crème Crown"]
[null,"Tyneside",600,72,0.12,0.6,"Y","June",6000000,"N","N","Wheat Bread","Demi Baguette","MK","Product currently supplied by Gallaghers (Aryzta)"]
[null,"Country Range",500,148,0.29599999999999999,0.4,"N","September",7250000,"N","N","Fast Food Bread","Floured Bap","MK","PL business currently supplied by Kara"]
[null,"Tesco",500,60,0.12,0.6,"Y","September",1300000,"Y","N","Savoury","Savoury turnovers","Klemme","Savoury range extension WK33 REVIEW"]
[null,"Marks & Spencers",350,120,0.34285714285714286,0.7,"Y","September",735000,"N","N","Danish Pastry","Raspberry & Lemon Fan","LUD","Successful Seasonal ranging - Maybe ranged permanantely"]
[null,"IKEA",270,75,0.27777777777777779,0.5,"N","July",4400000,"N","N","Fast Food Bread","Hot Dog Roll","MK","Transfer of Brakes volume to direct supply"]
[null,"KFC ",250,50,0.2,0.5,"N","Aug",3000000,"Y","N","Fast Food Bread","Bun","MK","Value offering"]
[null,"Iceland",200,44,0.22,0.4,"N","September",1350000,"N","N","Fast Food Bread","Brioche","MK","Incremental Business - Premium bun offer"]
[null,"Asda",200,24,0.12,0.35,"N","October",570000,"N","N","Savoury","Cheese Twist, Swirly","Klemme","Savoury range review opportunity - New to Asda"]
[null,"TRG ",100,30,0.3,0.9,"Y","May",900000,"Y","N","Fast Food Bread","Burger Bun","MK","Incremental Business with Frankie & Bennies"]
[null,"Odeon Cinema",100,28,0.28000000000000003,0.4,"N","September",1250000,"N","N","Fast Food Bread","Hot Dog Roll","MK","Tender process"]
[null,"Booker",100,24,0.24,0.3,"N","September",900000,"Y","N","Wheat Bread","Dinner Roll Selection","MK","Range Extension "]
[null,"Booker",50,12.5,0.25,0.15,"N","September",415000,"Y","N","Wheat Bread","NPD - TBC","MK","Incremental Business"]
[null,"Australia"]
[null,"Coles",1800,468,{"$f":"+D22/C22","v":0.26},0.9,"Y","August",6000000,"N","N","French Pastry/Danish","Filled Croissants, Fans","LUB/BD","Incremental Business (LUB, LUUK Cookie Creations)"]
[null,"Woolworths",1500,351,{"$f":"+D23/C23","v":0.23400000000000001},0.5,"N","October",4500000,"N","N","French Pastry/Danish","Squares, Pain Choc, Pain Raisin","LUB/BD","Incremental Business (LUB, LUUK)"]
[null,"South Africa"]
[null,"SPAR",220,92,{"$f":"+D25/C25","v":0.41818181818181815},0.2,"N","September",2850000,"N","N","French Pastry/Danish","Croissant, VCC, Pain Chocolat","LUB/BD","Quoted on new business.  Assuming 3 new lines"]
[null,"Nando's",160,67,{"$f":"+D26/C26","v":0.41875000000000001},0.2,"N","September",600000,"N","N","Other Sweet","PCT","Panpor","Quoted on new business.  PCT main area of interest  "]
[null,"KFC",98,41,{"$f":"+D27/C27","v":0.41836734693877553},0.2,"N","September",900000,"N","N","Fast Food Bread","Burger Buns","MK","Quoted on new business.  Assuming 2 Buns"]
[null,"Bidvest",50,21,{"$f":"+D28/C28","v":0.42},0.3,"N","September",440000,"N","N","Fast Food Bread","Burger Buns and Hot Dog Rolls","MK","Range of fast food breads to be presented."]
[null,"Woolworths",40,6,0.06,0.8,"Y","September",150000,"N","N","Other Sweet","FRE Portuguese Custard Tart","Panpor","PCT to be relisted now it's FRE"]
[null,"Internal"]
[null,"LUB",82,null,{"$f":"+D31/C31","v":0},0.1,"Y","September",875000,"Y","N","Danish Pastry","Mini Mania","BD","Incremental Business (LUB) - launch in LUB new brochure"]
[null,"LUB",75,null,{"$f":"+D32/C32","v":0},0.25,"Y","June",800000,"N","N","Fast Food Bread","Americana Brioche Bun","MK","Incremental Business (LUB)"]
[null,"LUD",52,null,{"$f":"+D33/C33","v":0},0.2,"Y","September",840000,"N","Y","Danish Pastry","Mini Cinnamon Swirl","BD","Incremental Business (LUD) - New customer in Japan"]
[null,"LUD",52,null,{"$f":"+D34/C34","v":0},0.2,"Y","September",840000,"N","Y","Danish Pastry","Mini Vanilla Crème Crown","BD","Incremental Business (LUD) - New customer in Japan"]
[null,"Total Op",{"$f":"SUM(C5:C34)","v":14654},{"$f":"SUM(D5:D34)","v":3132.875},{"$f":"+D35/C35","v":0.21378975023884264},null,null,null,{"$f":"SUM(I5:I34)","v":79965000}]
[null,"Risks","Net Sales £000’s","GP1 £000's","GP1 %","Probability %",null,"De-list Date","Volume Pieces"]
[null,"Lidl",-630,-185,{"$f":"+D37/C37","v":0.29365079365079366},0.9,"Y","July",-3600000,null,"Y","Danish Pastry","Vanilla Crème Crown","BD","High Waste"]
[null,"Creed",-150,-57,{"$f":"+D38/C38","v":0.38},0.3,"N","July",-1500000,null,"N","Wheat Bread","Small Grill Marked Panini","MK","E-auction"]
[null,"Booker",-50,-11,{"$f":"+D39/C39","v":0.22},0.5,"N","Aug",-300000,null,"N","Other Fast Food","Dough Pucks","MK","Range rationalisation"]
[null,"Total Risk",{"$f":"SUM(C37:C39)","v":-830},{"$f":"SUM(D37:D39)","v":-253},{"$f":"+D40/C40","v":0.30481927710843376},null,null,null,{"$f":"SUM(I37:I39)","v":-5400000}]
[]
[null,"Net Movement",{"$f":"+C35+C40","v":13824},{"$f":"+D35+D40","v":2879.875},{"$f":"+D42/C42","v":0.20832429108796297},null,null,null,{"$f":"SUM(I35+I40)","v":74565000}]

{"sheet":"FC3 R&O Schedule","index":4,"n_rows":93,"n_cols":37,"rows_kept":93,"cut":false,"hidden":true,"merged":[[41,28,41,31],[39,28,39,31],[39,33,39,36],[41,33,41,36],[3,1,3,4],[39,23,39,26],[41,18,41,21],[42,10,42,12],[42,14,42,16],[42,2,42,4],[42,6,42,8],[39,1,39,16]]}
[]
[null,"Commerical 2014 Gains & Losses & FC3 R&O"]
[]
[null,"Full Year Gains & Losses FC3 v Budget"]
[]
[null,"2014 Budget",153932,25851,{"$f":"+D6/C6","v":0.16793779071278228}]
[]
[null,"Gains","Net Sales £000’s","£ GP1","% GP1"]
[null,"Lidl",3655,715,{"$f":"+D9/C9","v":0.19562243502051985}]
[null,"New Brioche",1794,424,{"$f":"+D10/C10","v":0.23634336677814938}]
[null,"Bookers",708,122,{"$f":"+D11/C11","v":0.17231638418079095}]
[null,"Asda",540,95,0.17592592592592593]
[null,"New Puff Pastry",493,43,8.7221095334685597E-2]
[null,"KFC Water Split & Mini Fillet",358,58,0.16201117318435754]
[null,"KFC Brioche",297,76,0.25589225589225589]
[null,"LU USA Additional Danish Pastry",250,24,9.6000000000000002E-2]
[null,"Total Gains",{"$f":"SUM(C9:C16)","v":8095},{"$f":"SUM(D9:D16)","v":1557},{"$f":"+D17/C17","v":0.19234095120444719}]
[null,"Losses","Net Sales £000’s","£ GP1","% GP1"]
[null,"Australia",-4241,-1418,{"$f":"+D19/C19","v":0.33435510492808301}]
[null,"Morrison’s",{"$f":"-2135-350","v":-2485},{"$f":"-231-80","v":-311},{"$f":"+D20/C20","v":0.12515090543259558}]
[null,"Asda Danish",-1956,70,{"$f":"+D21/C21","v":-3.5787321063394682E-2}]
[null,"Tesco (Ranging & Delists)",{"$f":"-1361-100-873","v":-2334},{"$f":"-50-421","v":-471},0.20179948586118251]
[null,"Pret A Manger (FP)",-1052,-309,0.29372623574144485]
[null,"Pricing (Various Customers)",-991,-991,1]
[null,"Saudi Arabia",-616,-209,0.3392857142857143]
[null,"Co-Op",-591,-167,0.28257191201353637]
[null,3663,-560,-284,0.50714285714285712]
[null,"Other",{"$f":"-489-73","v":-562},{"$f":"-53","v":-53},9.4306049822064059E-2]
[null,"KFC Europe & GB",-445,-45,0.10112359550561797]
[null,"LU USA",-313,-30,9.5846645367412137E-2]
[null,"EAT",-305,-82,0.26885245901639343]
[null,"Costco",-198,-195,0.98484848484848486]
[null,"Total Losses",{"$f":"SUM(C19:C32)","v":-16649},{"$f":"SUM(D19:D32)","v":-4495},{"$f":"+D33/C33","v":0.26998618535647789}]
[]
[null,"Net Movement",{"$f":"+C17+C33","v":-8554},{"$f":"+D17+D33","v":-2938},{"$f":"+D35/C35","v":0.34346504559270519}]
[]
[null,"2014 FC3 (GL)",{"$f":"+C6+C17+C33","v":145378},{"$f":"+D6+D17+D33","v":22913},{"$f":"+D37/C37","v":0.15760981716628375}]
[]
[]
[null,"R&O to FC3",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Full Year R&O Impact",null,null,null,null,"Sept to Dec Impact - Total",null,null,null,null,"Sept to Dec Impact - Principal"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Summary R&O to FC3",null,null,null,null,"2014 Budget",153932,25851,{"$f":"+Z42/Y42","v":0.16793779071278228},null,"Summary R&O to FC2",null,null,null,null,"Summary R&O to FC2"]
[null,null,"Sept Act",null,null,null,"Oct FC3",null,null,null,"Nov FC3",null,null,null,"Dec FC3"]
[null,"Opportunities","Net Sales £000’s","£ GP1","% GP1",null,"Net Sales £000’s","£ GP1","% GP1",null,"Net Sales £000’s","£ GP1","% GP1",null,"Net Sales £000’s","£ GP1","% GP1",null,"Opportunities","Net Sales £000’s","£ GP1","% GP1",null,"Opportunities","Net Sales £000’s","£ GP1","% GP1",null,"Opportunities","Net Sales £000’s","£ GP1","% GP1",null,"Opportunities","Net Sales £000’s","£ GP1","% GP1"]
[null,"Lidl",89,12,{"$f":"+D45/C45","v":0.1348314606741573},null,107,27,{"$f":"+H45/G45","v":0.25233644859813081},null,56,13,{"$f":"+L45/K45","v":0.23214285714285715},null,65,17,{"$f":"+P45/O45","v":0.26153846153846155},null,{"$f":"+B9","v":"Lidl"},{"$f":"+C45+G45+K45+O45","v":317},{"$f":"+D45+H45+L45+P45","v":69},{"$f":"+U45/T45","v":0.21766561514195584},null,{"$f":"+B9","v":"Lidl"},{"$f":"+C9+T45","v":3972},784,{"$f":"+Z45/Y45","v":0.1973816717019134},null,{"$f":"+S45","v":"Lidl"},{"$f":"+C45+G45+K45+O45","v":317},{"$f":"+D45+H45+L45+P45","v":69},{"$f":"+AE45/AD45","v":0.21766561514195584},null,{"$f":"+X45","v":"Lidl"},{"$f":"+AD45","v":317},{"$f":"+AE45","v":69},{"$f":"+AJ45/AI45","v":0.21766561514195584}]
[null,"New Brioche",null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"},null,"New Brioche",{"$f":"+C46+G46+K46+O46","v":0},{"$f":"+D46+H46+L46+P46","v":0},{"$f":"+U46/T46","v":{"$error":"#DIV/0!"}},null,"New Brioche",1794,424,{"$f":"+Z46/Y46","v":0.23634336677814938},null,{"$f":"+S46","v":"New Brioche"},0,0,{"$f":"+AE46/AD46","v":{"$error":"#DIV/0!"}},null,{"$f":"+X46","v":"New Brioche"},{"$f":"+AD46","v":0},{"$f":"+AE46","v":0},{"$f":"+AJ46/AI46","v":{"$error":"#DIV/0!"}}]
[null,"Bookers",null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"},null,40,13,0.32500000000000001,null,"Bookers",40,13,{"$f":"+U47/T47","v":0.32500000000000001},null,"Bookers",748,135,{"$f":"+Z47/Y47","v":0.18048128342245989},null,"Bookers",40,13,{"$f":"+AE47/AD47","v":0.32500000000000001},null,"Bookers",{"$f":"+AD47","v":40},{"$f":"+AE47","v":13},{"$f":"+AJ47/AI47","v":0.32500000000000001}]
[null,"Asda",null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"},null,"Asda",0,0,{"$error":"#DIV/0!"},null,"Asda",540,95,0.17592592592592593,null,"Asda",0,0,{"$error":"#DIV/0!"},null,"Asda",0,0,{"$error":"#DIV/0!"}]
[null,"New Puff Pastry",null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"},null,"New Puff Pastry",0,0,{"$error":"#DIV/0!"},null,"New Puff Pastry",493,43,8.7221095334685597E-2,null,"New Puff Pastry",0,0,{"$error":"#DIV/0!"},null,"New Puff Pastry",0,0,{"$error":"#DIV/0!"}]
[null,"KFC Water Split & Mini Fillet",null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"},null,"KFC Water Split & Mini Fillet",0,0,{"$error":"#DIV/0!"},null,"KFC Water Split & Mini Fillet",358,58,0.16201117318435754,null,"KFC Water Split & Mini Fillet",0,0,{"$error":"#DIV/0!"},null,"KFC Water Split & Mini Fillet",0,0,{"$error":"#DIV/0!"}]
[null,"KFC Brioche",200,60,0.3,null,null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"},null,"KFC Brioche",200,60,0.3,null,"KFC Brioche",497,136,0.27364185110663986,null,"KFC Brioche",200,60,0.3,null,"KFC Brioche",200,60,0.3]
[null,"LU USA Additional Danish Pastry",73,9,0.12328767123287671,null,null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"},null,"LU USA Additional Danish Pastry",73,9,0.12328767123287671,null,"LU USA Additional Danish Pastry",323,33,0.1021671826625387,null,"LU USA Additional Danish Pastry",73,9,0.12328767123287671,null,"LU USA Additional Danish Pastry",73,9,0.12328767123287671]
[null,"Morrison's (Ranging)",null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"},null,75,8,0.10666666666666667,null,{"$f":"+B53","v":"Morrison's (Ranging)"},75,8,0.10666666666666667,null,{"$f":"+B53","v":"Morrison's (Ranging)"},{"$f":"+T53","v":75},{"$f":"+U53","v":8},0.10666666666666667,null,"Morrison's (Ranging)",75,8,0.10666666666666667,null,"Morrison's (Ranging)",{"$f":"+AD53-40","v":35},{"$f":"+AE53-4","v":4},0.11428571428571428]
[null,"Asda Additional New Business",null,null,{"$error":"#DIV/0!"},null,33,6,0.18181818181818182,null,null,null,{"$error":"#DIV/0!"},null,45,8.5,0.18888888888888888,null,"Asda Additional New Business",78,14.5,0.1858974358974359,null,"Asda Additional New Business",{"$f":"+T54","v":78},14.5,0.1858974358974359,null,"Asda Additional New Business",78,14.5,0.1858974358974359,null,"Asda Additional New Business",78,14.5,0.1858974358974359]
[null,"Australia",null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"},null,"Australia",0,0,{"$error":"#DIV/0!"},null,"Australia",0,0,{"$error":"#DIV/0!"},null,"Australia",0,0,{"$error":"#DIV/0!"},null,"Australia",0,0,{"$error":"#DIV/0!"}]
[null,"Co-Op",50,8,0.16,null,120,31,0.25833333333333336,null,29,10,0.34482758620689657,null,40,12,0.3,null,{"$f":"+B56","v":"Co-Op"},{"$f":"+C56+G56+K56+O56","v":239},{"$f":"+D56+H56+L56+P56","v":61},{"$f":"+U56/T56","v":0.25523012552301255},null,{"$f":"+B56","v":"Co-Op"},{"$f":"+T56","v":239},{"$f":"+U56","v":61},{"$f":"+Z56/Y56","v":0.25523012552301255},null,{"$f":"+S56","v":"Co-Op"},{"$f":"+C56+G56+K56+O56","v":239},{"$f":"+D56+H56+L56+P56","v":61},{"$f":"+AE56/AD56","v":0.25523012552301255},null,{"$f":"+X56","v":"Co-Op"},{"$f":"+AD56","v":239},{"$f":"+AE56","v":61},{"$f":"+AJ56/AI56","v":0.25523012552301255}]
[null,"Bako",55,8,{"$f":"+D57/C57","v":0.14545454545454545},null,null,null,{"$f":"+H57/G57","v":{"$error":"#DIV/0!"}},null,18,3,{"$f":"+L57/K57","v":0.16666666666666666},null,null,null,{"$f":"+P57/O57","v":{"$error":"#DIV/0!"}},null,{"$f":"+B57","v":"Bako"},{"$f":"+C57+G57+K57+O57","v":73},{"$f":"+D57+H57+L57+P57","v":11},{"$f":"+U57/T57","v":0.15068493150684931},null,{"$f":"+B57","v":"Bako"},{"$f":"+T57","v":73},{"$f":"+U57","v":11},{"$f":"+Z57/Y57","v":0.15068493150684931},null,{"$f":"+S57","v":"Bako"},{"$f":"+C57+G57+K57+O57","v":73},{"$f":"+D57+H57+L57+P57","v":11},{"$f":"+AE57/AD57","v":0.15068493150684931},null,{"$f":"+X57","v":"Bako"},{"$f":"+AD57","v":73},{"$f":"+AE57","v":11},{"$f":"+AJ57/AI57","v":0.15068493150684931}]
[null,"Brakes",96,15,{"$f":"+D58/C58","v":0.15625},null,95,8,{"$f":"+H58/G58","v":8.4210526315789472E-2},null,null,null,{"$f":"+L58/K58","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"+P58/O58","v":{"$error":"#DIV/0!"}},null,{"$f":"+B58","v":"Brakes"},{"$f":"+C58+G58+K58+O58","v":191},{"$f":"+D58+H58+L58+P58","v":23},{"$f":"+U58/T58","v":0.12041884816753927},null,{"$f":"+B58","v":"Brakes"},{"$f":"+T58","v":191},{"$f":"+U58","v":23},{"$f":"+Z58/Y58","v":0.12041884816753927},null,{"$f":"+S58","v":"Brakes"},{"$f":"+C58+G58+K58+O58","v":191},{"$f":"+D58+H58+L58+P58","v":23},{"$f":"+AE58/AD58","v":0.12041884816753927},null,{"$f":"+X58","v":"Brakes"},{"$f":"+AD58","v":191},{"$f":"+AE58","v":23},{"$f":"+AJ58/AI58","v":0.12041884816753927}]
[null,"Sterling Supergroup",null,null,{"$f":"+D59/C59","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"+H59/G59","v":{"$error":"#DIV/0!"}},null,99,23,{"$f":"+L59/K59","v":0.23232323232323232},null,null,null,{"$f":"+P59/O59","v":{"$error":"#DIV/0!"}},null,{"$f":"+B59","v":"Sterling Supergroup"},{"$f":"+C59+G59+K59+O59","v":99},{"$f":"+D59+H59+L59+P59","v":23},{"$f":"+U59/T59","v":0.23232323232323232},null,{"$f":"+B59","v":"Sterling Supergroup"},{"$f":"+T59","v":99},{"$f":"+U59","v":23},{"$f":"+Z59/Y59","v":0.23232323232323232},null,{"$f":"+S59","v":"Sterling Supergroup"},{"$f":"+C59+G59+K59+O59","v":99},{"$f":"+D59+H59+L59+P59","v":23},{"$f":"+AE59/AD59","v":0.23232323232323232},null,{"$f":"+X59","v":"Sterling Supergroup"},{"$f":"+AD59","v":99},{"$f":"+AE59","v":23},{"$f":"+AJ59/AI59","v":0.23232323232323232}]
[null,"Other",{"$f":"127-73","v":54},{"$f":"30-9","v":21},{"$f":"+D60/C60","v":0.3888888888888889},null,{"$f":"203-92","v":111},{"$f":"70-18","v":52},{"$f":"+H60/G60","v":0.46846846846846846},null,75,6,{"$f":"+L60/K60","v":0.08},null,45,6,{"$f":"+P60/O60","v":0.13333333333333333},null,{"$f":"+B60","v":"Other"},{"$f":"+C60+G60+K60+O60","v":285},{"$f":"+D60+H60+L60+P60","v":85},{"$f":"+U60/T60","v":0.2982456140350877},null,{"$f":"+B60","v":"Other"},{"$f":"+T60","v":285},{"$f":"+U60","v":85},{"$f":"+Z60/Y60","v":0.2982456140350877},null,{"$f":"+S60","v":"Other"},{"$f":"+C60+G60+K60+O60","v":285},{"$f":"+D60+H60+L60+P60","v":85},{"$f":"+AE60/AD60","v":0.2982456140350877},null,{"$f":"+X60","v":"Other"},{"$f":"+AD60","v":285},{"$f":"+AE60","v":85},{"$f":"+AJ60/AI60","v":0.2982456140350877}]
[null,"Aryzta",null,null,{"$f":"+D61/C61","v":{"$error":"#DIV/0!"}},null,72,8,{"$f":"+H61/G61","v":0.1111111111111111},null,null,null,{"$f":"+L61/K61","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"+P61/O61","v":{"$error":"#DIV/0!"}},null,{"$f":"+B61","v":"Aryzta"},{"$f":"+C61+G61+K61+O61","v":72},{"$f":"+D61+H61+L61+P61","v":8},{"$f":"+U61/T61","v":0.1111111111111111},null,{"$f":"+B61","v":"Aryzta"},{"$f":"+T61","v":72},{"$f":"+U61","v":8},{"$f":"+Z61/Y61","v":0.1111111111111111},null,{"$f":"+S61","v":"Aryzta"},{"$f":"+C61+G61+K61+O61","v":72},{"$f":"+D61+H61+L61+P61","v":8},{"$f":"+AE61/AD61","v":0.1111111111111111},null,{"$f":"+X61","v":"Aryzta"},{"$f":"+AD61","v":72},{"$f":"+AE61","v":8},{"$f":"+AJ61/AI61","v":0.1111111111111111}]
[null,"Iceland",null,null,{"$f":"+D62/C62","v":{"$error":"#DIV/0!"}},null,57,9,{"$f":"+H62/G62","v":0.15789473684210525},null,null,null,{"$f":"+L62/K62","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"+P62/O62","v":{"$error":"#DIV/0!"}},null,{"$f":"+B62","v":"Iceland"},{"$f":"+C62+G62+K62+O62","v":57},{"$f":"+D62+H62+L62+P62","v":9},{"$f":"+U62/T62","v":0.15789473684210525},null,{"$f":"+B62","v":"Iceland"},{"$f":"+T62","v":57},{"$f":"+U62","v":9},{"$f":"+Z62/Y62","v":0.15789473684210525},null,{"$f":"+S62","v":"Iceland"},{"$f":"+C62+G62+K62+O62","v":57},{"$f":"+D62+H62+L62+P62","v":9},{"$f":"+AE62/AD62","v":0.15789473684210525},null,{"$f":"+X62","v":"Iceland"},{"$f":"+AD62","v":57},{"$f":"+AE62","v":9},{"$f":"+AJ62/AI62","v":0.15789473684210525}]
[null,"Sainsburys",null,null,{"$error":"#DIV/0!"},null,45,9,0.2,null,44,10,0.22727272727272727,null,null,null,{"$error":"#DIV/0!"},null,"Sainsburys",89,19,0.21348314606741572,null,"Sainsburys",89,19,0.21348314606741572,null,"Sainsburys",89,19,0.21348314606741572,null,"Sainsburys",89,19,0.21348314606741572]
[null,"Tesco New Listings",null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"},null,0,0,{"$error":"#DIV/0!"},null,"Tesco New Listings",0,0,{"$error":"#DIV/0!"},null,"Tesco New Listings",0,0,{"$error":"#DIV/0!"},null,"Tesco New Listings",0,0,{"$error":"#DIV/0!"},null,"Tesco New Listings",{"$f":"+AD64-30","v":-30},{"$f":"+AE64-5","v":-5},0.16666666666666666]
[null,"LU Japan (Costco)",180,22,{"$f":"+D65/C65","v":0.12222222222222222},null,55,8,{"$f":"+H65/G65","v":0.14545454545454545},null,null,null,{"$f":"+L65/K65","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"+P65/O65","v":{"$error":"#DIV/0!"}},null,"LU Japan (Costco)",235,30,{"$f":"+U65/T65","v":0.1276595744680851},null,"LU Japan (Costco)",{"$f":"+T65","v":235},{"$f":"+U65","v":30},{"$f":"+Z65/Y65","v":0.1276595744680851},null,"LU Japan (Costco)",235,30,0.1276595744680851,null,"LU Japan (Costco)",235,30,0.1276595744680851]
[null,"Pret A Manger (FP)",120,30,0.25,null,245,65,0.26530612244897961,null,192,53,0.27604166666666669,null,180,50,0.27777777777777779,null,"Pret A Manger (FP)",737,198,0.26865671641791045,null,"Pret A Manger (FP)",737,198,0.26865671641791045,null,"Pret A Manger (FP)",737,198,0.26865671641791045,null,"Pret A Manger (FP)",0,0,{"$error":"#DIV/0!"}]
[null,"Total Opportunity",{"$f":"SUM(C45:C66)","v":917},{"$f":"SUM(D45:D66)","v":185},{"$f":"+D67/C67","v":0.20174482006543076},null,{"$f":"SUM(G45:G66)","v":940},{"$f":"SUM(H45:H66)","v":223},{"$f":"+H67/G67","v":0.2372340425531915},null,{"$f":"SUM(K45:K66)","v":513},{"$f":"SUM(L45:L66)","v":118},{"$f":"+L67/K67","v":0.2300194931773879},null,{"$f":"SUM(O45:O66)","v":490},{"$f":"SUM(P45:P66)","v":114.5},{"$f":"+P67/O67","v":0.2336734693877551},null,"Total Opportunity",{"$f":"SUM(T45:T66)","v":2860},{"$f":"SUM(U45:U66)","v":640.5},{"$f":"+U67/T67","v":0.22395104895104895},null,"Total Opportunity",{"$f":"SUM(Y45:Y66)","v":10955},{"$f":"SUM(Z45:Z66)","v":2197.5},{"$f":"+Z67/Y67","v":0.20059333637608398},null,"Total Opportunity",{"$f":"SUM(AD45:AD66)","v":2860},{"$f":"SUM(AE45:AE66)","v":640.5},{"$f":"+AE67/AD67","v":0.22395104895104895},null,"Total Opportunity",{"$f":"SUM(AI45:AI66)","v":2053},{"$f":"SUM(AJ45:AJ66)","v":433.5},{"$f":"+AJ67/AI67","v":0.21115440818314662}]
[null,"Risks","Net Sales £000’s","£ GP1","% GP1",null,"Net Sales £000’s","£ GP1","% GP1",null,"Net Sales £000’s","£ GP1","% GP1",null,"Net Sales £000’s","£ GP1","% GP1",null,"Risks","Net Sales £000’s","£ GP1","% GP1",null,"Risks","Net Sales £000’s","£ GP1","% GP1",null,"Risks","Net Sales £000’s","£ GP1","% GP1",null,"Risks","Net Sales £000’s","£ GP1","% GP1"]
[null,"Australia",null,null,{"$f":"+D69/C69","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"+H69/G69","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"+L69/K69","v":{"$error":"#DIV/0!"}},null,null,null,{"$f":"+P69/O69","v":{"$error":"#DIV/0!"}},null,{"$f":"+B19","v":"Australia"},{"$f":"+C69+G69+K69+O69","v":0},{"$f":"+D69+H69+L69+P69","v":0},{"$f":"+U69/T69","v":{"$error":"#DIV/0!"}},null,{"$f":"+B19","v":"Australia"},{"$f":"+C19+T69","v":-4241},{"$f":"+D19+U69","v":-1418},{"$f":"+Z69/Y69","v":0.33435510492808301},null,{"$f":"+S69","v":"Australia"},{"$f":"+C69+G69+K69+O69","v":0},{"$f":"+D69+H69+L69+P69","v":0},{"$f":"+AE69/AD69","v":{"$error":"#DIV/0!"}},null,{"$f":"+X69","v":"Australia"},{"$f":"+AD69","v":0},{"$f":"+AE69","v":0},{"$f":"+AJ69/AI69","v":{"$error":"#DIV/0!"}}]
[null,"Morrison’s",null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"},null,"Morrison’s",0,0,{"$f":"+U70/T70","v":{"$error":"#DIV/0!"}},null,"Morrison’s",-2485,-311,{"$f":"+Z70/Y70","v":0.12515090543259558},null,"Morrison’s",0,0,{"$f":"+AE70/AD70","v":{"$error":"#DIV/0!"}},null,"Morrison’s",{"$f":"+AD70+30","v":30},{"$f":"+AE70+2","v":2},{"$f":"+AJ70/AI70","v":6.6666666666666666E-2}]
[null,"Asda Danish",null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"},null,-45,-8,0.17777777777777778,null,"Asda Danish",-45,-8,{"$f":"+U71/T71","v":0.17777777777777778},null,"Asda Danish",-2001,62,{"$f":"+Z71/Y71","v":-3.0984507746126936E-2},null,"Asda Danish",-45,-8,{"$f":"+AE71/AD71","v":0.17777777777777778},null,"Asda Danish",{"$f":"+AD71","v":-45},{"$f":"+AE71","v":-8},{"$f":"+AJ71/AI71","v":0.17777777777777778}]
[null,"Tesco (Ranging & Delists)",-394,-145,0.36802030456852791,null,{"$f":"-338+92","v":-246},{"$f":"-132+18","v":-114},0.46341463414634149,null,{"$f":"-533+78","v":-455},-72,0.15824175824175823,null,-500,-100,0.2,null,"Tesco (Ranging & Delists)",-1595,-431,0.27021943573667712,null,"Tesco (Ranging & Delists)",-3929,-902,0.22957495545940443,null,"Tesco (Ranging & Delists)",-1595,-431,0.27021943573667712,null,"Tesco (Ranging & Delists)",{"$f":"+AD72+180","v":-1415},{"$f":"+AE72+44","v":-387},0.27349823321554773]
[null,"Pret A Manger (FP)",null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"},null,"Pret A Manger (FP)",0,0,{"$error":"#DIV/0!"},null,"Pret A Manger (FP)",-1052,-309,0.29372623574144485,null,"Pret A Manger (FP)",0,0,{"$error":"#DIV/0!"},null,"Pret A Manger (FP)",0,0,{"$error":"#DIV/0!"}]
[null,"Pricing (Various Customers)",null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"},null,-50,-50,1,null,"Pricing (Various Customers)",-50,-50,1,null,"Pricing (Various Customers)",-1041,-1041,1,null,"Pricing (Various Customers)",-50,-50,1,null,"Pricing (Various Customers)",-50,-50,1]
[null,"Saudi Arabia",null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"},null,-30,-3,0.1,null,"Saudi Arabia",-30,-3,0.1,null,"Saudi Arabia",-646,-212,0.32817337461300311,null,"Saudi Arabia",-30,-3,0.1,null,"Saudi Arabia",-30,-3,0.1]
[null,"Co-Op",null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"},null,"Co-Op",0,0,{"$error":"#DIV/0!"},null,"Co-Op",-591,-167,0.28257191201353637,null,"Co-Op",0,0,{"$error":"#DIV/0!"},null,"Co-Op",0,0,{"$error":"#DIV/0!"}]
[null,3663,null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"},null,3663,0,0,{"$error":"#DIV/0!"},null,3663,-560,-284,0.50714285714285712,null,3663,0,0,{"$error":"#DIV/0!"},null,3663,0,0,{"$error":"#DIV/0!"}]
[null,"Other",null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"},null,"Other",0,0,{"$error":"#DIV/0!"},null,"Other",-562,-53,9.4306049822064059E-2,null,"Other",0,0,{"$error":"#DIV/0!"},null,"Other",{"$f":"+AD78+20","v":20},{"$f":"+AE78+2","v":2},0.1]
[null,"KFC Europe & GB",null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"},null,-99,-8,8.0808080808080815E-2,null,-135,-10,7.407407407407407E-2,null,"KFC Europe & GB",-234,-18,7.6923076923076927E-2,null,"KFC Europe & GB",-679,-63,9.2783505154639179E-2,null,"KFC Europe & GB",-234,-18,7.6923076923076927E-2,null,"KFC Europe & GB",-234,-18,7.6923076923076927E-2]
[null,"LU USA",null,null,{"$error":"#DIV/0!"},null,{"$f":"-247+68","v":-179},{"$f":"-24+13","v":-11},6.1452513966480445E-2,null,-167,-17,0.10179640718562874,null,null,null,{"$error":"#DIV/0!"},null,"LU USA",-346,-28,8.0924855491329481E-2,null,"LU USA",-659,-58,8.8012139605462822E-2,null,"LU USA",-346,-28,8.0924855491329481E-2,null,"LU USA",-346,-28,8.0924855491329481E-2]
[null,"EAT",null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"},null,"EAT",0,0,{"$error":"#DIV/0!"},null,"EAT",-305,-82,0.26885245901639343,null,"EAT",0,0,{"$error":"#DIV/0!"},null,"EAT",0,0,{"$error":"#DIV/0!"}]
[null,"Costco",null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"},null,"Costco",0,0,{"$error":"#DIV/0!"},null,"Costco",-198,-195,0.98484848484848486,null,"Costco",0,0,{"$error":"#DIV/0!"},null,"Costco",0,0,{"$error":"#DIV/0!"}]
[null,"New Puff Pastry",-75,{"$f":"-10-5","v":-15},0.2,null,-68,-13,0.19117647058823528,null,-79,-13,0.16455696202531644,null,-133,-11.7,8.7969924812030073E-2,null,{"$f":"+B83","v":"New Puff Pastry"},-355,-52.7,0.14845070422535211,null,{"$f":"+B83","v":"New Puff Pastry"},{"$f":"+T83","v":-355},{"$f":"+U83","v":-52.7},0.14845070422535211,null,"New Puff Pastry",-355,-52.7,0.14845070422535211,null,"New Puff Pastry",-355,-52.7,0.14845070422535211]
[null,"LUB",null,null,{"$error":"#DIV/0!"},null,null,null,{"$error":"#DIV/0!"},null,-107,-12,0.11214953271028037,null,null,null,{"$error":"#DIV/0!"},null,{"$f":"+B84","v":"LUB"},-107,-12,0.11214953271028037,null,{"$f":"+B84","v":"LUB"},{"$f":"+T84","v":-107},{"$f":"+U84","v":-12},0.11214953271028037,null,"LUB",-107,-12,0.11214953271028037,null,"LUB",-107,-12,0.11214953271028037]
[null,"Total Risk",{"$f":"SUM(C69:C84)","v":-469},{"$f":"SUM(D69:D84)","v":-160},{"$f":"+D85/C85","v":0.34115138592750532},null,{"$f":"SUM(G69:G84)","v":-493},{"$f":"SUM(H69:H84)","v":-138},{"$f":"+H85/G85","v":0.27991886409736311},null,{"$f":"SUM(K69:K84)","v":-907},{"$f":"SUM(L69:L84)","v":-122},{"$f":"+L85/K85","v":0.13450937155457551},null,{"$f":"SUM(O69:O84)","v":-893},{"$f":"SUM(P69:P84)","v":-182.7},{"$f":"+P85/O85","v":0.20459126539753639},null,"Total Risk",{"$f":"SUM(T69:T84)","v":-2762},{"$f":"SUM(U69:U84)","v":-602.70000000000005},{"$f":"+U85/T85","v":0.21821144098479364},null,"Total Risk",{"$f":"SUM(Y69:Y84)","v":-19411},{"$f":"SUM(Z69:Z84)","v":-5097.7},{"$f":"+Z85/Y85","v":0.2626191334810159},null,"Total Risk",{"$f":"SUM(AD69:AD84)","v":-2762},{"$f":"SUM(AE69:AE84)","v":-602.70000000000005},{"$f":"+AE85/AD85","v":0.21821144098479364},null,"Total Risk",{"$f":"SUM(AI69:AI84)","v":-2532},{"$f":"SUM(AJ69:AJ84)","v":-554.70000000000005},{"$f":"+AJ85/AI85","v":0.21907582938388628}]
[]
[null,"Net Movement",{"$f":"+C67+C85","v":448},{"$f":"+D67+D85","v":25},{"$f":"+D87/C87","v":5.5803571428571432E-2},null,{"$f":"+G67+G85","v":447},{"$f":"+H67+H85","v":85},{"$f":"+H87/G87","v":0.19015659955257272},null,{"$f":"+K67+K85","v":-394},{"$f":"+L67+L85","v":-4},{"$f":"+L87/K87","v":1.015228426395939E-2},null,{"$f":"+O67+O85","v":-403},{"$f":"+P67+P85","v":-68.199999999999989},{"$f":"+P87/O87","v":0.16923076923076921},null,"Net Movement",{"$f":"+T67+T85","v":98},{"$f":"+U67+U85","v":37.799999999999955},{"$f":"+U87/T87","v":0.38571428571428523},null,"Net Movement",{"$f":"+Y67+Y85","v":-8456},{"$f":"+Z67+Z85","v":-2900.2},{"$f":"+Z87/Y87","v":0.34297540208136235},null,"Net Movement",{"$f":"+AD67+AD85","v":98},{"$f":"+AE67+AE85","v":37.799999999999955},{"$f":"+AE87/AD87","v":0.38571428571428523},null,"Net Movement",{"$f":"+AI67+AI85","v":-479},{"$f":"+AJ67+AJ85","v":-121.20000000000005},{"$f":"+AJ87/AI87","v":0.25302713987473913}]
[null,null,{"$f":"+C87-('Act v FC3'!K20/1000)","v":-0.24960949033885527},{"$f":"+D87-('Act v FC3'!K40/1000)","v":0.13830501400988027},null,null,{"$f":"+G87-('Act v FC3'!L20/1000)","v":0.11279729508191849},{"$f":"+H87-('Act v FC3'!L40/1000)","v":0.44093303992963229},null,null,{"$f":"+K87-('Act v FC3'!M20/1000)","v":-0.37023739606570416},{"$f":"+L87-('Act v FC3'!M40/1000)","v":-0.4848161809967424},null,null,{"$f":"+O87-('Act v FC3'!N20/1000)","v":-403},{"$f":"+P87-('Act v FC3'!N40/1000)","v":-68.199999999999989}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014 FC4 (GL)",{"$f":"+Y42+Y67+Y85","v":145476},{"$f":"+Z42+Z67+Z85","v":22950.799999999999},{"$f":"+Z89/Y89","v":0.15776347988671671}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014 FC3 (GL)",145378,22913,{"$f":"+Z91/Y91","v":0.15760981716628375}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Movement",{"$f":"+Y89-Y91","v":98},{"$f":"+Z89-Z91","v":37.799999999999272},{"$f":"+Z93/Y93","v":0.38571428571427829}]

{"sheet":"Act v FC3","index":5,"n_rows":40,"n_cols":15,"rows_kept":40,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Net Sales"]
[]
[null,"FC3","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","TOTAL"]
[null,null,"Act","Act","Act","Act","Act","Act","Act","Act","FC3","FC3","FC3","FC3"]
[null,"Principal",9051975.2999999989,8878136.8499999996,11655568.640000002,11671858.290000003,11969294.120000001,11845154.670000002,12200293.879999999,11024087.300000001,11373149.891511302,11672411.4245249,11289248.686376592,10820238.507587204,{"$f":"SUM(C6:N6)","v":133451417.56}]
[null,"Agency",1055402.3410311905,908932.25575674034,1135369.9410140999,1013572.7762030398,1187080.4948115,900143.51336590014,948425,831918.98144689994,1010303.0747168589,984607.80993441783,978766.88961234002,972335.19811705255,{"$f":"SUM(C7:N7)","v":11926858.27601004}]
[null,"Total",{"$f":"+C6+C7","v":10107377.641031189},9787069.1057567392,12790938.581014102,12685431.066203043,13156374.614811501,12745298.183365902,13148718.879999999,11856006.2814469,12383452.966228161,12657019.234459318,12268015.575988932,11792573.705704257,145378275.83601004]
[]
[null,"Actual (GL)","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","TOTAL"]
[null,null,"Act","Act","Act","Act","Act","Act","Act","Act","Act","Act","Act","Act"]
[null,"Principal",null,null,null,null,null,11845154.670000002,12200294,11024087.300000001,11977438.98,12103205.090000002,10991025.749999998,null,{"$f":"SUM(C12:N12)","v":70141205.790000007}]
[null,"Agency",null,null,null,null,null,900143.51336590014,948425,831918.98144689994,854263.59571849974,1000701.3471642338,883360.06338499975,null,{"$f":"SUM(C13:N13)","v":5418812.5010805335}]
[null,"Total",{"$f":"+C12+C13","v":0},0,0,0,0,12745298.183365902,13148719,11856006.2814469,12831702.5757185,13103906.437164236,11874385.813384999,0,75560018.291080534]
[]
[null,"Variance","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","TOTAL"]
[null,null,"Act","Act","Act","Act","Act","Act","Act","Act","Act","Act","Act","Act"]
[null,"Principal",null,null,null,null,null,{"$f":"+H12-H6","v":0},0.12000000104308128,0,{"$f":"+K12-K6","v":604289.08848869801},430793.66547510214,{"$f":"+M12-M6","v":-298222.93637659401},null,{"$f":"SUM(C18:N18)","v":736859.93758720718}]
[null,"Agency",null,null,null,null,null,0,0,0,{"$f":"+K13-K7","v":-156039.47899835918},16093.537229815964,{"$f":"+M13-M7","v":-95406.826227340265},null,{"$f":"SUM(C19:N19)","v":-235352.76799588348}]
[null,"Total",{"$f":"+C18+C19","v":0},0,0,0,0,0,0.12000000104308128,0,448249.60949033883,446887.20270491811,-393629.76260393427,0,501507.16959132371]
[]
[null,"GP1"]
[]
[null,"FC3","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","TOTAL"]
[null,null,"Act","Act","Act","Act","Act","Act","Act","Act","FC3","FC3","FC3","FC3"]
[null,"Principal",1485279.1100000003,1440571.0900000017,1867411.6900000013,1935006.2900000028,1876997.8000000007,1815910.3200000022,1942524.9899999984,1789208.7700000014,1854712.2115113027,1892192.3445249014,1842003.7963765934,1753989.8375872038,{"$f":"SUM(C26:N26)","v":21495808.250000011}]
[null,"Agency",124680.28860927503,107068.42965310001,133541.53872987998,119597.65746793002,141084.92912049993,107756.19280337008,113722,99803.778173899991,120483.27898887647,117319.10017485963,116686.74604740899,115863.29490724546,{"$f":"SUM(C27:N27)","v":1417607.2346763455}]
[null,"Total",{"$f":"+C26+C27","v":1609959.3986092755},1547639.5196531017,2000953.2287298813,2054603.9474679329,2018082.7291205006,1923666.5128033722,2056246.9899999984,1889012.5481739014,1975195.4905001791,2009511.444699761,1958690.5424240024,1869853.1324944494,22913415.484676357]
[]
[null,"Actual (GL)","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","TOTAL"]
[null,null,"Act","Act","Act","Act","Act","Act","Act","Act","Act","Act","Act","Act"]
[null,"Principal",null,null,null,null,null,1815910.3200000022,1942524.9899999984,1789208.7700000014,1897574.7799999993,1973986.3500000034,1849186.6199999992,null,{"$f":"SUM(C32:N32)","v":11268391.830000004}]
[null,"Agency",null,null,null,null,null,107756.19280337008,113722,99803.778173899991,102482.40548617,120084.16165982801,105988.73860499996,null,{"$f":"SUM(C33:N33)","v":649837.27672826801}]
[null,"Total",{"$f":"+C32+C33","v":0},0,0,0,0,1923666.5128033722,2056246.9899999984,1889012.5481739014,2000057.1854861693,2094070.5116598313,1955175.3586049993,0,11918229.106728273]
[]
[null,"Variance","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","TOTAL"]
[null,null,"Act","Act","Act","Act","Act","Act","Act","Act","Act","Act","Act","Act"]
[null,"Principal",null,null,null,null,null,{"$f":"+H32-H26","v":0},0,0,{"$f":"+K32-K26","v":42862.56848869659},81794.005475101992,{"$f":"+M32-M26","v":7182.8236234057695},null,{"$f":"SUM(C38:N38)","v":131839.39758720435}]
[null,"Agency",null,null,null,null,null,0,0,0,{"$f":"+K33-K27","v":-18000.873502706469},2765.061484968377,{"$f":"+M33-M27","v":-10698.007442409027},null,{"$f":"SUM(C39:N39)","v":-25933.819460147119}]
[null,"Total",{"$f":"+C38+C39","v":0},0,0,0,0,0,0,0,24861.694985990121,84559.06696007037,-3515.1838190032577,0,105905.57812705723]

{"sheet":"Act v FC2","index":6,"n_rows":40,"n_cols":17,"rows_kept":40,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Net Sales",null,null,null,null,null,null,127521.03999999988,null,121779.12501839998,{"$f":"+K2/12%","v":1014826.0418199999},null,114207.8599999999,{"$f":"+N2/12%","v":951732.16666666581}]
[]
[null,"FC2","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","TOTAL"]
[null,null,"Act","Act","Act","Act","Act","FC2","FC2","FC2","FC2","FC2","FC2","FC2"]
[null,"Principal",9159093.2599999979,10014552.17,12022956.909999998,11404291.1,11527857.620000003,11391601.752760937,11409860.764437864,11402789.262206404,11653243.718423842,11628149.260371141,11162422.704276647,11066763.529782137,{"$f":"SUM(C6:N6)","v":133843582.05225898},null,"GL"]
[null,"Agency",927295.33333333384,792832.66666666756,1178710.2500000005,1097341.9999999981,1143985.3333333319,949580.40152500011,963348.99320000014,1014826.0418199999,1030947.7843799995,1096538.2171099994,1072733.1133499998,1102201.1525149995,{"$f":"SUM(C7:N7)","v":12370341.28723333},null,"GL - Commission @ 12%"]
[null,"Total",{"$f":"+C6+C7","v":10086388.593333332},10807384.836666668,13201667.159999998,12501633.099999998,12671842.953333335,12341182.154285938,12373209.757637864,12417615.304026403,12684191.502803842,12724687.47748114,12235155.817626648,12168964.682297137,146213923.33949232]
[]
[null,"Actual (GL)","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","TOTAL"]
[null,null,"Act","Act","Act","Act","Act","FC2","FC2","FC2","FC2","FC2","FC2","FC2"]
[null,"Principal",null,null,null,null,null,12402843.049999997,11902515.880000005,11347570.490000002,null,null,null,null,{"$f":"SUM(C12:N12)","v":35652929.420000002},null,"GL"]
[null,"Agency",null,null,null,null,null,1036758.8333333323,951733,1062675.3333333323,null,null,null,null,{"$f":"SUM(C13:N13)","v":3051167.1666666646},null,"GL - Commission @ 12%"]
[null,"Total",{"$f":"+C12+C13","v":0},0,0,0,0,13439601.883333329,12854248.880000005,12410245.823333334,0,0,0,0,38704096.586666666]
[]
[null,"Variance","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","TOTAL"]
[null,null,"Act","Act","Act","Act","Act","FC2","FC2","FC2","FC2","FC2","FC2","FC2"]
[null,"Principal",null,null,null,null,null,{"$f":"+H12-H6","v":1011241.2972390596},492655.11556214094,{"$f":"+J12-J6","v":-55218.772206401452},null,null,null,null,{"$f":"SUM(C18:N18)","v":1448677.6405947991}]
[null,"Agency",null,null,null,null,null,87178.431808332214,-11615.993200000143,{"$f":"+J13-J7","v":47849.291513332399},null,null,null,null,{"$f":"SUM(C19:N19)","v":123411.73012166447}]
[null,"Total",{"$f":"+C18+C19","v":0},0,0,0,0,1098419.7290473918,481039.1223621408,-7369.4806930690538,0,0,0,0,1572089.3707164635]
[]
[null,"GP2"]
[]
[null,"FC2","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","TOTAL"]
[null,null,"Act","Act","Act","Act","Act","FC2","FC2","FC2","FC2","FC2","FC2","FC2"]
[null,"Principal",1408812.9799999981,1643873.3000000049,1802936.8899999971,1640315.5299999984,1713260.629999999,1642898.9866093353,1637183.3195757391,1670201.1732297754,1698261.6581293328,1668768.1709707603,1598688.255639195,1536726.6818395914,{"$f":"SUM(C26:N26)","v":19661927.575993728},null,"GL - GP1 less Distribution"]
[null,"Agency",111275.44000000006,95139.9200000001,141445.23000000004,131681.03999999978,137278.23999999982,113949.64818300001,115601.87918400002,121779.12501839998,123713.73412559993,131584.58605319992,128727.97360199995,132264.13830179995,{"$f":"SUM(C27:N27)","v":1484440.9544679995},null,"GL"]
[null,"Total",{"$f":"+C26+C27","v":1520088.4199999981},1739013.2200000051,1944382.1199999971,1771996.5699999982,1850538.8699999987,1756848.6347923353,1752785.1987597391,1791980.2982481753,1821975.3922549328,1800352.7570239601,1727416.2292411949,1668990.8201413914,21146368.530461729]
[]
[null,"Actual (GL)","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","TOTAL"]
[null,null,"Act","Act","Act","Act","Act","FC2","FC2","FC2","FC2","FC2","FC2","FC2"]
[null,"Principal",null,null,null,null,null,{"$f":"2907855-1160563","v":1747292},{"$f":"2847882-1082865","v":1765017},1842732,null,null,null,null,{"$f":"SUM(C32:N32)","v":5355041},null,"GL - GP1 less Distribution"]
[null,"Agency",null,null,null,null,null,124411.05999999988,114208,127521.03999999988,null,null,null,null,{"$f":"SUM(C33:N33)","v":366140.09999999974},null,"GL"]
[null,"Total",{"$f":"+C32+C33","v":0},0,0,0,0,1871703.0599999998,1879225,1970253.0399999998,0,0,0,0,5721181.0999999996]
[]
[null,"Variance","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec","TOTAL"]
[null,null,"Act","Act","Act","Act","Act","FC2","FC2","FC2","FC2","FC2","FC2","FC2"]
[null,"Principal",null,null,null,null,null,{"$f":"+H32-H26","v":104393.01339066471},127833.68042426091,{"$f":"+J32-J26","v":172530.82677022461},null,null,null,null,{"$f":"SUM(C38:N38)","v":404757.52058515023}]
[null,"Agency",null,null,null,null,null,10461.411816999869,-1393.8791840000194,{"$f":"+J33-J27","v":5741.9149815998971},null,null,null,null,{"$f":"SUM(C39:N39)","v":14809.447614599747}]
[null,"Total",{"$f":"+C38+C39","v":0},0,0,0,0,114854.42520766458,126439.80124026089,178272.74175182451,0,0,0,0,419566.96819974994]

{"sheet":"FC3","index":7,"n_rows":24,"n_cols":20,"rows_kept":24,"cut":false,"hidden":true,"merged":[[2,1,2,4]]}
[]
[]
[null,"Summary R&O to FC2"]
[]
[null,"Opportunities","Net Sales £000’s","£ GP2","% GP2",null,null,null,null,"Cases","Category",null,"International","Retail","Foodservice","Internal","Principal","Agency"]
[null,"Australia",950,248,0.26105263157894737,null,null,null,null,95959,"Danish Pastry",null,950,null,null,null,883.5,66.5,0,0]
[null,"Tesco",600,71,0.11833333333333333,null,null,null,null,39500,"Savoury",null,null,600,null,null,null,600,0,0]
[null,"Lidl (VCC)",471,85,0.18046709129511676,null,null,null,null,55600,"Danish Pastry",null,null,471,null,null,471,null,0,0]
[null,"Other",164,249,1.5182926829268293,null,null,null,null,13120,"Danish & French 50/50",null,null,92,72,null,129,35,0,0]
[null,"Internal (USA, Germany, Korea & Denmark)",110,11,0.1,null,null,null,null,17600,"Danish Pastry",null,null,null,null,110,110,null,0,0]
[null,"Morrisons (2nd Seasonal Line)",84,12,0.14285714285714285,null,null,null,null,5800,"French Pastry",null,null,84,null,null,84,null,0,0]
[null,"Greene King (Brioche Hot Dog Roll)",13.333333333333334,2.8,0.20999999999999996,null,null,null,null,2500,"Fast Food",null,null,null,13.333333333333334,null,13.333333333333334,null,0,0]
[null,"Total Opportunity",2392.3333333333335,678.8,0.28373972411871251]
[null,"Risks","Net Sales £000’s","£ GP2","% GP2"]
[null,"Lidl (MPP)",-327,-48.1,0.14709480122324159,null,null,null,null,-32440,"Danish Pastry",null,null,-327,null,null,-327,null,0,0]
[null,"FSC Tender",-100,-100,1,null,null,null,null,-7780,"French Pastry",null,null,-100,null,null,-100,null,0,0]
[null,"South Africa",-73,-20,0.27397260273972601,null,null,null,null,-7300,"French & Wheatbread 50/50",null,-73,null,null,null,-73,null,0,0]
[null,"Total Risk",-500,-168.1,0.3362,null,null,null,null,null,null,null,877,820,85.333333333333329,110,1190.8333333333333,701.5]
[null,null,null,null,null,null,null,null,null,"Danish",1286,143279]
[null,"Net Movement",1892.3333333333335,510.69999999999993,0.26987845693147783,null,null,null,null,"Savoury",600,39500,"Agency"]
[null,null,null,null,null,null,null,null,null,"French",30,930]
[null,null,null,null,null,null,null,null,null,"FF",13.333333333333334,2500]
[null,null,null,null,null,null,null,null,null,"Wheatbread",-36.5,-3650]
[null,null,null,null,null,null,null,null,null,null,1892.8333333333333,182559]

{"sheet":"Final Format","index":8,"n_rows":15,"n_cols":24,"rows_kept":15,"cut":false,"hidden":false,"merged":[[10,5,10,6],[6,1,6,2]]}
[]
[]
[null,null,null,null,"Opportunity and Risk Pipeline LUSA"]
[]
[null,"Zone","Region/sales person","Assigned Rep","Opportunity name - Customer","Segment","Type","Opportunity Type","L3","Product Category","Product(s)","Proposed Case  Net price","Probability %","Launch month in current year","Months to go in current year","Volume Cases Annually","Volume Pieces Annually","Volume Pieces OP YTG","Net Sales U$ annually","Net Sales U$ OP YTG","Net Sales OP YTG / Probability %","Budget","NPD required","Next Step (due date) - Step comment"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(13-MONTH(DATEVALUE(N6&\"1\")),\"-\")","v":"-"},null,null,{"$f":"IFERROR(+(Q6/12)*O6,\"-\")","v":"-"},{"$f":"IFERROR(+P6*L6,\"-\")","v":0},{"$f":"IFERROR(+(O6/12)*S6,\"-\")","v":"-"},{"$f":"IFERROR(SUM(T6*M6),\"-\")","v":"-"}]
[null,"Total Opportunity",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(109,P6:P6)","v":0},{"$f":"SUBTOTAL(109,Q6:Q6)","v":0},{"$f":"SUBTOTAL(109,R6:R6)","v":0},{"$f":"SUBTOTAL(109,S6:S6)","v":0},{"$f":"SUBTOTAL(109,T6:T6)","v":0},{"$f":"SUBTOTAL(109,U6:U6)","v":0}]
[null,"Zone","Region/sales person","Assigned Rep","Risk name - Customer","Segment","Type","Risk Type","L3","Product Category","Product(s)","Unit  Net price effect","Probability %","Start month","Months to go in current year","Volume Annual Cases","Volume Pieces Annually","Volume Pieces OP YTG","Net Sales U$ annually","Net Sales U$ OP YTG","Net Sales OP YTG / Probability %","Budget","Next Step (due date) - Step comment","N/A"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(13-MONTH(DATEVALUE(N9&\"1\")),\"-\")","v":"-"},null,null,{"$f":"IFERROR(+(Q9/12)*O9,\"-\")","v":"-"},{"$f":"IFERROR(+L9*P9,\"-\")","v":0},{"$f":"IFERROR(+(O9/12)*S9,\"-\")","v":"-"},{"$f":"IFERROR(SUM(T9*M9),\"-\")","v":"-"}]
[null,"Total Risk",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(109,P9:P9)","v":0},{"$f":"SUBTOTAL(109,Q9:Q9)","v":0},{"$f":"SUBTOTAL(109,R9:R9)","v":0},{"$f":"SUBTOTAL(109,S9:S9)","v":0},{"$f":"SUBTOTAL(109,T9:T9)","v":0},{"$f":"SUBTOTAL(109,U9:U9)","v":0}]
[null,"Net Movement",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(P7+P10)","v":0},{"$f":"SUM(Q7+Q10)","v":0},{"$f":"SUM(R7+R10)","v":0},{"$f":"+S7+S10","v":0},{"$f":"+T7+T10","v":0},{"$f":"+U7+U10","v":0}]
[]
[null,"Zone","Region/sales person","Assigned Rep","Risk name - Customer","Segment","Type","Risk Type","L3","Product Category","Product(s)","Unit  Net price effect","Probability %","Start month","Months to go in current year","Volume Annual Cases","Volume Pieces Annually","Volume Pieces OP YTG","Net Sales U$ annually","Net Sales U$ OP YTG","Net Sales OP YTG / Probability %","Budget","No Sale Reason"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(13-MONTH(DATEVALUE(N14&\"1\")),\"-\")","v":"-"},null,null,{"$f":"IFERROR(+(Q14/12)*O14,\"-\")","v":"-"},{"$f":"IFERROR(+L14*P14,\"-\")","v":0},{"$f":"IFERROR(+(O14/12)*S14,\"-\")","v":"-"},{"$f":"IFERROR(SUM(T14*M14),\"-\")","v":"-"}]
[null,"Total No Sale",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUBTOTAL(109,P14:P14)","v":0},{"$f":"SUBTOTAL(109,Q14:Q14)","v":0},{"$f":"SUBTOTAL(109,R14:R14)","v":0},{"$f":"SUBTOTAL(109,S14:S14)","v":0},{"$f":"SUBTOTAL(109,T14:T14)","v":0},{"$f":"SUBTOTAL(109,U14:U14)","v":0}]

{"sheet":"List","index":9,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["January",0,"Yes","Hamburger buns","West","Brian"]
["February",0.2,"No","Sandwich carriers","Northeast","Bruce"]
["March",0.4,null,"Dinner rolls","Canada","Cherie"]
["April",0.6,null,"Artisan loaves","Natioanl Accts.","Chris"]
["May",0.8,null,"Imported bread","Southeast","Drew"]
["June",1,null,"Danish pastry","Florida & Export","Eric C"]
["July",null,null,"Croissants","ISB","Erik I"]
["August",null,null,null,null,"Frank"]
["September",null,null,null,null,"John"]
["October",null,null,null,null,"George"]
["November",null,null,null,null,"Kelly"]
["December",null,null,null,null,"Linda"]
[null,null,null,null,null,"Mike"]
[null,null,null,null,null,"Merv"]
[null,null,null,null,null,"Bill"]
[null,null,null,null,null,"N/A"]

{"sheet":"Column descriptions","index":10,"n_rows":2,"n_cols":20,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[null,"Zone","Region","Sales person","Opportunity name - Customer","Product Category","Product(s)","Case Volume","Volume Pieces Annually","Launch month in current year","Propsed Case Net price","Probability %","Budget","Comments","NPD","Months to go in current year","Volume Pieces OP YTG","Net Sales U$ annually","Net Sales U$ OP YTG","Net Sales OP YTG / Probability %"]
[null,"zone name from region roll up","Region from Local Market Roll Up","Assigned Rep","Company Name--will be operator or distributor","L2","SKU","case volume from opportunity","From Equivalent Unit Field","Estimated Order Date Month","NOTE! Changed to case price!","Opportunity stage or Sold =25, 50, 75 or 100","nothing in this column, they will add text after they print the report possibly","nothing in this column, they will add text after they print the report possibly","nothing in this column, they will add text after they print the report possibly","Remainder of months of the year according to est. order date. Jan = 12, Feb = 11, March = 10 etc. ","This year ship volume-cases *pieces for pieces volume. Formula =Case volume *equivalent units","Annual Sales not adjusted","Prorated annual dollars based on estimated order date","This column is the net sales multiplied by the probablity from Column L"]

{"sheet":"data","index":11,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}