| Audit Information | | | | | | | | | | | |
| Audit Title | Inventory Cycle | | | | | | | | | | |
| Audit Number | 1097 | | | | | | | | | | |
| Audit Period | Fiscal Year Ending 11-30-2008 | | | | | | | | | | |
| Data Source | Audit Step | Audit Objective | Cmd | Table | Where | Column | ColString | Parameter 1 | Parameter 2 | Scheme | Chart Title |
| c:\test\data\EWP.xls | 1 | Using a histogram, plot quantities of high value inventory items (i.e. unit cost > $20) | histo | Inventory Data$ | [unit cost] > 20 | units | | | | Fall | High Value inventory items |
| c:\test\data\EWP.xls | 2 | Determine population statistics for high value inventory items (i.e. unit cost > $20) | stat | Inventory Data$ | [unit cost] > 20 | units | | | | Spring | High Value inventory items |
| c:\test\data\EWP.xls | 3 | Using a boxplot, plot quantities of high value inventory items (i.e. unit cost > $20) | boxplot | Inventory Data$ | [unit cost] > 20 | units | | | | Green | High Value inventory items |
| c:\test\data\EWP.xls | 4 | Summarize inventory values by warehouse location | summary | Inventory Data$ | | extended cost | warehouse | | 1 | | |
| c:\test\data\EWP.xls | 5 | Summarize inventory values by employee id | summary | Inventory Data$ | | extended cost | employee | | 1 | | |
| c:\test\data\EWP.xls | 6 | Prepare a schedule of the 10 largest value inventory items | topn | Inventory Data$ | | extended cost | | 10 | | | |
| c:\test\data\EWP.xls | 7 | Prepare a schedule of the 20 least value inventory items | bottomn | Inventory Data$ | | extended cost | | 20 | | | |
| c:\test\data\EWP.xls | 8 | Stratify inventory unit costs | stratify | Inventory Data$ | | units | | 0 100 200 300 400 500 600 700 800 900 1000 | | | |
| c:\test\data\EWP.xls | 9 | Stratify inventory extended costs | stratify | Inventory Data$ | | extended cost | | 0 500 1000 2000 3000 5000 10000 20000 30000 40000 | | | |
| c:\test\data\EWP.xls | 10 | Age inventory by date of receipt | age | Inventory Data$ | | | [inventory date],[extended cost] | 3/31/2007 | mdy | Yellow | Inventory by receipt date |
| c:\test\data\EWP.xls | 11 | Prepare a schedule of inventory items with negative units | extractwhere | Inventory Data$ | units < 0 | | | | | | |
| c:\test\data\EWP.xls | 12 | Prepare a schedule of inventory items with negative unit cost | extractwhere | Inventory Data$ | [unit cost] < 0 | | | | | | |
| c:\test\data\EWP.xls | 13 | Prepare a schedule of the 20 least value inventory items for warehouse AB | bottomn | Inventory Data$ | [warehouse] = 'AB' | extended cost | | 20 | | | |
| c:\test\data\EWP.xls | 14 | Prepare a schedule of stock numbers which contain the digits 562 in any position within the stock number | extractwhere | Inventory Data$ | [stock number] like '%562%' | | | | | | |
| c:\test\data\EWP.xls | 15 | Test clerical accuracy of extensions | extractwhere | Inventory Data$ | abs(([unit cost] * [units]) - [extended cost]) > .02 | | | | | | |
| Data Source | Audit Step | Audit Objective | Cmd | Table | Where | Column | ColString | Parameter 1 | Parameter 2 | Scheme | Chart Title |
| c:\test\data\EWP.xls | 16 | Test inventory quantities using benford's law | benford | Inventory Data$ | [unit cost] > 0 | unit cost | | F1 | | spring | Inventory Counts and benford's law |
| c:\test\data\EWP.xls | 17 | Analyze dates inventories taken by day of week | wdReport | Inventory Data$ | | inventory date | | mdy | US | Orange | Inventories taken by day of week |
| c:\test\data\EWP.xls | 18 | Prepare a schedule of inventories performed on a Sunday | wd | Inventory Data$ | | inventory date | | 1000000 | mdy | | |
| c:\test\data\EWP.xls | 19 | Test for round numbers in inventory counts | rn | Inventory Data$ | | units | | 0111111 | | Blue | Round number for inventories taken |
| c:\test\data\EWP.xls | 20 | Prepare a summary of round numbers in inventory counts | rnreport | Inventory Data$ | | units | | | | Purple | Round number for inventories taken |
| c:\test\data\EWP.xls | 21 | Prepare a schedule of duplicate inventory items (same warehouse, same stock number, same date) | duplicates | Inventory Data$ | | | [warehouse],[stock number],[inventory date] | | 3 | | |
| c:\test\data\EWP.xls | 22 | Analyze dates inventories taken on holidays | holidayReport | Inventory Data$ | | inventory date | | mdy | US | spring | Inventories taken on holidays |
| c:\test\data\EWP.xls | 23 | Prepare a schedule of inventories performed on a Sunday | holiday | Inventory Data$ | | inventory date | | mdy | US | | |
| c:\test\data\EWP.xls | 24 | Check for gaps in inventory tag numbers | gap | Inventory Data$ | | inventory date | [inventory tag] | | | | |
