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

1. Agreed to a 3-year contract effectiveApril1, 2021 to March 31, 2024. Key terms:
   1. 2% general wage increase onApril1, 2022 and April 1, 2023
   2. $3600 signing bonus for each employee PRIOR TO the start of contract i.e. paid in full before April 1, 2021.
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 = 37.5 hours (7.5 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 $20 per hour as of March 31, 2020.
7. For all salary info assume total healthcare benefits = 25% 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!)

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:

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, 2021:

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, 2021 AND ignore any one-time costs:

Show work:

Answer:

1. For the BASE CASE [i.e. BEFORE April 1, 2021] 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 paidnotworked in a year:

Show work:

Answer:

1. For ONE employee total hours ACTUALLY WORKEDin a year:

Show work:

Answer:

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

Show work:

Answer:

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

Show work:

Answer:

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

Show work:

Answer:

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

Show work:

Answer:

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

Show work:

Answer:

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

Show work:

Answer:

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

Answer:

1. Identify by name one other one-time costthat the parties could have agreed to (but didn't):

Answer:

1. Draft the contract language that clearly and unambiguously identifies the parties' agreement to the one-time cost you suggested in answer to question #11:

Answer: