Metrics Tools

The following spreadsheets and lists are used in calculating the quality and savings numbers needed for the Bend the Curve initiative. These numbers project the outcomes our changes should have on service quality and costs.

BIS 2005 Rates

For estimating IT Programming

Metrics Calculator

For estimating overall project savings. It can also be used for making recommendations. There is a version with example numbers and a blank version.

Staff time pay rates by pay range

Used to calculate savings when staff time is shifted, not eliminated

Recommendations Savings Calculator

Or copy main metrics sheet above, remove unaffected lines from the two states and correct the step counts

Recommendations Pay Rate Savings Calculator

Use with item number 3 for when the savings are from shifted--not eliminated--staff time.

Time Conversion Table

Value Stream Mapping Visio Template

Visio Templates And Instructions

Help for Project Data Managers