Business Overview#

The Atomberg BOM (Bill of Materials) system helps the procurement team manage what parts they buy, from whom, at what price, and how those prices change over time.

What Problem Does It Solve?#

Atomberg manufactures fans and other products. Each product is made of dozens of parts — plastic bodies, shafts, screws, foam packaging, tape, and more. Each part might come from multiple suppliers at different prices.

Before this system:

  • Pricing data lived in scattered Excel sheets

  • Comparing supplier prices meant opening multiple files

  • Tracking price changes over time was manual

  • Purchase orders were managed outside the system

  • Approvals happened over email

With this system:

  • All pricing data is centralized and searchable

  • Price history is automatic — every change is tracked

  • Supplier comparison is instant

  • Purchase orders flow through a defined approval process

  • Everyone works from the same source of truth

Key Concepts#

Parts = Everything You Buy or Make#

A “Part” in the system is anything physical:

  • Raw materials — plastic pellets, steel sheets, copper wire

  • Components — shafts, washers, PCB plates, foam packaging

  • Finished products — a complete ceiling fan

Each part has a unique code (like A348301) and belongs to a category (like “Plastic”, “EPS”, “Casting”).

Suppliers = Who You Buy From#

Each supplier has their own pricing for the parts they sell. The system tracks:

  • Which parts each supplier provides

  • Share of business — what percentage you buy from each supplier

  • Current and historical prices for every cost component

  • Cost breakdowns — raw material, processing, packing, freight, profit, etc.

Values = The Numbers#

Every cost figure is stored as a “Value” with a type (a “ValueHead”):

  • Weight values — Gross weight (45.5 gms), Net weight (32.1 gms)

  • Price values — RM cost (Rs 12.50), Process cost (Rs 3.20), PO price (Rs 28.90)

  • Percentage values — MB % (3%), Rejection % (2%)

Some values are entered directly. Others are calculated from formulas:

  • Existing RM Cost = (RM Rate per Kg * (1 - MB%) + MB Cost) * Gross Weight / 1000

  • Total BOP Cost = BOP Cost + BOP Handling Cost

Purchase Orders = What You Buy#

When it’s time to buy parts:

  1. Create a draft PO with line items (part + quantity + price)

  2. Submit it for approval

  3. Approvers review and approve or reject

  4. Supplier can counter-offer on prices

  5. Final PO gets accepted and eventually closed

Data in the System#

The system currently contains pricing data from:

Category

Suppliers

Parts

What’s tracked

Plastic

14 suppliers (Apex, Atharva, PGEL, Pune Polymer, etc.)

407

~35 cost components per part (weights, RM cost, process cost, BOP, freight, PO price)

EPS

5 suppliers (Styrotech, Kamaksha, KK Nag, etc.)

44

Weight, RM price, conversion, packing, freight, total cost

Corrugated Box

1 supplier (Boxline)

94

Box dimensions, ply count, flute type, final cost

Foam

1 supplier (Kamaksha Foam)

12

Dimensions, sheet cost, labor, overhead, profit

Tape

1 supplier (Tackon)

6

Current and revised prices, volume, cost impact

Polybag

1 supplier (Wrybillpack)

4

Dimensions, material weight, per-bag cost

Shaft

2 suppliers (Moon Engitech, ATPL)

2

Material cost, 17 process operations, overheads, freight

Washer

1 supplier (Chinar International)

2

Material weight, rates, cost per piece

Casting

1 supplier (Elicast)

1

41 cost components from die casting to total manufacturing

Total: 567 parts, 634 part-supplier relationships, 16,289 individual values

Workflows#

Price Comparison#

Search for a part (for example, "A348301")
  -> See all suppliers who sell it
  -> Compare their prices side by side
  -> View the full cost breakdown for each

Price Update#

Supplier sends a new costing sheet
  -> Import it using the data seeding command
  -> Old prices are preserved as history
  -> New prices become the "current" price
  -> Dashboard shows the price change impact

Purchase Order Flow#

Create draft PO -> Add line items -> Submit for approval
  -> Procurement Lead approves (Level 1)
  -> Finance Manager approves (Level 2)
  -> Supplier views PO in vendor portal
  -> Supplier accepts or counter-offers
  -> Final PO accepted -> Goods delivered -> PO closed

User Roles#

Role

What they can do

Admin

Full system access, manage users and settings

Procurement Team

Create/edit parts, manage suppliers, create POs

Finance Manager

Approve POs, review pricing changes

Category Manager

Manage parts and suppliers within their category

Vendor

View POs, accept/reject, make counter-offers (vendor portal)