Please compute upper divination rate and decide if auditor should accept or reject.

10e_Ch8_Mini_case_Testing_PartB [Read-Only] [Compatibility Mode] - Microsoft Excel (Product Activation Failed) X File Home Insert Page Layout Formulas Data Review View % Cut General E AutoSum * Arial Narrow 10 A Wrap Text En Copy Fill Paste BIU BY 3 Merge & Center $ % Conditional Format Cell Insert Delete Format Format Painter Formatting * as Table * Styles 2 Clear * Sort & Find & Filter Select Clipboard Font Alignment Number Styles Cells Editing K18 B C D E F G H J K L M 13 Sample Size Used 0 14 15 Compute Upper Deviation Rate The list below indicates the test of controls results for each control activity. Use the information provided to evaluate the results using IDEA. Please refer to Chapter 8 for instructions on using DEA to evaluate test results and to compute the upper deviation rate. After you compute the upper deviation rate, determine whether the test results met the objectives and can be accepted (i.e., determine whether the computed upper deviation rate is below the tolerable deviation rate noted above for the control activity). Select "Accept" or "Reject" from the drop down menu in 16 each cell of the Accept/Reject column. For control activities that you reject, please indicate necessary revisions to the audit plan Computed Desired Upper Confidence Sample Number of Deviation Accept/ Describe Any Necessary Revisions to 17 Description of Control Activities Level Size Deviations Rate (%) Reject the Audit Plan 18 1 Document packet includes all documents appropriate for the transaction. 90% 0 0 Enter Here 19 2 The Purchase Requisition is signed by a supervisor. 90% O Enter Here 20 3 The Purchase Order is signed by an authorized purchasing agent. 90% O Enter Here Quantities on vendor's invoice agree with related receiving report and 90% Enter Here 21 purchase order, and invoice is mathematically correct. 22 5 All documents in voucher packet have been stamped "paid". 90% 0 0 Enter Here 23 24 25 @McGraw-Hill Education, 2017 26 27 28 29 30 31 32 33 34 14 Instructions Work Paper 8-1 2 Ready 100% + X ? 1:19 PM Type here to search O 11/15/2019Ewalgnas_Ch8_Mini_case_Testing_PartB [Compatibility Mode] - Microsoft Excel (Product Activation Failed) X File Home Insert Page Layout Formulas Data Review View 6 ? - X % Cut Arial Narrow 10 A Wrap Text General AutoSum * En Copy Fill Paste Format Painter BIU BY 15 Merge & Center $ - Conditional Format Cell Insert Delete Format Sort & Find & Formatting * as Table * Styles 2 Clear * Filter * Select Clipboard Font Alignment Number Styles Cells Editing K8 C B C D E F G H J K L M I A W N - EARTHWEAR CLOTHIERS 8-1 Control Activities Testing - Sampling and Evaluation Sheet: Accounts Payable December 31, 2016 11/16/2019 Compute Sample Size The list below indicates the control activities tested using voucher packets in Part A (Part A was a Chapter 6 assignment, but you can complete this assignment even if you did not complete Part A). Use the information provided below to calculate the sample size using IDEA. Please refer to Chapter 8 of the textbook for instructions on how to use IDEA to calculate sample sizes. When different sample sizes are computed for control activities that will be tested concurrently, it is common to use the largest sample size computed for testing all control activities (see Chapter 8 for a 6 more detailed description). Expected Desired Tolerable Population Confidence Deviation Deviation Sample 7 Description of Control Activities Level Population Rate (% Rate (%) Size 8 1 Document packet includes all documents appropriate for the transaction. 90% 2,147 5% 1% 12 9 2 The Purchase Requisition is signed by a supervisor. 90% 2,147 10% 4% 5 10 3 The Purchase Order is signed by an authorized purchasing agent. 90% 2.147 10% 1% Quantities on vendor's invoice agree with related receiving report and 90% 11 purchase order, and invoice is mathematically correct. 2,147 5% 1% 8 12 5 All documents in voucher packet have been stamped "paid" 90% 2.147 10% 1% 10 13 Sample Size Used 12 14 15 Compute Upper Deviation Rate The list below indicates the test of controls results for each control activity. Use the information provided to evaluate the results using IDEA. Please refer to Chapter 8 for instructions on using IDEA to evaluate test results and to compute the upper deviation rate. After you compute the upper deviation rate, determine whether the test results met the objectives and can be accepted (i.e., determine whether the computed upper deviation rate is below the tolerable deviation rate noted above for the control activity). Select "Accept" or "Reject" from the drop down menu in 16 each cell of the Accept/Reject column. For control activities that you reject, please indicate necessary revisions to the audit plan. Computed 14 Instructions Work Paper 8-1 2 Desired Upper Ready 100% + Type here to search O Fi M 9 W X ? 2:38 PM 11/16/2019