NGO
Another Way (Stichting Bakens Verzet), 1018 AM
01. E-course :
Diploma in Integrated Development (Dip. Int.Dev.)
Edition
01: 10 December, 2009
Study points
: 05 points out of 18
Minimum study
time : 125 hours out of 504
The study
points are awarded upon passing the consolidated exam for
Section C : The Model.
[Study points 03
out of 18]
[Minimum study time: 85 hours
out of 504]
The study points
are awarded upon passing the consolidated exam
for Section C : The Model.
Section 1 : Project costs.[40
hours]
01. General
introduction. (02 hours)
02. General sketch of the financial structures.(02
hours)
03. Short budget analysis. (02 hours)
04. Budget organisation. (02 hours)
05. Description of the local contributions. (02
hours)
06. Method for calculating local contributions.
(02 hours)
07. Relationship between local money and formal money.(02
hours)
08. The budget (02 hours)
09. The budget in a form requested by donors/financing
parties. (02 hours )
10. Annual expenses (budgets per year). (02
hours )
11. Quarterly budgets. (02 hours )
12. Excel spreadsheets for the preparation of the budget.(02
hours )
13. The sustainability of the system.(02 hours
)
14. Tenders. (02 hours )
15. The bank structures with limitations imposed on the
project coordinator.(02 hours )
16. Auditing structures. (02 hours)
17. Protection of donors and financing parties.(02
hours )
Section 1 report : (06 hours) .
Section
1 : Project costs.[40 hours]
12. Excel spreadsheets for the preparation of the budget.(
At least 02 hours )
In section 07.13
Excel spreadsheets for budget preparation
of the Model there is an Excel file called Excel budget file, which is here
represented in .htm form.
Open the file and study it carefully. The data given refers to the Vivons
Makalondi project in
The total project cost is € 5.000.000.
This means that the individual budget items are inclusive of the contributions made by the local
populations under the local money systems. For the purposes of the budget,
these contributions have been converted into Euro at the rate of €3 for each eight-hour working day.
This means that before
putting the amounts into the spreadsheet, both the formal money amounts and the
amounts resulting from the €3 a day conversion
for the work done by the populations have been added up. The two components
(the formal money and the converted amounts) are shown individually in the project budget, which can be
consulted if a breakdown between the two parts is needed..
1. Research.
Open the Excel file Excel budget file. Because it is .htm form the column letters are missing.
Working from the left hand column market in the letters from A to T at
the top of the column. We are looking for quarterly totals per sub-groups,
annual totals per sub-group, and annual totals per budget group, and project
totals. Individual per item figures are not required.
On one page make a vertical list
with the letters H,I,J,O,P,Q,R,S,T. These are the columns with the required
totals.
Next to each letter write its description.
For example :
H= the total for a given item over the first four quarters.
R= the total per sub-group for the full project period.
2. Research.
Open the Excel file Excel budget file. Because it is .htm
form the line numbers are missing.
Working from the top left hand
corner mark in all the line numbers
(including the empty lines)
On one page make a vertical list
of lines 17,18,23,24,28,29,30,37,38, 40,41,42 …….etc. We are looking for the lines with the quarterly totals per sub-group ,annual totals
per sub-group, annual totals per budget group, and total project totals.
Individual per item figures are not required.
Next to each line-number give the
description.
For example :
17= the costs per quarter of local personnel.
18= the annual costs of local personnel.
Choose the budget of a
project for which you are or have been responsible. Otherwise, choose the budget
of a project which is on-going, or which has been completed, in your project
area.
3. Research.
Following the example of the Excel budget file create an Excel file for the project you have chosen. The
amount at the extreme right, at the bottom, should represent the total for the
project in question.
4. Research.
Using the Graphics Wizard of he
Excel programme, print out :
a) A complete series of per quarter graphs for all activities together. [Select
a quarter, then make a graph showing the activities for the main activity
groups]
b) A complete series of graphs showing quarterly activities for each of
the main budget groups.[Select a main budget group, then make a graph showing
the quarterly activities for the group].
◄ Eighth block : Economic aspects.
◄ Eighth block : Project costs.
◄ Main
index for the Diploma in Integrated Development
(Dip. Int. Dev.)
"Money is not the key that opens the gates of the market but the
bolt that bars them."
Gesell, Silvio, The Natural Economic Order, revised English edition,
Peter Owen,
“Poverty is created scarcity”
Wahu Kaara, point 8 of the Global Call to Action Against Poverty, 58th
annual NGO Conference, United Nations,
This
work is licensed under a Creative Commons
Attribution-Non-commercial-Share Alike 3.0 Licence.