Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

You are an internal auditor for a corporation. The company reimburses employees when they travel for work purposes using their own vehicles. To receive this

You are an internal auditor for a corporation. The company reimburses employees when they travel for work purposes using their own vehicles. To receive this travel expense reimbursement, the employee submits paperwork that lists the addresses of their departure and arrival locations, the total mileage they traveled and the total mileage to be reimbursed. If the employee has traveled to multiple locations, the paperwork will indicate the legs they traveled for the trip. A trip leg is the distance traveled between two points. For example, if an employee leaves their home, travels to one business, then visits another business and then returns home, the trip has three legs: (1) from their home to the first business, (2) the first business to the second business and (3) the second business back to their home.
Using this paperwork, an employee in the Payroll Department then calculates the reimbursement, calculated as miles traveled multiplied by the IRS reimbursement rate of $0.655 per mile. Employees are expected to track the mileage traveled to the nearest tenth of a mile. The company pays the employee the computed reimbursement amount in their next paycheck.
The head of the Audit Committee recently reviewed the companys financial data and thought the amount of employee travel reimbursement might be excessive. She asked you to conduct an audit of the travel reimbursements to see if employees are following company policies.
In the past, when Internal Audit would audit travel reimbursement expenses, the internal auditor would take a sample of the trips made by employees. The internal auditor would then use a commercial mapping service (Google Maps) to measure the distance between the departure and arrival locations. The auditor would then look for patterns in the sample and make recommendations based on their findings. Because of the time-consuming nature of gathering this data, the internal auditors were only able to look at a fraction of the nearly 4,000 trip legs that were made by employees in a year.
Recently, however, the head of IntConduct your analyses by preparing visualizations in Tableau. Your analyses should answer each of the following questions and your report should address the following requirements. Make sure that you clearly explain your process and how you arrive at your conclusions.
1. How much money was spent on reimbursing employees for travel expenses? How much money do you estimate was spent for misreported reimbursements?
Hint: you may need to create additional calculated variables in Tableau; Three new variables are needed: 1. reimbursement rate ($0.655 per mile); 2. misreported mileage([Reported Distance]-[Validated Distance]); 3. misreported expense (reimbursement rate x misreported mileage).
2. How much money was spent reimbursing each office for travel expenses? How much money do you estimate was spent for misreported reimbursements for each office? What is your best estimate of the correct amount of travel expenses that should have been reported for each office?
Hint: Tableau: step 1: open one worksheet: Columns-drag total expenses; misreported expenses; Rows-drag Offices; Step 2: create another new worksheet; create a new variable-should be expense([Reimbursement Rate]*[Validated Distance])
3. How much money was reimbursed to each employee? How much of the money that was reimbursed do you estimate was caused by misreporting for each employee? Separate employees by office and then sort to show the employee with the greatest misreported amount at the top of each office section.
Hint: Tableau: open a new worksheet: Columns: drag total expenses & misreported expenses; Rows: drag Offices; Employee ID; Full name(it is a new variable:First name + Last name).
4. For each employee that misreported an amount greater than $200, examine their misreporting behavior over time and provide a possible explanation for their behavior and any other evidence that might be relevant to their misreporting behavior. As a hint, although there is no time stamp in the file, the transaction Line ID is assigned so that larger numbers are assigned later in time.
Hint: Tableau: open a worksheet: Columns- drag Line ID; Rows-drag misreported mileage;
Next drag reported distance; misreported mileage; misreported expense; city; office; state; address into Tooltip.
5. What else can you learn? Create at least one additional visualization that adds information relevant to your examination. Apply the analytics mindset (AMPS framework) to guide you: explicitly consider and discuss each step in the context of your investigation.
6. Prepare a report for the Audit Committee explaining your analytical procedures and findings. In your report, you should describe the objectives of the procedures, the analyses you performed, your findings, and your recommendations. Whenever possible, quantify your findings and recommendations and use visualizations to convey meaning. pLEASE HELP WITH EXACT STEPS / AND HOW TO VISUALIZE IT ON TABLEAU INCLUDING THE FORMULAS

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

College Accounting Chapters 1-26

Authors: Douglas J. McQuaig, Patricia A. Bille

6th Edition

0395796997, 978-0395796993

More Books

Students also viewed these Accounting questions

Question

How can an energy producer use derivative markets to hedge risks?

Answered: 1 week ago

Question

Define Management or What is Management?

Answered: 1 week ago

Question

What do you understand by MBO?

Answered: 1 week ago

Question

What is meant by planning or define planning?

Answered: 1 week ago

Question

Define span of management or define span of control ?

Answered: 1 week ago