Second part of risk #3

for risk #3:

a. Was the engagement teams assessment of the evaluation of the design of each control appropriate (i.e., does the control identified by the team address the specific risk of material misstatement and associated assertion)

b. Was the engagement teams assessment of the risk associated with each control appropriate?

c. Was the teams interim planned procedures to test the operating effectiveness of each control appropriate considering the risk associated with the control?

d. Was the teams roll-forward planned procedures to test the operating effectiveness of each control appropriate considering the risk associated with the control

2 A Ncau drug 3 SIMONS Inc. Account Scoping and Risk Assessment Account Balance and Disclosure: Revenue Class of Transaction: Recording Sales Identification of risk of material misstatement RISKS Orders shipped are not recorded accurately to actual quantities shipped, and prices per invoice do not reflect approved pricing Relevant assertion Accuracy. No. Significant risk? Risk of material misstatement because of fraud? No. Control activity that addresses the risk of misstatement Does the control rely on information used in the control (or IUC)? If yes, list relevant information Control #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.45 million or fluctuations greater than 15 percent from prior year actual or current budget. The controller documents the results of any follow up. Yes. 1. Monthly reporting package. 2. Budget Monthly reporting package: The monthly reporting package, which includes revenue information, is generated by the assistant controller from the SAP 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. In addition, we will test the controls around report logic, parameters, and the source data. 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" (.e., determined based on reasonable expectations of future events, rather than a percentage increase over previously budgeted amounts). The application system used for this process is SAP. 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 SAP system, the information is uploaded to SAP. The financial analysis team then performs a tie-out and reconciliation of the SAP information versus the reports created in SAP to assure accuracy of the upload. SAP 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. Will we obtain audit evidence of the accuracy and completeness of information used in the control by testing controls? We plan to test the budget process and controls 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. 2. We will identify and test the controls around report logic, parameters, and the source data of the budget. 3. Verify that SAP information is tied out and reconciled to SAP. 4. Verify through review of board minutes that annual budget is approved by the CEO and CFO. No. Is the control automated? Relevant application system (if we are testing SAP, which is subject to IT controls and tested within the IT controls workpaper. information used in the control entity through tests of controls or the control is automated) Based on 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. Given that the control is performed monthly, it would detect errors in time to prevent material misstatement of the financial statements. Tests of controls: evaluation of design 3. The control is sufficiently precise to detect a material misstatement in the revenue account (which is based on $4.25 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. Risk Associated with the Control Not Higher Risk Associated with the Control Not Higher Interim 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 four months and determine if the monthly package was appropriately discussed. Tests of controls: planned operating effectiveness testing Roll forward Procedures: 1. Select a month from Q4 and perform the above procedures consistent with interim