Sample Final Calculation Page from a Negotiations Spread Sheet

Any cents per hour or percent increase can be entered to instantly obtain the total direct and indirect cost of the increase. Changes to any clauses in the collective agreement or special adjustments for a particular job are similarly reflected instantly.

This format allows for quick preparation of mandates for approval and also allows the negotiating team to make quick evaluations during negotiations to determine if proposals they would like to make fall within the overall mandate.

SUMMARY                                                                       

                                                                              

#employees                              23                                    

# regular hours                     47,840                                    

WAST                                $12.14                                    

impact costs                      $142,266 (pension +  LTD + Break + washup time + vacations + 
                                             statutory holidays)                           

impact/hour                          $2.97                                    

non-impact costs                   $37,278                                    

non-impact/hour                      $0.78                                    

total cost/hour                     $15.90                                    

cost of 1¢ increase                $595.54                                    

cost of 1% increase                 $7,233                                    

                                                                              

                                                                              

PROPOSED INCREASES                                                            

                                                                              

                                  PRESENT       1998        1999        2000 

increase %                                      4.00%       0.00%       0.00% 

increase ¢                                      $0.00       $0.60       $0.56 

WAST                                $12.14     $12.63      $13.23      $13.79 

Salary Costs                      $583,502   $606,743    $635,447    $662,237 

non-impact costs                   $37,278    $37,278     $37,278     $37,278 

impact costs                      $142,266   $147,957    $154,985    $161,545 

total                             $763,046   $791,977    $827,709    $861,060 

increase                                      $28,931     $35,732     $33,350 

increase as a % of total                        3.79%       4.51%       4.03% 
contract cost                                                                 

                                                                              



[Introductory Page] [Tools]