We Put Your Business
on AI AutopilotAI

The Challenge

Our client manufactures finished goods built from a defined Bill of Materials (BOM) — every unit produced consumes a specific combination of raw materials. Like most growing manufacturers, they were tracking this the way most businesses start out: across disconnected spreadsheets for purchases, production runs, and wastage.

The problem wasn't that spreadsheets don't work. It's that they don't scale. As the volume of daily entries grew, three things broke down:

• ✓
  No real-time answer to "do we have enough stock?" Checking whether raw materials could cover a planned production run meant manually cross-referencing multiple sheets — a process prone to human error and too slow to support same-day decisions.
• ✓
  No single source of truth. Opening stock, purchases, production consumption, and wastage lived in different places, so nobody could see the full stock movement picture at a glance.
• ✓
  No access control. Anyone with sheet access could edit core formulas or approve entries, with no accountability trail.

They needed a system that behaved like software, not a spreadsheet with more tabs.

The Solution

TTP designed and built RMS — a custom, browser-based inventory and production management system running on Google Apps Script with a Google Sheets backend, built specifically around the client's real production formula:

Every module was built to make that formula visible, live, and trustworthy:

• ✓
  Dashboard with flow-bar visualization — stock movement at a glance, no digging through tabs
• ✓
  BOM Availability Check — instantly confirms whether current raw material stock can support a planned production run, before a single unit is made
• ✓
  Stock Movement Ledger — a single, auditable trail of every stock-affecting event
• ✓
  Production, Purchase, and Wastage entry forms — structured data entry replacing free-form spreadsheet rows
• ✓
  Printable Production Challan — generated directly from entered data, no manual formatting
• ✓
  CSV bulk upload — for migrating existing historical records without re-typing months of data
• ✓
  Password-protected BOM Manager — only authorized users can edit the raw-material formulas that drive every stock calculation

The Performance Problem Behind the Scenes

Early in the build, the dashboard was technically complete but slow — over 15 seconds to load. The root cause: every dashboard section was independently re-reading the same sheets. For just 2 items, that meant 14+ separate reads; at 5 items, 26+.

TTP rebuilt the data layer around a single cached read: all source sheets are read once per session, and every dashboard section — stock summary, BOM availability, today's production, recent purchases — draws from that one cache instead of hitting the sheet again.

This is the kind of fix that doesn't show up in a feature list but defines whether a system actually gets used every day.

Built to Grow With the Business

RMS wasn't a one-time delivery — it's been extended in direct response to how the client actually works day to day:

• ✓
  Timestamped purchase entries for better audit tracking
• ✓
  A dedicated Wastage Adjustment tab that feeds directly into the final balance stock calculation
• ✓
  Password-gated status changes (Pending → Verified) on purchase/GRN entries, so approvals carry accountability
• ✓
  Rebranded from an internal working name to "RMS" as the client began treating it as a permanent operational system, not a project

Why It Matters

For a manufacturer running on tight production schedules, the difference between a 15-second dashboard and a 3-second one isn't just convenience — it's the difference between a tool people actually open every morning and one they quietly go back to avoiding. RMS gave the client a system that's fast enough to trust, accurate enough to rely on, and structured enough to grow alongside the business.

The Challenge

Our client runs on a team of field sales executives — out visiting clients, taking orders on the move, and managing an outstanding book that only grows more complex with every new client added. Running that operation well depends on two things happening at the same time: the field team needs a fast, reliable way to capture orders on a phone in the middle of a client visit, and leadership needs a real-time view of sales, receivables, and dispatch without waiting for someone to compile a report.

Neither was easy on a standard mobile browser setup. Long client meetings meant phones would sleep, browsers would reload, and an executive halfway through building an order — or recovering one taken over the phone — could lose everything they'd entered. On the leadership side, questions like "how are we tracking this month" or "which clients are overdue and by how much" meant manually pulling numbers together, every time.

The Solution

TTP built two connected systems for the client: a Field Sales App for executives working on the ground, and a Management Portal for the office side — payments, dispatch, and targets. Both run on the same backend, so nothing is ever out of sync between what a rep enters in the field and what leadership sees in the portal.

In the field:

• ✓
  Draft autosave — every field in an in-progress order is saved to the device as the executive types, and automatically restored if the page reloads mid-entry
• ✓
  Telephonic order recovery — orders taken over a phone call, not in person, get the same protection: the cart survives a reload instead of resetting
• ✓
  Clean invoice generation — professional, branded invoices generated directly from the order, with a navy header layout
• ✓
  Role-filtered Help & Training — new executives see onboarding guidance relevant to their role, not a generic manual

For leadership (the "Boss" role):

• ✓
  An AI analytics chatbot, powered by GPT-4o-mini, that answers business questions in plain language — but instead of computing everything live (slow, expensive, and inconsistent), it draws from a pre-computed 8-category, 100-point KPI scorecard refreshed on a schedule. The Boss gets an instant, consistent answer every time, not a chatbot "thinking out loud"
• ✓
  "All Clients" view — full visibility across the entire client base in one place, not filtered by territory

Across the whole system:

• ✓
  Role-based data pipeline — a single backend function determines what Admin, Executive, Customer, or Dispatch each see, so there's one source of truth instead of four separate builds
• ✓
  Credit-days-aware outstanding tracking — ageing buckets that account for each client's actual agreed credit terms, not a flat "30/60/90" assumption
• ✓
  Automated WhatsApp payment reminders — a daily trigger segments overdue clients into urgency buckets (10, 7, and 3 days before due) and sends reminders automatically, so collections follow-up happens without anyone remembering to do it manually
• ✓
  Partial payment support — the portal tracks partial settlements against an invoice, not just paid/unpaid
• ✓
  Searchable dropdowns and pagination throughout, so the system stays fast as the client and order list keeps growing
• ✓
  Dark/light mode built on a proper CSS variable design system, for executives working long hours in different lighting conditions

Why It Matters

A field sales operation lives or dies on two things: whether the person in front of the client can work without friction, and whether the person managing the business can see what's actually happening. TTP built the client's system around both — protecting every order an executive enters in the field, and giving leadership instant, reliable answers instead of another spreadsheet to chase. The result is a sales operation where the tool disappears into the background and the work just happens.