{"text_format":"3","workbook":"xls","n_sheets":2,"sheets":["Budget","Formula"],"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Budget","index":0,"n_rows":66,"n_cols":27,"rows_kept":66,"merged":[[1,2,1,3],[1,4,1,5],[1,6,1,7],[1,8,1,9],[1,10,1,11],[1,12,1,13],[1,14,1,15],[1,16,1,17],[1,18,1,19],[1,20,1,21],[1,22,1,23],[1,24,1,25],[2,2,2,3],[2,4,2,5],[2,6,2,7],[2,8,2,9],[2,10,2,11],[2,12,2,13],[2,14,2,15],[2,16,2,17],[2,18,2,19],[2,20,2,21],[2,22,2,23],[2,24,2,25]],"flags":["formulas_cached_only"]}
["Channel Marketing Budget "]
["All amounts are in $(000)",null,"Month 1",null,"Month 2",null,"Month 3",null,"Month 4",null,"Month 5",null,"Month 6",null,"Month 7",null,"Month 8",null,"Month 9",null,"Month 10",null,"Month 11",null,"Month 12",null,"Total"]
["Anticipated Sales Total (000):",null,100,null,200,null,500,null,{"v":1000,"d":"1,000"},null,{"v":1200,"d":"1,200"},null,{"v":1500,"d":"1,500"},null,{"v":1500,"d":"1,500"},null,{"v":1800,"d":"1,800"},null,{"v":2000,"d":"2,000"},null,{"v":2000,"d":"2,000"},null,{"v":2000,"d":"2,000"},null,{"v":2000,"d":"2,000"},null,{"v":15800,"d":"15800.00"}]
[null,"Rate","QTY","Amount","QTY","Amount","QTY","Amount","QTY","Amount","QTY","Amount","QTY","Amount","QTY","Amount","QTY","Amount","QTY","Amount","QTY","Amount","QTY","Amount","QTY","Amount"]
["Personnel (% of Total Sales)",null,{"v":1,"d":"100%"},null,{"v":1,"d":"100%"},null,{"v":1,"d":"100%"},null,{"v":1,"d":"100%"},null,{"v":1,"d":"100%"},null,{"v":1,"d":"100%"},null,{"v":1,"d":"100%"},null,{"v":1,"d":"100%"},null,{"v":1,"d":"100%"},null,{"v":1,"d":"100%"},null,{"v":1,"d":"100%"},null,{"v":1,"d":"100%"}]
["Human Resources",5,5,{"v":25,"d":"25.00"},5,{"v":25,"d":"25.00"},5,{"v":25,"d":"25.00"},5,{"v":25,"d":"25.00"},5,{"v":25,"d":"25.00"},5,{"v":25,"d":"25.00"},5,{"v":25,"d":"25.00"},5,{"v":25,"d":"25.00"},5,{"v":25,"d":"25.00"},5,{"v":25,"d":"25.00"},5,{"v":25,"d":"25.00"},5,{"v":25,"d":"25.00"},{"v":300,"d":"300.00"}]
["Commission",{"v":0.001,"d":"0.10%"},null,{"v":0.1,"d":"0.10"},null,{"v":0.2,"d":"0.20"},null,{"v":0.5,"d":"0.50"},null,{"v":1,"d":"1.00"},null,{"v":1.2,"d":"1.20"},null,{"v":1.5,"d":"1.50"},null,{"v":1.5,"d":"1.50"},null,{"v":1.8,"d":"1.80"},null,{"v":2,"d":"2.00"},null,{"v":2,"d":"2.00"},null,{"v":2,"d":"2.00"},null,{"v":2,"d":"2.00"},{"v":15.8,"d":"15.80"}]
["Personnel Total:",null,null,{"v":25.1,"d":"25.10"},null,{"v":25.2,"d":"25.20"},null,{"v":25.5,"d":"25.50"},null,{"v":26,"d":"26.00"},null,{"v":26.2,"d":"26.20"},null,{"v":26.5,"d":"26.50"},null,{"v":26.5,"d":"26.50"},null,{"v":26.8,"d":"26.80"},null,{"v":27,"d":"27.00"},null,{"v":27,"d":"27.00"},null,{"v":27,"d":"27.00"},null,{"v":27,"d":"27.00"},{"v":315.8,"d":"315.80"}]
[]
["Direct Marketing (% of Total Sales)",null,{"v":1,"d":"100%"},null,{"v":1,"d":"100%"},null,{"v":0.75,"d":"75%"},null,{"v":0.4,"d":"40%"},null,{"v":0.33,"d":"33%"},null,{"v":0.25,"d":"25%"},null,{"v":0.2,"d":"20%"},null,{"v":0.1,"d":"10%"},null,{"v":0.05,"d":"5%"},null,{"v":0.05,"d":"5%"},null,{"v":0.05,"d":"5%"},null,{"v":0.05,"d":"5%"}]
["Telemarketing (% of Direct Sales)",null,{"v":1,"d":"100%"},null,{"v":0.5,"d":"50%"},null,{"v":0.5,"d":"50%"},null,{"v":0.5,"d":"50%"},null,{"v":0.5,"d":"50%"},null,{"v":0.5,"d":"50%"},null,{"v":0.5,"d":"50%"},null,{"v":0.5,"d":"50%"},null,{"v":0.5,"d":"50%"},null,{"v":0.5,"d":"50%"},null,{"v":0.5,"d":"50%"},null,{"v":0.5,"d":"50%"}]
["Human Resources",null,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Infrastructure Support",{"$nulls":25},{"v":0,"d":"0.00"}]
["Commission",{"v":0,"d":"0.00%"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Training",{"$nulls":25},{"v":0,"d":"0.00"}]
["Telemarketing Total:",null,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[]
["Internet Marketing (% of Direct Sales)",{"$nulls":5},{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"}]
["Human Resources",null,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Web Site Development (one-time cost)",{"$nulls":25},{"v":0,"d":"0.00"}]
["Hosting",{"$nulls":25},{"v":0,"d":"0.00"}]
["Support & Maintenance",{"$nulls":25},{"v":0,"d":"0.00"}]
["Internet Total:",null,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[]
["Direct Mail (% of Direct Sales)",{"$nulls":3},{"v":0.5,"d":"50%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"}]
["Human Resources",{"$nulls":25},{"v":0,"d":"0.00"}]
["Material",{"$nulls":25},{"v":0,"d":"0.00"}]
["Postage",{"$nulls":25},{"v":0,"d":"0.00"}]
["Direct Mail Total:",null,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Direct Marketing Total:",null,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[]
["Agent/Broker (% of Total Sales)",null,{"v":0,"d":"0%"},null,{"v":0,"d":"0%"},null,{"v":0,"d":"0%"},null,{"v":0,"d":"0%"},null,{"v":0,"d":"0%"},null,{"v":0,"d":"0%"},null,{"v":0,"d":"0%"},null,{"v":0,"d":"0%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"},null,{"v":0.25,"d":"25%"}]
["Communication",{"$nulls":25},{"v":0,"d":"0.00"}]
["Training",{"$nulls":25},{"v":0,"d":"0.00"}]
["Promotions",{"$nulls":25},{"v":0,"d":"0.00"}]
["Discounts",{"v":0,"d":"0.00%"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Commission (% of Agent's Sales)",{"v":0,"d":"0.00%"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Agent/Broker Total:",null,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[]
["Distributors (% of Total Sales)",null,{"v":0,"d":"0%"},null,{"v":0,"d":"0%"},null,{"v":0,"d":"0%"},null,{"v":0,"d":"0%"},null,{"v":0,"d":"0%"},null,{"v":0.15,"d":"15%"},null,{"v":0.2,"d":"20%"},null,{"v":0.4,"d":"40%"},null,{"v":0.4,"d":"40%"},null,{"v":0.4,"d":"40%"},null,{"v":0.4,"d":"40%"},null,{"v":0.4,"d":"40%"}]
["Communication",{"$nulls":25},{"v":0,"d":"0.00"}]
["Training",{"$nulls":25},{"v":0,"d":"0.00"}]
["Promotions",{"$nulls":25},{"v":0,"d":"0.00"}]
["Commission/Discounts (% of Distributors' Sales)",{"v":0,"d":"0.00%"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Distributor Total:",null,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[]
["Retailer (% of Total Sales)",null,{"v":0,"d":"0%"},null,{"v":0,"d":"0%"},null,{"v":0.25,"d":"25%"},null,{"v":0.6,"d":"60%"},null,{"v":0.67,"d":"67%"},null,{"v":0.6,"d":"60%"},null,{"v":0.6,"d":"60%"},null,{"v":0.5,"d":"50%"},null,{"v":0.3,"d":"30%"},null,{"v":0.3,"d":"30%"},null,{"v":0.3,"d":"30%"},null,{"v":0.3,"d":"30%"}]
["Communication",{"$nulls":25},{"v":0,"d":"0.00"}]
["Training",{"$nulls":25},{"v":0,"d":"0.00"}]
["Promotions",{"$nulls":25},{"v":0,"d":"0.00"}]
["Commission/Discounts (% of Retail Sales)",{"v":0,"d":"0.00%"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Retailer Total:",null,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[]
["Customer Acquisition & Retention (CAR)"]
["Human Resources",{"$nulls":25},{"v":0,"d":"0.00"}]
["Communications",{"$nulls":25},{"v":0,"d":"0.00"}]
["Promotions/Coupons",{"$nulls":25},{"v":0,"d":"0.00"}]
["CAR Total:",null,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[]
["Other Expenses"]
["Travel",{"$nulls":25},{"v":0,"d":"0.00"}]
["Infrastructure (computer, telephone, etc.)",{"$nulls":25},{"v":0,"d":"0.00"}]
["Channel Support",{"$nulls":25},{"v":0,"d":"0.00"}]
["Other Expenses Total:",null,null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},null,{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[]
["Total Marketing Budget:",null,null,{"v":25.1,"d":"25.10"},null,{"v":25.2,"d":"25.20"},null,{"v":25.5,"d":"25.50"},null,{"v":26,"d":"26.00"},null,{"v":26.2,"d":"26.20"},null,{"v":26.5,"d":"26.50"},null,{"v":26.5,"d":"26.50"},null,{"v":26.8,"d":"26.80"},null,{"v":27,"d":"27.00"},null,{"v":27,"d":"27.00"},null,{"v":27,"d":"27.00"},null,{"v":27,"d":"27.00"},{"v":315.8,"d":"315.80"}]

{"sheet":"Formula","index":1,"n_rows":3,"n_cols":3,"rows_kept":3,"flags":["formulas_cached_only"]}
[]
["Human Resources",null,"Monthly (Rate) * number of resources (QTY) of given month"]
["Commission",null,"Total Sales * % of Total Sales * Rate"]