Using Schedule of Values in Contracting
Within Ediphi, specifically in the Contracting module, the Schedule of Values (SOV) provides a comprehensive summary of all Bid Packages in a project. This allows for a convenient review of the selected bidders and their pricing for your project.
In this article
Schedule of Values Overview
Within the Schedule of Values you have 3 main tabs (Estimate, Markups, and Area Summary), as well as some extra functionality like saving Versions, exporting the SOV, and managing your Use Groups.
Note: This is a global SOV for all Scope Sheets. Each Bid Package has a SOV section, but this is the same section for all Bid Packages.
Estimate tab
Upon opening the Schedule of Values you will see the Estimate tab. This is your summary of all bid packages and shown on the left along with the percent awarded for your bidders. Flowing to the right of the bid packages are multiple sections detailing each bid package, bidder pricing, and other important information captured from the Bid Leveling stage.
Markups tab
The Markups tab in the SOV is similar to the Markups tab in the Estimates module. The SOV Markups shows your Total Cost, W/ Projected Total, and grand totals at the bottom. For GCs & GRs to show here, first link your estimate to the GCGR, then set your Estimate as Active. See our GCs & GRs under Contracting article for more information.
Area Summary tab
The Area Summary tab in the SOV is a high-level breakdown of Area per Use Group. Gross Area, Unit Area, and Unit Counts will be shown here. Newly added Use Groups will appear in this tab as well as the Use Group section in the Estimate tab.
Versions Feature
Similar to Estimates and GCs & GRs, you have the ability to create versions in Contracting. This is a quick way to save work at a specific date/time and revert to an older version if needed. Additionally, you have the ability to save versions and include them in the Budget section within the SOV.
Report Builder
The Export function in the SOV works slightly different from the Export function in the other Contracting sections. When you choose to export the SOV in the Report Builder, the exported file will only show the expanded sections, not the collapsed sections.
Manage Use Groups
At the top right of the Contracting module, you have the ability to manage Use Groups that were pushed from the Estimates module. Within this function, you can add new Use Groups to Contracting (the added Use Groups will not push back into the Estimates module) and delete them if needed by a simple right-click. Added Use Groups will show in the Use Groups section in the Estimates tab as well as the Area Summary tab.
Using the Estimate tab in Schedule of Values
Bid Packages
This section of the Estimate tab lists all bid packages from your scope/buy sheets with their respective totals and Cost/GSF. Above this section is Percent Awarded, tracking the percentage of total bid packages with an awarded bidder. Lastly, listed at the bottom is Total Cost, Markups Total, and Grand Total (these totals stretch across to multiple expanded sections).
Budget
This section shows the Budget value versus the Delta. The delta column will by default show your Carried Bidder's grand total until a budget is in place. If you include Versions from the "Load Versions" window, they will show here.
Subcontractor Pricing
This section allows for game time decisions regarding your bidders and pricing, showing the first 3 bidders from the Scope Sheet. Subcontractor Pricing offers the ability to carry bidders without having to go back to the Scope/Buy Sheets to do so. For visuals regarding this new section, please see our Updated Schedule of Values article.
Purchasing
This section shows the Project Buy, Total W/ Project Buy, Buy Value, and Actual Buy from your Scope/Buy Sheets. The Buy Value column shows the delta from the original bid amount to the total bid amount including plugs. Red = you owe that amount. Green = you are saving that amount.
Holds & Allowances
This section will pull from Scope of Work line items and Trade Cleanups in your Scope Sheets. There you can toggle between Hold or Allowance. If a line item also has a plug assigned on a bidder, then it will show up on the Buy Sheet, as well as, the Holds & Allowances section in the SOV.
Use Groups
This section breaks down Use Groups from the Scope/Buy Sheets by allocated amounts and $/SF. If you have any amount that is unallocated, it will show in this section.
Alternates
This section shows Project Alternates from the Scope/Buy Sheets. Trade Alternates will not appear here as they will remain in their respective Scope Sheet/Bid Package.
Diversity Certifications
Similar to Scope Sheets, this section is used to show your Diversity Certifications used for your project/company. If your team allocated these certifications on Scope Sheets, they will show in the SOV.
Status
This section shows the Trade Estimator working on the bid package, Date Modified, Last Modified By, and Date Created.
Pro Tip: You have the ability to reorder and remove sections/columns in the SOV. Keep in mind, you will not be able to move the Subcontractor Pricing or Use Groups sections, but you can move another section before or after them in the order you need.
If you have any questions, feel free to contact our support team and we'll be happy to help!