Category

Fiscal Health

Fiscal Health, Municipal

Data Management and Analytics Software for Municipalities

The Ongoing Evolution of Data Management and Analytics Software for Cities, Villages and Townships

Advanced data management and analytics software for municipalities has evolved beyond mere data visualization—which is, of course, critical—to encompass robust yet intuitive performance analytics solutions as well. For it’s one thing to be able to contextualize data through charts and graphs, but quite another to have software convert that data into actionable insights and intelligence that can inform better decision making.

One component of the complete Munetrix edition of our data management and analytics software for municipalities is a suite of tools that empower cities, villages and townships to perform peer review audits, track progress against their own metrics and manage projects to easily meet compliance requirements. The Budget Builder app, for example, is a powerful tool that allows users to create linear regression budgets in a matter of minutes.

We wrote recently about some features of the Munetrix Municipal Budget Allocation Reporting Dashboard. Whether you are allocating new monies from stimulus or other surplus, or making tough decisions about spending cuts, the best way to make those hard choices confidently is having the most complete set of data available.

Get a Free Demo of Munetrix’s Data Management and Analytics Software for Municipalities Today!

The Enterprise Module of Munetrix’s data management and analytics software for cities offers the most complete range of data visualization software for municipalities available. The full product includes budgeting, chart of accounts planning, forecasting and scenario building to debt management, peer benchmarking and capital improvement management, powerful interdependent apps that collaborate to contextualize and visualize all data sets available, from public API to your city’s internal data systems.

City managers, finance directors and other municipal administrators can get free access to one of the key tools in our data management and analytics software for municipalities with a free report we are issuing to any city, township or village who wants to receive this complimentary report. Learn how your municipality’s budget allocations compare to the average of all others in your region with this free, personalized report created specifically for your particular city, village or township—at no cost or obligation! Click here to receive your free, personalized report within 24 hours.

To learn more about how local governments are using data management and analytics software for municipalities to build better budgets, make better decisions, and inject greater transparency, easier compliance and, ultimately, more community trust, collaboration and teamwork with their constituents, request a no-obligation demo to unlock 30 days of free access to the Munetrix data management and analytics software for municipalities!

Fiscal Health

Municipal Budget Allocation Reporting Dashboard

The Munetrix Premium Edition for Municipalities features a comprehensive and intuitive municipal budget allocation reporting dashboard. Whether you are allocating new monies from stimulus or other surplus, or making tough decisions about spending cuts, the best way to make those hard choices confidently is having the most complete set of data available.

City managers, finance directors and other municipal administrators can get free access to one of the key tools in our municipal budget allocation reporting dashboard with a free report we are issuing to any city, township or village who wants to receive this complimentary report. Learn how your municipality’s budget allocations compare to the average of all others in your region with this free, personalized report created specifically for your particular city, village or township—at no cost or obligation!

Your free municipal budget allocation report will be customized to your specific municipality, comparing your budget allocations against the average of all others in your region, allowing you to: 

  • Compare your allocations against the regional average
  • Determine where you might be over-spending or under-spending, based on your peer averages
  • Make better-informed decisions about where to apply budgets or where to cut without losing pace with other cities, villages and townships in your region
  • Use data to create a culture of community through trust, teamwork and transparency
  • Measure what you treasure

Get a Free Demo of Munetrix’s Municipal Budget Allocation Reporting Dashboard Today!

The Munetrix Premium Edition for Municipalities offers the most complete range of data visualization available. The full product suite features apps for budgeting, chart of accounts planning, forecasting and scenario building to debt management, peer benchmarking and capital improvement management, powerful interdependent apps that collaborate to contextualize and visualize all data sets available, all in one intuitive and accessible dashboard!

Continue reading to learn how local governments are leveraging tools like the Munetrix municipal budget allocation reporting dashboard to achieve greater transparency, facilitate mandated compliance and, ultimately, build community trust, collaboration and teamwork with their constituents.

Fiscal Health, Municipal, Opinion

Look at the Bigger Picture to Facilitate Better Budgeting

Better Data Makes for Better Budgeting for Municipalities

Whenever city managers and finance directors go into a budgeting exercise, they face dilemmas and difficult decisions. Whether trying to prioritize the allocation of stimulus or other surplus funds, or processing the challenging demands of budget cuts, tough calls need to be made.

The problem we see is many are forced to make difficult decisions with limited data and incomplete information. Placing unnecessary blinders on your budgeting can lead to incorrect conclusions and potentially misplaced allocations of resources.

It is, however, possible to remove the blinders that have shackled the hands of budgeters and forecasters for years, allowing them to make the invisible visible.

To help facilitate and illustrate this methodology for finance directors, we are, for a limited, time offering a free report to any municipality that wants to see how their budget allocations compare to those of all others in their regions.

.

Data as Competitive Advantage

Let’s face it: Even neighboring cities and townships are in competition. Municipalities are competing not only for population and tax bases, but for visitors, shoppers and recreationalists as well. 

Most often, the competition is right next door. Sometimes it’s within a reasonable commute. But make no mistake, population flight and lower pedestrian traffic are very real and likely to remain (at least to a degree) for the foreseeable future. 

With so much at stake, it’s imperative that municipalities make the most of their strategic decisions—budgetary or otherwise. It’s no longer enough to look internally and self-assess. To do so ignores the data set of competitive forces…the ones pulling at our residents and guests.

But what if you could not only zoom out from your own spreadsheets and historical data and look at the bigger picture? By this, we mean the much bigger picture of the entire region, to access more information, better intelligence, and greater insights on the drivers of success, resident migration and the flow of expenditures and investment. How might that change minds and budgets?

(To access your municipality’s comparison data like the one illustrated above, click here to receive a free report customized specifically to your city, village or township.)

What we’d see is not only our data, but our own data relative to the entire region’s—not just a neighbor or two. How do our city’s budget allocations differ or align with where our competitors are spending their dollars? It would make visible the answers to these questions, which would otherwise remain invisible:

  • If we have to cut spending, are we cutting in the right areas?
  • If we are able to invest stimulus dollars, where are the areas that we need to play catch-up with our peers?
  • Are we over-spending or under-spending, compared to our peers throughout the region, in areas like salaries, facilities and infrastructure, administrator compensation, etc.?
  • How do we know when enough is enough, or too much is too much?
  • Are we winning or losing the various battles for residents, tax payers, merchants, shoppers and federal investments?

It’s one thing to have “a sense” that particular line items need bolstering or trimming, and quite another to have access to regional averages that keep no secrets as to how your city or township is stacking up against the competition.

No longer is it prudent to play a hunch. It’s time to play to win.

Get Your Municipality’s Free Report to See How Your Budgeting Stacks Up Against the Competition

We feel so strongly about the power of performance analytics and data visualizations presenting the complete picture that we are offering a free report to any municipality that would like to evaluate its own budget allocations against the average of its regional peers. 

Your personalized report, customized to your specific city, township or village, will include your version of the above data, along with a breakdown of all spending categories, delivered personally to your inbox in an easy-to-read PDF:

Simply click here to access your city’s Budget Allocation report, at no cost or obligation. You will receive the report within 24 hours, along with access to a live human who will be available to answer questions or help you contextualize your data.

Before long, the invisible will be visible to you. And you will be entering your next budget planning session armed with greater insights, broader intelligence, and informed confidence. Say hello to easy!

Peter Solar is Director of Client Partnerships with Munetrix, a performance analytics and data visualization solution provider serving school districts and municipalities across the country. He can be reached at psolar@munetrix.com.

Fiscal Health, Municipal, News, Opinion, Uncategorized

Watch: How to Restore Public Trust in Government Institutions through Data Literacy

Take a closer look at the Munetrix Municipal Module, the comprehensive, all-in-one solution for municipal administrators being tasked with doing “more with less”:

Munetrix Municipal Data Solutions

More transparency. More trust. Stronger community…Say hello to easy!

To learn more about the Munetrix Municipal Module, take our virtual today!

Education, Fiscal Health, Municipal, Opinion

Be Not Afraid: Data Can Be Your Greatest Ally and Easiest Path to a Post-Pandemic Recovery

GovTech’s March magazine’s article, Data-Driven Ways to Maximize City Budgets Post-Pandemic, authored by Harvard-Kennedy Professor of Innovations in Government Stephen Goldsmith, was almost genius in the way it broke down the benefits of data use into simple components. Former government appointee and thought leader Jane Wiseman co-authored the piece, and collectively, they hit the nail on the head.

I have long held that the word data is one of the most oft-used but least understood words in government today. What exactly is data, anyway? It means different things to different people. And to almost everyone, the word can suggest an intimidating reference to sophisticated technology and informational analytics.

But for an archeologist, an unearthed piece of broken clay is a data point. A cardiologist would find blood pressure or heart rate data useful. For a police chief, crimes per capita per geographic square mile are significant data points. Certainly any police chief would understand those measures and their importance, but making an assumption that everybody shares that ability would be a mistake. The point is, data must be presented in a manner in which anybody can understand—especially public-sector data, which is often lacking in structure and availability.

Adopting a Culture of Data Literacy to Combat Data Intimidation

As both a data analyst and an office-holding policymaker, I can say with certainty that many public sector stakeholders who have limited exposure to technology, finance or analytics often shy away from asking questions for fear of embarrassment. This is particularly concerning with policymakers, who may be tasked with making decisions on information they may not completely comprehend.

Goldsmith and Wiseman suggest, “The best strategy is to use data as a tool—to identify what works and find operational efficiencies and identify the areas in the greatest need.” One with a technical or analytical background might infer he’s referring to the Pareto Principle, also referred to as the “80/20 Rule”, which implies that 80% of outputs are driven from just 20% of inputs.

Using data, a city discovered it was spending considerably more on its police department on a per-capita basis than any of the other 17 cities in the region. Blue bars represent region averages, red represent the city’s actual spend. By addressing the imbalance in its next contract, the city saved $2 million over the new contract term.

But not every municipality can afford to have a Business Analyst on staff, nor do they need to. Investing in a simple-to-use analytics platform, and with minimal training, a “culture of data literacy” can take root, and eventually erode away the intimidation that the typical lay person harbors when it comes to data and technology. Given the right inputs (the 20% Pareto references), technology can be leveraged to provide a prescriptive set of outputs, in an intuitive, dashboard-like visualization that even the broader community-at-large can understand, with no prior training at all!  

In one real-world example, a community in Michigan found that they were spending considerably less than the 11 other cities in its region by reviewing just such graphic outputs. When expanding their search/analysis to cities across the state of like size (budget, taxable value, population, e.g.), it emphasized the finding was truer than they even realized. In one sense, community officials could be proud of their cost controls, but the question that remained was, How does this relate to the quality of service we are delivering at that budget, and was it appropriate and sufficient?  

Another community found that it was spending considerably less than the 11 other cities in their region (middle chart), and when expanding their search to cities across the state of like size (budget, taxable value, population, shown at right) it emphasized the finding was true.

When they looked at their reported crime data, they realized that the money saved was not benefiting the residents, since they were near the top in every one of the four major categories of crime reporting data.

Aha. A more complete data set reveals a much different takeaway. And nobody needed an advanced degree to read the digital tea leaves. This community clearly and confidently recognized that it needed to invest more in their police department, and made the decision to do so almost immediately. 

Survey Says!

The authors cite a recent survey they conducted in 2020 with the Chief Data Officers of 20 cities. They report that the responses were contradictory, in that many cited the need for massive increases in data use, but anticipated less funding would be available for the infrastructure that creates value from data. One respondent said, “The appetite for data has tremendously increased, and data insights are becoming the norm.” 

One concern is that as data needs increase, budget reductions “will eliminate new initiatives and impact some ongoing operations,” according to Philadelphia CIO Mark Wheeler. The other concern confronting them is the loss of experienced staff due to the boomers hitting retirement eligibility and a shortage of qualified or interested talent coming into the public domain.

According to the article, consulting firm McKinsey estimated that globally, “Government could capture $1 trillion of value by using data analytics, both to identify revenue not collected and to recoup payments made in error, and estimates that using data analytics to eliminate waste, fraud and abuse in government can have returns as high as 10 to 15 times the cost.”

At Munetrix, we’ve seen this in situations as simple as analyzing an Accounts Payable report.  Why pay a single vendor 50-70 times per year when payment terms of once per month can be easily established?  If we calculate the cost of processing a payment, order to bank reconciliation, transactions costs range from $35 to almost $150 based on estimates from governments of different types and sizes. If 50 payments using an average of $50 were eliminated, we could free up $2,500 for other operational purposes. Multiply that by dozens of vendors and we’re talking real money.

Simple, intuitive and rich data visualizations have the ability to turn the invisible into the visible.

Looking at data visually can provide insights to trends or anomalies that may otherwise be left undiscovered.

Removing Uncertainty, Instilling Confidence in Decision Making

Goldsmith-Wiseman’s article concludes by saying that public officials should be able to check the following five boxes if they are interested in fostering a culture that respects the power of data to unlock insight. Does your community…

  1. Use public scorecards to show returns on investment measured in terms of customer service and dollars saved.  
  2. Use a predictive analytics program.
  3. Make widespread use of layered data and spatial analytics to identify trends and relationships.
  4. Use data to identify revenue opportunities in service areas or with examining unpaid fees. 
  5. Establish an internal “culture of data literacy” initiative with employees. 

And I would recommend a #6 be added: Don’t be afraid of data, and don’t be afraid to ask for help! There is nothing to fear in making more informed decisions and more confidently prescribing solutions to today’s challenges as we continue to recover from the effects of a global pandemic.

When data is Reliable, Timely, Relevant, Useful, Comparable and Consistent—the six qualitative characteristics of data per the Government Accounting Standard Board (GASB)—the invisible becomes visible; and added clarity will ultimately improve decisions, outcomes and literacy.

Education, Fiscal Health, K-12, Opinion

Schools Should Take a Three-Phased Approach as They Plan to Return to “Normal”

How to Adapt Today, Become Adept Tomorrow, and What to Adopt Permanently

[A version of this post originally appeared on District Administration, a national trade journal serving school district administrators and educators.]

When announcements came that states were closing schools for the remainder of this school year, in a way they brought the first semblance of clarity to the myriad spate of unknowns. Soon, we began to look ahead to the fall school year, which brings its own set of variables and unknowns. While we expect timelines and announcements to vary from district to district and state to state, one thing is becoming increasingly clear: it is unlikely that things will soon be getting “back to normal” in large measure.

With each day comes increased clarity, if only at the margins, but that clarity is often difficult to recognize in moments of urgency and quickly shifting priorities. But each day, discoveries are being made: we weren’t prepared for this or that, we hadn’t accounted for every contingency, or perhaps, maybe we’ve stumbled upon a better way to manage this particular task.

Which is why, though it may seem difficult at first, school districts and personnel at every level of education should be taking this time to reassess their systems, processes and vulnerabilities to optimize what will eventually be a return to some degree of normalcy. But it likely won’t happen overnight. In fact, we suggest that educators and administrators take a three-phased approach: take immediate remedial actions where you can in the short term, plan for an eventual transition back to a more recognizable learning environment, and document what new workflows should be permanently adopted as best practice long-term.

Phase One: Triage for Today

Literally overnight, educators and administrators were thrust into an entirely unfamiliar work and teaching environment. Technology needed to be learned and adopted without warning, nor training. Employees dispersed to millions of disconnected remote home offices in an instant. Nearly everything we took for granted, in terms of collaboration, communication and cooperation, was suddenly taken from us. And many instantly discovered the limitations and vulnerabilities that few had accounted for.

Access to systems and documents proved challenging for those who are used to keeping software and hardware under literal and figurative lock-and-key. If “it’s at my desktop at school,” it’s practically unreachable at the moment.

But work needs to get done. Meetings need to happen. Projects need to press forward, and budgets will soon be due. We cannot permanently pause. As many have discovered, time waits for no one. 

All of this underscores the need to quickly establish and document new workflows, new teams, new processes for planning, and new systems and technology that live in the cloud or are accessible to anyone who needs it, 24/7. 

Amid all of our other urgent priorities, administrators and educators should be documenting proper workflows that account for each of the following:

  • Tasks: Capture explicit documentation of all required tasks to complete a given project.
  • Teams: Make sure all tasks are assignable to ensure completion and inject accountability.
  • Timelines: Create project milestones that are clearly defined and realistically attainable.
  • Metrics: Measure progress and success against pre-established desired outcomes.
  • Prompts and Reminders: In times of uncertainty, teams will need (and respond to) built-in alerts and prompts when deadlines approach or new priorities arise.
  • Collaboration: Multiple teams may need to collaborate on overlapping projects. Create safeguards against tasks being missed due to workflow handoffs or unclear accountability.

Once decided upon and documented, leverage available technology to create one centralized knowledge base and project management tool, accessible remotely. Harnessing workflows into one centralized location will make sure nothing gets missed or skipped and can account for new workflows that might come along as priorities shift or change.

Phase Two: Transition to Tomorrow

Workflows, processes, systems and task forces will eventually need to return to a more conventional reality. The problem is, we don’t currently know when that will be. Perhaps it will be announced as suddenly as we transitioned away from our regularly scheduled programming. There will be a sense of relief, to be sure…but there will also be demanding deadlines and daunting decisions equal to those we are grappling with today. 

If uncertainty can be mitigated, now is the time to do it, when it is most relevant and obvious. School districts should be encouraging administrators, educators and clerical support to document where the vulnerabilities and shortcomings emerged, so they can be addressed, not only in the long term, but to avoid a painful transition-back in the nearer term.

In the past several weeks, decisions had to be made with little warning, and new processes had to be up and running overnight. But now we do have some luxury of foresight, knowing that a return to regular education is coming, even if we don’t know when. Perhaps now is the time to plan for those workflows and processes to be updated, especially considering that each individual workflow and task force might have several sub-workflows, and perhaps even disparate teams collaborating at different points and times.

A few transitions we can anticipate now, for which workflows and centralized knowledge bases can be established:

How will we track and process the return of devices that have been assigned out, and who is assigned to each subtask?

What is the new process for building preparation and maintenance, following the sudden dispersal of maintenance personnel, including timelines and accountabilities for reopening facilities?

What updates to registration workflows might need to be made if registration for the new school year is in a compressed time frame or needs to occur remotely/digitally?

How do our teacher and student evaluations need to be addressed, given how the final weeks of this school year’s curricula were delivered?

What changes need to be made to accommodate school lunch provision, both over the summer and should another similar crisis arise—remote delivery or centralized pickup?

Many districts were preparing to roll out a new math series in the fall: Will workflows need to accommodate new realities and timelines?

How will summer school be administered?

Are there necessary changes to scheduling and processing of material assets, such as bus maintenance?

As budget deadlines approach, how can we build in scenarios, given the many unknowns?

Technology is better equipped to manage these tasks, workflows and scenarios at scale than humans, pen-and-paper, or even static spreadsheet software (like Excel or Google Sheets). In most cases, the data to make informed decisions and create optimized workflows already exists and is readily available to school districts. There’s never been a better nor more urgent time to plug in to the tools at our disposal.

Phase Three: Adopt to Adapt, and Stay Adept

What many discover during times of crisis is that processes and procedures adapted out of urgency or necessity can actually be adopted as best practices going forward. In fact, the quicker, most efficient way to accomplish priorities can be discovered then defined to make our teams more effective while reducing costs and eliminating unnecessary exposures to human error.

The first step is moving away from paper and into digital environments. Next, make sure that data and technology is universally available and accessible—from anywhere, at any time, by anyone who should rightly have access. Lastly, allow (or force) technology to do the heavy lifting of planning, coordinating and measuring successful projects and collaborating teams.

Your new workflows and systems should allow you to:

  • plan and prepare for the unknown
  • proactively put processes in place and document workflows
  • account for contingencies
  • consider various and, perhaps even unforeseen, scenarios
  • trigger alternate paths, as appropriate
  • maintain a centralized knowledge repository that can be shared, not only among existing team members, but in perpetuity, even as personnel turnover continues at pace for the foreseeable future

School district professionals may find it challenging to manage the complexity of workflows even under “normal” circumstances. Maybe “normalcy” will return soon, but in the meantime, increased urgency and shifting priorities can create or elevate margin for human error. If we can use this challenge as an opportunity to modernize and optimize workflows, we will all be better for it…both in standard operating procedures and, heaven forbid, when the next crisis presents itself.

This discipline and attention to detail in the short term will build better habits for the long run. Once we emerge from crisis mode, we should take comfort in the lessons learned and the uncertainty conquered.

Linda Kraft is Director of Customer Engagement with Munetrix, a Michigan-based data analytics and management firm serving school districts and municipalities across the country. She can be reached at linda@munetrix.com.

Education, Fiscal Health, Municipal

Budget Planning at the Height of Uncertainty

Scenarios are Critical When You Can’t Predict the Future

[This article also appears in American City & County Magazine.]

For many working in the public sector, budgeting for an upcoming fiscal year is well underway. Has there ever been a more challenging time to account for future unknowns than the current crisis we find ourselves working to overcome?

Budget planning during a “normal” fiscal year is difficult enough, as unknowns and what-ifs are a part of the budgeting process. Past experiences and fairly settled patterns on which we can generally rely help us predict many of our budget assumptions. But forecasting and projecting an annual plan at a time when “facts on the ground” are changing so fast makes the plans we craft today seem like a fool’s errand.

School administrators and municipal managers should be forgiven for feeling ill-at-ease during their fiscal year-end planning and next-year budget planning sessions: Even the “experts” are getting projections wrong. Their models were off. New data emerged. We failed to account for this or that.

But the numbers will soon be due, and telling. There’s no sense in denying reality. The good news is that there are measures we can take today that won’t necessarily eliminate unpredictability in the future; but can at least account for it…and maybe even prepare for it.

Dynamic Events Demand Dynamic Scenario Building

A school superintendent friend of mine made a profound statement the other day, suggesting that, “Every district better have three budgets in their pocket when they start the 2021 school year!” Great advice!  But how?

One of the best ways to hedge against uncertainty is to create various and disparate scenarios, then calculate the outcomes to provide a range of projections for what the future might look like. The problem many budget builders are having right now is that inputs are seemingly infinite: What if income tax receipts drop 10%? Or 15%? What will our parking revenue be? Not knowing when our retail businesses will be back up to full stride, how much sales tax will they generate? How many children will  show back up for school when it reopens? How will we bus them? How will cafeterias function? With so many jobless claims, how “off” will our income tax revenue be? What if our expenses rise tenfold? With so many unforeseen investments suddenly necessary and urgent, such as PPE being sold at prices four to ten times higher than normal, new cleaning supplies and systems, increased investment in remote technology, ambulances that are wearing down quicker, with longer wait times for replacements, etc.? What if? What if, What if? 

We can’t reliably predict the relevant time horizons to inject any sort of end-date confidence into these projections. Yet, we don’t have the luxury of time to wait for a return to any semblance of “normal,” when projections and forecasts can be more reliably made. So now what?

NOW is the time to act – even if the budget isn’t due for a couple months or more. If we wait too long, too much will have changed, so much new information will have to be accounted for, and we’ll find ourselves scrambling to make best guesses and insert relatively random estimates in the interest of urgency. That’s a recipe for error, and even greater uncertainty. A perfect budget isn’t a reasonable expectation. Budgets are a plan, and plans are subject to change. 

Our advice is to look at the big picture…many of them, in fact. Whereas financial professionals have the natural gift, inclination and patience to make calculations in a very granular manner, the current moment demands that we take a step back and look at broader trends, larger impacts, and to be inclusive of line items we’ve never accounted for in the past. If we don’t, our granular and exacting attention to detail will be swept away with the tide of this rushing wave of new information.

In short, these are dynamic times, to be sure. Events, facts and data change hourly. Your budgeting needs to be equally dynamic and nimble to adapt right along with them.

Start with Three; Adjust as Needed.

With so few knowns and so many questions, we recommend that budgeters start by bracketing uncertainty to limit the range of unpredictability. From there, we can hone in. Start with three budget scenarios, after you’ve made your best-case analysis (likely an educated guess) where you are in the current budget cycle (be conservative) and use a top-down approach (i.e., you can’t spend more than you have), and start with revenues.

  • Best-Case Scenario: What is the most optimistic—but realistic—vision for future revenues and expenditures? Don’t be overly bullish…rather, very cautiously optimistic. This exercise will inject greater calm and confidence, and help you prepare for the future absent negativity, emotion or panic. Just as the coronavirus models themselves improved as behaviors changed, it is possible to emerge from this challenge better off than we’d originally feared. Be sure to have a plan for that eventuality.

  • Worst-Case Scenario: The counter exercise will allow your mind, your team and your planning process to put a bracket around your worst fears. Documenting those not only allows you to start planning now for the worst possible outcomes, it can have the effect of actually easing anxiety, as your budgeting should demonstrate your entity’s ability to withstand the coming storm, if you start accounting for the tough road ahead sooner.

  • Realistic Middle Ground: Only after going through the prior two exercises will your brain and your budget be able to wrap itself around the most likely scenario, factoring in both the negative and positive possible versions of the future. Clarity should emerge. You will get to a point where your focus is on some version of a reasonable forecast, from which you can tinker and tweak to account for deviations in inputs as actual data becomes available.

From there, you’ll want the ability to quickly and repeatedly adjust variables, including revenue and expenditure parameters, once unknowns become likelihoods, and eventually, knowns. It is absolutely critical, though, to build that framework now, so you can continue to make adjustments along the way, rather than build something new from scratch 20 times between now and the budget’s due date.

Of course, standard, off-the-shelf spreadsheet software will make this onerous and rigid. If there was ever a time to make an investment in a nimble, predictive and agile technology to create, envision and modify budget plans, it’s now. The minute you have a scenario settled, the facts will change. And even accounting for numerous and varied scenarios, you can be assured that once you find yourself presenting that budget to a room full of decision makers, someone at the table will inevitably ask, “Have you ever considered what this will look like if X happens, and not Y?”…presenting yet another scenario to consider! 

You’ll want to have that answer in minutes…not weeks or months. For all its utility, Excel will not be up to that challenge. Being able to adjust assumptions on the fly is critical.

Three scenarios may not even be enough. You’ll want a tool that can overlay five or more, and demonstrate side-by-side comparisons, so that informed decisions can be made easily, confidently, collaboratively and quickly.

In the Meantime, Cash is King!

Now is not the time to rest on our laurels and wait for the dust to settle. Apart from working hard on budgeting for an unknown future, we can and must take actions in the more certain present to mitigate future hardship, if at all possible. 

Consider pausing collision insurance on fleet assets, like school busses or dormant DPS vehicles. Before you do, fill the entire fleet up with historically inexpensive fuel, and even try to buy future fuel contracts. Adjust your HVAC controls. Turn off ISPs and cable TV access for buildings not in use. Renegotiate payment terms with vendors, including discounts for early payment terms. Nothing should be off the table. It’s time to re-evaluate everything!

In our experience, chaos breeds opportunities, and there is no time like the present to start addressing an uncertain and ever-changing future.

Need help or ideas? Contact us! Always happy to have conversations and explore scenarios! I can be reached personally using bob@munetrix.com, or leave a message at (248) 499-8355.

Education, Fiscal Health, Municipal, News, Press Releases

Munetrix Provides Live, Interactive Map of Coronavirus Cases to Any Government Agency at No Cost

Free Embed Code Allows Governments to Provide Visualized Map for Any Website

Munetrix, a data analytics solutions provider serving municipalities and public school districts, has developed and launched a visualized map that renders live coronavirus cases data by county, and is making the map available to any municipality, county or government agency that wishes to embed it on its own website.

The Michigan Association of Counties was the first such organization to embed the map on its home page, and since then, more than ten others have embedded the map, including regional councils of government, counties, cities and more, representing more than 5,000 cumulative user views of the map in total as of April 13th.

The interactive map visualizes various data in a live, interactive and scalable manner, with various ways to render the most recently reported government data, including the number of cases, the number of deaths, as well as cases and deaths per 100,000 population, which is sortable by county, council of government and other geographic criteria, as set by the user.

“Access to updated, actionable information is critical right now, both for governments and the constituents they serve,” said Bob Kittle, President and Chief Executive Officer of Munetrix. “It’s vital that the data be visualized, easily understood and widely accessible, as leaders, administrators, health departments and the general public alike make critical and, oftentimes, life-or-death decisions during this COVID-19 pandemic.

“We felt, as a data visualization company, it was our duty to do whatever our technology would allow to deliver that intelligence to those who need it, and to make it easy for anyone to display, use and understand,” he added.

Munetrix will provide a copy-and-paste embed code at no cost to any agency or government entity that would like to display the map on its own website. Simply contact Munetrix or the Michigan Association of Counties to submit a request.

About Munetrix

Auburn Hills, Mich.-based Munetrix, among the nation’s largest aggregators of municipal and school district data, promotes municipal wellness and sustainability through its cloud-based data management tools and proprietary performance management applications. In partnering with Munetrix, municipalities and school districts are able to manage their data and access cost-effective products and advisory services to make meaningful and reliable budgets, financial projections, trend reports and better-informed forward-looking decisions.


Fiscal Health, K-12, Municipal

What Can We Learn from this Forced New Reality?

Municipalities and School Districts Finding Need to Modernize Systems, Processes and Technology to Cope, Collaborate and Conquer Uncertainty

By and large, municipal governments and public school systems are doing admiral and applaudable work during this crisis that was suddenly thrust upon us all. From communicating to constituents with timely updates and critical announcements to establishing remote, virtual working and learning environments, what many have been able to achieve in such a short, compressed time frame is nothing short of amazing.

Of course, things haven’t been perfect. And some communities are coping more easily than others. But considering the circumstances, the early returns for most are encouraging, even as they are dispiriting. “We’re all in this together,” is a mantra we keep hearing, and it’s an important one to keep in mind as events continue to unfold.

No doubt, the cracks are starting to reveal themselves. Educators are confronting and working to overcome obstacles, as local governments are rising to meet previously unforeseen challenges, many seemingly unimaginable just a few short weeks ago. And while some of these newfound hurdles must and can be immediately cleared to keep our communities and schools operating, others are larger than what can be remedied in the here and now.

And therein lies both our collective challenge and opportunity: Take stock—there are lessons to be learned, and there are future decisions to inventory.

Prioritize and Triage Your Newly Discovered Vulnerabilities

In the short term, no doubt many school and municipal administrators are struggling to keep their heads above the proverbial water. But all water eventually finds its level, and there will, at some point, be an adjustment to this new normal, if only in parts. 

Some day, believe it or not, we will all get back to the old normal, and when we do, we will emerge more aware than ever of the challenges, vulnerabilities and downright deficiencies we were once willing to live with. We should use this opportunity—and the respite we’ll receive when we get back to “business as usual”—to take stock of the most critical cracks in our armor, knowing that the next crisis may just as quickly and just as critically present itself without warning. Will we be ready next time? Only if we start preparing today!

We encourage all municipal and school district administrators to document any discoveries they make relative to challenges they suddenly face, which may not have been quite so obvious when things were closer to normal. And we further urge them to encourage their entire staffs to do the same. 

Some challenges we expect many of you are struggling with include considerations such as:

Is there a remotely accessible knowledge bank for all to leverage? Or is critical data and information locked in desktop software on a computer that is suddenly behind locked doors? Or, worse yet, is there data, information or knowledge literally locked in a desktop drawer somewhere—as in, physically? Financial, operational and analytical knowledge, if it’s not already, should be accessible to anybody who needs it, wherever work may take them (in good times or in bad).

Are there tools and resources readily available to assist in the critical decisions we need to make in times of crisis? For example, many school districts need to make nearly instantaneous decisions regarding how and where they distribute their free and reduced lunch programs. A database that can instantly cross-sect demographic data based on need is a critical resource to efficiently answer questions, provide intelligence and inform critical decisions, in a whole host of applications and use cases.

How do we manage projects and teams when we’re all working from home? Significant projects, tasks and undertakings typically require the careful coordination of assets, budgets, personnel and calendars. This isn’t nearly as challenging when teams can convene, share physical project assets, and interact fluidly. But what about now, with no two people working in any single location? Project management software should facilitate collaboration, cooperative planning and dynamic budgeting, and even allow for asynchronous, a-geographical communication and coordination. Projects that have been long in the works might need to be urgently migrated to such third-party planning tools…then migrated back once we all get to enjoy some semblance of normalcy again.

What is our organization’s level of emergency preparedness? We’re re-learning during this most recent crisis just how quickly facts on the ground can change the modus operandi. What one day seems unimaginable and draconian may tomorrow feel necessary and intuitive. Coordinating, monitoring and documenting emergency preparedness and safety drills will be increasingly critical and, likely, more widely mandated in the future. Some of us are old enough to remember a time when “active-shooter lockdown” drills weren’t deemed necessary, but nuclear fallout drills were. And today, we are sheltering in place to escape and minimize viral infection. It’s important now more than ever to ask and answer: Will our systems and resources make such compliance and transparency easier, or more difficult?

Address the Urgent. Document the Important.

While we fully expect the cracks in the foundation to be showing (who in this world is today not waking up to new vulnerabilities and challenges?), we don’t expect that they be addressed and remedied overnight. Nor should they be. Sometimes, the decisions we make in times of crisis prove to be overreaches down the road.

But we can triage. We can document everything, and we can prioritize initiatives against considerations of urgency, impact and effect. Some challenges need to be immediately overcome, such as remote learning and virtual working environments. You’ve already taken steps in those regards. There will be more to consider. But you won’t be able to plug every hole in the dam at once.

Use this time to observe, to reflect and to take stock. Eventually, there will come a time when all (or most) of these challenges can and must be addressed. If we want to optimize our operations in preparation for times of crisis, we should modernize our technology, tools and resources now—once the dust of this current crisis clears. We will all need to rethink our priorities, plans and processes, not only to avoid future pain, but to attain an evergreen optimization of data, knowledge and valuable resources that represent the lifeblood of our communities. 

We must create a roadmap for tomorrow’s success, even amid today’s pain. There’s no better time to plan for that than the present, when we are right in the middle of it.

To join a no-cost Webinar that illustrates the capabilities and applications of the Munetrix ProjectTracker app, please register today. We plan to share tips and best practices for managing projects, personnel and budgets remotely.

If you have any questions relative to your community’s preparedness or data management capabilities, please do not hesitate to contact us.

1 2 3