Bottled Water Cost & Margin Calculator

Commercial estimate

Bottled Water Cost & Margin Calculator

Model the operating economics of replacing externally supplied bottled water with an on-site AYR Water program. Adjust the assumptions to match your property.

Your assumptions

Used to calculate on-site litres and CO₂ consumption cost.

70%

Sparkling share is automatically 30%.

30 days

Indicative. Final scope depends on system configuration and site conditions.

Optional. Leave at 0 if not applicable.

Estimated direct savings — 36 months

36-month comparison excluding VAT.

Current cost — 36 months

Per month

AYR estimated cost — 36 months

Per month, including CO₂ operating cost

Current cost per serve

AYR estimated cost per serve

Operating cost divided by monthly serves.

Annual bottles displaced

Over the selected period

Annual litres produced on-site

Break-even period

Time to recover the one-time reusable bottle investment.

Monthly commercial contribution

MetricCurrentAYR
Revenue
Gross contribution
Gross margin

Gross contribution change: per month

Want a property-specific calculation?

We can validate your water volumes, current costs, source-water conditions and operational requirements.

Request a Site Assessment

Commercial methodology

How the cost and margin estimate is calculated

The estimator provides an initial commercial comparison between externally supplied bottled water and an on-site AYR Water system. It uses the operating information entered by the visitor and is designed to support early-stage evaluation before a property-specific Site Assessment and proposal.

Calculation method

  1. Current bottled-water cost is calculated from bottles used per day, operating days, purchase cost per bottle and the selected analysis period.
  2. Estimated AYR operating cost combines the entered monthly service fee, indicative sparkling-water CO₂ consumption and any entered reusable-bottle investment.
  3. Direct savings compare the two operating-cost totals over 12, 24 or 36 months.
  4. Restaurant margin outputs compare revenue and gross contribution using the selling prices entered. These outputs are hidden when water is marked as complimentary.
  5. Hotel room demand is derived from occupied rooms and bottles placed per room, unless the visitor enters a property-wide daily total.

Key assumptions and limitations

  • Usage, purchasing cost, selling price, operating days, water mix and service fee are visitor-entered assumptions and should be replaced with current property data.
  • Sparkling-water cost uses the planning assumption shown in the calculator: one 5 kg CO₂ cylinder at Rp 500,000 producing approximately 600 L.
  • Figures exclude VAT unless VAT-inclusive values are entered.
  • Direct savings do not include labour, storage, transport, waste handling, carbon impacts or other operational effects that are not entered.
  • Actual performance and system requirements depend on incoming water, production and service windows, outlet locations, peak demand, chilling and carbonation requirements, installation conditions and operating procedures.
  • The result is indicative. It is not a quotation, guaranteed saving, financial advice or a complete lifecycle-cost assessment.

From estimate to an AYR Water proposal

The calculator introduces the commercial opportunity. AYR Water then validates the assumptions and defines a site-specific solution through the existing Site Assessment process.

  1. Validate the operation.
    Review current bottled-water volumes and costs, water applications, source-water conditions, outlet locations and service requirements.
  2. Define the configuration.
    Confirm treatment, chilling, carbonation, dispensing, reusable bottles, installation, commissioning, maintenance and support requirements.
  3. Issue the proposal.
    Set out the recommended system scope, commercial terms, bottle requirements, implementation responsibilities and the assumptions used for the property-specific business case.

Important: Final economics are confirmed only after the Site Assessment and written proposal. The proposal—not the online estimate—defines the equipment, service scope, installation requirements, pricing and commercial terms.