Excel project: using benfords law to detect potential disbursements fraud.* Required Read the article using spreadsheets and
Question:
Excel project: using benford’s law to detect potential disbursements fraud.*
Required
Read the article “using spreadsheets and benford’s law to test accounting data,†By mark g. Simkin in the isaca journal, vol. 1, 2010, available at www.isaca.org.
Follow the steps in the article to analyze the following set of supplierinvoices:
Transcribed Image Text:
t635-90598705419 6 7 2 9 5 2 3 8 6 9 4 2 1 1 u283274985 2 8 9 7 37 813611721277194 , 123 5678901234 e 6 6 6 6 cb333333) 3 3 3 3 3 3 3 3 3 oi n 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2 t5755359323-0250 4 7 9 5 3 5 3 7 6 3 3 0 220 893474 2 5 8 9 5 4 891 , 69 69 69 69 GA 69 $ $ 69 69 69 $ 567890123456789 ee444445555555555 b 3 3 3 3 3 3 3 3 3 3 3 3 3 3 3 oi n 2 2 2 2 2 2 2 2 2 2 2 2 2 2 2
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 64% (14 reviews)
To apply Benfords law we need to write a formula that extracts the leftmost digit from an invoice number Excel has a number of builtin functions that ...View the full answer
Answered By
PALASH JHANWAR
I am a Chartered Accountant with AIR 45 in CA - IPCC. I am a Merit Holder ( B.Com ). The following is my educational details.
PLEASE ACCESS MY RESUME FROM THE FOLLOWING LINK: https://drive.google.com/file/d/1hYR1uch-ff6MRC_cDB07K6VqY9kQ3SFL/view?usp=sharing
3.80+
3+ Reviews
10+ Question Solved
Related Book For
Accounting Information Systems
ISBN: 978-0133428537
13th edition
Authors: Marshall B. Romney, Paul J. Steinbart
Question Posted:
Students also viewed these Accounting questions
-
In problem, follow Steps 1 through 8 to analyze the graph of each function. %3D (x 1)(x + 2) |R(x)
-
In problem, follow Steps 1 through 8 to analyze the graph of each function. (x 1)(x + 2)(x 3) x(x 4)2 R(x)
-
Required (a) Using the data given in the table above, use MS Excel to: (i) Prepare a schedule to be presented to management. The schedule must show the following for 5000, 10000, 15000, 20000, 25000...
-
ME-1" Ltd. acquired 80% equity shares of You-2nd Ltd. on 30/04/2020 for a cost of GHS60,000. At that time the general reserves were GHe6,000 respectively.
-
Why are audit tests more likely to be conducted at or after year end for high-risk clients than for low-risk clients? Explain.
-
Bruce also requires a calculation of taxable income for the most recent year ended December 31, 2019. The calculation should be prepared in Excel. He has also requested that you prepare the year-end...
-
Given the different needs of the HRP/workforce planning process discussed in this chapter, what types of data would you expect the HRIS data warehouse to contain?
-
Reba Dixon is a fifth grade school teacher who earned a salary of $38,000 in 2017. She is 45 years old and has been divorced for four years. She received $1,200 of alimony payments each month from...
-
Hudson Company reports the following contribution margin income statement. HUDSON COMPANY Contribution Margin Income Statement For Year Ended December 31 Sales (11,000 units at $300 each) Variable...
-
Techcom is designing a new smartphone. Each unit of this new phone will require $230 of direct materials; $10 of direct labor; $22 of variable overhead; $18 of variable selling, general, and...
-
Match the terms in the left column with their appropriate definition in the rightcolumn. Terms Definitions 1. Economic order quantity a. A document that creates a legal ob EOO) ligation to buy and...
-
Match threats in the first column to appropriate control procedures in the second column. More than one control may be applicable. Threat Control 1. Failing to take available purchase discounts for...
-
What are the five different marketing management orientations? Which orientation do you believe your school follows when marketing itself?
-
Sales for a new car is expected to grow according to the equation: S = 150000(1-e -0.06t ), where t = months i) Calculate the number of cars sold after one year. ii) Calculate the number of cars sold...
-
1.Libby just expanded her restaurant. She projects revenue will reach $35,000 for the new restaurant in the first year and increase by 25% over the next three years. Expenses are 75% of sales. The...
-
Calculate Inventory Conversion Period, Receivables Conversion Period, the Payment Conversion Period, and the Operating Cycle for Innovation Inc. given the following information. Use 365 to get an...
-
A 480-g iron pan is heated on a stove to a temperature of 130 C. The pan is then dropped into a partially-filled sink of water at 20 C. The final temperature reached by the sink and the pan is 40 C....
-
A particle undergoing simple harmonic motion has a potential energy given by E/J=3(y/m) as it oscillates back and forth along the y-axis. When the y-coordinate of the particle is 0.75 m, what is the...
-
For each of the following pairs of products, briefly explain which pairs are complements, which are substitutes, and which are unrelated. a. New cars and used cars b. Houses and washing machines c....
-
Which should drive action planning more, strengths or weaknesses? That is, is it more important to build on your strengths or to reduce your weaknesses? Explain.
-
Here's a great everyday use of the physics described in this chapter. If you are trying to get ketchup out of the bottle, the best way to do it is to turn the bottle upside down and give the bottle a...
-
With the help of your instructor, identify a particular information system that is not working very well and perform a preliminary investigation of it. In your work, be sure to talk to (1) At least...
-
Wright Company employs a computer-based data processing system for maintaining all company records. The current system was developed in stages over the past five years and has been fully operational...
-
The managers at Kenbart Company have decided that increased emphasis must be placed on profit planning and comparing results to plans. A new profit planning system has been implemented to help with...
-
10. The probability that automobile sales will increase next month (A) is estimated to be 0.40. The probability that the sale of replacement parts will increase (R) is estimated to be 0.50. The...
-
You are trying to prepare financial statements for Bartlett Pickle Company, but seem to be missing its balance sheet. You have Bartlett's income statement, which shows sales last year were $630...
-
Custom Cabinetry has one job in process (Job 120) as of June 30; at that time, its job cost sheet reports direct materials of $6,400, direct labor of $3,400, and applied overhead of $2,890. Custom...
Study smarter with the SolutionInn App