I would like you to help me complete the predictive analytical procedure on personnel expenses for non-production employees for the year. Procedures over the production labor costs will be performed separately so you will focus on the personnel expenses for non-production employees.
Please refer to Activity 3.2.270.4.1 Personnel expenses predictive analytical where the audit procedure is explained.
You will need to document your testwork in EX_01 SAP Testwork, which is included in your participant materials. On EX_01 SAP Testwork, you can:
• develop your expectation of the personnel expenses for non-production employees,
• compare your expectation with the actual personnel expense non-production employees per the lead sheet, and
• check whether the difference (if applicable) is within the range of acceptable difference.
A copy of the testwork performed in the prior year is included in the Prior Period Viewer in the United Carbonations Build 1 and can be used as a reference as you perform the procedure.
Please note that I agreed the prior year balance per the lead sheet in eAudIT to the final trial balance for the prior year ending 12/31/X2, and no exceptions were noted.
United Carbonations’ Payroll Manager, Sheena Patel, has given me the non-production employee head count reports. The engagement team has performed testing over the headcount information in the headcount report and concluded the information in the report is complete and accurate. For the purposes of this procedure, you will not have to perform further work on the completeness and accuracy of the non-production employee headcount reports.
You will find the summary of the head count information that you will need for this procedure in your participant materials at PM_04 Headcount Testwork. I briefly spoke with the Payroll Manager who mentioned that non-production employees received a 9% increase on 01/10/X3.
I did not identify any other factors or relationships that may impact the performance of your predictive analytical procedure.
The acceptable difference has been set as CU100,000 above and below the actual balance.
Please let me know if you have any questions.
Thanks
Tony Ewan
In-Charge Auditor