News & Press: Newswire

ASBO New York Partner Forecast5 Presents Monthly 5Sight Tip

Tuesday, April 9, 2019  

Using 5Sight to visualize and compare line item spending trends

This tip shows how 5Sight lets users easily visualize and compare line item spending over time. To start, I created a comparison group of four neighboring school districts, with similar enrollments (numerically and demographically). The image below shows actual spending per student on medical benefits, budget code 9060.8.

Figure 1. Health Care Spending per Student

These districts have not experienced the same trajectories in their health care costs. The school district represented by the orange line has seen its health care costs remain relatively steady, while the district represented by the pink line has seen the steadiest increase. The first chart covers per pupil spending, so differences in enrollment could impact the numbers. Figure 2 shows health care spending as a share of overall operating expense.

Figure 2. Health Care as a Share of Overall Operating Expense

Looking at the data in terms of their share of overall spending, even though there are slight changes from the per pupil trends, it’s clear that health care spending has its greatest financial impact on the school district represented by the pink line.

By combining powerful public sector business intelligence software with ready-to-use analytics tools, 5Sight generates detailed and data-driven perspectives on organizational and peer performance to accelerate insights and put decisions on the fast track. For more information about 5Sight visit here or email Michael Vespi at mvespi@forecast5analytics.com.