PC

Production Co. — Command Center

April 2025 · 3 active projects · $68,400 revenue this year

3 projects activeJune gap opening1 invoice overdue

You're looking at a custom dashboard built for a video production company.

This is what your command center could look like — every project, proposal, crew booking, and dollar tracked in one place. No spreadsheets. No guessing if June is booked. Scroll down to explore the full layout.

Horizon Brands — $4,200 invoice overdue 18 days

Final deliverable was approved. No payment response since April 1.

Draft follow-up ↗

June is currently empty

You have $0 booked after May 28. Based on your average project lead time of 3 weeks, you need to close something this week.

Reach out ↗

Revenue YTD

$68,400

+31% vs same period last year

Active project value

$24,800

3 projects in flight

Pipeline (unconfirmed)

$41,200

4 proposals out

Overdue invoices

$4,200

Horizon Brands · 18 days

Avg. project margin

62%

After crew + gear + post

Revenue visibility — next 6 months

April

$18,400

Fully booked

May

$12,600

1 project confirmed

June

$0

Nothing booked

July

$8,000

1 proposal — 70%

August

$14,000

2 proposals out

September

TBD

No pipeline yet

Active Projects

Meridian Bank Brand Spot (30s)

Meridian Bank

Post-production
Deliver May 3$9,800Shoot complete
Progress75%

Profit after crew + gear + post

$3,200 crew$1,100 gear$800 post= $5,100 total
$4,700 48%

Vella Foods Product Launch Campaign

Vella Foods

In production
Deliver May 28$14,2003 shoot days remaining
Progress40%

Profit after crew + gear + post

$5,400 crew$2,200 gear$1,600 post= $9,200 total
$5,000 35%

Horizon Brands Social Content Pack

Horizon Brands

Invoice overdue
Deliver Mar 18$4,200Client approved
Progress100%

Profit after crew + gear + post

$800 crew$400 gear= $1,200 total
$3,000 unpaid71%

Proposals Out

$41,200 pending

Eastfield Foundation

Documentary 10min

$18,000
65% likely

SolarPath Energy

TV Commercial 60s

$12,000
80% likelyProposal opened 3x this week

Luma Skincare

Social content 8 videos

$7,400
50% likely

Veritas Group

Event recap full day

$3,800
30% likely

Revenue by Project Type

Commercials$28,400
Branded content$19,200
Social packs$10,600
Event / recap$5,200
Retainers$5,000

Crew & Freelancers

JM

J. Morales DP / Camera

Vella Foods — May 6

Confirmed
SK

S. Kim Editor

Meridian — post now

Active
RL

R. Lowe Sound

Vella Foods — May 6

Confirmed
DT

D. Torres Gaffer

Nothing booked

Available

Activity

Horizon Brands invoice — still unpaid, 18 days

Today

SolarPath proposal opened — 3rd time this week

Today

Meridian edit reviewed — 2 revision notes from client

Yesterday

Vella Foods shoot day 1 — complete, no issues

Apr 3

Luma Skincare — proposal viewed, no response yet

Apr 2

Project Profitability Tracker

ProjectPeriodContractCostProfitMargin
Apex Auto — TV spotJan · Delivered$16,400$5,900$10,50064%
Bloom Health — contentFeb · Delivered$8,200$3,800$4,40054%
Veritas — event recapFeb · Delivered$3,800$2,600$1,20032%
Horizon Brands — socialMar · Unpaid$4,200$1,200$3,000*71% unpaid
Eastfield — brand filmMar · Delivered$11,600$4,200$7,40064%

Client Health

Repeat clients

3 of 6 returned

50%

Avg. project value

commercials pulling up

$11,400

Avg. margin per project

after all hard costs

62%

Avg. payment time

target 14 days net

22 days

Proposal close rate

6 won of 9 sent YTD

67%

Monthly Revenue Trend

January$16,400
February$12,000
March$15,800
April(live)$18,400
May(projected)$12,600
June(gap)
Book a walkthrough →