Cost Code Analysis
Ref: AG3_203
Description
This report returns a cost analysis of work order costs broken down by cost code. The report has both detailed and summary sections.
The first section is a summary table showing totals for each cost centre. The second section shows the supporting data by using individual work order detail with costing on each grouped by the cost code.
The report returns;
Cost Code
Description (Cost Code description)
Work order number
Description (Work Order Description)
Start Date
Transaction Date
Labour Cost
Material Cost
Other Costs
Operational Criteria
Records are return based upon work orders and/or equipment items meeting the selected filter criteria.
Work Order selection
• Cost Code Range
o Cost codes to be analysed, leave ‘Null’ for all.
• Job Type
• Craft
• Job status
• Work order start date range
o This will only include any work orders in the cost and time calculations that have been raised against the equipment item where the work orders start date is within the specified date range.
• Work order completion date range
o This will only include any work orders in the cost and time calculations that have been raised against the equipment item where the work orders completion date is within the specified date range.
Equipment Selection
• Equipment Filter
The report will use the cost code associated with an inventory movement on the work order first, if no movement record exists then it will use the work order cost code for grouping and calculations.
The report supports 2 work order date range this allows for analysis to be made on open or completed work orders within a specific period.
Aims
The report is designed to provide the end user with a cost analysis for all of the cost centres defined within the system with facility to break this down to specific equipment, locations or periods.
For example;
This report could be used to determine the total cost for a specific type of job, i.e. breakdowns, for the different cost centres for work orders completed in a defined period, i.e. the second quarter.
Results Analysis
The report can be used to identify the highest cost centres; from their individual work order costs can be examined. The ultimate aim of this report is to assist in reducing costs in high cost areas by looking at the contributing factors.