pet-boarding-ops
Track boarding kennel occupancy from a daily bookings CSV — compute occupancy percent per day and revenue per available kennel (RevPAK) from your kennel count and nightly rate. Use when reviewing how full a pet boarding facility is and what each kennel actually earns.
$ skillbank install pet-boarding-ops@1.0.0 # pins exactly 1.0.0 · README + changelog included
Pet Boarding Ops
Overview
A boarding facility lives or dies on kennel utilization. This skill takes your total kennel count, a daily bookings file (how many kennels were occupied each night), and your nightly rate, then prints occupancy % per day plus RevPAK — revenue per *available* kennel, the number that tells you what each kennel earned whether it was full or not. Useful for weekly reviews, seasonal comparisons, and spotting the slow weekdays that need a promo before you reflexively discount weekends.
Installation
1. Copy the pet-boarding-ops/ directory anywhere convenient. 2. Make the script executable (Unix):
chmod +x scripts/occupancy.py
No pip install needed — standard library only. All data stays local — nothing is uploaded.
Configuration
Input file: a bookings CSV passed with --bookings (a starter is bundled at samples/bookings.csv):
date,dogs
2026-09-20,14
2026-09-21,19
2026-09-22,22
| Column | Required | Description | |--------|----------|-----------------------------------------------------| | date | yes | Night's date, ISO format YYYY-MM-DD. | | dogs | yes | Kennels occupied that night (whole number). |
dogs may never exceed --kennels — the script treats that as a data error and refuses rather than printing impossible occupancy. Dates must be valid ISO dates.
Inputs
| Command | Arguments | Returns | |---------------------------------------------------------------|--------------------------------------------------|------------------------------------------------------| | occupancy.py --kennels N --bookings <csv> [--nightly-rate R] | Kennel count (required), CSV (required), rate (default 55) | Per-day occupancy %, revenue, RevPAK; averages and total. |
RevPAK is (occupied kennels × nightly rate) / total kennels — it falls when kennels sit empty, which is exactly what you want to see. Bad input (missing file, wrong columns, bad dates, dogs > kennels, non-positive kennels/rate) exits nonzero with a plain-English error — never a traceback.
Worked example
$ ./scripts/occupancy.py --kennels 24 --bookings samples/bookings.csv --nightly-rate 55
Boarding occupancy — 24 kennels @ $55.00/night
Date Dogs Occupancy Revenue RevPAK
--------------------------------------------------------
2026-09-20 14 58.3% $ 770.00 $ 32.08
2026-09-21 19 79.2% $ 1045.00 $ 43.54
2026-09-22 22 91.7% $ 1210.00 $ 50.42
2026-09-23 18 75.0% $ 990.00 $ 41.25
2026-09-24 9 37.5% $ 495.00 $ 20.62
2026-09-25 12 50.0% $ 660.00 $ 27.50
2026-09-26 24 100.0% $ 1320.00 $ 55.00
--------------------------------------------------------
Average 70.2% $ 6490.00 $ 38.63
Total revenue over 7 day(s): $6,490.00
Thursday 9/24 ran at 37.5% — that's the night for the midweek stay promotion, not Saturday.
Version history
Changelog
1.0.0 — 2026-09-27
- Initial release. Occupancy and RevPAK calculator (scripts/occupancy.py) with sample bookings CSV.