{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["渠道营销预算"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"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":"渠道营销预算","index":0,"n_rows":58,"n_cols":17,"rows_kept":58,"cut":false,"hidden":false,"merged":[]}
[null,"渠道市场营销预算"]
[null,null,"费率","第 1 个月","第 2 个月","第 3 个月","第 4 个月","第 5 个月","第 6 个月","第 7 个月","第 8 个月","第 9 个月","第 10 个月","第 11 个月","第 12 个月",null,"总计"]
[null,"预计销售总额 ¥(000)",null,750,200,500,1500,1200,1500,1500,1800,2000,2000,2000,2000,null,{"$f":"SUM(D3:O3)","v":16950}]
[null,"个人（占销售总额的百分比）",null,{"$f":"D9+D28+D35+D41","v":1.1000000000000001},1.1000000000000001,1.1000000000000001,1.1000000000000001,1.1000000000000001,1.1000000000000001,1.1000000000000001,1.1000000000000001,0.85000000000000009,0.85000000000000009,0.85000000000000009,0.85000000000000009]
[null,"人力资源 - 人数",5,{"$f":"+$C$5","v":5},5,5,5,5,5,5,5,5,5,5,5]
[null,"人力资源 - 成本",null,{"$f":"$C$5*D5","v":25},25,25,25,25,25,25,25,25,25,25,25,null,{"$f":"SUM(渠道营销预算!$D6:$O6)","v":300}]
[null,"佣金",1E-3,{"$f":"D3*$C$7","v":0.75},0.2,0.5,1.5,1.2,1.5,1.5,1.8,2,2,2,2,null,{"$f":"SUM(渠道营销预算!$D7:$O7)","v":16.950000000000003}]
[null,"人员总额 ¥(000)",null,{"$f":"SUM(D6:D7)","v":25.75},25.2,25.5,26.5,26.2,26.5,26.5,26.8,27,27,27,27,null,{"$f":"SUM(渠道营销预算!$D8:$O8)","v":316.95000000000005}]
[null,"直接营销（占销售总额的百分比）",null,1,1,0.75,0.4,0.33,0.25,0.2,0.1,0.05,0.05,0.05,0.05]
[null,"电话营销（占直接销售的百分比）",null,1,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
[null,"人力资源 - 人数",3,{"$f":"$C$11*D10","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(渠道营销预算!$D11:$O11)","v":19.5}]
[null,"基础设施支持",null,25,10,25,10,25,10,25,10,25,10,25,10,null,{"$f":"SUM(渠道营销预算!$D12:$O12)","v":210}]
[null,"佣金",1E-3,{"$f":"$C$13*D3*D9*D10","v":0.75},0.1,0.1875,0.30000000000000004,0.19800000000000001,0.1875,0.15000000000000002,9.0000000000000011E-2,0.05,0.05,0.05,0.05,null,{"$f":"SUM(渠道营销预算!$D13:$O13)","v":2.1629999999999998}]
[null,"培训",null,25,10,25,10,25,10,25,10,25,10,25,10,null,{"$f":"SUM(渠道营销预算!$D14:$O14)","v":210}]
[null,"电话营销总额 ¥(000)",null,{"$f":"SUM(D11:D14)","v":53.75},21.6,51.6875,21.8,51.698,21.6875,51.65,21.59,51.55,21.55,51.55,21.55,null,{"$f":"SUM(渠道营销预算!$D15:$O15)","v":441.66300000000001}]
[null,"网络营销（占直接销售的百分比）",null,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,"人力资源 - 人数",1,{"$f":"$C$17*D16","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(渠道营销预算!$D17:$O17)","v":3}]
[null,"网站开发（一次性成本）",null,500,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(渠道营销预算!$D18:$O18)","v":500}]
[null,"托管",null,10,10,10,10,10,10,10,10,10,10,10,10,null,{"$f":"SUM(渠道营销预算!$D19:$O19)","v":120}]
[null,"支持和维护",null,25,null,null,null,null,null,null,null,null,null,25,null,null,{"$f":"SUM(渠道营销预算!$D20:$O20)","v":50}]
[null,"网络营销总额 ¥(000)",null,{"$f":"SUM(D17:D20)","v":535.25},{"$f":"SUM(E17:E20)","v":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(渠道营销预算!$D21:$O21)","v":673}]
[null,"直接邮件（占直接销售的百分比）"]
[null,"人力资源 - 成本",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(渠道营销预算!$D23:$O23)","v":0}]
[null,"材料",null,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,null,{"$f":"SUM(渠道营销预算!$D24:$O24)","v":12000}]
[null,"邮资",null,250,250,250,250,250,250,250,250,250,250,250,250,null,{"$f":"SUM(渠道营销预算!$D25:$O25)","v":3000}]
[null,"直接邮件总额 ¥(000)",null,{"$f":"SUM(D23:D25)","v":1250},{"$f":"SUM(E23:E25)","v":1250},1250,1250,1250,1250,1250,1250,1250,1250,1250,1250,null,15000]
[null,"直接营销总额 ¥(000)",null,{"$f":"SUM(D15,D21,D26)","v":1839},1281.8499999999999,1311.9375,1282.05,1311.9480000000001,1281.9375,1311.9,1281.8399999999999,1311.8,1281.8,1336.8,1281.8,null,{"$f":"SUM(Q15,Q21,Q26)","v":16114.663}]
[null,"代理商/经纪人（占销售总额的百分比）",null,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1,0.1]
[null,"通信",null,50,50,50,50,50,50,50,50,50,50,50,50,null,{"$f":"SUM(渠道营销预算!$D29:$O29)","v":600}]
[null,"培训",null,250,250,250,250,250,250,250,250,250,250,250,250,null,{"$f":"SUM(渠道营销预算!$D30:$O30)","v":3000}]
[null,"促销",null,600,600,600,600,600,600,600,600,600,600,600,600,null,{"$f":"SUM(渠道营销预算!$D31:$O31)","v":7200}]
[null,"折扣",0.1,{"$f":"D3*D28*$C$32","v":7.5},2,5,15,12,15,15,18,20,20,20,20,null,{"$f":"SUM(渠道营销预算!$D32:$O32)","v":169.5}]
[null,"佣金（占代理商销售的百分比）",0.1,{"$f":"D3*D28*$C$33","v":7.5},2,5,15,12,15,15,18,20,20,20,20,null,{"$f":"SUM(渠道营销预算!$D33:$O33)","v":169.5}]
[null,"代理商/经纪人总额 ¥(000)",null,{"$f":"SUM(D29:D33)","v":915},{"$f":"SUM(E29:E33)","v":904},910,930,924,930,930,936,940,940,940,940,null,11139]
[null,"分销商（占销售总额的百分比）",null,0,0,0,0,0,0.15,0.2,0.4,0.4,0.4,0.4,0.4]
[null,"通信",null,50,50,50,50,50,50,50,50,50,50,50,50,null,{"$f":"SUM(渠道营销预算!$D36:$O36)","v":600}]
[null,"培训",null,250,250,250,250,250,250,250,250,250,250,250,250,null,{"$f":"SUM(渠道营销预算!$D37:$O37)","v":3000}]
[null,"促销",null,600,600,600,600,600,600,600,600,600,600,600,600,null,{"$f":"SUM(渠道营销预算!$D38:$O38)","v":7200}]
[null,"佣金/折扣（占分销商销售的百分比）",0.15,{"$f":"D3*D35*$C$39","v":0},0,0,0,0,33.75,45,108,120,120,120,120,null,{"$f":"SUM(渠道营销预算!$D39:$O39)","v":666.75}]
[null,"分销商总额 ¥(000)",null,{"$f":"SUM(D36:D39)","v":900},900,900,900,900,933.75,945,1008,1020,1020,1020,1020,null,11466.75]
[null,"零售商（占销售总额的百分比）",null,0,0,0.25,0.6,0.67,0.6,0.6,0.5,0.3,0.3,0.3,0.3]
[null,"通信",null,50,50,50,50,50,50,50,50,50,50,50,50,null,{"$f":"SUM(渠道营销预算!$D42:$O42)","v":600}]
[null,"培训",null,250,250,250,250,250,250,250,250,250,250,250,250,null,{"$f":"SUM(渠道营销预算!$D43:$O43)","v":3000}]
[null,"促销",null,600,600,600,600,600,600,600,600,600,600,600,600,null,{"$f":"SUM(渠道营销预算!$D44:$O44)","v":7200}]
[null,"佣金/折扣（占零售的百分比）",0.1,{"$f":"D3*D41*$C$45","v":0},0,12.5,90,80.400000000000006,90,90,90,60,60,60,60,null,{"$f":"SUM(渠道营销预算!$D45:$O45)","v":692.9}]
[null,"零售商总额 ¥(000)",null,{"$f":"SUM(D42:D45)","v":900},900,912.5,990,980.4,990,990,990,960,960,960,960,null,11492.9]
[null,"客户获取和保留 (CAR)"]
[null,"人力资源",null,50,50,50,50,50,50,50,50,50,50,50,50,null,{"$f":"SUM(渠道营销预算!$D48:$O48)","v":600}]
[null,"通信",null,250,250,250,250,250,250,250,250,250,250,250,250,null,{"$f":"SUM(渠道营销预算!$D49:$O49)","v":3000}]
[null,"促销/礼券",null,600,600,600,600,600,600,600,600,600,600,600,600,null,{"$f":"SUM(渠道营销预算!$D50:$O50)","v":7200}]
[null,"CAR 总额 ¥(000)",null,{"$f":"SUM(D48:D50)","v":900},900,900,900,900,900,900,900,900,900,900,900,null,10800]
[null,"其他费用"]
[null,"旅行",null,50,50,50,50,50,50,50,50,50,50,50,50,null,{"$f":"SUM(渠道营销预算!$D53:$O53)","v":600}]
[null,"基础设施（计算机、电话等）",null,250,250,250,250,250,250,250,250,250,250,250,250,null,{"$f":"SUM(渠道营销预算!$D54:$O54)","v":3000}]
[null,"渠道支持",null,600,600,600,600,600,600,600,600,600,600,600,600,null,{"$f":"SUM(渠道营销预算!$D55:$O55)","v":7200}]
[null,"其他费用总额 ¥(000)",null,{"$f":"SUM(D53:D55)","v":900},900,900,900,900,900,900,900,900,900,900,900,null,10800]
[]
[null,"营销预算总额：",null,{"$f":"SUM(D8,D27,D34,D40,D46,D51,D56)","v":6379.75},5811.05,5859.9375,5928.55,5942.5479999999998,5962.1875,6003.4,6042.6399999999994,6058.8,6028.8,6083.8,6028.8,null,{"$f":"SUM(Q8,Q27,Q34,Q40,Q46,Q51,Q56)","v":72130.263000000006}]