Community Solar Subscriber Allocation Balancer

Introduction

Community solar projects usually look simple from the outside: build an array, sign subscribers, and pass bill credits through to customers. In practice, the hard part is deciding who gets how much of the project. A large anchor tenant can stabilize revenue but reduce room for households. A low-income carveout can advance program goals but changes how much energy remains for general participants. Household subscription limits, credit rates, and administration costs then decide whether the final offer still feels worthwhile to the people you want to enroll. This calculator focuses on that planning problem. It turns the physical size of the array and a few policy assumptions into a fast estimate of subscriber capacity, customer savings, and leftover energy buffer.

The tool is useful for developers, municipalities, subscriber managers, utilities, housing groups, and community organizations that need a quick scenario screen before they move into detailed contracting. It does not replace tariff review or a full financial model. Instead, it gives you a readable first-pass answer to a practical question: if you reserve part of the project for an anchor tenant and protect a low-income share, how many households can you serve and what does that likely mean for subscriber savings?

How to use

Start with the physical project inputs. Project size and expected capacity factor estimate how much electricity the array produces on average. Then enter the anchor tenant reservation, which is treated as capacity that is spoken for before residential allocations begin. Next, set the low-income carveout as a percentage of the remaining energy after the anchor share is removed. Those three numbers define the broad structure of the subscriber mix.

After that, describe a typical household subscription. Average household usage tells the calculator what a normal participant consumes each month. The maximum subscription coverage sets the fraction of that usage you are willing or allowed to offset with community solar. Financial fields translate that energy block into subscriber value: the bill credit rate, the share of the credit passed through to participants, the monthly administration cost per subscriber, and any one-time enrollment fee. The tool updates live while you type, so you can test tradeoffs quickly.

• Use project size and capacity factor to estimate monthly generation.
• Use anchor tenant reserved capacity to remove a stable commercial or institutional share first.
• Use the low-income carveout to protect equity goals inside the remaining residential pool.
• Use household usage and subscription coverage to size each subscriber block realistically.
• Use the cost and credit fields to see whether participant savings still look meaningful after overhead.

If the household count looks lower than expected, the usual causes are straightforward: the anchor block is large, the low-income carveout is ambitious, household usage is high, or the subscription cap is generous enough that each participant absorbs a lot of energy. That is not necessarily a bad result. Sometimes a program with fewer subscribers is intentionally built around deeper savings, stronger compliance, or a more secure anchor contract. The calculator helps you see those tradeoffs early instead of discovering them after outreach begins.

Formula

The core production estimate starts with nameplate size and capacity factor. In plain language, capacity factor converts a project that can produce at full output only part of the time into an annual energy estimate. The first relationship is annual energy:

Here, E is annual energy in kilowatt-hours per year, P is project size in kilowatts, CF is capacity factor as a decimal, and H is annual hours, typically 8,760. Because subscription planning is usually discussed in monthly bill terms, the calculator converts that annual value into an average monthly production estimate. The page preserves the monthly formula below exactly because it is the shortcut many community solar teams use when they sketch a project on a whiteboard:

From there, the logic is sequential. Anchor tenant energy is estimated with the same capacity factor and removed from the total. The low-income carveout is then applied to the energy that remains after the anchor reservation. What is left becomes the general residential pool. Each household is assumed to take a subscription block equal to average monthly usage multiplied by the maximum subscription coverage percentage. If a household uses 600 kWh per month and the program caps subscriptions at 90 percent of usage, the model treats the standard subscription block as 540 kWh per month. Dividing each energy bucket by that block gives an approximate household count.

The financial side is simpler but still useful. The bill credit value of a subscriber block equals block size times the bill credit rate. The participant share of that value equals the bill credit multiplied by the pass-through percentage. Net monthly savings then subtract the per-subscriber administration cost. The calculator also estimates how many months it takes for those savings to recover any enrollment fee. Finally, it applies the annual degradation rate to approximate year-10 monthly production so you can see whether today's allocation still looks reasonable after several years of panel aging.

Example

Suppose you are evaluating a 1,500 kWdc community solar project with an 18 percent capacity factor. A school district acts as the anchor tenant and reserves 300 kWdc. Program rules or mission goals require 25 percent of the remaining energy to be reserved for low-income households. Typical residential customers in the service area use 600 kWh per month, and subscriptions are capped at 90 percent of usage. Bill credits are valued at $0.11 per kWh, 85 percent of that credit is passed through to participants, administration costs are $3.50 per subscriber per month, the enrollment fee is $50, and annual degradation is assumed to be 0.5 percent.

Under those assumptions, the project produces about 197,100 kWh per month on average. The anchor tenant uses about 39,420 kWh per month, leaving roughly 157,680 kWh. The low-income carveout reserves about 39,420 kWh, leaving about 118,260 kWh for standard residential subscribers. With a 540 kWh monthly subscription block, that supports about 73 low-income households and 219 general households. Each subscriber block creates about $59.40 in bill credits per month, of which about $50.49 is passed through. After subtracting the $3.50 administration cost, the participant keeps about $46.99 per month, so the $50 enrollment fee is recovered in a little over one month. That is exactly the kind of scenario comparison this calculator is built to support.

Limitations

This is an average-month planning model, not a full operating simulation. It assumes a stable capacity factor instead of seasonal or hourly production. It also treats all residential subscribers as though they have the same usage and the same subscription cap. Real programs usually have a mix of apartment residents, single-family households, small businesses, and customers whose usage changes through the year. If you have interval data or tariff-specific rules, you should treat this page as a first screen and then move into a more detailed model.

The financial outputs are intentionally high level. The calculator uses one bill credit rate, one pass-through rate, and one average administration cost per subscriber. It does not account for customer acquisition expenses that change by segment, different servicing costs for low-income participants, tax incentives, reserve requirements, debt terms, or state-specific subscriber eligibility rules. It also assumes the anchor tenant can fully absorb the reserved share. Those simplifications are acceptable for fast planning, but they are precisely why the result should be read as directional guidance rather than a binding offer or compliance determination.