Project Budget Template

Project Budget Template

& TIPS FOR IT SOFTWARE

BUDGETS

Quickly prepare your software project budget with this project budget template, which may be amended to your requirements. Sample figures included for illustration purposes, will need to be replaced with your own figures. Also, see below for 25 tips for a more accurate and timely software project budget. The Excel ‘Project Budget Template’ is available for free download (70KB):

PROJECT BUDGET PROCESS

1. Determine your software project budget process eg o the steps required to gather the information o the time scales for your budget process and key dates o the deliverable(s) required o who is involved and what resources are available o the formal review stages o the number of project budget iterations and re-workings o how budgetary disagreements should be resolved 2. Is one person to be in overall charge of calculating the project budget? Or will various sections of the budget be allocated to team members to complete and then be consolidated together? 3. Ideally there should be input from a number of people associated with the software project. So arrange for contributions from the project manager, project leader, information systems manager, key users, steering group members, vendors (for software quotes) and procurement. 4. Remember, your first calculation of the budget is just that – your best estimates and (educated) guesses at the time. Treat the budget calculations as ongoing ‘work-in- progress’ and continually refine and revise, until the budget is approved / finalised. But even after approval, unforeseen events and project changes can force a budget to be revised or re-forecast. BUDGET COSTS 5. Determine what you are including within your project budget. Include only in-scope items. Exclude all non-scope items. But keep a list of excluded items, so they may be included or budgeted for at a later stage, if required. 6. Identify and itemise all project costs 7. Determine if you are working on an incremental cost basis (ie only including new or additional costs for your organisation). Or whether you are working on a full costing basis (ie including the project’s share of allocated costs incurred within the organisation). If including allocated costs, do so, on a consistent and agreed basis. 8. For purchases, include shipping and sales taxes / VAT if unable to reclaim them. 9. Cost all tasks within the project plan. Initially labour costs can be estimated as the number of days multiplied by their estimated day rate. Later on, more accuracy may be achieved by working in hours and an hourly rate. 10. Ensure daily or hourly labour rates include: salary + benefits + pension contribution + social security costs ie the total labour costs. 11. Review other software projects / staff performance to get an idea of how long people take to complete specific tasks. 12. State your budget assumptions – so if these change, the budget can easily be revised. BUDGET RISKS 13. The total project budget is the sum of the itemised estimated costs plus contingency for project risk. Typically, contingency (for project risk) can range from 5% of costs for a small quick project, to 30% or more for a large, complex or long project. 14. One option for calculating contingency is to simply add a percentage to the total costs, based on your best estimate. However, for more accuracy, you could identify the known and potential risks and then estimate a contingency for each project cost item. Risks can include: the number of software modules, the number and experience / skills of resources, project dependencies, critical dates, time shortages, implementing over multiple locations, new technology and costs yet to be negotiated. BUDGET REVIEW 15. Regularly review the budget, both on a formal and informal basis. Whilst the total project budget cost is important, are there any components which look high, low or unusual? What is the budgeted project cost per user (total project budget costs divided by number of users)? 16. Look out for obvious over or under budgetary estimates – attempt to be as realistic as possible. 17. Compare your calculations with those from the software vendor. What is their estimated total cost for your project / organisation? What is their typical total project cost and typical cost per user, for projects that they have undertaken elsewhere? 18. Compare with other projects within your organisation and their deliverables, original budgets, actual costs, over / under budget analyses. 19. Is your budget broadly ½ software and ½ labour (ie excluding hardware expenditure within the project)? Or is it roughly one third each for software, hardware and labour (if replacing hardware)? If not, re-examine your costs. 20. Are the budgetary items and their costs included in the correct year? Is the budgetary phasing / timing accurate? Have any warranty periods been included, prior to the commencement of annual (maintenance) costs? Would greater accuracy be achieved by phasing costs over months or quarters, rather than in years? 21. Are there any budgetary disagreements awaiting resolution? If so, are there project cost implications and have these been included within the budget? 22. Is the contingency for project risk large enough? What is used for other similar projects within your organisation? Can an increase be justified? 23. Have the budgetary calculations been checked for any spreadsheet errors? If not, double check. 24. Have all budget amendments been documented and reviewed? If not, add amendments into the budget and review accordingly. 25. Has the budget been independently reviewed eg by another project team member or by a member of the finance department? For more IT project proposal information visit: Reasons for changing software / Project scope checklist / IT project proposal / Proposal format / Basic ROI calculation / ROI calculator and tips for maximising systems project ROI / Hidden costs of acquiring software / Project budget template and tips for improving IT software budgets / Proposal evaluation sheet