Budgeting Performance of Big Red Bicycle Pty Ltd

BSBFIM501 Manage budgets and financial plans
Project Report: Assessment No. 2

BSBFIM501 Manage budgets and financial plans
Task A:
CAPEX budget:
Big Red Bicycle Pty Ltd
CAPEX Budget FY 2011-12
FY Q1 Q2 Q3 Q4
CAPEX
PPE 16,350 500,000
Building 654,000 654,000
Sales Budget:
Big Red Bicycle Pty Ltd
Sales Budget
FY Q1 Q2 Q3 Q4
REVENUE
Sales 2,480,000 560,000 800,000 560,000 560,000
Expenses budget:
Big Red Bicycle Pty Ltd
Expenses Budget FY 2011-12
FY Q1 Q2 Q3 Q4
EXPENSES
General & Administrative
Expenses
Accounting fees 15,000 5,000 5,000 5,000 5,000

BSBFIM501 Manage budgets and financial plans
Legal fees 5,000 1,250 1,250 1,250 1,250
Bank charges 600 150 150 150 150
Office supplies 5,000 1,250 1,250 1,250 1,250
Postage &
printing
400 100 100 100 100
Dues &
subscriptions
500 125 125 125 125
Telephone 10,000 2,500 2,500 2,500 2,500
Repairs &
maintenance
25,000 12,500 12,500 12,500 12,500
Payroll tax 10,000 6,250 6,250 6,250 6,250
Marketing Expenses
Advertising 100,000 25,000 25,000 25,000 25,004
Employment Expenses
Superannuation 37,200 9,300 9,300 9,300 9,300
Wages &
salaries
200,000 50,000 50,000 50,000 50,000
Staff amenities 20,000 5,000 5,000 5,000 5,000
Occupancy Costs
Electricity 17,567 4,392 4,392 4,392 4,391
Insurance 50,000 12,500 12,500 12,500 12,499
Rates 50,000 12,500 12,500 12,500 12,499
Rent 90,000 22,500 22,500 22,500 22,500
Water 15,000 3,750 3,750 3,750 3,750
Waste removal 35,000 8,750 8,750 8,750 8,749
TOTAL EXPENSES 686,267 182,817 182,817 182,817 182,817
Cash budget:
Big Red Bicycle Pty Ltd
Cash flow Budget FY 2011-12
FY Q1 Q2 Q3 Q4
Cash inflow
Sales 2,480,00
0
560,00
0
800,00
0
560,00
0
560,00
0
Total cash inflow 2,480,00
0
560,00
0
800,00
0
560,00
0
560,00
0