Can you please help with the following problem for EarthWear Hands-on Mini-case Chapter 10 - Accounts Receivable Tests of Details
File Home Insert Page Layout Formulas Data\\ Review| View\\ Developer\\ Help Power Pivot ` Tell me what you want to do 15 Share\\\\ \\~ Comments* XIT R & Cut Arial Narrow* *\\ 10 +| A " A"\\ = = =\\ 879 .) \\ab Wrap Text* 2 AutoSum *\\ General Comma 2 Currency 2 Normal 2 Percent 2\\ ~` LE] Copy " \\ 3 / 13] [ 1 ] Fill - Paste - #` B I U +| { ~| { . A .` Z Z Z| EE EE| {\\Merge & Center*\\ Conditional Format as Normal* Bad Good Neutral Insert Delete Format & Cleary Sort & Find & Ideas {} Format Painter\\ Formatting * Table ~\\ Filter * Select " Clipboard\\ Font Alignment* Number* Styles Cells Editing Ideas N 32 fox C D E F G H K M N O P R S U V EARTHWEAR CLOTHIERS Evaluation of AVR Confirmations Initial Here December 31 , 2016 OVER 2019 Results of AVR Confirmations Complete the worksheet below by reviewing the accounts receivable confirmason the contained in the Instructions . Complete the cells below in yellow . If you determine that the difference noted by the Reason ( s ) for Difference AVR Balance per AIR Balance\\ Difference per ( 1) ( i.e. , timing difference , transposition error , cut - off error , mistake , Amount of Customer ID* ` Customer Name clients' records per Customer Customer\\ etc . ) Overstatement a 65 6:52- 54310*. Red Star Health GROUP. $12, 365 $12, 356 so Transposoon error 6 10 210- 38725 Museum of Flight $14, 235 SO $14 , 235 Customer recorded wrong date on FOB\\ SO 11 254- 62418\\ Summit Hills Country Club. $24 , 362 521, 5^ $2, 842 Timing Difference\\ SO 12) 179 - 26343\\ Central States Hotels*.` ST``O`.. .`` mistake in 53 additional items\\ $8.80, 560 SO processing cables^ $3, 0.00\\ 13\\ $8.80, 560 SO Total Dollar Amount of Items in Sample* $950, 164 $930, 078 $20. 086 _Net misstatement $3.009 15\\ Total Dollar Amount of Items in Sampling Population\\ $7. 722.000 16 17 Nonstatistical Evaluation of Errors Book Value\\ Book Value known or Factual\\ Ratio of Projected Stratum of Stratum of Sample Misstatement \\ _Misstatements _Misstatement* Evaluation of Test Results 25100, 000 $921, 000 $921, 000 SO 0.00.00 % 6 SO Enter Evaluation Here $5100, 000 $7 , 7:22, 0.00 $950 , 164 $3, 009 0. 3167 %/ $24, 454 _Total Projected Misstatement\\ $24, 454\\ ' The ratio of misstatements is simply the computation of the percentage error in dollars tested in the sample . You can find this formula and an illustration of the computation in Chapter 9 , Nanstatistical Sampling section ) .* * Projected misstatement is the application of the misstatement ratio to the population subject to audit sampling . You can find this Famula and an illustration of the computation in Chapter } ( Nanstatistical Sampling section !* Statistical Evaluation of Errors using IDEA Monetary Unit Sampling*\\ 26) Results Overstatements Understatements Evaluation of Test Results 67 {Enter Evaluation Here 19 Sample }^` .. Number of errors`. Gross most likely error. . |8,0:31 . 3 2 . Net most likely error . . 18.631 . 3`. _ ( 18 , 6:31 . 3`. Total precision . 237 , 562.00 . 237. 562.0`. \\32\\ Gross upper error him \\3.56 , 293. 32\\ \\3:37 , 662.00 let upper error limit 356 , 293. 32\\ 319 . 030. 68\\ * Refer to Chapter 9 of the textbook for additional instructions for evaluating the results with IDEA .\\ 35 36 Evaluation Method Comparison\\ In this space please briefly discuss how the results compare to each other . Are the monetary amount and overall conclusions similar ? 31 20 Instructions| Work Paper 10 - 1\\ Ready -+ 10.0 %6\\
