Our Services

Get 15% Discount on your First Order

[rank_math_breadcrumb]

The total amount is for ALL 3 PARTS!!! Using Excel to Examine Revenue Trends and Outliers in the U.S. Department of Interior Data First, access the following database: U.S. Department of Interior Natu

The total amount is for ALL 3 PARTS!!!

Using Excel to Examine Revenue Trends and Outliers in the U.S. Department of Interior Data

First, access the following database: U.S. Department of Interior Natural Resources Revenue https://revenuedata.doi.gov/downloads/revenue/.

Next, download the file named: Fiscal year revenue, 2004 – 2023 (csv, 4MB)

Open the document in Excel (or Google Sheets) and perform the following tasks to analyze revenue trends and identify outliers in the data:

  1. Sort the document by State. Which 2 states produce the most revenue? How do you interpret the amounts that are marked as zero?
  2. Sort the document by Revenue Type. What are the top 2 revenue types in terms of revenue amount (Column L)?
  3. Use the Filter tool to filter the data for New Mexico, North Dakota, and Wyoming, individually. Which state would you focus on in terms of unexpectedly large revenue increases between 2020 and 2021?
  4. Filter the sheet by the two largest revenue-producing states and product type: oil. Save a copy of this view or a screenshot to include in your deliverable.
  5. Shift your attention by searching  for unusual or outlier observations. Filter the data to identify the two largest oil-producing counties in New Mexico.
  6. Within these two counties, locate the ten smallest (ex. negative amounts) and the ten largest revenue amounts, filtering the revenue into bonuses, other, rents, and royalties. Save a copy of each view to include in your deliverable.
  7. Write a brief 1-page memo to your audit senior explaining your data search, your thoughts on what you observed, and which revenue transactions need further evidence gathering based on their valuation.

Your deliverable will consist of 3 parts:

Part 1: Answering the questions from Steps 1, 2, and 3.Part 2: PDF copies or screenshots from Steps 4 and 6.Part 3: A 1-page memo as outlined in Step 6. Be sure to use complete sentences, be clear and concise in how you write, and have a clear introduction and conclusion.

Your deliverable should conform to APA guidelines

Share This Post

Email
WhatsApp
Facebook
Twitter
LinkedIn
Pinterest
Reddit

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Review the scenario and watch this week’s videos before you complete the activity below. This scenario can also be found in the “Problems – Series A” section 8-19A of Ch. 8, “Performance Evaluation” o

Review the scenario and watch this week’s videos before you complete the activity below. This scenario can also be found in the “Problems – Series A” section 8-19A of Ch. 8, “Performance Evaluation” of Fundamentals of Managerial Accounting Concepts. Scenario: The Redmond Management Association held its annual public relations luncheon in April Year 2.

Topic: Interpret income tax disclosures in financial statements In this discussion, please reflect on the previous weeks’ topics. Choose a topic you find to be difficult or hard to understand. Researc

Topic: Interpret income tax disclosures in financial statements In this discussion, please reflect on the previous weeks’ topics. Choose a topic you find to be difficult or hard to understand. Research this topic using AI (Copilot or Chatgpt.com, for example) and present your findings. Include a summary of the topic,

In this discussion, please research pension plans and post-retirement benefits for several public corporations. Find one with a defined benefit plan and one with a defined contribution plan. Interpret

In this discussion, please research pension plans and post-retirement benefits for several public corporations. Find one with a defined benefit plan and one with a defined contribution plan. Interpret the notes disclosing the plans, reviewing the notes and explaining the post-retirement benefits that the corporations offer. This discussion supports CO-3 by

Write 200–250 words that respond to the following questions with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. Please complete the following:

Write 200–250 words that respond to the following questions with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas.  Please complete the following: An entrepreneur is someone who has a passion and desire to organize and operate their own business. Using a business plan, an

Company: Samsung In this discussion, research income tax disclosures for a public corporation and access the impact of the tax differences on the income statement. Research this topic using AI (Copil

Company: Samsung In this discussion, research income tax disclosures for a public corporation and access the impact of the tax differences on the income statement.  Research this topic using AI (Copilot or Chatgpt.com, for example) and present your findings. Include a summary of the topic,  and what you learned after

KEONIA- UP TO 12/5/2025- ***** IMPORTANT: PLEASE MAKE SURE THAT ALL WORK IS AUTHENTIC- DO NOT USE AI/ PLAGERISE AS THE ASSIGNMENT WILL BE RUN THROUGH TURN IT IN!!!!!***** ****** THIS ASSIGNMENT HAS 4

KEONIA- UP TO 12/5/2025- ***** IMPORTANT: PLEASE MAKE SURE THAT ALL WORK IS AUTHENTIC- DO NOT USE AI/ PLAGERISE AS THE ASSIGNMENT WILL BE RUN THROUGH TURN IT IN!!!!!*****  ****** THIS ASSIGNMENT HAS 4 PARTS / PLEASE LABEL EACH PART SEPARATELY WITH REFERENCES WHEN COMPLETED****** **** FISCAL ACCOUNTABILITY **** PART

Write 200–250 words that respond to the following questions with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. For this Discussion Board, ple

Write 200–250 words that respond to the following questions with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas.  For this Discussion Board, please complete the following: A virtual business is any kind of business that is run via the Internet. With no physical location

Write 200–250 words that respond to the directions below with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. Payroll has many different parts.

Write 200–250 words that respond to the directions below with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. Payroll has many different parts. Not only is the employee paying taxes, but the employer is also paying additional payroll taxes. Watch the following

Company: Tesla In this discussion, please reflect on this weeks’ topics of corporate bonds and long-term debt. Choose a public corporation and evaluate the bond disclosure notes included with the fin

Company: Tesla  In this discussion, please reflect on this weeks’ topics of corporate bonds and long-term debt. Choose a public corporation and evaluate the bond disclosure notes included with the financial statements. Research this topic using AI (Copilot or Chatgpt.com, for example) and present your findings. Minimum 250 words  At

Write 200–250 words that respond to the following questions with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. For this Discussion Board, ple

Write 200–250 words that respond to the following questions with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas.  For this Discussion Board, please complete the following: When multiple employee personalities come into one business unit, there is a possibility of conflict happening.

Write 200–250 words that respond to the directions below with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. Internal controls are an important

Write 200–250 words that respond to the directions below with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. Internal controls are an important part of business operations. Internal controls are used to protect assets. Both companies and individuals use internal controls. Companies

Module 1 – SLPFinancial ReportingAssignment OverviewTraditional and Triple Bottom Line Reporting For managers in all departments, analyzing Traditional and Triple Bottom Line Reporting is important fo

Module 1 – SLPFinancial ReportingAssignment OverviewTraditional and Triple Bottom Line Reporting For managers in all departments, analyzing Traditional and Triple Bottom Line Reporting is important for making informed decisions that balance financial performance with social and environmental responsibility. It helps managers align strategies with sustainability goals, drive innovation, and support

Module 1 – CaseFinancial ReportingAssignment OverviewCompare Traditional Reporting vs. TBL Reporting Traditional reporting focuses solely on financial performance, while Triple Bottom Line (TBL) repor

Module 1 – CaseFinancial ReportingAssignment OverviewCompare Traditional Reporting vs. TBL Reporting Traditional reporting focuses solely on financial performance, while Triple Bottom Line (TBL) reporting evaluates financial, social, and environmental impacts, providing a broader view of a company’s sustainability and long-term value creation. In analyzing trends over five years of financial

Write 200–250 words that respond to the directions below with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. Adjusting entries are used to make

Write 200–250 words that respond to the directions below with your thoughts, ideas, and comments. Be substantive and clear, and use examples to reinforce your ideas. Adjusting entries are used to make sure that all revenue and expenses are recorded in the correct period. Last week you learned about four

Write a 1–2 page executive summary, along with an appendix of supporting information, in which you analyze an organization’s financial performance as well as its level of risk for lending and make and

Write a 1–2 page executive summary, along with an appendix of supporting information, in which you analyze an organization’s financial performance as well as its level of risk for lending and make and present a recommendation to help leadership make a loan decision. Collapse AllIntroduction This portfolio work project will

Listed below are several terms and phrases associated with the accounting concepts. Pair each item from List A with the item from List B that is most appropriately associated with it. 1. Expense recog

Listed below are several terms and phrases associated with the accounting concepts. Pair each item from List A with the item from List B that is most appropriately associated with it. 1. Expense recognition 2. Periodicity 3. Historical cost principle 4. Materiality 5. Revenue recognition 6. Going concern assumption 7.

Module 1 – CaseFinancial ReportingAssignment OverviewCompare Traditional Reporting vs. TBL Reporting Traditional reporting focuses solely on financial performance, while Triple Bottom Line (TBL) repor

Module 1 – CaseFinancial ReportingAssignment OverviewCompare Traditional Reporting vs. TBL Reporting Traditional reporting focuses solely on financial performance, while Triple Bottom Line (TBL) reporting evaluates financial, social, and environmental impacts, providing a broader view of a company’s sustainability and long-term value creation. In analyzing trends over five years of financial