Dashboards and tools we build

These are working samples of the dashboards and tools we build. They all run on one invented company's data.

Point/tap for details, click to drill, and choose "Show table" to see data behind any visual.

Dashboards

Web dashboards on sample data. Same view repeatable in Power BI.

Key numbers, sales and margin

Sandspur Marine, sample data

Are we ahead of last year, and where does the money come from?

What this tells you. Revenue is $3.73M so far this year, 10.1% ahead of last year. Install grew the most.

Try it: click Revenue to see where it comes from, or click a product line to filter the card.

Key numbers

Sales over time

Range

Sales, this year against last year

Margin by product line

Measure

Margin by product line, this year so far

Sales calendar

Sandspur Marine, sample data

Which days and hours are busiest? Counter and service sales.

What this tells you. Saturdays bring in the most, and June was the busiest month. The shops closed on 63 days.

Try it: click a busy day to open its month, then keep clicking down to the hour.

View
Show

Nov 10, 2025 to Nov 14, 2026

Scroll sideways to see the rest.

Sales a day:ClosedUnder $4,000$4,000 to $5,499$5,500 to $6,499$6,500 to $7,499$7,500 and over

Financial overview

Sandspur Marine, sample data

Did we make money, and what changed since last year?

What this tells you. EBITDA is $403,700 so far this year, 10.8% of revenue and $61,700 more than last year.

Try it: open What moved the bottom line and click a bar to see the accounts behind it.

View
Period
Compare with

From revenue to net income

Year to date, with each step as a share of revenue.

Revenue $3.73M 100.0%
Cost of goods sold -$2.44M 65.3%
Gross profit $1.29M 34.7%
Operating expenses -$890,378 23.9%
EBITDA $403,692 10.8%
Depreciation and amortization -$73,500 2.0%
Interest -$1,900 0.1%
Taxes (estimate) -$82,073 2.2%
Net income $246,219 6.6%

Profit and loss

January 1 to November 15, 2026, against the same days in 2025.

Profit and loss, January 1 to November 15, 2026
LineThis yearLast yearDifference%Result
$3,731,867$3,390,657+$341,210+10.1%
Cost of goods sold$2,437,797$2,198,199+$239,598+10.9%
Gross profit$1,294,070$1,192,458+$101,612+8.5%Better
$890,378$850,503+$39,875+4.7%
EBITDA$403,692$341,955+$61,737+18.1%Better
Depreciation and amortization$73,500$67,200+$6,300+9.4%
Interest$1,900$4,101-$2,201-53.7%
Taxes (estimate)$82,073$67,663+$14,410+21.3%
Net income$246,219$202,991+$43,228+21.3%Better

Custom tools

Tools your team works in every day, tied to QuickBooks from day one, on code you own.

Jobs on a map

Sandspur Marine, sample data

Which jobs need attention today?

What this tells you. 2 of 14 jobs are late and 3 are at risk. Those 5 carry $157,600 of budget.

Try it: click a pin marked Late, then Open budget.

Status
Crew
Map of the coast from Gulf Shores to Navarre.

Scroll sideways to see the rest.

On trackAt riskLateDone

Jobs

Job budgets

Sandspur Marine, sample data

Is each job on budget?

What this tells you. 12 of 14 jobs are on budget. Dock rebuild, job 2291 is on course to finish $4,590 over.

Try it: open Pilings, then mark the change order approved.

Jobs on budget 12 of 14
Budget $397,550 All 14 jobs
Spent $217,370 55% of budget
Expected final cost $385,210
Over or under $12,340 under
Change orders waiting $3,400 1 change order

Jobs

Job budgets
JobBudgetOn orderSpentExpected final costOver or underCompleteChange ordersStatus
$16,480$0$15,750$15,750$730 under100%NoneOn budget
$32,240$0$30,420$30,420$1,820 under100%$2,600 approvedOn budget
$54,000$8,780$37,660$51,120$2,880 under74%$4,800 approvedOn budget
$48,030$8,790$36,140$52,620$4,590 over69%$3,400 waitingOver budget
$41,970$1,630$21,310$39,640$2,330 under54%NoneOn budget
$18,940$0$16,730$18,200$740 under92%NoneOn budget
$16,940$0$15,620$16,280$660 under96%NoneOn budget
$35,640$7,330$7,180$33,660$1,980 under21%NoneOn budget
$24,490$13,680$6,040$23,540$950 under26%NoneOn budget
$1,110$0$0$1,110On budget0%NoneOn budget
$570$0$570$570On budget100%NoneOn budget
$39,040$8,020$3,900$36,870$2,170 under11%NoneOn budget
$39,600$0$1,860$37,400$2,200 under5%NoneOn budget
$28,500$1,720$24,190$28,030$470 under86%NoneWatch

Dock rebuild, job 2291

Over budget

By cost code

Dock rebuild, job 2291 by cost code
Cost codeBudgetOn orderSpentRemainingStatus
$2,000$0$2,000$0
$9,340$710$9,380$0Over
$8,000$0$9,760$0Over
$8,670$5,410$1,400$2,210Over
$12,010$0$8,930$5,480Over
$2,670$2,670$0$0
$2,670$0$4,670$0Over
$2,670$0$0$0
Total$48,030$8,790$36,140$7,690

Planned spending against actual, by week

Change order 1: longer pilings and one extra barge day, $3,400. Waiting for the customer's approval.

Labor forecast

Sandspur Marine, sample data

Do we have enough people for what we plan to build?

What this tells you. The week of Nov 30 needs 2 more welders than the shop has. Rigging has room.

Try it: add two T-tops to the week of Dec 7 and watch the shortfall grow.

Build plan, units per week

Build plan, units per week
ProductNov 16Nov 23Nov 30Dec 7Dec 14Dec 21Dec 28Jan 4Jan 11Jan 18Jan 25Feb 1Feb 8
T-tops
Leaning posts
Trailer kits

What the plan needs

Time frame

Hours needed each week, by product, against the hours the crew has

Scroll sideways to see the rest.

T-topsLeaning postsTrailer kitsCrew hours
What the plan needs, by week
Week ofNov 16Nov 23Nov 30Dec 7Dec 14Dec 21Dec 28Jan 4Jan 11Jan 18Jan 25Feb 1Feb 8
T-tops, hours58291451451455829588787588787
Leaning posts, hours2718181818189271818361818
Trailer kits, hours24122424242412242424242424
Hours needed1095918718718710050109129129118129129
Crew hours150150150150150150150150150150150150150
Short or spareSpare 41Spare 91Short 40Short 40Short 40Spare 50Spare 100Spare 41Spare 21Spare 21Spare 32Spare 21Spare 21
People needed5377743555555
People on hand5555555555555
Labor cost$4,142$2,242$5,586$5,586$5,586$3,800$1,900$4,142$4,902$4,902$4,484$4,902$4,902
Overtime cost$0$0$2,000$2,000$2,000$0$0$0$0$0$0$0$0

If the crew runs 10% faster or slower, the week of Nov 30 needs 168 to 206 hours.

Suggested action

Add 2 welders for the weeks of Nov 30 to Dec 14, or approve 120 overtime hours, about $6,000.

Hours = units × hours per unit. People needed = hours ÷ productive hours per person. Hours past the crew's total count as overtime.

Hours and people

Hours per unit
Hours per unitWeldingRigging
T-top
Leaning post
Trailer kit
People and cost
People and costValue
Welders
Riggers
Productive hours per person per week
Cost per hour, with taxes and benefits
Overtime cost per hour

The stock projection in Inventory and purchasing uses this plan.

Inventory and purchasing

Sandspur Marine, sample data

What should we order, and when does stock run out?

What this tells you. 6 of 36 items are at or below their reorder point. Anodized pipe, 1-1/2 in runs out first.

Try it: open To order and create the purchase order for torsion axles.

Inventory value $357,646 Parts and materials
On order $27,058 11 open purchase orders
Below reorder point 6 Items at or under it
Late orders 2 Past their expected date
View

36 of 2,140 items, the ones the build plan and the counter move most.

Stock on hand
SKUItemOn handAllocated to buildsAvailableOn orderReorder pointDays of supplyStatus
EL-SPRSpreader light94524148Reorder
TR-AXTorsion axle, 3,500 lb32112611Reorder
PC-IMPImpeller kit, 40 to 60 hp50524611Reorder
AL-150Anodized pipe, 1-1/2 in620 ft148 ft472 ft1,200 ft800 ft14Reorder
CV-CANMarine canvas52 yd7 yd45 yd60 yd60 yd18Reorder
FB-RHTRod holder tube861373605022In stock
EL-TLKTrailer light kit1911801027In stock
HW-EBOXElectronics box11110101227Reorder
PC-PROPStainless prop, 13 x 194044328In stock
EL-PNLSwitch panel162140829In stock
EL-DOMEDome light and fuse kit122100829In stock
TR-WINWinch and stand122100829In stock

Build checklist

Sandspur Marine, sample data

Does this build have its parts, and what has it cost so far?

What this tells you. Work order 4471 is 84% picked. The shop scrapped 40 ft of anodized pipe, 1-1/2 in, which added $265 to the build.

Try it: open Frame, then turn on Show only flagged.

Picked 84%
Planned cost $2,150
Actual so far $2,102
Budget $2,215 Planned plus 3% for scrap

Parts

Build checklist, work order 4471
PartRequiredPickedScrappedDamagedNot pickedStatusPlannedActualBudgetPick
100%Scrap$980$1,256$1,009
82%Scrap$420$370$433
29%In progress$330$98$340
91%In progress$420$378$433
Total84%$2,150$2,102$2,215

Flagged parts

Flagged parts, work order 4471
PartFlagReasonQuantityCost
Anodized pipe, 1-1/2 inScrappedBad bend40 ft$265
Marine canvasDamagedSewing error1 yd$31

Schedule and capacity

Sandspur Marine, sample data

Who is booked, and where is there room?

What this tells you. The Dock crew is 18 hours over the week of Nov 23, a short holiday week. One job could move a week.

Try it: click the week of Nov 23, then move a job to the next week.

Booked hours by job

Booked hours by job, next 8 weeks
JobNov 16Nov 23Nov 30Dec 7Dec 14Dec 21Dec 28Jan 4
Booked, all crews349209391415403232224343
Capacity420252408414420312324420
Open or overRoom 71Over 18Over 40Over 40Over 40Room 80Room 100Room 77
FullOver 18Room 30Room 12Room 12Room 6Room 12Room 12
Marina slips, job 228712182418
Dock rebuild, job 22913012
New dock, job 2294241812
Dock rebuild, job 231424
New dock, job 230124302418
New dock, job 2309243030243024
New dock, job 2312243036
Dock repair, job 231818
Booked9072607878426078
Capacity9054909090487290
Room 12Room 12Room 12FullRoom 12Room 12Room 6Room 12
Room 18Room 18Room 12Room 24Room 30Room 42Room 12Room 12
Room 14Room 13Over 40Over 40Over 40Room 2Room 37Room 14
Room 27Room 18Room 3Room 3Room 3Room 18Room 33Room 27

Capacity is people times 30 bookable hours a week, less time off and holidays.

What you would see on yours

Your own numbers

Read from your systems on a schedule instead of typed into a spreadsheet.

Tied to the books

Every total reconciles to your accounting software.

On the web or in Power BI

These samples are web pages. The dashboards work in Power BI too, if your team lives in Microsoft 365. The tools your team types into are web apps. Power BI or a web dashboard.

A price in writing

A Starter dashboard is $2,500 fixed. Larger dashboards and custom tools get a fixed quote after a paid scoping step. Every price.

Tell us which one you want with your own numbers.