FPME State of the Program — Leadership Review PrototypeAll displayed names and numbers are illustrative.
FPME · Power BI concept

Monthly State of the Program

A command conversation that moves from the current picture to upcoming movement, fiscal execution, command decisions, and the supporting program record.

1. Program Overview

The opening page gives the boss the monthly state in one minute: current lifecycle status, immediate movement, active requirements, and command focus.

Current month
Selected
12
Preparing for language or course execution
Language Training
7
At three current locations
Course Execution
18
Attending six programs
Cancelled
2
Closed records retained for program history

Command assessment

Overall: Program execution is steady. Two students transition from language training to course execution within 45 days. Fiscal execution stands at $928K obligated year-to-date against the $1.48M annual submitted budget.

Purpose: this short, human-written assessment connects the data to the command picture.

Next 60 days

DateExpected movementImmediate action
14 SepStudent 04 begins language trainingConfirm travel and reporting instructions
03 OctStudent 11 begins course executionComplete two open requirements
21 OctStudent 07 begins course executionResolve clearance verification

Command focus

Decision Confirm alternate report date for Student 07.

Coordination Gain host-school response for Student 15.

Awareness Three students change locations next month.

FITREP Two reports are due within 30 days; the earliest is due 15 Sep.

Fiscal $552K remains available; $120K in expected obligations supports the forecast.

Annual context: seat selection occurs annually, and the submitted budget establishes the fiscal plan. Monthly reporting shows program execution and obligations.

Lifecycle used across every page

SelectedLanguage TrainingCourse ExecutionCancelledAlumni

Each person carries one current lifecycle status. Alumni data enters the report during the future-expansion phase.

Annual submitted budget
$1.48M
Submitted for the current fiscal year
Obligated FYTD
$928K
63% of the submitted budget
Remaining balance
$552K
Available against the annual plan
Expected obligations
$120K
Forecast through 30 September

2. Current Population

WHO and WHERE form one operating picture. The roster shows selected and current students, their lifecycle status, their current location, and their next expected transition.

Who · where

Current roster

PersonProgramCurrent statusCurrent locationNext transitionRequirements
Example Fellowship ASelectedParent CommandLanguage Training · 14 Sep2 open
Example Program BLanguage TrainingArlington, VACourse Execution · 21 Oct1 blocked
Example Program CLanguage TrainingMonterey, CACourse Execution · 03 Oct2 open
Example Program DCourse ExecutionLondon, UKCompletion · 15 JunOn track
Example Program ECancelledParent CommandRecord closeoutClosed

Person detail

Choose a student name

Power BI drill-through opens the selected person’s complete record here: current place, dates, assigned program, requirements, and active issues.

Current locations

⌖
Parent Commands
Selected and cancelled personnel
14
⌖
Monterey, CA
Language Training
4
⌖
Arlington, VA
Language Training
2
⌖
Overseas Schools
Course Execution
18

Status distribution

Selected 12

Language Training 7

Course Execution 18

Cancelled 2

Upcoming FITREP Due Dates

Person-linked reporting dates are sorted by due date. Near-term reports receive the strongest visual priority.

Fictional examples
Due within 30 days
2
Earliest due 15 Sep
Due within 60 days
4
Cumulative through 31 Oct
Due within 90 days
5
Cumulative through 30 Nov
MarineReporting occasionDue dateDays remainingCurrent status
Example Marine 01Annual15 Sep 202613RO Action
Example Marine 02Transfer30 Sep 202628Draft Review
Example Marine 03Annual15 Oct 202643Input Received
Example Marine 04Change of Reporting Senior31 Oct 202659Drafting
Example Marine 05Annual30 Nov 202689Scheduled
Example Marine 06End of Service15 Dec 2026104Future

Due-within counts are cumulative and use the report date of 02 September 2026.

3. Upcoming Movement

This page looks forward across a selected date horizon. It shows expected arrivals, departures, location changes, and movement between lifecycle statuses.

What changes next
DatePersonMovementFromToStaff focus
14 SepStudent 04Arrival / status changeParent Command · Selected→Monterey · Language TrainingTravel and reporting
03 OctStudent 11Location / status changeMonterey · Language Training→Overseas School · Course ExecutionClose two requirements
21 OctStudent 07Location / status changeArlington · Language Training→Overseas School · Course ExecutionClearance verification
18 NovStudent 03Departure / status changeMonterey · Language Training→Overseas School · Course ExecutionFinalize reporting package
30-day moves
1
One arrival into Language Training
60-day moves
3
Two begin Course Execution
90-day moves
4
Four total transitions

4. Fiscal

The office coordinates funding for designated course tuition, training tuition, TDY, and housing. The budget is submitted annually, and obligations are tracked monthly across the fiscal year from 01 October through 30 September.

Resources · execution
Annual submitted budget
$1.48M
Sum of the Oct–Sep monthly budget plan
Spent this month
$102K
September obligations to date
Spent FYTD
$928K
October through September-to-date
Remaining balance
$552K
Annual budget less FYTD spending

Monthly Budgeted vs Spent · Oct–Sep

BudgetedSpent
Oct$80K / $55K
Nov$85K / $61K
Dec$75K / $48K
Jan$100K / $72K
Feb$95K / $64K
Mar$110K / $81K
Apr$115K / $90K
May$125K / $104K
Jun$135K / $92K
Jul$135K / $86K
Aug$140K / $73K
Sep$285K / $102K

Each month pairs the approved budget plan with recorded spending. Labels show Budgeted / Spent. Monthly budget values total $1.48M; monthly spending values total $928K fiscal-year-to-date.

Forecast

Expected future obligations
$120K
Final fiscal-year actions
Projected year-end spending$1.048M
Projected year-end balance$432K
Command use: the forecast shows how recorded spending and expected obligations fit within the submitted annual budget.

September Budgeted vs Spent by category

BudgetedSpent
Course Tuition
Budgeted · $120KSpent · $44K
Training Tuition
Budgeted · $25KSpent · $8K
TDY
Budgeted · $80KSpent · $31K
Housing
Budgeted · $60KSpent · $19K

September category budgets total $285K, and September spending totals $102K.

Course tuition applicability

Course tuition applies to designated programs. Each funding record carries a clear indicator.

ProgramIndicatorFiscal treatment
Example Fellowship ATuition AppliesProgram office coordinates payment
Example Program BTuition CoveredPartner agreement covers course tuition
Example Program CTuition AppliesProgram office coordinates payment

Funding records tied to execution

RecordPerson / programCategoryCourse tuitionExpectedSpentPlanned monthStatus
FND-104Student 04 · Fellowship ATraining TuitionApplies to course$18K$18KSepSpent
FND-107Student 07 · Program BTDYCourse covered$24K$16KSep–OctPartial
FND-111Student 11 · Program CCourse TuitionApplies$72K$72KAugSpent
FND-115Student 15 · Program DHousingCourse covered$36K$27KJul–SepExecuting

One person or program may carry several funding records across tuition, TDY, and housing.

5. Issues & Decisions

This page translates considerations into leadership relevance: what needs awareness, coordination, or a command decision.

Command attention
Command decision

Alternate report date

Needed by 12 Sep

Student 07’s clearance timing affects the planned report date.

Ask: approve the proposed alternate date.
Coordination

Host-school response

Needed by 18 Sep

Country Team coordination remains active for Student 15.

Ask: support elevation if the response remains pending at suspense.
Awareness

October movement

Next month

Three students change locations and two enter Course Execution.

Command use: maintain awareness of workload and transition risk.

Attention summary

Command decisions
1
Coordination items
2
Awareness items
3
Entry standard: every item states its effect, owner, timing, and command use.

6. Program Record

The program record holds the person and program detail behind the monthly picture. The annual Quota Plan and TEEP provide seat-selection and execution context.

Authoritative detail

Person record

FieldExample
Person IDSTU-011
ProgramExample Program C
Current statusLanguage Training
Current locationMonterey, CA
Course dates03 Oct – 15 Jun
Parent commandExample Command

Program record

FieldExample
Program IDPRG-C
School / countryExample School / Partner Nation
Education levelIntermediate
Annual seat contextFY27 seat selected
Execution windowOct – Jun
Program ownerFPME Office

Funding record

Funding IDPersonProgramCategoryCourse tuition indicatorExpected amountObligated amountFiscal month
FND-111STU-011PRG-CCourse TuitionApplies$72K$72KAug

Funding IDs connect obligations to the relevant person, course, program, and fiscal category.

Annual TEEP context

Person
Sep
Oct
Nov
Dec
Jan
Feb
Student 04
Selected
Language
Language
Language
Course
Course
Student 11
Language
Course
Course
Course
Course
Course

The TEEP supports annual seat planning, transition forecasting, and program continuity. Requirements remain independent and may be completed in any order.

7. How the Data Works

Think of the architecture as labeled filing cabinets that feed a monthly briefing. Staff maintain familiar lists; Power BI cleans, connects, counts, and displays them.

Plain English

From staff update to command report

1. Source listsPeople, programs, locations, funding records, FITREP due dates, issues, and annual seat context.
2. Power QueryStandardizes names, dates, blanks, and status values during refresh.
3. Data modelLinks matching IDs across the tables, like labeled folders.
4. MeasuresCreates reusable counts for lifecycle, movement, obligations, forecasts, and issues.
5. Report pagesPresents the command conversation in the sequence shown above.

Core tables

People
  • Person ID
  • Program ID
  • Current lifecycle status
  • Current location ID
  • Next transition date
Programs & Annual Seats
  • Program ID
  • School and country
  • Annual seat selection
  • Course dates
Locations
  • Location ID
  • Place name
  • Country and region
  • Location type
Funding Records
  • Funding ID
  • Person and Program IDs
  • Fiscal category
  • Expected and obligated amounts
  • Fiscal month
  • Course tuition indicator
Issues & Decisions
  • Issue ID
  • Person or program link
  • Attention type
  • Command ask
Monthly Snapshots
  • Snapshot month
  • Person ID
  • Status and location then
  • Monthly and FYTD obligations then
FITREP Due Dates
  • FITREP record ID
  • Person ID
  • Reporting occasion
  • Due date
  • Current status

Simple relationships

One Person or Program → many Funding Records

One Person → many FITREP Records

One Location → many People

One Program → many People

One Person or Program → many Issues

Monthly refresh workflow

1

Staff update the source lists.

2

Staff validate statuses, dates, IDs, FITREP reporting occasions, funding categories, expected amounts, and obligations.

3

Power BI refreshes the model and report pages.

4

The program office adds the command assessment.

5

A month-end snapshot preserves the historical picture.

8. Future Expansion

The current report includes the operational picture and Fiscal. Two deliberate additions extend the program view: Training and Alumni.

Next phases
Training

Preparation and readiness

  • Preparatory training requirements
  • Completion status and dates
  • Owners, suspenses, and blockers
  • Readiness for the next transition

Command value: shows preparation for successful execution and identifies actions that support the next transition.

Alumni

Long-term program record

  • Completion history
  • Follow-on utilization
  • Contact and assignment history
  • Program outcomes over time

Command value: shows enduring return from the program and supports future selection decisions.

Recommended growth order: sustain trusted People, Location, Fiscal, Issues, and Program records; preserve monthly snapshots; add Training and Alumni when their source data and owners are ready.

9. Review & Refine

This prototype is ready for leadership review. Your comments will help Taylor refine the report’s priorities, level of detail, and monthly command value.

Leadership feedback

How to review

Move through each report tab, then capture concise feedback below. Notes stay in this browser session. Copy your review notes and send them to Taylor.

Enter comments above, then copy the labeled notes.