Overview You are an internal auditor for a corporation. The company reimburses employees when they travel...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Overview¹ 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.58 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 company's 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 Internal Audit learned about robotic process automation (RPA). RPA allows a person to program a bot to automate tasks that a human would have performed. The head of Internal Audit assigned an internal auditor to design a bot that automatically calculates the distance traveled for every trip leg. Using RPA, the internal auditor was able to collect the data for every trip leg traveled by employees for the last year. The internal auditor has given you the output from this bot to analyze in preparing your report for the head of the Audit Committee. The output file is a labeled Case_study_dataset.xlsx and contains three sheets. The first sheet is labeled "TravelSheet." This sheet has 14 columns defined as follows: Lineld: is a unique identifier for each line in the data set. Business TripID: is a unique identifier for each trip an employee takes. A trip includes all legs traveled by the employee. LineltemID: is a unique identifier for each unique trip leg on a business trip. EmployeeID: is a unique employee number assigned to each employee. StartAddress, StartCity, StartZip, StartState: are the beginning address, city, ZIP and state for a travel leg, respectively. EndAddress, EndCity, EndZip, EndState: are the ending address, city, ZIP and state for a travel leg, respectively. Reported Distance: is the distance that the employee reported traveling between the two locations. Validated Distance: is the distance the RPA bot reports that was traveled between the two locations. The sheet labeled "EmployeeData" contains the employee ID, first name, last name, address, and office for each employee. The sheet labeled "CustomerData" contains the customer ID, name, and address for each customer. Implementing an Analytics Mindset As you perform this case, remember the value of using an analytics mindset. An analytics mindset is the ability to: Ask the right questions > Extract, transform and load relevant data Apply appropriate data analytics techniques Interpret and share the results with stakeholders Required Prepare visualizations in Tableau to answer each of the following questions and prepare a report for the head of the Audit Committee. 1. How much money was spent on reimbursing employees for travel expenses? How much money do you estimate was spent for misreported reimbursements? 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? 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. 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. 5. Create at least one additional visualization that adds information relevant to your examination. Apply the analytics mindset (AMPS framework) to guide you and explicitly consider each step. 6. Prepare a report for the Audit Committee regarding your audit analytics procedures and findings regarding the audit of the employee travel expenses. 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. Overview¹ 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.58 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 company's 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 Internal Audit learned about robotic process automation (RPA). RPA allows a person to program a bot to automate tasks that a human would have performed. The head of Internal Audit assigned an internal auditor to design a bot that automatically calculates the distance traveled for every trip leg. Using RPA, the internal auditor was able to collect the data for every trip leg traveled by employees for the last year. The internal auditor has given you the output from this bot to analyze in preparing your report for the head of the Audit Committee. The output file is a labeled Case_study_dataset.xlsx and contains three sheets. The first sheet is labeled "TravelSheet." This sheet has 14 columns defined as follows: Lineld: is a unique identifier for each line in the data set. Business TripID: is a unique identifier for each trip an employee takes. A trip includes all legs traveled by the employee. LineltemID: is a unique identifier for each unique trip leg on a business trip. EmployeeID: is a unique employee number assigned to each employee. StartAddress, StartCity, StartZip, StartState: are the beginning address, city, ZIP and state for a travel leg, respectively. EndAddress, EndCity, EndZip, EndState: are the ending address, city, ZIP and state for a travel leg, respectively. Reported Distance: is the distance that the employee reported traveling between the two locations. Validated Distance: is the distance the RPA bot reports that was traveled between the two locations. The sheet labeled "EmployeeData" contains the employee ID, first name, last name, address, and office for each employee. The sheet labeled "CustomerData" contains the customer ID, name, and address for each customer. Implementing an Analytics Mindset As you perform this case, remember the value of using an analytics mindset. An analytics mindset is the ability to: Ask the right questions > Extract, transform and load relevant data Apply appropriate data analytics techniques Interpret and share the results with stakeholders Required Prepare visualizations in Tableau to answer each of the following questions and prepare a report for the head of the Audit Committee. 1. How much money was spent on reimbursing employees for travel expenses? How much money do you estimate was spent for misreported reimbursements? 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? 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. 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. 5. Create at least one additional visualization that adds information relevant to your examination. Apply the analytics mindset (AMPS framework) to guide you and explicitly consider each step. 6. Prepare a report for the Audit Committee regarding your audit analytics procedures and findings regarding the audit of the employee travel expenses. 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.
Expert Answer:
Answer rating: 100% (QA)
Table of Contents Field notes 2 Audit Report 2 1 Reimbursement Spend for Employees Travel Expenses 3 2 Office Reimbursement Spend for Employees Travel Expenses 9 3 Reimbursement Spend for each Employe... View the full answer
Related Book For
Ethics in Accounting A Decision Making Approach
ISBN: 978-1118928332
1st edition
Authors: Gordon Klein
Posted Date:
Students also viewed these general management questions
-
In your role as an internal auditor for a car manufacturer, you discovered that your employer can produce a car engine that will get 8 more miles per gallon than the existing engine. However, the...
-
You are an internal auditor at Dunder Company. An employee of Dunder has phoned in an anonymous tip that a fellow worker, Jane, might be embezzling money. Jane has been a trusted employee of the...
-
You are the internal auditor for a company that started over 40 years ago as a local retailer of major home appliances. The company has now grown to include 55 retail stores in 12 metropolitan areas....
-
Use any method to evaluate the limit or show that it does not exist. lim (x,y) (0,0) x - y x + y
-
What are the three important contributions of the University of Michigan and Ohio State University studies?
-
A mud slurry is being drained from a tank through a $50 \mathrm{ft}$ long plastic hose. The hose has an elliptical cross section with a major axis of $4 \mathrm{in}$. and a minor axis of $2...
-
In a survey conducted by the National Center for Health Statistics, the sample mean height of women in the United States (ages 2029) was 64.2 inches, with a sample standard deviation of 2.9 inches....
-
Identify which control activity is violated in each of the following situations, and explain how the situation creates an opportunity for fraud or inappropriate accounting practices. 1. Once a month,...
-
2. Set up the following equations in the computer form: a. x+y=2+y-z 3z-1 b. 2xzy+x+ 4(3z+1)-y C. x = (y + z)
-
Randy Corp. issued $200,000 of 7.6% (payable each 28 February and 31 August), 4-year bonds. The bonds were dated 1 March 20X4, and mature on 28 February 20X8. The bonds were issued (to yield 8%) on...
-
2 Is it possible to factor 1 - sin x two different ways? If so, show and explain. If not, why not?
-
Tolo Co. plans the following repurchases: $9.9 million in one year, nothing in two years, and $19.1 million in three years. After that, it will stop repurchasing and will issue dividends totaling...
-
What approaches does your college take to reduce the volume of waste generated on campus? If you could implement one additional waste- reduction policy, what would it be?
-
Shatin Intl. has 9.8 million shares, an equity cost of capital of 12.7% and is expected to pay a total dividend of $20.7 million each year forever. It announces that it will increase its payout to...
-
What criterion does John Rawls suggest for decisions about how to act? Would you favor limits on gasoline use in the present under this criterion?
-
Halliford Corporation expects to have earnings this coming year of $2.77 per share. Halliford plans to retain all of its earnings for the next two years. Then, for the subsequent two years, the firm...
-
One of Edward L. Bernays's biggest contributions to the field of public relations was a. designing the first degree program in public relations. b. recruiting Don Hillman, the first distinguished...
-
The Higher the time period of the financial security the higher the. ............... risk. O a. Maturity O b. Default and Maturity Oc. Default O d. Liquidity
-
When you were at the office late at night, you were shocked to see a colleague in the Government Contract Accounting Verification Department make derogatory remarks about a fellow employee's...
-
For many years, the IRS would select 50,000 tax returns at random for audit and demand that taxpayers meticulously substantiate every line item on their tax returns. This program was called the...
-
Have you ever knowingly worn a counterfeit version of a famous brand-name item? If so, did your action cause any harm to the company that produces goods bearing that brand name? Did it cause any harm...
-
This chapter discusses the use of job redesign to reduce turnover. Do you think this is feasible in this case? Why or why not? If so, how should the job be redesigned?
-
What other solutions could you see be effective at improving employee motivation and reducing the turnover rate? Why do you believe these solutions would be useful?
-
Should the whole team have decided on the team members schedule accommodations collectively? Why or why not?
Study smarter with the SolutionInn App