PubliFlowTN

Forecast liquidity crises from public contract delays

Score: 7.9/10TNMedium BuildReady to Spawn
Brand Colors

The Opportunity

Problem

Tunisian construction companies are crippled by over 3 billion dinars in unpaid public sector contract payments, triggering liquidity crises and halting ongoing projects.

Solution

PubliFlowTN analyzes your contract portfolio against historical payment data to predict exact cash shortfalls. It generates actionable plans like project prioritization or bridge financing needs. Stay ahead of halts with scenario simulations for different delay patterns.

Target Audience

Tunisian construction companies with public sector contracts

Differentiator

AI-driven forecasts using 5+ years of Tunisia-specific public payment delay stats, far beyond basic spreadsheets.

Brand Voice

supportive

Features

Portfolio Input

must-have10h

Enter or import contracts with milestones and invoices

Delay Forecasting

must-have25h

Predict payment dates based on ministry historicals

Cashflow Projections

must-have18h

Monthly/weekly charts of inflows vs outflows

Scenario Simulator

must-have15h

What-if analysis for worse/best delays

Risk Alerts

must-have12h

Warnings for high-risk contracts nearing crisis

Action Plans

must-have10h

Auto-generated recommendations like renegotiate or factor

Expense Integration

nice-to-have8h

Link ongoing project costs

Sharing Reports

nice-to-have6h

Share forecasts with banks/investors

Benchmarking

nice-to-have10h

Compare your delays vs industry avg

Total Build Time: 114 hours

Database Schema

users

ColumnTypeNullable
iduuidNo
emailtextNo
company_nametextNo

Relationships:

  • one-to-many contracts

contracts

ColumnTypeNullable
iduuidNo
user_iduuidNo
ministrytextNo
invoice_amountintNo
invoice_datetimestampNo

Relationships:

  • foreign user_id

forecasts

ColumnTypeNullable
iduuidNo
user_iduuidNo
predicted_shortfallintNo
run_attimestampNo

Relationships:

  • foreign user_id

historical_data

ColumnTypeNullable
iduuidNo
ministrytextNo
avg_delay_daysintNo

API Endpoints

POST
/api/contracts

Add contract

🔒 Auth Required
POST
/api/forecasts

Run forecast

🔒 Auth Required
GET
/api/forecasts

Get user forecasts

🔒 Auth Required
POST
/api/simulations

Run scenario

🔒 Auth Required

Tech Stack

Frontend
Next.js 14 + Tailwind + shadcn/ui + Recharts
Backend
Next.js API + Supabase
Database
Supabase Postgres
Auth
Supabase Auth
Payments
Stripe
Hosting
Vercel
Additional Tools
Vercel AI SDK for basic predictions

Build Timeline

Week 1: Setup and data model

35h
  • DB schema
  • Auth
  • Contract input

Week 2: Forecast engine

40h
  • Historical data loader
  • Basic predictor

Week 3: UI charts

40h
  • Dashboard visuals
  • Simulator

Week 4: Alerts and polish

35h
  • Risk logic
  • Exports

Week 5: Payments and test

25h
  • Stripe
  • Beta test fixes
Total Timeline: 5 weeks • 175 hours

Pricing Tiers

Free

$0/mo

No scenarios

  • 3 contracts
  • Basic forecast

Pro

$30/mo
  • Unlimited
  • Scenarios
  • Alerts
  • Plans

Enterprise

$100/mo
  • All Pro
  • Custom data
  • API

Revenue Projections

MonthUsersConversionMRRARR
Month 1804%$96$1,152
Month 64009%$1,080$12,960

Unit Economics

$30
CAC
$650
LTV
4%
Churn
90%
Margin
LTV:CAC Ratio: 21.7xExcellent!

Landing Page Copy

Predict & Prevent Liquidity Crises

Forecast public payment delays with Tunisia data – plan your cashflow now.

Feature Highlights

Historical delay predictions
Scenario what-ifs
Actionable plans
Visual cashflow charts
Risk alerts

Social Proof (Placeholders)

"Avoided project halt – EngCo TN"
"Accurate to the week! – BatiPro"
"Bank loved the reports"

First Three Customers

Post in Facebook groups 'Entrepreneurs Tunisie BTP' offering free forecasts using public data. Cold email top 50 public contract winners from marchespublics.gov.tn. Partner with 1 local accountant for referrals.

Launch Channels

Indie Hackersr/entrepreneurFacebook BTP TunisieLinkedIn Ads

SEO Keywords

prévision trésorerie BTP tunisieretards paiements publics constructioncashflow forecast contrats gouvernement tunisiesimulation liquidité ministère tunisien

Competitive Analysis

Float Cashflow

floatapp.com
$59/mo
Strength

General forecasting

Weakness

No public sector data

Our Advantage

Tunisian public delays baked in

🏰 Moat Strategy

Growing proprietary historical delay dataset with user-submitted validations

⏰ Why Now?

Arrears escalating post-2023 elections, firms desperate for predictive tools

Risks & Mitigation

technicalmedium severity

Inaccurate predictions early on

Mitigation

Seed with public data, iterate with user feedback

executionhigh severity

Data collection slow

Mitigation

Manual bootstrap + cron scrapers

Validation Roadmap

pre-build5 days

Survey 15 firms on delay pains

Success: 80% interested

mvp21 days

Manual forecast spreadsheet tool

Success: 5 paid conversions

Pivot Options

  • Private sector cashflow tool
  • Expand to Algeria public contracts
  • Integrate with ERP as plugin

Quick Stats

Build Time
175h
Target MRR (6 mo)
$1,200
Market Size
$4.0M
Features
9
Database Tables
4
API Endpoints
4