Budgets: Creating and Using Your Budget Effectively

This guide helps you understand the importance of budgeting and how to create and use a budget effectively, so you can keep your business financially on track.

This guide covers:

  • Budgeting: why bother and what’s involved?
  • Creating your first budget
  • Sales budgets – building and using yours
  • Profit and loss budgets – building and using yours

Budgeting: why bother and what’s involved?

If you’re thinking of starting a business, a budget shows you and your potential backers whether your idea is viable. Once your business is up and running, a budget provides a blueprint for your business’ success, and an accurate measure of how it is performing against your blueprint, month by month.

Budgeting helps you forecast:

  • How much money you will spend.
  • How many products or services you hope to sell.
  • How much profit you are likely to make.

Building a detailed budget at the beginning of each year or financial period helps you make these forecasts more accurately. As each month ends, you can update your budget with actual data and adjust future estimates accordingly. This provides an accurate, at-a-glance projection of the business’s financial position at the end of the budget period.

A detailed budget helps you:

  • Pinpoint immediately where income, spending and profit stand versus monthly and yearly targets.
  • Track monthly progress and make adjustments based on actual figures.
  • Identify early when the company is drifting off course financially.
  • Illustrate your financial position and plans to key people such as staff, the bank, financial backers.

Creating your first budget

Where to begin? Every new business starts with a zero-based budget – ie figures for sales, costs and profit based purely on estimates. The figures you use should reflect your business goals and ambitions.

If you know your marketplace, the figures should be an honest assessment of what you expect your business to achieve in the given budget period. If you have no experience in your marketplace, your first task should be to seek the advice of someone who does. Their guidance and help will ensure your estimates are more realistic.

In future years you can produce historically-based budgets, using sales, cost and profit data from past years as an accurate starting-point to budget for the coming year.

Prepare best-case and worst-case figures

To help you plan both for a great year and poor year, creating two budgets using best-case and worst-case figures can be helpful. Then you can think through the implications of each scenario and prepare accordingly.

Getting the basics of budgeting right

Whether you decide to compile your budgets on paper or on a computer-based spreadsheet, the more accurate and up-to-date you make them – using all available data – the more useful they become. Regularly reviewing, updating and recalculating your budgets is an essential discipline, focusing your mind on costs, reminding you of business issues and giving you an accurate snapshot of how the company is performing against targets.

Even as you prepare to launch your business, you should be tweaking your budget as you gain more insight into production costs.

Annual budgeting is best done on a month-by-month basis, making sure you adjust monthly predictions if your business is likely to experience seasonal sales peaks during a year. For long-term financial planning, quarterly budgets are more useful.

Sales budgets – building and using yours

Building your sales budget

For each product (or product group if you have lots), consider carefully the most accurate answers to these key questions:

  • How many units are you planning to sell each month?
  • At what net price will you sell each unit? (Deduct any discounts by month and, if you’re registered, ignore VAT for now.)

Enter your results in a table like this:

Table 1

January
February
March
Quarter 1 Total
Product A
Sales units (UA)
1000
1500
3000
5500
Selling price (PA)
£5
£5
£4.50
Sales value (VA = UA x PA)
£5000
£7500
£13500
£26000
Product B
Sales units (UB)
500
400
600
1500
Selling price (PB)
£9
£9
£8
Sales value (VB = UB x PB)
£4500
£3600
£4800
£12900
Total sales value (VA + VB)
£9500
£11100
£18300
£28900

(Key: U = Units sold, P = Price per unit, V = Sales Value)

Using the simple formula sales units x sales price = sales value, you can calculate sales values for each month in a given period, adding them up to give you a quarterly figure (as in the illustration) and combine these to get yearly totals.

Using your sales budget

To make best use of your budget, plot your actual performance against it. You can then calculate how much over or under you are for your budget targets, identifying which products are over or under-performing. This is called a variance report.

If you have computerised accounting software, you should be able to input your monthly figures and the program will produce variance reports for you, both for that month and for the year to date. If not, you can construct your own report, like this one:

Table 2

January (£)
February (£)
March (£)
Actual sales
8000
10500
19000
Budgeted sales
9500
11100
18300
Variance
(1500)
(600)
700
Year to date
Actual sales
8000
18500

37500

Budgeted sales
9500
20600
38900
Variance
(1500)
(2100)
(1400)

Figures in brackets are negative.

The variance figure is produced by taking the budgeted figures away from the actual figures. The year-to-date figure is an accumulation of the amounts for each month.

By producing this variance report you can see several things clearly:

  • Total actual sales you’ve made by month.
  • How much actual sales vary from budgeted sales.
  • A cumulative total of actual sales each month.
  • A cumulative variance by month.

Why are these figures useful? The variance report gives you a snapshot of where your business stands financially compared to your budget. It also shows you in which months you have sold more than you thought you would and in which months you have sold less. By adding actual data you can easily spot trends. You can use this information to adjust future budgeted figures. This enables you to see – using all available data and having adjusted future budget figures – where the company will stand financially at the end of the budget period.

For instance, if you have an average positive variance of 10 per cent for the first six months of the year, it’s reasonable to adjust your budgeted figures upwards for the rest of the year.

Profit and loss budgets – building and using yours

Your sales budget feeds into a profit and loss budget which, taking all your other costs into consideration, enables you to work out how much profit you make each month and how much you’re likely to make in your budget period.

Working our the cost of sales

Cost of sales is a key part of working out how much profit you are making. Total revenue from sales minus total cost of sales equals profit.

First you need to work out how much it costs to produce the product, ie labour costs, materials etc. This is your unit cost. If you buy in your products, your unit cost is the wholesale price you pay for the product.

You then need to work out other costs per unit, ie every other cost involved in producing and selling each product. These include:

  • Staff commission.
  • Utility bills for machinery, repairs and maintenance.
  • Storage.
  • Delivery costs.
  • Packaging.

You need to work out what these costs are for each unit you sell. If the costs do not apply to individual units, such as utility bills and storage, take an average monthly cost and divide it by the number of units you think you will sell each month. This gives you an average estimated cost per unit for these costs. For instance: staff commission = £25p per unit; utility bills per month = £100 divided by an estimated 2000 units sold = 5p per unit; and so on.

If you take all of these costs and spread them over the months of the budget, you get total sales costs per month. From your sales budget use the predicted number of units per month and divide your sales costs by your number of sales. This gives you sales costs per unit. Add your unit cost to your sales cost per unit and you have your total cost of sale per unit.

To calculate your monthly cost of sales:

  • Bring down the total units you plan to sell in the year for each product from the sales budget (Table 1) into column 2.
  • Enter the unit cost in column 3 of the table below and other costs of sales in column 4.
  • Add the unit cost (column 3) to the other costs of sales (column 4). Multiply the result by the number of units sold to give a cost of sales for each product in the last column.

Table 3

Units Sold
Unit Cost
Other Costs of Sales
Cost of Sales
Product A
21000
£2.48
£0.52
£63000
Product B
6000
£3.74
£0.26
£24000
Total cost of sales
£87000

Calculating your gross profit

Gross profit is the surplus of money you’ve taken (turnover) once you’ve taken away your cost of sales. To calculate gross profit:

  • Take the total annual sales value from the sales budget (Table 1) – sales value is also often referred to as turnover – and copy it into the table below.
  • Bring down the cost of sales from Table 3.
  • Deduct cost of sales from turnover to get gross profit.

Table 4

£
Sales value
[T]
150500
Less cost of sales
[C]
87000
Gross profit
[G = T – C]
63500

Calculate your net profit

To find your real profit, you now need to deduct other costs not directly linked to sales and unit production. An example is rent, which won’t vary however many units you sell. These are called fixed costs or overheads.

For your overheads, take into account all your other costs, including:

  • Marketing, advertising, trade shows and PR.
  • Office and property running costs, including cleaning
  • Staff wages employing people, including pension contributions and Employer’s National Insurance.
  • Professional fees, including legal and accountancy fees.
  • Financing costs such as interest and bank charges.

Remember, most overheads will change over time (due to inflation, for instance), although costs like office rent might be fixed for at least a year ahead. So when you’re budgeting, it is important to include everything, be realistic and build in rising costs when you think they may occur. Most start-ups underestimate a lot of these overhead costs and end up with inaccurate profit estimates.

Note: if you are a manufacturer, be careful not to double-count items like labour costs and electricity that you have already built into your cost of sales.

Depreciation

Typically, to run a business you will need things like furniture, cars, computers, machine tools and so on. These are called capital items or fixed assets, and their purchase cost is not included in the budget. Instead, there is a special charge that accountants call depreciation. This is not an expense as such because it doesn’t involve parting with any cash, but it does represent an estimate of the proportion of the value of your fixed assets that is used up during the year.

For example, if you buy a new machine every four years, and the last one cost you £1000, you should include a depreciation charge of 25% of this £1000, ie £250 in each of the four years. By doing so, you’re building into your accounting surplus cash to buy new equipment when it is needed.

Let’s extend our table with a few overhead items. Your list of items will probably be much longer, but this example is merely to illustrate the format.

Add up all the Overheads and deduct from your Gross Profit to give a Net Profit of £18,800 for the year.

Table 5

£
£
% of sales
Sales value (turnover)
150500
100%
Less cost of sales
87000
58%
Gross profit
63500
42%
Less overheads
44700
Office/management salaries
21000
Rent/rates
3500
Selling costs/advertising
9500
Telephones
1800
Electricity
1200
Postage/stationery
1900
Professional fees – legal and accountancy
2100
Interest paid
1500
Depreciation
2200
Total overheads
44700
30%
Net profit
18800
12%

Add in actual figures and variance

Take Table 5 and add two extra columns – one for actual figures and one for variance. The actual figures again come from your accounting records and again exclude VAT. And the variance is calculated as the difference between the actual and budget column figures.

Table 6

Actual
Budget
Variance
Turnover
£145000
£150000
(£5500)
Cost of sales
£85000
£87000
£2000
Gross profit
£60000
£63000
(£3500)
Overheads
£47500
£44700
(£2800)
Net profit
£12500
£18800
(£6300)

Note that if turnover or profit is less than budget, the variance is negative (ie in brackets). However, if costs or overheads are less than budget, the variance is positive.

Table 6 gives you a simplified overview. It clearly shows you where your budget varies compared to your actual figures. This enables you to pinpoint areas that need attention, or areas that are more cost-efficient for the company.

The importance of cashflow

Just as important as your profitability is your cashflow. You can’t sell things unless you buy or make them, both of which may involve paying out cash before getting any return from them. Most businesses that fail do so because they run out of available cash, often despite showing good profits. Cashflow problems can also arise in seasonal businesses or those with poor credit control.

So another vital table is a cashflow forecast, where you list all your cash inflows and outflows and when you expect them to occur. This highlights periods when you may need a temporary overdraft. If you have a detailed annual budget that shows cashflow issues in the short term but good profits at the end of the year, this will help obtaining finance.

Useful contacts

For more information about budgeting, contact your local Business Link service on 0845 600 9006 or visit www.businesslink.gov.uk


This business advice article published in association with Lloyds TSB.

Whether you are looking to start-up a business account or want to move your existing business account Lloyds TSB can offer you all the Business Banking support you need

While all reasonable care has been taken to ensure that the information in this website is accurate, no liability is accepted by Lloyds TSB for any loss or damage caused to any person relying on any statement or omission in the content of this website. The content of this website is provided for information only and should not be relied on as offering advice for any set of circumstances and specific advice should always be sought in each instance

Budgets: Creating and Using Your Budget Effectively

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>