Case studies

See the work behind the service.

Explore the completed laundromat demonstration, including its spreadsheet model and report.

Go to the report preview →

Completed demonstration · Laundromat

Change prices, add a washer, or keep the current setup?

The study compared prices and equipment choices while checking how much washing and drying the operation could handle.

The problem

Busy periods can create queues even when machines sit unused at other times. The question was how to use the available machines and whether an addition would be worth its cost.

The options

The workbook tests three pricing plans and allows up to one eligible washer addition. The report compares the starting setup, a price change alone, and additions of three washer sizes.

96.0%Washer use during busy hours in the selected scenario
50.2%Washer use during quieter hours in the selected scenario
Different goalsThe most washes served did not mean the highest modeled profit.

Demonstration using assumed demand, price response, and cost inputs. These are model findings, not measured client results, implemented changes, or realized savings.

How this helps an owner

It shows why a decision about more equipment needs more than a daily average. An owner can compare prices and machine choices, see when the shortage occurs, and check which inputs need stronger evidence before spending.

A preview of the completed deliverable

The completed work includes an editable spreadsheet model, scenario comparisons, and a written report. This public excerpt keeps business identities private.

A look inside the spreadsheetExplore the model
Original workbook cells comparing the baseline, a price change, and adding one 8X washer. The full figures are available in the report comparison below.
  1. Current setup

    Plan A · no added washer

    Wash cycles
    1,844
    Modeled weekly profit
    $4,823.92
  2. Change prices

    Plan B · no added washer

    Wash cycles
    1,804
    Modeled weekly profit
    $5,180.97
  3. Add a washer

    Plan B · one added 8X washer

    Wash cycles
    1,859
    Modeled weekly profit
    $5,572.62
Three scenarios from the completed workbook. The figures show modeled weekly washer results, not measured business profit.
Read the full scenario comparison

Completed report · Reformatted excerpt

Comparing pricing and washer additions

This table reproduces the five scenarios in the completed report. All figures below are modeled weekly results for the washer operation.

Weekly washer scenarios
Option testedWash cycles servedModeled washer operating profit
Current prices, no addition (Plan A)1,844$4,823.92
Different prices, no addition (Plan B)1,804$5,180.97
Plan B + one 4X washer1,874$5,503.97
Plan B + one 6X washer1,804$5,050.97
Plan B + one 8X washer1,859$5,572.62

What the comparison shows: the 4X addition serves the most wash cycles. The 8X addition produces the highest washer operating profit under the tested inputs. Serving more washes and earning more are different goals.

Source: completed laundromat demonstration report, washer scenario comparison. The labels 4X, 6X, and 8X refer to washer size classes. Modeled operating profit includes washer revenue, variable washer costs, existing fixed costs, and the weekly cost assigned to an added washer. It is not an observed profit or a full equipment payback calculation.

Open the report excerpt for reading or printing →

What the model includes, and what still needs checking

The workbook includes pricing choices, washer sizes, demand by time period, washer costs, equipment additions, and a check of dryer capacity. Users can change inputs and rerun Excel Solver.

Customer demand and price response are scenario assumptions. Dryer use is illustrative and dryer costs are not yet validated. For that reason, the combined washer-and-dryer figure is not presented here as profit. The model also does not fully capture breakdowns, waiting behavior, or a full equipment investment appraisal.

A validated business study would need transaction records by time and machine, actual operating costs, downtime, and evidence of customer behavior. Proving an improvement would also require measurements after a change.

Work in progress

Other questions being developed

These projects have no completed findings to share yet.

RV rental

Data collection. How do rental days, prices, and costs affect the sales needed to cover expenses?

Food-service production

System development. How much can the business produce, and where does work get held up?

Specialty retail

Analysis planning. Which products and order sizes fit a limited launch budget?

Have a question about your business?

Tell me what you’re deciding. You don’t need to know which analysis to ask for.

Tell Me What You Need

I reply within 1–3 business days.