{"text_format":"3","workbook":"xlsx","n_sheets":1,"sheets":["通路行銷預算"],"not_rendered":{"defined_names":2},"read":"whole","date_system":"1900"}

{"sheet":"通路行銷預算","index":0,"n_rows":58,"n_cols":17,"rows_kept":58}
[null,"通路行銷預算"]
[null,null,"比率","第 1 個月","第 2 個月","第 3 個月","第 4 個月","第 5 個月","第 6 個月","第 7 個月","第 8 個月","第 9 個月","第 10 個月","第 11 個月","第 12 個月",null,"合計"]
[null,"預期總銷售額 $(000)",null,750,200,500,{"v":1500,"d":"1,500"},{"v":1200,"d":"1,200"},{"v":1500,"d":"1,500"},{"v":1500,"d":"1,500"},{"v":1800,"d":"1,800"},{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},{"v":2000,"d":"2,000"},null,{"$f":"SUM(D3:O3)","v":{"v":16950,"d":"16,950"}}]
[null,"人事 (佔總銷售額的百分比)",null,{"$f":"D9+D28+D35+D41","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,"人力資源 - 人數",5,{"$f":"+$C$5","v":5},5,5,5,5,5,5,5,5,5,5,5]
[null,"人力資源 - 成本",null,{"$f":"$C$5*D5","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(通路行銷預算!$D6:$O6)","v":{"v":300,"d":"300.00"}}]
[null,"佣金",{"v":1E-3,"d":"0.10%"},{"$f":"D3*$C$7","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(通路行銷預算!$D7:$O7)","v":{"v":16.950000000000003,"d":"16.95"}}]
[null,"人事總金額 $(000)",null,{"$f":"SUM(D6:D7)","v":25.75},{"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(通路行銷預算!$D8:$O8)","v":{"v":316.95000000000005,"d":"316.95"}}]
[null,"直接行銷 (佔總銷售額的百分比)",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,"電話行銷 (佔直接銷售額的百分比)",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,"人力資源 - 人數",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":{"v":19.5,"d":"19.50"}}]
[null,"基礎結構支援",null,25,10,25,10,25,10,25,10,25,10,25,10,null,{"$f":"SUM(通路行銷預算!$D12:$O12)","v":{"v":210,"d":"210.00"}}]
[null,"佣金",{"v":1E-3,"d":"0.10%"},{"$f":"$C$13*D3*D9*D10","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(通路行銷預算!$D13:$O13)","v":{"v":2.163,"d":"2.16"}}]
[null,"訓練",null,25,10,25,10,25,10,25,10,25,10,25,10,null,{"$f":"SUM(通路行銷預算!$D14:$O14)","v":{"v":210,"d":"210.00"}}]
[null,"電話行銷總金額 $(000)",null,{"$f":"SUM(D11:D14)","v":53.75},{"v":21.6,"d":"21.60"},{"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(通路行銷預算!$D15:$O15)","v":{"v":441.663,"d":"441.66"}}]
[null,"網際網路行銷 (佔直接銷售額的百分比)",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,"人力資源 - 人數",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":{"v":3,"d":"3.00"}}]
[null,"網站開發 (一次性成本)",null,500,{"$nulls":12},{"$f":"SUM(通路行銷預算!$D18:$O18)","v":{"v":500,"d":"500.00"}}]
[null,"主機",null,10,10,10,10,10,10,10,10,10,10,10,10,null,{"$f":"SUM(通路行銷預算!$D19:$O19)","v":{"v":120,"d":"120.00"}}]
[null,"支援與維護",null,25,{"$nulls":9},25,null,null,{"$f":"SUM(通路行銷預算!$D20:$O20)","v":{"v":50,"d":"50.00"}}]
[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":{"v":673,"d":"673.00"}}]
[null,"郵遞廣告 (佔直接銷售額的百分比)"]
[null,"人力資源 - 成本",{"$nulls":14},{"$f":"SUM(通路行銷預算!$D23:$O23)","v":{"v":0,"d":"0.00"}}]
[null,"資料",null,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,1000,null,{"$f":"SUM(通路行銷預算!$D24:$O24)","v":{"v":12000,"d":"12,000.00"}}]
[null,"郵資",null,250,250,250,250,250,250,250,250,250,250,250,250,null,{"$f":"SUM(通路行銷預算!$D25:$O25)","v":{"v":3000,"d":"3,000.00"}}]
[null,"郵遞廣告總金額 $(000)",null,{"$f":"SUM(D23:D25)","v":{"v":1250,"d":"1,250.00"}},{"$f":"SUM(E23:E25)","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,{"v":15000,"d":"15,000.00"}]
[null,"直接行銷總金額 $(000)",null,{"$f":"SUM(D15,D21,D26)","v":{"v":1839,"d":"1,839.00"}},{"v":1281.85,"d":"1,281.85"},{"v":1311.9375,"d":"1,311.94"},{"v":1282.05,"d":"1,282.05"},{"v":1311.948,"d":"1,311.95"},{"v":1281.9375,"d":"1,281.94"},{"v":1311.9,"d":"1,311.90"},{"v":1281.84,"d":"1,281.84"},{"v":1311.8,"d":"1,311.80"},{"v":1281.8,"d":"1,281.80"},{"v":1336.8,"d":"1,336.80"},{"v":1281.8,"d":"1,281.80"},null,{"$f":"SUM(Q15,Q21,Q26)","v":{"v":16114.663,"d":"16,114.66"}}]
[null,"經紀人/代理人 (佔總銷售額的百分比)",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,"通訊",null,50,50,50,50,50,50,50,50,50,50,50,50,null,{"$f":"SUM(通路行銷預算!$D29:$O29)","v":{"v":600,"d":"600.00"}}]
[null,"訓練",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(通路行銷預算!$D30:$O30)","v":{"v":3000,"d":"3,000.00"}}]
[null,"促銷",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(通路行銷預算!$D31:$O31)","v":{"v":7200,"d":"7,200.00"}}]
[null,"折扣",{"v":0.1,"d":"10.00%"},{"$f":"D3*D28*$C$32","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(通路行銷預算!$D32:$O32)","v":{"v":169.5,"d":"169.50"}}]
[null,"佣金 (佔經紀人銷售額的百分比)",{"v":0.1,"d":"10.00%"},{"$f":"D3*D28*$C$33","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(通路行銷預算!$D33:$O33)","v":{"v":169.5,"d":"169.50"}}]
[null,"經紀人/代理人總金額 $(000)",null,{"$f":"SUM(D29:D33)","v":{"v":915,"d":"915.00"}},{"$f":"SUM(E29:E33)","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,{"v":11139,"d":"11,139.00"}]
[null,"經銷商 (佔總銷售額的百分比)",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,"通訊",null,50,50,50,50,50,50,50,50,50,50,50,50,null,{"$f":"SUM(通路行銷預算!$D36:$O36)","v":{"v":600,"d":"600.00"}}]
[null,"訓練",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(通路行銷預算!$D37:$O37)","v":{"v":3000,"d":"3,000.00"}}]
[null,"促銷",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(通路行銷預算!$D38:$O38)","v":{"v":7200,"d":"7,200.00"}}]
[null,"佣金/折扣 (佔經銷商銷售額的百分比)",{"v":0.15,"d":"15.00%"},{"$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":{"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"},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,{"v":11466.75,"d":"11,466.75"}]
[null,"零售商 (佔總銷售額的百分比)",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,"通訊",null,50,50,50,50,50,50,50,50,50,50,50,50,null,{"$f":"SUM(通路行銷預算!$D42:$O42)","v":{"v":600,"d":"600.00"}}]
[null,"訓練",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(通路行銷預算!$D43:$O43)","v":{"v":3000,"d":"3,000.00"}}]
[null,"促銷",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(通路行銷預算!$D44:$O44)","v":{"v":7200,"d":"7,200.00"}}]
[null,"佣金/折扣 (佔零售商銷售額的百分比)",{"v":0.1,"d":"10.00%"},{"$f":"D3*D41*$C$45","v":0},0,12.5,90,80.4,90,90,90,60,60,60,60,null,{"$f":"SUM(通路行銷預算!$D45:$O45)","v":{"v":692.9,"d":"692.90"}}]
[null,"零售商總金額 $(000)",null,{"$f":"SUM(D42:D45)","v":{"v":900,"d":"900.00"}},{"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,{"v":11492.9,"d":"11,492.90"}]
[null,"客戶贏取與留存 (CAR)"]
[null,"人力資源",null,50,50,50,50,50,50,50,50,50,50,50,50,null,{"$f":"SUM(通路行銷預算!$D48:$O48)","v":{"v":600,"d":"600.00"}}]
[null,"通訊",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(通路行銷預算!$D49:$O49)","v":{"v":3000,"d":"3,000.00"}}]
[null,"促銷/折價券",null,600,600,600,600,600,600,600,600,600,600,600,600,null,{"$f":"SUM(通路行銷預算!$D50:$O50)","v":{"v":7200,"d":"7,200.00"}}]
[null,"CAR 總金額 $(000)",null,{"$f":"SUM(D48:D50)","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"},{"v":900,"d":"900.00"},null,{"v":10800,"d":"10,800.00"}]
[null,"其他費用"]
[null,"差旅費",null,50,50,50,50,50,50,50,50,50,50,50,50,null,{"$f":"SUM(通路行銷預算!$D53:$O53)","v":{"v":600,"d":"600.00"}}]
[null,"基礎結構 (電腦、電話等)",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(通路行銷預算!$D54:$O54)","v":{"v":3000,"d":"3,000.00"}}]
[null,"通路支援",null,600,600,600,600,600,600,600,600,600,600,600,600,null,{"$f":"SUM(通路行銷預算!$D55:$O55)","v":{"v":7200,"d":"7,200.00"}}]
[null,"其他費用總金額 $(000)",null,{"$f":"SUM(D53:D55)","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"},{"v":900,"d":"900.00"},null,{"v":10800,"d":"10,800.00"}]
[]
[null,"行銷總預算：",null,{"$f":"SUM(D8,D27,D34,D40,D46,D51,D56)","v":{"v":6379.75,"d":"6,379.75"}},{"v":5811.05,"d":"5,811.05"},{"v":5859.9375,"d":"5,859.94"},{"v":5928.55,"d":"5,928.55"},{"v":5942.548,"d":"5,942.55"},{"v":5962.1875,"d":"5,962.19"},{"v":6003.4,"d":"6,003.40"},{"v":6042.639999999999,"d":"6,042.64"},{"v":6058.8,"d":"6,058.80"},{"v":6028.8,"d":"6,028.80"},{"v":6083.8,"d":"6,083.80"},{"v":6028.8,"d":"6,028.80"},null,{"$f":"SUM(Q8,Q27,Q34,Q40,Q46,Q51,Q56)","v":{"v":72130.263,"d":"72,130.26"}}]