Question

In: Accounting

Background You are a manager in the audit division at Miller Yates Howarth (MYH), an accounting...

Background
You are a manager in the audit division at Miller Yates Howarth (MYH), an accounting firm with offices throughout the major regional centres of NSW and Queensland. Although a medium sized firm by national standards, MYH is the second largest regional accounting firm in Australia. Most of MYH’s audit clients are in the agriculture, mining, manufacturing and property industries. All of those industries are currently under pressure, either from a downturn in commodity prices or fierce competition from overseas competitors.

You are gathering information to prepare the audit plan of Big Machine Limited (BML), a company that leases and services large mining machinery to several of the gold mines in the region. The following information has been gathered to date.

Principle activities of BML:
• mining machine leasing, mainly to gold, coal and iron ore miners.
• machine maintenance, and
• contracting machine operators to the mines.

BML was incorporated as a private company in 1979 importing and maintaining mining equipment. It survived the downturn in mining in 1982/3 operating profitably as a private company until the current mining boom began in 2005. At that point the directors decided that the company needed an injection of funds enabling the company to capitalise on the need for extensive new machinery in the mining sector. A combination of share issue and bank finance provided the capital to expand and update the machines that BML could offer the industry.

The directors are:
• Mr. Matthew Collins, Chairman
• Mr David Long, Chief Executive Officer
• Ms Cynthia Brown
• Mr Brent Allen
• Mr Patrick Singh

Mr Brent Allen and Mr Patrick Sing are independent, non-executive directors and have been directors since 2010. Mr David Long was recently hired as CEO, coming to the firm with extensive experience in the mining industry. The other two executive directors were employed by the company prior to its public share issue.

MYH has placed reliance on most internal controls based on satisfactory results of extensive tests of control. Recent discussion with the client revealed that there have been changes to the systems and software used to record and pay contractors. No other changes to the internal control system have been made since the last audit when the permanent file was updated. In past audits reliance had been placed on the internal controls thus reducing the amount of substantive testing.

Over the past 18 months there has been a decline in the demand for the machinery already owned and an increased demand for computer controlled equipment and for contract staff to maintain this equipment. As a result, BML has had to increase borrowings to finance the new equipment required.
You have walked around the main warehouse and yard and noticed that there are several large used mining machines standing idle in the yard.

Ms Leanne Hopkins, the audit partner for BML, has identified several areas she is concerned about and wants you to report back to her about these before you complete the audit program. She has advised you about a few changes in the metals market that may have an impact on BML’s operations. The metals market has fluctuated with:
• gold dropping 24.95% since 2012 but has risen 9.25% over the past year
• Iron ore dropping 43.78% since 2012 and dropping 9.71% in the past year
• coal rising 9.99% since 2012 and rising 18.35% in the past year.

The areas and accounts are:

• Plant and equipment
• Machinery Finance Liabilities
• Accounts Receivable
• Lease income

Ratios extracted from an unaudited set of financial reports at 31 December 2017 together with audited comparatives for the year ended 31 December 2016 and the industry averages are set out below for your review.

Ratio 2017 (Unaudited) 2016 (Audited) Industry average
Return on equity % 15 22 26
Profit/lease income % 8 12 No data
Return on total assets % 14 17 20
Gross margin % 25 25 30
Net profit margin % 14.5 18.5 20.27
Times interest earned 1.90 3.51 4.10
Days in accounts receivable 62 53 45
Current ratio : 1 1.02 1.54 1.66
Quick asset ratio : 1 0.70 0.78 0.82
Debt to equity ratio : 1 1.05 1.35 1.50

Internal Controls

The Financial Controller for BML has provided you with the latest internal control manual which includes details of the controls over contract payments. As the system is new you also walk through the system checking that the walkthrough matches the information in the internal control manual. Details of the controls over contract payments your walkthrough are listed below:

BML tenders for a contract to operate a set of machines at a set price over a certain period. When the contract is accepted an accounts receivable account is set up by the accountant responsible for the contracts and a payroll account set up for the employee who will do the work.
The payroll clerk demonstrates the set up of the payroll account entering a supper user name and password specifically set up for the walk through.
The menu screen appears and displays many functions. The clerk selects the ‘add new employee’ function.
You are advised that the details can only be entered from a hard copy form signed by the employee and the contracts manager and a signed income tax instalment declaration form.

The clerk then enters the following information:
• employee name
• employee number
• contract number
• employee address
• employee phone number
• employee email
• start date
• employee date of birth
• employee tax file number
• hourly rate
• general exemption from tax Y/N

The fictitious employee is now set up in the system. The clerk goes back to the main screen and clicks the item ‘enter hours’ and explains that the employee can enter their own hours but that this must be approved by the contracts manager before the pay-run can be processed. The clerk then approves the hours.


Then the clerk selects ‘process pay-run’ and explains that the system automatically calculates the monthly payments based on hourly rate and the current tax rate. The system also calculates the superannuation accrual for the employee.
The system then generates a standard report entitled ‘monthly pay-run’ that lists the employees, their payments and the total tax paid. This report is then approved by the contracts manager who then, in a live pay run, uploads the Australian Bankers Association (ABA) file to the bank. The pay-run is automatically posted to the general ledger on approval by the contracts manager.

The contracts manager's bank login gives him the rights to approve processing of payments on the bank website. The bank account is reconciled monthly by the accountant who also has a bank login that gives him the right to approve processing of payments on the bank website. Other regular payments through the bank account occur on a weekly basis when the accountant uploads the ABA creditors payment file to the bank and apporves it for processing.


You note that the contracts payroll can be checked to the contracts accounts receivable by deducting from the accounts receivable amount the standard mark-up on the contracts.

Required:

Write a report, including a brief executive summary, to your managing partner that address the questions below. Where indicated use the following format to answer the question.

Question 1 A 8%
Analyse the ratios and the additional information associated the with four accounts listed by your audit partner, Ms Leanne Hopkins. Identify the potential audit risks and any related audit steps that need to be undertaken to reduce audit risk.
Respond to this part of the assignment using this format:

Account Analysis Audit Risk Audit steps to reduce risk
Plant and Equipment
Machinery Finance Liabilities
Accounts Receivable
Lease income

Question 1B 2%
Analyse the ratios and additional information to outline the business risks that BML faces.

Question 2A 7%
Identify the internal controls in the system that are potentially effective, the risk that the control could alleviate and one test of control for each of the identified potentially effective controls.
Answer this question using the following headings in a table format:

Control Risk alleviated Test of control

Question 2B 2%
List and identify the weaknesses in internal control for contract payroll.

Solutions

Expert Solution

1A
Account Analysis Audit Risk Audit steps to reduce risk
Plant and Equipment Return on total assets is lower than industry average and decreasing year on year

Return on equity is also lower year on year and also lower as compared to industry average

Also the mining market has recovered although not to the rates on the assumption of which the machines were purchased thus that is one of the reasons due to which return is lower
- Risk of obsolence/impairment of assets
- Potential inefficiency in utilisation of assets
- review the asset register to ensure depreciation rates are in line with law and business scenario
- Take independent expert's assessment on impairment
- Review the utilisation and consumption ratios of assets
Machinery Finance Liabilities Debt equity ratio has improved signifying debt reduction.
DE is lower than industry average which states that industry is taking on debt for growth and upgradation of machinery
- Loss of market share due to not taking up debt for upgradation
- Non fulfillment of financial liabilities
- Review board minutes to identify any opportunities explored for taking up additional debt for upgradation

- review loan register and bank book to ensure payments are made on a timely basis. Also check whether any penal interest etc. are being paid or not

- Also review whether loan covenants are being complied or not

- Review the working capital to see whether there is any financial crunch or not due to shortage of funds
Accounts Receivable Accounts receivable days have increased significantly implying delay in payments

Quick assets ratio has also reduced y-o-y which signifies reduction in liquidity and is lower than industry average
- Bad debts and delay in payments
- Loss of customers
- Working capital constraints
- Review the debtors ageing
- Review the working capital cycle and the trend
- Review the bad debts provision and its adequacy
Lease income Times interest earned has reduced year on year
Though gross margin is same, due to higher interest liabilities compaerd to income the net profit has reduced

Profit / Lease income % has also reduced which shows higher interest liabilities compaerd to income the net profit has reduced
- Lease income not being priced as per market standards or as per original estimates due to old machinery

- Opportunities for increasing lease rates not explored
- review pricing of lease charges to ensure it is as per plan and in line with market and with adequate approvals

Review whether increasing of lease rentals has been explored or not within the management and with the customers
1B
Particulars Description
Business Risks Risk of adverse metal price movements
Risk of loss of customer due to competition
Risk of fluctuating interest rates and currency movements
Risk of obsolence of machinery
2A
Control Risk alleviated Test of control
Access only to Payroll Clerk Creation of fictitious employees - Physical check of employees
- Test check employee files
- Check user access rights report
Approval of contract manager on hard copy Unauthorised creation of employee - Review hard copies of employee files for employee IDS created
Approval of hours by contract manager and payroll clerk Unathorised updation of attendance - Review time and attendance sheet with hours in the system
Segregation of duty - payroll processing by clerk and payment by contract manager Creation of fictitious employees
Unauthorised payment through payroll
- Check transaction log
Bank Account reconciliation by independent person - accountant Detective control around bank accounts - Check bank reconciliations for sample months
Auto mapping with the contracts receivable for billing with the decided mark up Risk of short billling to customers - Check contracts with actual attendance and billing
2B Weaknesses in the system
1 Bank Account of employee is updated without a bank confirmation
2 Lack of a maker checker in case of creation of employee
3 Lack of segregation between operations and finance i.e. contract manager processing payments whereas the same should be done by finance

Related Solutions

Background You are a manager in the audit division at Miller Yates Howarth (MYH), an accounting...
Background You are a manager in the audit division at Miller Yates Howarth (MYH), an accounting firm with offices throughout the major regional centres of NSW and Queensland. Although a medium sized firm by national standards, MYH is the second largest regional accounting firm in Australia. Most of MYH’s audit clients are in the agriculture, mining, manufacturing and property industries. All those industries are currently under pressure, either from a downturn in commodity prices or fierce competition from overseas competitors....
Background You are a manager in the audit division at Miller Yates Howarth (MYH), an accounting...
Background You are a manager in the audit division at Miller Yates Howarth (MYH), an accounting firm with offices throughout the major regional centres of NSW and Queensland. Although a medium sized firm by national standards, MYH is the second largest regional accounting firm in Australia. Most of MYH’s audit clients are in the agriculture, mining, manufacturing and property industries. All of those industries are currently under pressure, either from a downturn in commodity prices or fierce competition from overseas...
Background You are a manager in the audit division at Miller Yates Howarth (MYH), an accounting...
Background You are a manager in the audit division at Miller Yates Howarth (MYH), an accounting firm with offices throughout the major regional centres of NSW and Queensland. Although a medium sized firm by national standards, MYH is the second largest regional accounting firm in Australia. Most of MYH’s audit clients are in the agriculture, mining, manufacturing and property industries. All of those industries are currently under pressure, either from a downturn in commodity prices or fierce competition from overseas...
Task Background You are a manager in the audit division at Miller Yates Howarth (MYH), an...
Task Background You are a manager in the audit division at Miller Yates Howarth (MYH), an accounting firm with offices throughout the major regional centres of NSW and Queensland. Although a medium sized firm by national standards, MYH is the second largest regional accounting firm in Australia. Most of MYH’s audit clients are in the agriculture, mining, manufacturing and property industries. All those industries are currently under pressure, either from a downturn in commodity prices or fierce competition from overseas...
You are a manager in the audit division at Miller Yates Howarth (MYH), an accounting firm...
You are a manager in the audit division at Miller Yates Howarth (MYH), an accounting firm with offices throughout the major regional centres of NSW and Queensland. Although a medium sized firm by national standards, MYH is the second largest regional accounting firm in Australia. Most of MYH’s audit clients are in the agriculture, mining, manufacturing and property industries. All those industries are currently under pressure, either from a downturn in commodity prices or fierce competition from overseas competitors. Ratios...
You are a manager in the audit division at Miller Yates Howarth (MYH), an accounting firm...
You are a manager in the audit division at Miller Yates Howarth (MYH), an accounting firm with offices throughout the major regional centres of NSW and Queensland. Although a medium sized firm by national standards, MYH is the second largest regional accounting firm in Australia. Most of MYH’s audit clients are in the agriculture, mining, manufacturing and property industries. All of those industries are currently under pressure, either from a downturn in commodity prices or fierce competition from overseas competitors....
You are a manager in the audit division at Miller Yates Howarth (MYH), an accounting firm...
You are a manager in the audit division at Miller Yates Howarth (MYH), an accounting firm with offices throughout the major regional centres of NSW and Queensland. Although a medium sized firm by national standards, MYH is the second largest regional accounting firm in Australia. Most of MYH’s audit clients are in the agriculture, mining, manufacturing and property industries. All of those industries are currently under pressure, either from a downturn in commodity prices or fierce competition from overseas competitors....
You are a manager in the audit division at Miller Yates Howarth (MYH), an accounting firm...
You are a manager in the audit division at Miller Yates Howarth (MYH), an accounting firm with offices throughout the major regional centres of NSW and Queensland. Although a medium sized firm by national standards, MYH is the second largest regional accounting firm in Australia. Most of MYH’s audit clients are in the agriculture, mining, manufacturing and property industries. All those industries are currently under pressure, either from a downturn in commodity prices or fierce competition from overseas competitors. Ratios...
You a member of the audit team at Miller Yates Howarth (MYH), an accounting firm with...
You a member of the audit team at Miller Yates Howarth (MYH), an accounting firm with offices throughout the major regional centres of NSW and Queensland. Although a medium sized firm by national standards, MYH is the second largest regional accounting firm in Australia. Most of MYH’s audit clients are in the agriculture, mining, manufacturing and property industries. All those industries are currently under pressure, either from a downturn in commodity prices or fierce competition from overseas competitors. MYH have...
You a member of the audit team at Miller Yates Howarth (MYH), an accounting firm with...
You a member of the audit team at Miller Yates Howarth (MYH), an accounting firm with offices throughout the major regional centres of NSW and Queensland. Although a medium sized firm by national standards, MYH is the second largest regional accounting firm in Australia. Most of MYH’s audit clients are in the agriculture, mining, manufacturing and property industries. All those industries are currently under pressure, either from a downturn in commodity prices or fierce competition from overseas competitors. MYH have...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT