Template Library
Public Sector Improvement Charter Template
An Excel workbook for public-service improvement projects: a charter, milestones, risks, and a benefits log that keeps cash savings separate from capacity released.
The Charter tab captures the problem, public value, scope, legal constraints, stakeholders, baseline, target, balancing measures, and an equity and access check before work begins. The Milestones tab is an Excel Table with a Days Overdue formula, and the Risks tab scores likelihood and impact and assigns a level.
The Benefits tab records each benefit by type (cash savings, cost avoidance, capacity released, or service improvement) with baseline, target, actual, progress, and annual value, and the Summary tab totals value by type. Example rows for a permit-process project are included so you can see the formulas working before you replace them.
Download Public Sector Improvement Charter Template Back to Templates
What Is Included in the Workbook
| Sheet | Purpose | What Teams Capture |
|---|---|---|
| How-To | Guidance and disclaimer | Steps, notes, and how to report benefits |
| Charter | One-page project charter | Problem, public value, scope, legal constraints, stakeholders, baseline, target, balancing measures, equity check, approval |
| Milestones | Milestone tracker (Excel Table) | Milestone, owner, planned and actual dates, status, and calculated days overdue |
| Risks | Risk register (Excel Table) | Risk, likelihood, impact, calculated score and level, response, owner |
| Benefits | Benefits log (Excel Table) | Benefit, type, measure, baseline, target, actual, calculated progress, annual value, verification |
| Summary | Live rollup and chart | Milestone and risk counts and annual value by benefit type |
Key Features Inside the Template
Public Value and Constraints Up Front
The charter asks why the project matters to residents and what laws or rules limit it, so the team starts with the right boundaries.
Equity and Balancing Measures
Dedicated fields prompt the team to say what must not get worse and how it will check that access is protected.
Benefits by Type
Cash savings, cost avoidance, capacity released, and service improvement are recorded separately, so results are credible.
Automatic Tracking
Days Overdue, risk scores and levels, benefit progress, and totals by type calculate as you enter data.
Best Use Cases
- Chartering a process improvement project in a city, county, state, or federal office
- Tracking the benefits of an improvement program for leadership and budget reviews
- Training project leads to define scope, risks, and benefits consistently
- Documenting a project so results can be verified later
How to Use the Template Effectively
- Complete the charter with data, and get the sponsor's approval before starting.
- List milestones with owners and dates, and update status weekly.
- Score risks as a team and assign a response and owner to each.
- Record benefits with the right type, and state how each will be verified or used.
- Review the Summary at milestones, and report cash savings and capacity released separately.
Who Should Use This Template
- Process improvement leads and analysts in public agencies
- Program managers and sponsors overseeing improvement portfolios
- Trainers teaching public-service improvement methods
Common Mistakes to Avoid
- Counting released staff time as cash savings when no budget line changes
- Skipping the legal and policy constraints, then finding a step cannot change
- Leaving out balancing measures, so speed gains hide new problems
- Not saying how the capacity released will be used
Important Notes
Public Sector Improvement Charter Template Frequently Asked Questions
How should I record capacity released?
Record it as its own benefit type with the hours per year and an annual value based on your loaded cost per hour, and say how the time will be used, for example to reduce a backlog. It is not cash savings unless a budget line changes, so keep it separate from that total.
Can I use this for a very small project?
Yes. For a short project you can complete only the charter and the benefits tab, and skip the risks tab. The value of the charter is in agreeing scope, baseline, and target before work begins.
Does this satisfy my agency's project approval requirements?
Not by itself. Your agency may have its own forms, approvals, and reporting rules. Use this workbook as a working tool and adapt or attach it to whatever your governance requires.