K12 Category 2 E-Rate Intelligence

Select a state for market intelligence, then optionally narrow to a specific applicant/BEN.

State / Territory

Applicant

↗

Choose a state or applicant

The dashboard is Category 2 only. State views are served from a persistent local snapshot cache that is refreshed in the background, while the browser remembers your last state or territory selection and automatically restores it when you return.

Dashboard Scope

Analyze loaded data by funding yearFunding/equipment data is loaded through FY2026, while Procurement includes FY2027 Form 470 filings. Changing this range filters the loaded data locally and does not query USAC again.

From FY to To FY

C2 Cycle Budget—

C2 Remaining—

Scoped C2 Committed—

Scoped C2 Disbursed—

C2 470 Filings—Selected FY scope

Budget

C2 utilization

0%utilized

Funded + pending—

Remaining—

Engagement

Strategic signals

Funding History

Requested vs. committed

Selected FY scope

Installed Base

Manufacturer share

Top 20 • click to drill down

Product Mix

Total Win by Product Type

Selected FY scope • funded C2 line-item value • click a slice to drill down

Manufacturer Mix

Total Win by Manufacturer

Selected FY scope • funded C2 line-item value • click a slice to drill down

Channel

Incumbent partners

Top 20 • spend + leading manufacturer

Products

Top observed models

Immediate Opportunities0Score 80–100

High Priority0Score 60–79

Active Next-FY 470s0Current procurement horizon

Priority C2 Remaining—Immediate + high accounts

Territory Prioritization

Opportunity Intelligence

Explainable scoring combines current procurement activity, active-cycle C2 capacity, observed installed-base age, manufacturer/partner concentration, and award recency.

Score	Applicant	Priority	Why Now	C2 Remaining	Current Discount	Refresh	Incumbent	Latest Award	Action

Refresh Priority Models0First observed ≥5 FY ago

Approaching Refresh0First observed 4 FY ago

Potential Refresh Qty0Observed quantity, where reported

Normalized Model Groups0Lifecycle groups in current scope

Lifecycle Intelligence

Observed refresh candidates

Age is based on first observed E-Rate funding year.

Product Mix

Total Win by Product Type

Current equipment filters • click a slice to drill down

Manufacturer Mix

Total Win by Manufacturer

Current equipment filters • click a slice to drill down

Installed Base Intelligence

Equipment / service line items

						Lifecycle	Qty			Purchase / Service Date			FRN	Filings	Benchmark

Procurement Activity

Recent Form 470 filings

							Filing	RFP	Workspace

Observed Procurements0Form 470 relationships in scope

Linked Awards00% relationship coverage

Observed Committed—Linked FRNs only

Top Manufacturer—Observed procurement share

Observed Awards

Manufacturer win distribution

Count of linked procurements • click a manufacturer to drill down

Observed Awards

Partner win distribution

Top 20 • click a partner to drill down

Procurement Outcome

470 → 471 → FRN award history

Only exact USAC Form 470 relationships are treated as linked awards.

FY	Applicant	470	Requested	Outcome	Manufacturer	Partner	Committed	471 / FRNs	Consultant

Current Funding Year

FRN Status

Current state/applicant scope • Category 2 only

FY															Filings

Budgetary Competitive Modeling

Build a defensible manufacturer comparison in four guided steps.

Load the applicant, map and edit both BOMs, tune pricing assumptions, then review break-even economics and customer-facing results.

Step 1

Select the applicant

Not loaded

State

Applicant

No applicant selected

Step 2

Import, map, and edit both manufacturer BOMs

Upload almost any .xlsx or .csv layout. Confirm the detected column mapping before using the data, then edit cells directly, paste ranges from Excel, or apply bulk changes to selected rows.

Scenario A

Manufacturer A

Manufacturer Name WorkbookDrop file or click to browse.xlsx or .csv Worksheet

Upload a workbook to populate line items.

	SKU	List Price / Item	Qty	E-Rate Eligibility	Mfr Discount %	Extended List	After Mfr Discount	After Markup	Eligible Final Cost

Scenario B

Manufacturer B

Manufacturer Name WorkbookDrop file or click to browse.xlsx or .csv Worksheet

Upload a workbook to populate line items.

	SKU	List Price / Item	Qty	E-Rate Eligibility	Mfr Discount %	Extended List	After Mfr Discount	After Markup	Eligible Final Cost

Step 3

Tune pricing assumptions

Changes update the comparison instantly

E-Rate Discount Rate

Set once in Step 1 so both scenarios always price against the same rate.

Scenario A

Manufacturer A

Default Manufacturer Discount

Partner Markup

Discount by SKU

Leave a SKU blank to inherit the default manufacturer discount.

SKU	Qty	Extended List	SKU Discount	After Discount

Scenario B

Manufacturer B

Default Manufacturer Discount

Partner Markup

Discount by SKU

Leave a SKU blank to inherit the default manufacturer discount.

SKU	Qty	Extended List	SKU Discount	After Discount

Load both BOMs to see live customer economics.

Step 4

Competitive outcome

Load line items for both manufacturers to compare customer economics.

Customer cost comparison

C2 budget pressure

Sensitivity & Break-Even

What price does the losing option need to win?

Scenario Default discount 0.0% Partner markup 0.0%

Audit Detail

Full financial comparison

Metric	Manufacturer A	Manufacturer B	Difference (B − A)

K12 Category 2 E-Rate Intelligence

Choose a state or applicant

C2 utilization

Strategic signals

Requested vs. committed

Manufacturer share

Total Win by Product Type

Total Win by Manufacturer

Incumbent partners

Top observed models

Opportunity Intelligenceⓘ

Historical reference

Observed purchasing profile

E-Rate historical timeline

Observed refresh candidates

Total Win by Product Type

Total Win by Manufacturer

Equipment / service line itemsⓘ

Recent Form 470 filingsⓘ

Manufacturer win distribution

Partner win distribution

470 → 471 → FRN award historyⓘ

FRN Statusⓘ

API & cache status

Multi-source data quality & provenance

Build a defensible manufacturer comparison in four guided steps.

Select the applicant

Applicant

Import, map, and edit both manufacturer BOMs

Manufacturer A

Manufacturer B

Tune pricing assumptions

Manufacturer A

Discount by SKU

Manufacturer B

Discount by SKU

Competitive outcome

Customer cost comparison

C2 budget pressure

What price does the losing option need to win?

Full financial comparison

Opportunity Intelligence

Equipment / service line items

Recent Form 470 filings

470 → 471 → FRN award history

FRN Status