Question: Based on the information provided below, estimate your income and expenses and prepare a basic budget on the template provided. The Melbourne Football Club and

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

The Melbourne Football Club and Recreation Center have the following income and expenses. Identify each item as income or expense and complete the template provided to get the total income and expenses for the year. Assume one (1) game season per year.

Sales:

The number of opening hours per week: 14

Average sales per hour: $120

Number of weeks open per season: 30

Newspaper advertising:

Ad width: 2 columns

Number of lines per columns: 8

Cost per line (per column): $3

Number of ads: 4

Dining attendant:

Hourly wage rate: $30.00

Number of hours worked per week: 25

Weeks per year: 30

Referee Fees:

Salary rate per game: $100

Total games per week (all teams): 30

Number of weeks in the season: 30

Reflectors cost:

Watts per globe: 500W

Number of balloons: 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 games per week (all teams): 30

Average number of players on a team: 14

Number of weeks in the season: 30

Mowing field:

Hours to mow full fields: 6

Number of cuts per week: 1

Number of weeks in the season: 30

Hourly wage rate: $25

Fuel cost per hour: $3.5

Team clothing cost:

Cost per shirt: $20

Cost per pants: $15

Cost per socks (pair): $6

Number of players: 300

Administrative (Annual):

Management software cost: $1200

Computer expenses: $200

Telephone and mail: $300

Water uses: $1200

Cleaning:

The number of hours per week: 10

Hourly wage rate: $22

Weeks per year: 30

Membership fees:

Number of members: 500

Annual dues per member: $150

Balls, flags and whistles:

Balls, flags and whistles per week: $250

Number of weeks in the season: 30

Step by Step Solution

3.37 Rating (144 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!