Page 125 - JoFA_Jan_Apr23

TECHNOLOGY

Solver Parameters dialog box for sample size search

the total sample size needed to meet the auditor’s Objective input area (H21 or the name Precision_
desired monetary precision value. Difference) unchanged. Also retain the: (1) radio
button selection of Min; (2) check mark entered
REVISING SOLVER INPUTS TO SEARCH FOR into the Make Unconstrained Variables Non-
TOTAL SAMPLE SIZE Negative check box; and (3) the Evolutionary
Once strata boundaries are determined, information solving method in the Select a Solving Method
entered into the Solver Parameters dialog box dropdown box.
must be revised to support a search for the total However, the Solver must be told to vary the
sample size needed to meet the auditor’s desired application sample size to change the difference
precision value. To recall the Solver, select the between desired monetary precision and expected
Data tab and select the Solver option (at the monetary precision (cell H21 or the name
far right). When the Solver Parameters dialog Precision_Difference). This is accomplished by
box appears, leave the value specified in the Set replacing references to strata boundaries in the

34 | Journal of Accountancy March 2023