Model what a site-rate increase actually earns: how much gross revenue the bump adds, how much occupancy sensitivity gives back, and the occupancy you must hold for the increase to pay for itself.
The model is live. All inputs are recognized: current and new monthly site rent, affected sites, baseline occupancy, and occupancy sensitivity (elasticity). Fix any field marked invalid and everything recomputes instantly.
Added gross revenue = occupied sites × (new rate − current rate) — the revenue the bump adds if every currently-occupied site stays. This is the upside before any occupant leaves.
Occupancy sensitivity E answers: for every 1% rate increase, what % of occupied sites walk? new occupancy = current occupancy × (1 − E × % increase). Lost revenue is the departed sites valued at the new rate.
Net impact = added gross revenue − lost revenue. Positive means the increase earns more than occupancy loss costs it; negative means the opposite. Equal means the increase is revenue-neutral.
The occupancy at which the increase pays for itself: break-even = current occupancy × (current rate ÷ new rate). Only needs to hold if the modeled occupancy lands above it. At this sensitivity, the revenue-neutral price bump is the increase that would exactly offset its own occupancy loss.
Distinct from a current-revenue report and from utility pass-through: this isolates the marginal revenue impact of the site-rate change itself, rentable sites only — a utility pass-through keeps tenant billing revenue-neutral and shows up in this model only via the rate you charge.