Aquatics Pool Chemical Usage Cost Analysis Builder

Analyze pool chemical logs, bather load, water test results, weather, and vendor pricing to explain chemical cost spikes for aquatic facilities.

Prompt Template

You are an aquatics operations data analyst. Review pool chemical usage and cost patterns for the facility below.

Facility type: [municipal pool, recreation center, hotel pool, aquatic complex]
Pools included: [lap pool, therapy pool, splash pad, outdoor pool]
Dataset fields available: [date, pool_id, free_chlorine, pH, alkalinity, chemical_added, quantity, unit_cost, bather_count, weather, maintenance_notes]
Time period: [date range]
Operating context: [hours open, swim meets, heat waves, closures, vendor changes]
Cost question: [why costs rose, which pool drives variance, how to forecast next month]
Safety constraints: [regulatory chemical ranges, do not recommend unsafe reductions]

Deliver:
1. Data quality checks for chemical logs and unit costs
2. Usage and cost trend summary by pool and chemical type
3. Variance analysis against budget, prior period, and bather load
4. Likely operational drivers of spikes or waste
5. Forecast assumptions for the next [time period]
6. Actionable recommendations that preserve water safety
7. Dashboard metrics for managers and maintenance staff

Example Output

Pool Chemical Cost Review: Community Aquatic Center

Executive Summary

Chemical spend rose 22% month over month, mainly from the outdoor lap pool. The increase appears tied to higher bather load, two heat-wave weeks, and a temporary over-correction pattern after low chlorine readings.

Cost Drivers

| Driver | Evidence | Estimated Impact |

|---|---|---:|

| Heat wave | 9 days above 95F, outdoor pool chlorine additions up 31% | $1,180 |

| Swim meet weekends | Bather load 2.4x normal, shock treatment next morning | $740 |

| Unit price change | Sodium hypochlorite vendor price up 8% | $390 |

| Manual over-correction | 6 days with high chlorine readings after large additions | $260 |

Recommendations

1. Add event-day chemical forecast notes before swim meets and camps.

2. Review dosing logs for days where chlorine exceeded the upper operating band after treatment.

3. Track cost per 1,000 bathers by pool, not only total chemical spend.

4. Negotiate next vendor order using projected summer volume and price thresholds.

Tips for Best Results

  • 💡Do not ask the model to lower chemical usage blindly; keep regulatory water safety limits explicit.
  • 💡Include bather counts and weather if available, because raw chemical spend can be misleading.
  • 💡Ask for cost per bather and cost per open hour to compare pools with different operating schedules.