The PlanetBids system enables you to generate various reports to collect data from awarded projects. The following is a list of reports you may want to use:
Home – Metrics (Click Edit in the upper right corner, use the dropdowns under Bids. Can be filtered by agency-wide, department, user):
-
- Awarded Amount: shows the amount awarded per classification based on the total amount awarded
- Awarded: shows the number of projects awarded to each classification based on the total number of bids.
- Cost Savings: Analysis of cost savings for projects in Awarded and Award Pending statuses. Awarded amount is compared with the Target Bid Amount/Engineer's estimate when provided. The report also provides the lowest, mean, median, and highest bid per project and compares these values with the award amount.
Bid Management Reports and Charts (from Bid Management, select the Reports icon in the upper right corner. Based on bids in search results):
-
- Bid Activity: A comprehensive report containing a list of projects with bid and buyer information, a breakdown of the template and project type used, the total number of notified vendors, prospective bidders, bidders, and awards, with a breakdown for each classification, and the total amount awarded.
- Bid Activity Summary: A report providing statistics on the total number and percentage of notified vendors, prospective bidders, bidders, awards, and award amount for each classification based on the total number of bids.
- Bid Awards: This report includes two charts that illustrate bid awards. Award Amounts show the amount awarded per classification based on the total amount awarded, while Number of Awards shows the number of projects awarded to each classification based on the total number of bids.
- Subcontractor Awards: Two charts illustrating awards made to subcontractors. Award Amounts charts the amount of subcontracts awarded per classification, based on the total amount awarded. The Number of Awards chart displays the number of projects awarded to subcontractors per classification, based on the total number of bids.
- Cost Savings: Analysis of cost savings for projects in Awarded and Award Pending stages. Award amount is compared with the Target Bid Amount/Engineer's Estimate when provided. The report also provides the lowest, mean, median, and highest bid per project and compares these values with the award amount.
- Awards Bids Search Export: An export of Awarded projects listing vendors that bid for the project, their bid amount, the date the projects were awarded and the amount.
Individual Bid Reports (from the Reports tab within the bid):
-
- Project Participation: This report provides a summary of the participation on the project and lists whether a vendor has been Notified/Invited, became a Prospective Bidder, downloaded files, bid for the project, award information and the classifications that apply to each vendor.
- Cost Savings: Chart illustrating the Submitted and Awarded bid amounts compared to the Target Bid Amount.
Vendor Management (from Vendor Management, select the Reports icon in the upper right corner. Based on vendors in search results):
-
- Vendor Activity: A comprehensive report of registered vendors with their activity and Classifications. Activity reported includes the number of solicitations each vendor has received; number of times they've become a prospective bidder, bidder, and an awardee (with amount awarded).
Individual Vendor Profile (from the Reports tab within the individual vendor profile):
-
- Vendor statistics showing projects bid on, projects awarded, rankings, etc. Also available in collaborative view.
Contract Management (from Contract Management, select the Reports icon in the upper right corner):
-
- Business Utilization: Business Utilization Detail of Prime and Subcontractors by contract.
Individual Contract Management Reports (from the Reports tab within an individual contract:
-
- Subcontractor Compliance Payment Report: shows payments to subcontractors and acknowledgments for each month.
- Detailed Subcontractor Compliance Payments: shows subcontractor's contact, payments, and acknowledgement details for a specific month.
- Subcontractor Compliance Monthly Update: shows projected and actual payments to a subcontractor for a specific month.
Reports (above reports plus the below, select the Reports icon from the left side menu):
-
- Bid Management - Line Item Reports: The report provides pricing analysis for bids using line items listed in the Line Items Library. The analysis includes the highest, lowest, average bidder amounts and awarded for the line items.
- Bid Management - Bid Awards: This report has two charts illustrating awards. Award Amounts shows the amount awarded per classification, based on the total amount awarded while Number of Awards shows the number of projects awarded to each classification, based on the total number of bids.
- Bid Management - Subcontractor Awards: Two charts illustrating awards made to subcontractors. Award Amounts charts the amount subcontracts were awarded per classification, based on the total amount awarded while Number of Awards charts the number of projects awarded to subcontractors per each classification, based on the total number of bids.