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
-
Using either a tape measure or a ruler, make a measurement of your height in metres. Give your answer to three decimal places (i.e. to the nearest millimetre). Does this question make sense to...
-
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...
-
At 0.0 C and 1.00 atm, 1.00 mol of a gas occupies a volume of 0.0224 m3. (a) What is the number density? (b) Estimate the average distance between the molecules. (c) If the gas is nitrogen (N2), the...
-
Draw a molecular orbital energy-level diagram for the gaseous heteronuclear diatomic molecule boron nitride, BN. How does it differ from that for C 2 ?
-
Repeat Problem 14.D2 except for countercurrent process with a. Three stages. b. Eight stages. Data From Problem 14.D2 Alumina solids are being washed to remove \(\mathrm{NaOH}\) from liquid entrained...
-
On December 21, 1988, Pan Am Flight 103 exploded 31,000 feet in the air over Lockerbie, Scotland, killing all 259 passengers and crew on board and 11 people on the ground. Among those killed was...
-
Topic : Foreign Exchange Exposure I Mini-Case : China Noah Corporation What is the business reason for China Noah's potential currency exposure? Does the company really need to subject itself to...
-
Get It Right, CPAs, has been retained to review its client's corporate formation calculations for 20XX. Maria, Roger, and Novak created Grassroots Tennis, Inc. (GTI), which began operations on March...
-
Rodriquez Company budget the following sales in units: January 30,000 February 20,000 March 40,000 Rodriquez's policy is to have 20% of the following month's sales in inventory. On January 1,...
-
Consider two 5-year bonds; one has a $9 %$ coupon and sells for 101.00 ; the other has a $7 %$ coupon and sells for 93.20 . Find the price of a 5-year zero-coupon bond.
-
If the spot rates for 1 and 2 years are $s_{1}=6.3 %$ and $s_{2}=6.9 %$, what is the forward rate $f_{1,2}$ ?
-
Find the convexity of a zero-coupon bond maturing at time $T$ under continuous compounding (that is, when $m ightarrow \infty$ ).
-
Sports Research International hired Demarcus Jones, an African American, for the position of social media coordinator. Revise the following sentences to reduce bias (e.g., gender, racial, ethnic,...
-
An analyst claims, It is not worth my time to develop detailed forecasts of revenue growth, profit margins, etcetera, to make earnings projections. I can be almost as accurate, at virtually no cost,...
-
What risks are involved with Westeron sourcing products from platforms such as Crowd Maester or Kickstarter?
-
The purpose of this case is to come up with a contingency plan[s] in order to sustain the program Move With Me, a program that serves thousands of community members throughout Lower Manhattan. The...
-
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
-
Define and explain the law of supply.
-
Discuss shifts in market supply.
-
Explain how the market equilibrium price and quantity are determined.
Study smarter with the SolutionInn App