Each year, the IRS audits a large number of individual income tax returns in the hopes...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Each year, the IRS audits a large number of individual income tax returns in the hopes of collecting additional revenue for the federal government and encouraging all income tax filers to honestly complete their income tax returns. To decide which returns to audit, the IRS uses a complex (and highly secret!) algorithm to determine which returns are most likely to have been filed incorrectly/fraudulently. The algorithm uses information from the return (income of various types, deductions of various types, etc.) to calculate a DIF (Discriminant Inventory Function) score to each return. Those returns with the highest DIF scores are deemed most likely to generate additional tax liabilities if they are audited. To gain some insight into the effectiveness of their audit process, the IRS has audited a randomly generated sample of income tax returns. The sample included 200 returns from each of three different audit classes (see below for definition of audit class), for a total of 600 returns. Information pertaining to this study can be found in the database "IRS Data.accdb". This database consists for three tables as described below: Tax Return (This table has information pertaining to each return in the sample) Soc Sec Number - The social security number of the person filing the return Income - The gross income of the person filing the return Audit Class - The audit class of the income tax return. Class 1 are the simplest returns (Form 1040A or 1040EX), Class 2 are medium complexity (Form 1040 without schedule C or F), and Class 3 are high complexity (Form 1040 with schedule C or F) DIF - The DIF score calculated for this return • • Auditor (This table has information on the IRS employees conducting the audits) Auditor ID - A unique employee number for each auditor Auditor Name - The name of the auditor • • Hourly Cost - The hourly cost (including benefits) of the auditor Audit (This table has information regarding the outcome of each audit that was performed) • Social Security Number - The social security number of the person filing the return Auditor ID - The ID number of the auditor (IRS employee) performing the audit ATR - The additional tax recommended as a result of the audit (i.e., the difference between the tax liability determined by the audit and the tax reported on the return, which could be negative if the person paid more taxes than they owed). Hours - The number of hours spent by the auditor performing the audit • Please use this database to perform the following activities 1. (10 points) What is the Primary Key for each of the three tables? What fields do you need to link as Relationships to make the tables work together? Be sure to create these links in Access before doing any further work. 2. (15 points) Create a list (sorted from highest income to lowest income) showing the Social Security Number, Income, Audit Class and ATR for all the tax returns filed by people who earned more than $1,000,000. How many records are there? Include an image to show the first several rows of this list. 3. (15 points) Create a list (sorted from highest audit cost to lowest audit cost) showing the Social Security Number, ATR, Hours, Hourly Cost and Audit Cost of all the tax returns that cost over $2,000 to audit. How many records are there? Include an image to show the first several rows of this list. 4. (20 points) Calculate the total gross proceeds to the IRS (total of all the additional tax recommended) if they were to audit all returns from this sample with a DIF score greater than 25,000. Include an image of your results that shows the total proceeds and the number of returns that would be audited. 5. (20 points) Calculate the average cost for performing an audit by Audit Class (i.e., you should have one average cost for Class 1, one for Class 2, and one for Class 3). Include an image of your results. 6. (20 points) Within Audit Class 3, if you only audit the 100 returns with the highest DIF score (i.e., above the median) what would be the total net proceeds (additional tax recommended less cost of performing the audit) to the IRS? What is the average cost of performing the audit? (Note: you may have to run multiple queries, where the results of one query is the input for another query, to answer this question.) Include an image of your results that shows both the net proceeds and the average cost of performing the audit. Each year, the IRS audits a large number of individual income tax returns in the hopes of collecting additional revenue for the federal government and encouraging all income tax filers to honestly complete their income tax returns. To decide which returns to audit, the IRS uses a complex (and highly secret!) algorithm to determine which returns are most likely to have been filed incorrectly/fraudulently. The algorithm uses information from the return (income of various types, deductions of various types, etc.) to calculate a DIF (Discriminant Inventory Function) score to each return. Those returns with the highest DIF scores are deemed most likely to generate additional tax liabilities if they are audited. To gain some insight into the effectiveness of their audit process, the IRS has audited a randomly generated sample of income tax returns. The sample included 200 returns from each of three different audit classes (see below for definition of audit class), for a total of 600 returns. Information pertaining to this study can be found in the database "IRS Data.accdb". This database consists for three tables as described below: Tax Return (This table has information pertaining to each return in the sample) Soc Sec Number - The social security number of the person filing the return Income - The gross income of the person filing the return Audit Class - The audit class of the income tax return. Class 1 are the simplest returns (Form 1040A or 1040EX), Class 2 are medium complexity (Form 1040 without schedule C or F), and Class 3 are high complexity (Form 1040 with schedule C or F) DIF - The DIF score calculated for this return • • Auditor (This table has information on the IRS employees conducting the audits) Auditor ID - A unique employee number for each auditor Auditor Name - The name of the auditor • • Hourly Cost - The hourly cost (including benefits) of the auditor Audit (This table has information regarding the outcome of each audit that was performed) • Social Security Number - The social security number of the person filing the return Auditor ID - The ID number of the auditor (IRS employee) performing the audit ATR - The additional tax recommended as a result of the audit (i.e., the difference between the tax liability determined by the audit and the tax reported on the return, which could be negative if the person paid more taxes than they owed). Hours - The number of hours spent by the auditor performing the audit • Please use this database to perform the following activities 1. (10 points) What is the Primary Key for each of the three tables? What fields do you need to link as Relationships to make the tables work together? Be sure to create these links in Access before doing any further work. 2. (15 points) Create a list (sorted from highest income to lowest income) showing the Social Security Number, Income, Audit Class and ATR for all the tax returns filed by people who earned more than $1,000,000. How many records are there? Include an image to show the first several rows of this list. 3. (15 points) Create a list (sorted from highest audit cost to lowest audit cost) showing the Social Security Number, ATR, Hours, Hourly Cost and Audit Cost of all the tax returns that cost over $2,000 to audit. How many records are there? Include an image to show the first several rows of this list. 4. (20 points) Calculate the total gross proceeds to the IRS (total of all the additional tax recommended) if they were to audit all returns from this sample with a DIF score greater than 25,000. Include an image of your results that shows the total proceeds and the number of returns that would be audited. 5. (20 points) Calculate the average cost for performing an audit by Audit Class (i.e., you should have one average cost for Class 1, one for Class 2, and one for Class 3). Include an image of your results. 6. (20 points) Within Audit Class 3, if you only audit the 100 returns with the highest DIF score (i.e., above the median) what would be the total net proceeds (additional tax recommended less cost of performing the audit) to the IRS? What is the average cost of performing the audit? (Note: you may have to run multiple queries, where the results of one query is the input for another query, to answer this question.) Include an image of your results that shows both the net proceeds and the average cost of performing the audit.
Expert Answer:
Answer rating: 100% (QA)
lets tackle each part step by step 1 Primary Keys and Relationships Primary Key for Tax Return table Soc Sec Number Primary Key for Auditor table Audi... View the full answer
Related Book For
Posted Date:
Students also viewed these finance questions
-
Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...
-
List three specific parts of the Case Guide, Objectives and Strategy Section (See below) that you had the most difficulty understanding. Describe your current understanding of these parts. Provide...
-
Refer to the information in Exercise 16-11. Using the direct method, prepare the statement of cash flows for the year ended June 30, 2017. IKIBAN INC. Comparatlve Balance Sheets June 30, 2017 and...
-
The partnership of Nuan Zhang and Jen Phuah needed additional capital to expand into new markets, so the business incorporated as A-1 Services Inc. The articles of incorporation under the Canada...
-
A constitutional amendment has been proposed that would force Congress to balance the budget each year (that is, outlays must equal revenues in each year). Discuss some advantages and disadvantages...
-
Factoring can be a good source of cash by selling excess inventory. a) True b) False
-
QSR magazine reports on the largest quick serve and fast casual restaurants in the United States. Do the various market segments (burger, chicken, sandwich, and pizza) differ in their mean sales per...
-
A wheel of 100 cm diameter, 1000 N weight is resting against a block of 25 cm height. Find minimum force P at angle 45 with horizontal when the wheel is just on the point of climbing the block. P...
-
A study was published by the Journal of the American Medical Association (JAMA) in July 2022 that evaluated the cannabinoid content (CBD and THC) and label accuracy of topical cannabinoid products...
-
Compute the inverse \(z\) transform of the functions below. Suppose that the sequences are right handed and one sided. (a) \(X(z)=\sin \left(\frac{1}{z} ight)\) (b) \(X(z)=\sqrt{\frac{z}{1+z}}\).
-
Given a sequence \(x(n)\), form a new sequence consisting of only the even samples of \(x(n)\); that is, \(y(n)=x(2 n)\). Determine the \(z\) transform of \(y(n)\) as a function of the \(z\)...
-
Explain how a \(5 \times 8\) option contract on electricity with daily exercise works. Explain how a \(5 \times 8\) option contract on electricity with monthly exercise works. Which is worth more?
-
Compute the impulse response of the system with transfer function \[H(z)=\frac{z^{2}}{4 z^{2}-2 \sqrt{2} z+1}\] supposing that the system is stable.
-
Why does hedging a short call option involve a buy high, sell low strategy?
-
I. Fill the letter of correct answer in the brackets. (3 items, 3 points per item, a total of 9 points) Score 1. The internal forces of a statically deteminate structure may be influenced by: A. the...
-
-x/2 x/4 If A = -x/2 and A-1 =6 then x equals
-
Pesticides are chemicals often used in agriculture to control pests. In Pakistan, 70% of the population depends on agriculture, and pesticide use there has increased rapidly. In the article,...
-
As we mentioned on page 403, the following relationship holds between hypothesis tests and confidence intervals: For a two-tailed hypothesis test at the significance level , the null hypothesis H0: 1...
-
a. Find the y-intercept and slope. b. Determine whether the line slopes upward, slopes downward, or is horizontal, without graphing the equation. c. Use two points to graph the equation. y = 8 4x
-
The Wechsler IQ test is designed so that the mean is 100 and the standard deviation is 15 for the population of normal adults. Find the sample size necessary to estimate the mean IQ score of Delaware...
-
An economist wants to estimate mean annual income from the first year of work for college graduates who have had the profound wisdom to take a statistics course. How many such incomes must be found...
-
We can interpret the confidence interval given in Exercise 1 by saying that there is a 95% chance that the true population proportion will fall between 0.393 and 0.553. Decide whether the statement...
Study smarter with the SolutionInn App