{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Marketing Budget Plan","Budget Plan Chart"],"not_rendered":{"charts":2,"defined_names":2},"unopened":[{"sheet":"Budget Plan Chart","index":1,"reason":"not_a_worksheet"}],"read":"whole","date_system":"1900"}

{"sheet":"Marketing Budget Plan","index":0,"n_rows":96,"n_cols":5,"rows_kept":96,"merged":[[0,0,0,4],[95,0,95,1]]}
["Marketing Budget Plan"]
["Category","Estimated\nQuantity","Estimated\nCost per Unit","Estimated\nSubtotal","Notes"]
[]
["Research",{"$nulls":3},"fsdds"]
["Research firm fees",2,{"v":2300,"d":"$2,300.00"},{"$f":"SUM(B5*C5)","v":{"v":4600,"d":"$4,600.00"}}]
["Web research",1,{"v":1100,"d":"$1,100.00"},{"$f":"SUM(B6*C6)","v":{"v":1100,"d":"$1,100.00"}}]
["Independent research",3,{"v":300,"d":"$300.00"},{"$f":"SUM(B7*C7)","v":{"v":900,"d":"$900.00"}}]
["Other research",2,{"v":250,"d":"$250.00"},{"$f":"SUM(B8*C8)","v":{"v":500,"d":"$500.00"}}]
[]
["Research Costs Total",null,null,{"$f":"SUM(D5:D9)","v":{"v":7100,"d":"$7,100.00"}}]
[]
["Communications"]
["Promotional brochures",{"v":5000,"d":"5,000"},{"v":0.15,"d":"$0.15"},{"$f":"SUM(B13*C13)","v":{"v":750,"d":"$750.00"}}]
["Television",5,{"v":4000,"d":"$4,000.00"},{"$f":"SUM(B14*C14)","v":{"v":20000,"d":"$20,000.00"}}]
["Radio",13,{"v":350,"d":"$350.00"},{"$f":"SUM(B15*C15)","v":{"v":4550,"d":"$4,550.00"}}]
["Web",1,{"v":350,"d":"$350.00"},{"$f":"SUM(B16*C16)","v":{"v":350,"d":"$350.00"}}]
[{"$nulls":4}," "]
["Communications Costs Total",null,null,{"$f":"SUM(D13:D17)","v":{"v":25650,"d":"$25,650.00"}}]
[]
["Networking"]
["Memberships",3,{"v":50,"d":"$50.00"},{"$f":"SUM(B21*C21)","v":{"v":150,"d":"$150.00"}}]
["Affiliations",2,{"v":20,"d":"$20.00"},{"$f":"SUM(B22*C22)","v":{"v":40,"d":"$40.00"}}]
["Subscriptions",2,{"v":32,"d":"$32.00"},{"$f":"SUM(B23*C23)","v":{"v":64,"d":"$64.00"}}]
[]
["Networking Costs Total",null,null,{"$f":"SUM(D21:D24)","v":{"v":254,"d":"$254.00"}}]
[]
["Event"]
["Number of attendees",50]
["Meal (breakfast, lunch, or dinner)"]
["Food",null,{"v":23,"d":"$23.00"},{"$f":"C30*B28","v":{"v":1150,"d":"$1,150.00"}}]
["Tax (10%)",null,{"$f":"SUM(C29:C30)*0.1","v":{"v":2.3000000000000003,"d":"$2.30"}},{"$f":"C31*B28","v":{"v":115.00000000000001,"d":"$115.00"}}]
["Food and beverage gratuity (20%)",null,{"$f":"SUM(C29:C31)*(0.2)","v":{"v":5.0600000000000005,"d":"$5.06"}},{"$f":"C32*B28","v":{"v":253.00000000000003,"d":"$253.00"}}]
["Meal Costs Subtotal",null,null,{"$f":"SUM(D30:D32)","v":{"v":1518,"d":"$1,518.00"}}]
[]
["List Services"]
["Valet services",1,{"v":300,"d":"$300.00"},{"$f":"SUM(B36*C36)","v":{"v":300,"d":"$300.00"}}]
["Entertainment #1",1,{"v":800,"d":"$800.00"},{"$f":"SUM(B37*C37)","v":{"v":800,"d":"$800.00"}}]
["Entertainment #2",1,{"v":1200,"d":"$1,200.00"},{"$f":"SUM(B38*C38)","v":{"v":1200,"d":"$1,200.00"}}]
["Other services",1,{"v":200,"d":"$200.00"},{"$f":"SUM(B39*C39)","v":{"v":200,"d":"$200.00"}}]
["List Service Costs Subtotal",null,null,{"$f":"SUM(D36:D39)","v":{"v":2500,"d":"$2,500.00"}}]
[]
["Audio/Visual Services"]
["Basic PA system and podium",1,{"v":0,"d":"$0.00"},{"$f":"C43*B43","v":{"v":0,"d":"$0.00"}},"Provided by venue (usually)"]
["Screen",1,{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},"Provided by venue (usually)"]
["XGA data/video projector rental",1,{"v":45,"d":"$45.00"},{"v":45,"d":"$45.00"}]
["Wireless mouse",1,{"v":12,"d":"$12.00"},{"v":12,"d":"$12.00"}]
["Power strips",1,{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},"Provided by venue (usually)"]
["Extension cords",1,{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},"Provided by venue (usually)"]
["Lavalier microphone",1,{"v":0,"d":"$0.00"},{"v":0,"d":"$0.00"},"Provided by venue (usually)"]
["Labor and AV technicians",1,{"v":300,"d":"$300.00"},{"v":300,"d":"$300.00"}]
["Tax (8.8%)",null,{"$f":"SUM(C43:C50)*(0.088)","v":{"v":31.415999999999997,"d":"$31.42"}},{"$f":"SUM(D43:D50)*(0.088)","v":{"v":31.415999999999997,"d":"$31.42"}}]
["Audio/Visual Services Subtotal",null,null,{"$f":"SUM(D43:D51)","v":{"v":388.416,"d":"$388.42"}}]
[]
["Additional Costs"]
["Invitation \n(printing and postage costs)",null,{"v":834,"d":"$834.00"},{"$f":"C55","v":{"v":834,"d":"$834.00"}}]
["Time & Expense (T&E)",null,{"v":600,"d":"$600.00"},{"$f":"C56","v":{"v":600,"d":"$600.00"}}]
["Company staff T&E"," ",{"v":200,"d":"$200.00"},{"$f":"C57","v":{"v":200,"d":"$200.00"}},"<Number of persons onsite>"]
["Customer testimonial T&E",null,{"v":100,"d":"$100.00"},{"$f":"C58","v":{"v":100,"d":"$100.00"}}]
["Additional Costs Subtotal",null,null,{"$f":"SUM(D55:D58)","v":{"v":1734,"d":"$1,734.00"}}]
[]
["Giveaways",0]
["Giveaway #1",25,{"v":10,"d":"$10.00"},{"$f":"C62*B62","v":{"v":250,"d":"$250.00"}},"<Giveaway item description>"]
["Giveaway #2",25,{"v":5,"d":"$5.00"},{"$f":"C63*B63","v":{"v":125,"d":"$125.00"}},"<Giveaway item description>"]
["Giveaway Subtotal",null,null,{"$f":"SUM(D62:D63)","v":{"v":375,"d":"$375.00"}}]
[]
["Event Costs Total",null,null,{"$f":"SUM(D33+D40+D52+D59+D64)","v":{"v":6515.416,"d":"$6,515.42"}}]
["Event Price per Person",{"$f":"D66/B28","v":{"v":130.30832,"d":"$130.31"}}]
[]
["Promotions"]
["Product giveaways",50,{"v":8,"d":"$8.00"},{"$f":"SUM(B70*C70)","v":{"v":400,"d":"$400.00"}}]
["Product discounts",300,{"v":3,"d":"$3.00"},{"$f":"SUM(B71*C71)","v":{"v":900,"d":"$900.00"}}]
["Special offers",200,{"v":2.5,"d":"$2.50"},{"$f":"SUM(B72*C72)","v":{"v":500,"d":"$500.00"}}]
[]
["Promotions Costs Total",null,null,{"$f":"SUM(D70:D73)","v":{"v":1800,"d":"$1,800.00"}}]
[]
["Advertising"]
["Brochures (development and production)",{"v":5000,"d":"5,000"},{"v":0.15,"d":"$0.15"},{"$f":"SUM(B77*C77)","v":{"v":750,"d":"$750.00"}}]
["Mailings",{"v":15000,"d":"15,000"},{"v":0.04,"d":"$0.04"},{"$f":"SUM(B78*C78)","v":{"v":600,"d":"$600.00"}}]
["Postcards",{"v":15000,"d":"15,000"},{"v":0.03,"d":"$0.03"},{"v":450,"d":"$450.00"}]
["Television",2,{"v":600,"d":"$600.00"},{"v":1200,"d":"$1,200.00"}]
["Radio",4,{"v":300,"d":"$300.00"},{"v":1200,"d":"$1,200.00"}]
["Newspapers",6,{"v":220,"d":"$220.00"},{"v":1320,"d":"$1,320.00"}]
["Billboards",2,{"v":556,"d":"$556.00"},{"v":1112,"d":"$1,112.00"}]
["Bus sides",3,{"v":125,"d":"$125.00"},{"v":375,"d":"$375.00"}]
[]
["Advertising Costs Total",null,null,{"$f":"SUM(D77:D85)","v":{"v":7007,"d":"$7,007.00"}}]
[]
["Public Relations"]
["Charity events",3,{"v":200,"d":"$200.00"},{"$f":"SUM(B89*C89)","v":{"v":600,"d":"$600.00"}}]
["Advertising",4,{"v":200,"d":"$200.00"},{"$f":"SUM(B90*C90)","v":{"v":800,"d":"$800.00"}}]
["Employee promotions",6,{"v":200,"d":"$200.00"},{"$f":"SUM(B91*C91)","v":{"v":1200,"d":"$1,200.00"}}]
["Sponsorships",3,{"v":200,"d":"$200.00"},{"$f":"SUM(B92*C92)","v":{"v":600,"d":"$600.00"}}]
[]
["Public Relations Costs Total",null,null,{"$f":"SUM(D89:D93)","v":{"v":3200,"d":"$3,200.00"}}]
[]
["ESTIMATED MARKETING GRAND TOTAL",null,null,{"$f":"SUM(D10+D18+D25+D66+D74+D86+D94)","v":{"v":51526.416,"d":"$51,526.42"}}]