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

Http awards mtmrecognition com ns

03/12/2021 Client: muhammad11 Deadline: 2 Day

Case Analysis

Analytics mindset

P-card

Part VI:

Task 6

OSU’s internal controls prohibit transactions to purchase any of the following things:

· Alcohol

· Cash, cash advances, automated teller machine transactions

· Donations and sponsorships

· Gifts, gift cards, gift certificates

· Late fees

· Personal purchases of any type

Required

Using the same file from Week 3 Analytics mindset case studies PCard FY2014 that you already have loaded into IDEA you will perform the following:

Part 1

· Create reports in IDEA that will search for prohibited transactions from the list above.

· Perform two different types of searches (you can use Direct extract of Criteria) listed below for each of the 6 categories listed above for a total of 12 items.

· Search descriptions for possible key words that indicate internal control deviations (e.g., search descriptions for purchases of alcohol). The query should return the relevant information about the transaction for follow up investigation if needed.

· Search vendor names for possible key words that indicate internal control deviations (e.g., search vendor names for purchases from the ATM). The query should return the relevant information about the transaction for follow up investigation if needed.

· Based on these searches identify possible transactions, individuals or vendors that should be investigated further for violation of these internal control policies. Document your results in the attached worksheet (add additional rows if needed), by specifying the transaction date, the search criteria you used and the output you discovered (be sure to provide screen captures of the results). Write a brief statement about what additional tests you recommend performing on these transactions. An example is provided in the worksheet.

· Make sure you use professional judgment to eliminate false-positives. For example, purchasing rubbing alcohol for a laboratory would not be an example of a potential internal control violation even though alcohol was purchased.

Part 2

· Create reports in IDEA using the join feature, that will identify unauthorized cardholders making purchases and unauthorized agencies being used in the transactions.

· A)

· Perform two different types of queries listed below.

· Identify cardholders for possible indication of internal control violations where unauthorized cardholders are using the purchase cards. Join the cardholders list and compare it to the transaction list to see if any transactions need follow up investigation.

· B)

· Identify agency names or numbers for possible indication of internal control violations where unauthorized agencies are indicated on purchase card transactions. Join the agency name or number list and compare it to the transaction list to see if any transactions need follow up investigation.

· Based on these searches identify possible transactions that should be investigated further for violation of these internal control policies. Document your results in the attached worksheet (add additional rows if needed), by specifying the transaction date, the search criteria you used and the output you discovered (be sure to provide screen captures of the results). Write a brief statement about what additional tests you recommend performing on these transactions.

Part 3

· Create reports in IDEA using the gap and duplicate detection features, that will identify any gaps and/or duplicate transaction numbers.

· Perform the detection features listed below.

· Identify trans no that may be missing for possible indication of internal control violations since all transaction numbers are automatically generated. Use gap detection on the trans no field to see if any transactions need follow up investigation.

· Identify trans no that may be duplicates for possible indication of internal control violations since all transaction numbers are automatically generated. Use duplicate detection on the trans no field to see if any transactions need follow up investigation.

· .

Based on these features identify possible transactions that should be investigated further for violation of these internal control policies. Document your results in the attached worksheet (add additional rows if needed), by specifying the transaction date, the search criteria you used and the output you discovered (be sure to provide screen captures of the results). Write a brief statement about what additional tests you recommend performing on these transactions.

Part 1

Category and test

Transaction Date

Description of search criteria

Output Summary (print screen your output to insert into your paper)

Next steps

Alcohol

· Searched description field for Beer

· Searched description field for Wine

· No results were obtained

· No results were obtained

· No further work is needed for this query because this does not violate policy.

· No further work is needed for this query because this does not violate policy.

Cash

· Searched vendor field for ATM

· Searched vendor field for Cash

· No results were obtained

· No results were obtained

· No further work is needed for this query because this does not violate policy.

· No further work is needed for this query because this does not violate policy.

Donations

· Searched description field for Donation

· Searched vendor field for Sponsor

· No results were obtained

· No results were obtained

· No further work is needed for this query because this does not violate policy.

· No further work is needed for this query because this does not violate policy.

Gifts

· Searched description field for Gift

· Searched description field for Vendedor

· No results were obtained

· No results were obtained

· No further work is needed for this query because this does not violate policy.

· No further work is needed for this query because this does not violate policy.

Late Fees

· Searched description field for Late Fee

· Searched description field for Fee

· No results were obtained

· No results were obtained

· No further work is needed for this query because this does not violate policy.

· No further work is needed for this query because this does not violate policy.

Personal

See Print Screen# 12 for transactions date details

· Searched Merchant Category Code (MCC) field for Personal

· Searched Merchant Category Code (MCC) field for: MISCELLANEOUS PERSONAL SERVICES—NOT ELSEWHERE CLASSIFIED

· No results were obtained

· 25 results were returned that was described as a Miscellaneaus Personal Services not elsewhere classified

· No further work is needed for this query because this does not violate policy.

Contact the Oklahome State University Suppervisors and/or Cardholders to ask about this purchase.

Part 2

Category and test

Transaction Date

Description of search criteria

Output Summary (print screen your output to insert into your paper)

Next steps

·

· Print Screen #13

·

Print Screen #14

Oklahoma State University – South with Agency Number 1200 must be investigated (Add other steps here)

Part 3

Category and test

Transaction Date

Description of search criteria

Output Summary (print screen your output to insert into your paper)

Next steps

·

·

·

Analytics mindset case studies – P-card 1

© 2016 Ernst & Young Foundation (US). All Rights Reserved.

SCORE No. 04134-161US

Analytics mindset case studies – P-card 2

© 2016 Ernst & Young Foundation (US). All Rights Reserved.

SCORE No. 04134-161US

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:

Quick Mentor
Engineering Help
Best Coursework Help
Math Specialist
Buy Coursework Help
Top Grade Tutor
Writer Writer Name Offer Chat
Quick Mentor

ONLINE

Quick Mentor

This project is my strength and I can fulfill your requirements properly within your given deadline. I always give plagiarism-free work to my clients at very competitive prices.

$42 Chat With Writer
Engineering Help

ONLINE

Engineering Help

I am an elite class writer with more than 6 years of experience as an academic writer. I will provide you the 100 percent original and plagiarism-free content.

$15 Chat With Writer
Best Coursework Help

ONLINE

Best Coursework Help

As per my knowledge I can assist you in writing a perfect Planning, Marketing Research, Business Pitches, Business Proposals, Business Feasibility Reports and Content within your given deadline and budget.

$45 Chat With Writer
Math Specialist

ONLINE

Math Specialist

I am an elite class writer with more than 6 years of experience as an academic writer. I will provide you the 100 percent original and plagiarism-free content.

$37 Chat With Writer
Buy Coursework Help

ONLINE

Buy Coursework Help

I am an experienced researcher here with master education. After reading your posting, I feel, you need an expert research writer to complete your project.Thank You

$18 Chat With Writer
Top Grade Tutor

ONLINE

Top Grade Tutor

Being a Ph.D. in the Business field, I have been doing academic writing for the past 7 years and have a good command over writing research papers, essay, dissertations and all kinds of academic writing and proofreading.

$46 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

Essay - Crimson portal book brooklyn 99 - Benchmark - Capstone Project Change Proposal - Nasm assessment chart - Silver fiddle construction case study - O2 arena vehicle management system - Prentice hall world history chapter 18 - Register to vote washoe county nv - Section 129 conveyancing act 1919 - Mathematic - Bartender print to file - Needs of the various populations served in the criminal justice profession - Module 2 Activity & Discussion - Similarities between phenomenological and ethnographic research - Scientific method essay - Cantilever bridge strengths and weaknesses - Print n natural numbers in python - What is an appeal letter - Thank you letter to teacher - The beach a river of sand video - Financial Management - NUR601- REPLY TO DISCUSSION ANABEL - Ethics argument paper - A christmas carol staves - Ursula burns personal and organizational values - Why did the tay bridge collapse - Activity - Intro to human resource management - How to read german schematic - The little seagull handbook inquizitive - BW Texas Gov't Unit 2 Topic 4 - Multisim export to excel - Cost estimation methods in management accounting - Thors walden statue of jesus - Algebraic fractions corbett maths - A cylindrical specimen of a nickel alloy - Schemas openxmlformats org package 2006 content types - West common lane teaching practice - Discussion Post 4-1 - What is a thesis driven essay - 6155 broadway st indianapolis in 46220 - Words ending in ary - Max life growth super fund nav - How to determine ionic strength - Road and maritime services - Scottish endurance riding club - Shawshank redemption rooftop scene analysis - How to get analytic solver platform in excel - Describe the project identification and selection process - Reign of error diane ravitch pdf - Safe work method statements examples - Biomechanics in volleyball dig - Family assessment paper for social work - Essay questions about power - Chapter 8 data analysis and statistics chapter test form a - Operational definition of attitude - Ritz furniture has a contribution margin - Toucon collections - Business Case - Learners log book wa - Attitudes its the topic - Assignment 01.2: Interview Preparation - Ni circuit design suite pro - 2 crash course world history the indus valley civilization answers - Week-8 discussion cpm - Using models in science teaching - Conflicts in night by elie wiesel - How to make a mock website in powerpoint - Moodle koi edu au - MGT 365 Week 5 Discussion - Post And Response 2 - Sociocentric thinking - Mini Case Analysis 1000 words - Us army problem solving flowchart - Wk 2, HCS 355: Organizational Research - Bugsy malone character breakdown - Built environments unit of work - The ascent of money full documentary - William shakespeare biography answers - RM-RESEARCH-10 - Juniper ward park house - Queen mab speech full text - Introduction to microbiology ppt - The beginning of the song that diverts the heart poem - Nhtv breda university of applied sciences - Louis armstrong miles davis - Hot works permit template free - Assignment 1.1 a changing world thesis and outline - Maxine hong kingston tongue tied - Mary and kay inc a distributor of cosmetics throughout florida - Www nwlink com donclark hrd sat html - Practical connection assignment - 1984 war is peace ignorance is strength - Ap statistics chapter 1 test - Etta kralovec the end of homework - 560 fe - How to reset thermo king codes - Bazley v tortorich case brief - What advantages do collegiate entrepreneurs have when launching a business - Tan of a complex number - 2/2