Prepared for Tony Borg, Gold Cup
Fleet Total Cost
of Ownership Review
14 vehicles · Sprinter & Metris fleet · March 2026
Observed VINs
14
11 active · 3 limited data
Total fleet miles
1.30M
Observed across all VINs
Avg cost / mile
$0.279
Baseline, excl. acquisition
Open campaigns
4
Across 3 VINs — action needed
ALPHA-coverable repairs
$24,066
Had ALPHA been active fleet-wide
Prepared by
Tony Warner, Russ Castleberry, Lance Decker, Bart Warner
Dealer
Mercedes-Benz Van Center Warner · #78116 · West Valley City, UT
Data sources
VMI (MB internal) · CARFAX · RO history · MB pricing bulletin Dec 2025

Fleet Dashboard

Operating cost summary · utilization tiers · assumption inputs

Customer-paid service
$63,569
+ $2,976 MB warranty value received
Est. ALPHA-covered (if enrolled)
$24,066
Turbo/DPF · starter · mass air · DEF
Avg baseline $/mile
$0.279
Baseline scenario
Fleet size
14 VINs
11 active · 3 pending data · 1 ALPHA ineligible
Assumption inputs
Operating cost / mile by scenario
High (>38k mi/yr) Medium (18–38k) Low (<18k) Open campaign ALPHA ineligible
Utilization tiers — 11 active VINs
Low <18k · Medium 18–38k · High >38k mi/yr (fleet std dev)
Operating cost breakdown — fleet total
Fuel and tire are assumption-driven estimates
$/mile progression by mileage band
Solid dot = current observed $/mi · hollow = projected using Sprinter cost escalation curve · fleet avg shown in gold
VIN-level summary
VIN (last 8)YearModelMi/yrTier Cust. svc$/mi baseline ELWALPHA elig.Recommendation

Downtime Analysis

Days out of service · cost impact · open campaigns driving unplanned downtime

Fleet total days down
209
Est. $104,500 at $500/day
Worst single VIN
53 days
LT037626 · 2020 FTL Sprinter · open campaign
VINs with zero days down
1
HP540793 · 2017 MB 3500 · clean record
VINs with >20 days down
4
NT082886 · MT066457 · NT114990 · LT037626 · KT011151
Downtime cost assumptions
Downtime cost covers driver wages, overhead, and operational drag while the vehicle is out of service. Add lost revenue and loaner costs for full impact view.
Days out of service by VIN
High (>20 days) Moderate (10–20 days) Low (<10 days)
Downtime detail by VIN
VIN (last 7)Unit #Primary RouteYear / Model Days DownEst. CostEst. Total ImpactOpen CampaignNotes
⚠ Open campaigns driving unplanned downtime
LT037626 · 2020 FTL Sprinter 2500 · SERVICE OPEN 2025070011 · 53 days down — highest in fleet. Must resolve before ALPHA enrollment.
HP540798 · 2017 FTL Sprinter 3500 · SERVICE OPEN 2025070001 · 13 days down. Starter + mass air sensor history. ALPHA-coverable once enrolled.
MT066457 · 2021 MB Sprinter 2500 · SERVICE OPEN 2025070011 + 2025070001 · 24 days down. Two open campaigns. ELW active; resolve before ALPHA.
P4238904 · 2023 MB Metris · RECALL 2025090006 + RECALL 2024040005 · PDI-only history. Two open safety recalls — schedule immediately.
Open campaigns must be resolved before ALPHA A+ enrollment is permitted. Each day a vehicle sits with an unresolved campaign is a day without coverage protection.

Coverage ROI Analysis

Would ELW + ALPHA have paid off? What does the data say going forward?

Post-warranty customer-paid
$47,788
Actual spend after MB warranty expired
ALPHA-coverable (if enrolled)
$24,066
50% of post-warranty spend coverable
PPM illustrative savings
$2,417
vs. retail A/B service pricing
Missed (KT011151 — ineligible)
$8,132
Net ALPHA benefit, now over 175k
Net ROI per VIN — coverage benefit vs. cost
Net positive — coverage paid off Net negative — cost > benefit (so far) Neutral / limited history Missed opportunity (now ineligible)
ALPHA benefit = post-warranty ALPHA-covered repairs. Net = covered repairs minus ALPHA premium (+ ELW if not already active in VMI). Emissions add-on included for all diesel VINs.
Where did Gold Cup spend? — by warranty phase
B2B: 3yr/36k · Powertrain: 5yr/60k · Post: ELW/ALPHA zone
ALPHA benefit vs. premium cost — by term length
Benefit = total ALPHA-coverable repairs. Cost = sum of premiums for all 10 eligible VINs.
Per-VIN ROI detail
Forward-looking — warranty windows & enrollment urgency
VIN (last 8)Year / modelB2B expiresPT expires Miles todayELW statusALPHA statusAction
ELW must be purchased before factory warranty expires. ALPHA requires active ELW. Best enrolled at or near delivery.

Coverage Recommendations

ELW · ALPHA A+ · PPM — by vehicle and by utilization tier

Coverage matrix — by utilization tier
TierMi/yr profileELWALPHA A+PPMRationale
High>38k mi/yr Yes Yes + Emissions Optional High mileage accelerates powertrain/DPF wear. ALPHA unlimited miles protects major events. Emissions critical for diesel.
Medium18–38k mi/yr Yes Consider Yes ELW covers post-factory risk. PPM locks service below retail. ALPHA ROI less clear without major repair history.
Low<18k mi/yr Yes Not recommended Less value Time-bound risk remains. ELW justified on age alone. ALPHA unlimited miles premium hard to justify at low utilization.
Ineligible>175k mi If applicable Not available If applicable ALPHA unavailable. Focus on PPM for service savings and budget predictability.
ALPHA A+ — pricing & eligibility requirements
TermMileageDeductibleRetail priceELW required
12 monthsUnlimited$100/repair$2,9195yr/100k ELW
24 monthsUnlimited$100/repair$3,0445yr/100k ELW
36 monthsUnlimited$100/repair$3,1445yr/100k ELW
ALPHA eligibility gate
Vehicle must be ≤15 model years AND ≤175,000 miles. Active MB ELW required. Emissions add-on included for all Gold Cup diesel Sprinters.
PPM packageServicesMSRP (diesel)Retail A/B valueSavings
2 Services2A + 2B$2,285~$2,418$133
4 Services4A + 4B$4,740~$7,254$2,514
MB ELW 5yr/100k: $1,275. PPM retail pricing per MB Vans Dec 2025 bulletin.
Per-VIN recommendation & ALPHA pricing
VIN (last 8)Year / modelTierALPHA elig. ELW statusELW costALPHA costCombined PPM rec.PPM costRecommendation
Acquisition recommendations — VIN-level replacement analysis
Based on mileage trajectory, utilization tier, downtime history, and current MB incentive programs. Option A is the preferred path; Option B is the practical alternative. All pricing assumes MY25 Sprinter 2500 Cargo Van, MSRP ~$62,000, Medium Fleet $3,000 (customer-facing), Dealer Cash PLUS $8,000 (dealer-retained back-end support enabling competitive front-end pricing). Finance rate 4.90% / 60 mo as standard DDR reference.
⚠ Dealer Cash PLUS ($8,000–$10,000) is dealer-retained — it is not applied to customer's sale price. Medium Fleet Cash ($3,000) is customer-facing and directly reduces the net purchase price or cap cost. Lease Bonus Cash is customer-facing on TRAC/FMV lease. Consult your accountant regarding Section 179 / bonus depreciation treatment and TRAC lease payment deductibility.
Open recalls & service campaigns — schedule before enrollment
W1YV0CEY9P4238904 · 2023 Metris · RECALL OPEN 2025090006 + RECALL OPEN 2024040005. PDI-only history — no service records yet.
W2Y4EBHY2LT037626 · 2020 FTL Sprinter · SERVICE OPEN 2025070011. 53 days down — highest in fleet. Resolve before ALPHA enrollment.
WDYPF1CD6HP540798 · 2017 FTL Sprinter · SERVICE OPEN 2025070001. Starter and mass air sensor history. ALPHA enrollment recommended after resolution.
W1Y4EBHY9MT066457 · 2021 MB Sprinter · SERVICE OPEN 2025070011 + 2025070001. Two open campaigns.
Open campaigns may affect resale value, insurance coverage, and ALPHA enrollment. Recommend scheduling all four VINs before the next fleet review.

Acquisition & Financing

Cash · retail finance · TRAC lease · closed-end lease — with Gold Cup Medium Fleet incentives applied

✦ Gold Cup Medium Fleet CAN — May 2025 Programs
Gold Cup qualifies for Medium Fleet incentives (15–249 vehicle fleet). The following MBUSA/MBFS programs are available for new Sprinter purchases and leases during the current program period (May 1 – June 2, 2025).
Medium Fleet
$2,000–$3,000
→ Customer-facing · reduces net price
Dealer Cash PLUS
$8,000–$10,000
→ Dealer-retained back-end support
Lease Bonus Cash
$1,500–$3,900
→ Customer-facing · reduces cap cost
Model year & type Medium Fleet Cash
→ customer
Dealer Cash
→ dealer-retained
Dealer Cash PLUS
→ dealer-retained
Excl. 1.9% APR
rate subsidy
Spec. APR (24–36mo)
rate subsidy
Lease Bonus Cash
→ customer cap cost ↓
TRAC Lease MF
rate subsidy
Notes
MY26 Sprinter Cargo Van ✦ new $2,000–$3,000 TBD TBD TBD TBD TBD MY26 Customer Cash $2,000 confirmed (customer-facing, combinable w/ Med Fleet). DCP and lease programs pending program period announcement. Base cargo from ~$62k.
MY25 Sprinter Cargo Van $3,000 $2,000 $8,000 4.90% $1,500 .00195 special / .00300 std DCP + Med Fleet combinable on standard DDR. Best DDR combo: DCP $8k + Med Fleet $3k = $11,000
MY24 Sprinter Cargo Van $2,000 $5,000 $10,000 1.90% 4.90% $3,900 .00195 special / .00300 std Excl. 1.9% APR not combinable w/ Med Fleet or DCP. Best DDR combo: DCP $10k + Med Fleet $2k = $12,000
MY24 eSprinter Cargo Van $3,000 2.90% $18,500 .00195 special $15,000 customer cash available separately (not combinable w/ Lease Bonus Cash)
MY25 eSprinter Cargo Van $3,000 2.90% $10,000 .00195 special $10,000 customer cash available separately (not combinable w/ Lease Bonus Cash)
Gold Cup — Cargo Vans only · Program period May 1 – June 2, 2025 · Contracts funded by MBFS no later than June 18, 2025 · Privileged & Confidential — Authorized MBFS Dealers Only · Standard rates apply when amount financed exceeds $100,000. Minimum amount financed $20,000.
✓ Best structure for Gold Cup — Finance (standard DDR)
MY25 Cargo Van: Medium Fleet $3,000 reduces customer's net price
Dealer Cash PLUS $8,000 is retained by dealer to fund competitive front-end pricing
Combined dealer support enables up to $11,000 in deal flexibility
⚠ Dealer Cash PLUS charges back if any MBFS Exclusive/Special APR is applied
✓ Best structure for Gold Cup — TRAC Lease
Medium Fleet $3,000 + Lease Bonus Cash $1,500–$3,900 reduce cap cost (customer-facing)
TRAC preferred for high-mileage cargo fleet: no mileage penalty, no excess wear, 100% pmt deductible, customer retains residual upside.
Special MF .00195 (36–48 mo, MY24–25, Tier A9–T2) + $3,900 Lease Bonus Cash on MY24 Cargo Van
New Sprinter acquisition calculator — Cash · Finance · TRAC Lease · Closed-End Lease
Vehicle pricing & incentives
Trade-in & tax
Sale price − trade equity
Total lifecycle cost — acquisition + coverage + operations
Combines acquisition cost (from calculator above), ELW, ALPHA or PPM, and fleet average operating cost into a full 5-year ownership picture. Adjust coverage inputs to model different scenarios.
Coverage & lifecycle inputs
5yr/100k · MB only
Unlimited miles · $100 ded.
Diesel 2026 pricing
Shelving, equipment, etc.
Fleet avg · fuel/maint/tire
For total mile calc
VIN-level contract tracker — amortization & disposal analysis
Enter current contract details per vehicle. For finance contracts, the amortization table shows outstanding principal at any date — critical for calculating net payoff if a unit is sold or traded mid-contract. FMV (closed-end) lease eligibility is auto-assessed from Fleet Setup mileage. For units over 15k/yr, the FMV column shows the projected date the mileage allowance is exhausted and the three decision paths available.
Vehicle Contract type Start date Term (mo) Purchase / cap price ($) Rate / MF Down / CCR ($) Residual ($) Disposal date Outstanding principal / status Amort
Outstanding principal = remaining loan balance at disposal date, calculated from amortization schedule. Net payoff = outstanding principal − estimated ACV (ACV not entered here — use as reference for trade negotiation). TRAC lease: at disposal Gold Cup is responsible for the residual; if ACV > residual, Gold Cup receives the surplus. FMV (closed-end) lease: mileage allowance exhaustion date shown — turn in at that point, refinance into new contract, or buy out at residual. No per-mile penalty modeled — the decision is structural, not incremental.

Fleet Setup

Assign unit numbers and routes — saved automatically and shown throughout all tabs

Unit numbers and routes appear in every VIN table and card across all tabs. Data saves automatically as you type. ✓ Saved
Unit identifiers, routes & annual mileage — 14 vehicles
Annual mileage per route is used throughout the dashboard for utilization tier, FMV lease eligibility (MB 15k/yr allowance guideline), and lifecycle cost projections. FMV Eligible column auto-computes: units projected to exceed 15k/yr on their assigned route are flagged — TRAC or finance is the better structure for those vehicles.
Vehicle Unit Number Primary Route Secondary Route Est. Annual Miles (route-based)
Export / Import
Export saves all unit numbers & routes as a file. Import merges with existing entries.