Budgeting Cash Flow Chart

[WarblerOn]

We have to write a budget cash flow chart on excel as part of our assignment for financing and budgeting with managing a community service.

Based on our organisational chart that we have done according to a centre our teacher has provided us with to work on, we have to now create a budget cash flow chart, following the headings of the sample cash flow chart she has given us.

In this sample, she has in a table the number of days in month, Income - fees from families, income - CCB, Total income, and then it goes on to Expenses, Accountant's fees, Advertising, Consumables (costs) etc

I am unsure where this sample cash flow chart gets the figures for the "Income - fees from families" e.g. for example in January the fees from families is $390

To my understanding the CCB costs is how much you charge the families, per how many days in the month and how many children is in the service. Can someone please explain the Income fees from families?

[Lorina]

CCB changes depending on each families circumstances. For example, their yearly salary, the amount of children in care they have, how many hours their child are in care etc. It's not up to the centre to work it out... The Government (Centrelink) usually handles it and then depending how each familiy is recieving CCB it is deducted from the fees. Here is some more information on it:

CCB

For your income, you need to calculate how many families you have during the week and how many days the children come. So Family A could come 3 days per week, Family B 5 days per week and Family C 2 days per week. If you are calculating for an LDC you also need to think about the full day rates. A baby in the nursery would be charges more than a preschooler... Then I guess once you worked this out, you can try and figure out the CCB. See it's pretty complicated!!

Probably best to do a small centre with 10-20 children per week... Or an FDC...

Hope this helps,

,
Lorina