Create a Payment Template Excel for Public Relations Effortlessly

Payment template excel for Public Relations

hello everyone this is Rick Grantham of small business Champion bundle this week we're going to talk about a marketing budget a marketing budget template for the small business owner and why you should look at marketing for your small business as food and not medicine that's coming up next hello everyone and welcome back again this week we're going to talk about marketing budget and why that's so important for the small business owner now the first thing to consider as a small business owner is is to realize what your fortune 500 competitors are doing you know they do not look at a marketing budget and a marketing plan as being something that is medicine something that they do because their business is ill rather they see that as food and as part of an ongoing maintenance program for their business a great blog post on this at 40.com by James which you'll see in the description below up at that there kind of lays this out very well which I think is is very well put so I invite you to go look at that at that blog post at 40.com but there's talk about this template in particular what this template does to be able to assist you in setting up a small business marketing plan or a marketing budget first off some of the things you need to consider there's really about four or five major buckets of things that you need to consider in a marketing plan first off number one your personnel cost you know all of your all of your salaries all of your bus benefits all of everything that's related to anyone who might be doing marketing in your small business number two marketing research marketing research is is very important particularly if you have any sort of uh search engine research that might be going on if you're marketing on the web or if you're doing any research around Billboards or anything like that you know you need to take that into consideration next up is Communications now in Communications this could very well be your your website cost it could be uh any of your direct marketing plans so if you have if you're putting out brochures or something like that all of those sort of communication things need to be put and need to be cared for within your budget and so that's taken care of as well and additionally additionally Channel cost so anything related to specific Channel costs within your within your industry and it's certainly a place kind of a catchall for for other as well you know all the additional things you need to consider within a budget so this template that we're going to show you here in just a minute walks you through uh uh walks you through 12 months on how to budget all of that out and gives you suggested line items that you might want to consider in your budget as you're putting that together so again the next PR tutorial we're going to actually pull up the template we're going to walk you through it we're going to walk you through how to input your own business information to have a to have a overall budget to have a marketing budget that is not medicine however is food for your business business that's coming up next hello everyone welcome back to the template portion of tutorial when you first pull up the template first thing you'll be met with is this title page now in the title page you're going to see plenty of opportunities here to join the conversation you'll see on the left hand side you can download our free our free book ebook there's a robust question and answers period here a section here plus you know inviting you to join us on LinkedIn and Facebook you also see text over here which is invites you again to join the community uh to visit us on our LinkedIn group small business optimization or to join us on our fanbook Facebook page you know just to be able to join in the conversation now the marketing budget template if you go down here to the bottom here you'll see there's a tab called marketing budget as you select on marketing budget your marketing budget is brought up now first on the right hand side you'll see instructions you'll see opportunities to join the conversation so all of that's here for you um let's go ahead and jump into the actual template now you'll see right now there are plenty of numbers that are in here whenever you receive this this will be all blanked out so you'll be starting with a fresh slate you don't have to worry about going in and cancelling out other you know stuff that was there before uh but for the purposes of the demonstration we're going to show you this with some data already in it uh first off as was mentioned in the previous portion of the tutorial there's sections here you'll see headings let's go ahead and make that a little bit larger uh there's sections here for personnel and all of your personnel areas there's a section here for marketing research and all of your marketing research areas from primary research to library management uh your marketing Communications everything from branding to advertising uh direct marketing uh this direct marketing would be particularly important if you're uh the sort of business that needs to put out brochures and pamphlets and things like that and and that sort of direct marketing there are some other templates that we have that are very specific to direct marketing we'll put a link to that below as well uh collateral public relations Etc marketing Communications and uh different channels and of course other so you see there's there's a lot of places to put in your data here so the first question would be how do you know where you're supposed to put in your information and where are calculations at so that you're not writing over you know any formulas or anything like that uh to that end if you scroll over here to the right hand side you'll see that there's a section here says highlight inputs we're take that highlight inputs and select yes and we do that you'll see the input areas or the areas that you would interact with have now been updated and highlighted blue so not only can you go in here and put in your own information we'll say your budget for February maybe for salary and wages is not under $638 that you know this is just here for example purposes but it's something much more than that that might be 5,3 I don't know 28 just as an example so you have the ability to go in and put in your own numbers and you'll see that the calculations all update your end of year numbers all update so the budget is there for you uh you'll also see on the left hand side that you have the opportunity to go in and change the line items so some of these line items might not make sense for your business in particular under we'll say uh marketing Communications uh you might not be in the direct marketing area but you might have marketing Communications that are much more specific to what it is that you do you know what it is that's that's relevant for your industry so there's no reason you can't go in and type those in as well so this is the main budget area you you in the template we've given you pretty much a starter set of line items that would be typical for most marketing budgets once you're ready to print this and you can fill all this out with your information uh once you get ready to print this if you don't want to print that blue there you can come over here and set your highlights to no and now you can print this as normal so that is your marketing budget uh this is creating a situation to where you're looking at marketing again as food and not as medicine this is all part of the small business bundle small business Champion bundle um feel free to go ahead and follow us and subscribe to us uh you'll see some options down here somewhere so to subscribe to us you'll also see um you'll see plenty of our other videos we put out videos on a regular their basis feel free to go ahead and follow us or go ahead and leave your comments down below so until next time this is Rick ramp