Chapter 4: Quantitative techniques in budgeting
© EWP Go to www.emilewoolfpublishing.com for Q/As, Notes & Study Guides 85
The company might decide to prepare a sales budget on the assumption that annual
sales will be $46 million.
The problems with using probabilities and expected values
There are two problems that might exist with the use of probabilities and expected
values.
The estimates of probability might be subjective, and based on the judgement or
opinion of a forecaster. Subjective probabilities might be no better than educated
guesses. Probabilities should have a rational basis.
An expected value is most useful when it is a weighted average value for an
outcome that will happen many times in the planning period. If the forecast
event happens many times in the planning period, weighted average values are
suitable for forecasting. However, if an outcome will only happen once, it is
doubtful whether an expected value has much practical value for planning
purposes.
This point can be illustrated with the previous example of the EV of annual sales.
The forecast is that sales will be $40 million (0.60 probability), $50 million (0.30
probability) or $70 million (0.10 probability). The EV of sales is $46 million.
The total annual sales for the year is an outcome that occurs only once. It is
doubtful whether it would be appropriate to use $46 million as the budgeted
sales for the year. A sales total of $46 million is not expected to happen.
It might be more appropriate to prepare a fixed budget on the basis that sales
will be $40 million (the most likely outcome) and prepare flexible budgets for
sales of $50 million and $70 million.
When the forecast outcome happens many times in the planning period, an EV
might be appropriate. For example, suppose that the forecast of weekly sales of a
product is as follows:
Weekly sales Probability EV of weekly sales
$ $
7,000 0.5
3,500
9,000 0.3
2,700
12,000 0.2
2,400
8,600
Since there are 52 weeks in a year, it would be appropriate to assume that weekly
sales will be a weighted average amount, or EV. The budget for annual sales would
be (52
× $8,600) = $447,200. If the probability estimates are fairly reliable, this
estimate of annual sales should be acceptable as the annual sales budget.
3.4 Spreadsheets and ‘what if’ analysis
Preparing budgets is largely a ‘number crunching’ exercise, involving large
amounts of calculations. This aspect of budgeting was made much easier, simpler
and quicker with IT and the development of computer-based models for budgeting.
Spreadsheet models, or similar planning models, are now widely used to prepare
budgets.