Australian Tax Office requirements
This report contains a theoretical discussion on the aspects of monitoring, budgeting, taxation and planning, along with the preparation and analysis of the budgets for the company Proactive Management Consultants Pty Ltd. The findings of the report depicts that it is very important for the organization to properly monitor its financial plans and procedures and accurately prepare its budgets, in order to improve its financial performance.
Part A
Question 1.
Reviewing the evaluation of financial monitoring plans brings advantage to the staff performance reviews which help in recognising and value the team members, identifying the need of training and clarifying their roles. An evaluation basically examines the outcome of a project with an objective of providing a framework for future projects through Monitoring and Evaluating Development Programs. It can also be described as an evaluation of cooperative programs that resolute that the cooperatives do improve the lives of many people but does not have a major impact on the overall employment. The concept of evaluation is mainly used for selecting and designing the future projects appropriately. With help of evaluation studies, one can assess level to which a project can develop impacts and distribution of benefits between different groups. The study also laid emphasis on the evaluation of cost-effectiveness of the project, when compared to other options.
It is very important to timely review and monitors the financial plans and procedures in order to comply with the changing requirements. A periodical review of financial plans and policies is necessary to keep them in align with company’s aim and objectives and to determine the weaknesses of planning and implementation. As the financial planning is done on the basis of assumptions, it becomes important for the management to review the plans on regular basis and to ensure that the assumptions made must proves to be true. If the assumptions prove to be wrong, then the planning needs to be modified as per the changes required. Thus, reviewing financial procedures, plans and policies regularly, is essential for achieving organization’s predetermined goals and objectives (Harris and Mongiello, 2012).
It is very important to keep workplace safety for the employees of the firm. In order to keep that, organization need to formulate some suitable policies and especially companies engaged in manufacturing industry are required to take additional measures for keeping the workplaces safe for its employees. It has been seen that many organizations have already taken some measures regarding employee health and safety, which ultimately resulted in the increased and better financial performance of the organization. Thus, employing work health and safety measures can leave a positive impact on firm’s financial performance (Gahan, Sievewright and Evans, 2014).
Reporting guidelines for duty, excise and other overseas government charges
Apart from this, performance reviews also assist in creating the culture of open communication in the organization. In order to know about employees’ performance, companies generally conduct annual reviews of their efficiency, work product and their attitude towards their job. The results derived from performance reviews can help the management to take certain decisions regarding the pay grade and salary increment of their employees, promotions, need of providing additional training and all other decisions related to employees. Along with this, the organization can also improve their budget forecasts for coming fiscal year. Review of performance allows to describe the role and responsibility of employees as well as help them to reflect, consolidate, plan and review their work performance (Malik, Butt and Choi, 2015).
The work health and safety programs in an organization can affect its financial performance to a great extent. Illness, injuries and death on work places can impose large costs not only on the company but also on the national economies. These costs accrue to the workers who had suffer, their families, the organizations who employed them and to the society at large because of the cost associated with health care and treatment. The WHS programs will always have a positive impact on financial performance of the company. The overall productivity of an organization will increase when it has healthy and fit employees to work with. These programs are organized to maintain and manage the health and safety of the workers. There can be several reasons behind an improved performance and increased productivity of the firm. Some of them are reduction in employee turnover, less government interference and reduced machinery hours. The employee turnover will reduce as employees will feel safe to work in an organization which has work health and safety measures. This will result in increased worker’s efficiency and reduction in cost of employment which will ultimately bring an upsurge in firm’s productivity (Business.gov.au, 2017).
WHS measures also decreases the machinery hours which will lead to the reduction in cost of production and increase in efficiency. However, firms not having WHS programs and measures can face continuous government interruption as the health and safety of the employees are covered under proper laws and regulations. Thus, if the company does not follow the rules and regulations regarding employee health and safety, then it will be liable to pay fines and penalties which may sometimes extend to the suspension of the business. Another benefit which can be derived from WHS of employees is that if the workers stay healthy, then they will be able to work more effectively and efficiently. These measures boost up the capacity of the employees to work with full confidence and in a best possible manner. On the top of that, the reputation, goodwill or brand value of a firm is also improved when it complies with health and safety norms. On the other hand, companies not having WHS measure are not only entitled to pay penalties but their goodwill can also be impacted to large extent. The reduction in the reputation will brings a negative impact on the financial performance of the organization (Schlick, ed., 2009).
Discrepancies in business transactions
Question 2.
Effectiveness of any financial plan is mainly depended upon the approach followed by an organization. The top management usually formulates all the plans, policies and procedures and then these are transferred to the middle and lower level of management for the purpose of implementation and supervision. Monitoring the implementation of financial plans is the prime responsibility of the top management. Analysis of budgeting and financial planning process of management can help in ascertaining the effectiveness of financial monitoring and planning process. The process followed must be standardized as it assists in better supervision of plans. Along with this, the financial plans implemented by the management should not be rigid because rigidity in the budgets and plans causes problems in implementation and also results in resistance among the employees. If there will be rigidity in plans then employees may not be willing to make changes in the set policies but they may be compelled to do so. Forcing the employees to do something against their wish may result in resistance that ultimately affect the monitoring process of budgets (Boone and Kurtz, 2011).
Another factor which can be used in measuring the effectiveness of a financial plans is the budgets prepared by the organization. The management must have a working budget for each month. On the basis of which, management can judge the effectiveness of its plans and policies. Budgets help in making decisions regarding the achievement of long term financial goals. With the help of them, companies can prepare their financial plans and procedure and can also identify the variances if any. Thus working budget helps in monitoring the plans formulated by the management. Eliminating the debt can also result in an effective financial plan. Companies should make efforts to eliminate their debt as it is not useful when the organization save money and invest it in paying the higher interest rates on the funds borrowed. The position of debt in an organization reflects how effective its financial plan is. If management has lot of debt, then it has to cut down its spending are put efforts to increase it earnings in order to pay off the debts. This shows that the company does not properly monitor its plans, procedures and policies. Therefore, organization must have standard procedures, flexible policies, working budget and low debt in order to make its financial plans effective (Atkinson and Messy, 2012).
Question 3.
Impact of work health and safety programs on financial performance
The main element of financial planning and procedure is monitoring. It is the responsibility of the top management to formulate plans and budgets for coming years and to review them regularly. During the process of reviewing, management identifies the area where changes are required and after the identifications done, it forms policies and procedures in order to carry out such changes. It is very essential to make sure that the changes are accurately made and the improvements which are required in the monitoring process are carried out properly. Verification and comparison of new plans and procedures is very crucial in order to monitor such improvements. The new process must reflect the changes done by management and they should be in contrast with the previous one. Moreover, the evaluator must also consider the experience and qualification of the persons who are held responsible for making such changes in the monitoring process. As a person having professional and specialized qualification would monitor the changes in more effective manner (Localmanagement, 2017).
In order to monitor the improvements, the organization should make team of professionals or competent persons which can carried out the monitoring process more effectively and efficiently. Proper documentation should be there which contains the details of the results derived from making changes in financial procedures. The duties and responsibilities should be properly and clearly assigned to the team members and is must be the duty of the team to check that whether the results from improvements have positive or negative impact on the overall performance of the organization. A report must be sent to the top management which contains all the details of the improvements and everything should be done within the standard procedures (Brose, et. al. 2014).
The organization must follows the same process for monitoring the changes as it had followed in monitoring the financial procedures. The process used can be modified as and when required. The employees must be trained enough to comply with the improvements made and should accept them positively. In order to ensure this, management should provide additional training to its employees and workers and make them component to deal with the changes. Following standard procedures, having a team of professionally qualified persons, proper documentation and verification and having trained employees can help in monitoring the improvements made at the time of monitoring financial procedures.
-
Bilateral and Regional Trade Agreements are important phenomena in today’s era. In literal meaning, Bilateral Trade Agreement (BTA) is the one which is made between the two contracting parties whereas Regional Trade Agreements (RTA) is the one which is made between two or more contracting parties who share a common denomination which is conceptually known as “region”. The main aim of these agreements is to strengthen trade relations between members. Within the framework of Word Trade Organization, these agreements are been concluded to provide additional trade benefits to the contracting parties in compliance with the principles set out by WTO (Lester, Mercurio and Bartels, 2016).
-
Performance reviews and open communication
International Commercial Terms (INCOTERMS) are the terms developed by International Chamber of Commerce and is a three letter trade terms which is widely used in the contracts done internationally and domestically for the sale of goods. These terms have got a worldwide acceptance by the government and shippers and are used to avoid uncertainties and misunderstandings. It defines the rights and obligations of each of the parties which enters into a contract, made for delivery of goods sold. Distribution of transaction costs and responsibilities between the buyer and seller is specified by INCOTERMS (Moses, 2017).
-
Competition and Consumer Act 2010 is an act of Parliament of Australia. This law lay emphasis on promoting completion, fair trading and protecting the consumers in Australia. It replaces the Trade Practices Act 1974 on January 1, 2011. Australian Competition and Consumer Commission (ACCC) administers the act. The act covers areas of market such as relationship between wholesalers, retailers, suppliers and consumers. Its overall objective is to enrich the welfare of Australian people by establishing fair competition and consumer protection provisions. Mainly it includes price monitoring, safety of product, mergers and acquisition, industry codes and unfair market prices. The act also laid down the rights and responsibilities of the consumer (Corones, 2014).
-
Warsaw convention is known as the convention for the unification of some rules related to international carriage by air. The liability for international carriage of goods, luggage and persons which is carried out by aircraft is regulated by this convention. It was originally written in France and the original documents were deposited with the Ministry for Foreign Affairs of Poland. It also provides the requirements for the format and content of the documents which are used for air transport such as passenger tickets, luggage tickets and many more ( 2018).
-
The global organization which deals with the rules of trade between countries is known as World Trade Organization. The main component of WTO is the world trade agreements that are negotiated and signed by the large number of trading nations and approved in their parliaments. The main aim of WTO is to provide help to the importers, exporters and producers of goods and services in conducting their business ( 2018)
It is Australian Tax Office that levies Goods and Services Tax (GST) on the sales of goods and services made in the country. The businesses operating in Australia are required to file returns to ATO on periodic basis in regards to GST paid and collected. Further, companies are required to pay company tax at rate of 30% on the profits made (ATO. 2018). Employer deduct PAYG from the salary of the employee and the amount is deposited to ATO.
Effective financial plans and budgets
(a) The organization should have dedicated employees who are keen to do their job of computing tax liabilities and remitting the dues of ATO timely. Along with this, an integrated information system must also be there in the business, which collects the information from various sources and provide reports to the management on timely basis. Having dedicated employees and integrated information system can result in proper internal control of the firm. Management can properly control the activities of the business and take appropriate decisions regarding any discrepancies in the operations.
(b) The Australian Tax office provide options to report and pay Goods and Services Tax. The period for reporting and payment of GST will be one from the following:
-
Monthly: if the GST turnover is more than or equal to $20 million.
-
Quarterly: if the GST turnover is less than $20 million and no notification has been received from ATO regarding monthly reporting of GST.
-
Annually: if the company is voluntarily registered for GST and having a turnover under $75,000. For non-profit organizations, the limit is $150,000 ( 2018).
According to ATO, an individual needs to lodge a PAYG withholding report at the end of each and every fiscal years, if the business of an individual suspended amounts from the payment made to:
-
Non-residents (interest, dividend and royalty payments)
-
Employees
-
Foreign residents
-
Business which do not quote on ABN
The reports regarding entity tax or company tax are produced annually on or before 30th September 2017 and the information is derived from tax returns and amendments (ATO. 2018).
(c) Business operating in Australia are required to report to the Australian Taxation Office (ATO), Australian Securities and Investments Commission (ASIC) and the Australian Securities Exchange (ASX). In order to report their tax obligations and payments, the businesses need to lodge a business activity statement (BAS) to ATO. This statement can be lodged electronically, by mail or in person. For filing GST return, business use BAS and the company return is filed using the form of company tax return.
Question 6.
Companies engaged in production and manufacturing of goods are liable to pay excise duty. It is necessary for every manufacturer or producer to apply for a license from the Australian Tax Office. As and when sale of goods and services is made, the license holder is required to pay excise duty to ATO. Furthermore, license holders are provided with option in regard to their excise duty payment. They are allowed periodic settlements and prepayments. Under the option of prepayments, they can pay the duty before the liability of paying it actually arises.
Monitoring financial plans and procedures
Some business are exempted from the payment of duty of excise such as goods produced by the companies, which are used in diplomatic missions. Exemption is been given to such organizations. In regard with the imports of goods and services, traders are liable to pay import and export duties to the Australian Government. However, Australia has Free Trade Agreements with six countries, therefore no import and export duty will be levied on the goods and services imported and exported from or to these countries (ATO. 2018).
Question 7.
Discrepancies or errors in any business transaction would not be acceptable by the organization. Having discrepancies in the transactions can cost too high to the business and therefore in order to avoid them, management must have adequate controls over the process of recording transactions. Errors generally occurs at the time of recording the transactions such as omission of the amounts, wrong amounts recorded or incorrect presentation of the data. Recording incorrect amount, omitting the transactions or wrongly presenting the data, all of them are considered as discrepancies and companies has to face consequences of the same. Variations or error in the business transactions that are in books, records or returns which are required to be submitted to outside agencies are not acceptable because they could result in heavy penalties, fine and litigations to the company (Alhabeeb, 2014).
Though discrepancies in the books, records and reports which are used for internal use can tolerable as long as they do not affect the long term decisions of the management. Further, if they are use at internal level, management is able to detect the errors and rectify them as soon as possible. Thus, it should be a vital responsibility of the management of the company to make sure that there are no discrepancies in filing the tax returns which are to be submitted to taxation offices and authorities. Return filed with securities exchange commission should also be free from variations.
To avoid such discrepancies, errors or variations, companies place adequate controls over the transaction recording process. These controls regularly monitors the recording of business transactions and identify the errors and rectify them time to time. Companies should have strong control over the preparation of tax returns and returns submitted to SEC in order to save the reports and returns from being wrongly filed. Organization must follow a standard procedure for verifying the accuracy of the data, which is filled in the returns to be filed with SEC and taxation authorities (Alhabeeb, 2014).
Improving and monitoring financial procedures
Part B
Question 1.
Cash collection Schedule |
||||||||
May |
Jun |
July |
August |
September |
October |
November |
December |
|
Sales |
42,100 |
47,300 |
59,000 |
44,100 |
46,000 |
51,600 |
47,000 |
67,000 |
Cash Inflow: |
||||||||
Cash sales (60%) |
35,400 |
26,460 |
27,600 |
30,960 |
28,200 |
40,200 |
||
Collection from last month (30%) |
14,190 |
17,700 |
13,230 |
13,800 |
15,480 |
14,100 |
||
Collection from second to last month (10%) |
4,210 |
4,730 |
5,900 |
4,410 |
4,600 |
5,160 |
||
Total Cash Receipt |
53,800 |
48,890 |
46,730 |
49,170 |
48,280 |
59,460 |
Question 2.
Jul |
Budget |
Over the Budget $ |
% of budget |
Aug |
Budget |
Over the Budget $ |
% of budget |
|
Income |
||||||||
Reimbursed expense |
0 |
600 |
(600) |
(1) |
800 |
1,200 |
(400) |
(33) |
Sales |
59,000 |
61,200 |
(2,200) |
(4) |
44,100 |
42,000 |
2,100 |
5 |
Service |
0 |
0 |
300 |
100 |
200 |
200 |
||
Total income |
59,000 |
61,800 |
(2,800) |
(5) |
45,200 |
43,300 |
1,900 |
4 |
Expense |
||||||||
Bank service charges |
50 |
50 |
40 |
50 |
(10) |
(20) |
||
Books and publication |
80 |
100 |
(20) |
(20) |
200 |
100 |
100 |
100 |
Dues and subscription |
50 |
50 |
0 |
0 |
50 |
(50) |
(100) |
|
Expensed equipment |
600 |
500 |
100 |
20 |
450 |
500 |
(50) |
(10) |
Advertising |
2,000 |
2,000 |
0 |
0 |
2,000 |
2,000 |
0 |
0 |
Insurance |
10,000 |
10,000 |
0 |
0 |
300 |
1,000 |
(700) |
(70) |
Finance charges |
0 |
100 |
(100) |
(100) |
10 |
10 |
0 |
0 |
Loan interest |
4,970 |
5,000 |
(30) |
(1) |
3,300 |
3,300 |
0 |
0 |
License & permits |
1,100 |
700 |
400 |
57 |
0 |
0 |
0 |
|
Motor expense |
9,900 |
9,000 |
900 |
10 |
3,100 |
2,570 |
530 |
21 |
Office supplies |
30 |
150 |
(120) |
(80) |
90 |
150 |
(60) |
(40) |
Payroll expense |
25,000 |
25,000 |
0 |
0 |
25,000 |
25,000 |
0 |
0 |
Postage & delivery |
30 |
20 |
10 |
50 |
70 |
20 |
50 |
250 |
Printing & Reproduction |
770 |
1,000 |
(230) |
(23) |
500 |
350 |
150 |
43 |
Accounting fees |
0 |
0 |
0 |
1,200 |
1,200 |
0 |
0 |
|
Legal fees |
0 |
0 |
0 |
500 |
0 |
500 |
||
Recruitment & Training |
0 |
0 |
0 |
0 |
500 |
(500) |
(100) |
|
Rent |
1,200 |
1,200 |
0 |
0 |
3,500 |
3,500 |
0 |
0 |
Repairs |
250 |
300 |
(50) |
(17) |
0 |
300 |
(300) |
(100) |
Software expense |
300 |
300 |
0 |
0 |
60 |
60 |
0 |
0 |
Stamp duty |
70 |
100 |
(30) |
(30) |
100 |
100 |
0 |
0 |
Telephone |
90 |
100 |
(10) |
(10) |
300 |
100 |
200 |
200 |
Travel & Ent |
800 |
1,500 |
(700) |
(47) |
230 |
1,000 |
(770) |
(77) |
Utilities |
247 |
250 |
(3) |
(1) |
250 |
250 |
0 |
0 |
Total Expense |
57,537 |
57,420 |
117 |
0 |
41,200 |
42,110 |
(910) |
(2) |
Net Income |
1,463 |
4,380 |
(2,917) |
(67) |
4,000 |
1,190 |
2,810 |
236 |
Opening Balance |
51,200 |
51,200 |
0 |
0 |
47,463 |
49,260 |
(1,797) |
(4) |
Receipts |
53,800 |
55,480 |
(1,680) |
(3) |
49,990 |
49,250 |
740 |
2 |
Payments |
57,537 |
57,420 |
117 |
0 |
41,200 |
42,110 |
(910) |
(2) |
Closing Balance |
47,463 |
49,260 |
(1,797) |
(4) |
56,253 |
56,400 |
(147) |
(0) |
Sep |
Budget |
Over the Budget $ |
% of budget |
1st Quarter |
Budget |
Over the Budget $ |
% of budget |
|
Income |
||||||||
Reimbursed expense |
1,200 |
2,000 |
(800) |
(40) |
2,000 |
3,800 |
(1,800) |
(47) |
Sales |
46,000 |
41,000 |
5,000 |
12 |
149,100 |
144,200 |
4,900 |
3 |
Service |
100 |
400 |
(300) |
(75) |
400 |
500 |
(100) |
(20) |
Total income |
47,300 |
43,400 |
3,900 |
9 |
151,500 |
148,500 |
3,000 |
2 |
Expense |
#DIV/0! |
|||||||
Bank service charges |
50 |
50 |
140 |
150 |
(10) |
(7) |
||
Books and publication |
80 |
100 |
(20) |
(20) |
360 |
300 |
60 |
20 |
Dues and subscription |
60 |
50 |
10 |
20 |
110 |
150 |
(40) |
(27) |
Expensed equipment |
12,000 |
12,000 |
0 |
0 |
13,050 |
13,000 |
50 |
0 |
Advertising |
500 |
500 |
0 |
0 |
4,500 |
4,500 |
0 |
0 |
Insurance |
700 |
1,000 |
(300) |
(30) |
11,000 |
12,000 |
(1,000) |
(8) |
Finance charges |
10 |
10 |
0 |
0 |
20 |
120 |
(100) |
(83) |
Loan interest |
3,300 |
3,300 |
0 |
0 |
11,570 |
11,600 |
(30) |
(0) |
License & permits |
0 |
0 |
0 |
#DIV/0! |
1,100 |
700 |
400 |
57 |
Motor expense |
3,100 |
1,200 |
1,900 |
158 |
16,100 |
12,770 |
3,330 |
26 |
Office supplies |
150 |
150 |
0 |
0 |
270 |
450 |
(180) |
(40) |
Payroll expense |
25,000 |
25,000 |
0 |
0 |
75,000 |
75,000 |
0 |
0 |
Postage & delivery |
50 |
20 |
30 |
150 |
150 |
60 |
90 |
150 |
Printing & Reproduction |
80 |
150 |
(70) |
(47) |
1,350 |
1,500 |
(150) |
(10) |
Accounting fees |
0 |
0 |
0 |
#DIV/0! |
1,200 |
1,200 |
0 |
0 |
Legal fees |
0 |
1,200 |
(1,200) |
(100) |
500 |
1,200 |
(700) |
(58) |
Recruitment & Training |
0 |
0 |
0 |
#DIV/0! |
0 |
500 |
(500) |
(100) |
Rent |
3,500 |
3,500 |
0 |
0 |
8,200 |
8,200 |
0 |
0 |
Repairs |
0 |
0 |
0 |
#DIV/0! |
250 |
600 |
(350) |
(58) |
Software expense |
60 |
60 |
0 |
0 |
420 |
420 |
0 |
0 |
Stamp duty |
100 |
100 |
0 |
0 |
270 |
300 |
(30) |
(10) |
Telephone |
300 |
100 |
200 |
200 |
690 |
300 |
390 |
130 |
Travel & Ent |
200 |
100 |
100 |
100 |
1,230 |
2,600 |
(1,370) |
(53) |
Utilities |
250 |
0 |
250 |
#DIV/0! |
747 |
500 |
247 |
49 |
Total Expense |
49,490 |
48,590 |
900 |
2 |
148,227 |
148,120 |
107 |
0 |
Net Income |
(2,190) |
(5,190) |
3,000 |
(58) |
3,273 |
380 |
2,893 |
761 |
Opening Balance |
56,253 |
56,400 |
(147) |
(0) |
51,200 |
51,200 |
0 |
0 |
Receipts |
48,030 |
45,210 |
2,820 |
6 |
151,820 |
149,940 |
1,880 |
1 |
Payments |
49,490 |
48,590 |
900 |
2 |
148,227 |
148,120 |
107 |
0 |
Closing Balance |
54,793 |
53,020 |
1,773 |
3 |
54,793 |
53,020 |
1,773 |
3 |
Oct |
Budget |
Over the Budget $ |
% of budget |
Nov |
Budget |
Over the Budget $ |
% of budget |
||
Income |
|||||||||
Reimbursed expense |
0 |
0 |
0 |
900 |
700 |
200 |
29 |
||
Sales |
51,600 |
49,300 |
2,300 |
5 |
47,000 |
41,000 |
6,000 |
15 |
|
Service |
300 |
0 |
300 |
1,000 |
200 |
800 |
400 |
||
Total income |
51,900 |
49,300 |
2,600 |
5 |
48,900 |
41,900 |
7,000 |
17 |
|
Expense |
|||||||||
Bank service charges |
50 |
50 |
0 |
0 |
30 |
50 |
(20) |
(40) |
|
Books and publication |
30 |
100 |
(70) |
(70) |
80 |
100 |
(20) |
(20) |
|
Dues and subscription |
0 |
50 |
(50) |
(100) |
50 |
50 |
0 |
0 |
|
Expensed equipment |
0 |
500 |
(500) |
(100) |
400 |
500 |
(100) |
(20) |
|
Advertising |
16,000 |
16,000 |
0 |
0 |
500 |
500 |
0 |
0 |
|
Insurance |
1,000 |
1,000 |
0 |
0 |
1,300 |
1,000 |
300 |
30 |
|
Finance charges |
30 |
10 |
20 |
200 |
10 |
10 |
0 |
0 |
|
Loan interest |
3,300 |
3,300 |
0 |
0 |
3,300 |
3,300 |
0 |
0 |
|
License & permits |
700 |
700 |
0 |
0 |
20,050 |
20,000 |
50 |
0 |
|
Motor expense |
3,200 |
2,000 |
1,200 |
60 |
2,200 |
2,570 |
(370) |
(14) |
|
Office supplies |
400 |
150 |
250 |
167 |
140 |
150 |
(10) |
(7) |
|
Payroll expense |
25,000 |
25,000 |
0 |
0 |
32,500 |
32,500 |
0 |
0 |
|
Postage & delivery |
70 |
20 |
50 |
250 |
10 |
20 |
(10) |
(50) |
|
Printing & Reproduction |
300 |
150 |
150 |
100 |
900 |
1,000 |
(100) |
(10) |
|
Accounting fees |
0 |
0 |
0 |
1,200 |
1,200 |
0 |
0 |
||
Legal fees |
0 |
0 |
0 |
300 |
0 |
300 |
|||
Recruitment & Training |
10,000 |
10,000 |
0 |
0 |
500 |
500 |
0 |
0 |
|
Rent |
3,500 |
3,500 |
0 |
0 |
3,500 |
3,500 |
0 |
0 |
|
Repairs |
500 |
300 |
200 |
67 |
200 |
300 |
(100) |
(33) |
|
Software expense |
60 |
60 |
0 |
0 |
60 |
60 |
0 |
0 |
|
Stamp duty |
0 |
100 |
(100) |
(100) |
0 |
100 |
(100) |
(100) |
|
Telephone |
300 |
100 |
200 |
200 |
200 |
100 |
100 |
100 |
|
Travel & Ent |
1,200 |
1,500 |
(300) |
(20) |
1,200 |
1,500 |
(300) |
(20) |
|
Utilities |
250 |
250 |
0 |
0 |
250 |
250 |
0 |
0 |
|
Total Expense |
65,890 |
64,840 |
1,050 |
2 |
68,880 |
69,260 |
(380) |
(1) |
|
Net Income |
(13,990) |
(15,540) |
1,550 |
(10) |
(19,980) |
(27,360) |
7,380 |
(27) |
|
Opening Balance |
54,793 |
53,020 |
1,773 |
3 |
38,373 |
35,110 |
3,263 |
9 |
|
Receipts |
49,470 |
46,930 |
2,540 |
5 |
50,180 |
44,270 |
5,910 |
13 |
|
Payments |
65,890 |
64,840 |
1,050 |
2 |
68,880 |
69,260 |
(380) |
(1) |
|
Closing Balance |
38,373 |
35,110 |
3,263 |
9 |
19,673 |
10,120 |
9,553 |
94 |
Dec |
Budget |
$ over Budget |
% of Budget |
2nd Quarter |
Budget |
$ over Budget |
% of Budget |
|
Ordinary Income/Expense |
||||||||
Income |
||||||||
Reimbursed Expenses |
400.00 |
500.00 |
(100.00) |
-20% |
1,300.00 |
1,200.00 |
100.00 |
8% |
Sales |
67,000.00 |
63,000.00 |
4,000.00 |
6% |
165,600.00 |
153,300.00 |
12,300.00 |
8% |
Service |
200.00 |
– |
200.00 |
#DIV/0! |
1,500.00 |
200.00 |
1,300.00 |
650% |
Total Income |
67,600.00 |
63,500.00 |
4,100.00 |
6% |
168,400.00 |
154,700.00 |
13,700.00 |
9% |
Expense |
– |
– |
#DIV/0! |
– |
– |
#DIV/0! |
||
Bank Service Charges |
10.00 |
10.00 |
– |
0% |
90.00 |
110.00 |
(20.00) |
-18% |
Books and Publications |
80.00 |
20.00 |
60.00 |
300% |
190.00 |
220.00 |
(30.00) |
-14% |
Dues and Subscriptions |
100.00 |
50.00 |
50.00 |
100% |
150.00 |
150.00 |
– |
0% |
Expensed Equipment |
700.00 |
500.00 |
200.00 |
40% |
1,100.00 |
1,500.00 |
(400.00) |
-27% |
Advertising |
500.00 |
– |
500.00 |
#DIV/0! |
17,000.00 |
16,500.00 |
500.00 |
3% |
Insurance |
1,200.00 |
1,000.00 |
200.00 |
20% |
3,500.00 |
3,000.00 |
500.00 |
17% |
Finance Charge |
10.00 |
10.00 |
– |
0% |
50.00 |
30.00 |
20.00 |
67% |
Loan Interest |
3,300.00 |
3,300.00 |
– |
0% |
9,900.00 |
9,900.00 |
– |
0% |
Licenses and Permits |
– |
– |
– |
#DIV/0! |
20,750.00 |
20,700.00 |
50.00 |
0% |
Motor Expense |
2,100.00 |
2,000.00 |
100.00 |
5% |
7,500.00 |
6,570.00 |
930.00 |
14% |
Office Supplies |
140.00 |
150.00 |
(10.00) |
-7% |
680.00 |
450.00 |
230.00 |
51% |
Payroll Expenses |
48,500.00 |
48,500.00 |
– |
0% |
106,000.00 |
106,000.00 |
– |
0% |
Postage and Delivery |
80.00 |
20.00 |
60.00 |
300% |
160.00 |
60.00 |
100.00 |
167% |
Printing and Reproduction |
100.00 |
150.00 |
(50.00) |
-33% |
1,300.00 |
1,300.00 |
– |
0% |
Accounting Fees |
– |
– |
– |
#DIV/0! |
1,200.00 |
1,200.00 |
– |
0% |
Legal Fees |
– |
– |
– |
#DIV/0! |
300.00 |
– |
300.00 |
#DIV/0! |
Recruitment & Training |
18,000.00 |
18,000.00 |
– |
0% |
28,500.00 |
28,500.00 |
– |
0% |
Rent |
3,200.00 |
3,500.00 |
(300.00) |
-9% |
10,200.00 |
10,500.00 |
(300.00) |
-3% |
Repairs |
– |
– |
– |
#DIV/0! |
700.00 |
600.00 |
100.00 |
17% |
Software Expense |
60.00 |
60.00 |
– |
0% |
180.00 |
180.00 |
– |
0% |
Stamp Duty |
100.00 |
100.00 |
– |
0% |
100.00 |
300.00 |
(200.00) |
-67% |
Telephone |
50.00 |
100.00 |
(50.00) |
-50% |
550.00 |
300.00 |
250.00 |
83% |
Travel & Ent |
200.00 |
100.00 |
100.00 |
100% |
2,600.00 |
3,100.00 |
(500.00) |
-16% |
Utilities |
250.00 |
– |
250.00 |
#DIV/0! |
750.00 |
500.00 |
250.00 |
50% |
Total Expense |
78,680.00 |
77,570.00 |
1,110.00 |
1% |
213,450.00 |
211,670.00 |
1,780.00 |
1% |
– |
– |
#DIV/0! |
– |
– |
#DIV/0! |
|||
Net Income (EBIT) |
(11,080.00) |
(14,070.00) |
2,990.00 |
-21% |
(45,050.00) |
(56,970.00) |
11,920.00 |
-21% |
Opening Balance |
19,673.00 |
10,120.00 |
9,553.00 |
94% |
54,793.00 |
53,020.00 |
1,773.00 |
3% |
Receipts |
60,060.00 |
55,600.00 |
4,460.00 |
8% |
159,710.00 |
146,800.00 |
12,910.00 |
9% |
Payments |
78,680.00 |
77,570.00 |
1,110.00 |
1% |
213,450.00 |
211,670.00 |
1,780.00 |
1% |
Closing Balance |
1,053.00 |
(11,850.00) |
12,903.00 |
-109% |
1,053.00 |
(11,850.00) |
12,903.00 |
-109% |
Proactive Management Consultants Pty Ltd – Actuals – July to December 200X |
||||||
July |
Aug |
Sep |
Oct |
Nov |
Dec |
|
Ordinary Income/Expense |
||||||
Income |
||||||
Reimbursed Expenses |
– |
800.00 |
1,200.00 |
– |
900.00 |
400.00 |
Sales |
59,000.00 |
44,100.00 |
46,000.00 |
51,600.00 |
47,000.00 |
67,000.00 |
Service |
– |
300.00 |
100.00 |
300.00 |
1,000.00 |
200.00 |
Total Income |
59,000.00 |
45,200.00 |
47,300.00 |
51,900.00 |
48,900.00 |
67,600.00 |
Expense |
||||||
Bank Service Charges |
50.00 |
40.00 |
50.00 |
50.00 |
30.00 |
10.00 |
Books and Publications |
80.00 |
200.00 |
80.00 |
30.00 |
80.00 |
80.00 |
Dues and Subscriptions |
50.00 |
– |
60.00 |
– |
50.00 |
100.00 |
Expensed Equipment |
600.00 |
450.00 |
12,000.00 |
– |
400.00 |
700.00 |
Advertising |
2,000.00 |
2,000.00 |
500.00 |
16,000.00 |
500.00 |
500.00 |
Insurance |
10,000.00 |
300.00 |
700.00 |
1,000.00 |
1,300.00 |
1,200.00 |
Finance Charge |
– |
10.00 |
10.00 |
30.00 |
10.00 |
10.00 |
Loan Interest |
4,970.00 |
3,300.00 |
3,300.00 |
3,300.00 |
3,300.00 |
3,300.00 |
Licenses and Permits |
1,100.00 |
– |
– |
700.00 |
20,050.00 |
– |
Motor Expense |
9,900.00 |
3,100.00 |
3,100.00 |
3,200.00 |
2,200.00 |
2,100.00 |
Office Supplies |
30.00 |
90.00 |
150.00 |
400.00 |
140.00 |
140.00 |
Payroll Expenses |
25,000.00 |
25,000.00 |
25,000.00 |
25,000.00 |
32,500.00 |
48,500.00 |
Postage and Delivery |
30.00 |
70.00 |
50.00 |
70.00 |
10.00 |
80.00 |
Printing and Reproduction |
770.00 |
500.00 |
80.00 |
300.00 |
900.00 |
100.00 |
Accounting Fees |
– |
1,200.00 |
– |
– |
1,200.00 |
– |
Legal Fees |
– |
500.00 |
– |
– |
300.00 |
– |
Recruitment & Training |
– |
– |
– |
10,000.00 |
500.00 |
18,000.00 |
Rent |
1,200.00 |
3,500.00 |
3,500.00 |
3,500.00 |
3,500.00 |
3,200.00 |
Repairs |
250.00 |
– |
– |
500.00 |
200.00 |
– |
Software Expense |
300.00 |
60.00 |
60.00 |
60.00 |
60.00 |
60.00 |
Stamp Duty |
70.00 |
100.00 |
100.00 |
– |
– |
100.00 |
Telephone |
90.00 |
300.00 |
300.00 |
300.00 |
200.00 |
50.00 |
Travel & Ent |
800.00 |
230.00 |
200.00 |
1,200.00 |
1,200.00 |
200.00 |
Utilities |
247.00 |
250.00 |
250.00 |
250.00 |
250.00 |
250.00 |
Total Expense |
57,537.00 |
41,200.00 |
49,490.00 |
65,890.00 |
68,880.00 |
78,680.00 |
Net Income (EBIT) |
1,463.00 |
4,000.00 |
– 2,190.00 |
– 13,990.00 |
– 19,980.00 |
– 11,080.00 |
Opening Balance |
51,200.00 |
47,463.00 |
56,253.00 |
54,793.00 |
38,373.00 |
19,673.00 |
Receipts |
53,800.00 |
49,990.00 |
48,030.00 |
49,470.00 |
50,180.00 |
60,060.00 |
Payments |
57,537.00 |
41,200.00 |
49,490.00 |
65,890.00 |
68,880.00 |
78,680.00 |
Closing Balance |
47,463.00 |
56,253.00 |
54,793.00 |
38,373.00 |
19,673.00 |
1,053.00 |
Note: For cash receipts, the service revenues and reimbursement of expenses is considered on cash basis. |
Question 3.
The above tables shows the result of variance analysis which states that the actual total income in month of July is less than the budgeted income by 5%. On the other side actual total income of August, September, October, November and December exceeds their budgeted income by 4%, 9%, 5%, 17% and 6% respectively. Talking about actual total expenses, July’s actual expenses are almost equal to its budgeted figures while the actual total expense of August and November are less than their budgeted expense by 2% and 1% respectively. On the other hand, September, October and December have high actual total expenses than their budgeted figures by 2% and 1% respectively.
The closing balance for the month of July is less than the budgeted balance by 4% whereas the closing balance is equal to the budgeted balance in month of August. The actual cash closing balance of September and October is higher than their budgeted figures by 3% and 9% respectively. There is a huge difference of 94% in the actual and budgeted figures of closing balance in month of November. The actual balance is higher than the budgeted one. Further, December’s closing balance is lower than the budgeted one by 109%.
On the basis of the above analysis, following recommendations are provided for the financial plans of Proactive Management Consultants:
-
It is recommended to take up advertisement campaign in month of August instead of taking it in October. This would result in the addition of $10,000 to the training and recruitment expenses in August and 30% to the payroll of September and October. As a result, the sales of September and October will increase which will help the company to improve its cash position in subsequent months.
-
The plan of moving into new premises in August is required to be deferred till next month. Having enough sales in September can make it easier for the company to bear the increase rent expense of $3,500 in these months.
-
The expense of $20,000 related to the purchase of a license in November should be deferred to December.
Question 4.
The new budget for the company on the basis of above recommendations:
Proactive Management Consultants Pty Ltd – New Budget – July to December 200X |
||||||
July |
Aug |
Sep |
Oct |
Nov |
Dec |
|
Ordinary Income/Expense |
||||||
Income |
||||||
Reimbursed Expenses |
600.00 |
1,200.00 |
2,000.00 |
– |
700.00 |
500.00 |
Sales |
61,200.00 |
42,000.00 |
57,400.00 |
69,020.00 |
29,285.71 |
45,000.00 |
Service |
– |
100.00 |
400.00 |
– |
200.00 |
– |
Total Income |
61,800.00 |
43,300.00 |
59,800.00 |
69,020.00 |
30,185.71 |
45,500.00 |
Expense |
||||||
Bank Service Charges |
50.00 |
50.00 |
50.00 |
50.00 |
50.00 |
10.00 |
Books and Publications |
100.00 |
100.00 |
100.00 |
100.00 |
100.00 |
20.00 |
Dues and Subscriptions |
50.00 |
50.00 |
50.00 |
50.00 |
50.00 |
50.00 |
Expensed Equipment |
500.00 |
500.00 |
12,000.00 |
500.00 |
500.00 |
500.00 |
Advertising |
2,000.00 |
2,000.00 |
500.00 |
16,000.00 |
500.00 |
– |
Insurance |
10,000.00 |
1,000.00 |
1,000.00 |
1,000.00 |
1,000.00 |
1,000.00 |
Finance Charge |
100.00 |
10.00 |
10.00 |
10.00 |
10.00 |
10.00 |
Loan Interest |
5,000.00 |
3,300.00 |
3,300.00 |
3,300.00 |
3,300.00 |
3,300.00 |
Licenses and Permits |
700.00 |
– |
– |
700.00 |
– |
– |
Motor Expense |
9,000.00 |
2,570.00 |
1,200.00 |
2,000.00 |
2,570.00 |
2,000.00 |
Office Supplies |
150.00 |
150.00 |
150.00 |
150.00 |
150.00 |
150.00 |
Payroll Expenses |
25,000.00 |
25,000.00 |
32,500.00 |
42,250.00 |
25,000.00 |
25,000.00 |
Postage and Delivery |
20.00 |
20.00 |
20.00 |
20.00 |
20.00 |
20.00 |
Printing and Reproduction |
1,000.00 |
350.00 |
150.00 |
150.00 |
1,000.00 |
150.00 |
Accounting Fees |
– |
1,200.00 |
– |
– |
1,200.00 |
– |
Legal Fees |
– |
– |
1,200.00 |
– |
– |
– |
Recruitment & Training |
– |
10,500.00 |
– |
– |
500.00 |
18,000.00 |
Rent |
1,200.00 |
1,200.00 |
3,500.00 |
3,500.00 |
3,500.00 |
3,500.00 |
Repairs |
300.00 |
300.00 |
– |
300.00 |
300.00 |
– |
Software Expense |
300.00 |
60.00 |
60.00 |
60.00 |
60.00 |
60.00 |
Stamp Duty |
100.00 |
100.00 |
100.00 |
100.00 |
100.00 |
100.00 |
Telephone |
100.00 |
100.00 |
100.00 |
100.00 |
100.00 |
100.00 |
Travel & Ent |
1,500.00 |
1,000.00 |
100.00 |
1,500.00 |
1,500.00 |
100.00 |
Utilities |
250.00 |
250.00 |
– |
250.00 |
250.00 |
– |
Total Expense |
57,420.00 |
49,810.00 |
56,090.00 |
72,090.00 |
41,760.00 |
54,070.00 |
Net Income (EBIT) |
4,380.00 |
(6,510.00) |
3,710.00 |
(3,070.00) |
(11,574.29) |
(8,570.00) |
Opening Balance |
51,200.00 |
49,260.00 |
48,700.00 |
55,904.00 |
49,516.00 |
39,377.43 |
Receipts |
55,480.00 |
49,250.00 |
63,294.00 |
65,702.00 |
31,621.43 |
39,714.29 |
Payments |
57,420.00 |
49,810.00 |
56,090.00 |
72,090.00 |
41,760.00 |
54,070.00 |
Closing Balance |
49,260.00 |
48,700.00 |
55,904.00 |
49,516.00 |
39,377.43 |
25,021.71 |
Question 5.
Actual Vs Budgeted |
||||||
July |
Aug |
Sep |
Oct |
Nov |
Dec |
|
Sales |
||||||
Actual |
59,000.00 |
44,100.00 |
46,000.00 |
51,600.00 |
47,000.00 |
67,000.00 |
Budgeted (revised) |
61,200.00 |
42,000.00 |
57,400.00 |
69,020.00 |
29,285.71 |
45,000.00 |
Deviation |
(2,200.00) |
2,100.00 |
(11,400.00) |
(17,420.00) |
17,714.29 |
22,000.00 |
Expenditure |
||||||
Actual |
57,537.00 |
41,200.00 |
49,490.00 |
65,890.00 |
68,880.00 |
78,680.00 |
Budgeted (revised) |
57,420.00 |
49,810.00 |
56,090.00 |
72,090.00 |
41,760.00 |
54,070.00 |
Deviation |
117.00 |
(8,610.00) |
(6,600.00) |
(6,200.00) |
27,120.00 |
24,610.00 |
Conclusion
On the basis of above analysis, it can be concluded that budgeting is that process which is required to be modified as per the changes made. Organization must critically analyse such changes and added them to the budgets time to time. Proactive Management’s budget has been changed according to the circumstances in order to improve the overall performance of the company.
References
Alhabeeb, M.J. 2014. Entrepreneurial Finance: Fundamentals of Financial Planning and Management for Small Business. John Wiley & Sons.
Atkinson, A. and Messy, F.A., 2012. Measuring financial literacy.
ATO. 2018. GST. [Online]. Available at: https://www.ato.gov.au/Business/GST/ [Accessed on: 24 Jan 2018].
Boone, L.E. and Kurtz, D.L. 2011. Contemporary Business. John Wiley & Sons.
Brose, M.S., Flood, M.D., Krishna, D. and Nichols, B. eds., 2014. Handbook of Financial Data and Risk Information I (Vol. 1). Cambridge University Press.
Business.gov.au. (2017). Workplace health & safety. [online] Available at: https://www.business.gov.au/info/run/workplace-health-and-safety [Accessed 24 Jan. 2018].
Corones, S.G., 2014. Competition law in Australia. Thomson Reuters Australia, Limited.
Gahan, P., Sievewright, B. and Evans, P. (2014). WORKPLACE HEALTH AND SAFETY, BUSINESS PRODUCTIVITY AND SUSTAINABILITY. [online] Safeworkaustralia.gov.au. Available at: https://www.safeworkaustralia.gov.au/system/files/documents/1702/workplace-health-safety-business-productivity-sustainability.pdf [Accessed 24 Jan. 2018].
Globalnegotiator. 2017. Wafsaw convention. [Online]. Available at: https://www.globalnegotiator.com/international-trade/dictionary/warsaw-convention/ [Accessed on: 24 Jan 2018].
Harris, P. and Mongiello, M. 2012. Accounting and Financial Management. Routledge.
Hopwood, D. and Thompson, S. 2006. Workplace Safety: A Guide for Small and Midsized Companies. John Wiley & Sons.
Lester, S., Mercurio, B. and Bartels, L. eds., 2016. Bilateral and regional trade agreements: Commentary and analysis (Vol. 1). Cambridge University Press.
Localmanagement. 2017. Introduction to Implementation and Monitoring. [Online]. Available at: https://www.localmanagement.eu/index.php/mue25:mue_implementation [Accessed on: 14 August 2017].
Malik, M.A.R., Butt, A.N. and Choi, J.N., 2015. Rewards and employee creative performance: Moderating effects of creative self?efficacy, reward importance, and locus of control. Journal of Organizational Behavior, 36(1), pp.59-74.
Moses, M.L., 2017. The principles and practice of international commercial arbitration. Cambridge University Press.
Schlick, C.M. ed., 2009. Industrial Engineering and ergonomics: visions, concepts, methods and tools festschrift in honor of Professor Holger Luczak. Springer Science & Business Media.
WTO. 2018. What is the WTO? [Online]. Available at: https://www.wto.org/english/thewto_e/whatis_e/whatis_e.htm [Accessed on: 24 Jan 2018].