BOQ Builder·Auto-BOQ from dimensions, DSR ratesNEWBidEasy·Government tenders, searchableLIVEInfraLens App·Free on Play Store, offline-readyNEW
PMC📦 Procurement & StoresItem Rate Analysis Sheet

Item Rate Analysis Sheet

form
PMC-PRC-FRM-011·v1.0-beta·⚠ Beta — review before use

Detailed analysis of unit rate for a BOQ item — material + labour + machinery + overhead + profit breakdown. Used for new items (not in DSR) or VOs requiring rate justification.

ReferencesCPWD Schedule of Rates (DSR)MoRTH Standard Data BookState PWD DSR / SORProject Specific BOQ
Download
📍 When to use this template
  • Tender stage — rate justification + bidder analysis.
  • Variation Order rate finalisation.
  • New item rate negotiation (for items not in DSR).
  • Disputes + arbitration on rate fairness.
  • Internal cost analysis + budget tracking.
Sections & fields
Preview of the template structure. Download Excel to fill on site.
1Item Identification5 fields
BOQ Item Number
_____________
Item Description
_____________
Unit (cum / sqm / kg / nos)
_____________
Reference DSR Item (if applicable)
_____________
Source of Rate (Estimated / DSR / VO / Negotiated)
_____________
2Material Cost7 fields
Material Name
_____________
Specification
_____________
Quantity per Unit of Work
_____________
Wastage % (per IS / Practice)
_____________
Total Quantity (incl wastage)
_____________
Unit Rate
_____________
Material Cost
_____________
3Labour Cost4 fields
Skill (Mason / Carpenter / Helper)
_____________
Productivity (Units per Day)
_____________
Daily Wage
_____________
Labour Cost per Unit Output
_____________
4Equipment Cost5 fields
Equipment Used (Mixer / Vibrator / Crane / Hoist)
_____________
Hire Rate / Day or Hour
_____________
Hours per Unit of Output
_____________
Equipment Cost per Unit
_____________
Operator Cost (if separate)
_____________
5Overhead + Profit5 fields
Tools + Plant (if not equipment-listed)
_____________
Sundries (5-10 % typical)
_____________
Contractor Overhead (10-15 % typical)
_____________
Profit Margin (10-20 % depending on risk)
_____________
Total Cost + Overhead + Profit
_____________
6Final Rate6 fields
Sum of All Components
_____________
Tax (GST)
_____________
Total Quoted Rate
_____________
Reference DSR Rate (for Comparison)
_____________
Variance vs DSR
_____________
Justification
_____________
💡 Sample filled excerpt
Item: Plain Cement Concrete (PCC) 1:4:8 in foundation. Material: Cement 0.16 MT × ₹4500 = ₹720, Sand 0.42 cum × ₹1500 = ₹630, Aggregate 0.84 cum × ₹1200 = ₹1008. Labour: 0.5 mason-day × ₹650 + 1 helper × ₹450 = ₹775. Mixer: 0.1 hr × ₹150 = ₹15. Sundries 5 % = ₹126. Overhead 12 %, Profit 15 % = ₹712. Final ₹4053/cum + 18 % GST = ₹4783/cum.
⚖ Compliance notes
  • CPWD DSR is the reference rate for government projects — variations require formal justification.
  • MoRTH Standard Data Book is reference for highway projects.
  • State PWDs publish state-specific DSR/SOR with regional rate variations.
  • Wastage assumptions should align with IS norms or project quality plan.
  • Profit margin varies by project risk + sector (BOT/HAM allow lower margins due to revenue stream).

Engineer's Notes — Item Rate Analysis Sheet

Why the Item Rate Analysis matters

Rate Analysis is the systematic build-up of a unit rate from its constituent components: material + labour + machinery + sundries + overhead + profit. It is the bedrock of construction estimating, claim defence, and variation pricing.

Use cases: - New BOQ items: items not in DSR / SoR; original analysis required - Variation Orders (VOs): items added / modified during execution - Star Rate items: items not in SoR but quoted in BOQ; analysis backs the rate - Tender preparation: contractor's own rate analysis for own quoting - Rate dispute resolution: arbitration / DRB analysis - Audit defence: CAG / CVC questioning of rates - Internal cost control: monitoring actual vs estimated - Market benchmarking: comparing rates across regions / vendors - Cost-plus contracts: rate finalisation with employer

Indian reference rates: - CPWD DSR (Delhi Schedule of Rates) — federal benchmark - MoRTH Standard Data Book — highway projects - State PWDs: Maharashtra DSR, Rajasthan BSR, UP SoR, Karnataka SR, Tamil Nadu SR, Gujarat SoR (state-specific) - NHAI Rate Schedules — for NHAI projects - CMA India / NICMAR Studies — productivity benchmarks

The Item Rate Analysis Sheet provides the structured, transparent breakdown that becomes the defensive basis for every rate-related discussion. Without it, contractor's quoted rate appears arbitrary; employer's challenge succeeds; rate gets reduced; loss-of-margin.

How to build a Rate Analysis

Standard 5-section rate analysis structure:

A. Item identification: - BOQ item number (e.g., 5.3.1) - Full item description (per CPWD or project SoR) - Unit (cum / sqm / m / kg / nos / LS / sets) - Reference SoR / DSR item (if applicable) - Source: Estimated / DSR-based / Negotiated / VO

B. Material cost (build per unit of work):

For each material: - Material name + specification (cement: OPC 53 / PPC; steel: Fe 500; aggregate: 20 mm) - Quantity per unit of work (from standard formula or CPWD DSR analysis): - E.g., M25 concrete = 0.420 cum/cum × 1 (cement) + 0.42 m³ sand + 0.84 m³ aggregate per cum - 1 sqm 12 mm cement plaster 1:6 = 12 kg cement + 0.072 m³ sand - 1 m³ brickwork (modular brick) = 500 bricks + mortar volume × ratios - Wastage %: - Cement: 2-3% (storage + spillage) - Steel: 3-5% - Aggregate: 5-7% - Bricks: 5-10% - Tiles: 8-15% - Paint: 10-15% - Total quantity (incl. wastage) - Unit rate (market or DSR) - Material cost per unit of work

C. Labour cost:

For each skill category: - Productivity / output norm (per CPWD Analysis or project history): - Mason: 1.5-3 m³ brickwork/day - Plasterer: 6-12 m²/day (12mm) - Steel fixer: 250-400 kg/day - Carpenter (shuttering): 6-12 m²/day - Helper: 1.5-2× mason ratio typically - Days per unit of work = 1 ÷ productivity per day - Daily wage per state Minimum Wages notification - Labour cost per unit = days × wage - Aggregate across all skills

D. Equipment cost:

For each equipment item: - Equipment used (mixer / vibrator / pump / crane / hoist) - Hire rate: monthly / daily / hourly - Hours per unit of output: - Concrete mixer: 0.3-0.5 hr/m³ - Concrete pump: 0.2-0.3 hr/m³ - Vibrator: 0.1-0.2 hr/m³ - Crane lift: 0.05-0.1 hr/lift - Equipment cost = hours × rate ÷ output - Operator cost (if separate from hire) - Fuel cost (if applicable)

E. Overhead + Profit:

- Tools + plant (5% typically; for items where equipment not separately listed) - Sundries / Miscellaneous (3-7% — covers ancillaries) - Contractor Overhead (10-15%): - Site overheads (PM / engineers / site office) - Corporate overhead (HO share) - Insurance + bonds (proportionate) - Profit margin (10-20% depending on): - Project risk (BOT < EPC < Item-Rate) - Sector (govt < private; specialty > standard) - Competition - Strategic value - Subtotal before tax - GST (typically 18%) - Final rate: subtotal + GST

F. DSR comparison + justification: - Reference DSR rate - Variance % (computed rate vs DSR) - If above DSR > 10%: justification required - If below DSR > 20%: "abnormally low" check - Justification: market price increase, scope addition, special requirement, etc.

Common rate analysis errors

1. Quantity ratios wrong — using textbook M25 formula instead of project mix design; cement / aggregate proportions off; rate over- or under-stated.

2. Wastage assumed too low — 2% wastage on bricks; actual 10%; under-priced.

3. Wastage assumed too high — 15% on cement; actual 3%; over-priced; bidder loses.

4. Labour productivity unrealistic — using OEM productivity in field conditions; actual is 60-70%; rate insufficient.

5. Equipment hire rate wrong — using current market vs old SoR rate; significant differences.

6. Equipment hours over-allocated — assuming continuous use; actual is intermittent; rate inflated.

7. No equipment cost in low-tech items — manual work assumed; minor tools cost not included.

8. Overhead double-counted — OH in component rates AND OH at total level; over-pricing.

9. Profit margin too low — competitive pressure; below break-even.

10. GST treatment wrong — material has GST in component price + GST at item level; double tax.

11. Local taxes missed — octroi (now subsumed but still present in some forms), local body cess, mandi fees.

12. Royalty + cess missing — sand / aggregate royalty not in material rate; later mining dept claim.

13. No fuel + lubricant cost — for diesel-operated equipment; should be in equipment cost.

14. Mobilisation cost not amortised — one-time mobilisation lumped in first few items; later items under-priced.

15. No allowance for site difficulty — congested site / multi-level / coastal; standard rate used; later EOT / cost claims.

16. Currency for imports not hedged — imported component rates; FX risk not accounted; loss on volatile periods.

17. Outdated DSR used — current DSR available but bid done on old; differences accumulate.

18. No analysis for non-SoR items — "star rate" used without analysis; later audit challenge.

19. Component price source inconsistent — some materials from DSR, some from market; mixed reference.

20. Indirect cost not allocated — common facilities (security / canteen / safety) not in any item's OH; loss.

Cross-references

Companion formats: - Rate Analysis Brickwork (FMT-EST-003) - Rate Analysis Plaster Internal (FMT-EST-004) - Rate Analysis Plaster External (FMT-EST-005) - Rate Analysis Shuttering (FMT-EST-006) - Overhead + Profit Computation (FMT-EST-009) - Labour Productivity Sheet (FMT-EST-007) - Plant Productivity Sheet (FMT-EST-008) - Escalation Calculation (PMC-BIL-FRM-006) - BOQ Format PWD (FMT-TND-006)

Standards + references: - CPWD Specifications 2019 — Volume 1 + 2 (basis for rate analysis specifications) - CPWD DSR (Delhi Schedule of Rates) — current rate reference - CPWD Analysis of Rates — companion document - MoRTH Standard Data Book for Roads + Bridges — highway projects - MoRTH Standard Specifications — workmanship standards - State SoR / DSR documents — Maharashtra / Karnataka / Tamil Nadu / Gujarat / etc. - NHAI Schedule of Rates — NHAI-specific - CMA India Productivity Norms - CIDC (Construction Industry Development Council) Publications - NICMAR Cost Standards - IS Codes — for material specifications + standard ratios - NHBF + CREDAI — industry rate benchmarking