{"id":1179,"date":"2018-07-03T01:50:15","date_gmt":"2018-07-03T01:50:15","guid":{"rendered":"https:\/\/craftbreweryfinance.com\/oldversion\/?p=1179"},"modified":"2022-09-15T14:24:37","modified_gmt":"2022-09-15T18:24:37","slug":"how-to-create-a-painless-operating-budget","status":"publish","type":"post","link":"https:\/\/craftbreweryfinance.com\/oldversion\/how-to-create-a-painless-operating-budget\/","title":{"rendered":"How to Create a Painless Operating Budget"},"content":{"rendered":"<p><em data-redactor-tag=\"em\"><span data-verified=\"redactor\" data-redactor-tag=\"span\" data-redactor-style=\"font-size: 16px;\"><img decoding=\"async\" class=\"wp-image-1180 size-thumbnail alignleft\" src=\"https:\/\/craftbreweryfinance.com\/oldversion\/wp-content\/uploads\/2018\/07\/CBF-purse-522622_1280-150x150.jpg\" alt=\"\" width=\"150\" height=\"150\" srcset=\"https:\/\/craftbreweryfinance.com\/oldversion\/wp-content\/uploads\/2018\/07\/CBF-purse-522622_1280-150x150.jpg 150w, https:\/\/craftbreweryfinance.com\/oldversion\/wp-content\/uploads\/2018\/07\/CBF-purse-522622_1280-75x75.jpg 75w\" sizes=\"(max-width: 150px) 100vw, 150px\" \/>\u201cA budget tells us what we cannot afford, but it doesn&#8217;t keep us from buying it.\u201d William Feather<br \/>\n<\/span><\/em><\/p>\n<p><span data-verified=\"redactor\" data-redactor-tag=\"span\" data-redactor-style=\"font-size: 16px;\">Do you need to create an operating budget for your brewery? Of course you do. Let&#8217;s start with a budget pep talk.<\/span><\/p>\n<p><span data-verified=\"redactor\" data-redactor-tag=\"span\" data-redactor-style=\"font-size: 16px;\">I have created hundreds of budgets over my career and\u00a0<strong data-redactor-tag=\"strong\">I still get anxious when starting a new plan<\/strong>. It\u2019s a big job, and there is a lot of work involved. Further, there is a lot of pressure to get the budget right. People are counting on the numbers to be accurate in order to make good business decisions that impact the brewery.<br \/>\n<\/span><\/p>\n<p><span data-verified=\"redactor\" data-redactor-tag=\"span\" data-redactor-style=\"font-size: 16px;\"><strong data-redactor-tag=\"strong\">There\u2019s a lot at stake when building a budget.<\/strong><\/span><\/p>\n<p><span data-verified=\"redactor\" data-redactor-tag=\"span\" data-redactor-style=\"font-size: 16px;\">A budget can feel like an overwhelming task. So many numbers. So many unknowns. So many changes that come up unexpectedly and turn the whole business upside down.\u00a0<strong data-redactor-tag=\"strong\">How can you be expected to predict everything that will happen<\/strong>\u00a0accurately and get it all down on paper?<\/span><\/p>\n<p><span data-verified=\"redactor\" data-redactor-tag=\"span\" data-redactor-style=\"font-size: 16px;\">Short answer: You can\u2019t.<\/span><\/p>\n<p><span data-verified=\"redactor\" data-redactor-tag=\"span\" data-redactor-style=\"font-size: 16px;\">A famous guy once said that plans were useless but planning was indispensable. This holds true for operating budgets. Although I believe a good plan is achievable, too.<\/span><\/p>\n<p><span data-verified=\"redactor\" data-redactor-tag=\"span\" data-redactor-style=\"font-size: 16px;\">The process of planning &#8211; talking with your team and dreaming about the future of your brewery &#8211; are the fun parts of budgeting. That\u2019s why I recommend writing out the plan in words first. Don\u2019t worry about the numbers in the beginning. Just write down your goals, objectives and strategy in words. The numbers will come easy after that.<\/span><\/p>\n<p><span data-verified=\"redactor\" data-redactor-tag=\"span\" data-redactor-style=\"font-size: 16px;\">Take a deep breath and read on. I believe in you and I believe you can do this. A beautiful operating budget for your brewery is within reach.<\/span><\/p>\n<p><strong data-redactor-tag=\"strong\"><span data-verified=\"redactor\" data-redactor-tag=\"span\" data-redactor-style=\"font-size: 16px;\">Painless Budget Basics<\/span><\/strong><\/p>\n<p><span data-verified=\"redactor\" data-redactor-tag=\"span\" data-redactor-style=\"font-size: 16px;\">The good news is that once you create budget, you\u2019ll have a template to use the next time around. This saves time and aggravation.\u00a0<\/span><\/p>\n<p><span data-verified=\"redactor\" data-redactor-tag=\"span\" data-redactor-style=\"font-size: 16px;\">The operating budget involves five major pieces: the sales forecast, gross profit plan, operating expense plan, capital budget and debt schedule.<br \/>\n<\/span><\/p>\n<p><span data-verified=\"redactor\" data-redactor-tag=\"span\" data-redactor-style=\"font-size: 16px;\">You can have more pieces if you like, but these are the major building blocks. These pieces can be as simple or as complicated as you like. In most cases, I vote for simple.<\/span><\/p>\n<p><span data-verified=\"redactor\" data-redactor-tag=\"span\" data-redactor-style=\"font-size: 16px;\">Below, we\u2019ll dig into each of the budget building blocks and give you some tips to get started. Use these ideas in connection with the budget templates and you\u2019ll be well on your way to creating a (painless) operating budget for your brewery.<\/span><\/p>\n<p><strong data-redactor-tag=\"strong\"><span data-verified=\"redactor\" data-redactor-tag=\"span\" data-redactor-style=\"font-size: 16px;\">Sales Forecast<\/span><\/strong><\/p>\n<p><span data-verified=\"redactor\" data-redactor-tag=\"span\" data-redactor-style=\"font-size: 16px;\">The sales forecast is simply a projection of how much beer you will sell. It should show the sales by customer, by brand and by month.<\/span><\/p>\n<p><span data-verified=\"redactor\" data-redactor-tag=\"span\" data-redactor-style=\"font-size: 16px;\">If you sell through distributors, start by making a schedule of who you currently sell to (and who you plan to sell to). Include the historical sales for the past 12months, and the year over year growth for each distributor.<\/span><\/p>\n<p><span data-verified=\"redactor\" data-redactor-tag=\"span\" data-redactor-style=\"font-size: 16px;\">If you plan to open new markets with new distributors, that should be included in the schedule. If you have self-distribution sales and tap room sales, include the figures for these as well.<\/span><\/p>\n<p><span data-verified=\"redactor\" data-redactor-tag=\"span\" data-redactor-style=\"font-size: 16px;\">The Sales Forecast template provides a starting point for this exercise.<\/span><\/p>\n<p><span data-verified=\"redactor\" data-redactor-tag=\"span\" data-redactor-style=\"font-size: 16px;\">With a sales forecast, the trend is your friend. If growth this year was 20% but you project 100% next year, make sure you know where it will be sold.<\/span><\/p>\n<p><span data-verified=\"redactor\" data-redactor-tag=\"span\" data-redactor-style=\"font-size: 16px;\">Ask questions. Challenge assumptions. Build an achievable plan.<\/span><\/p>\n<p><strong data-redactor-tag=\"strong\"><span data-verified=\"redactor\" data-redactor-tag=\"span\" data-redactor-style=\"font-size: 16px;\">Gross Profit Plan<\/span><\/strong><\/p>\n<p><span data-verified=\"redactor\" data-redactor-tag=\"span\" data-redactor-style=\"font-size: 16px;\">Let\u2019s begin with some simple math:<\/span><\/p>\n<ul>\n<li><span data-verified=\"redactor\" data-redactor-tag=\"span\" data-redactor-style=\"font-size: 16px;\">Sales minus the cost of sales = gross profit<\/span><\/li>\n<li><span data-verified=\"redactor\" data-redactor-tag=\"span\" data-redactor-style=\"font-size: 16px;\">Gross profit divided by sales = gross profit percentage<\/span><\/li>\n<\/ul>\n<p><span data-verified=\"redactor\" data-redactor-tag=\"span\" data-redactor-style=\"font-size: 16px;\">Where possible, use an expected gross profit % to create your GP plan. This will make budgeting a lot easier.<\/span><\/p>\n<p><span data-verified=\"redactor\" data-redactor-tag=\"span\" data-redactor-style=\"font-size: 16px;\">For example, if the historical trend for gross profit in your brewery is 45%, use this as an expectation for your new budget.<\/span><\/p>\n<p><span data-verified=\"redactor\" data-redactor-tag=\"span\" data-redactor-style=\"font-size: 16px;\">Generally speaking, the longer the history and the more consistent the gross profit percentage, the more confidence you can have in the accuracy of the number.<\/span><\/p>\n<p><span data-verified=\"redactor\" data-redactor-tag=\"span\" data-redactor-style=\"font-size: 16px;\">In other words, if gross profit has ranged between 45% and 48% each month for the last year or two, you can feel pretty good that this trend will continue.<\/span><\/p>\n<p><span data-verified=\"redactor\" data-redactor-tag=\"span\" data-redactor-style=\"font-size: 16px;\">There are always exceptions, of course. If you\u2019re planning major additions of equipment, building improvements or personnel the gross profit can change in a hurry.<\/span><\/p>\n<p><span data-verified=\"redactor\" data-redactor-tag=\"span\" data-redactor-style=\"font-size: 16px;\">Look at the cost components of your beer \u2013 labor, materials and overhead. Look to your budget in words for reminders on goals, plans and strategy for next year. If no major changes, use the trend.<\/span><\/p>\n<p><strong data-redactor-tag=\"strong\"><span data-verified=\"redactor\" data-redactor-tag=\"span\" data-redactor-style=\"font-size: 16px;\">Operating Expense Plan<\/span><\/strong><\/p>\n<p><span data-verified=\"redactor\" data-redactor-tag=\"span\" data-redactor-style=\"font-size: 16px;\">Every expense number of significance should have a supporting schedule: payroll, lease payments, travel budgets, etc. A supporting schedule is a fancy way of saying \u2013 make a list that adds up to that one number on the operating expense plan.<\/span><\/p>\n<p><span data-verified=\"redactor\" data-redactor-tag=\"span\" data-redactor-style=\"font-size: 16px;\">To build up the expense plan and make sure everything is accounted for, I find it very helpful to comb through the detailed transactions in the general ledger.<\/span><\/p>\n<p><span data-verified=\"redactor\" data-redactor-tag=\"span\" data-redactor-style=\"font-size: 16px;\">The general ledger lists out all the transactions that hit the financial statements. It\u2019s basically like a check register that shows where money was spent and a description of what was purchased.<\/span><\/p>\n<p><span data-verified=\"redactor\" data-redactor-tag=\"span\" data-redactor-style=\"font-size: 16px;\">Where did we spend money? Will that happen again? Will we spend more or less? What new plans do we have next year? What will it cost?<\/span><\/p>\n<p><span data-verified=\"redactor\" data-redactor-tag=\"span\" data-redactor-style=\"font-size: 16px;\">Chances are, if you bought something this year, you\u2019ll buy it again next year. Use the general ledger to jog your memory on expense items that are likely to repeat. Use the historical amounts as a baseline for budgeting expenses next year.<\/span><\/p>\n<p><span data-verified=\"redactor\" data-redactor-tag=\"span\" data-redactor-style=\"font-size: 16px;\">Again, use the budget that you created in words: Brainstorm and estimate spending needs based on those goals and dreams. If you don\u2019t account for it in the operating expense plan, it\u2019s tough to make the dreams come true.<\/span><\/p>\n<p><strong data-redactor-tag=\"strong\"><span data-verified=\"redactor\" data-redactor-tag=\"span\" data-redactor-style=\"font-size: 16px;\">Capital Budget<\/span><\/strong><\/p>\n<p><span data-verified=\"redactor\" data-redactor-tag=\"span\" data-redactor-style=\"font-size: 16px;\">The capital budget is the place for big purchases. Big ticket items go here: that new canning line, keg washer and delivery van.<\/span><\/p>\n<p><span data-verified=\"redactor\" data-redactor-tag=\"span\" data-redactor-style=\"font-size: 16px;\">Anything that costs more than a set amount, say $1,000, and will last longer than a year should be on the capital budget.<\/span><\/p>\n<p><span data-verified=\"redactor\" data-redactor-tag=\"span\" data-redactor-style=\"font-size: 16px;\">The difference between a Capital Expense and an Operating Expense is that capital items need to be written off over a certain period of time. If you buy a box of copy paper for $50 it\u2019s an expense on the current income statement. If you buy a $15,000 fork lift, that\u2019s a capital expense that will be depreciated over the next five years.<\/span><\/p>\n<p><span data-verified=\"redactor\" data-redactor-tag=\"span\" data-redactor-style=\"font-size: 16px;\">Make your wish list. Determine what the items will cost and when you expect to buy them. This will help with cash needs planning.<\/span><\/p>\n<p><span data-verified=\"redactor\" data-redactor-tag=\"span\" data-redactor-style=\"font-size: 16px;\">Lastly, match up the expected spending to the expected funding. It\u2019s kind of important to figure out how you\u2019re going to pay for that new canning line, keg washer and delivery van. List any new loans or new capital you will need to make the Capital Budget a reality.<\/span><\/p>\n<p><strong data-redactor-tag=\"strong\"><span data-verified=\"redactor\" data-redactor-tag=\"span\" data-redactor-style=\"font-size: 16px;\">Debt Service<\/span><\/strong><\/p>\n<p><span data-verified=\"redactor\" data-redactor-tag=\"span\" data-redactor-style=\"font-size: 16px;\">Debt Service is the amount you pay each month on your loans. This is like customer service, expect with debt. The customer is always right, and so is the bank.<\/span><\/p>\n<p><span data-verified=\"redactor\" data-redactor-tag=\"span\" data-redactor-style=\"font-size: 16px;\">Create a schedule of all your debt and the payments due on each. List the bank, type of loan, term of the debt and of course the payment amounts.<\/span><\/p>\n<p><span data-verified=\"redactor\" data-redactor-tag=\"span\" data-redactor-style=\"font-size: 16px;\">Remember, only interest expense shows up on your income statement. The principal portion of your payment needs to be figured into your cash plan. The Debt Service schedule will serve as a reminder of how much is due and when.<\/span><\/p>\n<p><strong data-redactor-tag=\"strong\"><span data-verified=\"redactor\" data-redactor-tag=\"span\" data-redactor-style=\"font-size: 16px;\">Wrap Up + Action Items<\/span><\/strong><\/p>\n<p><span data-verified=\"redactor\" data-redactor-tag=\"span\" data-redactor-style=\"font-size: 16px;\">Here\u2019s the bottom line: any budget is better than no budget at all. Begin the budget process by writing out your plan in words and create a budget story. The main characters in the story are: the sales forecast, gross profit plan, operating expense plan, capital budget and debt service.<\/span><\/p>\n<p><span data-verified=\"redactor\" data-redactor-tag=\"span\" data-redactor-style=\"font-size: 16px;\">Take your budget story and translate it into numbers. Use the budget templates as a jumping off point.<\/span><\/p>\n<p><span data-verified=\"redactor\" data-redactor-tag=\"span\" data-redactor-style=\"font-size: 16px;\">I believe in you and I believe you can do this. A beautiful budget for your brewery is within your reach. Now, crack open a beer and build a budget that will make me proud.<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u201cA budget tells us what we cannot afford, but it doesn&#8217;t keep us from buying it.\u201d William Feather Do you need to create an operating budget for your brewery? Of course you do. Let&#8217;s start with a budget pep talk. I have created hundreds of budgets over my career and\u00a0I still get anxious when starting [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":1180,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"pgc_meta":"","_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"categories":[63,70,65],"tags":[],"class_list":["post-1179","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-financial","category-financial-newsletters","category-financial-resources"],"_links":{"self":[{"href":"https:\/\/craftbreweryfinance.com\/oldversion\/wp-json\/wp\/v2\/posts\/1179"}],"collection":[{"href":"https:\/\/craftbreweryfinance.com\/oldversion\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/craftbreweryfinance.com\/oldversion\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/craftbreweryfinance.com\/oldversion\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/craftbreweryfinance.com\/oldversion\/wp-json\/wp\/v2\/comments?post=1179"}],"version-history":[{"count":0,"href":"https:\/\/craftbreweryfinance.com\/oldversion\/wp-json\/wp\/v2\/posts\/1179\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/craftbreweryfinance.com\/oldversion\/wp-json\/wp\/v2\/media\/1180"}],"wp:attachment":[{"href":"https:\/\/craftbreweryfinance.com\/oldversion\/wp-json\/wp\/v2\/media?parent=1179"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/craftbreweryfinance.com\/oldversion\/wp-json\/wp\/v2\/categories?post=1179"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/craftbreweryfinance.com\/oldversion\/wp-json\/wp\/v2\/tags?post=1179"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}