Check gap night fill (FILL/SKIP)
gap_night_checkEvaluates whether filling a vacant night is profitable by computing a floor price based on costs and minimum margin, then comparing the candidate price. Returns fill or skip verdict with net after turnover costs.
Instructions
Checks whether filling a single gap night is worth it: computes the floor price (turnover cost + travel + minimum margin MIN_MARGIN, adjustable with the risk preset) from the median of the property's actual cost rows and compares the candidate price against it → FILL if price ≥ floor, otherwise SKIP. The verdict reports both the floor clearance and the actual net after turnover costs. If the date is already booked, reports which booking covers it. Read-only — never changes any prices.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| date | Yes | Night to check, YYYY-MM-DD | |
| risk | No | Risk preset for the floor's minimum margin (Wheelhouse's own CON/REC/AGG language): conservative doubles MIN_MARGIN, recommended keeps it as configured (default), aggressive uses 40% of it. | |
| property_id | Yes | Property identifier in the reservation data (property_id) | |
| candidate_price | No | Candidate price €/night — compared against the floor price; without it only the floor + guidance is shown |