1. |
The project budget, as approved by the Projects' Board, remains unchanged and serves as basis for expenditure. |
2. |
The spreadsheet contains formulae in the grey cells. These cells are therefore closed and cannot be changed. |
3. |
Summarising information:
|
|
 |
Total expenditure: |
| |
Automatically calculated from monthly totals |
|
Fund additions: |
| |
Funds obtained during the course of the project as a result of change requests |
|
Project recovery: |
| |
Any income or profit generated by the project, e.g. through the presentation of courses |
|
Internal staff: |
| |
Until further notice, costs, calculated by means of an average rate, are indicated but not recovered from the project. |
|
Available: |
| |
The amount available once the actual expenditure has been deducted from the allocated amount, as well as
additional funds (fund allocation and project redemption). Regularly verify whether the amount next
to "Available" corresponds with the amount indicated on the central computer system. |
|
Columns for each month: |
| |
Budget |
- Budget as approved |
| |
Actuals |
- Actual monthly expenditure |
| |
Variance |
- Automatically calculated |
| |
NB: Specific amounts automatically add up to monthly totals |
|
4. |
Detailed information:
|
|
|
Under each area provision has been made for project-specific information, e.g. for specific capital expenditure. |
|
Each area has its own total which is automatically calculated as details on expenditure become available. |
|
Add transaction information, like the requisition number and a brief description, below the entries in the Actuals column (right-click on the entry > Insert Comment). This will make future references easier. |
|
NB! It is of crucial importance to work accurately and to update information regularly. |
|
NB! |
No positions may be created in the context of the project that cannot be paid from current operational funds!! |
|
 |
|
