BSBFIM501 - Manage Budgets & Financial Plans: Big Red Bicycle Project

This document presents a comprehensive project report focusing on the financial planning and budgeting for 'Big Red Bicycle Pty Ltd.' It includes a variance report, CAPEX budget for FY 2012-13, sales evaluation, sales budget, expenses budget, master budget, and cash flow budget. The report covers revenue projections, cost of goods sold, gross profit analysis, and detailed expense breakdowns across various categories such as general & administrative, marketing, employment, and occupancy costs. The cash flow budget outlines cash inflows from sales and outflows related to commissions, direct wages, cost of goods sold, and various operational expenses. Desklib provides a platform for students to access similar solved assignments and past papers to aid in their studies.

Australian Ideal College
RTO No.: 91679 CRICOS Provider Code: 03053G ABN: 15 126 592 756
Sydney Campus: Level 7 & 8, 75 King St, Sydney NSW 2000 Australia
Tel: [phone] Fax: [phone]Educating for Excellence
Project Report: Assessment No. 3

Australian Ideal College
RTO No.: 91679 CRICOS Provider Code: 03053G ABN: 15 126 592 756
Sydney Campus: Level 7 & 8, 75 King St, Sydney NSW 2000 Australia
Tel: [phone] Fax: [phone]Educating for Excellence
Task A:
Variance report:
See the attached spreadsheet
Task B
Big Red Bicycle Pty Ltd
CAPEX Budget FY 2012-13
FY Q1 Q2 Q3 Q4
CAPEX
PPE 16,350 500,000
Building 654,000 654,000
Big Red Bicycle Pty Ltd
Sales evaluation FY 2012-13
FY Q1 Q2 Q3 Q4
REVENUE
Commissions
(2.5% sales)
77,500 17,500 25,000 17,500 17,500
Sales 3,100,000 700,000 1,000,000 700,000 700,000
Big Red Bicycle Pty Ltd
Sales Budget
FY Q1 Q2 Q3 Q4
REVENUE

Australian Ideal College
RTO No.: 91679 CRICOS Provider Code: 03053G ABN: 15 126 592 756
Sydney Campus: Level 7 & 8, 75 King St, Sydney NSW 2000 Australia
Tel: [phone] Fax: [phone]Educating for Excellence
Sales 2,480,000 560,000 800,000 560,000 560,000
Big Red Bicycle Pty Ltd
Expenses Budget FY 2012-13
FY Q1 Q2 Q3 Q4
EXPENSES
General & Administrative
Expenses
Accounting fees 15,000 5,000 5,000 5,000 5,000
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

Australian Ideal College
RTO No.: 91679 CRICOS Provider Code: 03053G ABN: 15 126 592 756
Sydney Campus: Level 7 & 8, 75 King St, Sydney NSW 2000 Australia
Tel: [phone] Fax: [phone]Educating for Excellence
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
Big Red Bicycle Pty Ltd
Master Budget FY 2012-13
FY Q1 Q2 Q3 Q4
REVENUE
Commissions (2.5%
sales)
62,000 14,000 20,000 14,000 14,000
Direct wages fixed 200,000 50,000 50,000 50,000 50,000
Sales 2,480,00
0
560,00
0
800,00
0
560,00
0
560,00
0
Cost of Goods Sold 198,400 44,800 64,000 44,800 44,800
Gross Profit 2,019,60
0
451,20
0
666,00
0
451,20
0
451,20
0
EXPENSES
General & Administrative Expenses
Accounting fees 15,000 5,000 5,000 5,000 5,000
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

Australian Ideal College
RTO No.: 91679 CRICOS Provider Code: 03053G ABN: 15 126 592 756
Sydney Campus: Level 7 & 8, 75 King St, Sydney NSW 2000 Australia
Tel: [phone] Fax: [phone]Educating for Excellence
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,81
7
182,81
7
182,81
7
182,81
7
NET PROFIT (BEFORE INTEREST
& TAX)
1,333,33
3
268,38
3
483,18
3
268,38
3
268,38
3
Income Tax Expense (25%Net) 333,333 67,096 120,79
6
67,096 67,096
NET PROFIT AFTER TAX 1,000,00
0
201,28
7
362,38
7
201,28
7
201,28
7
Big Red Bicycle Pty Ltd
Cash flow Budget FY 2012-13
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
Cash Outflow
Commissions (2.5%
sales)
62,000 14,000 20,000 14,000 14,000
Direct wages fixed 200,000 50,000 50,000 50,000 50,000
Cost of Goods Sold 198,400 44,800 64,000 44,800 44,800
PPE 16,350 500,00
0
Building 654,000 654,00

Australian Ideal College
RTO No.: 91679 CRICOS Provider Code: 03053G ABN: 15 126 592 756
Sydney Campus: Level 7 & 8, 75 King St, Sydney NSW 2000 Australia
Tel: [phone] Fax: [phone]Educating for Excellence
0
Accounting fees 15,000 5,000 5,000 5,000 5,000
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
Advertising 100,000 25,000 25,000 25,000 25,004
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
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 cash outflow 1,817,01
7
291,61
7
816,81
7
945,61
7
291,61
7
Net cash
flow 662,983
268,38
3 -16,817
-
385,61
7
268,38
3

Australian Ideal College
RTO No.: 91679 CRICOS Provider Code: 03053G ABN: 15 126 592 756
Sydney Campus: Level 7 & 8, 75 King St, Sydney NSW 2000 Australia
Tel: [phone] Fax: [phone]Educating for Excellence