Budgeting And Financial Management: Questions And Answers

Questions:

Major objectives of budget include providing a roadmap for the organization and its employees, managing resources of the organization effectively, making optimum utilization of resources, achieve organizational objectives etc.
Cash budget helps in handling cash resources of an organization. Revenue budget is prepared with the objective of maximizing revenue and expenditures budget helps in minimizing the amount of expenditures.

Item	Category	Financial Statement	Objective Save Time On Research and Writing Hire a Pro to Write You a 100% Plagiarism-Free Paper. Get My Paper
Sale of retail clothes by EFTPOS	Revenue	Financial performance	Report Revenue
Investment in five year project	Capital	Financial position	Capital
Replace chair in client waiting room	Expenditure	Financial performance	Manage expenditure
Periodic transfers between bank accounts	Cash	Financial position	Cash
Sale of office building	Capital	Financial position	Capital
Community service fees	Revenue	Financial performance	Report revenue

The master budget is prepared keeping in mind the organizational goals. Thus, the master budget is one of the tools in the hands of the management to outline the organizational objectives to its stakeholders.
The procurement budget affects the raw materials budget as the cost of procurement to a large extent determine the cost of raw materials.

Growth in sales means that the requirement of raw materials for production would also be higher hence, the raw material costs will increase with the increase in expected sales.

Growth in sales will positively influence the financial performance of an organization however, it is important that the organization has required capacity to achieve the targeted sales. Costs in all departments must not exceed beyond the desired level in order to improve the overall financial performance (Bryson, 2018).

In that case it would better to replace the disability manager immediately with come one who understands the objectives and requirements of the organization better.
AASB 101 is the relevant standard for presentation of financial statements including budgets.
Shareholders: The shareholders are mainly concerned with the financial performance and potion of the company.

Representative of Financial institutions: Liquidity and solvency position of the company are main concerns of the group.

Creditors: Short term liquidity position of the company concerns the group.

Sales forecast spreadsheet helps in identifying the expected level of sales at different periods in the future. This will help in calculating the expected profit at these points to identify the milestone profit in a period.
Budgets shows the expected future outcome of an organization. Management can inspire the employees by showing the possible effects of improvement in performance of the organization on the employees’ salaries and benefits.
Graph shows the forecasting sales, revenue, expenditures, profits and other items in simple picturesque forms. This helps in understanding the expected future performance of an organization very easily (Chenhall & Moers, 2015).
1. GST is transferred to cash budget.
2. At the end of the period in expenditures budget.
The expected cash inflows and cash outflows of an organization from operating, investing and financing activities.
1. To make effective use of cash resources.
2. For cash management.
3. To have a better liquidity position.
The departmental heads are legally responsible to supervise the departmental budgets with the manager responsible to supervise the master budget.
It is important to consider the long term impact of expansion plan on the future of an organization. All related expenditures shall be considered in order to ensure that the organization is fully aware of the expected impact of such expansion decision in the future. Aggressive revenue expansion plan requires huge amount of investment and expenditures thus, the management must evaluate the expected benefits from the expansion plan before taking any final decision in respect to the expansion strategy. Expenses control mechanisms should also be used to reduce the expenditures to the maximum extent possible.
The cash flow budget is used as a guide while disbursing cash for different items however, often the cash disbursement might be different from the budget. The management must use the cash flow budget as a guide while disbursing cash. Closing cash balance is calculated after adding all cash receipts and deducting the aggregate amount of cash disbursements from the cash receipts. The net cash inflow or outflow as the cash may be shall be added to the opening cash balance to calculate the closing cash balance.
Timesheets will help an accountant to complete different elements of accounting and financial reporting on time to complete annual reporting on time.
Budget information submitted to the department managers as per the schedule dates which are stored in a budget calendar (Sayles, 2017).
The trends from budget is identified and showed to the management. On the basis of such trends management decides the future course of action.
1. Technical evaluation.
2. Financial evaluation and
3. Operational evaluation.
The significance of revenue assumption will be properly assessed after evaluating the practical implications of such assumption. If it is true that the revenue will increase without any expenditure then the management should certainly expand its operations in new sales region.

The junior accountant should consider the expected increase in sales to prepare the sales forecast.

It is quite unusual to belief that the expansion of operations in different sales region will not increase the expenditures of the company.
A management should first complete the evolution process of a project on the basis of technical, financial and operational feasibility of the project. After that use of investment appraisal techniques such net present value method, internal rate of return method and others shall be used to evaluate the expected outcome of the project in the future.

Particulars	Budgeted	Actual	Variance	Percentages
New food expenses	900.00	2,700.00	(1,800.00)	(200.00)
Food for the month	100.00	300.00	(200.00)	(200.00)

The variances are unfavourable.

Discoverer: Community Services Organization
Management Assumption and Control worksheet

Request for assumption revision/financial control use	Budget name
Account	Food	Expense budget
Details
Assumption/ recommended control	The budgeted amount of $900 has exceed by significant margin of $1,800. Thus, it is important to provide for the additional expenditures in the budget. The initial assumptions were incorrect.
Authorise and sign by	Student name
Date:	19 October. 2018

The budget should be reviewed frequently in order to ensure that the necessary adjustments are made to adjust the budgeted amounts as required under the actual circumstances. It is desirable to review budgets at-least quarterly if not sooner.
The feature of a rolling budget is that it is continuously up-to-dated thus, for an organization growing continuously, rolling budget would be appropriate. For a stable organization with established market share rolling budget would be inappropriate. The nature of business, transactions, seasonal effects on the performance of an organization all these factors must be considered while deciding about the policy of budget.

Part a:

Revenue budget
Quarters	September	December	March	June
Revenue
Consultancy fees from senior consultant	17,000.00	15,640.00	15,640.00	15,640.00
Consultancy fees from junior consultant	8,820.00	9,240.00	8,820.00	9,240.00
Expected total revenue in different quarters (inclusive of GST)	25,820.00	24,880.00	24,460.00	24,880.00

Cash Collection forecasts
Quarters	September	December	March	June
Cash received for previous quarter	13,200.00	10,328.00	14,676.00	14,928.00
Cash received for the current quarter	15,492.00	14,928.00	9,952.00	9,784.00
Total cash inflows (inclusive of GST)	28,692.00	25,256.00	24,628.00	24,712.00

Part b:

2013	Sep	Dec	Mar	Jun	Financial year
Motor vehicle	1,300.00	1,495.00	300.00	450.00	3,545.00
Printing	200.00	50.00	200.00	50.00	500.00
New vehicle	27,500.00				27,500.00
Photocopier		5,500.00			5,500.00
Computer system		5,500.00			5,500.00
Up-gradation of computer system			2,750.00		2,750.00
Total capital expenses	29,000.00	12,545.00	3,250.00	500.00	45,295.00

Part c:

Expense budget
	Sep	Dec	Mar	Jun	Financial year
Depreciation	700.00	700.00	700.00	700.00	2,800.00
Wages:
Senior staff	8,000.00	8,000.00	8,000.00	8,000.00	32,000.00
Junior staff	5,000.00	5,000.00	5,000.00	5,000.00	20,000.00
Bonus				1,000.00	1,000.00
Printing	200.00	50.00	200.00	50.00	500.00
Electricity	600.00	555.00	500.00	500.00	2,155.00
Rent	4,500.00	4,500.00	4,500.00	4,500.00	18,000.00
Total expenses	19,000.00	18,805.00	14,400.00	15,250.00	67,455.00

Statement of financial performance
Particulars	Amount ($)	Amount ($)
Revenue (100040 x 100/110)	90,945.45
Less: Expenditures
Rent (18000 x 100/110)	16,363.64
Electricity (2155 x 100/110)	1,959.09
Printing (500 x 100/110)	454.55
Salaries	52,000.00
Bonus	1,000.00
Depreciation	2,800.00
		74,577.27
Earnings before tax	16,368.18
Less: [email protected]%	4,910.45
Profit after tax	11,457.73

Part d:

Cash collection forecast
Cash budget
Quarters	September	December	March	June	For the financial year
Cash received for previous quarter	13,200.00	10,328.00	14,676.00	14,928.00	53,132.00
Cash received for the current quarter	15,492.00	14,928.00	9,952.00	9,784.00	50,156.00
Total cash receipts	28,692.00	25,256.00	24,628.00	24,712.00	103,288.00

Cash payments
Wages:
Senior staff	8,000.00	8,000.00	8,000.00	8,000.00	32,000.00
Junior staff	5,000.00	5,000.00	5,000.00	5,000.00	20,000.00
Bonus				1,000.00	1,000.00
Printing	200.00	50.00	200.00	50.00	500.00
Electricity	600.00	555.00	500.00	500.00	2,155.00
Rent	4,500.00	4,500.00	4,500.00	4,500.00	18,000.00
New vehicle	27,500.00				27,500.00
Photocopier	5,500.00			5,500.00
Computer system	5,500.00			5,500.00
Up-gradation of computer system	2750		2,750.00
Total cash payments	32,800.00	16,105.00	7,950.00	5,050.00	61,905.00
Net cash received / (used)	(4,108.00)	9,151.00	16,678.00	19,662.00	41,383.00
Add: Opening cash balance	42000	37,892.00	47,043.00	63,721.00	42,000.00
Closing cash balance	37,892.00	47,043.00	63,721.00	83,383.00	83,383.00

The above graph shows different elements of cash budget for the four quarters.

Part e:

It has been assumed that the payment of salaries, bonus, rent, electricity and printing expenses have been made in respective quarters when expenditures have been incurred.
The budgets are prepared on the basis of certain assumtp0iosn since the future is uncertain and unknown. In order to counter the risk of uncertainty it is important to conduct the business operations by using the resources effectively.

Budgets have been prepared by taking into consideration the past performances of the company along with future expectations. In order to complete the budgets certain assumptions have been made since the future is uncertain. It is important to review the budgets periodically to make necessary adjustments to the budgeted figures as and when necessary.

The objectives of preparing the budgets include motivating and inspiring the employees of the company to achieve the organizational objectives in the future.

Part a:

OMG LTD
Budgeted Profit and Loss Statement for year ending 30/06/2016
Details	Quarter 1	Quarter 2	Quarter 3	Quarter 4	TOTAL
Sales	$100,000.00	$120,000.00	$100,000.00	$80,000.00	$400,000.00
Less: Cost of Goods Sold	$29,000.00	$34,800.00	$29,000.00	$23,200.00	$116,000.00
GROSS PROFIT	$71,000.00	$85,200.00	$71,000.00	$56,800.00	$284,000.00
Operating Expenses	$45,000.00	$45,000.00	$45,000.00	$45,000.00	$180,000.00
PROFIT BEFORE TAX	$26,000.00	$40,200.00	$26,000.00	$11,800.00	$104,000.00
Less Tax @ 30%	$7,800.00	$12,060.00	$7,800.00	$3,540.00	$31,200.00
PROFIT FOR PERIOD	$18,200.00	$28,140.00	$18,200.00	$8,260.00	$72,800.00

Part b:

Sub part 1:

Rundle Ltd
Purchase Budget for period ending 31st March 2016
Details	January	February	March	Total
Cost of Sales	$100,000.00	$120,000.00	$80,000.00	$300,000.00
Add: Closing Stock	$108,000.00	$72,000.00	$148,500.00	$148,500.00
Total Required	$208,000.00	$192,000.00	$228,500.00	$448,500.00
Less: Opening Stock	$90,000.00	$108,000.00	$72,000.00	$90,000.00
Total Purchases	$118,000.00	$84,000.00	$156,500.00	$358,500.00

Sub part 2:

Rundle Ltd
Cost of Goods Sold Budget for period ending 31st March 2016
Details	January	February	March	Total
Opening Stock	$90,000.00	$108,000.00	$72,000.00	$90,000.00
Add: Purchases	$118,000.00	$84,000.00	$156,500.00	$358,500.00
Less: Closing Stock	$108,000.00	$72,000.00	$148,500.00	$148,500.00
Cost of Goods Sold	$100,000.00	$120,000.00	$80,000.00	$300,000.00

Part c:

Sub part 1:

Rundle Ltd
Marketing Expense Budget for period ending 31st March 2016
Details	January	February	March	Total
Sales Representatives’ salaries	$6,000.00	$6,000.00	$6,000.00	$18,000.00
Cartage outwards	$7,500.00	$9,000.00	$6,000.00	$22,500.00
Advertising	$4,500.00	$5,400.00	$3,600.00	$13,500.00
Total Marketing Expenses	$18,000.00	$20,400.00	$15,600.00	$54,000.00

Sub part 2:

Rundle Ltd
Financial Expense Budget for period ending 31st March 2016
Details	January	February	March	Total
Interest on Loan	$830.00	$820.00	$810.00	$2,460.00
Bank Charges	$60.00	$60.00	$60.00	$180.00
Total Financial Expenses	$890.00	$880.00	$870.00	$2,640.00

Part d:

Rundle Ltd
Budget Income Statement for period ending 31st March 2016
Details	January	February	March	Total
Sales	$150,000.00	$180,000.00	$120,000.00	$450,000.00
Less: Cost of Goods Sold	$100,000.00	$120,000.00	$80,000.00	$300,000.00
Gross Profit	$50,000.00	$60,000.00	$40,000.00	$150,000.00
Marketing Expenses	$18,000.00	$20,400.00	$15,600.00	$54,000.00
Financial Expenses	$890.00	$880.00	$870.00	$2,640.00
Administrative Expenses	$17,900.00	$17,900.00	$17,900.00	$53,700.00
Total Operating Expenses	$36,790.00	$39,180.00	$34,370.00	$110,340.00
Net Profit	$13,210.00	$20,820.00	$5,630.00	$39,660.00

Administrative Expenses
Details	January	February	March	Total
General salaries and wages	$12,000.00	$12,000.00	$12,000.00	$36,000.00
Audit Fees	$200.00	$200.00	$200.00	$600.00
Payroll on-costs	$1,800.00	$1,800.00	$1,800.00	$5,400.00
Rent	$3,600.00	$3,600.00	$3,600.00	$10,800.00
Telephone	$150.00	$150.00	$150.00	$450.00
Stationery	$150.00	$150.00	$150.00	$450.00
Total Administrative Expenses	$17,900.00	$17,900.00	$17,900.00	$53,700.00

Part e:

Anshar Manufacturing
Budget Income Statement for period ending 30th June
Details	Amount	Amount
Sales (200 000 mugs)		$600,000.00
Variable Costs
Direct materials	$210,000.00
Direct labour	$72,000.00
Factory overhead	$48,000.00
Selling Expenses	$33,000.00
Admin & Finance Expenses	$12,000.00
Total Variable Costs		$375,000.00
Contribution Margin		$225,000.00
Fixed Costs
Factory Overhead	$60,000.00
Selling Expenses	$9,000.00
Admin & Finance Expenses	$37,500.00
Total Fixed Costs		$106,500.00
Net Profit		$118,500.00

Sub part 2:

Anshar Manufacturing
Budget Income Statement for period ending 30th June
Details	Amount	Amount	Amount
Level of Activity (Mugs)	100%	75%	50%
Sales (200 000 mugs)	$600,000.00	$450,000.00	$300,000.00
Variable Costs
Direct materials	$210,000.00	$157,500.00	$105,000.00
Direct labour	$72,000.00	$54,000.00	$36,000.00
Factory overhead	$48,000.00	$36,000.00	$24,000.00
Selling Expenses	$33,000.00	$24,750.00	$16,500.00
Admin & Finance Expenses	$12,000.00	$9,000.00	$6,000.00
Total Variable Costs	$375,000.00	$281,250.00	$187,500.00
Contribution Margin	$225,000.00	$168,750.00	$112,500.00
Fixed Costs
Factory Overhead	$60,000.00	$60,000.00	$60,000.00
Selling Expenses	$9,000.00	$9,000.00	$9,000.00
Admin & Finance Expenses	$37,500.00	$37,500.00	$37,500.00
Total Fixed Costs	$106,500.00	$106,500.00	$106,500.00
Net Profit	$118,500.00	$62,250.00	$6,000.00

Sub part 3:

Average budgeted sale price for mugs is (600,000/200,000) = $3 per mug.

Sub part 4:

Anshar Manufacturing
Budget Income Statement for period ending 30th June
Details	Amount	Amount	Amount
Level of Activity (Mugs)	200000	190000	210000
Sales (200 000 mugs)	$600,000.00	$570,000.00	$630,000.00
Variable Costs
Direct materials	$210,000.00	$199,500.00	$220,500.00
Direct labour	$72,000.00	$68,400.00	$75,600.00
Factory overhead	$48,000.00	$45,600.00	$50,400.00
Selling Expenses	$33,000.00	$31,350.00	$34,650.00
Admin & Finance Expenses	$12,000.00	$11,400.00	$12,600.00
Total Variable Costs	$375,000.00	$356,250.00	$393,750.00
Contribution Margin	$225,000.00	$213,750.00	$236,250.00
Fixed Costs
Factory Overhead	$60,000.00	$60,000.00	$60,000.00
Selling Expenses	$9,000.00	$9,000.00	$9,000.00
Admin & Finance Expenses	$37,500.00	$37,500.00	$37,500.00
Total Fixed Costs	$106,500.00	$106,500.00	$106,500.00
Net Profit	$118,500.00	$107,250.00	$129,750.00

Sub part 5:

Anshar Manufacturing
Variance Analysis
Details	Budgeted Amount	Actual Amount	Variance ($)	Variance (%)	U/F
Level of Activity (Mugs)	210000	210000
Sales (200 000 mugs)	630,000.00	622,500.00	(7,500.00)	(0.01)	U
Variable Costs
Direct materials	220,500.00	225,000.00	4,500.00	0.02	U
Direct labour	75,600.00	72,900.00	(2,700.00)	(0.04)	F
Factory overhead	50,400.00	52,500.00	2,100.00	0.04	U
Selling Expenses	34,650.00	37,500.00	2,850.00	0.08	U
Admin & Finance Expenses	12,600.00	15,000.00	2,400.00	0.19	U
Total Variable Costs	393,750.00	402,900.00	9,150.00	0.02	U
Contribution Margin	236,250.00	219,600.00	(16,650.00)	(0.07)	U
Fixed Costs
Factory Overhead	60,000.00	60,000.00	–	–	–
Selling Expenses	9,000.00	10,500.00	1,500.00	0.17	U
Admin & Finance Expenses	37,500.00	33,000.00	(4,500.00)	(0.12)	F
Total Fixed Costs	106,500.00	103,500.00	(3,000.00)	(0.03)	F
Net Profit	129,750.00	116,100.00	(13,650.00)	(0.11)	U

References:

Bryson, J. M. (2018). Strategic planning for public and nonprofit organizations: A guide to strengthening and sustaining organizational achievement. John Wiley & Sons.

Chenhall, R. H., & Moers, F. (2015). The role of innovation in the evolution of management accounting and its integration into management control. Accounting, Organizations and Society, 47, 1-13.

Sayles, L. R. (2017). Managing large systems: Organizations for the future. Routledge.

Turn in your highest-quality paper
Get a qualified writer to help you with

“ Budgeting And Financial Management: Questions And Answers ”

Get high-quality paper

NEW! AI matching with writer