EXCEL AUTOMATION · GARMENT FACTORIES

Excel automation for garment factories in Kolkata

Tirumala Automation builds Excel automation for garment factories in Kolkata and across India. Orders, fabric, trims, production, costing and dispatch live in one connected system on the Excel your team already uses, with Power Apps for floor entry and WhatsApp alerts for owners and merchants. The company was founded by Mohit Agarwal and Rohit Agarwal.

Book a live demo WhatsApp us

The problem: one factory, many files

In most garment factories the order sits in one file, fabric and trims in another, production in a register and dispatch in a WhatsApp group. When a buyer calls, someone has to dig through all of them to answer a simple question such as “Where is PO #4362?”

That digging is the real cost. Follow-ups live on sticky notes, five people read the same whiteboard, and several versions of the truth circulate at once. The aim of the system is to replace an hour of chasing with a three-minute look at one screen.

How the Excel system works

Every update follows the same five steps, so the data is entered once and used everywhere.

  1. Mobile entry in Power Apps. Floor staff enter data on an Android phone. It syncs live to SharePoint.
  2. Excel macro fires. The VBA engine cascades the formulas, validates stock and refreshes the KPIs.
  3. Logic layer flags problems. A rule engine spots delays, shortages and variances as they happen.
  4. PDF reports build themselves. Boardroom-ready reports are created and sent out automatically.
  5. WhatsApp alert. Managers receive alerts for production, stock and KPI breaches.

The 17 modules

You do not need all of them on day one. We agree which modules you need when we scope the work, and you can add more later.

Orders and planning

  • PPM File Addition: timeline
  • Planning vs Actual: variance
  • Forecast Analysis: AI prediction

Samples and job cards

  • Printing Sample Job Card: auto PDF
  • Embroidery Bulk Job Card: live sync
  • Buyer Sample Conversion: auto calculation

Materials and stock

  • Trims Card: shortage detection
  • BOM Sheet: auto calculation
  • Free vs Booked Stock: real-time
  • Accessory Inventory: low-stock alerts

Costing

  • Quoted vs Actual Costing: variance
  • Costing Module: multi-currency

People and capacity

  • Job Worker Capacity: live booking
  • Attendance & Payroll: auto calculation
  • KPI Per Merchant: real-time

Reports and alerts

  • Auto Daily Production Report: 09:00 AM
  • Automated Red Alerts: WhatsApp
SEE IT WORKING

Watch it work.

Automated fabric order generation

Enter the buyer quantity once and the purchase orders generate themselves. This demo shows how a single entry replaces repeated typing across files.

Accessory pending intelligence

Delayed trims are flagged in real time, so a merchant sees a shortage before it stops a line. This demo shows the pending-accessory view.

Your data stays safe

Your system runs on Microsoft platforms, so your data sits on Microsoft servers. It is encrypted in transit and at rest, backups run automatically and are versioned, so an earlier state can be restored, and access is role-based: each merchant, buyer or supervisor sees only what belongs to them.

Who it is for

The system is built for garment manufacturers, merchants and owners who already run orders in Excel and want the data connected. Four garment manufacturers use Tirumala Automation today; see the Clients page. The same approach also works for furniture makers and interior designers.

FAQ

Questions, answered.

What is Excel automation for a garment factory?

It connects orders, fabric, trims, production and dispatch data in one Excel-based system, so reports, alerts and costing update automatically instead of being typed by hand.

Do you work with factories outside Kolkata?

Yes. Tirumala Automation is based in Kolkata and builds for garment, furniture and interior businesses across India.

Will my team need a lot of training?

Your team keeps working in Excel, and floor staff use a simple mobile form, so there is little new to learn. We agree what training is needed when we scope the work.

Where is our data stored?

On Microsoft platforms. It is encrypted in transit and at rest, backed up automatically with versions, and shown to each person by role.

How do alerts reach us?

Red alerts and daily reports are sent on WhatsApp, and managers can also approve costing from a phone.

How long does set-up take?

It depends on how many of the 17 modules you need and how your data is organised today. We scope the work in the live demo and give you a plan before you commit.

SEE IT ON YOUR OWN FLOOR

Book a live demo.

We show the system on sample data and map it against how your business runs.

Book a live demo WhatsApp us
WhatsApp