🏭

My Role — Lead Designer & Builder

Designed the full commercial decision framework for industrial services bid management. Defined the two-layer economics model, the 15-rule Go/No-Go logic, the commodity sensitivity approach, and the site audit gate from requirements gathered directly with operations and finance leadership. Built and deployed the complete application end-to-end.

Contract Economics Design Go/No-Go Framework Commodity Sensitivity Model Pricing Model Design Site Audit Gate Microsoft 365 Integration
Case Study 06  ·  Industrial Services

CAO Bid Portfolio
Industrial Bid Intelligence Engine

Two-layer contract economics  ·  15-rule Go/No-Go engine  ·  Commodity sensitivity  ·  Live pricing calculator

React 18 Microsoft 365 Industrial Services Contract Economics Go/No-Go Engine Commodity Sensitivity Site Audit Gate
Launch Live App
Overview

The Problem & What Was Built

Service organisations competing for large industrial contracts face a recurring problem: bid decisions rely on individual judgment rather than a consistent economic framework. Opportunities get pursued based on revenue size alone, with no structured view of margin, pursuit cost, commodity risk, or site readiness. The result is misallocated commercial resources and contracts that erode profitability.

The CAO Bid Portfolio replaces that with a disciplined commercial decision engine — structuring every opportunity through the same economic lens before a single proposal hour is spent.

15
Go/No-Go Rules
2
Economic Layers
7
Bid Stages
6
App Views

Before

  • Bid viability assessed subjectively with no consistent economic framework
  • Pursuit cost not tracked against contract value
  • Byproduct commodity revenue excluded from margin calculations
  • No structured site audit gate — field readiness tracked informally
  • Go/No-Go decisions by individual judgement with no rule enforcement
  • Concurrent bid load not monitored — commercial resources overstretched

After

  • Two-layer economic model: pursuit cost evaluated against contract Expected Value
  • Byproduct commodity revenue factored into adjusted margin calculation
  • Commodity sensitivity flag when implied price/ton exceeds market threshold
  • 7-point site audit gate per bid before submission
  • 15 deterministic Go/No-Go rules evaluated in priority order on every update
  • Capacity concurrency monitor — flags when active bid load exceeds limit
📋
Intake
🔍
Qualified
🏭
Site Audit
💰
Pricing Model
⚖️
Go/No-Go
📤
Submitted
🏆
Won / Lost
Commercial Framework

Two-Layer Contract Economics

Every bid is evaluated across two economic layers. Layer A asks whether the pursuit itself is worth the investment. Layer B models the full contract economics — adjusted margin accounting for byproduct revenue, overhead, and risk. Together they answer the right commercial question: not "can we win this?" but "should we pursue it?"

LAYER A Pursuit Cost
  • Quantifies the cost of the bid development process itself
  • Based on bid team size, pursuit duration, and loaded team rate
  • Measured against the Expected Value of the contract
  • Pursuit ROI: gross profit relative to what was spent pursuing it
  • Review flag when pursuit cost is disproportionate to contract value
  • Hard stop when pursuit cost equals or exceeds the full Expected Value
LAYER B Contract Economics
  • Models adjusted annual margin net of all cost factors
  • Byproduct commodity revenue applied as a cost base offset
  • Overhead allocation factored into the cost structure
  • Commodity sensitivity: implied price/ton vs configurable market baseline
  • Expected Value: contract revenue weighted by win probability
  • Full-term totals projected across the contract period
Byproduct offset: Industrial services contracts — particularly in metals processing, chemical handling, and materials recovery — generate commodity byproduct streams that offset the cost base. The platform models this as an annual revenue credit applied before margin calculation. A sensitivity flag triggers automatically when the implied price per tonne diverges from the configured market baseline beyond the warning threshold.
Economic Evaluation Flow
Opportunity inputs → structured evaluation → bid decision
flowchart TD Opportunity[Contract Opportunity] Opportunity --> RevenuePotential[Revenue Potential] Opportunity --> CostStructure[Cost Structure] Opportunity --> RiskProfile[Risk Profile] Opportunity --> WinProbability[Win Probability] Opportunity --> CapitalExposure[Capital Exposure] RevenuePotential --> EconomicEvaluation[Economic Evaluation] CostStructure --> EconomicEvaluation RiskProfile --> EconomicEvaluation WinProbability --> EconomicEvaluation CapitalExposure --> EconomicEvaluation EconomicEvaluation --> BidDecision{Bid Decision} BidDecision -->|Pursue| BidPortfolio[Bid Portfolio] BidDecision -->|Decline| ExitOpportunity[Exit Opportunity] BidPortfolio --> StrategicRevenue[Strategic Revenue]
Commercial Use Case Flow
Assessment inputs → decision → portfolio or exit
flowchart LR Opportunity[Opportunity] --> EconomicReview[Economic Review] EconomicReview --> RevenueAssessment[Revenue Assessment] EconomicReview --> CostAssessment[Cost Assessment] EconomicReview --> RiskAssessment[Risk Assessment] EconomicReview --> WinProbability[Win Probability] RevenueAssessment --> Decision{Decision} CostAssessment --> Decision RiskAssessment --> Decision WinProbability --> Decision Decision -->|Pursue| BidPortfolio[Bid Portfolio] Decision -->|Decline| Exit[Exit] BidPortfolio --> StrategicGrowth[Strategic Growth]
Decision Engine

15-Rule Go/No-Go Framework

How it works: Rules run in strict priority order on every update. The first NO-GO trigger wins — evaluation stops. REVIEW flags accumulate; a bid can carry multiple simultaneously. Once a bid reaches a terminal stage (Won, Lost, No-Go), that status overrides all calculated outcomes.
#OutcomeRule
1NO-GOSafety Pre-Qualification failed
2NO-GOSite visit not completed and bid is at Submitted or Won stage
3NO-GOFixed Fee contract and adjusted annual margin is below the minimum threshold
4NO-GOBid pursuit cost equals or exceeds the full Expected Value of the contract
5NO-GOActive concurrent bids at or above the capacity limit
6REVIEWAdjusted annual margin is below the minimum threshold
7REVIEWWin probability is below the minimum floor
8REVIEWPursuit cost exceeds the maximum allowable percentage of Expected Value
9REVIEWFixed Fee contract type — cost overrun risk flag, always applied
10REVIEWImplied byproduct price per tonne exceeds the commodity market baseline threshold
11REVIEWSafety Pre-Qualification pending — outcome not yet confirmed
12REVIEWSite visit not yet completed at Qualified stage
13WONStage set to Won — terminal status, overrides all calculated outcomes
14LOSTStage set to Lost — terminal status
15NO-GOStage set to No-Go — terminal status
Application Views

Six Views

01 — DASHBOARD
Portfolio Health Overview

Active bid count, pipeline Expected Value, GO/REVIEW/NO-GO/Won breakdown, annual revenue under management, average adjusted margin, byproduct pipeline, total pursuit investment. Stage distribution, industry vertical mix, contract type risk split, capacity monitor, and mobilisation tracker for won contracts.

02 — PORTFOLIO GRID
Full Bid Table with Inline Edit

All active bids in a filterable table — Stage, Industry Vertical, and Go/No-Go outcome filters applied simultaneously. Expand any row to edit all fields inline with a live contract economics summary updating in real time. Two-step confirmation on delete.

03 — ADD BID
Intake with Live Viability Preview

New bid intake form with a live preview panel calculating the Go/No-Go outcome, adjusted margin, Expected Value, pursuit ROI, and any fatal flags in real time as the form is filled — before the bid is saved to the portfolio.

04 — SITE AUDIT
7-Point Field Readiness Gate

All bids in early stages shown with a per-bid 7-point checklist: tonnage, equipment, labour environment, byproduct streams, commodity buyer confirmation, safety walkthrough, and scope agreement. Progress bar, financial snapshot, and Go/No-Go status per bid card.

05 — PRICING MODEL
Live Cost-Build Calculator

Bottom-up annual cost build: labour roles, headcount, wages and burden rate through to equipment, consumables, subcontractors, overhead, risk contingency, byproduct credit, escalation, and throughput. Outputs a recommended annual price at target margin with a full margin sensitivity table.

06 — SETTINGS
Business Logic Configuration

All decision engine parameters are configurable — margin threshold, win probability floor, pursuit cost ceiling, burden rate, overhead, commodity baseline, concurrency limit. Changes are shared across all users. Live preview shows current rule thresholds before saving.

Pricing Model

Live Cost-Build Pricing Calculator

The Pricing Model is a bottom-up cost construction tool purpose-built for industrial services contract pricing. Starting from labour — roles, headcount, wages, and payroll burden — it builds through equipment, consumables, subcontractors, overhead, and risk contingency to arrive at a total annual cost. Byproduct credit is applied as an offset. The output is a recommended annual price at the target margin, with a full-term contract total and a margin sensitivity table showing price at increments above and below target.

Create Bid from Model: Once a pricing scenario is built and the economics are sound, the model generates a new bid record directly — pre-populated with the revenue, margin, and contract parameters from the pricing output. The pricing exercise connects straight into the portfolio decision workflow.
CAO Bid Portfolio — Pricing Model
Pricing Model — Labour cost build · Annual cost waterfall · Recommended price · Margin sensitivity table  ·  Click to expand