Skip to content

core.md

Latest commit

 

History

History
465 lines (308 loc) · 11.8 KB

core.md

File metadata and controls

465 lines (308 loc) · 11.8 KB

Case Study

Table of Content:

  1. Introduction
  2. Implementation
  3. Inventory
  4. Production
  5. Deployment

Eco Innovative Technological Services (EITS)

Our client need an ERP solution for Quotation generation and Stock management. Currently they are using Tally and wants to Upgrade towards ERPNext.

Client deals with Manufacturing of Mechanical , Electronical and Plumbing items.

The sample quotation can be found here

Quotation Analysis - Aluminum Gate Work @ JAV Hindu Temple

1. BASIC INFORMATION

Company Details

  • Contractor: Eco Innovative Technical Services LLC (EITS)
  • Contact Person: S P Singh M D
  • Mobile: +971 501768742
  • Quote Reference: ET-QTN25-2891-00
  • Date: 12-May-2025

Client Details

2. PROJECT OVERVIEW

Project Scope

Subject: Aluminum Gate Work @ JAV Hindu Temple, Dubai

Main Components

  1. Sliding Gate: Heavy duty aluminum sliding gate (5200 x 2400 mm)
  2. Fixed Panel: Aluminum fixed panel (1050 x 1500 mm)
  3. Transportation: Delivery charges included

3. DETAILED SCOPE OF WORK

3.1 Main Sliding Gate (Item 1)

  • Dimensions: 5200 x 2400 mm
  • Type: Heavy duty sliding gate with partial blocked view
  • Material: Aluminum white powder coated
  • Features:
    • All aluminum joints welded, sanded & buffed
    • Gate outer frame: Aluminum profile 120x50x3 mm
    • Vertical tubes: Various sizes (80x20mm, 40x20mm, 120x20mm) with 40mm gaps
    • Backed with aluminum sheet for partial blocked view
    • Bottom rail: Steel flat bar 75x8mm (double gate length)
    • Hardware: 4 heavy duty SS ball bearing wheels, 8 guide rollers & wheels at top

3.2 Fixed Panel (Item 2)

  • Dimensions: 1050 x 1500 mm
  • Material: Same as sliding gate
  • Features: Partial blocked view, welded, sanded & buffed

3.3 Transportation (Item 3)

  • Service: Delivery to site
  • Cost: AED 407.00

4. FINANCIAL BREAKDOWN

Cost Summary

Item Description Quantity Unit Rate (AED) Total Cost (AED)
1 Sliding Gate 1 Lot 16,806.90 16,806.90
2 Fixed Panel 1 Lot 1,815.00 1,815.00
3 Transportation 1 Lot 407.00 407.00
Sub Total 19,028.90
VAT (5%) 951.45
GRAND TOTAL 19,980.35

5. TERMS & CONDITIONS

Payment Terms

  • VAT: All invoices subject to 5% VAT
  • Payment Schedule: 50% advance, remaining on completion (CDC)

Delivery & Completion

  • Delivery Time: 3-4 weeks from order confirmation with signed LPO
  • Work Completion: 3-4 working days from access & material availability
  • Quote Validity: 7 days from offer date

Client Responsibilities

  1. Access permits/passes and design approvals
  2. Welfare facilities for workforce
  3. Utilities (power supply, lighting, water)
  4. Equipment power shutdown/restart supervision

Contractor Responsibilities (EITS)

  • Fabrication, supply & installation
  • Quality materials and workmanship
  • Timely completion

6. BANKING DETAILS

  • Account Name: Eco Innovative Technical Services LLC
  • Bank: National Bank of Um Al Quwain (NBQ)
  • Account Number: 0086310167
  • SWIFT Code: UMMQAEAD
  • IBAN: AE340420000000086310167
  • Branch: Main branch, Khalid Bin Al Walid Street, Dubai

7. IMPORTANT DISCLAIMERS

Work Limitations

  • Work scope limited to provided photos/site visit discussions
  • Additional work will be quoted separately
  • Any existing damage/failures found during work subject to additional cost

Material Specifications

  • Client to provide approved products/RAL/manufacturer details
  • Similar products may be used if client specifications not provided
  • EITS not responsible for slight differences due to similar product usage

8. KEY ANALYSIS POINTS

Strengths

  • Detailed technical specifications
  • Clear cost breakdown
  • Professional presentation
  • Comprehensive terms & conditions

Considerations

  • Relatively short quote validity (7 days)
  • Client responsible for many site preparations
  • Additional costs possible for unforeseen issues
  • Final material selection flexibility may affect final appearance

Recommendations

  • Confirm exact material specifications before approval
  • Clarify any design requirements in detail
  • Ensure all permits and access arrangements are in place
  • Consider requesting extended quote validity if needed

Comprehensive Element Analysis - Quotation Document

DOCUMENT STRUCTURE & DATA TYPE ANALYSIS

1. HEADER SECTION

Document Type Identifier

  • Element: "Quotation"
  • Type: STATIC (Standard document type)
  • Format: Header text

Date Field

  • Element: "Date: - 12-05-25"
  • Type: DYNAMIC (Changes per quotation)
  • Format: DD-MM-YY
  • Note: Unusual formatting with dash prefix

Reference Information

  • Element: "Attention: Mr. Shyju Parayil"
  • Type: DYNAMIC (Client-specific)
  • Element: "Ref: ET-QTN25-2891-00"
  • Type: DYNAMIC (Unique quote reference)
  • Pattern: ET-QTN[YY]-[NNNN]-[VV] (Year-Sequential-Version)

2. CLIENT INFORMATION BLOCK

Organization Details

  • Element: "Hindu Temple Dubai, Jebel Ali Village, Dubai"
  • Type: DYNAMIC (Client-specific)
  • Structure: Organization + Location + City

Contact Information

Subject Line

  • Element: "Subject: Quotation for Aluminum Gate Work @ JAV Hindu Temple, Dubai."
  • Type: DYNAMIC (Project-specific)
  • Components: Service type + Location identifier

3. SALUTATION & INTRODUCTION

Greeting

  • Element: "Dear Sir,"
  • Type: SEMI-STATIC (Standard but could vary)
  • Gender assumption: Male-oriented

Opening Paragraph

  • Text: "Thank you for your enquiry and providing opportunity..."
  • Type: STATIC (Template text)
  • Purpose: Standard business courtesy

Value Proposition Statement

  • Text: "Below is our best quote...quality services and timely work completion"
  • Type: STATIC (Template marketing text)

4. PRICING TABLE (MAIN)

Table Headers

  • Headers: Sl.#, Location, Task, Scope of work, Unit, Qty, Unit Rate, Total Cost, Remark
  • Type: STATIC (Standard table structure)

Row Data

  • Sl.# "1.": STATIC (Sequential numbering)
  • Location "GF Outdoor": DYNAMIC (Project-specific)
  • Task "Aluminium gate work": DYNAMIC (Service-specific)
  • Scope: DYNAMIC (Detailed project specifications)
  • Unit "Lot": SEMI-STATIC (Common unit type)
  • Qty "1": DYNAMIC (Project-specific)
  • Unit Rate "19028.90": DYNAMIC (Price calculation)
  • Total Cost "19028.90": DYNAMIC (Calculated value)
  • Remark: EMPTY (Unused field)

Financial Calculations

  • SubTotal: DYNAMIC (Sum of line items)
  • VAT Label: STATIC ("Vat 5%")
  • VAT Rate: SEMI-STATIC (UAE standard rate)
  • VAT Amount: DYNAMIC (Calculated: 5% of subtotal)
  • Grand Total: DYNAMIC (Subtotal + VAT)

5. DISCLAIMER SECTION

Disclaimer Text

  • Content: "Works mentioned/quoted above are only limited to..."
  • Type: STATIC (Standard legal protection)
  • Purpose: Scope limitation and liability protection

Technical Specifications Clause

  • Content: "For tiles/cladding/paint project approved products..."
  • Type: STATIC (Standard material disclaimer)

6. BANK DETAILS SECTION

Section Header

  • Element: "Bank Details:"
  • Type: STATIC

Financial Information

  • A/C Name: STATIC (Company legal name)
  • SWIFT Code: STATIC (Bank identifier)
  • Bank Name: STATIC (Financial institution)
  • Account No: STATIC (Company account)
  • Bank Address: STATIC (Branch location)
  • IBN/IBAN: STATIC (International account number)

7. DETAILED SCOPE OF WORK (ANNEX)

Document Headers

  • "EITS SCOPE OF WORK (SOW)": STATIC
  • Date: DYNAMIC (Same as main quote)
  • Annex: SEMI-STATIC (Sequential numbering)
  • Quote Ref: DYNAMIC (Links to main quote)

Detailed Table Structure

  • Table Headers: STATIC (Standard SOW format)
  • Location Identifiers: DYNAMIC (Project-specific)
  • Task Descriptions: DYNAMIC (Work-specific)
  • Technical Specifications: DYNAMIC (Project requirements)
  • Quantities: DYNAMIC (Project-specific)
  • Rates: DYNAMIC (Current pricing)

Specific Work Items

Item 1.1-1.4 (Sub-components)

  • Type: DYNAMIC (Detailed breakdowns)
  • Structure: Hierarchical numbering system
  • Content: Technical specifications

Item 2 (Fixed Panel)

  • Type: DYNAMIC (Additional component)
  • Specifications: Technical details

Item 3 (Transportation)

  • Type: SEMI-STATIC (Standard service)
  • Cost: DYNAMIC (Distance/logistics based)

8. TERMS & CONDITIONS SECTION

Payment Terms

  • "Payment Terms:": STATIC (Section header)
  • VAT Statement: STATIC (Regulatory requirement)
  • Payment Schedule: STATIC (Company policy)

General Terms

  • "General Terms:": STATIC (Section header)
  • Delivery Timeline: SEMI-STATIC (Standard but adjustable)
  • Work Completion: SEMI-STATIC (Standard timeframe)

Validity

  • "Validity:": STATIC (Section header)
  • Validity Period: SEMI-STATIC (Standard business practice)

9. CLOSING SECTION

Closing Statement

  • Text: "Should there be a need for further clarification..."
  • Type: STATIC (Standard courtesy)

Sign-off

  • "Thanking you,": STATIC
  • Company Name: STATIC
  • Signatory Details: STATIC (Authorized person)

10. FOOTER ELEMENTS

Bank Details (Repeated)

  • Content: STATIC (Same as earlier section)
  • Placement: Footer for reference

Final Disclaimer

  • Content: STATIC (Legal protection)
  • Repetition: Same as header disclaimer

SUMMARY OF DATA TYPES

STATIC ELEMENTS (Never Change)

  • Document template structure
  • Company bank details
  • Standard terms and conditions
  • Legal disclaimers
  • Table headers and formatting
  • Courtesy language and closings

SEMI-STATIC ELEMENTS (Rarely Change)

  • VAT rates
  • Payment terms
  • Delivery timeframes
  • Unit types (Lot, Nos, etc.)
  • Standard service categories

DYNAMIC ELEMENTS (Change Per Quote)

  • Quote reference numbers
  • Client information
  • Project specifications
  • Pricing and calculations
  • Dates
  • Technical details
  • Quantities and measurements

DOCUMENT EFFICIENCY ANALYSIS

Template Reusability: ~60%

  • High reuse of structure and standard text
  • Efficient for similar aluminum work projects

Customization Required: ~40%

  • Technical specifications
  • Pricing calculations
  • Client details
  • Project-specific requirements

Areas for Improvement

  1. Standardize date format (inconsistent formatting)
  2. Automate calculations (reduce manual errors)
  3. Template fields for common variables
  4. Version control for quote references
  5. Gender-neutral greetings (currently male-assumed)

Implementation

The implementation can be studied here.