Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Management Principles and Applications

Authors: Sheridan Titman, Arthur Keown, John Martin

12th edition

133423824, 978-0133423822

More Books

Students also viewed these Finance questions

Question

What is the difference between design and innovation? LO-1

Answered: 1 week ago

Question

In what research projects are your students currently involved?

Answered: 1 week ago