Case Studies | Sequential Analytics

Shipped — Flagship Project

Custom Sales App

R.F. MacDonald Co. — Industrial Equipment Services

Production sales application for a 12-office industrial equipment company — 7 forms, 31 tables, 145 users, built and shipped solo.

31

Database Tables

7

Form Types

145

Users

12

Offices

The Problem

Paper forms, manual entry, zero visibility.

R.F. MacDonald Co. is one of the largest boiler and burner service companies on the U.S. West Coast, with 12 offices across California and Nevada serving commercial, industrial, and institutional customers.

25 field salespeople were generating 100–125 quotes per month each. Every quote started on paper or a tablet, then got manually entered into NetSuite by inside sales.

That's 50–100 hours of data entry per salesperson per month. Errors, bottlenecks, and zero visibility for managers into what the field team was actually doing.

The Solution

A full production sales management application.

Not a prototype — a system used daily by a real company. Built from discovery call to production deployment by one person.

• 7 digitized form types with auto-calculation engines (pump quotes, skid quotes, AM/EMP estimates, BPO assessments, ANSI pump RFQs)
• 31-table PostgreSQL database with Row-Level Security on every table
• Multi-role access: admin, manager, field sales, inside sales
• Approval workflow: draft → submit → review → approve/reject
• Customer and equipment inventory, linked to jobs
• Executive dashboard: KPIs, trends, status distribution across all offices
• Mobile-first PWA, installable on phones for field use

Results

What changed.

Digitized paper-based sales workflow across 12 offices

Real-time manager visibility into field sales activity for the first time

Automated quote calculations that previously required manual spreadsheet work

Approval pipeline that eliminated bottleneck between field and office

Designed to save the company 1,000+ hours per month in manual data entry

Delivered beyond contract scope: labor rates admin, printable reports, CSV export, audit logging

Built with

Next.js Supabase PostgreSQL Vercel TypeScript Tailwind CSS shadcn/ui Row-Level Security PWA

In Development — Sequential Product

SPARK Assessment

Sequential Analytics — Proprietary Business Health Diagnostic

Proprietary business health assessment — 30 questions, 5 pillars, automated scoring. Sequential's diagnostic framework for small business consulting.

5

Pillars

30

Questions

150

Max Score

4

Tier Bands

The Framework

Five pillars of business health.

SPARK is a proprietary business health assessment framework designed for small businesses (5–100 employees) who know something isn't working but can't pinpoint where.

S Sales 0–30

P Performance 0–30

A Awareness 0–30

R Retention 0–30

K Knowledge 0–30

What Exists Today

Assessment framework and scoring engine.

Complete 30-question assessment framework with validated scoring methodology
Scoring engine: 0–150 total, 0–30 per category, with tier bands
React dashboard for presenting scored results
Professional report template with executive summary and recommendations roadmap

What's Being Built

→ Full automation pipeline: form submission → scoring → report generation → delivery
→ Tiered pricing model from self-service to premium multi-department analysis
→ Website integration for lead generation

SPARK demonstrates that Sequential isn't just a services shop — there's a product methodology behind the work. It shows structured thinking about how to diagnose business problems before building solutions.

Interactive Demo

Bakery Operations Dashboard

Rise & Proof — Sample Client

A fully interactive enterprise operations application for a bakery — 5 modules, 3 user roles, live cost calculations, and responsive mobile design. Built as a working demo to showcase what a custom business app looks like.

5

Modules

3

User Roles

8

Recipe Items

10

Inventory Items

The Concept

Show, don't tell.

Most agencies show mockups. We built a fully working application that visitors can click through on the homepage. No login, no signup — just open the site and start exploring.

Rise & Proof is a fictional bakery with real operational complexity: wholesale orders, recipe costing, inventory tracking, and role-based access for different team members.

The demo runs entirely in the browser — no backend, no database, no stored data. Just the frontend patterns and calculation engines that power production applications.

What It Includes

Five modules, three roles, real logic.

• Dashboard — KPIs, revenue charts, sales breakdown, and recent orders at a glance
• Orders — Filterable order management with status tracking and assignee visibility
• Recipes — Live cost calculator with ingredient management, batch scaling, and profit margins
• Inventory — Stock levels, reorder points, and inventory valuation
• Role Switching — Owner sees everything, Kitchen sees production, Front of House sees their orders
• Mobile Responsive — Full mobile layout with bottom navigation and card-based views

Why It Matters

What this demonstrates.

Production-grade UI patterns for complex business operations

Live calculation engines that update with every keystroke

Role-based access control that changes what each user type can see

Responsive design that works across desktop and mobile devices

Data architecture thinking — how entities relate across modules

The kind of application we build — try it yourself at the top of the homepage