[okfn-za] Cape Town budget for dummies
Fritz Jooste
fritz at nu.org.za
Sat May 4 23:40:32 UTC 2013
Hi Rufus
Sincere apologies for the slow reply, things have been a bit manic.
I've put together a chart with some of the most useful information in the
budget broken down into different levels and indicating which table each
bit of information is from (attached). I've also shown this in text at the
end of this email.
Looking at the table you shared, there might be value in using the budget
information for particular departments (referred to as *Votes *in the
budget). For instance, Table 69 shows revenue and expenditure for the
Safety & Security directorate. In that case, the information could perhaps
be entered like this:
Item: employee-related costs
Category: operating budget
Subcategory: expenditure by type
Department: safety & security
Year: 2013/14
Amount: 1254457
This information should be entered for each 14 departments/'votes'. Could
this work?
Best
Fritz
*City of Cape Town Draft Budget*
- *Capital budget*
- *Expenditure*
- *By vote*
- *Vote 1: City Health*
- *Vote 2: City Manager *
- *Vote 3: Community Service *
- *Vote 4: Corporate Services*
- *Vote 5: Deputy City Manager *
- *Vote 6: Economic, Environment & Spatial Planning*
- *Vote 7: Finance *
- *Vote 8: Human Settlements *
- *Vote 9: Rates & Other*
- *Vote 10: Safety & Security*
- *Vote 11: Social and Early Childhood Development*
- *Vote 12: Tourism, Events & Marketing*
- *Vote 13: Transport, Events and Marketing *
- *Vote 14: Utility Services *
- *By standard classification*
- *Governance and administration*
- *Executve and council*
- *Budget and treasury office*
- *Corporate services*
- *Community and public safety*
- *Community and social services*
- *Sport and recreation*
- *Public safety*
- *Housing*
- *Health*
- *Economic and environmental services*
- *Planning and development*
- *Road transport*
- *Environmental protection*
- *Trading services*
- *Electricity*
- *Water*
- *Waste water management*
- *Waste management*
- *Other*
- *Funding*
- *By source*
- *Transfers recognised - capital*
- *National government*
- *Provincial government*
- *Other transfers and grants*
- *Public contributions & donations *
- *Borrowing*
- *Internally generated funds*
- *Operating budget *
- *Revenue*
- *By source*
- *Property rates tax*
- *Property rates tax*
- *Penalties & collection charges*
- *Service charges*
- *Service charges - electricity*
- *Service charges - water*
- *Services charges - sanitation*
- *Service charges - refuse*
- *Service charges - other*
- *Rental of facilities and equipment*
- *Interest earned*
- *External investments*
- *Outstanding debtors*
- *Fines*
- *Licences and permits*
- *Agency Services*
- *Transfers Recognised - Operational*
- *National government*
- *Provincial government*
- *Other grant providers*
- *Other revenue*
- *Gains on Disposal of PPE*
- *Expenditure*
- *By type*
- *Employee related costs *
- *Remuneration of councillors *
- *Debt impairment *
- *Depreciation & asset impairment*
- *Finance charges *
- *Bulk purchases *
- *Other materials*
- *Contracted services *
- *Transfers*
- *Other Expenditure*
- *Loss on disposal of PPE*
- *By vote*
- *Vote 1: City Health*
- *Vote 2: City Manager *
- *Vote 3: Community Service *
- *Vote 4: Corporate Services*
- *Vote 5: Deputy City Manager *
- *Vote 6: Economic, Environment & Spatial Planning*
- *Vote 7: Finance *
- *Vote 8: Human Settlements *
- *Vote 9: Rates & Other*
- *Vote 10: Safety & Security*
- *Vote 11: Social and Early Childhood Development*
- *Vote 12: Tourism, Events & Marketing*
- *Vote 13: Transport, Events and Marketing *
- *Vote 14: Utility Services *
- *By standard classification*
- *Governance and administration*
- *Executve and council*
- *Budget and treasury office*
- *Corporate services*
- *Community and public safety*
- *Community and social services*
- *Sport and recreation*
- *Public safety*
- *Housing*
- *Health*
- *Economic and environmental services*
- *Planning and development*
- *Road transport*
- *Environmental protection*
- *Trading services*
- *Electricity*
- *Water*
- *Waste water management*
- *Waste management*
- *Other*
On 30 April 2013 12:59, Rufus Pollock <rufus.pollock at okfn.org> wrote:
> Hi Fritz and Thoko,
>
> Just wanted to follow up here. Having been looking through the spreadsheet<https://docs.google.com/a/okfn.org/spreadsheet/ccc?key=0AqR8dXc6Ji4JdDM4LWtFWVFLTWZ4ZDdNZHNzY1NmUmc&hl=en#gid=0> it
> seems that Table 1 may be the best (if there were a way to merge other
> tables I could perhaps get richer info).
>
> @Fritz: would you have any tips here.
>
> Regards,
>
> Rufus
>
>
> On 22 April 2013 13:01, Rufus Pollock <rufus.pollock at okfn.org> wrote:
> > Dear Fritz (cc'ing the Open Knowledge Foundation South Africa mailing
> list),
> >
> > This is brilliant. I've google-doc'd it here:
> >
> >
> https://docs.google.com/a/okfn.org/spreadsheet/ccc?key=0AqR8dXc6Ji4JdDM4LWtFWVFLTWZ4ZDdNZHNzY1NmUmc&hl=en#gid=0
> >
> > As the document is quite large with a lot of tables I wondered if you
> > had any tips on how to get the best (most disaggregated) set of
> > expenditure (or revenue info) out in a consolidated table.
> >
> > To illustrate what I had in mind I've creating a separate example
> > sheet with headings:
> >
> >
> https://docs.google.com/a/okfn.org/spreadsheet/ccc?key=0AqR8dXc6Ji4JdDM4LWtFWVFLTWZ4ZDdNZHNzY1NmUmc&hl=en#gid=1
> >
> > This is what would be perfect for loading into http://openspending.org/!
> >
> > Rufus
> >
> > On 20 April 2013 18:26, Fritz Jooste <fritz at nu.org.za> wrote:
> >> Hi Rufus and Thoko
> >>
> >> I've attached the Excel file I used for the document. It the output
> from a
> >> PDF to XLS conversion program I used on the budget document from the
> City of
> >> Cape Town website. It's not the cleanest data, but with some editing and
> >> tweaking should be usable.
> >>
> >> The more people can meaningfully engage with the budget, the better!
> >>
> >> All the best
> >> Fritz
> >>
> >>
> >>
> >> On 20 April 2013 16:22, Thoko Madonko <thoko.madonko at gmail.com> wrote:
> >>>
> >>> Dear Fritz
> >>>
> >>> See the request below from Rufus Pollock. It would be great to get Cape
> >>> Town included.
> >>>
> >>> Let me know if I can help.
> >>>
> >>> regards
> >>> Thoko
> >>>
> >>>
> >>> ---------- Forwarded message ----------
> >>> From: Rufus Pollock <rufus.pollock at okfn.org>
> >>> Date: 19 April 2013 18:43
> >>> Subject: Re: [okfn-za] Cape Town budget for dummies
> >>> To: Adi Eyal <adi at burgercom.co.za>
> >>> Cc: "okfn-za at lists.okfn.org" <okfn-za at lists.okfn.org>
> >>>
> >>>
> >>> http://nu.org.za/analysis-city-of-cape-town-201314-draft-budget/ -
> very
> >>> nice!
> >>>
> >>> Is there any way to get the underlying data in excel / CSV? It would
> then
> >>> be 2s to get this into http://openspending.org/ and have a first South
> >>> African city on http://apps.openspending.org/maps/!
> >>>
> >>> Rufus
> >>>
> >>>
> >>> On 18 April 2013 17:47, Adi Eyal <adi at burgercom.co.za> wrote:
> >>>>
> >>>> Hi All
> >>>>
> >>>> Check out @fritzjooste of Ndifuna Ukwazi and his visualisation of the
> >>>> draft Cape Town city budget. He's turned a spreadsheet into a story.
> I can't
> >>>> think of a more apt use of visualisation for simplifying data.
> >>>>
> >>>> Adi
> >>>>
> >>>> --
> >>>> Adi Eyal
> >>>> Data Specialist
> >>>> phone: +27 78 014 2469
> >>>> skype: adieyalcas
> >>>> linkedin: http://za.linkedin.com/pub/dir/Adi/Eyal
> >>>>
> >>>>
> >>>> _______________________________________________
> >>>> okfn-za mailing list
> >>>> okfn-za at lists.okfn.org
> >>>> http://lists.okfn.org/mailman/listinfo/okfn-za
> >>>> Unsubscribe: http://lists.okfn.org/mailman/options/okfn-za
> >>>>
> >>>
> >>>
> >>> _______________________________________________
> >>> okfn-za mailing list
> >>> okfn-za at lists.okfn.org
> >>> http://lists.okfn.org/mailman/listinfo/okfn-za
> >>> Unsubscribe: http://lists.okfn.org/mailman/options/okfn-za
> >>>
> >>>
> >>
> >>
> >>
> >> --
> >> Fritz Jooste
> >> RESEARCHER
> >>
> >> Ndifuna Ukwazi (Dare to Know)
> >>
> >> Tel: +27 (0) 21 423 9593/3089
> >> Fax: +27 (0) 21 423 7554
> >> Cell: +27 (0) 82 512 5496
> >>
> >> Office 203, 47 on Strand,
> >> Cape Town, 8001
> >>
> >> http://www.nu.org.za
>
>
--
Fritz Jooste
*RESEARCHER*
*
Ndifuna Ukwazi (Dare to Know)*
Tel: +27 (0) 21 423 9593/3089
Fax: +27 (0) 21 423 7554
Cell: +27 (0) 82 512 5496
Office 203, 47 on Strand,
Cape Town, 8001
http://www.nu.org.za
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/okfn-za/attachments/20130505/8d76e5dd/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: City of Cape Town budget structure.png
Type: image/png
Size: 244974 bytes
Desc: not available
URL: <http://lists.okfn.org/pipermail/okfn-za/attachments/20130505/8d76e5dd/attachment-0003.png>
More information about the okfn-za
mailing list