{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["MARKETING BUDGET PLAN","CATEGORY CHART"],"not_rendered":{"charts":1,"defined_names":4,"pivot_tables":1},"read":"whole","date_system":"1900"}

{"sheet":"MARKETING BUDGET PLAN","index":0,"n_rows":61,"n_cols":7,"rows_kept":61,"merged":[[3,1,3,2],[4,1,4,2],[5,1,5,2],[6,1,6,2]]}
[]
[null,"MARKETING BUDGET PLAN"]
[]
[null,"NUMBER OF ATTENDEES",null,50]
[null,"EVENT COSTS",null,{"$f":"SUMIF(tblData[Primary Category],\"Event\",tblData[Estimated\nSubtotal])","v":{"v":2500,"d":"$2,500.00"}}]
[null,"EVENT PRICE per PERSON",null,{"$f":"EventCosts/NumberOfAttendees","v":{"v":50,"d":"$50.00"}}]
[null,"ESTIMATED MARKETING GRAND TOTAL",null,{"$f":"SUMIF(tblData[Primary Category],\"<>Event\",tblData[Estimated\nSubtotal])","v":{"v":45743,"d":"$45,743.00"}}]
[null,"SUBTOTAL",null,{"$f":"SUBTOTAL(109,tblData[Estimated\nSubtotal])","v":{"v":48243,"d":"$48,243.00"}}]
[]
[null,"Primary Category","Secondary Category","Estimated\nQuantity","Estimated\nCost per Unit","Estimated\nSubtotal","Notes"]
[null,"Research","Research firm fees",2,{"v":2300,"d":"$2,300.00"},{"$f":"tblData[[#This Row],[Estimated\nQuantity]]*tblData[[#This Row],[Estimated\nCost per Unit]]","v":{"v":4600,"d":"$4,600.00"}}]
[null,"Research","Web research",1,{"v":1100,"d":"$1,100.00"},{"$f":"tblData[[#This Row],[Estimated\nQuantity]]*tblData[[#This Row],[Estimated\nCost per Unit]]","v":{"v":1100,"d":"$1,100.00"}}]
[null,"Research","Independent research",3,{"v":300,"d":"$300.00"},{"$f":"tblData[[#This Row],[Estimated\nQuantity]]*tblData[[#This Row],[Estimated\nCost per Unit]]","v":{"v":900,"d":"$900.00"}}]
[null,"Research","Other research",2,{"v":250,"d":"$250.00"},{"$f":"tblData[[#This Row],[Estimated\nQuantity]]*tblData[[#This Row],[Estimated\nCost per Unit]]","v":{"v":500,"d":"$500.00"}}]
[null,"Communications","Promotional brochures",{"v":5000,"d":"5,000"},{"v":0.15,"d":"$0.15"},{"$f":"tblData[[#This Row],[Estimated\nQuantity]]*tblData[[#This Row],[Estimated\nCost per Unit]]","v":{"v":750,"d":"$750.00"}}]
[null,"Communications","Television",5,{"v":4000,"d":"$4,000.00"},{"$f":"tblData[[#This Row],[Estimated\nQuantity]]*tblData[[#This Row],[Estimated\nCost per Unit]]","v":{"v":20000,"d":"$20,000.00"}}]
[null,"Communications","Radio",13,{"v":350,"d":"$350.00"},{"$f":"tblData[[#This Row],[Estimated\nQuantity]]*tblData[[#This Row],[Estimated\nCost per Unit]]","v":{"v":4550,"d":"$4,550.00"}}]
[null,"Communications","Web",1,{"v":350,"d":"$350.00"},{"$f":"tblData[[#This Row],[Estimated\nQuantity]]*tblData[[#This Row],[Estimated\nCost per Unit]]","v":{"v":350,"d":"$350.00"}}]
[null,"Networking","Networking",null,null,{"$f":"tblData[[#This Row],[Estimated\nQuantity]]*tblData[[#This Row],[Estimated\nCost per Unit]]","v":{"v":0,"d":"$0.00"}}]
[null,"Networking","Memberships",3,{"v":50,"d":"$50.00"},{"$f":"tblData[[#This Row],[Estimated\nQuantity]]*tblData[[#This Row],[Estimated\nCost per Unit]]","v":{"v":150,"d":"$150.00"}}]
[null,"Networking","Affiliations",2,{"v":20,"d":"$20.00"},{"$f":"tblData[[#This Row],[Estimated\nQuantity]]*tblData[[#This Row],[Estimated\nCost per Unit]]","v":{"v":40,"d":"$40.00"}}]
[null,"Networking","Subscriptions",2,{"v":32,"d":"$32.00"},{"$f":"tblData[[#This Row],[Estimated\nQuantity]]*tblData[[#This Row],[Estimated\nCost per Unit]]","v":{"v":64,"d":"$64.00"}}]
[null,"Event","Number of attendees",50,null,{"$f":"tblData[[#This Row],[Estimated\nQuantity]]*tblData[[#This Row],[Estimated\nCost per Unit]]","v":{"v":0,"d":"$0.00"}}]
[null,"Event","Meal (breakfast, lunch, or dinner)",null,null,{"$f":"tblData[[#This Row],[Estimated\nQuantity]]*tblData[[#This Row],[Estimated\nCost per Unit]]","v":{"v":0,"d":"$0.00"}}]
[null,"Event","Food",null,{"v":23,"d":"$23.00"},{"$f":"tblData[[#This Row],[Estimated\nQuantity]]*tblData[[#This Row],[Estimated\nCost per Unit]]","v":{"v":0,"d":"$0.00"}}]
[null,"Event","Tax (10%)",null,{"v":2.3000000000000003,"d":"$2.30"},{"$f":"tblData[[#This Row],[Estimated\nQuantity]]*tblData[[#This Row],[Estimated\nCost per Unit]]","v":{"v":0,"d":"$0.00"}}]
[null,"Event","Food and beverage gratuity (20%)",null,{"v":5.0600000000000005,"d":"$5.06"},{"$f":"tblData[[#This Row],[Estimated\nQuantity]]*tblData[[#This Row],[Estimated\nCost per Unit]]","v":{"v":0,"d":"$0.00"}}]
[null,"Event","Valet services",1,{"v":300,"d":"$300.00"},{"$f":"tblData[[#This Row],[Estimated\nQuantity]]*tblData[[#This Row],[Estimated\nCost per Unit]]","v":{"v":300,"d":"$300.00"}}]
[null,"Event","Entertainment #1",1,{"v":800,"d":"$800.00"},{"$f":"tblData[[#This Row],[Estimated\nQuantity]]*tblData[[#This Row],[Estimated\nCost per Unit]]","v":{"v":800,"d":"$800.00"}}]
[null,"Event","Entertainment #2",1,{"v":1200,"d":"$1,200.00"},{"$f":"tblData[[#This Row],[Estimated\nQuantity]]*tblData[[#This Row],[Estimated\nCost per Unit]]","v":{"v":1200,"d":"$1,200.00"}}]
[null,"Event","Other services",1,{"v":200,"d":"$200.00"},{"$f":"tblData[[#This Row],[Estimated\nQuantity]]*tblData[[#This Row],[Estimated\nCost per Unit]]","v":{"v":200,"d":"$200.00"}}]
[null,"Audio/Visual Services","Basic PA system and podium",1,{"v":0,"d":"$0.00"},{"$f":"tblData[[#This Row],[Estimated\nQuantity]]*tblData[[#This Row],[Estimated\nCost per Unit]]","v":{"v":0,"d":"$0.00"}},"Provided by venue (usually)"]
[null,"Audio/Visual Services","Screen",1,{"v":0,"d":"$0.00"},{"$f":"tblData[[#This Row],[Estimated\nQuantity]]*tblData[[#This Row],[Estimated\nCost per Unit]]","v":{"v":0,"d":"$0.00"}},"Provided by venue (usually)"]
[null,"Audio/Visual Services","XGA data/video projector rental",1,{"v":45,"d":"$45.00"},{"$f":"tblData[[#This Row],[Estimated\nQuantity]]*tblData[[#This Row],[Estimated\nCost per Unit]]","v":{"v":45,"d":"$45.00"}}]
[null,"Audio/Visual Services","Wireless mouse",1,{"v":12,"d":"$12.00"},{"$f":"tblData[[#This Row],[Estimated\nQuantity]]*tblData[[#This Row],[Estimated\nCost per Unit]]","v":{"v":12,"d":"$12.00"}}]
[null,"Audio/Visual Services","Power strips",1,{"v":0,"d":"$0.00"},{"$f":"tblData[[#This Row],[Estimated\nQuantity]]*tblData[[#This Row],[Estimated\nCost per Unit]]","v":{"v":0,"d":"$0.00"}},"Provided by venue (usually)"]
[null,"Audio/Visual Services","Extension cords",1,{"v":0,"d":"$0.00"},{"$f":"tblData[[#This Row],[Estimated\nQuantity]]*tblData[[#This Row],[Estimated\nCost per Unit]]","v":{"v":0,"d":"$0.00"}},"Provided by venue (usually)"]
[null,"Audio/Visual Services","Lavalier microphone",1,{"v":0,"d":"$0.00"},{"$f":"tblData[[#This Row],[Estimated\nQuantity]]*tblData[[#This Row],[Estimated\nCost per Unit]]","v":{"v":0,"d":"$0.00"}},"Provided by venue (usually)"]
[null,"Audio/Visual Services","Labor and AV technicians",1,{"v":300,"d":"$300.00"},{"$f":"tblData[[#This Row],[Estimated\nQuantity]]*tblData[[#This Row],[Estimated\nCost per Unit]]","v":{"v":300,"d":"$300.00"}}]
[null,"Audio/Visual Services","Tax (8.8%)",null,{"v":31.415999999999997,"d":"$31.42"},{"$f":"tblData[[#This Row],[Estimated\nQuantity]]*tblData[[#This Row],[Estimated\nCost per Unit]]","v":{"v":0,"d":"$0.00"}}]
[null,"Additional Costs","Invitation \n(printing and postage costs)",null,{"v":834,"d":"$834.00"},{"$f":"tblData[[#This Row],[Estimated\nQuantity]]*tblData[[#This Row],[Estimated\nCost per Unit]]","v":{"v":0,"d":"$0.00"}}]
[null,"Additional Costs","Time & Expense (T&E)",null,{"v":600,"d":"$600.00"},{"$f":"tblData[[#This Row],[Estimated\nQuantity]]*tblData[[#This Row],[Estimated\nCost per Unit]]","v":{"v":0,"d":"$0.00"}}]
[null,"Additional Costs","Company staff T&E",null,{"v":200,"d":"$200.00"},{"$f":"tblData[[#This Row],[Estimated\nQuantity]]*tblData[[#This Row],[Estimated\nCost per Unit]]","v":{"v":0,"d":"$0.00"}},"<Number of persons onsite>"]
[null,"Additional Costs","Customer testimonial T&E",null,{"v":100,"d":"$100.00"},{"$f":"tblData[[#This Row],[Estimated\nQuantity]]*tblData[[#This Row],[Estimated\nCost per Unit]]","v":{"v":0,"d":"$0.00"}}]
[null,"Giveaways","Giveaway #1",25,{"v":10,"d":"$10.00"},{"$f":"tblData[[#This Row],[Estimated\nQuantity]]*tblData[[#This Row],[Estimated\nCost per Unit]]","v":{"v":250,"d":"$250.00"}},"<Giveaway item description>"]
[null,"Giveaways","Giveaway #2",25,{"v":5,"d":"$5.00"},{"$f":"tblData[[#This Row],[Estimated\nQuantity]]*tblData[[#This Row],[Estimated\nCost per Unit]]","v":{"v":125,"d":"$125.00"}},"<Giveaway item description>"]
[null,"Promotions","Product giveaways",50,{"v":8,"d":"$8.00"},{"$f":"tblData[[#This Row],[Estimated\nQuantity]]*tblData[[#This Row],[Estimated\nCost per Unit]]","v":{"v":400,"d":"$400.00"}}]
[null,"Promotions","Product discounts",300,{"v":3,"d":"$3.00"},{"$f":"tblData[[#This Row],[Estimated\nQuantity]]*tblData[[#This Row],[Estimated\nCost per Unit]]","v":{"v":900,"d":"$900.00"}}]
[null,"Promotions","Special offers",200,{"v":2.5,"d":"$2.50"},{"$f":"tblData[[#This Row],[Estimated\nQuantity]]*tblData[[#This Row],[Estimated\nCost per Unit]]","v":{"v":500,"d":"$500.00"}}]
[null,"Advertising","Brochures (development and production)",{"v":5000,"d":"5,000"},{"v":0.15,"d":"$0.15"},{"$f":"tblData[[#This Row],[Estimated\nQuantity]]*tblData[[#This Row],[Estimated\nCost per Unit]]","v":{"v":750,"d":"$750.00"}}]
[null,"Advertising","Mailings",{"v":15000,"d":"15,000"},{"v":0.04,"d":"$0.04"},{"$f":"tblData[[#This Row],[Estimated\nQuantity]]*tblData[[#This Row],[Estimated\nCost per Unit]]","v":{"v":600,"d":"$600.00"}}]
[null,"Advertising","Postcards",{"v":15000,"d":"15,000"},{"v":0.03,"d":"$0.03"},{"$f":"tblData[[#This Row],[Estimated\nQuantity]]*tblData[[#This Row],[Estimated\nCost per Unit]]","v":{"v":450,"d":"$450.00"}}]
[null,"Advertising","Television",2,{"v":600,"d":"$600.00"},{"$f":"tblData[[#This Row],[Estimated\nQuantity]]*tblData[[#This Row],[Estimated\nCost per Unit]]","v":{"v":1200,"d":"$1,200.00"}}]
[null,"Advertising","Radio",4,{"v":300,"d":"$300.00"},{"$f":"tblData[[#This Row],[Estimated\nQuantity]]*tblData[[#This Row],[Estimated\nCost per Unit]]","v":{"v":1200,"d":"$1,200.00"}}]
[null,"Advertising","Newspapers",6,{"v":220,"d":"$220.00"},{"$f":"tblData[[#This Row],[Estimated\nQuantity]]*tblData[[#This Row],[Estimated\nCost per Unit]]","v":{"v":1320,"d":"$1,320.00"}}]
[null,"Advertising","Billboards",2,{"v":556,"d":"$556.00"},{"$f":"tblData[[#This Row],[Estimated\nQuantity]]*tblData[[#This Row],[Estimated\nCost per Unit]]","v":{"v":1112,"d":"$1,112.00"}}]
[null,"Advertising","Bus sides",3,{"v":125,"d":"$125.00"},{"$f":"tblData[[#This Row],[Estimated\nQuantity]]*tblData[[#This Row],[Estimated\nCost per Unit]]","v":{"v":375,"d":"$375.00"}}]
[null,"Public Relations","Charity events",3,{"v":200,"d":"$200.00"},{"$f":"tblData[[#This Row],[Estimated\nQuantity]]*tblData[[#This Row],[Estimated\nCost per Unit]]","v":{"v":600,"d":"$600.00"}}]
[null,"Public Relations","Advertising",4,{"v":200,"d":"$200.00"},{"$f":"tblData[[#This Row],[Estimated\nQuantity]]*tblData[[#This Row],[Estimated\nCost per Unit]]","v":{"v":800,"d":"$800.00"}}]
[null,"Public Relations","Employee promotions",6,{"v":200,"d":"$200.00"},{"$f":"tblData[[#This Row],[Estimated\nQuantity]]*tblData[[#This Row],[Estimated\nCost per Unit]]","v":{"v":1200,"d":"$1,200.00"}}]
[null,"Public Relations","Sponsorships",3,{"v":200,"d":"$200.00"},{"$f":"tblData[[#This Row],[Estimated\nQuantity]]*tblData[[#This Row],[Estimated\nCost per Unit]]","v":{"v":600,"d":"$600.00"}}]

{"sheet":"CATEGORY CHART","index":1,"n_rows":6,"n_cols":13,"rows_kept":6}
[]
[null,"MARKETING CATEGORY CHART"]
[]
[null,null,"Primary Category"]
[null,null,"Additional Costs","Advertising","Audio/Visual Services","Communications","Event","Giveaways","Networking","Promotions","Public Relations","Research","Grand Total"]
[null,"Estimated Subtotal",{"v":0,"d":"$0.00"},{"v":7007,"d":"$7,007.00"},{"v":357,"d":"$357.00"},{"v":25650,"d":"$25,650.00"},{"v":2500,"d":"$2,500.00"},{"v":375,"d":"$375.00"},{"v":254,"d":"$254.00"},{"v":1800,"d":"$1,800.00"},{"v":3200,"d":"$3,200.00"},{"v":7100,"d":"$7,100.00"},{"v":48243,"d":"$48,243.00"}]