Inventory Reserve: When Cycle Count Accuracy Masks Obsolescence
Northline Components distributes semiconductors and has 12,400 active SKUs across three warehouses. Management reports cycle count accuracy of 98.6% and a slow-moving and obsolete (SLOB) reserve of $1.2 million against inventory of $46 million. Internal audit's planning analytics show that 31% of SKUs have had no sale in 270 days, and the reserve covers only 6.4% of the cost of those SKUs. The inventory subledger is a legacy system; warehouse movements are recorded in a separate WMS, and the interface runs nightly with an exception log that IT clears weekly. The controller says the reserve is based on a formula approved by the prior CFO and that the auditors signed off last year. The audit committee has asked for assurance before the year-end earnings release in 25 days. The engagement team has two auditors, one of whom is new and has not tested IT interfaces. Management will not allow a full physical count before close but will permit a sample.
1. Define the population and design a test to determine whether the inventory reserve is materially misstated. Address completeness and the WMS interface.
Read the worked answer
Start with the population and the interface, not the sample. The population is every SKU in the inventory subledger, reconciled to the WMS, at the balance sheet date. The nightly interface may drop or duplicate records; test it by comparing record counts and hash totals, reviewing the exception log for the period, and re-running one interface cycle. A 98.6% cycle-count accuracy rate addresses existence and count accuracy, not valuation. For valuation, stratify the full SKU population by aging, last sale date, and value, and use analytics on all 12,400 SKUs rather than relying only on a sample. Test the formula inputs: last sale date, demand forecast, contractual return rights, and historical write-offs. Challenge the 6.4% coverage of slow-moving items against the 31% with no sale in 270 days. Select a sample of high-value and high-risk SKUs for file review and, where possible, customer confirmation or subsequent-sales testing. Document the basis for sample size and selection. The objective is to conclude on the reserve, not to re-perform the count.
2. Assess the sufficiency and reliability of the evidence available given the 25-day deadline and the team's skills. What should the CAE do?
Read the worked answer
The evidence is not yet sufficient. One auditor is new and the team has no IT interface testing experience, so the CAE must assign a qualified IT specialist or co-source that work before relying on the WMS data. The 25-day deadline is a constraint, but it does not lower the evidence standard. Prioritize: reconcile the subledger to the GL and WMS, test the interface, run full-population aging analytics, and review the reserve formula. Use subsequent sales and customer returns as corroborating evidence. Supervise the new auditor's work and review the sampling documentation before it goes into the file. If management will not permit a full count, that is acceptable for valuation work, but the scope limitation should be documented. If key evidence cannot be obtained in time, issue an interim report or a qualified conclusion rather than an unqualified one. Prior-year sign-off is not evidence for the current year.
3. What should the CAE report to the audit committee if management refuses to adjust the reserve?
Read the worked answer
If management refuses to adjust, the CAE should report the disagreement, not resolve it by accepting management's position. The report should state the criteria (lower of cost or net realizable value), the condition (reserve coverage of 6.4% versus 31% of SKUs with no sale in 270 days), the cause (formula not updated, no demand review), and the effect (a quantified range of possible overstatement). Include management's response fairly summarized. If the amount could be material to the earnings release, communicate to the audit committee before issuance and consider whether the external auditor needs the information; do not wait for the normal report cycle. The CAE should avoid directing the adjustment but should make the risk and the basis for the conclusion clear. Follow up at the next close and retest the reserve. If the audit committee does not act, document that escalation.