A warehouse budget: planning costs in advance

Many warehouses live without a budget: costs "come to light" at month end in the accounts, and the manager shrugs, "this month it came out expensive". Yet most warehouse costs can be foreseen. A warehouse budget is not for reporting but for decisions: how many orders can we take, do we need another person, when is it time to expand, what price should we quote a new customer. A budget lets you answer these questions with figures instead of by eye.

Split costs into two groups

Fixed costs do not depend on volume: rent, the pay of core staff, utilities, payment for software and communications, insurance. Variable costs grow with volume: temporary workers and overtime, packing materials, fuel, labels, damaged goods. The split matters because when volume changes only the second group moves while the first stays as it was. That is exactly why managers are puzzled: "volume rose, so why didn't costs?" or "volume fell, so why didn't costs?"

Include in the budget the items that are often forgotten: shrinkage and the write-off of damaged goods, the cost of stock counts, equipment repairs, staff training. They are not visible every month, but over a year they add up to a noticeable sum.

Building a budget in five steps

1. Gather the costs of the last 12 months by item; accounting and payment documents are enough.
2. Estimate the volume of the next period in advance: the number of order lines or pallets to be shipped. Do this together with sales and purchasing.
3. Name a person responsible for every item: whoever starts a cost answers for it.
4. Write seasonal peaks and planned changes (a new shift, a change in rent) on a separate line.
5. Set aside a small reserve for the unexpected, but record it under its own name instead of hiding it inside other items.

Keep the budget in one Excel file: columns for plan, actual and comment are enough for each item. No complex software is needed, only the same routine of filling it in every month.

Work out the unit cost

The most useful result of a budget is the cost of one shipped order line (or pallet). An example, with illustrative figures. Fixed costs are 120 million so'm a month, variable costs at 30,000 lines are 60 million so'm, that is 2,000 so'm per line. The total is 180 million so'm, or 6,000 so'm per line. If next month volume grows by 20 percent to 36,000 lines, variable costs become 72 million so'm while fixed costs stay at 120 million so'm. The total is 192 million so'm, about 5,333 so'm per line. Volume rose by 20 percent, costs by only 6.7 percent. Conversely, if volume falls, fixed costs fall on each line in a larger share and the unit cost rises. A manager who knows this figure will not go wrong when pricing a new order or judging an outside offer. Watching the unit cost month by month also shows early that costs are creeping up.

Plan versus actual: one page a month

At month end plan and actual are compared for each item. The main thing is to find the cause, not the culprit. You set the deviation threshold yourself, for example discussing differences above 10 percent and skipping small ones, otherwise the meeting drifts into detail. For each large deviation three questions are asked: why did it happen, was it a one-off or will it repeat, and what are we changing. Get the actuals from accounting not after the month closes but, if possible, weekly: you cannot stop a cost with news that is a month late. Write large one-off costs (racking, equipment, software) into a separate investment plan and do not mix them with monthly running costs, otherwise the monthly figure jumps about and becomes impossible to read.

Typical mistakes

• building the budget only from the top and not asking the warehouse manager;
• ignoring the seasonal peak, so that money runs short in the busiest month of the year;
• changing the plan to match the actual, which makes the plan meaningless;
• looking at a cost apart from volume: say not "rent went up" but "the cost of one line went up".

Conclusion

A budget does not restrict the warehouse; it gives confidence in decisions. The OmborExpert specialists help put cost items in order, work out the unit cost and set up a monthly management report.