Based on the information provided below, estimate the income and expenditure and prepare a basic budget in the template provided.

The Melbourne Football Club and the recreational centre has the following income and expenditure. Identify each item as income or expenditure and fill in the template provided to get total income and expenditure for the year. Assume one (1) season of the game per year.

Sales:

The number of opening hours per week: 14

The average sales per hour: $120

Number of open weeks per season: 30

Newspaper advertising:

Width of advert: 2 columns

Number of lines per columns: 8

Cost per line (per single column): $3

Number of adverts: 4

Canteen Attendant:

Wage rate per hour: $30.00

Number of hours worked per week: 25

Weeks per year: 30

Referee fees:

Wage rate per game: $100

Total matches per week (all teams): 30

Number of weeks in the season: 30

Cost of Floodlights:

Watts per globe: 500W

Number of globes: 50

Hours of use: 18 hrs. per week

Number of weeks in the season: 30

Cost per kilowatt-hour: $0.20

Note: 1 Kilowatt = 1000 watts

Game Fees:

Game fee per player: $6

Total matches per week (all teams): 30

The average number of players in a team: 14

Number of weeks in the season: 30

Pitch Mowing:

Hours to mow whole of fields: 6

Number of mows per week: 1

Number of weeks in the season: 30

Wage rate per hour: $25

Fuel cost per hour: $3.5

Team Apparel Cost:

Cost per shirt: $20

Cost per shorts: $15

Cost per socks (pair): $6

Number of players: 300

Administrative (Yearly):

Management software cost: $1200

Computer expenses: $200

Telephone and postage: $300

Water uses: $1200

Cleaning:

The number of hours per week: 10

Wage rate per hour: $22

Weeks per year: 30

Membership Fees:

Number of members: 500

Yearly fee per member: $150

Balls, flags and whistles:

Balls, flags and whistles per week: $250

Number of weeks in the season: 30

Income

Total Income

Expenditure

Total Expenditure

Profit