Fluent Essays

ZOU Fencing Inc. (“ZOU Fencing” or “the Company”) is a public company in the United States that files quarterly and annual reports with the SEC. ZOU Fencing has five manufacturing facilities located in Missouri and produces and provides chain-link fencing to customers throughout the Midwest (specifically, Wisconsin, Indiana, Michigan, Ohio, Illinois, and Iowa) via rail car.ZOU Fencing sells chain-link fencing to customers under freight on board (FOB) shipping point terms. Therefore, revenue is recorded when goods are shipped from the respective warehouse. ZOU Fencing currently uses a sophisticated warehouse management system (the Warehouse K-Series System), which allows the Company to (1) record sales upon shipment of goods out of the warehouse, (2) automatically price fence sales on the basis of standard pricing tables, and (3) generate multiple reports for the evaluation of ZOU Fencing’s operations.Engagement Team Note:Materiality was determined to be $5 million. In planning the current year’s audit, the engagement team obtained an understanding of the internal controls related to revenue. This understanding was done through the engagement team’s walkthrough of the revenue process. As part of their walkthrough procedures the engagement team made inquiries of appropriate personnel, inspected relevant documentation and in certain cases observed the control performers performing the control procedures.As a result, the engagement team arrived at the conclusion that there have been no significant changes in the revenue process since the prior year. Furthermore, the engagement team has determined that they will not be using the work of others for testing the operating effectiveness of controls related to revenue.The engagement team identified three risks of material misstatement relating to the recording of sales. For each risk identified, the team documented in the excerpted worksheet (see Handout 1) the control activity that addresses the risk of material misstatement, the evaluation of the design of that control activity, and the planned testing of operating effectiveness.2. For each of the three revenue risks identified by the engagement team, address the following: b. Was the engagement team’s assessment of the risk associated with each control appropriate?Hand out : Risk #1Identification of risk of misstatement (what could go wrong)All orders shipped are not recorded as revenue.Relevant assertionCompleteness.Significant risk?No.Risk of material misstatement because of fraud?No.Control activity that addresses risk of misstatementControl #1: Sales are automatically recorded and invoices are automatically generated upon the release of the order in the Warehouse K-Series System. Orders are not released until the goods have been confirmed for shipping in the system (which occurs when the goods are scanned as they are loaded in the shipping area).Does the control rely on information produced by the entity (or IPE)? If yes, list relevant informationNo.Will we obtain audit evidence of the accuracy and completeness of information produced by the entity by testing controls or by performing procedures directly on the information?N/AIs the control automated?Yes.Relevant application system (if we are testing information produced by the entity through tests of controls or the control is automated)Warehouse K System, which is subject to IT controls performed by management and tested within the IT controls workpaper.Tests of controls: evaluation of designOn the basis of the following factors, we concluded that the control is appropriately designed to address the stated risk of material misstatement:1. The control is the automation of the invoicing of goods shipped as the system will automatically record revenues when goods are shipped from the warehouse (revenue generating activity), thus resulting in no shipped goods going unrecorded in the system that appropriately addresses the related risk of material misstatement and assertion.2. Automated control prevents errors from occurring as opposed to identifying them once they have occurred (preventive control).3. Control operates at the transaction level and, as such, is sufficiently precise to mitigate the risk.4. Control is performed on a continual basis and thus addresses the risk directly and for the period under audit. 5. There are no historical issues with operation of the control and the control has not been modified in the period under audit.Tests of controls: planned operating effectiveness testingInterim Procedures (test as of 9/30):1. Contact the Director of Customer Service and obtain detailed explanation of how control operates.2. View samples of the shipping request.3. Verify that understanding through testing of general IT controls; i.e., program change controls that there have been no changes to the control since the previous year.Rollforward Procedures:1. Make inquiries of the controller and the IT manger to determine if any events have occurred that might impact the design or operation of the control (e.g., changes, additional risks, operating deficiencies) after our interim testing date. If any significant changes are noted, retest control.Copyright 2011 Deloitte Development LLC All Rights Reserved.Case 21: ZOUs Fencing Controls Page 2 Handout 1ZOU Fencing Inc. (Case 13-9 handout)Risk #2Identification of risk of misstatement (what could go wrong)Revenue is recorded for orders not shipped or fictitious sales.Relevant assertionExistence or occurrence.Significant risk?YesRisk of material misstatement because of fraud?YesControl activity that addresses risk of misstatementControl #2: The Orders Shipped & Invoiced Report is reviewed by the warehouse director on a daily basis for unusual items and reasonableness; evidenced by the warehouse directors initials on the report, which is maintained.Does the control rely on information produced by the entity (or IPE)? If yes, list relevant informationYes — The Orders Shipped & Invoiced Report, which details orders that were shipped and invoiced for a given day. The report is automatically generated by the Warehouse K system.Will we obtain audit evidence of the accuracy and completeness of information produced by the entity by testing controls or by performing procedures directly on the information?Because the operating effectiveness of the control is dependent upon the accuracy and completeness of the IPE, we will test the controls around accuracy and completness. As the IPE is a system generated report, refer to our testing of the companys IT general contols. In addition, we will test the controls around report logic as well as the internal controls around the source data.Is the control automated?No.Relevant application system (if we are testing information produced by the entity through tests of controls and/or the control is automated)Warehouse K System, which is subject to IT controls and tested within the IT controls workpaper.Tests of controls: evaluation of designOn the basis of the following factors, we concluded that the control is appropriately designed to address the stated risk of material misstatement:1. The warehouse director has been with the company for over 10 years and has been acting in this current role for the last five. The warehouse director is in charge of overseeing operations at all five warehouses and directly supervises the warehouse managers. The director is knowledgeable of the business and focuses reviews on activity that seems unusual given the customer and quantities purchased. The review is directed to the identification of unusual trends and thus appropriately addresses the related risk of material misstatement and assertion.2. Control is performed on a daily basis.3. Control identifies exceptions after they have occurred (i.e., its a detective control), yet given the frequency of performance, it would identify errors in a timely manner.4. Although the control entails the review of daily revenue activity, it is done on a transaction by transaction basis, and as such it is sufficiently precise to mitigate the risk.5. Control involves the judgment of the warehouse director since there is no specific threshold set. However, since all transactions are evaluated and ZOU Fencing has a cyclical business, the report results are predictable. In addition, the warehouse director has been employed by the company for 10 years.Tests of controls: planned operating effectiveness testingInterim Procedures (tested as of 9/30):1. Discuss the performance of the control procedure with the warehouse director.2. Select 15 days out of the year.3. Obtain the Orders Shipped & Invoiced Report reviewed by the warehouse director.4. Determine whether the reports were signed off by the warehouse director and dated on the day following the report date.Rollforward Procedures:1. Make inquiries of management and the process owner of the control activity to determine if any events that might impact the design or operation of the control (e.g., changes, additional risks, operating deficiencies) have been identified after our interim testing date.Copyright 2011 Deloitte Development LLC All Rights Reserved.Case 21: ZOUs Fencing Controls Page 3 Handout 1ZOU Fencing Inc. (Case 13-9 handout)Risk #3Identification of risk of misstatement (what could go wrong)Orders shipped are not recorded accurately to actual quantities shipped and prices per invoice do not reflect approved pricing.Relevant assertionValuation or allocation.Significant risk?No.Risk of material misstatement because of fraud?No.Control activity that addresses risk of misstatementControl #3: On a monthly basis, the reporting package is reviewed and analyzed by the controller and presented and discussed at the operations review meeting. The Controller focuses on differences or amounts greater than $4 million or fluctuations greater than 15 percent from prior year actual or current budget. The controller documents the results of any follow up.Does the control rely on information produced by the entity? If yes, list relevant informationYes.1. Monthly reporting package. 2. Budget.Will we obtain audit evidence of the accuracy and completeness of information produced by the entity by testing controls or by performing procedures directly on the information?Monthly reporting package:The monthly reporting package, which includes revenue information, is generated by the assistant controller from the PeopleSoft general ledger using data query tools by selecting certain data fields and defining calculations using the data. We tested the general IT controls (in particular program change controls) for completeness and accuracy. Budget:The CFO and CEO develop a budget annually in accordance with a set of defined budgeting procedures that require that the budget be “zero set” (i.e., determined on the basis of reasonable expectations of future events, rather than a percentage increase over previously budgeted amounts). The application system used for this process is Budgetpro. The CFO and CEO review the budget to confirm that the budgeted amounts have been determined in accordance with the established procedures and are based on reasonable expectations of future events. Upon finalization and approval of the budgets and forecasts within the Budgetpro system, the information is uploaded to PeopleSoft. The financial analysis team then performs a tie-out and reconciliation of the Budgetpro information versus the reports created in PeopleSoft to assure accuracy of the upload. PeopleSoft budget information is important since management compares the P&L, BS, and other activity budgets to the actual monthly actual performance as indicators of unusual activity. All budgets and forecasts are subject to several tiered reviews. The final budget is then presented in a slide deck to the CEO and CFO for final approval. According to the budgeting procedures, the budget cannot be reset once approved by the CEO.We plan to test the budget process and controls directly as follows:1. Obtain a copy of the original budget and gain an understanding of how it was prepared and how it is modified during the year for known changes.Final procedures:1. Verity that Budgetpro information is tied out and reconciled to Peoplesoft.2. Verify through review of board minutes that annual budget is approved by President-Americas and CEO and CFO.Is the control automated?No.Relevant application system (if we are testing information produced by the entity through tests of controls or the control is automated)No.Tests of controls: evaluation of designOn the basis of the following factors, we concluded that the control is appropriately designed to address the stated risk of material misstatement:1. Control appropriately addresses the related risk of material misstatement and assertion since any unexpected variances would be detected by the controller’s analysis of budget to actual.2. The control is detective and therefore identifies exceptions after they have occurred, yet given that the control is performed on a monthly basis, it would detect errors in time to prevent material misstatement of the financial statements.3. The control is sufficiently precise to detect a material misstatement in the revenue account (which is based on $5 million materiality threshold).4. Management has defined quantitative thresholds for investigating variances.5. The company’s financial results have historically been consistent with budget. There are no significant changes planned in the current year to the company’s business nor are there any external factors related to the industry, regulatory environment, or economy that would be expected to impact the company’s current year financial results.Tests of controls: planned operating effectiveness testingInterim Procedures:Inquiry:1. Inquire of the controller and assistant controller of the following:a. Explanation of the steps involved in performing the control.b. Reports and other information used, including how such information is used and from where it is obtained. c. Procedures performed when an exception or misstatement is identified.d. Procedures performed when the individual is absent.e. Procedures performed with respect to unusual transactions.f. Changes to controls during the period, including changes in personnel who perform them.Inspection:2. Obtain the meeting minutes for two months and determine if the monthly package was appropriately discussed.Rollforward Procedures:1. Select a month from Q4 and perform the above procedures consistent with interim.