We just received the new Union Agreement in regards to California Ironworkers Pay rate and Benefit increases beginning July 1, 2021.  Usually we just update pay tables and edit the Vacation Formula to produce the new wages and Benefits, However this July 1, 2021 increase seems to be more intricate in that the Ironworkers Administrative Trust Fund just released the summary of changes booklet with new pay increases for California now broken into "Zones"  1 thru 5.  Each of the 5 Zones has its own Wage Sheet attached to it with designated Cities and Counties assigned for those pay rates that Ironworkers are to receive when working in that city.  We are looking for the simplest way to set this up in SAGE 300 CRE Payroll module in order to pull the correct rates and benefits for the city the work is in.

Previously, the Trust Fund had California split into 2 areas Northern California (Alameda, Contra Costa, San Mateo & Santa Clara Counties) and Southern California ( Los Angeles, Riverside, Orange counties)  Each of those with different Hourly Rates.  Northern Area was higher Dollar per hour and some higher Benefits per hour too.

this New Schedule in ZONES, Breaks down like:

ZONE 1  =  City and County of San Francisco

ZONE 2 =  Alameda, Contra Costa, San Mateo and Santa Clara Counties

ZONE 3 =  Los Angeles City including the cities of Baldwin Hills, Beverly Hills, Burbank, Culver City, El Segundo, Gardena, Hawthorne, Hermosa Beach, Inglewood, Lawndale, Lennox, Lomita, Manhattan Bch, Marina Del Rey, Rancho Palos Verdes, Redondo Bch, Rolling Hills Estates, San Fernando, Santa Monica, Torrance, Universal City, W. Hollywood and Westwood Veterans Affairs.

ZONE 4  =  Counties of Amador, Butte, Calaveras, Colusa, El Dorado, Fresno, Glenn, Humbolt, Imperial, Kern, Kings, Lake, Los Angeles (portions not covered in ZONE 3), Madera, marin, Mariposa, Mendocino, Merced, Monterey, Napa, Nevada, Oran, San Bernardino, San Diego, San Jge, Placer, Plumas, Riverside, Sacramento, San Benitio, San Bernardino, San Diego, San Joaquin, San Luis Obispo, Santa Barbara, Santa Cruz, Shasta, Sierra, Solano, Sonoma, Stanislaus, Sutter, Tulare, Ventura.

ZONE 5 = Alpine, Del Norte, Inyo, Lassen, Modoc, Mono, Siskiyou, Trinity   -  Nevada Counties of:  Churchill, Esmeralda, Humboldt, Lander, Lincoln, Lyon, Mineral, Pershing.

To try and track each jobsite and timesheets with what pay rates seems like it would be super difficult.  Looking at the Zone Charts provided it appears the benefit amounts are the same and it is really only the Hourly Wage Rate the changes.  For Example ZONE 3 Hourly Wage is $43.88 and Zone 4 is $43.00.

In Lieu of keeping the Pay rate ZONE charts on my desk when entering Payroll Time to then override the Hourly wage rate does anyone have another idea to somehow automate it to pull the proper ZONE Wage amount?   Maybe in Job Cost / Job Set up ?

Any ideas would be helpful.  I appreciate any and all suggestions.

thank you