Answered step by step
Verified Expert Solution
Question
1 Approved Answer
A CapsLk S Appendix A: Budget/Financial Plans for Bayside Call Centre 6 Month Budget Figures: Month January Budget January Actual February Budget February Actual
A CapsLk S Appendix A: Budget/Financial Plans for Bayside Call Centre 6 Month Budget Figures: Month January Budget January Actual February Budget February Actual March April April May May June June March Budget Budget Actual Budget Actual Budget Actual Actual INCOME 1,000,000.0 1,100,600.0 1,000,000.0 1,000,900.0 Total Sales 1,000,000.0 0 0 0 1,000,400.0 1,000,000.0 1,000,500.0 1,000,000.0 1,000,950.0 1,000,000.0 1,100,100.0 0 0 0 0 0 0 0 0 0 COGS (Cost of Goods Sold) Total COGS 400,000.00 Gross Profit 600,000.00 400,000.00 400,840.00 699,760.00 600,000.00 400,600.00 400,000.00 600,300.00 600,000.00 400,300.00 600,100.00 400,000.00 600,000.00 400,450.00 600,050.00 400,000.00 600,000.00 400,600.00 600,350.00 400,000.00 400,900.00 600,000.00 699,200.00 EXPENSES Bank charges & fees 2,500.00 Stationery 1,000.00 2,505.00 650.00 2,500.00 1,000.00 2,507.00 700.00 2,500.00 2,507.00 2,500.00 2,508.00 2,500.00 2,510.00 2,500.00 2,510.00 1,000.00 600.00 1,000.00 500.00 1,000.00 700.00 1,000.00 850.00 License/insurance fees 1,500.00 1,500.00 1,500.00 1,500.00 1,500.00 1,500.00 1,500.00 1,500.00 1,500.00 1,500.00 1,500.00 1,500.00 Advertising 0 0 0 0 0 0 0 0 0 0 0 0 Entertainment/Meals 3,000.00 4,500.00 3,000.00 2,500.00 3,000.00 2,300.00 3,000.00 2,000.00 3,000.00 2,500.00 3,000.00 3,000.00 Travel/Accommodation 2,000.00 0.00 2,000.00 0.00 2,000.00 0.00 2,000.00 0.00 2,000.00 0.00 2,000.00 0.00 Cleaning 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 2,000.00 Equipment lease 5,000.00 5,000.00 5,000.00 5,000.00 5,000.00 5,000.00 5,000.00 5,000.00 5,000.00 5,000.00 5,000.00 5,000.00 Motor Vehicle 3,000.00 2,500.00 3,000.00 3,300.00 Expenses 3,000.00 3,200.00 3,000.00 2,400.00 3,000.00 2,900.00 3,000.00 3,200.00 T 10,000.00 9,100.00 10,000.00 Salaries/Wages 300,000.00 300,600.00 300,000.00 PAYE 72,000.00 73,000.00 72,000.00 Superannuation 27,000.00 29,000.00 27,000.00 earning & 10,000.00 0.00 10,000.00 6,000.00 10,000.00 3,000.00 evelopment 10,000.00 10,200.00 10,000.00 10,000.00 9,700.00 10,000.00 301,100.00 300,000.00 300,000.00 300,600.00 300,000.00 300,600.00 72,000.00 73,000.00 73,000.00 72,000.00 72,000.00 73,000.00 27,000.00 29,000.00 27,000.00 27,000.00 31,000.00 29,000.00 10,000.00 10,000.00 10,000.00 10,500.00 10,000.00 10,500.00 300,000.00 302,000.00 72,000.00 73,000.00 27,000.00 32,000.00 304,000.00 73,000.00 33,000.00 10,000.00 12,000.00 14,000.00 ease/Outgoings 20,000.00 20,000.00 20,000.00 20,000.00 20,000.00 20,000.00 20,000.00 20,000.00 20,000.00 20,000.00 20,000.00 20,000.00 ilities 4,000.00 4,000.00 4,000.00 4,000.00 4,000.00 4,000.00 4,000.00 4,000.00 4,000.00 4,000.00 4,000.00 4,000.00 epair & maintenance 2,000.00 2,000.00 ST 46,500.00 tal Expenses 511,500.00 t Profit / (Loss) 88,500.00 600.00 46,500.00 47,700.00 508,107.00 511,500.00 502,655.00 92,193.00 88,500.00 197,105.00 1,500.00 2,000.00 1,100.00 2,000.00 2,100.00 2,000.00 900.00 2,000.00 2,400.00 46,800.00 46,500.00 43,500.00 46,500.00 43,100.00 46,500.00 44,000.00 46,500.00 44,000.00 511,500.00 88,500.00 501,307.00 98,793.00 511,500.00 510,408.00 88,500.00 511,500.00 89,642.00 88,500.00 515,510.00 511,500.00 522,960.00 84,840.00 88,500.00 176,240.00 BSBFIM501 Student Assessment V3.0 March 2020 Page 11 of 17 Tab O Cash Flow Projections Jun May Jul Jan Feb Mar Apr Aug Sep Oct Nov Dec 12 Month Cash Flow Projections Cash In Sales 1,000,000.00 1,000,000.00 1,000,000.00 1,000,000.00 1,000,000.00 1,000,000.00 1,000,000.00 1,000,000.00 1,000,000.00 1,000,000.00 1,000,000.00 1,000,000.00 Cash Out COGS 400,000.00 400,000.00 Expenses 465,000.00 465,000.00 400,000.00 465,000.00 400,000.00 400,000.00 465,000.00 465.000.00 400,000.00 400,000.00 400,000.00 400,000.00 465,000.00 465,000.00 465,000.00 465,000.00 400,000.00 400,000.00 465,000.00 465,000.00 400,000.00 465,000.00 Net Cash 135,000.00 135,000.00 135,000.00 135,000.00 135,000.00 135,000.00 135,000.00 135,000.00 135,000.00 135,000.00 135,000.00 135,000.00 Opening Balance Closing Balance 135,000.00 270,000.00 405,000.00 135,000.00 270,000.00 405,000.00 540,000.00 540,000.00 675,000.00 810,000.00 675,000.00 810,000.00 945,000.00 1,080,000.00 1,215,000.00 1,350,000.00 1,485,000.00 945,000.00 1,080,000.00 1,215,000.00 1,350,000.00 1,485,000.00 1,620,000.0 Departmental Responsibilities Human Resources Manager Salaries $300,000.00 per month Learning and Development $10,000.00 per month Call Centre Manager Sales per month $1,000,000.00 COGS per month $400,000.00 IT Manager IT Expenses $10,000.00 per month + 12 Months Cash Flow Results S Current Year Cash Flow Q1 Budget Q1 Actual Q2 Budget Q2 Actual Q3 Budget Q3 Actual Q4 Budget Q4 Actual Cash In Sales 3,000,000.00 3,000,000.00 3,000,000.00 3,000,000.00 3,000,000.00 2,700,000.00 3,000,000.00 2,700,000.00 Cash Out COGS 1,200,000.00 Expenses 1,395,000.00 1,200,000.00 1,365,000.00 1,200,000.00 1,395,000.00 1,200,000.00 1,365,000.00 1,200,000.00 1,395,000.00 1,080,000.00 1,421,850.00 1,200,000.00 1,080,000.00 1,395,000.00 1,321,850.00 Net Cash 405,000.00 435,000.00 405,000.00 435,000.00 405,000.00 198,150.00 405,000.00 298,150.00 Opening Balance Closing Balance 405,000.00 435,000.00 405,000.00 810,000.00 435,000.00 810,000.00 870,000.00 1,215,000.00 870,000.00 1,215,000.00 1,068,150.00 1,068,150.00 1,620,000.00 1,366,300.00
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started