5.2.1 Introduction
5.2.2 Estimating the cost of budget
items
5.2.3 Estimating the cost of workload
dependent budget items
Budgeting is the Process of ensuring that the correct finance is available for the provision of IT Services and that during the budget period they are not over-spent. The Budgeting process has a key influence on strategic and tactical plans. It is also the means of delegating control and monitoring performance against predefined targets. It is paramount that budgets are effectively integrated within the organisation and that managerial responsibility and accountability is matched and communicated in an efficient way.
As all spend affects profitability, it must be recognised that decisions about investment in IT Services and the integrated management IT Accounting discipline can help provide the competitive edge necessary for survival of an organisation.
All organisations have a periodic (e.g. annual) round of negotiations between the business departments and the IT organisation covering expenditure plans and agreed investment programmes which ultimately sets the budget for IT. These are closely linked to reviews with the businesses (individually or collectively) that cover:
The final budget agreed for an IT organisation may include financial disciplines imposed by the organisation, including:
Further, the business departments which provide the revenue to the organisation, from which departmental budgets are drawn, may themselves have rigid limits on the way in which they pay for services - they may not be able to fund a Change in service or service level mid-year despite IT being able to provide it.
An example, very simplified, budget is shown in Table 5.1.
Budget Item |
Capital |
Purchase Cost |
Annual Maintenance |
Spend |
Budget |
Notes |
Annualised |
Hardware |
|
||||||
UNIX Server |
Yes |
£80,000 |
£8,000 |
£8,000 |
£8,000 |
No changes |
£34,667 |
NT Server |
Yes |
£10,000 |
£1,000 |
£1,000 |
£1,000 |
No changes |
£4,333 |
Netware Server |
Yes |
£3,000 |
£300 |
£300 |
£300 |
No changes |
£1,300 |
PCs (50) |
Yes |
£60,000 |
£6,000 |
£6,000 |
£6,000 |
No changes |
£26,000 |
Routers (5) |
Yes |
£3,000 |
£300 |
£300 |
£300 |
No changes |
£1,300 |
LAN Cabling |
Yes |
£40,000 |
£4,000 |
£4,000 |
£4,000 |
No changes |
£17,333 |
|
|||||||
Software |
|
||||||
General Ledgers |
No |
£20,000 |
£20,000 |
£24,000 |
|||
ORACLE |
No |
£7,000 |
£7,000 |
£8,400 |
|||
Marketing and Sales appl. |
No |
£3,000 |
£3,000 |
£3,600 |
|||
MS Windows (50-User) |
No |
£2,500 |
£2,500 |
£3,000 |
Staff increase |
||
MS Office (20-user) |
No |
£3,000 |
£3,000 |
£3,600 |
from 50 to 60 |
||
Netware |
No |
£3,000 |
£3,000 |
£3,600 |
|||
NT |
No |
£2,500 |
£2,500 |
£3,000 |
|||
|
|||||||
Employment |
|
||||||
Manager |
No |
£50,000 |
£50,000 |
£52,000 |
4% pay rise |
||
Senior Operator |
No |
£30,000 |
£30,000 |
£30,000 |
Just joined |
||
Operator |
No |
£20,000 |
£20,000 |
£21,000 |
5% pay rise |
||
Contractor |
No |
£100,000 |
Paid by Marketing |
||||
|
|||||||
Accommodation |
|
||||||
Computer Room |
No |
£10,000 |
£10,000 |
£10,200 |
2% rise in |
||
Office |
No |
£10,000 |
£10,000 |
£10,200 |
charges |
||
|
|||||||
External Service |
|
||||||
Wide Area connection |
No |
£20,000 |
£20,000 |
£20,000 |
Fixed price, |
||
DR contract |
No |
£10,000 |
£10,000 |
£10,000 |
3-year contracts |
||
|
|||||||
|
Total |
£210,600 |
£222,200 |
Table 5.1 - Example budget calculation
Note: the annualised cost is taken as 1/3 of the purchase cost, plus the annual maintenance cost and will be used in the Cost Model in Paragraph 5.3.3
The categorisations in Table 5.1, of hardware, software etc, are arbitrary but help ensure that all of the budget items can be identified. Other categorisations can be chosen: the test is that all budget items are identified. The categorisation needs to be consistent for two reasons. The first reason is to enable an organisation to make true comparisons, year on year, both with its own expenditure trends and with the costs of other organisations. The second reason is to provide a simple basis for activity based Costing, as expenditure items likely to be treated in the same manner logically, are grouped together. This may also be important if different accounting rules, e.g. Depreciation (see Paragraph 5.3.5), are to be applied to different categories of costs. Cost Types in Paragraph 5.3.4 provides more detail to these categorisations.
The cost of some budget items may not be known at the time a budget is drawn up, e.g. overtime payments, contractor payments, consumables, external network charges. These have to be estimated, usually based upon a previous IT Accounting period, or on a forward prediction of the costs of the estimated workload.
Some costs may vary from the estimates, depending upon the usage. An example of this is software licences that may increase (in steps) as further Users are introduced. Other costs may need to be estimated to cover out-of-hours support, major equipment re-location.
IT Finance Management must be cautious in estimating changes in costs where they do not fully control them. For example, planning a reduction of 20% computer accommodation usage by removing old disk drives and closing one room is unlikely to result in 20% saving in costs, as the rental for the space may be fixed by the lease.
Another reason for costs changing, is when the IT workload Changes. For this reason, workload estimates and forecasts should be considered when drawing up budgets. Such estimates and forecasts are also required for the preparation of Service Level Agreements and for Capacity Management.
Estimates of workload volumes are normally obtained from historical data, and forecasts are made on the basis of updated information and revised plans. A fuller approach to workload estimating can be seen in Chapter 6.
In the simplified example, Table 5.2, a calculation is performed for the cost (for budgetary purposes) of the Wide Area Network (WAN).
Current Year | Budget Year | ||||||
Factor | Quantity | Unit Cost | Cost | Quantity | Unit Cost | Cost | Note |
Users |
30
|
-
|
40
|
-
|
|||
64k dial-up lines |
5
|
£200
|
£1,000 |
10
|
£200 | £2,000 | |
64k dial-up telephony |
|
|
£3,000 |
|
£6,000 | Demand per user doubles each year | |
ISDN lines |
2
|
£1,000
|
£2,000 |
7
|
£1,000 | £7,000 | Higher proportion of customers use ISDN |
Routers required |
1
|
£500
|
£500 |
3
|
£500 | £1,500 | 1 router handles up to 8 lines |
|
|
|
|||||
Network Budget |
|
|
£6,500 |
|
£16,500 |
Table 5.2 - Estimating workload-dependent budget items