Rate Analysis Excel Sheet Download | AOR, SOR, DSR Templates – Afroz Civil


Download the complete Rate Analysis Excel Sheet (AOR + SOR+DAR) for civil engineering estimation, costing and billing work. This sheet includes material, labour, machinery and output constants based on CPWD/PWD guidelines.

Rate Analysis Excel Sheet Download – Afroz Civil

About Rate Analysis 

Rate Analysis, Civil Engineering, AOR, SOR, DAR, Labour Output Constants, Construction Estimation, Costing, Billing, Material Cost, Machinery Cost, Afroz Civil

Rate Analysis in civil engineering is a complete scientific method used to calculate the actual unit cost of construction activities. A proper rate analysis includes the breakdown of material, labour, machinery, overheads, contractor profit, taxes, and productivity norms. Accurate rate analysis ensures transparent billing, precise estimation, cost control, and efficient project management.

It forms the foundation of the Analysis of Rates (AOR) and aligns with the Schedule of Rates (SOR/DAR) published by CPWD, PWD and State Engineering Departments. These codes help engineers maintain standard, uniform and technically correct cost calculations across all construction activities.

Abbreviations Used in Rate Analysis:

In this article, several important engineering abbreviations have been used, and each plays a key role in preparing accurate construction costing. AOR (Analysis of Rates) defines the method for calculating the detailed cost of every activity, while SOR (Schedule of Rates) and DAR (Delhi Analysis of Rates) provide approved departmental rates for materials, labour and machinery. The DSR (Delhi Schedule of Rates) issued by the CPWD (Central Public Works Department) and different PWDs (Public Works Departments) ensures standardised costing across government projects. Labour productivity is based on IS 7272 – Indian Standard Recommendation for Labour Output Constants, which specifies daily output norms for masons, labourers and work teams. Costing and billing rely on a well-prepared BOQ (Bill of Quantities) and regular RA Bills (Running Account Bills). Larger projects also require a DPR (Detailed Project Report), supported by accurate T&P (Tools and Plants) allocation and applicable GST (Goods and Services Tax). These full forms and standards help maintain clarity, transparency and correctness in Rate Analysis and civil engineering estimation.

Purpose of Rate Analysis

  1. Determine realistic unit rates for BOQ items

  2. Standardize costs as per AOR / SOR / DAR

  3. Evaluate contractor claims and prevent overbilling

  4. Plan labour and machinery based on productivity norms

  5. Support detailed technical and financial estimates

  6. Ensure compliance with CPWD / PWD specifications

  7. Maintain cost transparency during tendering

  8. Support DPR preparation & cost justification

  9. Compare market rates vs departmental rates

  10. Improve project cost control and decision-making

Main Components of Rate Analysis

1. Material Cost (With SOR/DAR Coefficients)

Material quantities are derived using standard engineering formulas and SOR/DAR material coefficients.
Includes:

  • Cement, sand, aggregates

  • Steel reinforcement

  • Bricks and blocks

  • Finishing materials

  • Wastage allowance (typically 2–5%)

  • Loading/Unloading/Transportation

Material rates must match SOR/DAR or latest local market analysis.

2. Labour Cost (As per Wage Code + SOR/DAR Rates)

Labour wages depend on:

  • Skilled, semi-skilled & unskilled categories

  • Minimum Wages Act

  • DAR/DSR wage tables

  • Productivity norms

Labour requirement is calculated using output constants (DAR norms).

3. Labour Output Constants - IS 7272 (Part -1 ) 1974

Labour Output Constants (as per Delhi Analysis of Rate (DAR) Labour Productivity Tables) define how much work one labourer or mason can complete in 1 day.

Standard Output Constants (DAR norms):

  • Earthwork Excavation: 3–5 m³ per mazdoor/day

  • Brickwork: 1.0–1.25 m³ per mason/day

  • Plastering: 8–10 m² per mason/day

  • Concrete Work: 1.5–2 m³ per labour team/day

  • Shuttering Removal: 10–12 m² per helper/day

  • Formwork Fixing: 5–7 m² per carpenter/day

  • Reinforcement Steel Cutting/Bending: 50–70 kg per fitter/day

These constants directly determine labour quantity and labour cost.

4. Machinery / Equipment Cost (AOR & DAR Based)

Machinery cost includes:

  • Excavators, JCB

  • Rollers, compactors

  • Tractor trolleys

  • Concrete mixers

  • Pumps and generators

DAR provides equipment hourly output which must be used:

Cost = (Hourly rate × Working hours) + Fuel + Operator

5. Lead, Lift, Carriage & Handling

As per DAR/SOR:

  • Lead = Horizontal transportation distance

  • Lift = Vertical movement

  • Carriage rates = Government-approved

  • Loading/Unloading allowances

Earthwork, concrete, sand, metal & brick transportation charges vary significantly based on lead distances.

6. Overheads, Contractor Profit & Taxes

Departmental norms (DAR/PWD/CPWD):

  • 10–15% Overheads

  • 10–15% Contractor Profit

  • GST as applicable

  • Safety & T&P charges

  • Site establishment cost

Additional Components of Rate Analysis

7. Site Conditions

Cost varies due to:

  • Soil type

  • Water table level

  • Accessibility

  • Weather conditions

  • Site layout

8. Productivity of Labour & Machines

Lower productivity = Higher cost
Higher productivity = Lower cost

9. Risk Factor / Contingencies

Usually 3–5% added in major infrastructure projects.

10. Quality Requirements

Higher quality standards increase:

  • Material consumption

  • Skilled labour requirement

  • Equipment usage

11. Duration of Work

Fast-track projects cost more due to overtime and extra machinery.

12. Local Market Fluctuation

Cement, steel, diesel prices change frequently and affect rate analysis.

Rate Analysis as per SOR / DAR

SOR/DAR documents include:

  • Material basic rates

  • Labour wage rates

  • Standard outputs

  • Coefficients

  • Equipment productivity

  • Approved unit rates

Using DAR ensures:

✔ Accurate
✔ Auditable
✔ Transparent
✔ Accepted by all departments
✔ Technically correct as per civil engineering norms

Importance of Rate Analysis in Civil Engineering

  • Ensures fair & transparent billing

  • Helps in accurate estimation & DPR

  • Supports Project Managers in resource planning

  • Helps Consultants justify technical rates

  • Useful for Billing Engineers during RA bill checking

  • Provides clarity to Clients/Owners

  • Avoids disputes between contractor & engineer

  • Improves overall project cost control

Rate Analysis at Afroz Civil 

Afroz Civil prepares Rate Analysis using:

  • Delhi Analysis of Rates (DAR)

  • CPWD Labour Output Standards

  • AOR (Analysis of Rates) methods

  • Real market material rates

  • Updated machinery productivity norms

Our Rate Analysis Bundle covers Excavation to Finishing Work, making it ideal for:

  • Billing Engineers

  • Project Managers

  • Consultants

  • Contractors

  • Clients

Download Rate Analysis Excel Sheet (AOR + SOR) Templates
Get professionally designed Excel sheets for Rate Analysis, Estimation, BOQ, Billing, DPR, Labour Management and Construction Planning. Perfect for Billing Engineers, Project Managers, Consultants and Contractors.

👉 Download Now:

 Click Here https://rzp.io/rzp/DKNgZTPZ


                                                        watch the excel template folder 

ChatGPT AI Prompt 

🎁 BONUS FOR YOU:

You can use this prompt to instantly find any BOQ item from DAR/DSR 2023.

Just change the activity name and press enter — ChatGPT will give you the exact DSR item number + full specification, perfect for Billing Engineers, QS, Estimation & Tendering Work.

BOQ Item Finder Prompt:

"From the Delhi Analysis of Rates (DAR/DSR 2023), give the exact item number and description/activity name for the activity "[enter name of activity here]", exactly as written in the DSR book.

Do not include any explanation, summary, or notes — only return the item number and full description as per the DSR format"

You can also watch the complete Rate Analysis process step-by-step on Afroz Civil.




Location: India

Popular posts from this blog

Types Of Level In Construction

Image
Complete Guide to Construction Levels Complete Guide to Construction Levels with Practical Explanations In construction and civil engineering, different levels are used to ensure proper alignment, stability, drainage, and functionality. Below is a step-by-step explanation of each level in logical order, with practical examples to help you understand them better. 1. Natural Ground Level (NGL) – The Original Surface Definition: The existing level of the ground before any excavation or filling. Practical Example: Imagine you buy land with an uneven surface. The NGL is the starting point before any construction activity. Why It’s Important? Used as a reference for leveling, excavation, and filling. Helps determine how much soil needs to be removed or added. 2. Existing Ground Level (EGL) – After Site Preparation Definition: The level of the ground after site clearing, but before exc...
Read more

Working Space for Footing Excavation: Standards & Guidelines You Can't Miss

Image
Working Space for Footing Excavation | Indian Standards Working Space for Footing Excavation as per Indian Standards Providing adequate working space around footing excavation is essential for safe and efficient execution of tasks, including placing reinforcement, formwork, and concreting. As per Indian Standards like IS 1200 (Part 1) and IS 3764:1966 , the required working space depends on the type, size, depth of the footing, and soil conditions. Below is a detailed explanation of working space requirements based on practical applications and Indian codes. 1. Working Space Dimensions The working space around footing excavation is categorized into 300 mm, 450 mm, 600 mm, and 750 mm , depending on the project requirements: a) 300 mm Working Space Application: Small-scale projects with shallow excavations (e.g., boundary walls, small residential structures). Minimal r...
Read more