Making a budget estimate

In a budget estimate you can show how much money is probably necessary to organise an event or make an improvement on something in the school.

In the budget estimate you try to estimate the expected cost of the project as realistically as possible. This will take some time, but it is very useful. In the end your costs should not be higher than your income. However, improving the atmosphere, more safety, etc. are also worth the cost! Make good use of Windows Excel when keeping track of your expenses.

The budget estimate is an overview that consist of your expected income and expected costs. Make sure that there is a clear structure and also think about which formulas should be in which cells.

Divide your form in a section for your income and a larger section that describes your expected costs.

Below there is an example of possible income and costs

Income:

o  Price per participant

o  Total amount of income

If you fill in the cells correctly, Excel will automatically calculate the total amount of income.

Costs:

First, try to get a clear overview of your total costs.

Costs can include several aspects:

o  transport;

o  meals;

o  entrance fees;

o  excursions;

o  insurance;

o  material costs;

stone

trash cans

thrash bags

o  loans;

10 hours

o  rent for machines/tools;

rent for an excavator

o  ……

Below this overview there will be several amounts that need to be calculated by Excel.

If you need help with your budget estimate you can always ask your economics or M&O-teacher for help. If you need help with Excel you can ask your questions to your informatics teacher.

Make sure your budget estimate is balanced. Also take into account that some costs might be higher than you expected.

GOOD LUCK!

©HavistenCompetent/bronnen/leerling/Verbeterpunt/Organisatietalent/begroting maken in Excel/2012