Question

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
The answer must include the following information: Income Total Income Expenditure Total Expenditure Profit

Answer 1

Income
Sales Revenue
1 season x 30 weeks x 14 hours x $120	$        50,400
Membership fees
500 members x $150	$        75,000
Total Income	$     125,400
Expenditure:
Newspaper advertising
4 adverts x 2 column x 8 lines x $3	$              192
Canteen attendant
30 weeks x 25 hours x $30	$        22,500
Referee Fees
30 weeks x 30 matches x $100	$        90,000
Cost of floodlights
30 weeks x 18 hrs x 50 globe x 500w x $0.20/1000	$          2,700
Gamefees
30 weeks x 30 matches x 14 players x $6	$        75,600
Pitch mowing
30 weeks x 1 mows x 6 hrs x ($25+$3.5)	$          5,130
Team apparel cost
300 players x ($20+15+6)	$        12,300
Administrative
($1200+200+300+1200)	$          2,900
Cleaning
30 weeks x 10 hrs x $22	$          6,600
Balls, flags and whistles
30 weeks x $250	$          7,500
Total expenditures	$     225,422
Net loss	$   (100,022)