Continuing and Professional Education


    Homepage > Course Description

    Course: Union Side Contract Costing

    In this intensive, hands-on class, students will learn how to cost out a union contract in detail and how to communicate that information to members in a meaningful way. This class is for Union Staff and Attorneys who support contract negotiations, Bargaining Team Members, CAT Team, and members at large who would like to participate in bargaining someday. Space is limited to 15 people. Students must bring a laptop with Excel already installed.

    Note: The "Excel warmup" pre-class should be attended by anyone who does not use Excel regularly in their daily life. Its focus will be on functions used for costing purposes.

    Programs Associated with this Course
    • Advanced Bargaining Certificate Program
    Who Should Attend

    Students must be Union Staff and Attorneys who support in contract negotiations and grievance handling, union members on Bargaining or Campaign Action Teams, or union members at large who would like to participate in bargaining someday.

    Benefits

    Upon successful completion of the program, students will feel more equipped and confident to prepare and justify contract proposals, leaving with a proficient level of knowledge and skills to go forward in doing the work. Specifically, they will:

    • Be able to create, manipulate, and calculate a detailed set of budget proposals that includes real costs for all elements of a union contract.
    • Know how to explain varying costs and tradeoffs when making proposals in negotiations.
    • Be able to articulate and demonstrate the various choices and costs in their proposals to members of the bargaining committee and union at large

    Professional Affiliations

    The Advanced Bargaining Certificate Program is presented in partnership with DePaul's Labor Education Center.

    Topics/Syllabus

    • Introduction to costing concepts and equations using Excel
    • Differences in front, uniform, and back loading increases, as well as annual percentage vs. flat rate increases
    • How to develop a base year costing for an individual, then expand across three years
    • Practice adjusting proposals by modifying spreadsheet equations for an individual around salary increases, paid time off, changes to health care costs, and increases in employer payments to pensions
    • How to develop a base cost for a whole bargaining unit
    • How to use the spreadsheet to avoid impasse by creating alternative proposals

    FAQ

    Do I need a laptop for this class?
    Yes. A laptop with excel software already loaded is required.

    Is there a required textbook?

    No, no textbooks are required for this program. Reading materials will be provided in class.

    Do I get DePaul credit for this class?
    No, but some DePaul CPE courses have been approved for continuing education units (CEUs). These classes are professional education classes with different requirements than courses taken for academic credit.

    Is this class offered in-person or online?
    This certificate program is offered in-person.

    Will I have to write papers and take exams?
    There will be short papers and exams in some of the courses.

    For More Information, Contact:

    Jessica Cook-Qurayshi

    Email: JCOOK18@depaul.edu
    Phone:


    Upcoming Class Offerings

    Union Side Contract Costing

    Dates: 04/23/2025 - 05/21/2025
    Time: 6:30 PM - 9:00 PM
    Meeting Pattern Wednesday
    Location:
    Cost: $450.00
    Registration Deadline: 04/23/2025 - a $75 late fee will be assessed after this date for late registrations
    Final Deadline: 04/23/2025 
    REGISTER FOR THIS CLASS


    Paper Registration

    If you wish to register for a class via a paper form, click here.
     

    Student Policies

    Click here for a list of our student policies.
    017317

    Contact Us

    For general inquiries, please email us or call 312-362-6300.