You are to assume that you are working in the team charged with the audit of...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You are to assume that you are working in the team charged with the audit of Hardco Limited (Hardco) for the year ended 31 March 2018 and will be working on inventory. Hardco purchases a wide variety of hardware products directly from the manufacturer and then on sells these to retail hardware stores across New South Wales. Inventory is stored in a single warehouse. Total sales revenue for the year is expected to be approximately $1,000,000. Planning materiality has been set at $50,000 and performance materiality for inventory is $30,000. You have been advised by company management that the sales price for all products has remained unchanged for the entire year. The company uses a period inventory system. The risk of material misstatement for the assertions of "Existence' and 'Accuracy Valuation and Allocation' is high. The partner has decided to adopt a primarily substantive approach to the audit of inventory. You have downloaded some data from the client's information system and saved it as an excel file (this is available on the Course Moodle website - you should download this file before class). The data includes the following: Column Heading Prod No. Prod Name Avg Cost Sales Price POTY Balance Sales LPDate LSDate Inventory COS Sales Description Product Number Product Name Average cost per unit Sales Price Quantity of last purchase Quantity available for sale as at 31 March Quantity of product sold during the year Date of last purchase None of this information has been audited. Remember also that control risk has been set at high and no reliance is being placed on controls. • Date of last sale Cost of inventory at year end Cost of Sales for the year Sales revenue for the year In class, you will be using Excel (or other spreadsheet packages) as an audit tool to assist in the execution of the audit plan and to perform substantive tests relating to the audit of inventory. Before class, you must make sure that you are able to perform the basic excel functions of sorting data, using formulas to perform basic mathematical functions, and generating random numbers. There are many online tutorials that can help you have forgotten how to perform these l asic functions.. You should specifically consider the following questions and submit your preparation notes; . Reflect on how a contemporary IT environment impacts the conduct of an audit. In this regard, describe key elements that an auditor needs to consider in relation to: - understanding the entity/ assessing inherent risk, understanding and assessing internal controls, performing controls testing and performing substantive testing. Detail one (1) audit procedure that you will perform in order to collect sufficient appropriate audit evidence for both the 'existence' and 'accuracy, valuation and allocation of inventory. For each of the procedures, note ways in which the auditor could use excel functions and the data file discussed above to help perform the procedure. Remember that, in order to be eligible for the 2 marks seminar preparation, you must submit your preparation notes via the Turnitin link in Moodle. You are to assume that you are working in the team charged with the audit of Hardco Limited (Hardco) for the year ended 31 March 2018 and will be working on inventory. Hardco purchases a wide variety of hardware products directly from the manufacturer and then on sells these to retail hardware stores across New South Wales. Inventory is stored in a single warehouse. Total sales revenue for the year is expected to be approximately $1,000,000. Planning materiality has been set at $50,000 and performance materiality for inventory is $30,000. You have been advised by company management that the sales price for all products has remained unchanged for the entire year. The company uses a period inventory system. The risk of material misstatement for the assertions of "Existence' and 'Accuracy Valuation and Allocation' is high. The partner has decided to adopt a primarily substantive approach to the audit of inventory. You have downloaded some data from the client's information system and saved it as an excel file (this is available on the Course Moodle website - you should download this file before class). The data includes the following: Column Heading Prod No. Prod Name Avg Cost Sales Price POTY Balance Sales LPDate LSDate Inventory COS Sales Description Product Number Product Name Average cost per unit Sales Price Quantity of last purchase Quantity available for sale as at 31 March Quantity of product sold during the year Date of last purchase None of this information has been audited. Remember also that control risk has been set at high and no reliance is being placed on controls. • Date of last sale Cost of inventory at year end Cost of Sales for the year Sales revenue for the year In class, you will be using Excel (or other spreadsheet packages) as an audit tool to assist in the execution of the audit plan and to perform substantive tests relating to the audit of inventory. Before class, you must make sure that you are able to perform the basic excel functions of sorting data, using formulas to perform basic mathematical functions, and generating random numbers. There are many online tutorials that can help you have forgotten how to perform these l asic functions.. You should specifically consider the following questions and submit your preparation notes; . Reflect on how a contemporary IT environment impacts the conduct of an audit. In this regard, describe key elements that an auditor needs to consider in relation to: - understanding the entity/ assessing inherent risk, understanding and assessing internal controls, performing controls testing and performing substantive testing. Detail one (1) audit procedure that you will perform in order to collect sufficient appropriate audit evidence for both the 'existence' and 'accuracy, valuation and allocation of inventory. For each of the procedures, note ways in which the auditor could use excel functions and the data file discussed above to help perform the procedure. Remember that, in order to be eligible for the 2 marks seminar preparation, you must submit your preparation notes via the Turnitin link in Moodle.
Expert Answer:
Answer rating: 100% (QA)
Impact of Contemporary IT Environment on Inventory Audit Understanding the EntityAssessing Inherent Risk Data analysis tools Utilize data analytics tools to analyze historical sales data inventory tur... View the full answer
Related Book For
International Financial Reporting A Practical Guide
ISBN: 978-1292200743
6th edition
Authors: Alan Melville
Posted Date:
Students also viewed these accounting questions
-
The following figures relating to the year ended 31 March 20X3 have been extracted from the books of a manufacturer: ............................................................... Total of sales...
-
The following particulars relating to the year ended 31 March 20X3 have been extracted from the books of Heel and Toe, footwear wholesalers. All sales have been recorded in personal accounts in the...
-
The following particulars relating to the year ended 31 March 20X3 have been extracted from the books of a trader:...
-
In designing an experiment, the researcher can often choose many different levels of the various factors in order to try to find the best combination at which to operate. As an illustration, suppose...
-
Identify four indirect costs you might find on a moderately complex project. Why are these costs classified as indirect?
-
Compute Home Depot's Debt to Asset ratio for the year ended January 2 0 2 3 . AMAZON.COM, INC. CONSOLIDATED BALANCE SHEETS (in millions, except per share data) ASSETS December 31, 2021 2022 Current...
-
Consider the Michaelis-Menten model introduced in Eq. (12.23). Graph the expectation function for \(\theta_{1}=100,150,200,250\) for \(\theta_{2}=0.06\). Overlay these curves on the same set of...
-
On January 2, 2008, McGregor Co. issued at par $45,000 of 9% bonds convertible in total into 4,000 shares of McGregors common stock . No bonds were converted during 2008. Throughout 2008, McGregor...
-
An 80.0 kg sprinter starts a race with an acceleration of 1.96 m/s2. If the sprinter accelerates at that rate for 34 m, and then maintains that velocity for the remainder of the 100 m dash, what will...
-
Crane Construction's manufacturing costs for August when production was 1,240 units are as follows: Direct material Direct labor Variable overhead Factory depreciation Factory supervisory salaries...
-
As part of your human resource management course, your teacher asked you to conduct a study covering HRM concepts. This study should show how well you understand the HRM functions and give related...
-
1.8. The state of a spin-particle is given by i =1/31+2)+ + 1-2) (1) What are (S) and AS, for this state? Suppose that an experiment is carried out on 100 particles, each of which is in this state....
-
The Moon orbits the Earth is a roughly circular orbit. To calculate the force the Earth exerts on the Moon, you need to know the direction of the separation unit vector (7) and the gravitational...
-
2p 1e A position-dependent force (x, y) = axy (with a a constant) acts on an object with mass m. The object is released from rest at position (xo, y1) (with y a nonzero constant). When the object is...
-
Vector A = 2 . 0 0 i + - 1 . 0 0 j and Vector B = 3 . 0 0 i + 4 . 0 0 j . What is Vector C = A - B ? A . 1 . 0 0 i + 5 . 0 0 j B . - 1 . 0 0 i + - 5 . 0 0 j C . - 1 . 0 0 i + 3 . 0 0 j D . 1 . 0 0 i...
-
A system is made up of two point charges, Q, and Q of 6 C and 5 C respectively as shown in the figure below. Point P is 5 cm vertically below Q 10 cm (+) Q 5 cm P. Y Determine the electric field...
-
An industry consulting firm has the following structure and culture: All the employees at this consulting firm work full-time. All the full-time consultants report to various industry directors,...
-
With your classmates, form small teams of skunkworks. Your task is to identify an innovation that you think would benefit your school, college, or university, and to outline an action plan for...
-
An asset (which has never been revalued) has a carrying amount of 100,000. The asset is being depreciated on the straight-line basis, with a remaining useful life of three years and a residual value...
-
Identify and explain the four enhancing qualitative characteristics of useful financial information. Is there a prescribed order for applying these enhancing characteristics?
-
The statements of financial position of M Ltd, P Ltd and Q Ltd as at 31 July 2018 are as follows: The following information is available: (a) On 31 July 2015, M Ltd paid ?410,000 to acquire 90% of...
-
The topological optimization is discussed in chapter 1. Here, we will consider a topological optimization problem for a chemical process plant. The layout of the chemical process plant has been shown...
-
For installation and operation of a pipeline for an incompressible fluid, the total cost (in dollars per year) can be represented as follows: \[C=C_{1} D^{1.5} L+C_{2} m \Delta p / ho\] where...
-
An adiabatic two-stage compressor is used to compress a gas, which is cooled to the inlet gas temperature between the stages, the theoretical work can be expressed by the following equation:...
Study smarter with the SolutionInn App