ACC501 Internal Control Bank Reconciliation
You are a financial accountant at ABC Ltd, a large manufacturing company. Your boss comes to you, and tells you that he is on a cost-cutting mission. He understands the importance of your role in preparing the company’s general purpose financial reports for shareholders and other stakeholders... and that these reports are required by law... so your job is safe. However, he tells you that he is thinking of not replacing the current management accountant who resigned last week. You are quite concerned by this plan, as you know how valuable management accountants are. He leaves your office before you get a chance to present your views.
Required:
Prepare a memo to respond to your boss, explaining the role and importance of management accountants, and how the reports and information prepared by management accountants differs to the general purpose financial reports that you prepare.
Decision making in accounting
You are the management accountant at Bakery Delights Ltd, a business that owns 126 bakeries across Australia. The directors have asked you to undertake some research into cloud based management accounting... they have heard the term ‘cloud based management accounting’ used, but don’t really know what it means. They would also like to know about the potential benefits and risks of moving to a cloud based management accounting system.
Required:
Prepare a business report (as if for the directors of the company) on cloud based management accounting.Note: You must reference using the APA referencing format, and include a reference list at the end of your report.
Cost volume profit (CVP) analysis
During July, Heavenly Hair Salon gave 2,000 haircuts, at a price of $34 per haircut. Fixed costs for the salon are $21,000 per month, and variable costs are 60% of sales.
Required:
- i) What is the number of haircuts that Heavenly Hair Salon must complete each month to (a) break even, and (b) make a target net income of $12,000? What net income did Heavenly Hair Salon make for July?
- ii) Create a CVP chart in Excel to show the results of your analysis. Show the data area, and clearly label your CVP chart.
iii) In two months time, Heavenly Hair Salon will need to increase the wages paid to its employees due to an increase in the minimum award rates. The increase will cause variable costs to increase from 60% to 65% of sales. The owner of the hair salon would like to know how the wage rise will impact the number of haircuts needed each month to (a) break even, and (b) make a target net income of $12,000.
Decision making
Use this page for your survey.
Suppose you're on a TV game show, and you're given the choice of three doors. Behind one door is a brand new car, behind the others, nothing. You pick a door. The TV host, who knows what's behind the doors, chooses another door and opens it to show you that it has nothing. Should you change your decision.
Required:
- i) Suppose you're on a TV game show, and you're given the choice of three doors. Behind one door is a brand new car, behind the others, nothing. You pick a door. The TV host, who knows what's behind the doors, chooses another door and opens it to show you that it has nothing. Should you change your decision?
Don’t think about this too deeply just yet. Do you feel (intuit?) that you should change your choice? Answer initially without researching the question. What is the thinking behind your answer?
Conduct a survey of ten of your friends/colleagues to give their opinion. You may wish to provide them with a copy of the problem. Prepare a table in Excel, setting out the results of your survey. Also create a simple chart in Excel to present the results of your survey.
- ii) After you answer the first part of this question, search the Internet for the Monty Hall problem. Provide your own explanation of the correct answer. Why do so many people get the wrong answer Did you.
A man goes to see his medical doctor to find out whether or not he has a deadly disease. The test is positive. The test is 98% accurate and one in one thousand men of his age has this disease. What is the probability he has the disease? When this question was put to a group of student doctors, 80% of them answered “98%”. He now plans to sell up all his assets, quit his job on the spot and live in Bora Bora in the time he has left. Is this a rational decision? Explain. (Hint: research conditional probability)
Suppose an urn contains 100 marbles, 65 red and 35 black. A marble is drawn at random from the urn and you are asked to guess what colour you believe the marble to be. The marble is then shown, replaced, and the urn's contents again randomised. The aim is to maximise the number of correct guesses. Before reading any further, what strategy would you employ? What would you guess?
Assume that 5 red marbles come out in a row. What would your next guess be? Why? Include a brief discussion of the gambler's fallacy (Monte Carlo fallacy).
After working through the above scenarios, what does this tell you about the rationality of human decision making? What lessons can managers learn from these scenarios and apply when making business decisions?
Relevant information and special decisions
Miya Manufacturing Ltd has four operating divisions. During the first quarter of 2018, the company reported a total profit from operations of $120,000 and the following division results:
Division | ||||
1 |
2 |
3 |
4 | |
Sales |
$490 000 |
$410 000 |
$200 000 |
$300 000 |
Variable expenses |
230 000 |
240 000 |
220 000 |
240 000 |
Fixed expenses |
130 000 |
90 000 |
40 000 |
90 000 |
Profit/(loss) from operations |
$130 000 |
$80 000 |
($60 000) |
($30 000) |
The directors are very concerned about divisions 3 and 4, and are considering discontinuing one or both of them. The directors make the comment: ‘if divisions 3 and 4 are eliminated, total profits would increase by $90,000.’
If division 3 is discontinued, $20,000 of the division’s fixed costs would be eliminated. If division 4 is discontinued, $45,000 of the division’s fixed costs would be eliminated.
If both division 3 and division 4 are discontinued, there would be enough idle space to open a new division – a division that the directors have previously considered, but haven’t had the space available to open it. If this new division is opened, the directors estimate that it could generate $65,000 in sales, generate a 20% contribution margin percentage, and have additional avoidable fixed costs of $5,000.
Required:
What course of action do you recommend the directors take for division 3 and division 4? Should they close division 3 or division 4? Alternatively, should they close both division 3 and division 4, and open the new division? Show calculations to support your recommendations.
Answer:
Question 1- internal control bank reconciliation
- Bank reconciliation statement
Bargain Buys ltd | ||||
Bank Reconciliation as at 31 July 2018 | ||||
Cash balance as per bank Statement |
25,720.92 | |||
Add: | ||||
Outstanding Deposits |
1190.4 | |||
Bank fees |
60 | |||
1482 |
unrecorded cheque payments |
475.5 | ||
1485 |
recording error |
90 | ||
27,536.82 | ||||
Less: | ||||
Unpresented Cheques |
Cheque amount | |||
1470 |
410 | |||
1474 |
1027 | |||
1478 |
538 | |||
1481 |
807 | |||
1483 |
2360 | |||
1484 |
832 | |||
1486 |
972 |
6946.6 | ||
interest received |
148.62 | |||
Recording receipt errors |
1009 | |||
Unrecorded receipts |
2423 | |||
Balance as per cash book |
17,009.6 | |||
- Journal entries
account title |
debit |
credit |
Cash |
149 | |
interest income |
148.62 | |
Cash |
2423 | |
account receivable |
2423 | |
cash |
1000 | |
account receivabble |
1000 | |
cash |
9 | |
account receivable |
9 | |
bank fees expense |
60 | |
cash |
60 | |
account payable |
476 | |
cash |
475.5 | |
account payable |
90 | |
cash |
90 |
bank ledger account | |||
Debit |
Credit | ||
Details |
amount |
details |
amount |
Balance |
$ 17,009.60 | ||
interest income |
$ 148.62 |
bank fees expense |
$ 60.00 |
account receivable |
$ 2,423.00 |
account payables |
$ 475.50 |
account receivable |
$ 1,000.00 |
account payables |
$ 90.00 |
account receivable |
$ 9.00 |
account payables | |
$ 19,964.72 | |||
$ 20,590.22 |
$ 20,590.22 | ||
adjusted balance |
$ 19,964.72 |
Question 2-Internal control
- Internal control over cash
Segregation of duties (Arens, et al., 2012)
The manager inserts the rolls of tickets in machines, removes the tickets, completes the cash count, puts the cash into a safe in the accountant office and takes the cash count sheet to accountant.
The cashiers receives cash, issues tickets and initiates cash count
Doorman receives the ticket confirm it validity, tears the ticket into half deposits one half into a locked box and gives the other to customer before admitting the customer.
Accountant receives cash count sheet, deposit the cash receipts for each week to the bank, and record the cash receipts and banking deposits in an accounting system.
Safeguarding of assets and records
Cash receipts are put into a safe while tickets pieces are stored into a locked box.
Cash receipts are banked every week and recorded in an accounting system.
Internal checks
Several different persons are involved in transaction, handing and counting of cash for example cashiers are checked by manager who is checked by accountant.
Weakness
Depositing of cash at end of each week may expose it theft or pilferage by employees such as accountant.
Internal checks are weak because manager has a huge control over cash and can therefore defraud the company if he wish to.
Suggestion
The company should deposit cash more often to the bank and the manager should have someone to check his tasks. For example the accountant can check the numbers of rolls the manager inserts in the machines and confirm the cash receipts agrees with the half pieces of tickets in the box.
- If the door and cashier decided to collaborate to misappropriate cash the cashier can issue duplicate tickets and the door person could agree not place the half of the duplicate in the box.
Question 3 –Memo
Date: 10/10/2018
To: Manager
From: Financial accountant
Subject: Role and Importance of management Accountants
Whereas financial accounting is concerned with providing information to external user’s management accounting provides very useful information to management or internal users which aid planning, control and decision making processes. Management accounting provides the indispensable information with which organizations are actually run and which affects the performance of the business. On the other hand financial accounting measures the company performance based on past results hence financial accounting measure effectiveness of management accounting role. While the financial accounting is focused on the past results management accounting is more forwarding looking and tries to improve the current decisions so as to realize good future results using the past and current data.
Management accounting focuses on both monetary and non-monetary information that inform management decisions and activities such as planning and budgeting, ensuring efficient use of resources, performance measurement and formulation of business policy and strategy. The role of a management accountant cannot be ignore as help management make decision that maximizes, creates, and protects the wealth/interests of an organization’s stakeholders.
Through planning and budgeting management accounting provides effective business control, because the results are measured and compared to the set targets. Any deviation is identified, investigated and necessary action taken to control it.
The role nad importance management account is equally important as that of the financial accountant despite the role not being a legal requirement. The benefits of management accountant outweighs the cost and I would recommend hiring of a management accountant.
Regards
Financial accountant. (Pant, n.d.)
Question 4 – Decision making in Accounting
Report On cloud based management accounting
This report discusses the cloud based management accounting. The report defines the cloud based management accounting, argues the benefits of using a cloud based management accounting system and critically analysis the risks associated with cloud based management accounting. In addition the report looks at the development and evolution of cloud based management accounting.
Cloud based management accounting is use of remote servers to store data for ease access and processing from anywhere in similar way to the use of software as a service. Cloud computing solutions refers to a structure of computer hardware and software whereby the physical location of data and software doesn’t have to be related to where the end-user will access the data or processes data (Strauss, et al., 2015). Cloud computing technology acts as an enabling solution to management accounting in it decision making role by, improving, facilitating, and or influencing management accounting processes or systems.
Evolution and development of technology is positively affecting the way management accounting is done. Technology advancement in cloud computing has made it easy for management accountant to access and process data for easier decision making. Cloud computing allows sharing of resources among the company users without geographical limitation and at relatively low prices. With modern globalization trends cloud based management accounting is very reasonable system to use for any organization with operations at various different locations. The other reason for increased use of cloud computing in management decision making is the increased use of internet as platform for many transactions including retail, banking, health and working.
Benefits of Cloud based management accounting.
There are several benefits of using a cloud based management accounting solution including the following;
Cost effectiveness
Cloud based management accounting is very cost effective as an organization with different location can share it resources remotely at all it branches without investing physical storage devices. The firm can also avoid software installation on all it computer hence saving costs of installation as cloud based software is accessible through internet or other medium and works well without installing the software on a computer.
The cloud based management accounting has low maintenance costs because the cloud service provider updates the software and backups data automatically without the need to upload updated software to computer manually and also without causing disruptions to operations. The work of It department is also significantly reduced as most of their functions in maintain software is delegated to the cloud service provider. Money is also saved as traditional expenditure in initial server’s infrastructures and software are avoided.
Increased data security
There is misguided perception that cloud based management accounting increases the risk of data security being breached. Cloud based management accounting offers a similarly secure medium of storing management accounting data to the traditional management accounting software and sometimes even more secure. For example an organization computer or storage device with very important management information may break down, crash get lost or even get stolen leading to loss of information. On the other hand information stored in cloud based solution can assessed from other devices even after of devices get lost or breaks down because the information is not stored in a physical device. The data is secured by use of passwords and is encrypted. According to (Strauss, et al., 2015) cloud service providers normally provide more secure services than the traditional solutions.
Ease of access and processing of data
Cloud computing solutions provide management accounting with an easy platform of accessing data from anywhere (Furth, 2017). So many users at different locations can still access data provided they have the required authorization details such as PIN and passwords as opposed to the traditional solutions which required transfer of data or sharing of resources in the same physical location (Kinsella, n.d.).
Cloud based data is backed up to more than one server
This provides the benefits of no disruption to operations when one server is not working as the employees will continue accessing data because cloud services providers usually backs up data to several servers (Anon., n.d.).
Additionally cloud technology improves the management accounting decision making capabilities by increasing the ability of the management to process information effectively.
Risks and limitation of using cloud based management accounting solution.
As with every other solution the cloud computing technology has it shortcomings and decision to use the cloud technology will depend on an entity needs other factors. The major concern with the use of cloud computing technology in management accounting has been security, privacy and integrity of the data stored and processed through cloud technology. Although some has argued that security of data stored in cloud based platforms is more secure than the traditional forms the concern of data security is still high because the control of data is left in the hands of the service provider.
Another limitation of using cloud based management accounting solution is lack of high speed connection in some areas making this solution untenable.
The risk of cyber-attacks and hacking is also a concern for most organisation as this can cause breach of data security, integrity and privacy exposing the organization huge losses.
Another issue with cloud computing legal requirements in some jurisdictions for example in European Union companies are required to store data with the EU region.
The last issue is bankruptcy issues with cloud service provider and cost of transferring the data and cloud service from one vendor to another after bankruptcy of the initial provider.
There also the issue of suck cost as the company will be forced to invest in new solution before the end of economic lives of existing traditional structures.
Question 5
selling Price |
100% |
$ 34.00 |
variable cost |
60% |
$ 20.40 |
Contribution margin |
40% |
$ 13.60 |
Fixed cost |
21000 | |
target income |
12000 |
break even units= fixed cost/ contribution margin= 21000/13.6=1,544.12
- Target income units= (fixed cost + target income)/contribution margin=(21000+12000)/13.6= 2,426.47
July net income $6,200.00
selling Price |
100% |
$ 34.00 |
variable cost |
65% |
$ 22.10 |
Contribution margin |
35% |
$ 11.90 |
Fixed cost |
21000 | |
target income |
12000 |
target income units =21000+12000)/11.9=2,773.11 target unit also increases.
Question 6
Tv game
My decision is Yes because if the TV host had two chances of showing me the door with nothing but he chose one and left the other so it has a probability that it has a car behind.
TV game Survey | |
Friend |
decision |
1 |
No |
2 |
No |
3 |
YES |
4 |
YES |
5 |
YES |
6 |
No |
7 |
YES |
8 |
No |
9 |
YES |
10 |
Yes |
6 out of 10 student got it right. When I originally picked one door the probability of winning was 1/3 but then when the host picked one door form the remaining two his action provide new information that the other door is likely to contain the car because it was not chosen by the host presuming an equal initial probabilities the unchosen door has a probability of 2/3 after host action as the revelation of the other door having nothing increases the probability that the unchosen door has a car (BetterExplined, n.d.).
Many people get it wrong because they fail to recognize that by choosing one door and not the other the host provides new information that the other door is likely to have a car. Simple the two remaining door after My choice have a probability of 2/3 of having a car behind but after revealing that one door has nothing the probabilities of the remaining door increases to (2/3-0) =2/3
I got it right
Condition probabilities | |||
Has disease |
No Disease | ||
Test + |
98 |
198 |
296 |
Test- |
2 |
9702 |
9704 |
Total |
100 |
9900 |
10000 |
probability he has the disease |
33.108% |
This is an irrational decision because the actual probability is much less than he has been made to believe.
- I would pick red as it has a higher probability of being selected 65% compare to blue 35%.
Since the marble are being replaced I would stick to my choice of red to maximize my correct predictions.
Monte Carlo Gambler’s fallacy is the belief that if something happen more frequently in the past or present it is likely to occur less in the future (CROSON & SUNDALI, 2005).
- Using the available information to make management decision and re-evaluating decisions as and when information changes.
Question 7
Close |
division 3 only |
Division 4 only |
Both division 4 &3 and open division |
Contribution margin other divisions |
$ 490,000.00 |
$ 410,000.00 |
$ 430,000.00 |
Fixed costs (current) |
350,000 |
350,000 |
350,000 |
less avoidable fixed costs |
-20000 |
-45000 |
-70000 |
new fixed costs |
330,000 |
305,000 |
280,000 |
new contribution margin |
0 |
0 |
13000 |
New profit |
$ 160,000.00 |
$ 105,000.00 |
$ 163,000.00 |
The management should close both division 3 and 4 to maximize profit.
Question 8
Cash Budget April-June | |||
April |
May |
June | |
Cash Receipts | |||
Cash balance |
3500 |
$ 3,000.00 |
10660 |
Accounts receivables |
$ 19,900.00 |
$ 24,000.00 |
$ 23,400.00 |
Total cash receipts |
$ 23,400.00 |
$ 27,000.00 |
$ 34,060.00 |
Cash payments | |||
Accounts payable |
$ 10,040.00 |
$ 10,300.00 |
$ 11,400.00 |
Wages and salaries |
$ 4,000.00 |
$ 3,800.00 |
$ 4,200.00 |
Gen And admin costs |
$ 1,500.00 |
$ 1,000.00 |
$ 1,500.00 |
Insurance |
$ 4,100.00 |
$ - |
$ - |
income tax |
$ 2,000.00 |
$ - |
$ 14,500.00 |
Total cash payments |
$ 21,640.00 |
$ 15,100.00 |
$ 31,600.00 |
Net cash |
$ 1,760.00 |
$ 11,900.00 |
$ 2,460.00 |
minimum cash balance |
3000 |
3000 |
3000 |
Cash surplus (deficit) |
$ (1,240.00) |
$ 8,900.00 |
$ (540.00) |
cash Borrowing |
$ 1,240.00 |
$ 540.00 | |
Repayment |
$ (1,240.00) | ||
Ending Cash balance |
$ 3,000.00 |
$ 10,660.00 |
$ 3,000.00 |
Question 9 - Variance analysis
Direct material Price variance Actual Quantity x Actual Price - Actual Quantity x Standard Price
$(110.00) favourable
Direct labour rate variance Actual Quantity x Actual rate - Actual Quantity x Standard rate
$(1,200.00) Favourable
Direct material quantity variance Actual Quantity x Standard Price-Standard Quantity x Standard Price
300 Adverse
Direct labour quantity variance Actual Hours x Standard Rate - Standard Hours x Standard Rate
550 Adverse
Question 10
Question 10- Capital budgeting | ||||||||||
Initial cost |
$ 75,000.00 | |||||||||
useful year |
8 | |||||||||
discount rate |
9% | |||||||||
Residual value |
$ 21,000.00 | |||||||||
i) NPV |
Year |
0 |
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
Cash outflow | ||||||||||
Initial cost |
$ (75,000.00) | |||||||||
overhaul |
$ (5,600.00) | |||||||||
Cash inflows | ||||||||||
Towing cash inflows |
$ - |
$ 8,400.00 |
$ 8,400.00 |
$ 8,400.00 |
$ 8,400.00 |
$ 8,400.00 |
$ 8,400.00 |
$ 8,400.00 |
$ 8,400.00 | |
residual value |
$ 21,000.00 | |||||||||
Total cash flow |
$ (75,000.00) |
$ 8,400.00 |
$ 8,400.00 |
$ 8,400.00 |
$ 2,800.00 |
$ 8,400.00 |
$ 8,400.00 |
$ 8,400.00 |
$ 29,400.00 | |
Discounted cash flow |
$ (75,000.00) |
$ 7,706.42 |
$ 7,070.11 |
$ 6,486.34 |
$ 1,983.59 |
$ 5,459.42 |
$ 5,008.65 |
$ 4,595.09 |
$ 14,754.87 | |
NPV |
$ (21,935.51) | |||||||||
Recommendation |
The truck should not be purchased as it has negative NPV |
References
AccountingExplained, 2018. AccountingExplained.
Anon., n.d. Financialforce:What is Cloud Accounting
Arens, A. A., Elder, R. J. & Beasley, M. S., 2012. Auditing and Assurance Services. 14th ed. s.l.:Pearson.
BetterExplined, n.d. Understanding the Monty Hall Problem
CFI, n.d. Bank Reconciliation.
Corporate Finance Institute, 2018. Contribution Analysis.
CPA Australia, 2012. F o u n d a t i o n l e v e l Management Accounting. s.l.:BPP Learning Media Ltd.
CROSON, R. & SUNDALI, J., 2005. The Gambler’s Fallacy and the Hot Hand: Empirical Data from Casinos. The Journal of Risk and Uncertainty, 30(3), p. 195–209.
DeMarzo, P. & Berk, J., 2014. Corporate Finance. 3rd ed. Boston: Pearson.
Dopson, L., 2004. Linking Cost-Volume-Profit Analysis with Goal Value Analysis in the Curriculum Using Spreadsheet Applications. Journal of Hospitality Financial Management, 12(1), pp. 78-80.
Furth, D., 2017. Cloud-Based Accounting Software: What Your Clients Need to Know.
Kinsella, K., n.d. CPA Ireland:HOW CLOUD COMPUTING CAN BENEFIT ACCOUNTANTS.
[Accessed 10 October 2018].
Millians, P. M., 1947. Profit Planning and Budgetary Control. The Accounting Review, pp. 65-68.
Mongiello, M., 2016. Management accounting. London: University of London.
Pant, S., n.d. 7 Roles of Management Accountant
Ross, S. A., Westerfield, R. W. & Jordan, B. D., 2016. Fundamentals of corporate finance. 11 ed. New York(NY): McGraw Hill Education.
Strauss, E., Kristandl, G. & Quinn, M., 2015. The effects of cloud technology on management accounting and decision making, London: Chartered Institute of Management Accountants.
Sybba, et al., 2017. Bayes’ Theorem and Operations Research. Imperial Journal of Interdisciplinary Research, 3(10), pp. 404-412.
THE INSTITUTE OF COMPANY SECRETARIES OF INDIA, 2014. FUNDAMENTALS OF ACCOUNTING AND AUDITING. New Delhi: THE INSTITUTE OF COMPANY SECRETARIES OF INDIA.
The Institute of Cost Accountants of India, 2014. FUNDAMENTALS OF ACCOUNTING. Kolkata: Directorate of Studies The Institute of Cost Accountants of India (ICAI).
Buy ACC501 Internal Control Bank Reconciliation Answers Online
Talk to our expert to get the help with ACC501 Internal Control Bank Reconciliation Answers to complete your assessment on time and boost your grades now
The main aim/motive of the management assignment help services is to get connect with a greater number of students, and effectively help, and support them in getting completing their assignments the students also get find this a wonderful opportunity where they could effectively learn more about their topics, as the experts also have the best team members with them in which all the members effectively support each other to get complete their diploma assignments. They complete the assessments of the students in an appropriate manner and deliver them back to the students before the due date of the assignment so that the students could timely submit this, and can score higher marks. The experts of the assignment help services at urgenthomework.com are so much skilled, capable, talented, and experienced in their field of programming homework help writing assignments, so, for this, they can effectively write the best economics assignment help services.