{"id":14754,"date":"2024-11-26T09:17:55","date_gmt":"2024-11-26T14:17:55","guid":{"rendered":"https:\/\/www.gcdev3.com\/mwra\/?p=14754"},"modified":"2024-12-06T08:49:07","modified_gmt":"2024-12-06T13:49:07","slug":"fy-25-current-expense-budget-ceb-dashboard","status":"publish","type":"post","link":"https:\/\/www.gcdev3.com\/mwra\/fy-25-current-expense-budget-ceb-dashboard\/","title":{"rendered":"FY 25 Current Expense Budget (CEB) Dashboard"},"content":{"rendered":"<p>In November, Advisory Board staff introduced a new tool to help Advisory Board members abreast of on-going MWRA budget analysis. The CEB Dashboard is a collection of summary tables and data visualizations that seek to provide quick and intuitive understanding of the key budget performance indicators and the opportunity to explore them further.<\/p>\n<p>Each month this dashboard will be updated with the latest figures and analysis.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-14794\" src=\"https:\/\/www.gcdev3.com\/mwra\/wp-content\/uploads\/2024\/11\/CEB-Dashboard_November-pdf-image.jpg\" alt=\"\" width=\"1280\" height=\"960\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>In the upper left-hand corner is a familiar table from the Proposed FY 25 Comments and Recommendations. This table provides the current year-to-date budget for Direct and Indirect cost centers, actual expenses and the variance between those two amounts expressed in absolute dollars and as a percentage of the budget.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-14756\" src=\"https:\/\/www.gcdev3.com\/mwra\/wp-content\/uploads\/2024\/11\/CEB-Table.jpg\" alt=\"\" width=\"816\" height=\"822\" srcset=\"https:\/\/www.gcdev3.com\/mwra\/wp-content\/uploads\/2024\/11\/CEB-Table.jpg 816w, https:\/\/www.gcdev3.com\/mwra\/wp-content\/uploads\/2024\/11\/CEB-Table-298x300.jpg 298w, https:\/\/www.gcdev3.com\/mwra\/wp-content\/uploads\/2024\/11\/CEB-Table-150x150.jpg 150w, https:\/\/www.gcdev3.com\/mwra\/wp-content\/uploads\/2024\/11\/CEB-Table-768x774.jpg 768w, https:\/\/www.gcdev3.com\/mwra\/wp-content\/uploads\/2024\/11\/CEB-Table-68x68.jpg 68w\" sizes=\"auto, (max-width: 816px) 100vw, 816px\" \/><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-14775 alignleft\" src=\"https:\/\/www.gcdev3.com\/mwra\/wp-content\/uploads\/2024\/11\/Heat-map-zoom-in.jpg\" alt=\"\" width=\"309\" height=\"295\" srcset=\"https:\/\/www.gcdev3.com\/mwra\/wp-content\/uploads\/2024\/11\/Heat-map-zoom-in.jpg 820w, https:\/\/www.gcdev3.com\/mwra\/wp-content\/uploads\/2024\/11\/Heat-map-zoom-in-300x286.jpg 300w, https:\/\/www.gcdev3.com\/mwra\/wp-content\/uploads\/2024\/11\/Heat-map-zoom-in-768x732.jpg 768w, https:\/\/www.gcdev3.com\/mwra\/wp-content\/uploads\/2024\/11\/Heat-map-zoom-in-71x68.jpg 71w\" sizes=\"auto, (max-width: 309px) 100vw, 309px\" \/>Cell shading is used to indicate cost centers with the greatest variation from the budgeted amounts. The darker the shading, the greater the absolute variation.<\/p>\n<p>The right-hand side of the Dashboard is dedicated to visualizing the data behind the two cost centers with the greatest variances at the time of analysis.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-14758\" src=\"https:\/\/www.gcdev3.com\/mwra\/wp-content\/uploads\/2024\/11\/Heat-Map-Formulas.jpg\" alt=\"\" width=\"834\" height=\"268\" srcset=\"https:\/\/www.gcdev3.com\/mwra\/wp-content\/uploads\/2024\/11\/Heat-Map-Formulas.jpg 834w, https:\/\/www.gcdev3.com\/mwra\/wp-content\/uploads\/2024\/11\/Heat-Map-Formulas-300x96.jpg 300w, https:\/\/www.gcdev3.com\/mwra\/wp-content\/uploads\/2024\/11\/Heat-Map-Formulas-768x247.jpg 768w, https:\/\/www.gcdev3.com\/mwra\/wp-content\/uploads\/2024\/11\/Heat-Map-Formulas-120x39.jpg 120w\" sizes=\"auto, (max-width: 834px) 100vw, 834px\" \/><\/p>\n<p>An aging workforce along with low national and regional unemployment has presented a multi-year challenge to the MWRA and one that the Advisory Board has consistently noted in its Comments &amp; Recommendations. Thus the upper right-hand side of the Dashboard will be dedicated for visualizing both the deviation in staffing from budget targets (top) as well as the resulting underspending in salaries and fringe benefits (bottom).<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-14759\" src=\"https:\/\/www.gcdev3.com\/mwra\/wp-content\/uploads\/2024\/11\/Personnel-BTA-by-period.jpg\" alt=\"\" width=\"812\" height=\"647\" srcset=\"https:\/\/www.gcdev3.com\/mwra\/wp-content\/uploads\/2024\/11\/Personnel-BTA-by-period.jpg 812w, https:\/\/www.gcdev3.com\/mwra\/wp-content\/uploads\/2024\/11\/Personnel-BTA-by-period-300x239.jpg 300w, https:\/\/www.gcdev3.com\/mwra\/wp-content\/uploads\/2024\/11\/Personnel-BTA-by-period-768x612.jpg 768w, https:\/\/www.gcdev3.com\/mwra\/wp-content\/uploads\/2024\/11\/Personnel-BTA-by-period-85x68.jpg 85w\" sizes=\"auto, (max-width: 812px) 100vw, 812px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-14776 alignright\" src=\"https:\/\/www.gcdev3.com\/mwra\/wp-content\/uploads\/2024\/11\/Maintenance-Color-Coding.png\" alt=\"\" width=\"544\" height=\"345\" srcset=\"https:\/\/www.gcdev3.com\/mwra\/wp-content\/uploads\/2024\/11\/Maintenance-Color-Coding.png 1461w, https:\/\/www.gcdev3.com\/mwra\/wp-content\/uploads\/2024\/11\/Maintenance-Color-Coding-300x190.png 300w, https:\/\/www.gcdev3.com\/mwra\/wp-content\/uploads\/2024\/11\/Maintenance-Color-Coding-1024x648.png 1024w, https:\/\/www.gcdev3.com\/mwra\/wp-content\/uploads\/2024\/11\/Maintenance-Color-Coding-768x486.png 768w, https:\/\/www.gcdev3.com\/mwra\/wp-content\/uploads\/2024\/11\/Maintenance-Color-Coding-107x68.png 107w\" sizes=\"auto, (max-width: 544px) 100vw, 544px\" \/>The lower right-had portion of the dashboard is where drivers for the\u00a0 cost center with the next greatest absolute variance will be graphicly explored. In the first quarter of FY 25 it was Maintenance.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-14777 alignleft\" src=\"https:\/\/www.gcdev3.com\/mwra\/wp-content\/uploads\/2024\/11\/October-Maintenance-Table.jpg\" alt=\"\" width=\"259\" height=\"403\" srcset=\"https:\/\/www.gcdev3.com\/mwra\/wp-content\/uploads\/2024\/11\/October-Maintenance-Table.jpg 529w, https:\/\/www.gcdev3.com\/mwra\/wp-content\/uploads\/2024\/11\/October-Maintenance-Table-193x300.jpg 193w, https:\/\/www.gcdev3.com\/mwra\/wp-content\/uploads\/2024\/11\/October-Maintenance-Table-44x68.jpg 44w\" sizes=\"auto, (max-width: 259px) 100vw, 259px\" \/><\/p>\n<p>&nbsp;<\/p>\n<p>A narrative table accompanies this chart, to offer explanations for these budget variances<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>&nbsp;<\/p>\n<p>Finally, in the lower left-hand portion of the dashboard is a summary of the CEB in terms of total dollars and a radial chart displaying the budget by expense categories.<img loading=\"lazy\" decoding=\"async\" class=\"wp-image-14768 size-full alignright\" src=\"https:\/\/www.gcdev3.com\/mwra\/wp-content\/uploads\/2024\/11\/CEB-Dashboard-Lower-LH-Image.jpg\" alt=\"\" width=\"1229\" height=\"611\" srcset=\"https:\/\/www.gcdev3.com\/mwra\/wp-content\/uploads\/2024\/11\/CEB-Dashboard-Lower-LH-Image.jpg 1229w, https:\/\/www.gcdev3.com\/mwra\/wp-content\/uploads\/2024\/11\/CEB-Dashboard-Lower-LH-Image-300x149.jpg 300w, https:\/\/www.gcdev3.com\/mwra\/wp-content\/uploads\/2024\/11\/CEB-Dashboard-Lower-LH-Image-1024x509.jpg 1024w, https:\/\/www.gcdev3.com\/mwra\/wp-content\/uploads\/2024\/11\/CEB-Dashboard-Lower-LH-Image-768x382.jpg 768w, https:\/\/www.gcdev3.com\/mwra\/wp-content\/uploads\/2024\/11\/CEB-Dashboard-Lower-LH-Image-120x60.jpg 120w\" sizes=\"auto, (max-width: 1229px) 100vw, 1229px\" \/><\/p>\n","protected":false},"excerpt":{"rendered":"<p>In November, Advisory Board staff introduced a new tool to help Advisory Board members abreast of on-going MWRA budget analysis. The CEB Dashboard is a collection of summary tables and [&hellip;]<\/p>\n","protected":false},"author":6,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[36],"tags":[],"class_list":["post-14754","post","type-post","status-publish","format-standard","hentry","category-blog-post","has-not-thumbnail"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.gcdev3.com\/mwra\/wp-json\/wp\/v2\/posts\/14754","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.gcdev3.com\/mwra\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.gcdev3.com\/mwra\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.gcdev3.com\/mwra\/wp-json\/wp\/v2\/users\/6"}],"replies":[{"embeddable":true,"href":"https:\/\/www.gcdev3.com\/mwra\/wp-json\/wp\/v2\/comments?post=14754"}],"version-history":[{"count":10,"href":"https:\/\/www.gcdev3.com\/mwra\/wp-json\/wp\/v2\/posts\/14754\/revisions"}],"predecessor-version":[{"id":14814,"href":"https:\/\/www.gcdev3.com\/mwra\/wp-json\/wp\/v2\/posts\/14754\/revisions\/14814"}],"wp:attachment":[{"href":"https:\/\/www.gcdev3.com\/mwra\/wp-json\/wp\/v2\/media?parent=14754"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.gcdev3.com\/mwra\/wp-json\/wp\/v2\/categories?post=14754"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.gcdev3.com\/mwra\/wp-json\/wp\/v2\/tags?post=14754"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}