{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Start","Channel Marketing Budget"],"not_rendered":{"images":1,"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":70,"n_cols":17,"rows_kept":70,"merged":[[0,1,0,19],[1,16,1,19],[2,16,2,19],[4,16,4,19],[5,16,5,19],[35,16,35,19],[36,16,36,19],[37,16,37,19],[38,16,38,19],[39,16,39,19],[40,16,40,19],[41,16,41,17]]}
[]
[null," ","Rate","Month 1","Month 2","Month 3","Month 4","Month 5","Month 6","Month 7","Month 8","Month 9","Month 10","Month 11","Month 12",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(D3:O3)","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.","Personnel Items","Rate","Month 1","Month 2","Month 3","Month 4","Month 5","Month 6","Month 7","Month 8","Month 9","Month 10","Month 11","Month 12"]
[null,"PERSONNEL (% OF TOTAL SALES)",null,{"$f":"D11+D36+D44+D51","v":{"v":1.1,"d":"110%"}},{"v":1.1,"d":"110%"},{"$f":"F11+F36+F44+F51","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":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$6","v":5},5,5,5,5,5,5,5,5,5,5,5]
[null,"Human Resources - Cost",null,{"$f":"$C$6*D6","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'!$D7:$O7)","v":{"v":300,"d":"300.00"}}]
[null,"Commission",{"v":1E-3,"d":"0.10%"},{"$f":"D3*$C$8","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'!$D8:$O8)","v":{"v":16.950000000000003,"d":"16.95"}}]
[null,"Personnel Total $(000)",null,{"$f":"SUM(D7:D8)","v":25.75},{"$f":"SUM(E7:E8)","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(Q7:Q8)","v":316.95}]
[null,"DIRECT MARKETING ITEMS","Rate","Month 1","Month 2","Month 3","Month 4","Month 5","Month 6","Month 7","Month 8","Month 9","Month 10","Month 11","Month 12"]
[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$13*D12","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'!$D13:$O13)","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'!$D14:$O14)","v":{"v":210,"d":"210.00"}}]
[null,"Commission",{"v":1E-3,"d":"0.10%"},{"$f":"$C$15*D3*D11*D12","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'!$D15:$O15)","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'!$D16:$O16)","v":{"v":210,"d":"210.00"}}]
[null,"Telemarketing Total $(000)",null,{"$f":"SUM(D13:D16)","v":53.75},{"$f":"SUM(E13:E16)","v":{"v":21.6,"d":"21.60"}},{"$f":"SUM(F13:F16)","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(Q13:Q16)","v":{"v":441.663,"d":"441.66"}}]
[null,"INTERNET MARKETING ITEMS","Rate","Month 1","Month 2","Month 3","Month 4","Month 5","Month 6","Month 7","Month 8","Month 9","Month 10","Month 11","Month 12"]
[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$20*D19","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'!$D20:$O20)","v":{"v":3,"d":"3.00"}}]
[null,"Website Development (one-time cost)",null,500,{"$nulls":12},{"$f":"SUM('Channel Marketing Budget'!$D21:$O21)","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'!$D22:$O22)","v":{"v":120,"d":"120.00"}}]
[null,"Support & Maintenance",null,25,{"$nulls":9},25,null,null,{"$f":"SUM('Channel Marketing Budget'!$D23:$O23)","v":{"v":50,"d":"50.00"}}]
[null,"Facebook",null,null,100,null,100,null,100,null,100,null,100,null,100,null,{"$f":"SUM('Channel Marketing Budget'!$D24:$O24)","v":{"v":600,"d":"600.00"}}]
[null,"Twitter",null,100,null,100,null,100,null,100,null,100,null,100,null,null,{"$f":"SUM('Channel Marketing Budget'!$D25:$O25)","v":{"v":600,"d":"600.00"}}]
[null,"YouTube",null,null,100,null,100,100,{"$nulls":3},100,100,null,100,null,{"$f":"SUM('Channel Marketing Budget'!$D26:$O26)","v":{"v":600,"d":"600.00"}}]
[null,"Internet Marketing Total $(000)",null,{"$f":"SUM(D20:D23)","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(Q20:Q23)","v":{"v":673,"d":"673.00"}}]
[null,"DIRECT MAIL ITEMS","Rate","Month 1","Month 2","Month 3","Month 4","Month 5","Month 6","Month 7","Month 8","Month 9","Month 10","Month 11","Month 12"]
[null,"DIRECT MAIL (% OF DIRECT SALES)"]
[null,"Human Resources - Cost",{"$nulls":14},{"$f":"SUM('Channel Marketing Budget'!$D30:$O30)","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'!$D31:$O31)","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'!$D32:$O32)","v":{"v":3000,"d":"3,000.00"}}]
[null,"Direct Mail Total $(000)",null,{"$f":"SUM(D30:D32)","v":{"v":1250,"d":"1,250.00"}},{"$f":"SUM(E30:E32)","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(Q30:Q32)","v":{"v":15000,"d":"15,000.00"}}]
[null,"Direct Marketing Total $(000)",null,{"$f":"SUM(DirectMail[[#Totals],[Month 1]],InternetMarketing[[#Totals],[Month 1]],DirectMarketing[[#Totals],[Month 1]])","v":{"v":1839,"d":"1,839.00"}},{"$f":"SUM(DirectMail[[#Totals],[Month 2]],InternetMarketing[[#Totals],[Month 2]],DirectMarketing[[#Totals],[Month 2]])","v":{"v":1281.85,"d":"1,281.85"}},{"$f":"SUM(DirectMail[[#Totals],[Month 3]],InternetMarketing[[#Totals],[Month 3]],DirectMarketing[[#Totals],[Month 3]])","v":{"v":1311.9375,"d":"1,311.94"}},{"$f":"SUM(DirectMail[[#Totals],[Month 4]],InternetMarketing[[#Totals],[Month 4]],DirectMarketing[[#Totals],[Month 4]])","v":{"v":1282.05,"d":"1,282.05"}},{"$f":"SUM(DirectMail[[#Totals],[Month 5]],InternetMarketing[[#Totals],[Month 5]],DirectMarketing[[#Totals],[Month 5]])","v":{"v":1311.948,"d":"1,311.95"}},{"$f":"SUM(DirectMail[[#Totals],[Month 6]],InternetMarketing[[#Totals],[Month 6]],DirectMarketing[[#Totals],[Month 6]])","v":{"v":1281.9375,"d":"1,281.94"}},{"$f":"SUM(DirectMail[[#Totals],[Month 7]],InternetMarketing[[#Totals],[Month 7]],DirectMarketing[[#Totals],[Month 7]])","v":{"v":1311.9,"d":"1,311.90"}},{"$f":"SUM(DirectMail[[#Totals],[Month 8]],InternetMarketing[[#Totals],[Month 8]],DirectMarketing[[#Totals],[Month 8]])","v":{"v":1281.84,"d":"1,281.84"}},{"$f":"SUM(DirectMail[[#Totals],[Month 9]],InternetMarketing[[#Totals],[Month 9]],DirectMarketing[[#Totals],[Month 9]])","v":{"v":1311.8,"d":"1,311.80"}},{"$f":"SUM(DirectMail[[#Totals],[Month 10]],InternetMarketing[[#Totals],[Month 10]],DirectMarketing[[#Totals],[Month 10]])","v":{"v":1281.8,"d":"1,281.80"}},{"$f":"SUM(DirectMail[[#Totals],[Month 11]],InternetMarketing[[#Totals],[Month 11]],DirectMarketing[[#Totals],[Month 11]])","v":{"v":1336.8,"d":"1,336.80"}},{"$f":"SUM(DirectMail[[#Totals],[Month 12]],InternetMarketing[[#Totals],[Month 12]],DirectMarketing[[#Totals],[Month 12]])","v":{"v":1281.8,"d":"1,281.80"}},null,{"$f":"SUM(Q33,Q27,Q17,Q9)","v":{"v":16431.613,"d":"16,431.61"}}]
[null,"AGENT/BROKER ITEMS","Rate","Month 1","Month 2","Month 3","Month 4","Month 5","Month 6","Month 7","Month 8","Month 9","Month 10","Month 11","Month 12"]
[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'!$D37:$O37)","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'!$D38:$O38)","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'!$D39:$O39)","v":{"v":7200,"d":"7,200.00"}}]
[null,"Discounts",{"v":0.1,"d":"10.00%"},{"$f":"D3*D36*$C$40","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'!$D40:$O40)","v":{"v":169.5,"d":"169.50"}}]
[null,"Commission (% of Agent's Sales)",{"v":0.1,"d":"10.00%"},{"$f":"D3*D36*$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,"Agent/Broker Total $(000)",null,{"$f":"SUM(D37:D41)","v":{"v":915,"d":"915.00"}},{"$f":"SUM(E37:E41)","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(Q37:Q41)","v":{"v":11139,"d":"11,139.00"}}]
[null,"DISTRIBUTORS ITEMS","Rate","Month 1","Month 2","Month 3","Month 4","Month 5","Month 6","Month 7","Month 8","Month 9","Month 10","Month 11","Month 12"]
[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'!$D45:$O45)","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(Dstributors[[#This Row],[Month 1]:[Month 12]])","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(Dstributors[[#This Row],[Month 1]:[Month 12]])","v":{"v":7200,"d":"7,200.00"}}]
[null,"Commission/Discounts (% of Distributors' Sales)",{"v":0.15,"d":"15.00%"},{"$f":"D3*D44*$C$48","v":0},0,0,0,0,33.75,45,108,120,120,120,120,null,{"$f":"SUM(Dstributors[[#This Row],[Month 1]:[Month 12]])","v":666.75}]
[null,"Distributor Total $(000)",null,{"$f":"SUM(D45:D48)","v":{"v":900,"d":"900.00"}},{"$f":"SUM(E45:E48)","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(Q45:Q48)","v":{"v":11466.75,"d":"11,466.75"}}]
[null,"RETAIL ITEMS","Rate","Month 1","Month 2","Month 3","Month 4","Month 5","Month 6","Month 7","Month 8","Month 9","Month 10","Month 11","Month 12"]
[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'!$D52:$O52)","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'!$D53:$O53)","v":{"v":3000,"d":"3,000.00"}}]
[null,"Commission/Discounts (% of Retail Sales)",{"v":0.1,"d":"10.00%"},{"$f":"D3*D51*$C$55","v":0},0,12.5,90,80.4,90,90,90,60,60,60,60,null,{"$f":"SUM('Channel Marketing Budget'!$D55:$O55)","v":{"v":692.9,"d":"692.90"}}]
[null,"Retailer Total $(000)",null,{"$f":"SUM(D52:D55)","v":{"v":900,"d":"900.00"}},{"$f":"SUM(E52:E55)","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(Q53:Q55)","v":{"v":4292.9,"d":"4,292.90"}}]
[null,"CUSTOMER ACQUISTION & RETENTION (CAR) ITEMS","Rate","Month 1","Month 2","Month 3","Month 4","Month 5","Month 6","Month 7","Month 8","Month 9","Month 10","Month 11","Month 12"]
[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'!$D59:$O59)","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'!$D60:$O60)","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'!$D61:$O61)","v":{"v":7200,"d":"7,200.00"}}]
[null,"CAR Total $(000)",null,{"$f":"SUM(D59:D61)","v":{"v":900,"d":"900.00"}},{"$f":"SUM(E59:E61)","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(Q59:Q61)","v":{"v":10800,"d":"10,800.00"}}]
[null,"OTHER EXPENSE ITEMS","Rate","Month 1","Month 2","Month 3","Month 4","Month 5","Month 6","Month 7","Month 8","Month 9","Month 10","Month 11","Month 12"]
[null,"OTHER EXPENSES"]
[null,"Travel",null,50,50,50,50,50,50,50,50,50,50,50,50,null,{"$f":"SUM('Channel Marketing Budget'!$D65:$O65)","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'!$D66:$O66)","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'!$D67:$O67)","v":{"v":7200,"d":"7,200.00"}}]
[null,"Other Expenses Total $(000)",null,{"$f":"SUM(D65:D67)","v":{"v":900,"d":"900.00"}},{"$f":"SUM(E65:E67)","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(Q65:Q67)","v":{"v":10800,"d":"10,800.00"}}]
[]
[null,"TOTAL MARKETING BUDGET:",null,{"$f":"SUM(D34,AgentAndBroker[[#Totals],[Month 1]],Dstributors[[#Totals],[Month 1]],Retailer[[#Totals],[Month 1]],CAR[[#Totals],[Month 1]],OtherExpenses[[#Totals],[Month 1]])","v":{"v":6354,"d":"6,354.00"}},{"$f":"SUM(OtherExpenses[[#Totals],[Month 2]],CAR[[#Totals],[Month 2]],Retailer[[#Totals],[Month 2]],Dstributors[[#Totals],[Month 2]],AgentAndBroker[[#Totals],[Month 2]],E34)","v":{"v":5785.85,"d":"5,785.85"}},{"$f":"SUM(OtherExpenses[[#Totals],[Month 3]],CAR[[#Totals],[Month 3]],Retailer[[#Totals],[Month 3]],Dstributors[[#Totals],[Month 3]],AgentAndBroker[[#Totals],[Month 3]],F34)","v":{"v":5834.4375,"d":"5,834.44"}},{"$f":"SUM(OtherExpenses[[#Totals],[Month 4]],CAR[[#Totals],[Month 4]],Retailer[[#Totals],[Month 4]],Dstributors[[#Totals],[Month 4]],AgentAndBroker[[#Totals],[Month 4]],G34)","v":{"v":5902.05,"d":"5,902.05"}},{"$f":"SUM(OtherExpenses[[#Totals],[Month 5]],CAR[[#Totals],[Month 5]],Retailer[[#Totals],[Month 5]],Dstributors[[#Totals],[Month 5]],AgentAndBroker[[#Totals],[Month 5]],H34)","v":{"v":5916.348,"d":"5,916.35"}},{"$f":"SUM(OtherExpenses[[#Totals],[Month 6]],CAR[[#Totals],[Month 6]],Retailer[[#Totals],[Month 6]],Dstributors[[#Totals],[Month 6]],AgentAndBroker[[#Totals],[Month 6]],I34)","v":{"v":5935.6875,"d":"5,935.69"}},{"$f":"SUM(OtherExpenses[[#Totals],[Month 7]],CAR[[#Totals],[Month 7]],Retailer[[#Totals],[Month 7]],Dstributors[[#Totals],[Month 7]],AgentAndBroker[[#Totals],[Month 7]],J34)","v":{"v":5976.9,"d":"5,976.90"}},{"$f":"SUM(OtherExpenses[[#Totals],[Month 8]],CAR[[#Totals],[Month 8]],Retailer[[#Totals],[Month 8]],Dstributors[[#Totals],[Month 8]],AgentAndBroker[[#Totals],[Month 8]],K34)","v":{"v":6015.84,"d":"6,015.84"}},{"$f":"SUM(OtherExpenses[[#Totals],[Month 9]],CAR[[#Totals],[Month 9]],Retailer[[#Totals],[Month 9]],Dstributors[[#Totals],[Month 9]],AgentAndBroker[[#Totals],[Month 9]],L34)","v":{"v":6031.8,"d":"6,031.80"}},{"$f":"SUM(OtherExpenses[[#Totals],[Month 10]],CAR[[#Totals],[Month 10]],Retailer[[#Totals],[Month 10]],Dstributors[[#Totals],[Month 10]],AgentAndBroker[[#Totals],[Month 10]],M34)","v":{"v":6001.8,"d":"6,001.80"}},{"$f":"SUM(OtherExpenses[[#Totals],[Month 11]],CAR[[#Totals],[Month 11]],Retailer[[#Totals],[Month 11]],Dstributors[[#Totals],[Month 11]],AgentAndBroker[[#Totals],[Month 11]],N34)","v":{"v":6056.8,"d":"6,056.80"}},{"$f":"SUM(OtherExpenses[[#Totals],[Month 12]],CAR[[#Totals],[Month 12]],Retailer[[#Totals],[Month 12]],Dstributors[[#Totals],[Month 12]],AgentAndBroker[[#Totals],[Month 12]],O34)","v":{"v":6001.8,"d":"6,001.80"}},null,{"$f":"Q72","v":{"v":0,"d":"0.00"}}]