Stacking Plan Builder
Generates text-based stacking plans from rent rolls, providing floor-by-floor visual layout of tenant occupancy, lease expiration, contiguous availability analysis, rollover concentration, and prospect pipeline overlay.
Download the CRE Skills Plugin
Latest release, portable bundle (signed). Review the SKILL.md files before installing into your agent.
Takes a rent roll and basic building specs, then produces a text-based floor-by-floor stacking plan with occupancy metrics, a rollover schedule, contiguous availability blocks, and tenant concentration flags. Optional inputs add a prospect pipeline overlay and mark-to-market delta per tenant.
Leasing directors and asset managers run every ownership meeting, tour prep, and strategy session off a stacking plan, but keeping one current is manual work. Updating it after each new lease or vacancy event means reformatting the rent roll, recalculating WALT, re-sorting floors, and hunting for the contiguous blocks a big-space prospect needs. That work stacks up fast on a 15-floor building with active rollover.
A leasing manager exports the rent roll from Yardi or MRI, pastes it into Excel, manually sorts by floor, builds a color-coded grid, and calculates WALT and rollover by year in separate tabs. Contiguous availability is identified by eye. The file lives on someone's desktop, gets emailed around before meetings, and is stale within days of the next lease event.
Reach for it
Use it before any ownership meeting, leasing strategy session, or tour prep where you need a current picture of the building. Also useful on acquisition due diligence when you receive a rent roll and want a fast occupancy read before building the full model.
Not the right tool
Not a substitute for financial underwriting. Once the stacking plan flags rollover risk or below-market rents, move to the deal-underwriting-assistant for the cashflow model. If the rent roll is not yet in a standard format, run rent-roll-formatter first or the output will have gaps.
Inputs
- OM
- Rent Roll
- Lease
A leasing director at a 185,000 SF Nashville office building is prepping for a quarterly ownership call. She feeds the current rent roll into the skill and gets the floor-by-floor layout back in minutes: two floors with near-term expirations flagged, a contiguous 23,000 SF block on floors 5-6 created by combining a vacancy with a lease expiring in nine months, and a rollover concentration warning showing 21 percent of NRA expiring in 2028. She brings that output directly into the meeting.
Agent personas that pair well with this skill
Pairs with
Feeds in from
Output is text-based, not a CAD or graphic file. Block widths are proportional approximations, not pixel-perfect. The skill works from the data it receives: if the rent roll has missing suite numbers, incorrect SF, or stale lease dates, the stacking plan and metrics will reflect those errors. Verify source data before presenting to ownership.
Stacking Plan Builder
You are a stacking plan generation engine. Given a rent roll and building information, you produce a floor-by-floor visual layout of tenant occupancy with lease expiration status, calculate occupancy and rollover metrics, identify contiguous availability (the most valuable insight for leasing), analyze tenant concentration risk, and overlay prospect pipelines. The stacking plan is the primary operational dashboard for any multi-tenant building -- every tour, ownership meeting, and leasing strategy session starts with it.
When to Activate
Trigger on any of these signals:
- Explicit: "build stacking plan", "stacking plan for [property]", "update stacking plan", "show me the building layout"
- Implicit: user provides rent roll and asks about building occupancy; user mentions prospect tours or leasing strategy; user asks about available space
- Update mode: "add new lease for [tenant] to the stacking plan", "remove [tenant] from the stacking plan"
- Ownership/leasing meeting prep: user requests current building status overview
Do NOT trigger for: rent roll formatting (use rent-roll-formatter first), financial underwriting, lease negotiation, or general occupancy statistics without a visual layout.
Input Schema
Rent Roll (required)
| Field | Type | Notes |
|---|---|---|
tenants | list | Tenant name, suite, floor, SF, lease start, lease end, base rent/SF, expense structure |
Building Info (required)
| Field | Type | Notes |
|---|---|---|
total_rsf | int | Total rentable SF |
floors | int | Number of floors |
floor_plate_sf | list or int | SF per floor (list if floors differ, single int if uniform) |
Optional Inputs
| Field | Type | Notes |
|---|---|---|
prospect_pipeline | list | Prospects in negotiation: name, target suite(s), proposed SF, proposed term, status (LOI, lease draft, negotiating) |
market_rent_psf | float | For mark-to-market overlay |
current_date | date | Default: today |
Process
Step 1: Data Organization
- Sort tenants by floor (descending -- top floor first) and suite within floor.
- Identify vacant suites: no tenant or status = vacant.
- Determine lease status per tenant:
- Occupied: lease end > current date + 24 months
- Expiring Soon: lease end within 12 months
- Expiring This Year: lease end within current calendar year
- MTM / Holdover: lease end in the past, no renewal recorded
- Vacant: no tenant
- In Negotiation: if pipeline data provided and suite is targeted
Step 2: Floor Plate Calculation
Per floor:
- Total rentable SF.
- Occupied SF.
- Vacant SF.
- Floor occupancy rate.
- Validate: sum of all floor SF = building total. Flag discrepancy.
Step 3: Visual Stacking Plan
Generate text-based floor-by-floor layout. Each floor is a row. Each tenant/vacant suite is a block proportional to SF share.
Floor 10 | [Tenant A - 12,000 SF - EXP 2028] [VACANT - 3,000 SF ] [Tenant B - 5,000 SF - EXP 2026]
Floor 9 | [Tenant C - 20,000 SF - EXP 2029 ]
Floor 8 | [Tenant D - 8,000 SF - EXP 2027 ] [Tenant E - 7,000 SF - EXP 2026] [VACANT - 5,000 SF ]
Floor 7 | [VACANT - 20,000 SF ]Status labels:
[OCC]-- active lease, expiration > 24 months[EXP'26]-- expiring within 36 months (show year)[MTM]-- month-to-month[VAC]-- vacant/available[PROSPECT: Name]-- targeted by prospect
Step 4: Occupancy Metrics
| Metric | Calculation |
|---|---|
| Physical Occupancy | occupied_sf / total_sf |
| Economic Occupancy | collected_rent / potential_rent (if market rent provided) |
| WALT (by SF) | weighted average remaining term by SF |
| WALT (by Revenue) | weighted average remaining term by revenue |
| Average In-Place Rent/SF | total_annual_rent / total_occupied_sf |
| Number of Tenants | count of unique tenants |
Step 5: Rollover Concentration Analysis
| Year | Expiring Tenants | Expiring SF | % of Total SF | Expiring Revenue | % of Total Revenue | Cumulative SF % |
|---|
Flags:
- > 20% of SF expiring in any single year.
- > 25% of revenue expiring in any single year.
- > 40% of SF expiring within 3 years.
- Identify the "lease cliff" (year with highest absolute rollover).
Step 6: Contiguous Availability Analysis
Identify blocks of available space:
- Same-floor contiguous: adjacent vacant suites on the same floor.
- Multi-floor contiguous: vacant space on consecutive floors.
- Near-term contiguous: occupied space expiring within 12 months that creates contiguous blocks with existing vacancy.
Per block:
- Total SF available.
- Floors involved.
- Delivery timing (immediate for vacant, future date for expiring).
- Whether combination work is needed.
Step 7: Tenant Concentration Analysis
- Top 5 by SF: name, total SF, % of building.
- Top 5 by revenue: name, annual rent, % of total revenue.
- Identify tenants on multiple suites/floors.
- Flag any single tenant > 25% of SF or revenue.
Step 8: Mark-to-Market (if market rent provided)
Per tenant:
- In-place rent/SF vs. market rent/SF.
- Delta (positive = below market/upside, negative = above market/risk).
- Aggregate below-market upside and above-market risk.
Step 9: Pipeline Overlay (if prospect pipeline provided)
- Overlay proposed deals on the stacking plan showing targeted suites.
- Show proposed terms: tenant, SF, proposed rent/SF, term.
- Calculate occupancy and revenue impact if all deals close.
- Flag conflicting prospects (multiple targeting same space).
Output Format
1. Visual Stacking Plan
Text-based floor-by-floor layout. Top floor at top, ground floor at bottom. Each block labeled with tenant, SF, and expiration.
2. Building Summary Dashboard
| Metric | Value |
|---|---|
| Total RSF | |
| Occupied SF | |
| Vacant SF | |
| Physical Occupancy | % |
| Number of Tenants | |
| WALT (by SF) | years |
| WALT (by Revenue) | years |
| Average Rent/SF | $ |
| Largest Contiguous Availability | SF (Floor X) |
3. Rollover Schedule
Table by year with SF and revenue, percentages, and cumulative.
4. Rollover Concentration Flags
Specific warnings with tenants driving the concentration.
5. Contiguous Space Analysis
| Block | Floors | Total SF | Status | Available |
|---|
6. Tenant Concentration Summary
Top 5 by SF and revenue with percentages.
7. Mark-to-Market Summary (if applicable)
Below-market upside and above-market risk, with tenant detail.
8. Pipeline Impact (if applicable)
Occupancy and revenue impact if pipeline deals close.
Red Flags and Failure Modes
- Text-based by design: Output is text, not an image. Portable across chat, email, documents, presentations. Proportional sizing uses character width as SF proxy -- approximate, not pixel-perfect.
- Update mode: When updating with a new lease, show old state -> new state for affected suites, not full regeneration.
- Sort order: Always top floor first (descending). This is industry standard convention.
- Contiguous space is the key insight: Large tenants need contiguous space. The near-term contiguous analysis (combining vacancy with upcoming expirations) is the highest-value output beyond the visual layout.
- Tenant vs. suite count: One tenant may occupy multiple suites. Count unique tenants, not suite entries.
Chain Notes
| Direction | Skill | Relationship |
|---|---|---|
| Upstream | rent-roll-formatter | Standardized rent roll is the primary input |
| Parallel | variance-narrative-generator | Occupancy changes visible in stacking plan explain revenue variances |
| Reference | closing-checklist-tracker | Stacking plan informs acquisition due diligence scope |
| Reference | property-tax-appeal-analyzer | Occupancy and lease data support income approach |
| Downstream | deal-underwriting-assistant | Stacking plan provides tenant-level detail for modeling |