You will be costing the impacts of an agreement outlined as follows:

1. Agreed to a 3-year contract effective April 1, 2023 to March 31, 2026. Key terms:
   1. 6% general wage increase on April 1, 2023 and April 1, 2025
   2. $3000 signing bonus for each employee paid in full on June 1, 2023.
2. Cost the settlement and provide answers to the questions below.
3. You must explicitly identify any assumptions you make beyond those stated below.
4. Use this form only to provide your answers. Spreadsheets etc. are not acceptable.

Assumptions for the Assignment:

1. There are 1,000 FTE (full-time equivalent) employees in the bargaining unit. There are no part time employees
2. Basic work week = 40 hours (8 hours x 5 days/week)
3. Calendar year = 52 weeks
4. There are eleven (11) paid statutory holidays in the collective agreement
5. Each FTE has three (3) weeks = 15 work days of paid vacation
6. For all salary info assume an average of $25 per hour prior to April 1, 2023.
7. For all salary info assume total healthcare benefits = 30% of salaries
8. Contract year is April 1 to March 31.

Record your answers to the questions and show ALL your work (no part marks without it!!!) butPUT THE ANSWER AT THE VERY END OF THE WORK FOR EACH QUESTION I.E. I WONT HUNT FOR YOUR ANSWERS.

1. (1 point) Start the BASE CASE: calculate the total cost of employing a single average employee for one hour as at the day prior to commencing the new agreement in April 2021 [i.e. wages AND benefits]:

Show work:

Total cost of one hour =

Answer:

1. (1 point) Continuing the BASE CASE: calculate the number of PAID HOURS PER YEAR per employee:

Show work:

Answer:

1. (1 point) Continuing the BASE CASE: Calculate the total cost (including benefits) of employing a single average worker for one year prior to April 1, 2023:

Show work:

Answer:

1. (1 point) FINISHING the BASE CASE: Calculate the total cost for ONE year of wages and benefits for the whole bargaining unit prior to the new agreement i.e. at March 31, 2023 AND ignore any one-time costs:

Show work:

Answer:

1. For the BASE CASE [i.e. BEFORE April 1, 2023] calculate the total number of paid time hours not worked in a single YEAR for each EMPLOYEE [include in this calculation ONLY the statutory paid holidays and paid vacations found in the assumptions]. Calculate:
   1. (1 point) For ONE employee total hours paid not worked in a year:

Show work:

Answer:

1. (1 point) For ONE employee total hours ACTUALLY WORKED in a year:

Show work:

Answer:

1. (1 point) For a THOUSAND EMPLOYEES total hours ACTUALLY WORKED in a year.

Show work:

Answer:

1. (1 point) For ONE employee total PAY (including benefits) for paid time not worked in a year:

Show work:

Answer:

1. (1 point) Start the NEW CASE: calculate the total cost of employing a single average employee for one hour on April 2, 2023 [i.e. wages AND benefits]:

Show work:

Answer:

1. (1 point) Continuing the NEW CASE: Calculate the total cost of employing a single average worker from April 1, 2023 to March 31, 2024 (including benefits):

Show work:

Answer:

1. (3 points) Continuing the NEW CASE: Calculate the total cost of employing a single average worker in calendar year 2023 (exluding benefits):

Show work:

Answer:

1. (1 point) Calculate the dollar amount of any one-time costs in the deal (for the entire bargaining unit):

Show work:

Answer:

1. (1 point) Identify by name (not the amount) any ongoing costs (not savings) in the deal:

Answer:

1. (2 points) Identify by name one other one-time cost that the parties could have agreed to (but didnt).

Answer:

1. (3 points) Draft the contract language (no more than 2 sentences) that clearly and unambiguously identifies the parties agreement to the one-time cost you suggested in answer to question #11:

Answer: