Question: PR 4.1 (LO 1-4) Data Auditing Managerial Accounting Complete Project Plan You work in the internal audit group in your organization, and your supervisor has

PR 4.1 (LO 1-4) Data Auditing Managerial Accounting Complete Project Plan You work in the internal audit group in your organization, and your supervisor has asked you to analyze p-card data. The objective of the analysis is to understand p-card spending in the current year. The questions associated with the objective include: With which three vendors does the company spend the most money using p-cards? Which employee spends the highest dollar amount of money using the p-card? Review the data and complete the chart to document your data and analysis strategy choices. Objective and Questions Data and Analysis Strategies Risks Controls Objective: Understand p-card spending in the current year. Questions: What are the three vendors where the Company spends the most money using p-cards? Which employee spends the highest dollar amount of money using the p-card? Data: Use the data provided in the Excel file. Analysis: Use Excel to create a PivotTable that allows grouping of the p-card spending data by vendor and sort by the highest vendor. Use Excel to create a PivotTable to group p-card spending amount by employee and sort by the highest dollar amount by employee. 1. Data: 2. Analysis: 3. Data: 4. Analysis: Perform the analyses suggested in the chart. Summarize your results

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

I would like assistance with assignment 3 and 4 on the attached document I have been struggling with the subject and its my last AUI4863/102/0/2016 Tutorial letter 102/0/2016 ADVANCED INTERNAL AUDIT...

Need help with the final project ACC 640. The attached file includes rubrics and guidelines. ACC 640 Final Project Guidelines and Rubric Overview The final project for this course is the creation of...

I have done milestone 1,2 and 3 but need help articulating the final audit report based on these three documents. Final report (summary) should be 8-10 pages plus cover page and supporting documents....

Referring to the information of control environment factors below (very important) and the two interviews(YOUTUBE) and according to the case, generate a memo of Alchemy's internal environment based...

ACC 640 Final Project Guidelines and Rubric Overview The last venture for this course is the production of a review report with updates. Evaluating is a profitable ability in bookkeeping and...

Companychosen isAmazon. I need Phase III answered without using previous assignment submissions since school has data and document check. III. Memos: For this part of the assessment, you will use...

Write an engagement letter of no more than 1,050 words for a Section 404 audit of Apollo Shoes. Assume that Apollo Shoes is a publicly traded company for which the SEC requires an audit of internal...

Apollo case studies the question is on page 44 Apollo case studies the question is on page 44 Apollo case studies the question is on page 44 APOLLO SHOES, INC. An Audit Case to Accompany AUDITING AND...

ISSUES IN ACCOUNTING EDUCATION Vol. 26, No. 3 2011 pp. 521-545 American Accounting Association DOI: 10.2308/iace-50031 Breach of Data at TJX: An Instructional Case Used to Study COSO and COBIT, with...

***READ THIS FIRST*** I need the questions for Part 1 AND Part 2 answered for this case study. The answers must be well-written, detailed, and must answer each question fully with examples from the...

Petty Cash The petty cash fund of Teasdale's Auto Repair Service, a sole proprietorship, contains the following. The general ledger account Petty Cash has a balance of $300. Prepare the journal entry...

Read the case study Arthur Andersen LLP and answer the following question: In 2000, the SEC proposed new regulations that would limit consulting work by accounting firms. This proposal was not passed...

12. Why are bank credit card sales similar to cash sales for a business?

The first scenario will be a Verbal Judo scenario in which your scenario follows the standard Verbal Judo interaction: You need to ask somebody to modify their behavior either to do something or to...

(Appendices) INVENTORY TURNOVER. A recent annual report for The Limited shows cost of goods sold for the year of approximately $5,286 million and average inventory of approximately $769 million...

(Appendices) RECORDING SALES. Sullivan Company sells industrial cleaning supplies and equipment to other businesses. During the first quarter of 19x2, the following transactions occurred: a) On...

(Appendices) CORRECTING AN ERRONEOUS WRITE-OFF. The new bookkeeper at Karlin Construction Company was asked to write off two accounts totaling $1,710 that had been determined to be uncollectible....