Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Internal control case study with answer

24/11/2021 Client: muhammad11 Deadline: 2 Day

Analytics mindset

P-card

Part I:

Background

You work as an internal auditor for Oklahoma State University (OSU). You were asked to perform an audit of the purchasing cards (P-cards) that are used on campus. P-cards are a business credit card that some employees are permitted to use to purchase necessary goods and services. If employees agree to certain rules, they can then use a P-card to make appropriate business purchases rather than using their own credit card. This allows the employee to avoid spending personal funds and seeking reimbursement. It also provides the business with greater control because the business can institute internal controls to limit types of purchases and avoid inefficient and fraudulent transactions. Organizations also can track spending using detailed P-card records provided by the credit card companies.

You have been assigned the task of auditing all of OSU’s P-card transactions. To perform this audit, you received a file of all P-card transactions for the entire state of Oklahoma (the state collects all transactions for state and higher education institutions).

The purpose of this case is to help develop your analytical mindset. An analytics mindset is the ability to:

· Ask the right questions

· Extract, transform and load (ETL) relevant data

· Apply appropriate data analytics techniques

· Interpret and share the results with stakeholders

For this case, you will perform the following task

Task 5 – Perform a test of various P-card internal controls.

* Adapted from original case

Analytics mindset

P-card

Part V:

Task 5

One of the key objectives of your internal audit is to determine if employees of OSU are following internal controls.

Required

· Using the data provided, perform the tests listed below to analyze whether there are potential internal control violations. Use the following matrix to guide your analysis. The matrix is set up as follows:

· The first column lists the internal control that should be operating.

· The second column identifies the test you should perform to evaluate the control.

· The third column lists how you should name the query or file with your results so your instructor can review your work (if you use multiple queries, use the query that contains your final results).

· Note that, although something is flagged as a potential internal control violation, it does not mean there has been a violation. There may be acceptable reasons for internal control deviations. The goal of this assignment is to identify higher-risk transactions, employees and vendors that should be targeted for additional testing.

Internal control

Test to perform and desired output

What to name query/file with output

Import the Excel data into IDEA (be sure you import all 3 tabs, the first row is the column headings, and 0 for blank fields). This data will be used again later in the course

Import

1. User shall not spend more than $50,000 per year.

Display the cardholder name and total amount spent during the year for all employees using summarization. Sort by the total amount spent with the larger amounts listed first.

Summarization

2. User shall not spend more than $10,000 per month without approval.

Display the cardholder name, total amount spent, and transaction date using summarization. Sort by larger amounts listed first.

Summarization 1

3. User shall not spend more than $5,000 per transaction.

Display all transaction details for transactions greater than $5,000 using the direct extraction command. Sort by the total transaction amount. Using field statistics identify the total amount of these transactions

Import- Transactions

4. Purchases should not be made out to the vendor or generic card holder

Be sure to use the original data set. Find all transactions where the vendor is the same as the cardholder last name (Question4) using direct extract. Again back to the original data set, see if the cardholder last name is named "Cardholder" (Question4a) using direct extract.

Duplicate

Question 4a

5. Purchases should not have the same transaction number, these are generated automatically by the system

Display duplicate transactions numbers (Question5), then using this data summarize the amount by transaction date (Question5a). Run the duplicate command again and summarize by cardholder (Question5b)

Question5, Question5a, and Quesiton5b

Duplicate 3

Summarization 2

Summarization3

6. Transactions are prohibited for expenses for food while traveling. A per diem for food expenses may be claimed using a travel voucher.

Find all transaction details about any transactions for FOOD in the description field (Question6). Sort them in ascending order by cardholder and then by the amount. Then look in the merchant category code field for anything related to GROCERY purchases (Question6a). Summarize by cardholder, sorted by highest amount first (Question6b).

Question6, Question6a, Question6b

Display a copy of the IDEA History File for this case

History

Answers

1.-

image1.png

2.-

image2.png

3-

image3.png

image4.png

4-

image5.png

4.a)

Nothing

image6.png

5.-

image7.png

5.a

image8.png

5.b

image9.png

6.- not found which means that everyone is complying with the policy

� The data for this case comes from the Purchase Card (P-card) Fiscal Year 2015 database and is made available under the Open Database License: � HYPERLINK "http://opendatacommons.org/licenses/odbl/1.0/" �http://opendatacommons.org/licenses/odbl/1.0/�. Any rights to individual contents of the database are licensed under the Database Contents License: � HYPERLINK "http://opendatacommons.org/licenses/dbcl/1.0/" �http://opendatacommons.org/licenses/dbcl/1.0/�. The data for this case is made publicly available at � HYPERLINK "https://data.ok.gov/dataset/purchase-card-pcard-fiscal-year-2015" �https://data.ok.gov/dataset/purchase-card-pcard-fiscal-year-2015�. Do not use the data set posted on the web. Use the one included by your professor because some of the transactions may have been changed or updated. Also, some data may have been altered, added or deleted to enhance learning objectives and, thus, you should not use the data to infer good or malicious intent by anyone listed in the data set.

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Pro Writer
Top Academic Guru
Innovative Writer
Top Academic Tutor
Peter O.
Financial Hub
Writer Writer Name Offer Chat
Pro Writer

ONLINE

Pro Writer

I have written research reports, assignments, thesis, research proposals, and dissertations for different level students and on different subjects.

$24 Chat With Writer
Top Academic Guru

ONLINE

Top Academic Guru

I find your project quite stimulating and related to my profession. I can surely contribute you with your project.

$16 Chat With Writer
Innovative Writer

ONLINE

Innovative Writer

I am a PhD writer with 10 years of experience. I will be delivering high-quality, plagiarism-free work to you in the minimum amount of time. Waiting for your message.

$27 Chat With Writer
Top Academic Tutor

ONLINE

Top Academic Tutor

I will provide you with the well organized and well research papers from different primary and secondary sources will write the content that will support your points.

$21 Chat With Writer
Peter O.

ONLINE

Peter O.

I have written research reports, assignments, thesis, research proposals, and dissertations for different level students and on different subjects.

$38 Chat With Writer
Financial Hub

ONLINE

Financial Hub

I am an academic and research writer with having an MBA degree in business and finance. I have written many business reports on several topics and am well aware of all academic referencing styles.

$50 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Payment express response codes - System analysis - What counseling theory am i - Literature Review Paper - Cooperative travel insurance privilege account - I need help solving - Project Performance - Fish cheeks by amy tan answer key - Robinson crusoe friday relationship - Digital marketing plan analysis 5 - Planet retail net group - Spirax sarco liquid drain trap - Kounin model of discipline pdf - Ari fleet phone number - Cap 1 M3 - REFLECTING ON READING #2 - How to write a self introduction speech outline - Journal Article - Choosing a differentiation and positioning strategy - MDP 500 FOUNDATIONS OF DEVELOPMENT: Delivering 3 speech - Wiley plus accounting answers chapter 12 - 2.5 worksheet iqr outliers answers key - Frost poem the road not taken - What is zeta in math - Sap new dimensional products - Reflecting on Reading - Key organizational enablers for effective demand management - Absolute lovers sj hooks epub - Https www random org dice num 1 - Which of the following elements of the marketing communication mix - Board of directors confidentiality agreement - Attributes of a polygon - The four i's of transformational leadership pdf - Peripheral vascular disease nursing assessment - X ray of duodenum cpt code - V srinivasan kunnakudi vaidyanathan - Statement - British microlight aircraft association - Cirque du soleil case study analysis - AstroloGy bAbA 7340613399 OnLinE reaL VashIKaraN sPecIaLIsT IN Bijapur - Radne raket 120 parts - 1: Describe at least 4 things that the earliest civilizations - What is wasted energy - Article reviews - Homework 5 AV - Paper 10 for Jennifer - Combating fake news in the digital age joanna m burkhardt - Does virtue ethics support abortion - Culturally Responsive Practice - Stack light color code - Several benefits as well as challenges associated with the use of Big Data Analytics in the e-Healthcare industry - Barton private hospital admission form - MGT312T Week 5 Knowledge Check SCORE 100 PERCENT - Computer gateway device crossword clue - Week 4 discussion cloud computing - Cork institute of technology - How are electrons arranged in an atom - How to compute the degree of operating leverage - Nicola de la haye - Analyzing and Comparing GLBA and HIPAA - Lab Assignment - Ani things fall apart - Country club management style - Church music department mission statement - 1 metre in cm - Responses - Hockenberry family care funeral home in atlantic - Anthropological kinship chart template - Essay - Bus Cont Plan&Disas Recov Plan (ISOL-632-A04) - Phd in Information Technology - The strategy making strategy executing process - Problem Set 7 - Personality Literature Review - Annotated Bibliography - Economic - Nothing works criminal justice - Ubi universal basic income is an unbelievably bad idea - Jarron draper - Does technology make us more alone argumentative essay - How to make elephant toothpaste with potassium iodide - 123 queen street melbourne pte - Who built the georgia guidestones - Unit 40 international marketing assignment - Companies with ethnocentric hrm orientations - Dometic 9100 power awning fabric replacement instructions - Western powders reloading guide - Molarity of naoh in titration with khp - Mount baw baw live cam - Where is the dna housed in a prokaryotic cell - Coperion k tron manual - Nursing C-W-P (due 24 hours) - Ozito rotary tool rtp 163 - Why did brutus betray caesar - The signal man question answers - Which one of the following is a transition metal - 88.4 kg to lbs - Possible conflict management and negotiation techniques - Pastor tony smith bio - Sealink ferry cape jervis - Discuss about the FIT2002 Global Treps Project : RACI Matrix. - Chapter 5 HR