Logo Help

 

Home

Networking

External Data

comparing the tenders received and award contracts for work Play Video

Review each subcontractors tender and decide who will be awarded the contract, partially or completely.

Each completed bill document is imported separately. This is the completed copy of the tender document previously submitted to the subcontractor in Excel format. The original item ID is maintained so you are always comparing the same item.

Select the bill level in the tree in order to review all subcontractors. Each of the rates the subcontractor has completed will be shown in their own column so you can compare with others and your own rate (if any).

Select the subcontractor level in the tree to review the rates for each individual subcontractor.

Comparison Chart

You can display an at-a-glance graphic view of the key values submitted for this Trade by subcontractors (Make sure you select the Trade level on the tree).
The chart always refers to the entire bill and not individual items so the function can be selected at any point
The chart will show up to 4 bars. The first is the Lowest Cost submission (green), the next is the average submission value (one incl. self, the other excl. self, shown in yellow) and the highest cost submission (red).

Selecting Trade Rates

As you may have multiple trades assigned to each bill, use the Trade pull-down list to choose which trade to display (greyed out if only one)

You can also compare each column using different Views as required:

Rates - Shows the item rate submitted by each subcontractor together with your own rate. You can manually adjust these if needed

Totals - Shows the extended item value (Qty x Rate) submitted for each item together with the bill total at foot of table

Extended - Shows both the item rate and the extended amount for each rated item

Decide which subcontractor is to be awarded the work for each Trade allocated. This can be applied on a bill or individual item basis.

Plugging Rates

You can easily 'plug' any missing rates using a range of criteria.
Select the subcontractor on the tree to load their rates for this bill. Highlight the item you want to plug then choose which rate to plug it with.

Adjustments & Attendance Allowance

You can make adjustments to the overall subcontractor prices using the Adjustments function.
You can add multiple adjustments if needed.
All adjustments entered here are applied equlally over all the priced items.

Notes:

  1. Trades linked to items can be changed at any time
  2. You can generate as many enquiry documents as you wish
  3. Original item ID's are maintained to reduce possible matching errors
  4. Values may be entered as Rates (unit based) or Item Totals (Qty x Net Rate). If the Item Total is entered then the rate will be calculated by dividing extended rate by the Qty (If the quantity is 0 it will be changed to 1). The resulting rate will be multiplied by the quantity and the extended rate updated.