会计数据分析 Solutions_Manual Chapter_6_Labs_SM.docx

Copyright?2019McGraw-HillEducation.Allrightsreserved.NoreproductionordistributionwithoutthepriorwrittenconsentofMcGraw-HillEducation.

CHAPTER6LABS

Lab6-1Evaluatethemasterdataforinterestingaddresses

Lab6-2Performsubstantivetestsofaccountbalances

Lab6-3FindingDuplicatePayments

Lab6-4:ComprehensiveCase:DillardsDataHypothesisTesting

Lab6-5:ComprehensiveCase:DillardsDataHypothesisTesting(PartII–DataVisualization)

6-1Evaluatethemasterdataforinterestingaddresses

You’restartingtomakeanameforyourselfintheinternalauditdepartment.Yourmanagerlikedyouranalysisoftheauditplanandnowwouldlikeyoutoseewhatotherwaysdataanalyticscouldbeappliedbeyondtheexistingauditactionsheets.

Asyou’vebeenreadingaboutriskandfraud,youlearnedthatonecommonriskisthatemployeesmaybetemptedtocreatefictitioussuppliersthattheyusetoembezzlemoney.Thepremiseissimpleenough.Anemployeewithaccesstocreatemasterdataaddsasupplierrecordforaspouse.Theythensubmitaninvoicefor“cleaningservices”thatwereneverperformedandarepromptlypaid,assumingthereisn’tgoodfollow-upfromtheaccountspayabledepartment.Theemployeeissmartenoughtoknowthatanexactaddresswouldraiseredflags,soshealtersitslightlytoavoiddetection.OthersuspiciousaddressesmayincludePOBoxaddresses,sincetheycanobscuretheidentityofafictitioussupplier.

Youknowthatonewaytodetectthisissueistolookforfuzzymatches,andyou’reeagertoshowyourmanagerwhatyouknow.RefertoLab3-2foranotherexample.ThislabassumesyouhavecompletedLab5-1.

Techniques

Datapreparation

Filtering

Fuzzymatching

SoftwareNeeded

Excel

Inthislab,youwill:

Part1:Identifythequestions

Part2:Mastertheemployeeandvendordata

Part3:Performtheanalysis

Part1:Identifythequestions

Q1.Givenwhatyouknowaboutvendoraddresses,whattypesofaddresses