Software for Volunteer Treasurers

Create an Employment Budget

Budgeting Exercise 8

Download budgeting exercise 08In this exercise provides you are provided with ready-to-go formatted spreadsheets and instructions on how to complete this exercise on preparing an employment budget.

Employment is perhaps the largest cost in most businesses. Therefore developing an employment budget and being able to accurately predict employment costs is a fundamentally important aspect of business planning.

This exercise introduces a number of terms associated with employment and the remuneration of workers e.g. superannuation. The following link will provide some assistance with regard to these terms:

http://www.leoisaac.com/fin/fin048.htm

It is recommended that you utilise spreadsheet software such as Microsoft Excel to undertake this exercise. Microsoft Excel is the tool of choice for most people responsible for preparing budgets. But if you do not have spreadsheet software you can simply use the tables on the exercise sheet to insert your answers worked out with a calculator.

Download the task sheet for Budgeting Exercise 8: Employment Budget

Download the accompanying Excel work book file for Budgeting Exercise 8

 

Online higher education
help with Excel
answers to budgeting exercises