HomeMy WebLinkAbout2021 Fire StatSBStat | Fire
2 0 2 1 Q u a r t e r 1 J u n e 1 0 t h 2021
C i t y o f S o u t h B e n d
SBStat 2021
Ground rules for SB Stat Meetings
1. No stupid questions
Use this space to ask and address difficult questions
safely
2. Data-driven decision making
Strive to make decisions based on whatever most
recent data is available
3. Relentless follow-up
Identify clear action items and owners after each
meeting
4. A bias towards action
Continuously seek to improve: our data, our ways of
working, etc.
Good questions to be asking…
•What are the next steps on this project? Who’s going to own it?
•Do we have the data we need to make a good decision? If not, how can we get that data?
•Is there a strategy or hypothesis on this issue we want to test during the next quarter?
SBStat 2021
Today’s Agenda
I. Project updates from previous Stat meeting
II. Quarterly Statistics Review
III. Deep-dive analysis & discussion
-Fire Compensation Study
-Fire Operation Dashboard
-Fire Inspection Dashboard
IV. Taking action
-Identifying clear action items and owners
V. Celebrating our values
SBStat 2021
Fire Stat Portfolio Summary
Status of SBStat projects in the queue for 2021
Project Brief Description Status
Fire Inspection Dashboard Visualizing data that summarizes the Fire inspection and prevention programs
Fire Operations
Dashboard
Visualizing data that summarizes
basic Fire operations, including response
time,incident types, etc.
Fire Compensation
Study
A comparative analysis of SBFD's
compensation package to other agencies
Legend Project on schedule Project delayed Project cancelled Project under consideration
SBStat 2021
Quarterly Statisitics Review
Summarizing data points and statistics related to core operations since the last Stat meeting
Quarterly StatisticsFire Stat
•Response Time
•Fire Prevention
•Programmatic Data
New in 2021: Quarterly Statistics Review
What’s the Quarterly Statistics Review?
•New this year across all SB Stat Focus Areas is a review of recent data and
statistics relevant to the Stat project portfolio.
•These reviews will occur in every Stat meeting to help the audience be data-
driven in their thinking and ensure data important to residents stay top of
mind.
How does this data help the City manage performance?
•Revisiting data frequently across departments helps the City develop common
language for asking questions and working together.
•For Fire Stat, this data will help City Leadership understand fire operations in
South Bend and inform how city actions may affect outcomes.
•Including how other departments can collaborate with SBFD to affect those
outcomes
Existing Use Cases
Response Time
•NFPA Targets
•Notifications
Fire Stat Quarterly Statistics
Program Data
•Incident Details
•Equipment management
Fire Prevention
•Inspections
•Community Engagement
Initial metrics and geographic units of analysis
Initial Metrics
•Response Time
•NFPA targets
•Incident Details
Units of analysis
•By Station
•By Shift
•Census Tract
SBStat 2021
Discussion questions before closing out the topic
1.Is there anything missing from the initial metrics list that should be included?
2.What metrics would you love to see more analysis on?
SBStat 2021
Deep-dive analysis & discussion
Diving deep into a few key initiatives being undertaken to improve city performance
•Fire Compensation Study
•Fire Operations Dashboard
•Fire Inspection Dashboard
SBStat 2021
Fire Compensation Study
Preliminary Analysis
•Background / context
•Available data & analysis
•Next steps
SBStat 2021
Fire Compensation Study –Preliminary Analysis
Background/Context
Purpose
The study will follow the same methodology as the 2020 Police Department compensation study that was performed in early 2020
Methodology
•Easily comparable incentives
•Cities of similar size or population
•Averaged out through a 10 and 20 year time horizon
Fire Compensation Study –Preliminary Analysis
Background/Context
•Gathering information from comparable Indiana and out of state cities,such as:
•Study Limitations
1.Staff are still waiting to receive firefighter salary information from the following cities:
Bloomington, Evansville, and Fort Wayne
2.SBFD typically offers more services than fire departments in other cities3.Data has not been vetted by Human Resources staff
•Elkhart
•Carmel
•Lafayette
•Noblesville
•Greenwood
•Mishawaka
•Franklin
•Kokomo
•Valparaiso
•Michigan City
•Anderson
•Rockford, IL
•Green Bay, WI
•Toledo, OH
•Grand Rapids, MI
•Madison, WI
•Parma, OH
•Rochester, MN
•Ann Arbor, MI
Indiana cities Out-of-state cities
City Total Annual Pay after 10 years Difference from South Bend
Total Annual Pay
after 10 years
(adjusted for COLA)
1 Carmel $78,471 $15,816 $75,983
2 Elkhart $73,240 $10,585 $72,825
3 Lafayette $69,509 $6,854 $68,329
4 Noblesville $66,734 $4,079 $64,618
5 Greenwood $64,981 $2,326 $62,920
6 South Bend $62,655 $0 $62,655
7 Mishawaka $62,540 ($115)$62,540
8 Franklin $63,031 $376 $61,033
9 Kokomo $58,542 ($4,112)$60,465
10 Valparaiso $69,785 $7,130 $58,325
11 Michigan City $55,350 ($7,305)$57,669
12 Anderson $53,535 ($9,120)$51,837
Indiana city comparisons by total pay after 10 years
The table below compares South Bend with other Indiana cities for total annual pay after 10 years for a first-class firefighter.Total annual pay includes the firefighters’ annual salary, uniform allowance, and longevity payment
Note: The City of South Bend is still waiting to receive firefighter salary information from the following cities: Bloomington,
Evansville, and Fort Wayne.
City Total Annual Pay
after 20 years
Difference from
South Bend
Total Annual Pay
after 20 years
(adjusted for COLA)
1 Carmel $81,571 $17,316 $78,984
2 Elkhart $73,600 $9,345 $73,183
3 Lafayette $72,759 $8,504 $71,523
4 Franklin $68,689 $4,434 $66,511
5 Noblesville $68,064 $3,809 $65,905
6 South Bend $64,255 $0 $64,255
7 Greenwood $65,731 $1,476 $63,647
8 Mishawaka $62,540 ($1,715)$62,540
9 Kokomo $60,239 ($4,016)$62,217
10 Valparaiso $70,685 $6,430 $59,078
11 Michigan City $56,700 ($7,555)$59,076
12 Anderson $55,535 ($8,720)$53,774
Indiana city comparisons by total pay after 20 years
The table below compares South Bend with other Indiana cities for total annual pay after 20 years for a first-class firefighter.
Total annual pay includes the firefighters’ annual salary, uniform allowance, and longevity payment
Note: The City of South Bend is still waiting to receive firefighter salary information from the following cities: Bloomington, Evansville, and Fort Wayne.
SBStat 2021
Out of state cities comparisons by total pay after 10 years
The table below compares South Bend with other Indiana cities for total annual pay after 10 years for a first-class firefighter.Total annual pay includes the firefighters’ annual salary, uniform allowance, and longevity payment
City Total Annual Pay
after 10 years
Difference from
South Bend
Total Annual Pay
after 10 years
(adjusted for COLA)
1 Rockford, IL $85,244 $22,589 $86,596
2 Green Bay, WI $71,550 $8,895 $70,415
3 Toledo, OH $66,449 $3,794 $68,029
4 Grand Rapids, MI $66,515 $3,860 $63,728
5 South Bend $62,655 $0 $62,655
6 Parma, OH $62,410 ($245)$61,279
7 Madison, WI $62,715 $60 $56,962
8 Rochester, MN $59,749 ($2,906)$56,636
9 Ann Arbor, MI $58,452 ($4,203)$50,310
SBStat 2021
Out of state cities comparisons by total pay after 20 years
The table below compares South Bend with other Indiana cities for total annual pay after 10 years for a first-class firefighter.Total annual pay includes the firefighters’ annual salary, uniform allowance, and longevity payment
City Total Annual Pay after 10 years Difference from South Bend
Total Annual Pay
after 10 years
(adjusted for COLA)
1 Rockford, IL $86,596 $22,617 $86,624
2 Green Bay, WI $70,415 $9,135 $70,652
3 Toledo, OH $68,029 $5,465 $69,740
4 Grand Rapids, MI $63,728 $4,460 $64,303
5 South Bend $62,655 $0 $62,655
6 Parma, OH $61,279 $555 $62,064
7 Madison, WI $56,962 $2,988 $59,622
8 Rochester, MN $56,636 -$2,906 $56,636
9 Ann Arbor, MI $50,310 -$4,203 $50,310
City Total Population Total Square Miles Total Sworn Firefighters Total Annual Incidents
Total Annual
Pay after 10
years (adjusted
for COLA)
Carmel 97,464 50.17 154 7,321 $75,983
Elkhart 52,257 28.45 129 $72,825
Lafayette 72,581 27.74 149 11,973 $68,329
Noblesville 63,071 32.79 140 $64,618
Greenwood 59,458 27.91 54 7,218 $62,920
South Bend 102,037 42.40 260 ~15,770 $62,655
Mishawaka 49,245 17.97 115 7,432 $62,540
Franklin 25,106 13.44 ~2500 $61,033
Kokomo 58,145 36.79 90 $60,465
Valparaiso 33,355 16.36 73 $58,325
Michigan City 31,118 20.59 $57,669
Anderson 54,513 14.63 $51,837
Note: The City of South Bend is still waiting to receive firefighter salary information from the following cities: Bloomington, Evansville, and
Fort Wayne.
Indiana benchmarks by other modes of comparison
The table below compares South Bend with other Indiana cities for total annual pay after 10 years for a first-class firefighter.Total annual pay includes the firefighters’ annual salary, uniform allowance, and longevity payment
Note: The City of South Bend is still waiting to receive firefighter salary information from the following cities: Bloomington, Evansville, and Fort Wayne.
Out of State benchmarks by other modes of comparison
The table below compares South Bend with other out of state cities for total annual pay after 10 years for a first-class
firefighter. Total annual pay includes the firefighters’ annual salary, uniform allowance, and longevity payment
City Total Population Total Square Miles Total Sworn Firefighters Total Annual Incidents
Total Annual
Pay after 10
years (adjusted
for COLA)
Rockford, IL 147,070 65.39 246 29,621 $86,596
Green Bay, WI 104,777 55.76 187 13,574 $70,415
Toledo, OH 276,614 83.83 475 60,662 $68,029
Grand Rapids, MI 198,401 45.63 200 24,124 $63,728
South Bend 102,037 42.40 260 ~15,770 $62,655
Parma, OH 79,091 20.07 119 $61,279
Madison, WI 254,977 101.50 258 25,646 $56,962
Rochester, MN 115,557 55.69 101 ~10,000 $56,636
Ann Arbor, MI 120,735 28.79 83 7,318 $50,310
SBStat 2021
City ALS Transport Haz mat River Rescue Drone Community
Paramedicine
Total Annual
Pay after 10
years (adjusted
for COLA)
Elkhart x $75,983
Carmel x x $72,825
Lafayette x x $68,329
Noblesville x x x $64,618
Greenwood x $62,920
South Bend x x x x x $62,655
Mishawaka x $62,540
Franklin $61,033
Kokomo x $60,465
Valparaiso x $58,325
Michigan City x $57,669
Anderson x $51,837
Services provided by respective departments
The table below compares South Bend with other Indiana cities for the type of services the department offers.
SBStat 2021
City ALS Transport Haz mat River Rescue Drone Community
Paramedicine
Total Annual
Pay after 10
years (adjusted
for COLA)
Rockford, IL x x $86,596
Green Bay, WI x $70,415
Toledo, OH x x $68,029
Grand Rapids, MI x x $63,728
South Bend x x x x x $62,655
Parma, OH x $61,279
Madison, WI x x $56,962
Rochester, MN x x $56,636
Ann Arbor, MI x x $50,310
Services provided by respective departments
The table below compares South Bend with other Indiana cities for the type of services the department offers.
SBStat 2021
Taking Action
Fire Compensation Analysis
Next Steps
•Business Analytics to share the analysis in-depth
with HR, other key negotiators
•Business Analytics will prepare an overview on
compensation analysis (memo)
•HR to review preliminary analysis, validate
SBStat 2021
Fire Operations Dashboard
•Background / Context
•Available data & analysis
•Options to improve performance
SBStat 2021
Fire Operations DashboardBackground/Context
Last quarter, we produced a prototype dashboard
that communicates precise data with improvements
to the visualizations.
In 2021 SB Stat
the main focus is:
Improve visualizations, remove technical
jargon for better understanding of
the data
Scale the prototype to include more data
SBStat 2021
Fire Operations Dashboard
Industry Best Practices
•Cincinnati's dashboard is understandable and very user friendly for residents to use.
•Valparaiso's dashboard was more designed for internal use for the actual fire department
•Potentially designing an internal dashboard for only the fire department to utilize
SBStat 2021
Fire Operations Dashboard
Industry Best Practices
Cincinnati, OH Valparaiso, IN
SBStat 2021
Fire Operations Dashboard
Previous Prototype
SBStat 2021
Keeping the data up-to-date
On-the-ground data entry to the operations dashboard in the cloud
1. Fire captain enters
incident data in ESO
2. ESO data is locked
3. A weekly ESO
report is pulled into
reporting server 5. ESO data fed into
PowerBI dashboard
4. Weekly ESO report
integrated with
historical data
SBStat 2021
Fire Operations Dashboard
Current Prototype
SBStat 2021
Fire Operations Dashboard
Discussion Questions
•What are the next steps you see for the prototype?
•Should the prototype be added to the City’s public transparency portal and be available to residents?
•What metrics would you like to see in an internal dashboard?
SBStat 2021
Fire Inspection Dashboard
BACKGROUND /
CONTEXT
AVAILABLE DATA &
ANALYSIS
OPTIONS TO IMPROVE
PERFORMANCE
SBStat 2021
Fire Inspection DashboardBackground/Content
1.Last quarter, we incorporated the previous
year's data
2.This quarter we are continuously focusing
on the business license map to be added to
the data source that interacts with PowerBI
SBStat 2021
Fire Inspection Dashboard
Available Data & Analysis
Dashboard Link
SBStat 2021
Fire Inspection Dashboard
Options to Improve Performance
•The ulimate goal is to consolidate both the reinspections and business inspections into one map
•By adding the business license map as a data source for PowerBI
SBStat 2021
•Should any other metrics be added to the final Fire Inspection dashboard?
•Do you see this dashboard being used for residents, internally, or both?
Discussion questions before closing out the topic
SBStat 2021
Taking action
Offering policy alternatives, data-based frameworks, and decision points to take action in improving the lives of South Bend residents
Taking Action
Next Steps Summary
Fire Compensation
Study
•Business Analytics to share the analysis in-depth with
HR, other key negotiators
•Business Analytics will prepare an overview on
compensation analysis (memo)
•HR to review preliminary analysis, validate
Fire Operations
Dashboard
•Explore adding dashboard to City transparency portal
•Develop internal version of operations dashboard that
drills down to station-level views
Fire Inspection
Dashboard
•Consolidate both the reinspections and business
inspections into one map by adding the business
license map as a data source for PowerBI
SBStat 2021
Fire Stat Portfolio Summary
Status of SBStat projects in the queue for 2021
Project Brief Description Status
Fire Inspection
Dashboard
Visualizing data that summarizes
the Fire inspection and prevention programs
Fire Operations
Dashboard
Visualizing data that summarizes
basic Fire operations, including response
time,incident types, etc.
Fire Compensation
Study
A comparative analysis of SBFD's
compensation package to other agencies
Legend Project on schedule Project delayed Project cancelled Project under consideration
SBStat 2021
Celebrating our values
This section highlights exemplary work happening in the City to improve performance that may otherwise go unnoticed
SBStat 2021
Celebrating our Values
SBStat | Fire Stat
2021 Quarter 1 J u n e 1 0 , 2 0 2 1
C i t y o f S o u t h B e n d