A spreadsheet modeler creates a spreadsheet to calculate each employee's total wages for a time period. After completing the model, the analyst feels there is an error. Interpret the auditing information shown below to determine which of the following statements is TRUE. B C $11.50 per hour A 1 2 Wage 345 4 Employee Hours Total Wages 1 6 2. $460.00 99$402.50 7 3 28 $322.00 8 4 17 9 5 25 $195.50 $287.50 10 There is no error in the model. The model is incorrect because it is using the wrong information for the employee hours. The model is incorrect because it is using the wrong wage information. O The model is incorrect because it is using the wrong information for the employee hours and the model is incorrect because it is using the wrong wage information are both true.

A spreadsheet modeler creates a spreadsheet to calculate each employee's total wages for a time period. After completing the model, the analyst feels there is an error. Interpret the auditing information shown below to determine which of the following statements is TRUE. B C $11.50 per hour A 1 2 Wage 345 4 Employee Hours Total Wages 1 6 2. $460.00 99$402.50 7 3 28 $322.00 8 4 17 9 5 25 $195.50 $287.50 10 There is no error in the model. The model is incorrect because it is using the wrong information for the employee hours. The model is incorrect because it is using the wrong wage information. O The model is incorrect because it is using the wrong information for the employee hours and the model is incorrect because it is using the wrong wage information are both true.

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter1: Introduction To Cost Management

Section: Chapter Questions

Problem 1E: Classify each of the following actions as either being associated with the financial accounting...

See similar textbooks

Similar questions

During the audit of a manufacturing firm, you are performing audit data analytics based on the payroll file. You are examining the reasonability of deductions as a percentage of gross wages for the 12 months of the year and the results were summarized in the following scatter chart. Please interpret the visualization. Discuss any notable items you identified, potential causes, and further steps you would take. • Deductions as a % of gross wages 60.0% 50.0% 40.0% 30.0% 20.0% 10.0% 0.0% Months
INPUT VALIDATIONDescribe the types of input edits used for the following data in a payrollsystem. a. Employee nameb. Employee numberc. Social security number d. Rate per hour or salarye. Marital statusf. Number of dependents g. Cost centerh. Regular hours workedi. Overtime hours worked
You are auditing payroll for the Morehead Technologiescompany for the year ended October 31, 2013. Included next are amounts from the client’strial balance, along with comparative audited information for the prior year.Audited Balance Preliminary Balance10/31/2012 10/31/2013Sales $ 51,316,234 $ 57,474,182Executive salaries 546,940 615,970Factory hourly payroll 10,038,877 11,476,319Factory supervisors’ salaries 785,825 810,588Office salaries 1,990,296 2,055,302Sales commissions 2,018,149 2,367,962You have obtained the following information to help you perform preliminary analyticalprocedures for the payroll account balances.1. There has been a significant increase in the demand for Morehead’s products. Theincrease in sales was due to both an increase in the average selling price of 4 percentand an increase in units sold that resulted from the increased demand and an increasedmarketing effort.2. Even though sales volume increased there was no addition of executives, factorysupervisors,…
From the following information, prepare a general journal entry to record the employee benefits expense for Jagger Company for the weekly payroll of May 9. (Click the icon to view the payroll register.) Prepare a general journal entry to record the employee benefits expense for Jagger Company for the weekly payroll of May 9. (Record debits first, then credits. Explanations are not required. Round your answers to the nearest cent.) Es Date May 9 Get more help. Accounts PR Debit (... Credit Payroll register Employee Tad Ness John Yu Tom Wait Total Salary 910 650 830 Print Tax 173 89 158 Deductions CPP 43 30 39 Done ΕΙ 15 11 13 Clear all Net Pay 679 520 620 - X Check answer
Describe the types of application control used for the following data in a payroll system.a. Employee nameb. Employee numberc. Social Security numberd. Rate per hour or salarye. Marital statusf. Number of dependentsg. Cost centerh. Regular hours workedi. Overtime hours workedj. Total employees this payroll period
An auditor is skeptical about the assertion on the salary expenses. He collected information on the number of employees, categories of employees, their pay scales to estimate the amount of salary expenses. In this case the auditor is considering: O a. Relationship between financial and non- financial information O b. Anticipated results of the entity O c. Comparable information from previous period o d. Similar industry information
Completing the Payroll Register The Employee Payroll Register presents all the computations previously performed as it applies to this payroll period. Complete the following steps (if a field should be blank, leave it blank): Record the amount to be withheld for group insurance. Record the amount to be withheld for health insurance. Each worker is to be paid by check. Assign check numbers provided to the correct employee. Compute the net pay for each employee. Total the input columns. KIPLEY COMPANY, INC.Payroll RegisterFor Period Ending January 8, 20-- EARNINGS DEDUCTIONS NET PAY Name Gross OASDI HI FIT SIT SUTA CIT SIMPLE Grp. Ins. Health Ins. Ck. No. Amount Carson, F. $700.00 $43.40 $10.15 $48.00 $21.49 $0.42 $21.00 $20.00 Wilson, W. 897.04 55.62 13.01 68.00 27.54 0.54 26.91 50.00 Utley, H. 678.75 42.08 9.84 14.00 20.84 0.41 20.36 40.00 Fife, L. 877.10 54.38 12.72 33.00 26.93 0.53 26.31 50.00 Smith, L. 790.00 48.98 11.46 59.00…
You are the staff accountant working at a local tutoring center. The monthly financial statements (Income Statement, Statement of Retained Earnings, and Balance Sheet) were just finalized and released to the employees of the tutoring center. You hear some of the other employees talking about the financial statements. In most cases, the employees do not understand the purpose of the statements. You have been asked by your supervisor to create a MEMO to be sent to the employees of the tutoring center that includes the following: Select either the Balance Sheet OR the Income Statement and explain the purpose of the statement and why it is important (i.e. what should the reader know about the company by looking at the statement).
You are the staff accountant working at a local tutoring center. The monthly financial statements (Income Statement, Statement of Retained Earnings, and Balance Sheet) were just finalized and released to the employees of the tutoring center. You hear some of the other employees talking about the financial statements. In most cases, the employees do not understand the purpose of the statements. You have been asked by your supervisor to create a MEMO to be sent to the employees of the tutoring center that includes the following: Reflect on how you think you and your peers at the tutoring center may be able to apply this knowledge/understanding of accounting in your future (in your career, in your personal life, in any aspect of your life).
You are the staff accountant working at a local tutoring center. The monthly financial statements (Income Statement, Statement of Retained Earnings, and Balance Sheet) were just finalized and released to the employees of the tutoring center. You hear some of the other employees talking about the financial statements. In most cases, the employees do not understand the purpose of the statements. You have been asked by your supervisor to create a MEMO to be sent to the employees of the tutoring center that includes the following: Identify and explain (in words everyone can understand) each item in the accounting equation; what does each item represents and where does each item appear on the financial statements. Providing examples would be beneficial!
You are the staff accountant working at a local tutoring center. The monthly financial statements (Income Statement, Statement of Retained Earnings, and Balance Sheet) were just finalized and released to the employees of the tutoring center. You hear some of the other employees talking about the financial statements. In most cases, the employees do not understand the purpose of the statements. You have been asked by your supervisor to create a MEMO to be sent to the employees of the tutoring center that includes the following: Explain how accounting became a “norm” (what made a system of accounting necessary) and reflect on why YOU think it is beneficial for society as a whole to have a standard method of accounting.
the service center for a broke range company provides three functions to callers account status order confirmation and stock quotes measured for each of the services over one month then with the results 0.80 0.70 and 0.96 respectively. what is the overall rehability of the call center