{"text_format":"1","workbook":"xls","n_sheets":2,"sheets":["Marketing Budget Plan","Budget Plan Chart"],"not_rendered":{"charts":1,"images":0,"macros":0,"external_links":1,"defined_names":4,"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","formulas":"cached_only"}

{"sheet":"Marketing Budget Plan","index":0,"n_rows":97,"n_cols":5,"rows_kept":97,"cut":false,"hidden":false,"merged":[[96,0,96,1]],"flags":["formulas_cached_only"]}
["Marketing Budget Plan"]
["Category","Estimated\nQuantity","Estimated\nCost per Unit","Estimated\nSubtotal","Notes"]
[]
["Research",null,null,null,"fsdds"]
["Research firm fees",2,2300,4600]
["Web research",1,1100,1100]
["Independent research",3,300,900]
["Other research",2,250,500]
[]
["Research Costs Total",null,null,7100]
[]
["Communications"]
["Promotional brochures",5000,0.15,750]
["Television",5,4000,20000]
["Radio",13,350,4550]
["Web",1,350,350]
[null,null,null,null," "]
["Communications Costs Total",null,null,25650]
[]
["Networking"]
["Memberships",3,50,150]
["Affiliations",2,20,40]
["Subscriptions",2,32,64]
[]
["Networking Costs Total",null,null,254]
[]
["Event"]
["Number of attendees",50]
["Meal (breakfast, lunch, or dinner)"]
["Food",null,23,1150]
["Tax (10%)",null,2.3000000000000003,115.00000000000001]
["Food and beverage gratuity (20%)",null,5.0600000000000005,253.00000000000003]
["Meal Costs Subtotal",null,null,1518]
[]
["List Services"]
["Valet services",1,300,300]
["Entertainment #1",1,800,800]
["Entertainment #2",1,1200,1200]
["Other services",1,200,200]
["List Service Costs Subtotal",null,null,2500]
[]
["Audio/Visual Services"]
["Basic PA system and podium",1,0,0,"Provided by venue (usually)"]
["Screen",1,0,0,"Provided by venue (usually)"]
["XGA data/video projector rental",1,45,45]
["Wireless mouse",1,12,12]
["Power strips",1,0,0,"Provided by venue (usually)"]
["Extension cords",1,0,0,"Provided by venue (usually)"]
["Lavalier microphone",1,0,0,"Provided by venue (usually)"]
["Labor and AV technicians",1,300,300]
["Tax (8.8%)",null,31.415999999999997,31.415999999999997]
["Audio/Visual Services Subtotal",null,null,388.416]
[]
["Additional Costs"]
["Invitation \n(printing and postage costs)",null,834,834]
["Time & Expense (T&E)",null,600,600]
["Company staff T&E"," ",200,200,"<Number of persons onsite>"]
["Customer testimonial T&E",null,100,100]
["Additional Costs Subtotal",null,null,1734]
[]
["Giveaways",0]
["Giveaway #1",25,10,250,"<Giveaway item description>"]
["Giveaway #2",25,5,125,"<Giveaway item description>"]
["Giveaway Subtotal",null,null,375]
[]
["Event Costs Total",null,null,6515.416]
[]
["Event Price per Person",130.30832]
[]
["Promotions"]
["Product giveaways",50,8,400]
["Product discounts",300,3,900]
["Special offers",200,2.5,500]
[]
["Promotions Costs Total",null,null,1800]
[]
["Advertising"]
["Brochures (development and production)",5000,0.15,750]
["Mailings",15000,0.04,600]
["Postcards",15000,0.03,450]
["Television",2,600,1200]
["Radio",4,300,1200]
["Newspapers",6,220,1320]
["Billboards",2,556,1112]
["Bus sides",3,125,375]
[]
["Advertising Costs Total",null,null,7007]
[]
["Public Relations"]
["Charity events",3,200,600]
["Advertising",4,200,800]
["Employee promotions",6,200,1200]
["Sponsorships",3,200,600]
[]
["Public Relations Costs Total",null,null,3200]
[]
["ESTIMATED MARKETING GRAND TOTAL",null,null,51526.416]

{"sheet":"Budget Plan Chart","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[],"flags":["formulas_cached_only"]}