Gorham Joint Finance Committee Advances Fiscal Dashboard and KPI Plan
Speakers labeled via automated voice-based diarization + AI name-matching against the city's official roster. Automated transcription can still mis-hear a name during fast speech (e.g. a rapid roll-call vote) -- clear near-misses are auto-corrected, but this is not manually verified line-by-line. Treat names as a strong best guess, not an official record. Home addresses that residents give are left out of this page.
[0:07] Speaker A (unidentified): Welcome, everybody, to the Special Joint Finance Committee meeting. Today is Thursday, October 22nd. I believe we have all three Town Council Finance Committee members here, all three school committee members here, and one of our two committee members from the public, Christy Damon, is in attendance, as well as the town manager, and we expect the superintendent will hopefully be joining us shortly. With that, we would go to the minutes. we've got two minutes to look at attachment 1a and attachment 1b from July 16th and July 23rd to
[0:46] Speaker B (unidentified): accept the minutes to accept a second from
[0:51] Speaker A (unidentified): counselor Hamlin all in favor of accepting the minutes are we doing both sets of minutes or moving to current business so on here we've got continuing to review key performance indicator data. Am
[1:11] Speaker C (unidentified): I shifting this to you?
[1:12] Speaker A (unidentified): I know, Michelle, you were going to look at some stuff, I believe, after the last meeting.
[1:17] Speaker D (unidentified): I have, actually, quite a benefit that I'm just not here. Heather and I had a quick conversation today. We don't want to lose momentum. I think what we're hoping to get is just some, based on maybe that spreadsheet that was going around and the earlier conversations, direct guidance that we can give to our staff and just bust something out so I took one of the spreadsheets I had today from the fiscal sustainability committee I'll pass it out here in a second they had a bunch of graphs and charts and have some of the things it could be KPI it's not saying these will be the KPI's punch it into AI that's why it seemed it's not it needs to be a little finesse the data is kind of there but I think this is where you had hinted you wanted I'm having just a simple dashboard, and if we could just get the where you want to go and which ones you want. I just want to unleash the staff, and I got the impression that Heather does too, on where are we, which ones, and then we'll take a crack at something. And this is just something that I came up with today, really needs to be finessed. Don't freak out that it shows certain curvatures with school versus towns. I think that's what we'll have to really look at. Is this kind of what you're envisioning, and can we make it into a document that can live with the town and grow with the town, put on a website, all that stuff? And maybe I'll, I have the director of the community college asking me today what they can do for GORM, and I was like, oh boy, do I have a project for you. So
[3:05] Speaker E (unidentified): just reminding, this would go on the website, this pull-up, when people went to the website, or would they have to click somewhere in the text?
[3:15] Speaker D (unidentified): I think there was a couple different ideas that were floating around. One could be just a dashboard online. One could be a part of a budget process. One is just keeping the data and rolling it from year to year to year. I would want to put this in the town's budget, and I'm guessing Heather may be in some documents that the school does too. Again, this just pulled out of my spreadsheet, so this is not me advocating for any KPI or anything like that. But whenever we do something, it could just be something, and the impression I got from the full committee and this committee, something that we can roll out from year to year is just tracking the same items that may be a little bit, some different components from time to time, but it's just a constant so the public knows based on that. Yeah,
[4:06] Speaker F (unidentified): I think this is exactly, I mean, from a look perspective.
[4:09] Speaker G (unidentified): Yeah, this is a look thing.
[4:12] Speaker D (unidentified): This is don't take the data.
[4:13] Speaker F (unidentified): Yeah, I think this is really like what we were hoping for.
[4:16] Speaker D (unidentified): Because Heather won't like our data
[4:23] Speaker F (unidentified): So one of the things that I had done in between meetings that I had hoped to route before this meeting but it just didn't get there was I had compiled a spreadsheet which Efrem just mentioned that I had done that included the list of the KPIs that we had and like just some quick links like their definitions a little bit more information and then I had my suggestion was could we rank them all of the members rank them and that would help us just to quickly identify these are the ones that came to the top these are the ones that are less important are there any that we need to cut and then that would be like here you go this is your list and then from there I think it would be a matter of then setting up like the David what we were talking about a little bit ago before we started was just around how do we how do we frame this for the next committee to take over like what and then they do with the dashboard and the KPIs and the communication aspect of it so
[5:23] Speaker A (unidentified): yeah I think this is great I got something very similar from somebody who lives in Harrison that Harrison they have a residence in Gorman and residence in Harrison and Harrison published something that visually looks a little bit different but it's kind of the same idea that I think they threw some KPIs into AI and it kicked out as pretty graphic and they were like really impressed and happy about the communication that they were getting from that community so I think if we can have something like this that if it's getting pushed out during the budget season and available online I believe and somebody on the original committee will have to remind me I think one of the goals was to your point Charlie like having the website that could get pointed to from both the school side and the town side that is sort of around fiscal sustainability that we have some of those indicators living there all the time in addition to potentially being a part of the budget packets and so forth so you would have to kind of go looking for it but we could also push it out
[6:23] Speaker F (unidentified): there a little bit. I think the other piece too just off the top of mind for me what you said is connecting these to our budget processes and just as a heads up we've done that as we've started even already for next year so like the percentage of school budget covered by non-property tax revenue we've like explicitly added that into our data request we already did that you know the operating expenditures of per pupil but that was one that was missing so I think just making sure that somehow we are recognizing that we're actually using the data points in the budget process too so not just in that silo of a dashboard it
[7:01] Speaker E (unidentified): makes sense just add the value of the mill rate or something like that so people could calculate it on their own how they can compare it to the media.
[7:19] Speaker D (unidentified): Yeah, we can do that. This just pulled randomly from my spreadsheet. This wasn't all they approved.
[7:25] Speaker F (unidentified): These are not actually in the data form.
[7:27] Speaker H (unidentified): I would have probably one of them.
[7:32] Speaker D (unidentified): Heather's not going to like this. This federally came from just a conversational spreadsheet that we had, not the KPIs. More for a visual.
[7:39] Speaker H (unidentified): I like the visual. The visual is great.
[7:44] Speaker D (unidentified): But I feel, I think Heather and I decided, the committee decided on KPIs. The one I would just pitch for is we need something that shows the long-term tax trajectory in whatever form, for a property form, so people can actually see, yeah, we see spikes and stuff like that, but this is the history of our taxes. and is it as bad as we think it is or are current times and inflation just making it that much worse when you look at the long term perspective it's kind of growing normally something like that whatever it is
[8:22] Speaker F (unidentified): would that be the property tax for average homeowner
[8:25] Speaker A (unidentified): you're essentially advocating that middle graph just showing up somewhere
[8:29] Speaker F (unidentified): I have a spreadsheet that I had done with all the KPIs
[8:33] Speaker G (unidentified): I don't know if you want to put it on the screen
[8:34] Speaker F (unidentified): so people can just have a list of what the KPIs that we're discussing are I can't remember how to connect to that.
[8:42] Speaker D (unidentified): So, you have a Mac, and I'm hoping that our friends at GoCAN might hear me talking and
[8:48] Speaker H (unidentified): come down. And you'd have to install a little... There's a...
[8:51] Speaker D (unidentified): We don't use Mac on the tablet side, so there's a process.
[8:54] Speaker H (unidentified): Could you email it to...
[8:55] Speaker F (unidentified): Yeah, I mean, I sent it... I can send it to you. I'll send it now.
[9:00] Speaker I (unidentified): That'll make it an easier tablet, so we'll try.
[9:04] Speaker H (unidentified): You know what? Actually, I think I can do it, because I can download it.
[9:07] Speaker D (unidentified): There's a special thing just for Heather.
[9:09] Speaker H (unidentified): Yes, I did download that.
[9:10] Speaker F (unidentified): So as long as I... Oh, shoot. Send you both. Look at that.
[9:14] Speaker H (unidentified): Listen to that. Stop that. What were you setting you up? We did... Well, it might be better to set him up because I don't have a...
[9:21] Speaker D (unidentified): I have an Android device.
[9:23] Speaker J (unidentified): Yeah, so you don't have to... So we use Roku for you.
[9:26] Speaker K (unidentified): We use ClickShare for you. Okay.
[9:29] Speaker H (unidentified): And I don't have... Who's going first, Steph or not?
[9:32] Speaker F (unidentified): I just sent it to both of you, so...
[9:35] Speaker J (unidentified): We have one more of the... Let them figure it out.
[9:37] Speaker H (unidentified): Oh, we're here. Yes,, absolutely. [Speaker E (unidentified): I have to] go upstairs and get a doll. I can meet you if I go up and get a doll.
[9:50] Speaker G (unidentified): What do you need for a doll? No, it's okay. I'm curious.
[10:13] Speaker E (unidentified): Is it possible to compare the taxing versus Scarborough or something? Only in certain
[10:25] Speaker D (unidentified): mill rates are not easily compared. You could do like cost per population, where cost for operational services, it's just it's hard because everything's different. Unlike schools where the state has it set up, you can pair everything. Towns are just all over the place, and then when you throw in like Scarborough's got like six or seven billion more in value than we do from their fancy waterfront in Rouen so we can take a crack at it 's just better if they're more easily compared like a neighbor that's like a window so we know this
[11:05] Speaker G (unidentified): window is just closer to us that kind of thing I thought we did talk about trying
[11:23] Speaker K (unidentified): to put together a number I think maybe you just alluded to it about like we have per pupil cost and sort of per resident cost of town services even if
[11:36] Speaker D (unidentified): it's not a comparison it would be a good historical how are we doing as the town grows are there is a cost of our services remaining relatively stable per person or is it skyrocketing or if it is you know skyrocketing yeah this is the you're crazy and under stabilized what I hear most from people is taxes are too
[11:58] Speaker E (unidentified): high I've been hearing that for 50 years and I think you always hear so I'm just looking for well compared to other people as we're in the ballpark we're not in the ballpark kind of thing so that can kind of try to head that
[12:12] Speaker D (unidentified): off a little bit I think those some of the KPIs can be modified so
[12:22] Speaker F (unidentified): he pushed background modifying KPIs at this point, right? We're so far that we've defined, you know?
[12:28] Speaker D (unidentified): Or maybe modify, I think some highlight it better than others, would be maybe a better statement.
[12:34] Speaker L (unidentified): So maybe, a suggestion, because I read, I wasn't here last, for the last meeting, but I read through the agenda. So as someone who does this every day in my job, can we start with where we have common ground? Because we had talked about five, but I think this represents seven pretty well. Well, seven if you include the key takeaways at the bottom as being like a metric, which would be more changeable based on where we are at that point in time. But I think this general idea of six with the takeaways works well. Can we agree on that? And then maybe before we narrow down to specific KPIs, is there an allocation we can talk about between like how many should be school focused versus overall budget focused or tax rate by focused maybe we want one comparable metric and then that would help us kind of narrow down to how we go about deciding which metrics would be
[13:26] Speaker F (unidentified): highlighted here give eight caveats just as a reminder so we only really would
[13:32] Speaker G (unidentified): have to eliminate two yeah sure I like you on one page is a wonderful thing yeah no reason to go into multiple pages yeah absolutely I was just going to
[13:43] Speaker C (unidentified): offer that maybe to get a point of being able to compare to other school districts or other towns if we had you could just not create a different graphic but you have a three percent growth benchmark but you could also have a you know an average we have a 10 town average of a cumberland town you could have that also to provide it would provide some comparison
[14:06] Speaker B (unidentified): right if we're above or below that well what i'm hoping i think that's what most people
[14:13] Speaker E (unidentified): want to yeah absolutely that percentage is kind of interesting to me but i'm not sure
[14:17] Speaker B (unidentified): everybody is going to get excited about yeah unless you have something to compare it to
[14:22] Speaker D (unidentified): yeah right that's true right what would i be optimistic with gp cog because one of my goals from the council is to work more with them and get more out of them and the timing today is perfect they have made dashboards for communities already that are more just dashboards I can get them to do something with the KPIs, whatever you decide, and we figure out what you want to do. In the general framework, you can add those add-ons within the KPIs, assuming the group was okay with it, of the comparison. So if you wanted to compare and we had the data on debt ratios and all that, people could get in there and interactively play with it if you wanted to dive into the weeds.
[15:09] Speaker E (unidentified): That'd be cool for some people. I'm not sure how many. but
[15:14] Speaker C (unidentified): more than you think the circles ripple out on these specifically to me the one of the other we've got two that basically tell us the same thing the local tax appropriations in the upper right hand corner and the graph they're basically telling us the same information so I don't know if that gives us some space to add one of the other ones who are I don't know if you
[15:34] Speaker F (unidentified): caught this part so this is just a visual the data point so it's not here not real that's why we're trying to pull up some things that we had
[15:42] Speaker D (unidentified): had initially in the whole committee talked about, but it's not anything that the community is like, yeah, we want this. But yeah, you could... My goal with this was for a simple dashboard would something like this work, and could we finesse it at the end of the day and keep a template running?
[16:00] Speaker A (unidentified): I think this is great. Do we have... This is a jumping-off point.
[16:09] Speaker F (unidentified): Some of our KPIs that we're getting on the screen. soon. Do fold it nicely here. So I just kind of mapped what matches in my perspective from a data
[16:23] Speaker A (unidentified): perspective. So I think. Well,, Georgia's getting that up and running. I'll fill the air with one thought that I have that this may be a good time to talk about. One suggestion I have for anybody who's on the committee next year, knowing that things may change in November and committees may change and we have some holdovers, I think we should actually have a chair of this committee and somebody that is both leading the meeting and also helping to craft it. Right now it's been sort of us and I talked to get the meeting started but I think it'd be good to have somebody that's a little bit more of a point person beyond just we show up in the room and all kind of start from where we left off from the last time. So I think that would go a long way And then I had suggested to Michelle before that we try to have a couple of benchmarks that they're trying to hit. So, like, maybe if we're saying we'd love to have this and the KPIs all identified and ready to go for the next budget packet, as of, for instance, and a website up by you name the date, so that we have a timeline that we're trying to meet in this. It has felt to me a little bit this year that, you know, we're just kind of getting together and talking about it and slowly moving the discussion forward. But I felt exactly, it sounds like you guys did coming in your joint meeting, that, you know, we've got to take a little bit more of a jump forward rather than just kind of creeping forward the way it's gone so far.
[17:50] Speaker L (unidentified): What does that look like to have this available for the budget cycle this year? What does the timing look like on that?
[17:58] Speaker A (unidentified): I would look to staff for that.
[17:59] Speaker D (unidentified): I would think the KPIs themselves, that's not a huge thing. The graphics should look like maybe there's some flexibility that the graphics could look a little different. But each budget book or maybe you want the same template, I don't know. An interactive website will take a little while. That might be a spring thing. Or maybe we could try for the budget process or maybe the conclusion of this year's budget process would be a better date. Perhaps things like that.
[18:39] Speaker A (unidentified): It seems like a lot of this data, well, that data that we're going to talk about already mostly exists. Is that fair? Oh, yeah. The KPIs. So if the goal is to narrow them down and then be able to get them on a sheet that looks like this, I would think that could happen fairly quickly with the assistance of AI and a little bit of fact checking. I
[19:02] Speaker D (unidentified): think what AI is, AI is good at giving us a template and then let the staff actually do something and then just make it, and that way we're not going to trust AI. Yes.
[19:12] Speaker G (unidentified): And you shouldn't. You're not. I don't know. It does weird stuff.
[19:16] Speaker D (unidentified): But it's good at just printing out some pretty stuff and kind of giving us something wrong.
[19:22] Speaker K (unidentified): That's what I learned in the webinar yesterday was gremlins and some other thing that AI does.
[19:31] Speaker D (unidentified): Yeah. It's weird that it can create something like this,
[19:33] Speaker I (unidentified): but then I said, can you put the town's actual logo
[19:35] Speaker D (unidentified): and it messed it all up, really? I don't know. I don't like that logo. It's very simple.
[19:51] Speaker K (unidentified): about four switches have to be all in the same place
[20:18] Speaker H (unidentified): and this is my mouse but the problem is it's not mirrored
[20:25] Speaker D (unidentified): is your screen extended? drag your window if your mouse is making it
[20:33] Speaker H (unidentified): No, it's not. It needs to mirror. For some reason it's not mirroring. We
[20:45] Speaker K (unidentified): need to figure that out. Well, eventually. Usually it works. Do you need more
[20:52] Speaker H (unidentified): tonight? Should I keep working on this? I think he's going to print it out. Because I don't know. It's there but it's not.
[21:01] Speaker K (unidentified): That's why I rebooted it. We can try it one more time. Action being made.
[21:21] Speaker H (unidentified): Yeah, so it's the connection with the base, you know, it was lost, please return, and now it's connecting, it's reconnecting to the base.
[21:32] Speaker E (unidentified): I'm so old, I remember before computers, and we used to use Greenbar, and everything in the accounting world. I remember the first Apple TV showing up in the office, and nobody had any idea what to do with it. I remember when fax came around, and people would go, oh my god.
[21:50] Speaker H (unidentified): I remember the faxes. I still remember the Mimeo machines. I have fond memories of that, yeah. Every
[22:00] Speaker A (unidentified): classroom had a projector instead of a projector and chalkboard.
[22:05] Speaker E (unidentified): Mine was similar in that way,
[22:07] Speaker G (unidentified): although things still didn't work.
[22:09] Speaker I (unidentified): Right, no, that's right, the projector would break.
[22:12] Speaker K (unidentified): Now at our school, we've been growing up our whiteboards with some TV screen. I think that's what we have now. All our whiteboards are covered up after we got whiteboards and projectors. Is
[22:34] Speaker E (unidentified): everybody excited to have the election behind us?
[22:37] Speaker H (unidentified): I would be glad to get my TV back. Oh my gosh.
[22:40] Speaker J (unidentified): There's going to be a Coca-Cola commercial again. Oh my gosh. It's overwhelming.
[22:45] Speaker B (unidentified): Some of the language in the attack ends at like 2 o'clock in the afternoon.
[22:49] Speaker A (unidentified): We need a football game. Oh yeah.
[22:52] Speaker I (unidentified): They use my kids in the room.
[22:54] Speaker A (unidentified): It's like, it's bad.
[22:56] Speaker E (unidentified): I don't know what happened. I guess it's always been bad, but it just seems worse. [Speaker K (unidentified): No, it's worse.] We used to have a lot of papers there.
[23:03] Speaker K (unidentified): We didn't have no ads because of that.
[23:07] Speaker G (unidentified): Have you seen one of these?
[23:09] Speaker H (unidentified): Oh, you know what, I'll know.
[23:11] Speaker B (unidentified): It's been interesting. My YouTube must get confused.
[23:15] Speaker I (unidentified): Because it'll show me, like, an ad from, like, Ohio or
[23:19] Speaker B (unidentified): Tennessee or something.
[23:20] Speaker J (unidentified): The location is off, or it's...
[23:22] Speaker E (unidentified): I'm like, I'm watching it on the same device. Like, I have a Troy Jackson that's, like,
[23:32] Speaker I (unidentified): got aired in Portland, Oregon. So
[23:38] Speaker F (unidentified): I could send this digitally to everyone too, but the actual digital file has descriptions, so if we need a refresher of what something meant, it was included in the digital file just so that it was accessible. So those were the eight KPIs that came from the initial fiscal sustainability report that the committee had narrowed down in their process. process. So I included discussion notes of things that we've said about each of those. KPI is just like a top level, it's not too descriptive as you can see. The type of data that it is, like how we would reference it, like what are we measuring against, that sort of thing. And then if there's a target associated to it. And then there's a link to the report board which you can't click because it's paper so those were the eight so
[24:45] Speaker E (unidentified): you talked about like trends are comparing year over year it's just so we can see the growth there
[24:52] Speaker F (unidentified): yeah so like for example on nine like that one would be it says upward trend i don't know that was just notes that i had put in i think all that was up for discussion to be finalized but or if you're looking for growth like percentage of overall municipal value like are you looking Are you looking for growth? Are you looking for negative growth? Like, that's what would have to be, I think, further clarified.
[25:16] Speaker L (unidentified): But maybe what you're asking is data type and data reference, where some of them would be growth rate that we would want to demonstrate, and some are the actual, like, absolute number. Number. Right. Yeah. And then the reference is calling out where the growth rate would be against itself versus where we might try to find a peer group to compare against with absolute numbers. Okay.
[25:38] Speaker F (unidentified): My mind works. I need to compare. Yeah. Yeah, that was what column E was intended to be, which is the data reference. So I don't know, I just marked up this sheet, so I'll just maybe, if it's okay, I'll just keep talking until someone else does it. So my recommendation is that if we modified this dashboard, I would like, I think the per-pupil expenditures goes in this upper left where we have that dollar figure. here I think per resident cost of town services would go nicely next to it and then the total town and school on the right hand side total town school operating expenditure so it kind of puts our per pupil per resident and then our total operating centers in the very top then the big graph across the middle I would say the one that fits to me best there would be property tax for the average homeowner so like how could the average person see the history of the impact to them and then lower bottom left the percent of town budget covered by non-property tax revenue and then to the right percent of school budget non-property tax revenue which means I preferring to cut the last two data points so the one about the non-residential property is total property and the TIF. So, I don't know.
[27:03] Speaker E (unidentified): I like your suggestions. Get rid of those bottom two.
[27:07] Speaker F (unidentified): Those to me are just, yeah, the ones that I feel like are the most comprehensible and really could be easily explained.
[27:15] Speaker G (unidentified): It takes a lot of questions. What does that mean? I
[27:22] Speaker L (unidentified): think the percent of non-residential property as a percent of total property could easily work in as a comment to either of the budgets not covered or covered not by non-property if
[27:44] Speaker D (unidentified): I am successful in getting GBCOG to do a bunch of work and more comprehensive like interactive website or something like that not like a one-page static thing from year to year would the group object to keeping them as the other two as items that could just be out there we're tracking we should keep it because i can see two different groups at the end of the day any typically non-residential brings in more than it costs us not always but it's a metric that internally at the town we track and should continue to track and should engage ourselves on as we grow but maybe the public might not care about it or may not be applicable to our budget process and then the tips are where tips have been keeping us afloat for a couple years now and but what i like to track and what i have in the spreadsheets somewhere is how are we doing comparing other municipalities to make sure we're not as dependent or more dependent than other communities and right now we're actually right on par with other communities a certain percentage that they're locking up in TIFF. So that's always worried me in my area that people become too dependent on it or something like that.
[29:04] Speaker J (unidentified): I'm wondering, I'm going to say something. I'm not, like, I don't know technology, so I'm going to put a word out there. Like, I wonder if there's any way to do almost like widgets where they can, and I know we said we wanted to keep them to a certain amount, but if they could customize kind of ones that they're interested in or, you know, I know that we're, like, trying to make, like, one-pagers, but I'm also wondering if we had just some options and things that they might want to track and because you're right like I think this is the hard thing about a lot of stuff everybody's gonna want something different and you're trying to meet everyone's needs but I'm not saying we need to go like have an exorbitant amount of options but just being able to kind of view it they can select how it's viewed
[29:56] Speaker D (unidentified): be an awesome resource for all the communities to have a benchmark that GBCOG can track it and we'll just give you the data and blah so that's why I'm trying to sell it.
[30:09] Speaker B (unidentified): Go ahead. And when we give them the data would it be able to request you know that when there are
[30:16] Speaker D (unidentified): like aberrances you know like when you hover your mouse over it with like this is a revaluation year but you know or whatever that's easier to do than what you described
[30:31] Speaker I (unidentified): but i think it's a great idea though to your point it could that could live on the website i
[30:37] Speaker A (unidentified): mean there could be more than six there i sort of look at those as two different things this is like the easily digestible the general taxpayer who's not looking to dive real deep in the numbers can see this and comprehend you know what they're looking at in five minutes right where
[30:54] Speaker H (unidentified): Could that go with the tax bill? What's that?
[30:56] Speaker F (unidentified): Could that go with the tax bill? Like could we print that and send it with the tax bill?
[31:00] Speaker B (unidentified): We could send it with the tax bill.
[31:02] Speaker D (unidentified): That's a political town council question. But yeah, we could send anything with the tax bill. I would, my only advice would be let the tax base and the taxpayers order that coming because the last thing you want is they're trying to sell us on our taxes. Yeah, very true. you really you really have to get that out there and have the public used to it as almost expect me like I want to see this you know how we're doing yeah so
[31:33] Speaker E (unidentified): we're really interested in comparing ourselves to other towns is it worth reaching out to GPCOG first to see what data they might have to help point us to what we want here because if we have a KPI and nobody else has the data it's
[31:48] Speaker B (unidentified): hard to compare when we do comparisons it would be easier if it was a regional
[31:52] Speaker D (unidentified): Because when I go hunt data, I have to interpret. On the school side, you don't have to do this as much because it's all the same format. The towns, we have all the different budget books and formats. And some lump everything together. Some don't. Like ours are itemized. Some communities are just loading up blocks. So it's hard to get that accurate data unless you're looking at state data. But I think we're in a good spot now.
[32:21] Speaker A (unidentified): And what would probably happen is, so GPCOG, there's the committee that I sit on and then there's like a managers group right that connects and so if you get buy-in from GPCOG on this theory they're going to take it to the other municipalities and say hey here's something that we're offering now and maybe they can offer the data points that we're using right so like then they can collect their information and we could have some
[32:44] Speaker E (unidentified): comparative data everybody starts sharing and all of a sudden everybody
[32:48] Speaker D (unidentified): saves a little time exactly makes more meaningful data until one time doesn't look good with everybody else a day and they stop sharing right that'll that'll eventually happen
[32:56] Speaker E (unidentified): well it's good they should fix their act that's why we're doing this
[33:07] Speaker C (unidentified): another thought and once we see what it looks like i think easier to contemplate but some of these metrics like the town total town school operating expenditures without the totals i don't know like without the totals on the same page, the percentage, like you have the total of operating expenditures but that's not the total budget right? It's not capital
[33:33] Speaker H (unidentified): expenditures or is that both? If I were to read that right there I would say the total school operating
[33:39] Speaker C (unidentified): expenditures would not include SIPs and not include... Right, so I'm just saying without the total to compare it, I'm just saying there may be some other pieces of data that are just constants that aren't filterable but like some there are some things I don't know what the percentage is of the total budget by
[34:06] Speaker F (unidentified): looking at this. I'm just referring back to the notes on it. So what it tells us, it reads, this indicator is a broad measure of the town's yearly operating expenses. This figure includes operating expenditures for the town's specifically not include capital debt or outside grant funds. I think it was that we would like to see fluctuations range against consistent CPI fluctuations.
[34:27] Speaker C (unidentified): Yeah, and I led that car, I think I was in, yes, but we just have to say that somewhere here. Yeah, yep. So people know, like, what do you mean? I thought our budget was $60 million, and nothing here ends up with $60 million. So how do I, like, this doesn't make sense to me. You're just, you know, pulling the wool over my eyes because this isn't the real numbers.
[34:48] Speaker F (unidentified): I think it's key to define each KPI, like have something that's visible, like, again, like with the tech side, click it or hover over it, and you see what is the definition of that very clearly maybe not even something that you click maybe it has to be on the dashboard at least to start that's what I mean that's somewhere like
[35:04] Speaker C (unidentified): it has to all be add back up to yeah or it's not we're just gonna dismiss it so
[35:09] Speaker E (unidentified): maybe that's page two originally support that until we can get that other feature
[35:14] Speaker A (unidentified): which would be amazing but for those point you could put a little star underneath the metric and just say here's what makes up the data point of looking at, or just a note or something, because otherwise somebody's going to take this and share it and go, this is junk, because if the math doesn't math, then they're trying to trick us, which is the opposite of what everyone in this room is trying to do. That's a good point. Yeah, I think the committee can take a longer look at that, Jimmy Bogg or whoever comes up with something here, and just maybe double check that, but maybe put it in the notes if our note takers listening to have on the agenda for you know what this is night of that I think that's really important to look at so that whoever that committee is I was
[36:07] Speaker D (unidentified): writing down notes on my sheet I missed the upper right-hand
[36:10] Speaker F (unidentified): corner which KPI that one was the total town and school operating expenditures
[36:15] Speaker C (unidentified): what we're just talking about you
[36:21] Speaker E (unidentified): think the reactions are going to be from people with me but this is done Do you have somebody to call to answer? If you have questions, you should send your information to XYZ because there are going to be people asking the question. Two
[36:44] Speaker D (unidentified): questions, I think. The initial reaction is I think probably the majority of the public will find it helpful. I think there will be an initial reaction kind of to the you're trying to pull the wool over our eyes, you're trying to justify the tax increases. I think that's a natural reaction. And we could definitely put a, you know, if you have questions, reach out to, you know, whatever we decide at the superintendent's office, county's office, and then links to here's our budget information, if this is a standalone, you know, for more information to visit this.
[37:14] Speaker C (unidentified): Or there's an FAQ, if you frequently ask questions, like attachment or something that answers the 10, you know, we could probably anticipate what the most common questions are going to be.
[37:26] Speaker F (unidentified): Would that be a role of the future chair to, like, again, to give the committee more, I don't know if that's normal for a chair to be the person that responds to community questions about something like that? Or if it's more staff?
[37:38] Speaker H (unidentified): I'm sure that kind of details the staff.
[37:40] Speaker D (unidentified): It's usually kicked to the staff. I think that's just a, and it's because the staff, for whatever question, have the expertise. we occasionally come up with the trash rollout i think maybe we that made it to me on how is this being funded how are you doing this i'm confused can you explain how this is being paid for but i'm sure there was way more questions out there people just tend not to ask just assume right
[38:18] Speaker E (unidentified): but if we can build interaction so if you have a look at that and know somebody contacting an answer I think that's a plus for everybody. Instead of frustration, I don't understand what that means. You spend too much money.
[38:31] Speaker A (unidentified): One thing we may want to consider doing is reaching out to the warm times before this comes out, too. Maybe they would highlight the work of the Fiscal Sustainability Committee and that they're coming out with some information. I think generally the public appreciate the communication and the information, and having it be easy to find instead of pouring through
[38:55] Speaker I (unidentified): large budget books on both sides I think most people don't read
[39:00] Speaker A (unidentified): all of that but like this you can quickly grab some data so I'm sure there may be questions but I think most people would appreciate just the transparency of it but the Times may be willing to do something
[39:16] Speaker J (unidentified): Are there forms too? Like in the town office that you can just grab, there's like a stack. Like
[39:26] Speaker D (unidentified): budget information? Yeah, like that. If it's a one-pager, yeah, we'll print it out everywhere. Little Falls Activity Center, where there's a lot of seniors. I mean, yeah, library. Simple stuff. Unfortunately, just given the physical constraints in the world we live in, like our budgets are so complex and so thick now, we used to just have copies laying around everywhere, but it's just so much wasted paper and expense, and it just costs us money when they do it all the way. But if somebody comes in and asks, we'll print one out for them. That's not a problem.
[40:00] Speaker K (unidentified): We'll have a new communications director to help take care of this, right? Yeah.
[40:05] Speaker D (unidentified): Somebody in that role. Won't be right on January 1. No. Just managing expectations.
[40:15] Speaker A (unidentified): Without necessarily taking a vote, are we all in general agreement on those six KPIs? and if we're asking staff to get some numbers together and then you're going to work with GPCOG, it sounds like?
[40:29] Speaker D (unidentified): Yeah, so again, I haven't. GPCOG has offered some assistance based on some interactions in the spring, but they're a very interactive group and always when there's a regional component, they hop on it because they want to grow their organization. So I'm very optimistic that I can get some help here.
[40:52] Speaker L (unidentified): But to clarify, we want to grab the data for all eight. Even if the goal is to present six on the dashboard.
[40:59] Speaker G (unidentified): And depending on when you want to meet,
[41:03] Speaker D (unidentified): I'm sure Heather and I can look at who amongst our team or maybe have the expertise to craft something that can be a living document, not just a one-time AI snapshot. Yeah,
[41:22] Speaker H (unidentified): do we have to have a person that does data dashboards for us on student achievement and different things like that? I mean, it's just a matter of being willing to share the information and create the database that's required. I
[41:42] Speaker E (unidentified): think the rebound. I think it's great. Presentation looks good. The KPI is good. Let's jump in. We
[41:53] Speaker F (unidentified): can adjust. Do we need to identify the peer group? I know that was our second item, right? But did we just kind of agree that we're going to lean on GPCOG for that? Or should we narrow down the comparison towns for the ones that we want to compare against peers?
[42:11] Speaker D (unidentified): If you wanted some data this spring, I would pick a couple and we'll see what we can do. if you're willing to wait to see if a larger regional effort that we just get who wants to participate and you're okay with that and we can take that route. It
[42:37] Speaker F (unidentified): may be good to wait because I think if we also see the sample dashboard or whoever the committee is that sees the sample dashboard something might change like that we might look at the data and be like that's not going to serve us well and we need to think rethink it so maybe we don't go to the next step until we
[42:51] Speaker C (unidentified): are sure but like we have the average cost of pupil data like that exists like we have some of the data we just have yeah and so there may be other ones i don't know all of them
[43:02] Speaker H (unidentified): but they're that one's easy one right line four is the per resident cost for county services and the property tax average homeowner would be those would be brand new comparison figures
[43:15] Speaker D (unidentified): but i mean it could be relatively easy because we're just taking their overall expenditures and
[43:19] Speaker B (unidentified): divide populations.
[43:24] Speaker A (unidentified): I'm okay holding off if others are, and starting with us, I mean, I think this is a good piece to bite off to begin with. Reconvene in whatever form and look at what's there and then see what happens with GPCOG in the future.
[43:39] Speaker H (unidentified): So, to be clear, I'm going to repeat my directions. So what you're asking then is for us to develop another, like, basically a page like this for the next time that we meet that would include the six things that we talked about and then based on that go deeper into making it like
[44:08] Speaker F (unidentified): communication plan around it even yeah
[44:12] Speaker A (unidentified): i think that's a great first step i mean i think whoever can sit back and look at this and we want to talk about timing for that and just inform the next opportunity to get together
[44:31] Speaker H (unidentified): realistic I've already got my stuff when will the committee's change though
[44:38] Speaker D (unidentified): because like I may not I think on the council level where we left it with a lot of the committee's is we're gonna see what those committee assignments are early in November and then our staff will reach out and reschedule meetings you know for our various subcommittees I'm guessing December the earliest would be and I don't know if December's bad month just because we're trying to cram so much in for January I mean to hit to realistically hit the final budget documents for you here earlier like your final rollout version
[45:17] Speaker H (unidentified): would be what so the school committee votes on a budget publicly in the early
[45:21] Speaker D (unidentified): part of April so for at least for a one-page initial document or something you can put into the budgets you probably want it done by february so that everyone kind of
[45:32] Speaker A (unidentified): agree right february or march so potentially this committee could meet in january look at this as a rough draft starting point could meet again beginning of march or somewhere in that time frame and if it gets okayed at that time move something forward that could be a part of the budget documents it sounds like that may be better than trying to hold committees together and then begin middle of November said because we've missed our first week so it's like the second week in November and then the council is not
[46:07] Speaker D (unidentified): gonna set everything up for you 're gonna be two weeks in January seems like
[46:21] Speaker K (unidentified): the right time, like it's before we're really diving in? Well, I know you're in the budgets, but...
[46:26] Speaker H (unidentified): Yeah, but it's before it becomes public knowledge at that point. You know, like, I mean, the public conversations begin with the school committee in March. All March. All March is our favorite time.
[46:38] Speaker A (unidentified): So maybe the suggestion to Danielle and whoever's helping to pull that stuff together,
[46:42] Speaker B (unidentified): like early January and early March.
[46:45] Speaker L (unidentified): Can we... they're going to use Power BI. They use Power BI every day. Can we get the
[46:54] Speaker H (unidentified): Power BI document? That would be, I think, a little step later, just because in order for Power BI to work, you have to create the database that it feeds from. I've got my data, no problem, but I don't have your data, and somebody would have to...
[47:12] Speaker L (unidentified): The Microsoft product. You can't use source data
[47:15] Speaker D (unidentified): from Excel. But I think that's what GPCOG used. I could be wrong that might have been what they did for their value per acre or study that we looked at value per acre sorry it's a catchphrase we used the net positive value of yeah they did an analysis but i think it was powerpoint
[47:35] Speaker L (unidentified): yeah it's a microsoft product yeah it's pretty straightforward too it's much easier than like tableau or something like that yeah i
[47:45] Speaker H (unidentified): think we i mean quite a january date that we even can absolutely have like a piece of you know this kind of thing that would look at it and all kinds of things because before diving into creating those databases what
[47:59] Speaker D (unidentified): color are we going with because we wanted to be attached to the school and we want a neutral color because I can see you like six emails
[48:12] Speaker H (unidentified): going around this one because I think that the whole point of this conversation has been that we're one town so go with the town I like don't I don't really have a question. I like that.
[48:21] Speaker L (unidentified): I like the question. You do now. You just printed it out. Do you have a choice?
[48:26] Speaker F (unidentified): Okay. Whatever goes to the new brand. I
[48:32] Speaker B (unidentified): don't remember either. Yeah, I think, did we take the school's colors?
[48:38] Speaker D (unidentified): On some things. We did.
[48:40] Speaker F (unidentified): We were moving in that direction. Really? The school's colors?
[48:43] Speaker D (unidentified): Yeah. Some things, and then other, I don't know. It was very involved. It's complicated. Yeah, it was very complicated.
[48:49] Speaker I (unidentified): Layers. It sounds like it's the opinion at least of the school.
[48:53] Speaker A (unidentified): of this current committee that there's some flexibility in the color scheme and we'll
[48:58] Speaker I (unidentified): just save this a lot of conversation and tell the next committee tell us differently
[49:01] Speaker F (unidentified): go blue and green and then it's an orange do maroon for the red you know
[49:06] Speaker B (unidentified): so we
[49:13] Speaker A (unidentified): we sort of skipped from 2a to number four but is there any other business that anybody wants to discuss and then we
[49:30] Speaker K (unidentified): had talked about we're not doing the identifying peer group yet because we're going to wait and see
[49:36] Speaker A (unidentified): we'll table that for now you guys are clear on next steps on your end
[49:47] Speaker D (unidentified): sounds like by this deadline Heather will yell at me and we'll get there
[50:06] Speaker F (unidentified): For me it was hard to know like how much do you like, yeah, do you push, you know, I feel like As a co-chair, I don't know. I don't know that I was doing enough, but I tried my best
[50:17] Speaker I (unidentified): Yeah, when you have two quarterbacks, you don't have a quarterback Good to have a quarterback
[50:26] Speaker J (unidentified): We both have done a great job You never know We appreciate you. Thank you for all your work. Yes.
[50:35] Speaker I (unidentified): We did exactly the same as all of you.
[50:36] Speaker A (unidentified): Well, Michelle did more. But I did exactly the same as all of you. But they did a spreadsheet. That's what I do.
[50:43] Speaker I (unidentified): With that, unless there's anything else, I would take a motion to adjourn. So moved. Second. Great. I don't know. We need to vote on it. So thank you, everyone.