An important skill accountants and business leaders must dem…
An important skill accountants and business leaders must demonstrate is the ability to create, read, and understand how a system and/or process works, often through the creation of flowcharts. As practiced in this class, to create a good flowchart, one should emphasize [choice1] and put less emphasis on [choice2].
Read DetailsYou have been hired by Initech Consulting and have been aske…
You have been hired by Initech Consulting and have been asked to thoroughly document the existing accounting information system in preparation for making recommendations for improvements. You begin by meeting with the information technology staff in order to develop a flowchart illustrating the flow of information through the system, including points of interest such as: how do users log into the system; points of data entry by users; how data and/or information is accessed; and where data is stored. The flowchart you are developing is best described as a ____________________.
Read DetailsBecause the company uses a double-entry accounting system, a…
Because the company uses a double-entry accounting system, all journal entries should net to zero ($0) because the debits (Dr) equal the credits (Cr). As a result, a common red flag of fraud is journal entries that do not net to zero ($0) (i.e., are unbalanced) How many unbalanced journal entries are there? (note: a journal entry with two (2) lines would be considered one (1) journal entry so please make sure to count distinct)
Read DetailsAs part of some data analysis you are building relationships…
As part of some data analysis you are building relationships among data tables in Tableau based on your client’s business rules. To help you understand the relationships among data tables your client provides you the following entity relationship diagram (ERD) related to its sales and invoicing process. Given the cardinalities as presented by your client below, which of the following business rule statements is true?
Read DetailsTableau Problem #2 – Use the following information to answer…
Tableau Problem #2 – Use the following information to answer questions 46 through 50. Assume you have been doing a departmental rotation for the past year at your company and have just rotated into the Internal Audit department. A Senior Internal Auditor has asked for your help in evaluating employee expense reimbursements for potential violations of Human Resources (HR) and Payroll policies such as employees approving their own expense reports, or purchases from prohibited vendors, etc.. As a result, employee expense data has been extracted into the Excel spreadsheet linked below. The data you receive is broken out as follows: Expense Reimbursement Data worksheet with the following data fields: Expense Report Tracking Number: number that uniquely identifies the expense report an expense is associated with (SC246062) Approver Employee Number: employee number of the employee that approved the expense report (EE070464) Approver Name: name of the employee that approved the expense report in last name, first name format (Cooper, Mary) Expense Approved Date: the date the expense report was approved in month/day/year format (03/12/25) Reimbursement Paid Date: the date the expense was reimbursed to the employee in month/day/year format (03/12/25) Expense Category: name of the expense category such as ‘hotels’ or ‘meals’ or ‘air’ Airline Ticket Number: number that uniquely identifies airline ticket numbers Transaction Date: date the expense was incurred in month/day/year format (03/12/25) Vendor: name of the vendor where the expense was incurred Employee Number: employee number of the employee that incurred the expense (EE070464) Employee Name: name of the employee that incurred the expense (EE070464) Department: name of the department of the employee that incurred the expense (Sales) Transaction Amount: dollar amount of the incurred expense Specifically, you are to: download and save the following data ‘Expense Reimbursement Data.xlsx’; look through the data in Excel – this will help you become familiar with the data connect Tableau to the data; there are 13 fields with 9,176 rows in the data – before beginning, please double check the ‘Data Source’ tab in Tableau to ensure all data has been loaded. In addition, in order to perform certain distinct counts you will need to duplicate the ‘Expense Report Tracking Number’ dimension and convert that duplicate into a measure. using Tableau, answer the questions that follow; and delete the data file once finished.
Read DetailsYou’ve been asked to analyze some Human Resource and Payroll…
You’ve been asked to analyze some Human Resource and Payroll data that is stored in two different tables. To start your analysis you join the data tables in such a way so that only matches across both tables remain (i.e., records or values that do not have a match are dropped entirely). What type of join have you performed?
Read DetailsYour company has identified the following risk regarding its…
Your company has identified the following risk regarding its pricing process: “Collusion between a pricing employee and a purchaser to award contracts via insider information or kick-backs may result in financial loss.” Choose from the list below the control activity that would not help mitigate this pricing-related risk.
Read Details