A CapsLk S Appendix A: Budget/Financial Plans for Bayside Call Centre 6 Month Budget Figures: Month...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 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
Expert Answer:
Related Book For
Financial Management Principles and Applications
ISBN: 978-0133423822
12th edition
Authors: Sheridan Titman, Arthur Keown, John Martin
Posted Date:
Students also viewed these finance questions
-
Two companies, Energen and Hastings Corporation, began operations with identical balance sheets. A year later, both required additional manufacturing capacity at a cost of $50,000. Energen obtained a...
-
The spot rate between the U.S. dollar and the New Zealand dollar is $1 = NZD1.1867. If the interest rate in the United States is 5 percent and in New Zealand is four percent, then what should be the...
-
How are balance sheet quality and earnings quality related? Provide a specific example of a management judgment, estimate, or choice that could decrease both balance sheet and earnings quality. Be...
-
Lawn RX, Inc. prepares a variable costing income statement for internal management and an absorption costing income statement for its bank. Lawn RX provides a quarterly lawn care service that is sold...
-
Sunburn Sunscreen has a zero coupon bond issue outstanding with a $25,000 face value that matures in one year. The current market value of the firms assets is $26,300. The standard deviation of the...
-
Bramble Corporation leases equipment from Falls Company on January 1, 2025. The lease agreement does not transfer ownership. contain a bargain purchase option, and is not a specialized asset. It...
-
A company in South Korea makes bicycle wheels. They make 10,000 per day with the following resources: Labour: 600 hours per day at $6.50 per hour Raw Material: 1,000 kilograms of rubber per day at $1...
-
A set S R^n is convex if for all x, y S and t [0, 1], we have (1 t)x + t y S (in other words, if S contains the points x and y, it contains the entire line segment between them). (a) If W R^n is a...
-
Looking for some guidance, Produce a summary of this segment of the conclusive article and submit it by Thursday to allow time for feedback to/from peers. You will be rated on your workshop...
-
What is the public's general expectation on program implementation?
-
The density of a fluid changes with depth from the surface h according to the following formula: (h) = ch 2 , where c is a constant. A. What an expression for the gauge pressure p as a function of...
-
Instructions Your next blog post should be titled "Teamwork". With reference to one or more of your experience working in a team and reference to theory: Consider the benefits of team working Explain...
-
Ms. Sabeena owns 2 furnished houses, both houses are let out for residential purposes. The details of each residential property for the tax year 1/10/2019 are as follows: a). You are required to...
-
Prove the result that the R 2 associated with a restricted least squares estimator is never larger than that associated with the unrestricted least squares estimator. Conclude that imposing...
Study smarter with the SolutionInn App