Ipsoot.Data

What We’ve Built / Costing

Automatically creating custom costing sheets from submitted bargaining unit lists

Before a proposal goes across the table, the team needs to know what it costs, and the employer’s number will come back different. A costing the union can stand behind starts from the same list the employer uses.

Checkedevery rate on the list against the contract
Pricedeach year of the proposal, worker by worker
Comparedeach raise against inflation
Exportedto Excel, with live formulas

What the union gets

A costing tool. Upload the bargaining unit list from the employer’s response to your information request, set the proposal for each year, and the tool prices it worker by worker and builds a spreadsheet the team can take to the table.

Starting from the employer’s list

The list is matched column by column: names, steps, lanes or classifications, hours and health plans. Every salary or hourly rate is checked against the contract’s current schedule, so placement errors and out-of-date lists surface before they skew the numbers.

Built from your contract

The tool reads the current wage schedule and pay rules out of your contract automatically, from salary schedules with education lanes to hourly scales with shift differentials, overtime and step timing. Each item is shown with the section it came from, for you to confirm or correct before anything is priced.

Every way to shape a proposal

Raise every step by a percentage, raise the base so later years build on it, rebuild the schedule from a new base and step increment, or add cents per hour, with a minimum wage floor if you need one. Add longevity payments and choose when they’re paid, set stipends in dollars or as a share of the base, and change health and retirement contributions. Adding a step is possible too, with a note on what it costs over a career.

What it shows

New money year by year, how much comes from step movement and how much from the raise, what each worker gets, and who falls behind inflation in any year.

Take it to the table

The tool builds an Excel workbook with live formulas: the costing, the scales from the contract, and the employer’s data, laid out like the costings bargaining teams already use, so anyone can check or change a figure.