~/work/industrial-economic-analysis-tool.md
Case study

Industrial Economic Analysis Tool

A web-based application enabling engineers and economists to evaluate project viability by defining technical and financial parameters, then computing levelized unit-cost metrics under discounted cash-flow assumptions to assess break-even economics.

role
Technical Lead — Backend & Infrastructure
sector
Climate / Industrial Economics · Energy & Capital Project Evaluation
team
Small team · up to 3 developers
client
name and identifying details withheld · screens and data illustrative
status
● delivered to production
01 / Problem

Modelling complex investment scenarios

Users needed to model complex investment scenarios across dozens of parameters spanning timelines, ramp-up profiles, consumables, labor, transport, and detailed capital and operating costs — then analyze sensitivity and audit results over time.

02 / Approach

Clean boundary between application and calculation

Application foundation. Django backend with data models, an extensible input form system, interactive Plotly / Dash visualizations, integration with an enterprise data platform, and deployment into an existing Kubernetes environment.

The core calculations — DCF, NPV / IRR, levelized-cost solving — were implemented by domain specialists, with a clean serialization boundary separating application from calculation layers.

Input workflow. Dynamic Django forms with inline formsets, robust validation, and draft / error handling — failed calculations are saved as drafts with actionable error messages for safe correction and retry.

diagram · architecturesso · django · calc · data platform · dash
kubernetes · rolling · monitoring user · sso auth django forms · validate calc-engine dcf · npv/irr · lco data platform versioned snapshots dash-views summary · detail · sensitivity
domain specialists own the calculation layer · application owns inputs, persistence, and views
03 / Output Workflow

Three interactive views

Three views cover the full analysis loop: a KPI summary with cost-breakdown charts, an annualized detail table spanning the project lifetime, and a sensitivity analysis where users select variables, define ranges, and visualize impact on cost metrics. All screens and data are illustrative — real client data withheld.

04 / Auditability & Operations

Versioned snapshots, Kubernetes, SSO

Each save produces versioned snapshots in the data platform. The service operates on Kubernetes with rolling deployments, monitoring and alerting, availability objectives, and SSO authentication.

surfacecovers
inputs dozens of parameters · validation · draft / error handling
calc DCF · NPV / IRR · levelized-cost solving · break-even economics
views KPI summary · annualized detail · sensitivity analysis
audit versioned snapshots in the data platform
ops Kubernetes · rolling deployments · monitoring / alerting · availability objectives · SSO
05 / Outcomes

Delivered to production

Tool delivered to production and actively used for evaluating real investment scenarios. Supported small, high-performing team collaboration across backend, domain expertise, and UI development.

06 / Tech Stack

Tools

  • Django
  • Plotly / Dash
  • Enterprise data platform
  • Kubernetes
  • SSO
~/work
01 / 01 navigate · Esc close