Reports Hub / Equipment & Fleet

Equipment Cost Analysis

Weighted-Avg Cost vs Selling Price with rate-version annotations and per-class breakdown.

↓ From:Posted EQP lines (Combined Daily) + Machinery Class RatesSynced 4 hrs ago·↑ Feeds:County board reporting, WisDOT audit, Saved Reports

Parameters

County
Trailing 12 months
Last run: 9/30/2026, 3:56:59 PM by Alex Nguyen· via Saved Report →Sauk Equipment Q2Clean

Latest WAC ($/hr)

$50.05

Fleet-weighted across 7 classes

Selling Price ($/hr)

$55.47

Fleet-weighted across 7 classes

Margin

$5.42

$/hr

Fleet-weighted across 7 classes

Total EQP Cost (12mo)

$342,500.00

Fleet-weighted across 7 classes

WAC vs Selling Price (12 months)

OctNovDecJanMarMarAprMayJunJulAugSep$70$62$53WisDOT Mid-Year Sync · Feb 1, 2026 · Run #1842 →
Weighted-Avg CostSelling Price

WAC moves with actual monthly cost drivers (fuel, repairs, winter utilization); selling price is rate-book based and steps up after the WisDOT sync.

Cost by Machinery Class

GRDR-200
$87,420.00
DUMP-150
$64,180.00
LOAD-300
$52,640.00
PICKUP-050
$48,920.00
PLOW-100
$41,280.00
BACK-220
$28,640.00
SWEEP-180
$19,420.00

Results · 12 rows

MonthWAC ($/hr)Selling ($/hr)Margin
Oct$55.91$60.71+$4.80
Nov$59.21$61.06+$1.85
Dec$58.41$61.06+$2.65
Jan$61.11$61.31+$0.20
Mar$57.31$61.31+$4.00
Mar$56.11$61.61+$5.50
Apr$60.81$61.61+$0.80
May$65.41$61.91-$3.50
Jun$62.11$66.61+$4.50
Jul$58.91$66.91+$8.00
Aug$57.81$67.21+$9.40
Sep$60.71$67.51+$6.80