Pricing Management
The Pricing Database is the company-wide catalog of rates for labor, equipment rentals, materials, and subcontractor services. Unlike bid-specific defaults, pricing items are looked up when creating estimation items, not copied.
This guide is for ADMIN and ESTIMATOR users. Pricing management requires appropriate role permissions.
Pricing Database Overview
The pricing database contains:
- 111+ items imported from company rate sheets
- 4 categories: Labor, Rental (Equipment), Materials, Subcontractor
- Real-time pricing: Changes immediately affect new estimation items
- Tax configuration: Different tax rates per item type
Accessing Pricing Database
Go to Admin Panel → Pricing Database (6th tab)
Use the category filter to view:
- Labor (8 items)
- Rental (95+ equipment items)
- Materials (15+ items)
- Subcontractor (6 items)
Use the search bar to find specific items by description, category, or subcategory.
Pricing Categories
Labor Rates
8 standardized labor roles with hourly rates:
| Role | Base Rate | Tax Rate | Total Rate |
|---|---|---|---|
| Executive PM | $65.00/hr | 5% | $68.25/hr |
| Safety Manager | $42.00/hr | 5% | $44.10/hr |
| Labor Foreman | $38.00/hr | 5% | $39.90/hr |
| Equipment Operator | $27.00/hr | 5% | $28.35/hr |
| Skilled Labor | $25.00/hr | 5% | $26.25/hr |
| Concrete Finisher | $24.00/hr | 5% | $25.20/hr |
| Unskilled Labor | $22.00/hr | 5% | $23.10/hr |
| Testing Labor | $20.00/hr | 5% | $21.00/hr |
These rates are base labor rates. Burdened rates (with FICA/FUTA/SUTA) are calculated automatically in the Labor module.
Equipment Rentals
95+ equipment items with daily, weekly, and monthly rates:
Examples:
| Equipment | Unit | Base Rate | Tax | Total Rate |
|---|---|---|---|---|
| Dozer 650P | Daily | $829.60 | 12.25% | $931.23 |
| Excavator Medium | Daily | $502.50 | 12.25% | $564.06 |
| Wheel Loader 3.5yd | Daily | $650.00 | 12.25% | $729.63 |
| Water Truck 4000gal | Daily | $445.00 | 12.25% | $499.51 |
Equipment pricing includes Daily, Weekly, and Monthly rate variants. Select the appropriate unit when adding equipment to scopes.
Materials
15+ common construction materials:
| Material | Unit | Base Price | Tax | Total Price |
|---|---|---|---|---|
| 3000 PSI Concrete | CY | $125.00 | 8.25% | $135.31 |
| 4000 PSI Concrete | CY | $135.00 | 8.25% | $146.14 |
| 5000 PSI Concrete | CY | $145.00 | 8.25% | $156.96 |
| #4 Rebar | LB | $0.85 | 8.25% | $0.92 |
| 6x6 Wire Mesh | SF | $0.45 | 8.25% | $0.49 |
Subcontractor Services
6 standard subcontractor services:
| Service | Description |
|---|---|
| Concrete Pumping | Pump catalog with reach/rate configurations |
| Excavation & Grading | Earthwork and site prep |
| Asphalt Paving | Paving services |
| Storm Drain Installation | Drainage systems |
| Testing Services | Material testing and inspection |
| Concrete Finishers | Finishing labor |
Managing Pricing Items
Editing Prices
Use the search bar or browse by category to locate the item.
Click the edit icon (✏️) next to the item.
Edit any of the following:
| Field | Description |
|---|---|
| Description | Item name |
| Subcategory | Optional grouping |
| Unit | Unit of measure (HR, DAY, WEEK, MONTH, CY, SF, LB) |
| Base Price | Price before tax |
| Tax Rate | Tax percentage (decimal: 0.0825 = 8.25%) |
| Delivery Fee | One-time delivery charge (equipment) |
| Waste % | Material waste factor |
| Status | Active/Inactive |
Click save icon (💾) to update the item.
Total Price is auto-calculated as Base Price × (1 + Tax Rate) + Delivery Fee.
Adding New Items
Click the "Add Item" button at the top of the pricing table.
Choose category: Rental, Materials, Labor, or Subcontractor
The form adjusts based on category selection.
For Equipment (Rental):
Description: Dozer 750 - Daily
Subcategory: (optional)
Unit: DAY
Base Price: $645.00
Tax Rate: 12.25%
Delivery Fee: $100.00
For Materials:
Description: Rebar #6
Subcategory: Rebar
Unit: LB
Base Price: $0.95
Tax Rate: 8.25%
Waste %: 5.0%
For Labor:
Description: Site Superintendent
Subcategory: Management
Unit: HR
Base Price: $55.00
Tax Rate: 5.00%
Click "Save". Item is added to the pricing database and immediately available for use in bids.
Deleting Items
Deleting pricing items affects future estimation items only. Existing bid items preserve their original pricing.
Check the checkbox next to items you want to delete.
Use the header checkbox to select all visible items.
Click "Delete Selected" in the bulk actions bar.
Review the list of items being deleted.
Type confirmation if required.
Click "Delete X Items".
Bulk Operations
Select multiple pricing items to perform bulk actions:
| Action | Description |
|---|---|
| Bulk Edit | Update subcategory, unit, tax rate, waste %, or delivery fee for multiple items |
| Bulk Delete | Remove multiple items at once |
| Export CSV | Download selected items as CSV file |
Bulk Edit Workflow
Check items you want to edit.
Click "Edit Selected" in the bulk actions bar.
Change only the fields you want to update.
Fields show "Leave unchanged" by default. Modified fields apply to all selected items.
Click "Save Changes" to update all selected items.
Tax Configuration
Different item types have different default tax rates:
| Item Type | Default Tax Rate | Applies To |
|---|---|---|
| Labor | 5% | Labor burden (FICA, FUTA, SUTA) |
| Equipment | 12.25% | Rental equipment sales tax |
| Materials | 8.25% | Construction materials sales tax |
| Subcontractor | Varies | Per vendor/service |
Tax rates can be customized per item. Override the default when creating or editing items.
Price Lookup Flow
When estimators create items in bids:
Key Points:
- Pricing items are looked up, not copied
- Changes to pricing database affect new items only
- Existing bid items preserve their original pricing
- Historical bids remain accurate even if prices change
Bid-Specific vs Global Pricing
- Pricing Database (Global)
- Bid Variables (Per-Bid)
Purpose: Company-wide rate catalog
When to use:
- Equipment rental rates
- Material unit costs
- Labor hourly rates
- Subcontractor services
Characteristics:
- Looked up when creating items
- Changes affect future items
- Single source of truth
Purpose: Bid-specific settings
When to use:
- Overhead percentage
- Profit percentage
- Tax exemption status
- Per diem settings
Characteristics:
- Copied to each new bid
- Can be overridden per bid
- Preserves historical accuracy
Audit Logging
All pricing database changes are logged:
| Action | Logged Data |
|---|---|
| Item Created | Description, category, base price, tax rate |
| Item Updated | Changed fields (delta logging) |
| Item Deleted | Full snapshot for potential restoration |
| Bulk Update | Item count, updated fields, user |
| Bulk Delete | Item count, deleted items list, user |
View audit logs at Admin Panel → Audit Log tab.
API Endpoints
| Method | Endpoint | Description | Auth |
|---|---|---|---|
| GET | /api/pricing | Get all pricing items | ADMIN, ESTIMATOR, PM |
| GET | /api/pricing?category=Labor | Filter by category | ADMIN, ESTIMATOR, PM |
| GET | /api/pricing/search?query=dozer | Search pricing | ADMIN, ESTIMATOR, PM |
| GET | /api/pricing/categories | Get all categories | ADMIN, ESTIMATOR, PM |
| POST | /api/pricing | Create pricing item | ADMIN, ESTIMATOR |
| PUT | /api/pricing/:id | Update pricing | ADMIN, ESTIMATOR |
| DELETE | /api/pricing/:id | Delete pricing | ADMIN |
| PUT | /api/pricing/bulk | Bulk update | ADMIN, ESTIMATOR |
| DELETE | /api/pricing/bulk | Bulk delete | ADMIN |
Best Practices
Update Regularly
Review and update pricing database regularly to keep rates current with market conditions.
Use Consistent Naming
Follow naming conventions for equipment variants (e.g., "Dozer 750 - Daily", "Dozer 750 - Weekly").
Set Accurate Tax Rates
Verify tax rates are correct for your jurisdiction. Incorrect tax rates affect all new items.
Review Before Deleting
Deleting pricing items cannot be undone. Verify items aren't needed before deleting.
Troubleshooting
Item not appearing in dropdown
Check:
- Item status is Active
- Category matches (e.g., Rental items only in Equipment module)
- Search filter isn't excluding the item
Total price showing as NaN
This happens when:
- Base price is empty
- Tax rate is invalid
Solution: Edit the item and ensure base price and tax rate are valid numbers.
Changes not reflected in existing bids
This is expected behavior. Pricing changes only affect new items. Existing bid items preserve their original pricing.
Service Definitions
Service Definitions are admin-managed templates that control what fields appear when estimators add subcontractor items to a scope, and how those items are costed.
Go to Admin Panel → Module Configuration → Subcontractor Services (sidebar).
The table shows all service definitions with columns:
- Service Key — unique identifier used in subcontractor items (e.g.,
Joint Saw - Green) - Display Name — label shown to estimators
- Compute Code — the cost function assigned (e.g.,
joint_saw_green) - Fields — number of field definitions attached
- Active — whether the service is available to estimators
Click Add or the row overflow menu (⋮) → Edit to open the definition sheet.
Required fields:
- Name (unique service key)
- Display Label
- Compute Key (must match a key from the Compute Registry)
Optional fields: Sort Order, Active status
Expand a service row to manage its field definitions. Each field has:
- Key — input name used by the compute function
- Label — displayed to estimators
- Role —
input(estimator fills in) orrate(sourced from pricing database or variables) - Field Type —
number,select,checkbox, ortext - Options — for
selectfields, the list of valid choices
Deleting a service definition is a soft delete — existing subcontractor items referencing the service by name are not affected. The definition is hidden from new item creation but historical items are preserved.
Available Compute Keys
| Key | Service Type |
|---|---|
simple | Generic quantity × rate |
joint_saw_green | Green joint sawing with depth tiers and $550 minimum |
joint_saw_demo | Demo/removal sawing with depth tiers and $550 minimum |
place_and_finish | Place and finish with complexity multiplier |
pumping | Concrete pumping with volume + hourly + fuel surcharge |
rodbusting | Rebar installation (per-LB or per-SQFT) |
pier_drilling | Drilled piers (per-pier, per-day, or lump sum) |
lump_sum | Any flat lump sum |
hydro_excavation | Hydrovac excavation (per-LF or lump sum) |
extruded_curb | Extruded curb (per-LF or per-day) |
monolithic_curb | Monolithic curb (per-LF or per-day) |
See Service Definitions API for full endpoint reference and field schemas.