{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Start","Channel marketing budget"],"not_rendered":{"defined_names":1},"read":"whole","date_system":"1900"}

{"sheet":"Start","index":0,"n_rows":7,"n_cols":2,"rows_kept":7}
[null,"ABOUT THIS TEMPLATE"]
[null,"Use this template to create a channel marketing budget."]
[null,"Enter anticipated sales for each month and other details in tables."]
[null,"Totals are auto-calculated and sparklines are updated."]
[null,"Note: "]
[null,"Additional instructions have been provided in column A in CHANNEL MARKETING BUDGET worksheet. This text has been intentionally hidden. To remove text, select column A, then select DELETE. To unhide text, select column A, then change font color."]
[null,"To learn more about tables, press SHIFT and then F10 within a table, select the TABLE option, and then select ALTERNATIVE TEXT."]

{"sheet":"Channel marketing budget","index":1,"n_rows":71,"n_cols":17,"rows_kept":71,"merged":[[0,2,0,14],[9,17,9,18],[17,17,17,18],[27,17,27,18],[34,17,34,18],[42,17,42,18],[49,17,49,18],[56,17,56,18],[62,17,62,18],[68,17,68,18],[70,17,70,18]]}
[null,null,"CHANNEL MARKETING BUDGET"]
[]
[null," ","Rate","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec",null,"Total"]
[null,"ANTICIPATED SALES TOTAL $(000)"," ","750","200","500","1,500","1,200",{"v":1500,"d":"1,500"},{"v":1500,"d":"1,500"},"1,800","2,000",{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},null,{"$f":"SUM(D4:O4)","v":{"v":9000,"d":"9,000"}}]
["Enter details in Personnel table starting in cell at right. Personnel Total for each month is auto calculated at the table-end and annual Total in cell Q9. Sparkline is updated in cell S9. Next instruction is in cell A10."]
[null,"PERSONNEL (% OF TOTAL SALES)",null,{"$f":"D12+D37+D45+D52","v":{"v":1.1,"d":"110%"}},{"v":1.1,"d":"110%"},{"v":1.1,"d":"110%"},{"v":1.1,"d":"110%"},{"v":1.1,"d":"110%"},{"v":1.1,"d":"110%"},{"v":1.1,"d":"110%"},{"v":1.1,"d":"110%"},{"v":0.8500000000000001,"d":"85%"},{"v":0.8500000000000001,"d":"85%"},{"v":0.8500000000000001,"d":"85%"},{"v":0.8500000000000001,"d":"85%"}]
[null,"Human resources - headcount",5,{"$f":"+$C$7","v":5},5,5,5,5,5,5,5,5,5,5,5]
[null,"Human resources - cost",null,{"$f":"$C$7*D7","v":{"v":25,"d":"25.00"}},{"v":25,"d":"25.00"},{"v":25,"d":"25.00"},{"v":25,"d":"25.00"},{"v":25,"d":"25.00"},{"v":25,"d":"25.00"},{"v":25,"d":"25.00"},{"v":25,"d":"25.00"},{"v":25,"d":"25.00"},{"v":25,"d":"25.00"},{"v":25,"d":"25.00"},{"v":25,"d":"25.00"},null,{"$f":"SUM('Channel marketing budget'!$D8:$O8)","v":{"v":300,"d":"300.00"}}]
[null,"Commission",{"v":1E-3,"d":"0.10%"},{"$f":"D4*$C$9","v":0.75},{"v":0.2,"d":"0.20"},{"v":0.5,"d":"0.50"},{"v":1.5,"d":"1.50"},{"v":1.2,"d":"1.20"},{"v":1.5,"d":"1.50"},{"v":1.5,"d":"1.50"},{"v":1.8,"d":"1.80"},{"v":2,"d":"2.00"},{"v":2,"d":"2.00"},{"v":2,"d":"2.00"},{"v":2,"d":"2.00"},null,{"$f":"SUM('Channel marketing budget'!$D9:$O9)","v":{"v":16.950000000000003,"d":"16.95"}}]
[null,"Personnel total $(000)",null,{"$f":"SUM(D8:D9)","v":25.75},{"$f":"SUM(E8:E9)","v":{"v":25.2,"d":"25.20"}},{"v":25.5,"d":"25.50"},{"v":26.5,"d":"26.50"},{"v":26.2,"d":"26.20"},{"v":26.5,"d":"26.50"},{"v":26.5,"d":"26.50"},{"v":26.8,"d":"26.80"},{"v":27,"d":"27.00"},{"v":27,"d":"27.00"},{"v":27,"d":"27.00"},{"v":27,"d":"27.00"},null,{"$f":"SUM(Q8:Q9)","v":316.95}]
[null,"DIRECT MARKETING ITEMS","Rate","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
[null,"DIRECT MARKETING (% OF TOTAL SALES)",null,{"v":1,"d":"100%"},{"v":1,"d":"100%"},{"v":0.75,"d":"75%"},{"v":0.4,"d":"40%"},{"v":0.33,"d":"33%"},{"v":0.25,"d":"25%"},{"v":0.2,"d":"20%"},{"v":0.1,"d":"10%"},{"v":0.05,"d":"5%"},{"v":0.05,"d":"5%"},{"v":0.05,"d":"5%"},{"v":0.05,"d":"5%"}]
[null,"Telemarketing (% of direct sales)",null,{"v":1,"d":"100%"},{"v":0.5,"d":"50%"},{"v":0.5,"d":"50%"},{"v":0.5,"d":"50%"},{"v":0.5,"d":"50%"},{"v":0.5,"d":"50%"},{"v":0.5,"d":"50%"},{"v":0.5,"d":"50%"},{"v":0.5,"d":"50%"},{"v":0.5,"d":"50%"},{"v":0.5,"d":"50%"},{"v":0.5,"d":"50%"}]
[null,"Human resources - headcount",3,{"$f":"$C$14*D13","v":3},1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,1.5,null,{"$f":"SUM('Channel marketing budget'!$D14:$O14)","v":{"v":19.5,"d":"19.50"}}]
[null,"Infrastructure support",null,25,10,25,10,25,10,25,10,25,10,25,10,null,{"$f":"SUM('Channel marketing budget'!$D15:$O15)","v":{"v":210,"d":"210.00"}}]
[null,"Commission",{"v":1E-3,"d":"0.10%"},{"$f":"$C$16*D4*D12*D13","v":0.75},{"v":0.1,"d":"0.10"},{"v":0.1875,"d":"0.19"},{"v":0.30000000000000004,"d":"0.30"},{"v":0.198,"d":"0.20"},{"v":0.1875,"d":"0.19"},{"v":0.15000000000000002,"d":"0.15"},{"v":0.09000000000000001,"d":"0.09"},0.05,0.05,0.05,0.05,null,{"$f":"SUM('Channel marketing budget'!$D16:$O16)","v":{"v":2.163,"d":"2.16"}}]
[null,"Training",null,25,10,25,10,25,10,25,10,25,10,25,10,null,{"$f":"SUM('Channel marketing budget'!$D17:$O17)","v":{"v":210,"d":"210.00"}}]
[null,"Telemarketing total $(000)",null,{"$f":"SUM(D14:D17)","v":53.75},{"$f":"SUM(E14:E17)","v":{"v":21.6,"d":"21.60"}},{"$f":"SUM(F14:F17)","v":{"v":51.6875,"d":"51.69"}},{"v":21.8,"d":"21.80"},{"v":51.698,"d":"51.70"},{"v":21.6875,"d":"21.69"},51.65,21.59,51.55,21.55,51.55,21.55,null,{"$f":"SUM(Q14:Q17)","v":{"v":441.663,"d":"441.66"}}]
[null,"INTERNET MARKETING ITEMS","Rate","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
[null,"INTERNET MARKETING (% OF DIRECT SALES)",null,{"v":0.25,"d":"25%"},{"v":0.25,"d":"25%"},{"v":0.25,"d":"25%"},{"v":0.25,"d":"25%"},{"v":0.25,"d":"25%"},{"v":0.25,"d":"25%"},{"v":0.25,"d":"25%"},{"v":0.25,"d":"25%"},{"v":0.25,"d":"25%"},{"v":0.25,"d":"25%"},{"v":0.25,"d":"25%"},{"v":0.25,"d":"25%"}]
[null,"Human resources - headcount",1,{"$f":"$C$21*D20","v":0.25},0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,0.25,null,{"$f":"SUM('Channel marketing budget'!$D21:$O21)","v":{"v":3,"d":"3.00"}}]
[null,"Website development (one-time cost)",null,500,{"$nulls":12},{"$f":"SUM('Channel marketing budget'!$D22:$O22)","v":{"v":500,"d":"500.00"}}]
[null,"Hosting",null,10,10,10,10,10,10,10,10,10,10,10,10,null,{"$f":"SUM('Channel marketing budget'!$D23:$O23)","v":{"v":120,"d":"120.00"}}]
[null,"Support & maintenance",null,25,{"$nulls":9},25,null,null,{"$f":"SUM('Channel marketing budget'!$D24:$O24)","v":{"v":50,"d":"50.00"}}]
[null,"Social platform 1",null,null,100,null,100,null,100,null,100,null,100,null,100,null,{"$f":"SUM('Channel marketing budget'!$D25:$O25)","v":{"v":600,"d":"600.00"}}]
[null,"Social platform 2",null,100,null,100,null,100,null,100,null,100,null,100,null,null,{"$f":"SUM('Channel marketing budget'!$D26:$O26)","v":{"v":600,"d":"600.00"}}]
[null,"Social platform 3",null,null,100,null,100,100,{"$nulls":3},100,100,null,100,null,{"$f":"SUM('Channel marketing budget'!$D27:$O27)","v":{"v":600,"d":"600.00"}}]
[null,"Internet marketing total $(000)",null,{"$f":"SUM(D21:D24)","v":535.25},10.25,10.25,10.25,10.25,10.25,10.25,10.25,10.25,10.25,35.25,10.25,null,{"$f":"SUM(Q21:Q24)","v":{"v":673,"d":"673.00"}}]
[null,"DIRECT MAIL ITEMS","Rate","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
[null,"DIRECT MAIL (% OF DIRECT SALES)"]
[null,"Human resources - cost",{"$nulls":14},{"$f":"SUM('Channel marketing budget'!$D31:$O31)","v":{"v":0,"d":"0.00"}}]
[null,"Material",null,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,null,{"$f":"SUM('Channel marketing budget'!$D32:$O32)","v":{"v":12000,"d":"12,000.00"}}]
[null,"Postage",null,250,250,250,250,250,250,250,250,250,250,250,250,null,{"$f":"SUM('Channel marketing budget'!$D33:$O33)","v":{"v":3000,"d":"3,000.00"}}]
[null,"Direct mail total $(000)",null,{"$f":"SUM(D31:D33)","v":{"v":1250,"d":"1,250.00"}},{"$f":"SUM(E31:E33)","v":{"v":1250,"d":"1,250.00"}},{"v":1250,"d":"1,250.00"},{"v":1250,"d":"1,250.00"},{"v":1250,"d":"1,250.00"},{"v":1250,"d":"1,250.00"},{"v":1250,"d":"1,250.00"},{"v":1250,"d":"1,250.00"},{"v":1250,"d":"1,250.00"},{"v":1250,"d":"1,250.00"},{"v":1250,"d":"1,250.00"},{"v":1250,"d":"1,250.00"},null,{"$f":"SUM(Q31:Q33)","v":{"v":15000,"d":"15,000.00"}}]
[null,"Direct marketing total $(000)",null,{"$f":"SUM('Channel marketing budget'!$D$34,'Channel marketing budget'!$D$28,'Channel marketing budget'!$D$18)","v":{"v":1839,"d":"1,839.00"}},{"$f":"SUM('Channel marketing budget'!$E$34,'Channel marketing budget'!$E$28,'Channel marketing budget'!$E$18)","v":{"v":1281.85,"d":"1,281.85"}},{"$f":"SUM('Channel marketing budget'!$F$34,'Channel marketing budget'!$F$28,'Channel marketing budget'!$F$18)","v":{"v":1311.9375,"d":"1,311.94"}},{"$f":"SUM('Channel marketing budget'!$G$34,'Channel marketing budget'!$G$28,'Channel marketing budget'!$G$18)","v":{"v":1282.05,"d":"1,282.05"}},{"$f":"SUM('Channel marketing budget'!$H$34,'Channel marketing budget'!$H$28,'Channel marketing budget'!$H$18)","v":{"v":1311.948,"d":"1,311.95"}},{"$f":"SUM('Channel marketing budget'!$I$34,'Channel marketing budget'!$I$28,'Channel marketing budget'!$I$18)","v":{"v":1281.9375,"d":"1,281.94"}},{"$f":"SUM('Channel marketing budget'!$J$34,'Channel marketing budget'!$J$28,'Channel marketing budget'!$J$18)","v":{"v":1311.9,"d":"1,311.90"}},{"$f":"SUM('Channel marketing budget'!$K$34,'Channel marketing budget'!$K$28,'Channel marketing budget'!$K$18)","v":{"v":1281.84,"d":"1,281.84"}},{"$f":"SUM('Channel marketing budget'!$L$34,'Channel marketing budget'!$L$28,'Channel marketing budget'!$L$18)","v":{"v":1311.8,"d":"1,311.80"}},{"$f":"SUM('Channel marketing budget'!$M$34,'Channel marketing budget'!$M$28,'Channel marketing budget'!$M$18)","v":{"v":1281.8,"d":"1,281.80"}},{"$f":"SUM('Channel marketing budget'!$N$34,'Channel marketing budget'!$N$28,'Channel marketing budget'!$N$18)","v":{"v":1336.8,"d":"1,336.80"}},{"$f":"SUM('Channel marketing budget'!$O$34,'Channel marketing budget'!$O$28,'Channel marketing budget'!$O$18)","v":{"v":1281.8,"d":"1,281.80"}},null,{"$f":"SUM(Q34,Q28,Q18,Q10)","v":{"v":16431.613,"d":"16,431.61"}}]
[null,"AGENT/BROKER ITEMS","Rate","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
[null,"AGENT/BROKER (% OF TOTAL SALES)",null,{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"},{"v":0.1,"d":"10%"}]
[null,"Communication",null,50,50,50,50,50,50,50,50,50,50,50,50,null,{"$f":"SUM('Channel marketing budget'!$D38:$O38)","v":{"v":600,"d":"600.00"}}]
[null,"Training",null,{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},null,{"$f":"SUM('Channel marketing budget'!$D39:$O39)","v":{"v":3000,"d":"3,000.00"}}]
[null,"Promotions",null,{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},null,{"$f":"SUM('Channel marketing budget'!$D40:$O40)","v":{"v":7200,"d":"7,200.00"}}]
[null,"Discounts",{"v":0.1,"d":"10.00%"},{"$f":"D4*D37*$C$41","v":{"v":7.5,"d":"7.50"}},{"v":2,"d":"2.00"},{"v":5,"d":"5.00"},{"v":15,"d":"15.00"},{"v":12,"d":"12.00"},{"v":15,"d":"15.00"},{"v":15,"d":"15.00"},{"v":18,"d":"18.00"},{"v":20,"d":"20.00"},{"v":20,"d":"20.00"},{"v":20,"d":"20.00"},{"v":20,"d":"20.00"},null,{"$f":"SUM('Channel marketing budget'!$D41:$O41)","v":{"v":169.5,"d":"169.50"}}]
[null,"Commission (% of agent's sales)",{"v":0.1,"d":"10.00%"},{"$f":"D4*D37*$C$42","v":{"v":7.5,"d":"7.50"}},{"v":2,"d":"2.00"},{"v":5,"d":"5.00"},{"v":15,"d":"15.00"},{"v":12,"d":"12.00"},{"v":15,"d":"15.00"},{"v":15,"d":"15.00"},{"v":18,"d":"18.00"},{"v":20,"d":"20.00"},{"v":20,"d":"20.00"},{"v":20,"d":"20.00"},{"v":20,"d":"20.00"},null,{"$f":"SUM('Channel marketing budget'!$D42:$O42)","v":{"v":169.5,"d":"169.50"}}]
[null,"Agent/broker total $(000)",null,{"$f":"SUM(D38:D42)","v":{"v":915,"d":"915.00"}},{"$f":"SUM(E38:E42)","v":{"v":904,"d":"904.00"}},{"v":910,"d":"910.00"},{"v":930,"d":"930.00"},{"v":924,"d":"924.00"},{"v":930,"d":"930.00"},{"v":930,"d":"930.00"},{"v":936,"d":"936.00"},{"v":940,"d":"940.00"},{"v":940,"d":"940.00"},{"v":940,"d":"940.00"},{"v":940,"d":"940.00"},null,{"$f":"SUM(Q38:Q42)","v":{"v":11139,"d":"11,139.00"}}]
[null,"DISTRIBUTORS ITEMS","Rate","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
[null,"DISTRIBUTORS (% OF TOTAL SALES)",null,{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0.15,"d":"15%"},{"v":0.2,"d":"20%"},{"v":0.4,"d":"40%"},{"v":0.4,"d":"40%"},{"v":0.4,"d":"40%"},{"v":0.4,"d":"40%"},{"v":0.4,"d":"40%"}]
[null,"Communication",null,50,50,50,50,50,50,50,50,50,50,50,50,null,{"$f":"SUM('Channel marketing budget'!$D46:$O46)","v":{"v":600,"d":"600.00"}}]
[null,"Training",null,{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},null,{"$f":"SUM('Channel marketing budget'!$D47:$O47)","v":{"v":3000,"d":"3,000.00"}}]
[null,"Promotions",null,{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},null,{"$f":"SUM('Channel marketing budget'!$D48:$O48)","v":{"v":7200,"d":"7,200.00"}}]
[null,"Commission/discounts (% of distributors' sales)",{"v":0.15,"d":"15.00%"},{"$f":"D4*D45*$C$49","v":0},0,0,0,0,33.75,45,108,120,120,120,120,null,{"$f":"SUM('Channel marketing budget'!$D49:$O49)","v":666.75}]
[null,"Distributor total $(000)",null,{"$f":"SUM(D46:D49)","v":{"v":900,"d":"900.00"}},{"$f":"SUM(E46:E49)","v":{"v":900,"d":"900.00"}},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},933.75,{"v":945,"d":"945.00"},{"v":1008,"d":"1,008.00"},{"v":1020,"d":"1,020.00"},{"v":1020,"d":"1,020.00"},{"v":1020,"d":"1,020.00"},{"v":1020,"d":"1,020.00"},null,{"$f":"SUM(Q46:Q49)","v":{"v":11466.75,"d":"11,466.75"}}]
[null,"RETAIL ITEMS","Rate","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
[null,"RETAILER (% OF TOTAL SALES)",null,{"v":0,"d":"0%"},{"v":0,"d":"0%"},{"v":0.25,"d":"25%"},{"v":0.6,"d":"60%"},{"v":0.67,"d":"67%"},{"v":0.6,"d":"60%"},{"v":0.6,"d":"60%"},{"v":0.5,"d":"50%"},{"v":0.3,"d":"30%"},{"v":0.3,"d":"30%"},{"v":0.3,"d":"30%"},{"v":0.3,"d":"30%"}]
[null,"Communication",null,50,50,50,50,50,50,50,50,50,50,50,50]
[null,"Training",null,{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},null,{"$f":"SUM('Channel marketing budget'!$D53:$O53)","v":{"v":600,"d":"600.00"}}]
[null,"Promotions",null,{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},{"v":600,"d":"600.00"},null,{"$f":"SUM('Channel marketing budget'!$D54:$O54)","v":{"v":3000,"d":"3,000.00"}}]
[null,"Commission/discounts (% of retail sales)",{"v":0.1,"d":"10.00%"},{"$f":"D4*D52*$C$56","v":0},0,12.5,90,80.4,90,90,90,60,60,60,60,null,{"$f":"SUM('Channel marketing budget'!$D56:$O56)","v":{"v":692.9,"d":"692.90"}}]
[null,"Retailer total $(000)",null,{"$f":"SUM(D53:D56)","v":{"v":900,"d":"900.00"}},{"$f":"SUM(E53:E56)","v":{"v":900,"d":"900.00"}},{"v":912.5,"d":"912.50"},{"v":990,"d":"990.00"},{"v":980.4,"d":"980.40"},{"v":990,"d":"990.00"},{"v":990,"d":"990.00"},{"v":990,"d":"990.00"},{"v":960,"d":"960.00"},{"v":960,"d":"960.00"},{"v":960,"d":"960.00"},{"v":960,"d":"960.00"},null,{"$f":"SUM(Q54:Q56)","v":{"v":4292.9,"d":"4,292.90"}}]
[null,"CUSTOMER ACQUISTION & RETENTION (CAR) ITEMS","Rate","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
[null,"CUSTOMER ACQUISITION & RETENTION (CAR)"]
[null,"Human resources",null,50,50,50,50,50,50,50,50,50,50,50,50,null,{"$f":"SUM('Channel marketing budget'!$D60:$O60)","v":{"v":600,"d":"600.00"}}]
[null,"Communications",null,{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},null,{"$f":"SUM('Channel marketing budget'!$D61:$O61)","v":{"v":3000,"d":"3,000.00"}}]
[null,"Promotions/coupons",null,600,600,600,600,600,600,600,600,600,600,600,600,null,{"$f":"SUM('Channel marketing budget'!$D62:$O62)","v":{"v":7200,"d":"7,200.00"}}]
[null,"CAR total $(000)",null,{"$f":"SUM(D60:D62)","v":{"v":900,"d":"900.00"}},{"$f":"SUM(E60:E62)","v":{"v":900,"d":"900.00"}},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},null,{"$f":"SUM(Q60:Q62)","v":{"v":10800,"d":"10,800.00"}}]
[null,"OTHER EXPENSE ITEMS","Rate","Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"]
[null,"OTHER EXPENSES"]
[null,"Travel",null,50,50,50,50,50,50,50,50,50,50,50,50,null,{"$f":"SUM('Channel marketing budget'!$D66:$O66)","v":{"v":600,"d":"600.00"}}]
[null,"Infrastructure (computer, telephone, etc.)",null,{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},{"v":250,"d":"250.00"},null,{"$f":"SUM('Channel marketing budget'!$D67:$O67)","v":{"v":3000,"d":"3,000.00"}}]
[null,"Channel support",null,600,600,600,600,600,600,600,600,600,600,600,600,null,{"$f":"SUM('Channel marketing budget'!$D68:$O68)","v":{"v":7200,"d":"7,200.00"}}]
[null,"Other expenses total $(000)",null,{"$f":"SUM(D66:D68)","v":{"v":900,"d":"900.00"}},{"$f":"SUM(E66:E68)","v":{"v":900,"d":"900.00"}},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},{"v":900,"d":"900.00"},null,{"$f":"SUM(Q66:Q68)","v":{"v":10800,"d":"10,800.00"}}]
[]
[null,"TOTAL MARKETING BUDGET:",null,{"$f":"SUM(D35,'Channel marketing budget'!$D$43,'Channel marketing budget'!$D$50,'Channel marketing budget'!$D$57,'Channel marketing budget'!$D$63,'Channel marketing budget'!$D$69)","v":{"v":6354,"d":"6,354.00"}},{"$f":"SUM('Channel marketing budget'!$E$69,'Channel marketing budget'!$E$63,'Channel marketing budget'!$E$57,'Channel marketing budget'!$E$50,'Channel marketing budget'!$E$43,E35)","v":{"v":5785.85,"d":"5,785.85"}},{"$f":"SUM('Channel marketing budget'!$F$69,'Channel marketing budget'!$F$63,'Channel marketing budget'!$F$57,'Channel marketing budget'!$F$50,'Channel marketing budget'!$F$43,F35)","v":{"v":5834.4375,"d":"5,834.44"}},{"$f":"SUM('Channel marketing budget'!$G$69,'Channel marketing budget'!$G$63,'Channel marketing budget'!$G$57,'Channel marketing budget'!$G$50,'Channel marketing budget'!$G$43,G35)","v":{"v":5902.05,"d":"5,902.05"}},{"$f":"SUM('Channel marketing budget'!$H$69,'Channel marketing budget'!$H$63,'Channel marketing budget'!$H$57,'Channel marketing budget'!$H$50,'Channel marketing budget'!$H$43,H35)","v":{"v":5916.348,"d":"5,916.35"}},{"$f":"SUM('Channel marketing budget'!$I$69,'Channel marketing budget'!$I$63,'Channel marketing budget'!$I$57,'Channel marketing budget'!$I$50,'Channel marketing budget'!$I$43,I35)","v":{"v":5935.6875,"d":"5,935.69"}},{"$f":"SUM('Channel marketing budget'!$J$69,'Channel marketing budget'!$J$63,'Channel marketing budget'!$J$57,'Channel marketing budget'!$J$50,'Channel marketing budget'!$J$43,J35)","v":{"v":5976.9,"d":"5,976.90"}},{"$f":"SUM('Channel marketing budget'!$K$69,'Channel marketing budget'!$K$63,'Channel marketing budget'!$K$57,'Channel marketing budget'!$K$50,'Channel marketing budget'!$K$43,K35)","v":{"v":6015.84,"d":"6,015.84"}},{"$f":"SUM('Channel marketing budget'!$L$69,'Channel marketing budget'!$L$63,'Channel marketing budget'!$L$57,'Channel marketing budget'!$L$50,'Channel marketing budget'!$L$43,L35)","v":{"v":6031.8,"d":"6,031.80"}},{"$f":"SUM('Channel marketing budget'!$M$69,'Channel marketing budget'!$M$63,'Channel marketing budget'!$M$57,'Channel marketing budget'!$M$50,'Channel marketing budget'!$M$43,M35)","v":{"v":6001.8,"d":"6,001.80"}},{"$f":"SUM('Channel marketing budget'!$N$69,'Channel marketing budget'!$N$63,'Channel marketing budget'!$N$57,'Channel marketing budget'!$N$50,'Channel marketing budget'!$N$43,N35)","v":{"v":6056.8,"d":"6,056.80"}},{"$f":"SUM('Channel marketing budget'!$O$69,'Channel marketing budget'!$O$63,'Channel marketing budget'!$O$57,'Channel marketing budget'!$O$50,'Channel marketing budget'!$O$43,O35)","v":{"v":6001.8,"d":"6,001.80"}},null,{"$f":"Q73","v":{"v":0,"d":"0.00"}}]