| Course | ACC 680 Auditing and Data Analytics Core |
|---|---|
| Topic | Topic 7 |
| Paper type | Substantive analytic simulation |
| Length | About 960 words, 2 pages |
| Format | APA 7 student paper |
| School | Grand Canyon University (GCU) |
| Program | MS in Accounting |
| Updated | September 2026 |
Free sample paper for ACC 680 Topic 7
A Substantive Analytical Procedure for Hourly Payroll: A $39.31 Million Expectation, a $600,000 Difference and a $180,000 Residual That Keeps the Work Open
[Author Name]
Colangelo College of Business, Grand Canyon University
ACC-680: Auditing and Data Analytics Core
Topic 7 Assignment
[Instructor Name]
[Date]
The organization, setting and figures below are a composite written as a model document. No real employer, client, colleague or patient is described.
A Substantive Analytical Procedure for Hourly Payroll: A $39.31 Million Expectation, a $600,000 Difference and a $180,000 Residual That Keeps the Work Open
Task 1: Purpose (time allotted 4 minutes, used 3)
The procedure provides evidence on the occurrence and accuracy of hourly payroll expense at the Easton plant of Delmar Packaging, a composite manufacturer. An analytical procedure suits this cost because hourly payroll is driven by a few stable, predictable inputs, headcount, scheduled hours and contract wage rates, each available from sources independent of the payroll system. When the relationship between inputs and the account is plausible and predictable and the inputs are reliable, a substantive analytical procedure can provide persuasive evidence at lower cost than testing individual paychecks (American Institute of Certified Public Accountants, 1988).
Task 2: The Expectation (time allotted 10 minutes, used 11)
Each input comes from a source outside the payroll department. Headcount: the human resources monthly roster shows an average of 980 hourly workers for the year; before use, the December roster was agreed to plant badge-access records for the same month, with a difference of two workers, both on leave. Scheduled hours: the union contract sets a standard 40-hour week, 2,080 hours a year. Wage rate: the contract sets the average hourly rate at $19.00 through June 30, with a 3 percent increase to $19.57 from July 1.
Expectation: 980 workers times 2,080 hours, with half the year at $19.00 and half at $19.57, gives about $39,310,544, or $39.31 million.
The expectation is precise enough to be useful. Its main uncertainty is headcount, which varied between 960 and 1,000 during the year; using the monthly average rather than a year-end figure keeps that variation from distorting the result. A difference of one hour a week per worker would move the expectation by about $1 million, so scheduled hours were checked against the contract and against the plant's shift pattern, which runs five eight-hour days with overtime recorded separately. The expectation deliberately excludes overtime, bonuses and shift premiums, because none of those can be predicted from independent data; they are the first explanations to look for when the recorded amount exceeds it.
Task 3: The Threshold (time allotted 4 minutes, used 4)
The threshold for investigating a difference is $150,000, set on the planning date, before recorded payroll was obtained. It equals 30 percent of performance materiality of $500,000, the firm's guideline for accounts assessed at a moderate risk of misstatement; a higher-risk account would have used a lower percentage. Setting the threshold before seeing the recorded amount prevents it from being chosen to make a difference look acceptable.
Task 4: The Comparison (time allotted 3 minutes, used 2)
Recorded hourly payroll expense for the Easton plant is $39.91 million. The difference from the expectation is $600,000, recorded above the expectation, and it exceeds the $150,000 threshold, so it must be investigated.
Task 5: Working the Difference (time allotted 12 minutes, used 13)
Explanation sought: the plant manager stated that a product recall in March required two weeks of extended shifts to inspect and repack inventory.
Corroboration: the timekeeping system shows 21,500 overtime hours in the recall period, against a normal level of about 1,500 for two weeks, at a time-and-a-half rate on the $19.00 base, $28.50 an hour. The additional 20,000 hours at $28.50 total $570,000. Of that, $150,000 was charged to the recall reserve rather than payroll expense, as recorded in the recall reserve roll-forward, leaving about $420,000 in payroll expense. The plant's production log records the repack runs on the same dates.
The recall overtime explains $420,000. The remaining $180,000 is unexplained and exceeds the $150,000 threshold (Arens et al., 2020).
Other explanations were considered and ruled out. Shift premiums, paid for night work, were agreed to the contract rate and the night-shift roster and were already reflected in the average rate. Retroactive pay from the July increase was paid in July, not accrued at year end, so it does not distort the comparison. Temporary agency workers are paid through accounts payable, not payroll, and were excluded from both sides.
Task 6: Consequence (time allotted 5 minutes, used 5)
Because the residual exceeds the threshold, it cannot be treated as immaterial or attributed to rounding. The analytical procedure has not produced sufficient evidence for the full balance, and the residual is routed to tests of details. Pay rates for a selection of 40 employees will be agreed to the union contract and personnel files, and hours for the same employees will be agreed to timekeeping records for two pay periods, one in each half of the year. If those tests find a rate or hours error, it will be projected to the population and compared with the residual (American Institute of Certified Public Accountants, 2020).
Task 7: Conclusion (time allotted 4 minutes, used 3)
On the evidence obtained so far, $39.73 million of hourly payroll expense is supported by the expectation and the corroborated overtime. The remaining $180,000 is not yet supported. The procedure is not complete, and no conclusion on the occurrence and accuracy of the full balance can be reached until the detail tests are performed.
An examiner would mark down an answer that stopped at the $420,000 explanation and called the rest immaterial, because the residual exceeds a threshold set in advance. The value of an analytical procedure depends on treating that threshold as binding. Once it is crossed, the procedure has done its job by locating where more evidence is needed, and the auditor's task is to obtain that evidence rather than to argue the difference away.
Time Record
Total time allotted: 42 minutes. Total time used: 41 minutes. The expectation and the difference analysis each ran one minute over; the comparison ran one minute under.
References
American Institute of Certified Public Accountants. (1988). Analytical procedures (Statement on Auditing Standards No. 56). AICPA.
American Institute of Certified Public Accountants. (2020). Audit evidence (Statement on Auditing Standards No. 142). AICPA.
Arens, A. A., Elder, R. J., Beasley, M. S., & Hogan, C. E. (2020). Auditing and assurance services: An integrated approach (17th ed.). Pearson.
What the ACC 680 Topic 7 instructions ask for
ACC-680 Topic 7 asks students to perform a substantive analytical procedure in a simulation format. Many papers explain a difference away. The assignment rewards answers that state why an analytical procedure suits the account, build an expectation from independent sources, and set a threshold before comparing it with the recorded amount. Students should seek and corroborate explanations, separate the explained from the residual difference, route any residual above the threshold to detail testing and state a conclusion that matches the evidence.
How the ACC-680 Topic 7 example is put together
The finished simulation answer follows the exhibits in the order an examiner supplies them, every figure illustrative. The expectation comes from human resources and union records rather than from payroll: an average of 980 hourly workers, 2,080 scheduled hours each, at $19.00 an hour until a 3 percent contract increase on July 1. That gives $39.31 million. The threshold for investigation, $150,000, was set from performance materiality before recorded payroll was opened. Recorded payroll is $39.91 million, a difference of $600,000. Overtime during a product recall explains $420,000, corroborated by timekeeping records and the plant's production log. The remaining $180,000 still exceeds the threshold, so the answer does not call it immaterial; it routes the balance to detail testing of pay rates and hours. The response notes the time budgeted and used for each task.
ACC 680 Topic 7 rubric: what Excellent looks like
Faculty grading the simulation reward an expectation built from independent inputs. Excellent answers agree headcount to badge records before using it. Credit goes to a threshold dated ahead of the comparison. The rubric values corroborating the overtime explanation with two sources. The highest level treats the $180,000 residual as binding and leaves the conclusion open. Answers that call the residual immaterial after seeing it, or that build the expectation from payroll's own records, usually lose marks with graders. Recording time against each task's allowance is expected.
ACC 680 Topic 7 help: mistakes that cost marks
Simulation answers usually lose the most points at the expectation, when it is built from last year's payroll plus a growth rate, which tests the ledger against itself. Setting the threshold after seeing the $600,000 difference invites a limit chosen to fit, and graders check whether the threshold was fixed first. Accepting the recall overtime because management described it, with no timekeeping or production evidence, treats inquiry as corroboration. A frequent error is concluding that the remaining $180,000 is immaterial because it is small against $39.91 million, when the threshold exists precisely to prevent that judgment after the fact. Answers that ignore the July raise understate the expectation by about $580,000 and chase a difference their own arithmetic created. Time matters as well: a response that exhausts its budget on the expectation leaves later tasks unanswered and unscored.
Get an ACC-680 Topic 7 example written to your instructions
Send the ACC-680 Topic 7 instructions, the rubric and the simulation exhibits your section is working from. We write a custom example to them, with an expectation built from independent inputs, the threshold fixed before comparison, explanations corroborated, any residual carried to further testing and time noted per task, in 24 to 48 hours. The first one is free.
More ACC 680 papers and MS in Accounting samples
- ACC 680 Topic 1: Analytic Assertion Coverage Map
- ACC 680 Topic 2: Benford Screen Risk Memo
- ACC 680 Topic 3: Journal Entry Testing Workpaper
- ACC 680 Topic 4: Exception Triage Log
- ACC 680 Topic 5: Full Population Testing Dq Post
- ACC 680 Topic 6: Analytic Evidence Working Paper
- ACC 680 Topic 8: Review Note Response Memo
- ACC 670 Topic 7: Segment Disaggregation Analysis
- ACC 669 Topic 7: Two-level Liquidation Computation
- ACC 663 Topic 7: Plain-language Plan Letter
- ACC 653 Topic 7: Transfer Pricing Policy Memo
ACC 680 Topic 7 questions, answered
What makes an analytical procedure substantive?
Its design. The auditor develops an independent expectation precise enough to detect a misstatement that matters, sets in advance the difference that will be investigated, compares the expectation with the recorded amount and corroborates any explanation. Without the expectation and threshold, a comparison of two years' figures is only a scan that might suggest where to look, which is useful in planning but provides little evidence at the assertion level.
Why does the expectation's independence matter?
Because a figure derived from the account being tested cannot reveal a misstatement in it. Last year's payroll plus a growth rate carries forward whatever errors the ledger already holds. Headcount, scheduled hours and contract rates come from other systems and documents, so a disagreement between the expectation and recorded payroll means something. Those inputs still need their own reliability check, which is why the headcount was agreed to badge records.
How is the threshold chosen?
From performance materiality and the level of assurance the procedure is meant to provide, before recorded amounts are compared. A procedure carrying most of the evidence for an account needs a tighter threshold than one used alongside detail tests. Course materials and simulations usually supply or constrain the figure; what matters is that it is fixed first and that any difference above it is either corroborated or tested further.
Where can I find a free ACC 680 Topic 7 sample paper?
Every task is above: the purpose, the expectation, the threshold, the comparison, working the difference, the consequence, the conclusion and the time record. Tell us your simulation's exhibits for a free worked answer.
Why does the work stay open in ACC 680 Topic 7?
Overtime explains $420,000 of the $600,000 difference, and the $180,000 left exceeds the $150,000 threshold set in advance, so detail testing is required.