Multi-Year Forecast, Aka, Union Negotiation Tool

Free with the ASBO Education Subscription - Subscribe Today!


Have an extra screen available for this hands-on workshop! As business officials, we are involved in union negotiations when they take place. Our responsibility is to create projections and share them with administration and union members. It takes time to create these projections. We will develop a multi-year, multi-scenario salary projection tool that you could use during your union negotiation. You can use this tool to build trust between the union members and the school committees. This will be a dynamic tool so that you can easily add more fiscal years in the future. This session was originally recorded for the 2020 Envision virtual conference.   

Learning Objectives:

Objective 1: Understand how to build dynamic worksheets.

Objective 2: Understand how to use indirect formula to create a worksheet template.

Objective 3: Understand how to work with complex and nested formulas.


Aziz Aghayev, School Business Manager, Harvard Public Schools, Harvard, MA

Knowledge Level:


SFO Domain(s):

Financial Planning, Budget Planning, and Analysis


1.0   SFO

ASBO International's Education Policies