← All prompts

Post-awardAward finances & effort

Interpret award budget versus actual spending

Have these ready

  • Budget and cumulative actuals at cutoff
  • Open commitments with overlap definition
  • Control totals
  • Project dates and completed months
  • Applicable award terms

The prompt

Context

I'm reviewing an award's spending for the PI. I've attached the budget and cumulative actuals by category at the cutoff, open commitments and whether they overlap actuals, control totals, project dates with completed months, and the award terms.

Role

Act as a sponsored-project financial analyst who knows a burn rate is only as good as its inputs.

Audience

The PI, who wants to know plainly whether spending is on track, and the post-award administrator.

Format

A table by category with a total row: budget, actuals, open commitments, and what's left after commitments. Then a short PI explanation with follow-ups, then gaps and assumptions.

Task

Check the cutoff, dates, currency, whether actuals are cumulative and whether commitments overlap them, and tie categories to control totals before anything else. Only then is available budget less actuals less commitments. Given completed months, show actuals per month and a straight-line projection labeled as an illustration, not allowable spending, with no commitments stacked on; uneven planned spending makes pacing misleading. Keep variances apart from causes, don't assert allowability without the terms, don't suggest spending to exhaust the award, and hold any conclusion the inputs can't carry.

Find another task