Site-Level Profitability Modeler

Park Configuration

This tool builds a per-site P&L — distinct from tracking whole-park occupancy revenue or metering utility-recovery economics. Each site's own revenue and its own costs are modelled line by line on a monthly basis.

• Month length — the billing period every per-site figure is reported against (typically 30 days).
• Allocation basis — how shared amenity and property/overhead pools are divided across sites (equal per site, by site occupancy, or by site revenue).

Revenue Sources

Each site generates revenue from multiple sources. The base site fee is the site's monthly rental/site charge. Additional streams (electric, water, amenity fees, store, misc) capture ancillary income tied to that site.

• Site fee — the primary rental charge per month.
• Additional — metered power, water, recreation/amenity fees, camp-store spend, and any other income.
• Utilities-as-revenue here reflects what you charge the occupant, not your cost to supply it.

Site-Specific Costs

Costs that are attributable to operating a single site: the utilities actually consumed, routine maintenance on that site's pad/hookups, and the site's portion of shared amenity and property/overhead pools.

• Utilities — metered or estimated power/water/sewer consumed on the site.
• Maintenance — servicing the site's pad, power/water hookups, and fixtures.
• Shared cost pools are allocated below via the chosen basis.

Shared Cost Allocation

The amenity pool (pools, laundry, rec hall, wifi, grounds lighting) and the property/overhead pool (taxes, insurance, admin, common-area utilities) are not traceable to one site, so they are split across sites.

• Equal — each site gets an identical share of the pool.
• By occupancy — sites with more occupied nights absorb more of the pool.
• By revenue — higher-revenue sites carry a larger share.

Weights are entered per site in the site table (occupancy days or revenue). Choose the basis that best mirrors how the cost is actually driven.

Profit & Ranking

Every site is scored on net profit per month and margin percent, then ranked best to worst.

• Profit — net dollars the site contributes per month after its allocated costs.
• Margin — profit as a share of revenue (a profitability %).
• The bar at the top shows the mix of profitable vs breakeven vs losing sites.