Commitments: How Purchase Orders Encumber the Budget
This lesson is part of the course
In this lesson
You read Fernhill's purchase-order register, add up the open commitments per budget line with SUMIFS while leaving out cancelled orders, and find the line whose budget is already most committed.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Budget Lines: Original Budget, Transfers & the Revised Budget Locked
- Commitments: How Purchase Orders Encumber the Budget Locked
- Invoices & Releases: Actual Spend, Partial Invoices and the Open PO Balance Locked
- Available Budget & the Funds Check Before a New PO Locked
- Price & Quantity Differences: Invoices Above or Below the PO and Tolerance Rules Locked
- Forecast to Year-End: Run Rate, Planned Commitments & Projected Out-Turn Locked
- Year-End: Carrying Forward Open Commitments & the New Year's Opening Position Locked
- The Budget Report: Line × Month Table, Share Used, RAG Status & Chart Locked