Tender Analysis in UniPhi

This article will take you through the setup required for generating tender analysis reports in UniPhi.

1. Create tender codes in the chart of accounts

   If you don't already have these set up, an Administrator can edit the chart of accounts by going to Configuration > Chart of Accounts > click on the appropriate chart of accounts.

   
   

   From this page, you can then enter level 2 codes or click on the code that you want the new ones to nest underneath and enter the details.

   

2. Create metrics for tender codes

   An Administrator can create metrics by going to Configuration > Metrics > Calculated Columns.
   

   Make sure you have the correct Chart of Accounts selected on the top right corner.

   

   Press the yellow + icon to create a new one. Enter the column name, then you can use the fields provided to create the formula.

   

   
   

   In the example below, we have created a column that will calculate the dollars per fully enclosed covered area. The formula will take the total value of a code in the project budget and divide the value by the number entered in the "FECA" project custom field.

   

   
   

3. Receive tender responses, import into budget screen and snapshot for each tenderer

   This is done from Costs > Budget.

   
   

   Use the steps in this article to update the budget with the tender responses.
   

   Once the budget has been updated with the first tender response, create a snapshot.

   

   Repeat this process for each tender response.
   

4. Run tender analysis reports in benchmark reports

   Once all the configuration is done, users can go to Reporting > Reports > Benchmark.

   This is where you will find the Tender Analysis - Rates report and the Tender Analysis - Total Rates and Percentage report.

   These reports will show all budget snapshots, except for month-end ones, allowing you to compare the snapshots created for the different tenders to determine the most cost-effective option.