Part 2 Create a Budget (30 marks)

1.As the Administration Department Team Leader, you are responsible for compiling your departments budget each year.

Your department has 5 members of staff.

You are given R500 000.00 to run your department.

Create a monthly budget using Microsoft Excel.

Your budget must be detailed and include the following items.

Stationary

Training and Skills Development

Team Building Events Printing

Computer Software Coffee and Tea

Office Hygiene

Maintenance and Repairs