Great Deal! Get Instant $10 FREE in Account on First Order + 10% Cashback on Every Order Order Now

Task back to top 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...

1 answer below »

Task

back to top

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. Ratios extracted from an unaudited set of financial reports at 30 June 2018 together with audited comparatives for the year ended 30 June 2017 and 2016 are set out below for your review.

You are gathering information to prepare the audit plan of Trunkey Creek Wines Limited for the year ended 30 June 2018. Trunkey Creek Wines (TCW) is one of MYH’s most significant and longstanding clients. The following information has been gathered to date.

Principal activities of TCW
• growing grapes for wine production;
• production and distribution of red, white and sparkling wines;
• beef cattle production on land surplus to grape production; and
• investment of surplus funds.

TCW was originally a family company incorporated in 1968 and has operated successfully and profitably since that date. In the 1990’s shares were sold to a small number of investors to increase funds for the development and upgrading of the winery and the purchase of additional land for the vineyards. Insufficient rainfall had meant that some land was no longer suitable for wine grape production, as a result, TWC moved into Wagyu beef cattle production on this surplus land. The Wagyu operation is now starting to return a profit.

TWC now find that the 2 degrees increase in temperature at some vineyards is affecting the production of sparkling wine and are now looking at purchasing land in cooler climates. TWC has built up a strong following for their sparkling wine which earns significant profits in both domestic and overseas markets. TWC are currently negotiating the land purchase and part funding in part from medium term bank loans. The remaining purchase price will be sourced from surplus funds.

The Wagyu beef is sold through the Wagyu Selling Group (WSG) in which TWC has shares. These shares form a material part of TWC’s investment portfolio. WSG buys, butchers and sells the Wagyu beef to high end domestic restaurants and regularly sends frozen shipments to Japan and China. TWC are heavily marketing their pinot, both domestically and overseas, as a perfect accompaniment to the Wagyu beef.

The directors of TCW are:

  • Mrs Claire Harewood, Chairman. Mrs Harewood has significant experience in the industry and replaced her husband as chair when he died 10 years ago.
  • Mr Phillip Strange, Chief Executive Officer
  • Mr. Joe Quade
  • Mr Steven Harewood, son of Claire Harewood and has oversight of the Wagyu beef operation
  • Dr Mary Owens
  • Ms Hilary Jones
  • Mr Geoffrey Owens

Your audit partner, John Richards, has approached you and advised that there are several areas he is concerned about and he wants to you to report back to him about these areas before you complete your audit program. These areas and accounts are:
• Accounts receivable
• Investments
• Property assets
• Marketing expense

Ratio

2018 (Unaudited)

2017 (Audited)

2016 (Audited)

Return on equity %

10.80

17.5

15.2

Return on beef production assets %

1.67

-0.82

-3.45

Return on grape and wine production assets %

12.2

14.5

16.2

Gross margin %

24.5

30.00

31.76

Net profit margin%

14.38

20.27

17.85

Marketing expense % of total S & A expenses

23.67

17.89

15.2

Times interest earned

6.67

7.51

8.10

Days in inventory - wine

367

423

460

Days in accounts receivable - wine

50.2

60.65

53.24

Days in accounts receivable - beef

57

36

24

Current ratio:1

2.80

2.54

2.66

Quick asset ratio:1

1.18

1.15

1.20

Debt to equity ratio:1

0.54

0.63

0.67


Internal control

The financial controller at TCW has been refining the system of internal controls and informs you, at the planning stage of the current year's audit, that he has put together an internal control manual for the company. He has stated that this manual will create greater awareness of controls in the company, particularly with management which, in the past, has not been overly conscious of the need to implement and enforce effective internal controls.

Management staff receive bonuses based on certain agreed-upon target ratios which include measures such as targeted monthly sales volumes, variance of actual to budget departmental overheads and profit before interest and tax. The Board takes an active interest in the performance of the company and is quick to request explanations on variances from the agreed-upon monthly budgets.

Two years ago, the company devoted significant time and resources to the development and implementation of a new IT system. All teething problems associated with the implementation phase have now been resolved, and the financial controller is satisfied that the automated controls in place are assisting in producing accurate and complete accounting records. The management accountant also looks after the IT function as the position is not regarded by management as being a full-time job. Once application programs have been tested, strict password control exists over access to the programs. Passwords are not required for access to databases.

To assist in the planning for the current year's audit engagement, you extracted the following information from a review of the systems notes in the permanent file and a perusal of the new internal control manual:

  • There are three section managers, one each for grape production, wine production and beef production. Each can order supplies for their respective operations up to a limit of $10,000 for each order. Orders between $10,000 and $30,000 must be approved by the management accountant. Orders over $30,000 must be approved by the CEO. Orders over $50,000 must be approved by the Board.
  • Orders must be made through the computer ordering system which has direct links to the approved suppliers.
  • Supplier information is contained in a supplier master file. Each supplier has a unique supplier code. If a section manager orders from an unapproved supplier, the order is rejected and sent to the management accountant for approval.
  • The supplier information file is maintained by the accounts clerk. Changes to the file are approved manually by the management accountant.
  • When supplies are received at the winery, the storeman checks the supplies received to the online copy of the order and the delivery docket provided by the supplier. Any discrepancies are noted on the online copy of the order.
  • The delivery docket is filed by the storeman in a folder that is kept at the winery.
  • The invoice is received electronically from the supplier and matched to the order by the accounts clerk. If the order and the invoice match the invoice is included in a payments file.
  • The payments file is approved online by the management accountant once a week and used to generate an ABA file which is then uploaded to the bank by the management accountant.
  • When the payments file is approved by the management accountant, the invoice is automatically recorded as being paid in the accounting system.
  • When services such as repairs are ordered for the winery by the wine production manager, a service order is generated within the computer system and automatically sent to the service provider.
  • When the service has been delivered, the wine production manager or the storeman signs the service delivery docket on the service man’s tablet.
  • The invoice from the service company, with a copy of the signed service delivery docket, is received online by the accounts clerk.
  • The accounts clerk checks the signed service delivery docket to the invoice and the order and adds the invoice to the payments file for final approval by the management accountant.
  • In the case of discrepancies, the accounts clerk contacts the supplier and the wine production manager to resolve the issue. Payments are not made until the issue has been resolved.


Required

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

Question 1A 8%
Analyse the ratios and additional information associated with the four accounts listed by your audit partner, John Richards. Identify the potential audit risks and any audit steps that need to be undertaken to reduce audit risk.
Answer this question using the following table:

Account

Analysis

Audit Risk

Audit Steps to reduce risk



















Question 1B 2%
Analyse the ratios and additional information to outline business risks that TWC 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:

Effective control

Riskalleviated

Test of control






Question 2B 2%
List and justify the weaknesses in internal control for purchases and accounts payable.

Weakness

Justification




Rationale

back to top

This assessment task will assess the following learning outcome/s:

  • be able to demonstrate risk management methodologies and the role of internal controls in an audit context.
  • be able to design an audit plan and select and apply appropriate audit procedures for a financial statement audit.
  • be able to exercise critical and reflective judgement and appreciate the value of ethical practice.

Marking criteria and standards

back to top

Criteria


High Distinction

Distinction

Credit

Pass

Question 1





Analysis of ratios and other information demonstratingauditrisk assessment skills and critical and reflective judgement (4 marks).

Correct interpretation of ratios and other informationprovided, demonstrating a sophisticated understanding of how the ratios can be used to analyse the audit risks.

Correct interpretation of ratios and other informationprovided, demonstrating aclear understanding of how the ratios can be used to analyse the audit risks.

Most interpretations of ratios and other informationprovidedcorrect, demonstrating an understanding of how the ratios can be used to analyse the audit risks.

Most interpretations of ratios and other informationprovidedcorrectbut alimitedunderstanding oftheir usefulness in identifying the audit risks.

Identification of audit steps that minimise audit risk identified through the analysis of the ratios and the additional information (4 marks).

All appropriate audit steps identified with a clear statement as to how these will minimise audit risk, demonstrating a sophisticated level of audit planning.

Most appropriate audit steps identified. A clear understanding of how audit tests minimise audit risk.

Many appropriate audit steps identified. Some understanding of how audit tests minimise audit risk.

Some appropriate audit steps identified.
Basic understanding of how audit tests minimise audit risk.

Analysis of ratios and other information demonstratingbusinessrisk identification skills (2 marks).

Strong application of analytical procedures and other provided information to provide comprehensive assessment of at least four items of business risk.

Sound application of analytical procedures and other provided information to provide assessment of at least four items of business risk.

Some application of analytical procedures and other provided information to assessment of at least three items of business risk.

Use of some provided information in listing at least three items of business risk.Basic application of analytical procedures.

Question 2





Appraisal of the client's internal control environment and application to the audit risk model (5 marks)

Identification of at least four internal controls that are potentially effective, with acomprehensive explanation of the risk each one could mitigate. Tests of control


Identification of at least four internal controls that are potentially effective, with an explanation of the risk each one could mitigate.


Identification of at least three internal controls that are potentially effective, with an explanation of the risk each one could mitigate.

Identification of three internal controls that are potentially effective withbasic explanation of the risk each one could mitigate.

Development ofa series of audit steps thatassess the effectivenessof internalcontrols (2 marks).

Development of a comprehensive series of audit steps designed toassess the effectiveness of internal controls.This demonstrates a deep understanding of the audit process.

Development ofa series ofhigh quality audit steps designed to assess the effectiveness of internal controls. This demonstrates aclear understanding of the audit process.

Development of audit steps designed to assess the effectiveness of internal controls. This demonstrates a moderate understanding of the audit process.

Development of basic audit steps designed to assess the effectiveness of internal controls. This demonstrates a basic understanding of the audit process.

Identified internal control weaknesses (2 marks)

Identification of and comprehensive justification for at least five sales and receivables internal control weaknesses.

Identification of and justification for at least four sales and receivables internal control weaknesses.

Identification of and justification for at least three sales and receivables internal control weaknesses.

Identification of but limited explanation for at least three sales and receivables internal control weaknesses.

These last two criteria relate to the whole of the case study.

Professional communication (Note: you are required to space between paragraphs; use Arial 10pt or TNR 12 pt; use 1.5 or double line spacing) (0.5 mark).

Work contains distinct understandable statements with no errors.
Extremely well organised. Content is structured in a manner that facilitates the reader’s understanding.

Work contains distinct understandable statements with minimal errors.
Answer is well organised. Content is structured in a manner that facilitates the reader’s understanding.

Minor spelling, grammar and punctuation errors. Work shows evidence of proofreading. Well-structured with one main idea or argument provided per paragraph.

Some spelling, grammar and punctuation errors found but the work is readable and structured. Work may include too many ideas in one paragraph.

Appropriate resources and correct referencing
(0.5 mark).

Used a range of sources. All work has been referenced correctly as per APA (6th edn) requirements.

Used two or more sources. All work has been referenced correctly as per APA (6th edn) requirements.

Used one or more sources. All work has been referenced within the body of the answer and in the reference list, with some omissions or errors in terms.

No additional sources used other than the text. Others’ work is not always acknowledged and there are a number of errors or non-compliance with the APA (6th edn).


Answered Same Day Sep 16, 2020

Solution

Pulkit answered on Sep 19 2020
149 Votes
Executive Summary: -
The purpose of this report is to assist the preparation of the audit plan of the Trunkey Creek Wines Ltd. For the year ended 30 June 2018. The Trunkey creeks wines Ltd (TCW) is the one of the most valuable client of the Miller Yates Howarth (MYH) and the business line of the TCW is to growing of the grapes for the preparation of the wine and also the beef cattle production. The main objective of this report is to analyze the ratios to determine the performance of the company by comparing the ratios with the industries average ratio in which the company is operating and identify the potential audit risk through understanding and assessing the internal control to identify the risk associated to determine the timing and extent of audit procedure to be performed.
About the entity:
The principle activities of the company Trunkey creeks wines Ltd (TCW) is to growing grapes for the production of the wines and the company is producing the red white and the sparkling wines and the surplus area of the land is utilized by the company in the beef cattle production. The surplus generated from the operations of the company is distributed among the shareholders of the company and the excess amount of funds invested by the company in the market. There are three department of the company which includes the grape production department, wine production department, and the beef department. It is necessary to understanding the entity and its environment for identifying and assessing the risk of material misstatement in the entity.
Major areas of the audit are as follows:
1. Account Receivable: - It is the amount of money which the company has to be received from its customers in the near future. The account receivable is directly related to the credit sales of the company as much as the credit sales of the entity increase the total account receivable of the company is increases. More the credit sales in the business means more the receivables in the company and therefore the risk of loss of money always exist in the business.
2. Investment: - It is the part of surplus fund which is invested in the market to generate the better return as compare to the idle funds in the business. There are different ways to invest in the market the company may invest in the equity market, debt market or making the investment in the other company so that making them associate or the subsidiary company. In our case the investment portfolio of the company Trunkey creeks wines Ltd (TCW) includes the major investment in the Wagyu Selling Group (WSG) which is deals in the beef selling to the high end domestic as well as send the shipments to Japan and China.
3. Property asset: - Property is the valuable asset of the company. It includes the premises of the company, free land hold property etc. In our case the major portion of the fixed asset of the company consist of the land and property due to the nature of the business. The major portion of the company’s property is used for the growing grapes and the surplus land is utilized for the cattle beefing production.
4. Marketing expenses: - Marketing expenses are the major expenses of the business which is incu
ed for presenting the goods and services to the target customers. The marketing expenses include the advertising expenses, agency fees, customer survey, printing materials and display and sponsorship etc. in the case of the Trunkey creeks wines Ltd (TCW) the marketing expenses of the company is increases as compare to the previous years.
Solution 1(A)
    Account
    Analysis
    Audit Risk
    Audit steps to reduce risk
    Account Receivable
    The account receivable are the highly risky area in an entity and therefore requires the auditors to spend the substantial time to review the account receivable to identify and assess the risk of material misstatement.
In our case Trunkey creeks wines Ltd (TCW) has the total days in the account receivable for the wine are 50.2 days and in the beef credit sales are 57 days. Due to the long debtors’ collection period of the company as compare to the average of the industry in which it operates it will increase the risk of loss.
    Â· Existence of the account receivable in the balance sheet of the company.
· Accuracy of the balances of account receivables.
· Collection of the account receivables on the due dates.
· Inco
ect recognition of the credit sales of a particulars period.
· Provision for the doubtful debt for the period.
· Credit worthiness of the customers and the credit limit.
· Long outstanding receivables present in the balance sheet.
    Â· The auditor needs to check the account receivable aging report to trace the total account receivables for the period.
· Calculate the total credit sales amounts during the year to verify the total amount of the account receivable as per the general ledger are co
ect.
· Test the sample invoices for the credit sales from the account receivable report.
· Sampling to be done to check the necessary document of the sales like shipping log etc.
· The external confirmation must be taken from the third parties (customer) to verify their account balances.
· Analyze the collection procedure followed by the company.
· Trend analysis of the account receivable and the credit sales from the past years.
· Check the credit sales done with the related parties and the recovery amount of the same.
    Investments
    A portion of the surplus funds invested by the company in the market in order to earn the more returns from the idle funds available with them.
In our case the company Trunkey creeks wines Ltd (TCW) has also done various investment out of their surplus funds in the market out of which the major portion of their investment portfolio consist of the investment in the Wagyu Selling Group (WSG) which engage in the business of beef selling.
    Â· Reliability of the investment made by the management of the company.
· Valuation of the investment as on balance sheet date.
·...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here