Skip to planner

Free planning tool

Supply Yard
Scenario Planner

Pressure-test a one-stop sewer and underground utility supply yard before inventory, trucks, and equipment start consuming cash.

Built for scenarios, not promises. Change monthly sales, gross margin, inventory turns, overhead, and payment terms. The planner shows what those assumptions imply.

Your entries stay in this browser and are not saved or sent.

01 / Starting point

Choose a scenario

Illustrative defaults only

Monthly fixed overhead Payroll, insurance, utilities, software, and other fixed costs. Site, fleet & equipment setup One-time improvements and assets; land purchase is excluded. Fixed-overhead reserve months A simple runway buffer, separate from working capital. Average customer collection days Use 0 for immediate payment; longer terms increase cash need. Average supplier terms days Applied only to stocked-product cost in this model.

02 / Revenue engine

Model each category

Use expected monthly sales, not purchase volume.

01

Pipe & heavy fittings

Pipe, wyes, tees, cleanouts, couplings

Monthly sales Gross margin% Inventory turns / year

Annual sales: $672,000
Gross profit: $127,680
Avg. inventory: $54,432

02

Aggregates & bulk material

Bedding rock, sand, gravel, fill

Monthly sales Gross margin% Inventory turns / year

Annual sales: $288,000
Gross profit: $95,040
Avg. inventory: $16,080

03

Tools, PPE & consumables

Gloves, marking paint, hand tools, safety gear

Monthly sales Gross margin% Inventory turns / year

Annual sales: $168,000
Gross profit: $63,840
Avg. inventory: $17,360

04

Counter & convenience

Drinks, ice, snacks, towels, grab-and-go items

Monthly sales Gross margin% Inventory turns / year

Annual sales: $72,000
Gross profit: $30,240
Avg. inventory: $2,320

05

Fuel

On-site contractor fueling, modeled separately

Monthly sales Gross margin% Inventory turns / year

Annual sales: $144,000
Gross profit: $14,400
Avg. inventory: $5,400

06

Rental & yard services

Compaction gear, trailers, repairs, loading

Monthly sales Gross margin%

Inventory turnsService / asset

Annual sales: $120,000
Gross profit: $66,000
Avg. inventory: Not stocked

07

Jobsite delivery

Scheduled drops and urgent hot-shot service

Monthly sales Gross margin%

Inventory turnsService

Annual sales: $96,000
Gross profit: $48,000
Avg. inventory: Not stocked

03 / Sales mix

Where revenue comes from

Annual sales by category

Pipe & fittings$672,000

43%

Aggregates$288,000

18%

Tools & PPE$168,000

11%

Counter$72,000

5%

Fuel$144,000

9%

Rental & services$120,000

8%

Delivery$96,000

6%

04 / Capital

Modeled launch cash

Directional, before financing

Average inventory at cost: $96,000
Customer receivables buffer: $85,000
Less supplier financing: -$82,000
Net working-capital need: $99,000
Site, fleet & equipment setup: $250,000
Fixed-overhead reserve: $66,000
Modeled launch cash: $415,000

Read the model before trusting the number

What this planner calculates

The defaults are hypothetical starting points from the supplied business brief. They are not published industry averages. Replace them with supplier quotes, local demand evidence, payroll, insurance, fleet, permitting, and financing terms.

Gross profit

Annual sales × gross margin. Gross margin is not markup.

Average inventory

Annual product cost ÷ inventory turns. Service categories carry no stocked inventory.

Break-even sales

Annual fixed overhead ÷ blended gross margin, assuming the modeled sales mix stays constant.

Launch cash

Net working capital + setup assets + the selected fixed-overhead reserve.

Method reviewed August 21, 2026. Reference checks:

SBA break-even method ↗ U.S. Census industry scope ↗ EPA fuel-storage overview ↗