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.
Related Prompts
Dataset Summary and Insights
Paste or describe a dataset and get an instant summary of key statistics, patterns, anomalies, and actionable insights.
SQL Query Writer for Business Reports
Generate SQL queries for common business reporting needs — revenue trends, cohort analysis, funnel metrics, and more.
Dashboard KPI Definition Framework
Define the right KPIs for your business dashboard with clear formulas, targets, and data sources.