Budgeting for a small manufacturer: how to build and use budget vs actual

A small manufacturer lives with three pressures at once: raw material prices that move, orders that come in lumps, and fixed costs that do not care about either. A budget is not a bureaucratic exercise in that setting. It is how you decide in July how much to buy, how many people to keep, and whether the loan you are about to take can be repaid from the margin you expect.

The problem is that many budgets are written once, filed, and never compared with reality. This guide shows a budget you can build in a few days and a monthly budget-versus-actual habit that takes an hour.

Start with sales, in quantities

Everything flows from what you expect to sell. For each product group, estimate units by month, using last year's actual sales, confirmed orders, seasonal peaks (Eid, wedding season, export shipment windows) and known changes in your customers. Multiply by expected prices to get revenue. Be conservative: it is much easier to run a business on a budget that is slightly low than one that assumes your best months.

Build the cost side from the bill of materials

• Direct materials: units to be produced times material quantity per unit (from your BOM or recipe) times expected price, including a wastage allowance
• Direct labour: hours or piece-rate output needed for the planned volume
• Variable overheads: power, packaging, consumables, freight, which rise with production
• Fixed overheads: rent, salaries of fixed staff, insurance, depreciation, loan interest, which stay broadly the same each month
• Selling and administration costs: commissions, marketing, office costs

Separating variable from fixed costs is the most useful thing you will do. It tells you what happens to profit if volume falls by 20%: variable costs fall with it, fixed costs do not.

A simple monthly budget layout

Budget on the same account structure you use for actuals, so the comparison is line for line. A budget on a different structure from the ledger creates reconciliation work every month and eventually gets abandoned.

Do not forget cash

Profit and cash are different. A manufacturer who buys raw material three months before the customer pays can be profitable and out of cash at the same time. Build a simple cash budget next to the profit budget: when materials are paid, when customers pay on their terms, when loan instalments, VAT payments and salaries fall due, and when capital items are bought. If the cash line turns negative in some month, you have found next year's problem while there is still time to arrange finance.

Budget vs actual: the monthly routine

1. 1Close the month first. Budget versus actual on unreconciled books just compares a plan with noise.
2. 2Run the budget versus actual report for the month and for the year to date.
3. 3Mark the variances that matter. Use a simple rule such as any line differing by more than 10% and more than a fixed taka amount, so you are not drowned in small items.
4. 4For each flagged line, find the cause: price, volume, wastage, timing, or an error.
5. 5Decide an action or accept the variance deliberately. Write down which.
6. 6If circumstances have really changed, reforecast the rest of the year rather than pretending the original budget still holds.

Price, volume and efficiency

A material cost overspend can come from three different problems that need different responses: you paid more per kilogram (price), you made more units than planned (volume, which may be good news), or you used more material per unit (efficiency, meaning wastage or recipe drift). Compare quantities as well as taka, and the cause becomes visible quickly.

Using cost centres

If you run more than one plant, product line or shop, track budgets and actuals by cost centre so each manager sees their own numbers. A combined variance that nets off a good line against a bad one hides both. The accounting module in eSolverBooks supports budgets and a budget-versus-actual report, and cost centres let you cut the numbers by branch or department.

Common budgeting mistakes

• Adding a percentage to last year's numbers without asking what changed
• Ignoring seasonality by dividing the annual figure by twelve
• Leaving out depreciation, interest and tax-related cash payments
• Setting targets nobody believes, so nobody uses the report
• Never revisiting the budget, even after a major customer is lost or a price shock hits

Start small. Even a one-page budget with ten lines, compared monthly and discussed for an hour with your production and sales heads, will teach you more about your business than a thick plan nobody reads. Refine it every year. After two cycles it becomes the way you run the company.