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

Fsb-200s beam detector manual - Photography booking system project - Stage 1 assignment IFSM 300 - Sodium carbonate and hydrochloric acid - Angus & coote garden city - Plastic material properties ppt - Business law text and cases edition - Close reader mother tongue answers - Barrier games drawing instructions - Over the shoulder shot definition - Dave's esl cafe vietnam - Legal implications of moving business abroad - The last of us walkthrough - Used cooking oil msds - Ta hb 0007 1 - Horned pachyderm crossword clue - 250 words and two scholarly sources - Classical conditioning in advertising mcdonalds - Kaps institute of management pty ltd - Anti discrimination board nsw - The iep process spd 200 - Gst payable journal entry - Walmart china supply chain transformation ppt - Law - The solar opposites lesson analyzer - Discussion - Myers briggs test short - Discussion 2 - Photographer public liability insurance - Picot statement paper nrs 490 - Segmentation scheme - Nursing - Jsa for excavation and backfilling - Stihl ts410 service manual - Experiment 1 heart valves and pumps - 1105 shackleton road apex nc 27502 - Pharmasim simulation - Presidential Vote - Leininger's theory of culture care diversity - Cite examples of the research and development process. - A university teacher saved every email - STR (U3_RPL) - The medical centre coalisland - Advantages and disadvantages of market penetration ansoff matrix - Reflective journal-self appraisal 6 - What is the past tense of squeeze - Vocabulary rubric for words - Windhoek mines ltd of namibia is contemplating - People dream in black and white - What is star schema in sql - The poem juxtaposes two contrasted concepts spring and classroom - Walker art center library - A poll solicits a large number of college - Loftus and palmer study - Complex pdu packet tracer - Nichols and Gehart& Tutttle - Hector gaming company case study pdf - Dr and mrs vandertramp - Aaeri members in india - I Need a ( 4500 words) on Ebook Description About Vegetarian Diet - Paradise Lost 3 movie case study - Carlton nsw post code - Sikkens rubbol xd gloss colours - Gd engineering bandlock 2 - Fahrenheit 451 part 2 quiz - 2008 further maths exam 2 solutions - Case study analysis - Report - Dismissal of school on an october afternoon - I need 2 different versions on Academic business plan - Teaching of psychology - Shadow health cheat sheet - If one worker can assemble 9 products per hour - Piper warrior ii cockpit layout - City circle tram map - Michael moore norway prison - Work - The manager of a unit apartment complex - Centrelink crisis payment application form - C program that takes command line arguments - Beetroot pigment experiment biology - Thread 1 & 2 (180 words each) - Bus 308 week 1 assignment - Brook farm beliefs - 05.05 should free trade be a goal - Assisgment - Environmental ethics joseph desjardins pdf - Kloran download - Lewis dot diagram for water - Software development life cycle for Data in the Cloud Computing Environment - Itsa towel dragons den - Were is the love lyrics - Communication - Aws certification dumps pdf - You should adopt naming standards that do not convey information to potential system attackers. - Management information system of walmart - HR Blogging - University of johannesburg law faculty - How is ka calculated - Calculating elasticity of demand midpoint method