All work stories
Anonymized case studyEV infrastructure / convenience retail

Modeling an EV charging chain as five businesses under one roof

An EV-infrastructure startup was planning a chain of roadside hubs that combined monthly charging memberships, pay-as-you-go charging, a mini-market, fast-casual food and coffee. The model had to represent both charging customers and ordinary walk-in or drive-through trade, then roll a typical site into a staggered multi-location launch.

Site economics and chain rollout planningFinancial model
Electric-car drivers charging beside a fictional roadside hub with a mini-market, food counter and coffee drive-through.
Original concept illustration. No client data shown.
CONFIDENTIAL BY DESIGNWhy you won’t see the client workbook

Financial models contain pricing, salaries, conversion assumptions, funding plans and other sensitive data. I do not publish client workbooks, identifiable screenshots or proprietary inputs—especially where an NDA applies. This page uses an anonymized summary and original concept art to explain the business decision and my modeling approach.

Five enginesRevenue architecture

Membership, metered charging, convenience retail, prepared food and coffee each use their own operating driver.

Member + walk-inCustomer mix

Recurring charging customers and passing retail traffic create different visit and purchase patterns.

One site → chainRollout logic

A typical-site model is copied through an editable opening schedule instead of blended into one growth rate.

COGS by streamContribution control

Energy, merchandise and food costs remain attached to the revenue activity that actually creates them.

WHY THIS WASN’T A TEMPLATE EXERCISE

The model had to respect
how the business actually moved.

The reconstructed structure separates five revenue engines, traces product-level cost of goods into contribution, builds a repeatable typical-site model and lets each location open on an editable rollout schedule.

01

One average order contained incompatible units

A monthly membership, a time-based charging session, a grocery basket, a meal and a cup of coffee could not be forecast as five equal pieces of one transaction. Each needed its own volume, price and frequency logic before the totals could be combined.

02

Traffic did not imply the same purchase journey

Some visitors arrived to charge, some were recurring members and others used the market or drive-through without charging. The model had to separate traffic sources from cross-purchase behavior instead of assuming every visitor bought the full bundle.

03

A site delay changed more than its opening month

Moving one launch shifted equipment spending, pre-opening costs, hiring, inventory, revenue ramp and the timing of cash recovery. Across a chain, a small date change could reshape the entire funding curve.

MODEL ARCHITECTURE

From operating activity
to a decision-ready view.

Each layer has one job. Together they keep the commercial story, unit economics and cash consequences on the same timeline.

01

Customer journeys

Charging members, pay-as-you-go drivers, walk-in shoppers and drive-through guests create separate visit pools with explicit overlap assumptions.

02

Charging revenue

Monthly membership tiers and metered charging sessions use their own adoption, utilization, price and service-speed assumptions.

03

Retail and food spend

Mini-market, prepared-food and coffee transactions are driven by customer traffic, attachment rates, order frequency and average spend by channel.

04

Stream-level contribution

Electricity, merchandise, ingredients, packaging and payment costs flow against the operating activity that creates each expense.

05

Typical-site economics

Staffing, occupancy, utilities, maintenance, working capital and capital expenditure produce a reusable site-level operating and cash profile.

06

Chain rollout

Each location receives its own opening date and ramp, while a dashboard scenario rolls sites into consolidated revenue, profit and funding needs.

WHAT THE ANALYSIS SURFACED

Useful answers,
without exposing client data.

The takeaways are intentionally qualitative. Exact assumptions, calculations and outputs remain inside the confidential client model.

Generalized project pattern

The charging visit was not the same thing as the basket

Charging can create a reason to stop, but ancillary revenue depends on how many visitors enter each channel, how frequently they buy and what portion of members return. Cross-sell therefore needed an explicit bridge rather than an automatic assumption.

Reconstructed insight

Every cost of goods needed its own denominator

Energy cost follows charging activity, merchandise cost follows retail sales and food inputs follow prepared orders. A blended COGS percentage could look plausible at group level while sending the wrong margin signal inside each business.

Generalized project pattern

The typical site was the real expansion unit

Separating one mature location from the rollout made it possible to test whether the concept worked before timing differences and overlapping ramps obscured site economics.

Reconstructed insight

The opening-date control was a funding sensitivity

A dashboard date selector was more than a presentation convenience: it linked site sequencing directly to capital deployment, operating burn and the lowest cash point.

MODELING APPROACH

The working system
behind the answer.

  • Customer traffic, membership and channel-overlap assumptions
  • Tiered monthly charging-subscription forecast
  • Pay-as-you-go charging volume, time and pricing schedule
  • Mini-market, prepared-food and coffee revenue builds
  • Stream-specific COGS and contribution schedules
  • Typical-site staffing, operating expense and capital plan
  • Editable location launch dates, ramps and dashboard scenarios
  • Consolidated site and chain P&L, cash and funding view

CASE CONFIDENTIALITY

This anonymized case explains the multi-revenue site and rollout logic without naming the founders, business, brand, market, dates, planned location count, site size, subscription structure, opening schedule or exact assumptions. The original scopes, workbook, dashboard and client comments remain private. The illustration is an original fictional EV convenience hub rather than a real location, floor plan, charging system or brand concept.

CUSTOM PROJECTS START AT $2,500 USD

Need a financial model?
Or the complete business package?

The final fee reflects the agreed scope, complexity and deliverables. Combined packages are quoted individually.