Ideally to support a 2nd stage tender we would need a very flexible analysis as discussed the following common issues make the current comparison limited;
Subcontractor remeasures: mostly we would ask our subcontractors to take the risk on quantities so they often make adjustments on the BoQ quantities
We ask subcontractors to price detailed scopes which may not be captured in the BoQ. Therefore items are often added below the line, which then needs to be compared between packages
Comments column: We need to present the final price to our peers and also the clients team. A column for notes next to every item is a necessity so we can report properly on a particular inclusion/exclusion etc.
Multiple columns for the same subcontractor to show the movement from āas opened tenderā to the final worked price. [Audit trail on tender package versions]
Consider Post contract use of the functionality as well...We also run within this tender analysis all the post tender queries (see TQ tabs) and s/c clarifications reviews (Clarifications tab). These are then marked in a colour system to indicate if a particular item may have a cost associated with it and will then be marked to say it has been captured. I donāt know if this is something that can included in your assessment.
We then report the process up the line on a CSA. Presumably this could be set up on Causeway for each package (from the TAās) to filter back into the relevant line item to build our final cost.