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