Change order for site inspection - In Excel Free Download

Change Order for Site Inspection


In the construction and civil engineering industry, change orders are an essential part of managing projects. They outline modifications to the original scope of work due to unforeseen circumstances, client requests, or necessary adjustments. In this post, we'll discuss a specific change order for a site inspection, as illustrated in the attached document.



Understanding the Change Order Document


The change order, prepared by Parag Pal, is available on the website www.civilnotess.com. It provides a detailed record of modifications required for a site inspection, including descriptions, reasons, reference numbers, quantities, unit prices, and total amount of variance.

Change order format in Excel for Site inspection work


Key Components of the Change Order


Change Description: The document lists three changes:

  • Highway Machines
  • Extra Labour for Cleaning
  • Water Pump

Reason: This column explains the necessity of each change. For example, extra machinery and manpower are needed for cleaning, and the water pump is a new addition not part of the existing contract.

Reference Number: This refers to the original contract or BOQ (Bill of Quantities) item, such as BOQ item 1.1 for the highway machines and extra labours.

Original Contract: Details the original quantities, units, unit prices, and amounts for each item.

Change Order: Shows updated quantities, units, unit prices, and amounts after the changes.

Total Amount Variance: Calculates the difference between the original contract amount and the change order amount, highlighting the financial impact.

Remarks: Additional notes or comments related to the changes.

Detailed Breakdown of Changes


Highway Machines:

Original Contract: 5 machines at ₹50,000 each, totaling ₹250,000.

Change Order: 15 machines at ₹50,000 each, totaling ₹750,000.

Total Amount Variance: ₹500,000.

Remarks: Additional work.

Extra Labour for Cleaning:


Original Contract: 10 labours at ₹800 each, totaling ₹8,000.

Change Order: 25 labours at ₹800 each, totaling ₹20,000.

Total Amount Variance: ₹12,000.

Remarks: Extra labour cost.

Water Pump:


Original Contract: Not applicable.

Change Order: 10 water pumps at ₹5,000 each, totaling ₹50,000.

Total Amount Variance: ₹50,000.

Remarks: Additional work.

Financial Summary


Total Original Contract Amount: ₹258,000.

Total Change Order Amount: ₹820,000.

Total Amount Variance: ₹562,000.

Tax (18% GST): ₹147,600.

Grand Total: ₹967,600.

Total Amount Variance (including tax): ₹663,160.

Watch detailed explanation video for Change order format for Site inspection.







Conclusion


Change orders are crucial for maintaining transparency and accountability in construction projects. They ensure all parties are aware of modifications and their financial implications. By understanding and utilizing change orders effectively, project managers can better manage resources, timelines, and budgets, ultimately leading to successful project completion.

Post a Comment

0 Comments