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

Ip21 excel add in - The red badge of courage and camouflaging the chimera - Sponge plowed guitar lesson - The stock of business adventures sells for $40 - The first step in the screening process for potential markets and sites is to ________. - How to draw a crime scene sketch - Beweep in a sentence - Case Study - Characteristics of mother munchausen by proxy cases - 1123 hours in days - Products such as furniture, audio equipment, bicycles, and clothing are generally classified as: - Pythagorean theorem and trigonometry worksheet answers - Physical or behavioral signs of incipient puberty - Rock climbing powerpoint presentation - A common size income statement for creek enterprises - Peugeot 308 sw boot dimensions - Postera crescam laude translation to english - Narrow band pass filter using op amp - Forensic toxicology worksheet answers - Sea doo rxt 260 rs specifications - Geometry similar polygons assignment - Legal aspects of health care administration 13th edition pdf - Comp xm round 1 answers - Unsw student card lost - Porosity and permeability animation - Getting paid math worksheet 2.3 9 a1 answers - Mary kay in india case study - In what way is zaroff portrayed as rainsford's foil - Range rover revere 2010 - Down under products ltd of australia has budgeted sales - The kgb and the world pdf download - Drama Analysis - Capital punishment sherman analysis - Statement addressing selection criteria format - Thank you for your interest in working with us - The unfinished nation volume 2 8th edition pdf - Uow subject database 2021 - Banning cellphones in school statistics - Chemistry yr 11 data sheet - Born haber cycle practice questions - Discussion.. - Unsw arc clubs handbook - Routine Messages - Accounting class - Lecture summary sample - Psyc reading homework - Math homework - Qantas social media strategy - Help 2 - Blue haven spa manual - Answer 10 Questions correctly - As4100 - Product design at regal marine case study answers - Nessus plugin id 19506 - Community promoting - Steve biko academic hospital occupational therapy pretoria - Bikini bottom genetics 2 answer key - Karisma travel agent login - Bones of the orbit - Box and whisker plot minitab - The best active empathic listening response below is - Why are there few absolutes in ob - Vcaa definitions for biology - Electrical Engineering Lab 1 - Cost of capital case study - Sitting Bull - In stoichiometry chemists are mainly concerned with - Www aida live com audios - Pecha kucha presentation rubric - Jennie celeste parks williams - Specky magee book 1 summary - A standard cost system may be used in cpa adapted - Hsco 506 mcminn book review - Quaid e awam public school larkana - Role of nurse as a social change agent - KPI Paper - 1.2 9 practice complete your assignment - Under armour accounts receivable turnover - Part 3: BRD - The speckled band summary - Why are books better than television - Sociological Research Discussion - Illawarra tree top walk address - Nursing Shortage Case - Domestic containment - Jen purchased a condo in naples florida - Best practices for lan domain compliance - Affirmative vs negative debate - Fragile planet organic apple juice - Camino por el hospital. camino por los pasillos del hospital. camino en dirección al hospital. - Costas Social Strategy 3 - Essay questions on socialization - Interview - BusinessManagement - Regency grand hotel case study analysis - Assignment 2 - Chicago speakeasies in the 1920's - Which situation indicates a weak internal control structure? - Andy cano menendez death - Stoichiometry lab the determination of the mass of product