| Description | Value |
|---|
| Prepared By | IMAN Auditor |
| Date | 02-26-2009 |
| Reviewed By | G. Audit Supervisor |
| Review Date | 02-02-2009 |
| Audit Step | 11 |
| Audit Objective | Quantify posted invoices by terms days offered |
| Data Source | c:\test\data\EWP.xls |
| Date Run | 04-19-09 17:12:52 |
| Table/WorkSheet | Trans$ |
| Column | invoice amount |
| Command | summary - Summarize amounts |
| Parameters Used | [terms days] |
| First Parameter | (none) |
| Where | (none) |
| Second Parameter | (none) |
| SQL used | select sum([invoice amount]) as [Total], avg([invoice amount]) as [Average], min([invoice amount]) as [Minimum], max([invoice amount]) as [Maximum], count([invoice amount]) as [Count], stdev([invoice amount]) as [Standard Deviation], [terms days] from [Trans$] group by [terms days] ; |
| Processing status | Normal process - 2 rows |
| Finding (Condition, Cause, Effect) | |
| Conclusions | |
| Recommendations | |
| Discussed with | |
| Management agrees? | |
| Management comments | |
| Auditor comments | |
|
| terms days | Total | Average | Minimum | Maximum | Count | Standard Deviation |
| 10 | 7,624,937.93 | 7,579.46 | -11,000.00 | 10,497.28 | 1,006 | 5,793.66 |
| 30 | 14,126,511.04 | 3,508.82 | -9,000.00 | 8,494.81 | 4,026 | 3,683.89 |
|
