Sample Solutions Library

25 BPA-Call-ready solution scenarios

Real operational problems facing USDA Rural Development's Office of Budget and Policy — each paired with the HSG team lead, specific approach, deliverables, and expected outcome. Click any scenario to see the full solution.

Filter:

Showing 25 of 25 scenarios

01Data Review/ValidationAccounting

ULO Certification Triage Backlog

RD's semi-annual and quarterly Unliquidated Obligation (ULO) Certification cycle requires field staff and program offices to attest to the validity of every open obligation across a $224B portfolio, but staffing constraints and inconsistent field response rates have left invalid obligations on the books long past the deobligation trigger — driving the $315M+ OIG-projected misstatement in the FY 2023 audit and a repeat continuous-monitoring deficiency in FY 2025.

Read solution PDF
02Data Review/ValidationAccounting

Funds-Control to Loan-System Reconciliation Gap

RD operates multiple legacy loan systems (PLAS, DLS, CLSS, GLS, LoanServ, AMAS, ECMS) that feed obligation, disbursement, and balance data into FMMI funds-control records and Treasury reporting, and reconciliation gaps between loan-of-record and funds-control-of-record drive both the OIG ULO finding and recurring monthly closeout exceptions.

Read solution PDF
03Process AutomationCredit Reform Act

Annual Subsidy Re-estimate Cycle Compression

Per OMB Circular A-11 §185, re-estimates must be made immediately after each fiscal year for every cohort with outstanding loans, and RD's 750+ cohort models from FY 1992 forward make this cycle mechanically intensive — pulling actuals, refreshing default/prepay/recovery curves, running OMB CSC, reconciling to BICS pivots, and assembling re-estimate memoranda.

Read solution PDF
04Data AnalysisCredit Reform Act

Modification Subsidy Cost Analysis for Mass Workouts and Refis

Legislative, regulatory, or contractual changes to RD credit programs — e.g., the March 2026 B&I Guarantee bump from 80% to 85% for sub-$5M loans, the September 2024 Section 502 Guaranteed seven-year credit-reestablishment proposed rule, and the March 2026 LITE Delegated Authority Pilot — each require an FCRA modification subsidy cost calculation flowing through OMB CSC, the financing accounts, the apportionment chain, and the OMB Credit Supplement.

Read solution PDF
05Data AnalysisCredit Reform Act

Cohort Cash-Flow Model Maintenance Across 750+ Models

RD-FO maintains cohort accounting for every program × every cohort year from FY 1992 forward — approximately 750+ cohort models touched annually — and each model requires actuals refresh, curve recalibration, narrative assumption documentation, and audit-trail continuity. With staff contraction, the per-model time budget is shrinking faster than the cohort population.

Read solution PDF
06Data AnalysisCredit Reform Act

Loan Asset Sale and Prepayment Program Subsidy Effects

When RD considers (or executes) loan asset sales, prepayment programs, or portfolio dispositions to GSEs or private investors, the FCRA subsidy estimate must include the effects of those sales — but RD does not have an established asset-sale subsidy methodology, despite OMB A-129 explicitly requiring one when sales are programmatic.

Read solution PDF
07Data Review/ValidationCredit Reform Act

Statistical Model Validation Under A-11 §185

OMB A-11 §185 requires statistical models to be predictive of defaults and other deviations and to consider general market conditions, population shifts, and climate change, but RD's program models — covering RHS, RBCS, RUS portfolios across 750+ cohorts — face a model validation backlog that grows as climate and macroeconomic conditions shift faster than RD's annual model refresh cycle.

Read solution PDF
08Data Review/ValidationAccounting

DATA Act and FFATA Submission Validation Failure Loop

RD-FO submits monthly and quarterly financial assistance and procurement data into the USDA NFC-managed DATA Act pipeline feeding USAspending.gov, and File-level validation errors and warnings (FABS and DAIMS) require resubmission cycles consuming scarce OBP, NFAOC, and program-office time.

Read solution PDF
09Process ImprovementBudget Formulation

Agency-to-Department-to-President's-Budget Workflow Gaps

RD's annual Budget Formulation cycle moves Agency Estimates through Department Estimates (USDA OBPA, under Director Rapp and Deputy Director for Budget Formulation Barrack) to the President's Budget submission to OMB, and the handoffs are friction-laden — driving cycle-time pressure into the credit subsidy estimate, MAX schedule load, and OMB CSR.

Read solution PDF
10Report GenerationBudget Formulation

Program Account Justification Drafting at Scale

Each RD program account — Section 502 Direct, 502 Guaranteed, 504, 515, 521, 538, B&I Guaranteed, REAP, IRP, REDLG, RBDG, WWD, CF, ReConnect, Electric, Telecom, and others — requires a Congressional Justification narrative, an OMB MAX submission narrative, and supporting trend / volume / subsidy-rate exhibits, and the volume across RHS / RBCS / RUS routinely overwhelms OBP's drafting capacity in compressed cycles.

Read solution PDF
11Process ImprovementBudget Execution

Apportionment Chain Documentation and Cycle Time

RD's apportionment chain — Congressional Appropriation → Treasury Warrant → OMB Apportionment (SF-132) → OBPA Allotment → RD / USEC sub-allotment → obligation → outlay → SF-133 reporting — runs through MAX and FMMI and requires NETs (SF-1151) and RC502 funds-control reporting, with cycle-time pressure increasing whenever a CR, supplemental, or apportionment update arrives mid-year.

Read solution PDF
12Data Review/ValidationAccounting

A-123 Internal Controls and Year-End Accruals Audit Readiness

OMB Circular A-123 requires RD to maintain a documented internal-control posture for financial reporting, and year-end accrual entries (interest on borrowings from Treasury, financing-account interest, undelivered orders, accrued grants, accrued payroll) drive material AFR positions auditors examine in detail — but accrual documentation is uneven across program offices and NFAOC.

Read solution PDF
13Data AnalysisBudget Execution

Burn Rate, Operating Plan, and FTE Forecasting for the 32% Workforce Cut

RD's FY 2026 budget cuts FTE from 4,630 to 3,162 — a 32% workforce contraction — and OBP must produce credible Burn Rate, Operating Plan, and FTE-and-payroll forecasts for the Acting Under Secretary, COO, HR, and OMB while operations are being restructured underneath the forecast.

Read solution PDF
14Data Review/ValidationAccounting

Cross-System Reconciliation Between RD Loan Systems and Treasury

RD must reconcile transactions across PLAS, DLS, CLSS, GLS, LoanServ, AMAS, ECMS, FMMI, NFC, and Treasury systems (CARS, GTAS, ASAP, G-Invoicing, IPAC, Fund Balance with Treasury) every month, and timing differences, transposition errors, mis-coded TAS, and pending Treasury settlements drive a stream of reconciling items.

Read solution PDF
15Data AnalysisBudget Execution

Anomaly Detection at the $40M / 5% Abnormal Activity Threshold

RD-FO must surveil for abnormal activity at a $40M absolute or 5% relative threshold across program obligations, outlays, and subsidy actuals, and the manual nature of threshold monitoring means anomalies are often surfaced after the fact rather than as they emerge.

Read solution PDF
16Data AnalysisCredit Reform Act

Trend Analysis and 5-Percentage-Point Subsidy-Rate Variance Justification

When a program subsidy rate moves by 5 percentage points or more year-over-year — for example RBCS Intermediary Relending Program (IRP) which jumped from 17.54% (FY22) to 30.35% (FY24) — RD-FO must produce trend-analysis-and-justification material for OMB, OBPA, the AFR, and the Hill, but assembling the supporting narrative is labor-intensive and the volume across the portfolio is significant.

Read solution PDF
17Process ImprovementBudget Execution

Process Re-engineering Across the 32% FTE Cut

RD's announced 32% FTE contraction (4,630 → 3,162) means OBP and NFAOC must continue delivering all current obligations on the credit-reform, accounting, and budget-execution work plan with two-thirds of the prior-year staffing — and without process re-engineering, work-quality regression and burnout are inevitable.

Read solution PDF
18Process AutomationBudget Execution

Dashboard, Tableau, and Rural Data Gateway Integration

RD's Rural Data Gateway publishes 12+ years of program data across 70+ programs through 20+ dashboards, and RD operates a USDA-wide Tableau catalog ($5M / 3-year contract), but financial-management dashboards across OBP, NFAOC, and program offices remain fragmented — leading to inconsistent leadership decision-support data.

Read solution PDF
19Process ImprovementAccounting

OIG and Audit Response Tracking and Remediation

RD must track open OIG findings (the FY 2023 $315M ULO finding, the FY 2025 repeat continuous-monitoring finding, FY 2025 undocumented-grant finding) and GAO recommendations through closure, but remediation tracking is fragmented across program offices, NFAOC, and OBP — leaving RD vulnerable to repeat findings and slow closure cycles.

Read solution PDF
20Process AutomationAccounting

USDA Loan Modernization Migration Support (130+ Systems)

USDA's March 17, 2026 announcement of the unified loan-platform consolidation will collapse 130+ FSA + RD loan / grant systems onto a single platform with AI / automation, and the migration will require RD-FO to reconcile cohort balances, financing-account positions, ULO status, and audit-trail continuity across the cutover — without breaking the OMB CSC / BICS / Essbase / Treasury reporting envelope.

Read solution PDF
21Report GenerationBudget Formulation

OMB MAX Schedule Submission and Credit Supplement Report Exercise

RD-FO must submit budget data into OMB MAX at the budget account level, with separate Schedule X submissions for credit subsidy cost data that flows through the OMB Credit Supplement Report Exercise (CSR), and the manual nature of MAX schedule construction and the iterative back-and-forth on the CSR consumes substantial OBP analyst time.

Read solution PDF
22Process AutomationCredit Reform Act

AI / Automation Workflow Stack (OMB M-25-21 / M-25-22 Compliance)

RD-FO has identified — and OMB M-25-21 / M-25-22 mandate — that AI / automation should accelerate input preparation, anomaly flagging, certification-sheet generation, and similar mechanical work across the credit-reform, accounting, and budget-execution workstreams, but RD does not yet have an AI workflow stack that meets federal AI governance requirements.

Read solution PDF
23Data Review/ValidationAccounting

Legacy System Data Migration and Data Quality

RD's legacy mainframe systems (PLAS, DLS, CLSS, GLS, LoanServ, AMAS, ECMS) carry decades of data with inconsistent field definitions, partial documentation, and aging extraction interfaces, and any cohort, modification, or audit work depends on extracts that must be rationalized before they are usable.

Read solution PDF
24Report GenerationBudget Execution

External Inquiry Response (Congress, GAO, OMB, OIG)

OBP routinely receives ad-hoc data calls from House and Senate appropriations subcommittees, GAO audit teams, OMB exam staff, and OIG audit teams covering RD program data, subsidy execution, beneficiary distribution, geographic profile, and policy questions, and turning these around in compressed deadlines pulls senior analyst time off the critical path.

Read solution PDF
25Report GenerationCredit Reform Act

Multi-Program Portfolio Risk Reporting

RD's $224B portfolio spans RHS, RBCS, and RUS with materially different risk profiles per program (Section 502 Direct subsidy 45.76%; 502 Guaranteed at 90% guarantee; B&I Guaranteed FY24 blended subsidy 2.38%; IRP 30.35%; Water & Waste Disposal Direct 8.35%) and OBP must produce portfolio-level risk reporting for the Acting Under Secretary, OMB, and the AFR — but cross-program risk aggregation today is largely manual.

Read solution PDF