case study - Operations Management
Churn Data - Canuck 2020
Fiscal Year Gender Age FTE Occupation Termination Reason Termination Category Years of Service
2010 M 55 Full Time Accounting Death Death 24
2010 M 59 Full Time Accounting Death Death 37
2011 M 61 Full Time Accounting Death Death 33
2012 M 58 Full Time Accounting Dismissed - Misconduct Involuntary 15
2015 M 53 Full Time Accounting Dismissed - Misconduct Involuntary 0
2011 M 39 Full Time Accounting Dismissed - Poor Performance Involuntary 3
2015 M 39 Full Time Accounting Dismissed - Poor Performance Involuntary 1
2018 F 52 Full Time Accounting Dismissed - Poor Performance Involuntary 1
2010 F 58 Full Time Accounting Early Retirement Retirement 14
2010 M 58 Full Time Accounting Early Retirement Retirement 26
2010 F 58 Full Time Accounting Early Retirement Retirement 31
2010 M 59 Full Time Accounting Early Retirement Retirement 32
2010 F 55 Full Time Accounting Early Retirement Retirement 33
2010 M 56 Full Time Accounting Early Retirement Retirement 34
2010 M 56 Full Time Accounting Early Retirement Retirement 35
2010 M 56 Full Time Accounting Early Retirement Retirement 35
2010 F 56 Full Time Accounting Early Retirement Retirement 37
2011 F 56 Full Time Accounting Early Retirement Retirement 14
2011 F 58 Full Time Accounting Early Retirement Retirement 18
2011 M 60 Full Time Accounting Early Retirement Retirement 18
2011 M 51 Full Time Accounting Early Retirement Retirement 21
2011 M 55 Full Time Accounting Early Retirement Retirement 32
2011 M 61 Full Time Accounting Early Retirement Retirement 32
2011 F 56 Full Time Accounting Early Retirement Retirement 34
2012 F 61 Full Time Accounting Early Retirement Retirement 14
2012 F 61 Full Time Accounting Early Retirement Retirement 19
2012 F 60 Full Time Accounting Early Retirement Retirement 26
2012 F 63 Full Time Accounting Early Retirement Retirement 26
2012 F 55 Full Time Accounting Early Retirement Retirement 28
2012 M 58 Full Time Accounting Early Retirement Retirement 30
2012 M 60 Full Time Accounting Early Retirement Retirement 31
2012 F 55 Full Time Accounting Early Retirement Retirement 34
2012 F 57 Full Time Accounting Early Retirement Retirement 36
2012 M 57 Full Time Accounting Early Retirement Retirement 36
2012 M 59 Full Time Accounting Early Retirement Retirement 36
2012 M 62 Full Time Accounting Early Retirement Retirement 37
2013 M 63 Full Time Accounting Early Retirement Retirement 16
2013 F 62 Full Time Accounting Early Retirement Retirement 28
2013 F 60 Full Time Accounting Early Retirement Retirement 34
2013 M 56 Full Time Accounting Early Retirement Retirement 34
2013 F 56 Full Time Accounting Early Retirement Retirement 36
2018 F 61 Full Time Accounting Early Retirement Retirement 28
2010 F 38 Full Time Accounting Family Issues Voluntary 1
2010 F 39 Full Time Accounting Family Issues Voluntary 2
2010 F 42 Full Time Accounting Family Issues Voluntary 2
2010 F 42 Full Time Accounting Family Issues Voluntary 4
2011 F 34 Part Time Accounting Family Issues Voluntary 3
2011 F 37 Full Time Accounting Family Issues Voluntary 3
2011 F 33 Full Time Accounting Family Issues Voluntary 4
2011 F 35 Full Time Accounting Family Issues Voluntary 4
2011 F 34 Full Time Accounting Family Issues Voluntary 10
2012 F 42 Full Time Accounting Family Issues Voluntary 1
2016 M 36 Full Time Accounting Family Issues Voluntary 1
2017 F 45 Full Time Accounting Family Issues Voluntary 4
2017 F 33 Full Time Accounting Family Issues Voluntary 5
2019 F 33 Full Time Accounting Family Issues Voluntary 2
2010 F 32 Full Time Accounting Health Reasons Voluntary 2
2010 M 37 Full Time Accounting Health Reasons Voluntary 4
2011 M 65 Full Time Accounting Health Reasons Voluntary 2
2013 M 48 Full Time Accounting Health Reasons Voluntary 0
2018 F 30 Full Time Accounting Health Reasons Voluntary 0
2009 F 24 Full Time Accounting Layoff Involuntary 0
2010 M 29 Full Time Accounting Layoff Involuntary 1
2010 M 48 Full Time Accounting Layoff Involuntary 1
2010 M 46 Full Time Accounting Layoff Involuntary 16
2011 M 53 Full Time Accounting Layoff Involuntary 2
2011 M 56 Full Time Accounting Layoff Involuntary 18
2011 M 60 Full Time Accounting Layoff Involuntary 27
2012 F 22 Full Time Accounting Layoff Involuntary 0
2012 F 23 Part Time Accounting Layoff Involuntary 0
2012 F 23 Full Time Accounting Layoff Involuntary 0
2012 F 56 Part Time Accounting Layoff Involuntary 0
2012 F 56 Full Time Accounting Layoff Involuntary 0
2012 M 20 Full Time Accounting Layoff Involuntary 0
2012 M 41 Full Time Accounting Layoff Involuntary 0
2012 M 41 Full Time Accounting Layoff Involuntary 0
2012 F 23 Part Time Accounting Layoff Involuntary 1
2012 F 60 Part Time Accounting Layoff Involuntary 2
2012 F 65 Full Time Accounting Layoff Involuntary 25
2012 M 58 Full Time Accounting Layoff Involuntary 30
2012 M 57 Full Time Accounting Layoff Involuntary 36
2012 M 59 Full Time Accounting Layoff Involuntary 36
2012 M 65 Full Time Accounting Layoff Involuntary 40
2013 F 24 Part Time Accounting Layoff Involuntary 0
2013 F 29 Full Time Accounting Layoff Involuntary 0
2013 F 45 Full Time Accounting Layoff Involuntary 0
2013 F 45 Full Time Accounting Layoff Involuntary 0
2013 M 50 Full Time Accounting Layoff Involuntary 1
2013 M 58 Full Time Accounting Layoff Involuntary 20
2013 M 58 Full Time Accounting Layoff Involuntary 20
2013 M 63 Full Time Accounting Layoff Involuntary 37
2013 M 65 Full Time Accounting Layoff Involuntary 38
2010 F 32 Full Time Accounting Resignation Voluntary 0
2010 M 36 Full Time Accounting Resignation Voluntary 0
2010 F 38 Full Time Accounting Resignation Voluntary 14
2011 F 31 Full Time Accounting Resignation Voluntary 0
2011 F 42 Full Time Accounting Resignation Voluntary 0
2011 M 35 Full Time Accounting Resignation Voluntary 0
2011 M 38 Full Time Accounting Resignation Voluntary 0
2011 M 42 Full Time Accounting Resignation Voluntary 0
2011 F 41 Full Time Accounting Resignation Voluntary 1
2011 F 36 Full Time Accounting Resignation Voluntary 3
2011 M 43 Full Time Accounting Resignation Voluntary 3
2011 F 29 Full Time Accounting Resignation Voluntary 6
2011 F 40 Part Time Accounting Resignation Voluntary 6
2012 F 21 Full Time Accounting Resignation Voluntary 1
2012 F 43 Full Time Accounting Resignation Voluntary 4
2013 F 46 Full Time Accounting Resignation Voluntary 0
2013 M 52 Full Time Accounting Resignation Voluntary 0
2013 F 33 Full Time Accounting Resignation Voluntary 5
2015 F 55 Full Time Accounting Resignation Voluntary 0
2015 M 32 Full Time Accounting Resignation Voluntary 0
2015 M 41 Full Time Accounting Resignation Voluntary 0
2015 M 31 Full Time Accounting Resignation Voluntary 1
2015 M 45 Full Time Accounting Resignation Voluntary 3
2016 M 31 Full Time Accounting Resignation Voluntary 2
2017 M 42 Full Time Accounting Resignation Voluntary 3
2011 M 65 Full Time Accounting Retirement Retirement 29
2011 F 65 Full Time Accounting Retirement Retirement 44
2011 M 65 Full Time Accounting Retirement Retirement 44
2012 M 65 Full Time Accounting Retirement Retirement 6
2018 M 65 Full Time Accounting Retirement Retirement 13
2011 F 49 Full Time Accounting Return to School Voluntary 0
2011 M 44 Full Time Analysts Death Death 0
2010 M 59 Full Time Analysts Early Retirement Retirement 29
2010 M 56 Full Time Analysts Early Retirement Retirement 33
2010 M 57 Full Time Analysts Early Retirement Retirement 33
2011 M 60 Full Time Analysts Early Retirement Retirement 32
2012 M 61 Full Time Analysts Early Retirement Retirement 31
2012 M 56 Full Time Analysts Early Retirement Retirement 32
2012 M 56 Full Time Analysts Early Retirement Retirement 33
2012 M 61 Full Time Analysts Early Retirement Retirement 34
2013 M 59 Full Time Analysts Early Retirement Retirement 17
2013 M 56 Full Time Analysts Early Retirement Retirement 29
2011 F 51 Part Time Analysts Family Issues Voluntary 0
2011 F 51 Part Time Analysts Family Issues Voluntary 0
2011 M 51 Part Time Analysts Family Issues Voluntary 0
2011 F 40 Full Time Analysts Family Issues Voluntary 6
2011 F 40 Full Time Analysts Family Issues Voluntary 6
2011 F 40 Full Time Analysts Family Issues Voluntary 6
2011 M 40 Full Time Analysts Family Issues Voluntary 6
2011 F 55 Full Time Analysts Family Issues Voluntary 15
2011 F 55 Full Time Analysts Family Issues Voluntary 15
2011 F 55 Full Time Analysts Family Issues Voluntary 15
2015 F 55 Full Time Analysts Family Issues Voluntary 15
2016 F 51 Part Time Analysts Family Issues Voluntary 0
2011 M 54 Full Time Analysts Layoff Involuntary 8
2012 F 43 Full Time Analysts Layoff Involuntary 0
2012 M 56 Full Time Analysts Layoff Involuntary 1
2012 M 56 Full Time Analysts Layoff Involuntary 1
2012 M 34 Full Time Analysts Layoff Involuntary 3
2013 M 44 Full Time Analysts Layoff Involuntary 0
2013 F 37 Full Time Analysts Layoff Involuntary 1
2013 F 52 Full Time Analysts Layoff Involuntary 10
2013 M 56 Full Time Analysts Layoff Involuntary 11
2013 M 63 Full Time Analysts Layoff Involuntary 35
2010 M 55 Full Time Analysts Resignation Voluntary 1
2010 M 55 Full Time Analysts Resignation Voluntary 1
2010 M 55 Full Time Analysts Resignation Voluntary 1
2010 M 55 Full Time Analysts Resignation Voluntary 1
2010 M 40 Full Time Analysts Resignation Voluntary 2
2010 M 40 Full Time Analysts Resignation Voluntary 2
2010 M 40 Full Time Analysts Resignation Voluntary 2
2010 M 40 Full Time Analysts Resignation Voluntary 2
2010 M 47 Full Time Analysts Resignation Voluntary 4
2010 M 47 Full Time Analysts Resignation Voluntary 4
2010 M 47 Full Time Analysts Resignation Voluntary 4
2010 M 47 Full Time Analysts Resignation Voluntary 4
2012 M 65 Full Time Analysts Retirement Retirement 6
2011 F 60 Full Time Business Development Death Death 32
2019 F 33 Full Time Business Development Dismissed - Poor Performance Involuntary 6
2017 M 42 Full Time Business Development Dismissed - Poor Performance Involuntary 0
2010 M 63 Full Time Business Development Early Retirement Retirement 5
2011 F 54 Full Time Business Development Early Retirement Retirement 16
2011 M 59 Full Time Business Development Early Retirement Retirement 26
2011 M 61 Full Time Business Development Early Retirement Retirement 30
2011 M 57 Full Time Business Development Early Retirement Retirement 37
2012 F 54 Part Time Business Development Early Retirement Retirement 20
2012 F 51 Full Time Business Development Early Retirement Retirement 27
2012 F 59 Full Time Business Development Early Retirement Retirement 27
2013 M 58 Full Time Business Development Early Retirement Retirement 35
2009 F 30 Full Time Business Development Family Issues Voluntary 6
2009 F 30 Full Time Business Development Family Issues Voluntary 6
2010 F 43 Full Time Business Development Family Issues Voluntary 16
2011 F 36 Full Time Business Development Family Issues Voluntary 11
2011 F 36 Full Time Business Development Family Issues Voluntary 11
2011 F 40 Full Time Business Development Family Issues Voluntary 16
2011 F 40 Full Time Business Development Family Issues Voluntary 16
2010 M 65 Full Time Business Development Health Reasons Voluntary 10
2010 M 65 Full Time Business Development Health Reasons Voluntary 10
2009 F 23 Full Time Business Development Layoff Involuntary 0
2009 F 23 Part Time Business Development Layoff Involuntary 0
2009 F 23 Full Time Business Development Layoff Involuntary 0
2009 F 23 Full Time Business Development Layoff Involuntary 0
2009 F 23 Full Time Business Development Layoff Involuntary 0
2009 F 23 Full Time Business Development Layoff Involuntary 0
2009 F 24 Full Time Business Development Layoff Involuntary 0
2009 F 24 Full Time Business Development Layoff Involuntary 0
2009 F 24 Full Time Business Development Layoff Involuntary 0
2009 F 24 Full Time Business Development Layoff Involuntary 0
2009 F 24 Full Time Business Development Layoff Involuntary 0
2009 F 24 Full Time Business Development Layoff Involuntary 0
2009 F 25 Full Time Business Development Layoff Involuntary 0
2009 F 25 Full Time Business Development Layoff Involuntary 0
2009 F 25 Part Time Business Development Layoff Involuntary 0
2009 F 25 Full Time Business Development Layoff Involuntary 0
2009 F 25 Full Time Business Development Layoff Involuntary 0
2009 F 26 Full Time Business Development Layoff Involuntary 0
2009 F 26 Full Time Business Development Layoff Involuntary 0
2009 F 27 Full Time Business Development Layoff Involuntary 0
2009 F 27 Full Time Business Development Layoff Involuntary 0
2009 F 29 Full Time Business Development Layoff Involuntary 0
2009 M 23 Full Time Business Development Layoff Involuntary 0
2009 M 24 Full Time Business Development Layoff Involuntary 0
2009 M 26 Full Time Business Development Layoff Involuntary 0
2009 M 26 Full Time Business Development Layoff Involuntary 0
2009 M 26 Full Time Business Development Layoff Involuntary 0
2009 M 28 Full Time Business Development Layoff Involuntary 0
2010 F 38 Full Time Business Development Layoff Involuntary 1
2011 F 44 Full Time Business Development Layoff Involuntary 0
2011 F 57 Full Time Business Development Layoff Involuntary 0
2011 F 49 Full Time Business Development Layoff Involuntary 1
2011 M 54 Full Time Business Development Layoff Involuntary 6
2012 F 20 Full Time Business Development Layoff Involuntary 0
2012 F 21 Full Time Business Development Layoff Involuntary 0
2012 F 21 Full Time Business Development Layoff Involuntary 0
2012 F 21 Full Time Business Development Layoff Involuntary 0
2012 F 22 Full Time Business Development Layoff Involuntary 0
2012 F 22 Full Time Business Development Layoff Involuntary 0
2012 F 22 Full Time Business Development Layoff Involuntary 0
2012 F 22 Full Time Business Development Layoff Involuntary 0
2012 F 22 Full Time Business Development Layoff Involuntary 0
2012 F 22 Full Time Business Development Layoff Involuntary 0
2012 F 22 Full Time Business Development Layoff Involuntary 0
2012 F 22 Full Time Business Development Layoff Involuntary 0
2012 F 22 Full Time Business Development Layoff Involuntary 0
2012 F 22 Full Time Business Development Layoff Involuntary 0
2012 F 22 Full Time Business Development Layoff Involuntary 0
2012 F 34 Full Time Business Development Layoff Involuntary 0
2012 F 40 Full Time Business Development Layoff Involuntary 0
2012 M 21 Full Time Business Development Layoff Involuntary 0
2012 M 21 Full Time Business Development Layoff Involuntary 0
2012 M 21 Full Time Business Development Layoff Involuntary 0
2012 M 21 Full Time Business Development Layoff Involuntary 0
2012 M 21 Full Time Business Development Layoff Involuntary 0
2012 M 22 Full Time Business Development Layoff Involuntary 0
2012 M 22 Full Time Business Development Layoff Involuntary 0
2012 M 22 Full Time Business Development Layoff Involuntary 0
2012 M 23 Full Time Business Development Layoff Involuntary 0
2012 M 35 Full Time Business Development Layoff Involuntary 0
2012 M 38 Full Time Business Development Layoff Involuntary 0
2012 M 45 Full Time Business Development Layoff Involuntary 0
2012 M 47 Full Time Business Development Layoff Involuntary 0
2012 M 52 Full Time Business Development Layoff Involuntary 0
2012 M 52 Full Time Business Development Layoff Involuntary 0
2012 M 58 Full Time Business Development Layoff Involuntary 4
2013 F 21 Full Time Business Development Layoff Involuntary 0
2013 F 21 Full Time Business Development Layoff Involuntary 0
2013 F 21 Full Time Business Development Layoff Involuntary 0
2013 F 21 Full Time Business Development Layoff Involuntary 0
2013 F 22 Full Time Business Development Layoff Involuntary 0
2013 F 22 Full Time Business Development Layoff Involuntary 0
2013 F 22 Full Time Business Development Layoff Involuntary 0
2013 F 22 Full Time Business Development Layoff Involuntary 0
2013 F 23 Full Time Business Development Layoff Involuntary 0
2013 F 23 Full Time Business Development Layoff Involuntary 0
2013 F 23 Full Time Business Development Layoff Involuntary 0
2013 F 23 Full Time Business Development Layoff Involuntary 0
2013 F 23 Full Time Business Development Layoff Involuntary 0
2013 F 23 Full Time Business Development Layoff Involuntary 0
2013 F 23 Full Time Business Development Layoff Involuntary 0
2013 F 23 Full Time Business Development Layoff Involuntary 0
2013 F 23 Full Time Business Development Layoff Involuntary 0
2013 F 23 Full Time Business Development Layoff Involuntary 0
2013 F 23 Full Time Business Development Layoff Involuntary 0
2013 F 23 Full Time Business Development Layoff Involuntary 0
2013 F 23 Full Time Business Development Layoff Involuntary 0
2013 F 23 Full Time Business Development Layoff Involuntary 0
2013 F 23 Full Time Business Development Layoff Involuntary 0
2013 F 24 Full Time Business Development Layoff Involuntary 0
2013 F 24 Full Time Business Development Layoff Involuntary 0
2013 F 24 Full Time Business Development Layoff Involuntary 0
2013 F 24 Full Time Business Development Layoff Involuntary 0
2013 F 24 Full Time Business Development Layoff Involuntary 0
2013 F 24 Full Time Business Development Layoff Involuntary 0
2013 F 24 Full Time Business Development Layoff Involuntary 0
2013 F 24 Full Time Business Development Layoff Involuntary 0
2013 F 25 Full Time Business Development Layoff Involuntary 0
2013 F 25 Full Time Business Development Layoff Involuntary 0
2013 F 25 Full Time Business Development Layoff Involuntary 0
2013 F 25 Full Time Business Development Layoff Involuntary 0
2013 F 25 Full Time Business Development Layoff Involuntary 0
2013 F 25 Full Time Business Development Layoff Involuntary 0
2013 F 26 Full Time Business Development Layoff Involuntary 0
2013 F 26 Full Time Business Development Layoff Involuntary 0
2013 F 26 Full Time Business Development Layoff Involuntary 0
2013 F 26 Full Time Business Development Layoff Involuntary 0
2013 F 26 Full Time Business Development Layoff Involuntary 0
2013 F 27 Full Time Business Development Layoff Involuntary 0
2013 F 28 Full Time Business Development Layoff Involuntary 0
2013 F 28 Full Time Business Development Layoff Involuntary 0
2013 F 29 Full Time Business Development Layoff Involuntary 0
2013 F 30 Full Time Business Development Layoff Involuntary 0
2013 F 34 Full Time Business Development Layoff Involuntary 0
2013 F 38 Full Time Business Development Layoff Involuntary 0
2013 M 20 Full Time Business Development Layoff Involuntary 0
2013 M 21 Full Time Business Development Layoff Involuntary 0
2013 M 21 Full Time Business Development Layoff Involuntary 0
2013 M 21 Full Time Business Development Layoff Involuntary 0
2013 M 22 Full Time Business Development Layoff Involuntary 0
2013 M 22 Full Time Business Development Layoff Involuntary 0
2013 M 23 Full Time Business Development Layoff Involuntary 0
2013 M 23 Full Time Business Development Layoff Involuntary 0
2013 M 24 Full Time Business Development Layoff Involuntary 0
2013 M 24 Full Time Business Development Layoff Involuntary 0
2013 M 24 Full Time Business Development Layoff Involuntary 0
2013 M 24 Full Time Business Development Layoff Involuntary 0
2013 M 24 Full Time Business Development Layoff Involuntary 0
2013 M 25 Full Time Business Development Layoff Involuntary 0
2013 M 25 Full Time Business Development Layoff Involuntary 0
2013 M 25 Full Time Business Development Layoff Involuntary 0
2013 M 27 Full Time Business Development Layoff Involuntary 0
2013 M 28 Full Time Business Development Layoff Involuntary 0
2013 M 29 Full Time Business Development Layoff Involuntary 0
2013 M 33 Full Time Business Development Layoff Involuntary 0
2013 M 27 Full Time Business Development Layoff Involuntary 1
2013 M 31 Full Time Business Development Layoff Involuntary 1
2013 M 56 Full Time Business Development Layoff Involuntary 1
2013 F 47 Full Time Business Development Layoff Involuntary 2
2013 M 64 Full Time Business Development Layoff Involuntary 29
2014 M 29 Full Time Business Development Layoff Involuntary 0
2010 M 35 Full Time Business Development Resignation Voluntary 0
2010 M 35 Full Time Business Development Resignation Voluntary 0
2010 M 25 Full Time Business Development Resignation Voluntary 1
2010 M 25 Full Time Business Development Resignation Voluntary 1
2011 M 45 Full Time Business Development Resignation Voluntary 2
2011 M 45 Full Time Business Development Resignation Voluntary 2
2011 F 31 Full Time Business Development Resignation Voluntary 7
2011 F 31 Full Time Business Development Resignation Voluntary 7
2012 F 31 Full Time Business Development Resignation Voluntary 0
2012 F 34 Full Time Business Development Resignation Voluntary 7
2012 F 34 Full Time Business Development Resignation Voluntary 7
2016 F 31 Full Time Business Development Resignation Voluntary 0
2013 M 65 Full Time Business Development Retirement Retirement 34
2011 M 24 Full Time Business Development Return to School Voluntary 0
2016 M 24 Full Time Business Development Return to School Voluntary 0
2011 F 61 Full Time Clerks/Assistants Death Death 28
2013 F 28 Part Time Clerks/Assistants Dismissed - Misconduct Involuntary 0
2019 F 38 Full Time Clerks/Assistants Dismissed - Poor Performance Involuntary 0
2010 F 61 Full Time Clerks/Assistants Early Retirement Retirement 5
2010 F 56 Part Time Clerks/Assistants Early Retirement Retirement 10
2010 F 61 Full Time Clerks/Assistants Early Retirement Retirement 13
2010 F 63 Full Time Clerks/Assistants Early Retirement Retirement 15
2010 F 56 Full Time Clerks/Assistants Early Retirement Retirement 17
2010 F 59 Full Time Clerks/Assistants Early Retirement Retirement 25
2010 F 64 Full Time Clerks/Assistants Early Retirement Retirement 25
2010 F 60 Full Time Clerks/Assistants Early Retirement Retirement 26
2010 F 58 Full Time Clerks/Assistants Early Retirement Retirement 29
2010 F 60 Full Time Clerks/Assistants Early Retirement Retirement 29
2010 F 56 Full Time Clerks/Assistants Early Retirement Retirement 31
2010 M 58 Full Time Clerks/Assistants Early Retirement Retirement 32
2010 M 58 Full Time Clerks/Assistants Early Retirement Retirement 32
2010 M 59 Full Time Clerks/Assistants Early Retirement Retirement 35
2010 F 56 Full Time Clerks/Assistants Early Retirement Retirement 36
2010 M 56 Full Time Clerks/Assistants Early Retirement Retirement 36
2011 F 55 Full Time Clerks/Assistants Early Retirement Retirement 15
2011 F 61 Full Time Clerks/Assistants Early Retirement Retirement 15
2011 F 63 Full Time Clerks/Assistants Early Retirement Retirement 16
2011 F 54 Full Time Clerks/Assistants Early Retirement Retirement 17
2011 F 60 Full Time Clerks/Assistants Early Retirement Retirement 25
2011 M 57 Full Time Clerks/Assistants Early Retirement Retirement 29
2011 F 56 Full Time Clerks/Assistants Early Retirement Retirement 32
2011 F 56 Full Time Clerks/Assistants Early Retirement Retirement 33
2011 F 59 Full Time Clerks/Assistants Early Retirement Retirement 33
2011 F 56 Full Time Clerks/Assistants Early Retirement Retirement 34
2011 F 56 Full Time Clerks/Assistants Early Retirement Retirement 34
2011 M 55 Full Time Clerks/Assistants Early Retirement Retirement 34
2011 F 61 Full Time Clerks/Assistants Early Retirement Retirement 35
2011 M 63 Full Time Clerks/Assistants Early Retirement Retirement 38
2012 M 57 Full Time Clerks/Assistants Early Retirement Retirement 17
2012 F 61 Full Time Clerks/Assistants Early Retirement Retirement 19
2012 F 58 Full Time Clerks/Assistants Early Retirement Retirement 23
2012 F 61 Full Time Clerks/Assistants Early Retirement Retirement 23
2012 F 59 Full Time Clerks/Assistants Early Retirement Retirement 26
2012 F 62 Full Time Clerks/Assistants Early Retirement Retirement 27
2012 F 62 Full Time Clerks/Assistants Early Retirement Retirement 30
2012 F 56 Full Time Clerks/Assistants Early Retirement Retirement 31
2012 F 58 Full Time Clerks/Assistants Early Retirement Retirement 31
2012 F 60 Full Time Clerks/Assistants Early Retirement Retirement 31
2012 M 59 Full Time Clerks/Assistants Early Retirement Retirement 35
2012 F 56 Full Time Clerks/Assistants Early Retirement Retirement 36
2012 M 59 Full Time Clerks/Assistants Early Retirement Retirement 36
2012 M 58 Full Time Clerks/Assistants Early Retirement Retirement 39
2013 F 61 Full Time Clerks/Assistants Early Retirement Retirement 4
2013 F 51 Full Time Clerks/Assistants Early Retirement Retirement 16
2013 F 61 Full Time Clerks/Assistants Early Retirement Retirement 19
2013 F 59 Full Time Clerks/Assistants Early Retirement Retirement 20
2013 M 62 Full Time Clerks/Assistants Early Retirement Retirement 21
2013 F 62 Full Time Clerks/Assistants Early Retirement Retirement 28
2013 M 63 Full Time Clerks/Assistants Early Retirement Retirement 29
2013 M 61 Full Time Clerks/Assistants Early Retirement Retirement 34
2013 F 57 Full Time Clerks/Assistants Early Retirement Retirement 36
2015 F 62 Full Time Clerks/Assistants Early Retirement Retirement 27
2011 F 24 Full Time Clerks/Assistants Family Issues Voluntary 0
2011 F 34 Part Time Clerks/Assistants Family Issues Voluntary 0
2011 F 33 Full Time Clerks/Assistants Family Issues Voluntary 1
2012 F 35 Full Time Clerks/Assistants Family Issues Voluntary 4
2016 F 23 Full Time Clerks/Assistants Family Issues Voluntary 0
2009 F 24 Full Time Clerks/Assistants Health Reasons Voluntary 2
2009 F 23 Full Time Clerks/Assistants Layoff Involuntary 0
2009 F 23 Full Time Clerks/Assistants Layoff Involuntary 0
2009 F 23 Part Time Clerks/Assistants Layoff Involuntary 0
2009 F 23 Full Time Clerks/Assistants Layoff Involuntary 0
2009 F 23 Full Time Clerks/Assistants Layoff Involuntary 0
2009 F 23 Full Time Clerks/Assistants Layoff Involuntary 0
2009 F 23 Full Time Clerks/Assistants Layoff Involuntary 0
2009 F 23 Full Time Clerks/Assistants Layoff Involuntary 0
2009 F 23 Full Time Clerks/Assistants Layoff Involuntary 0
2009 F 23 Full Time Clerks/Assistants Layoff Involuntary 0
2009 F 23 Full Time Clerks/Assistants Layoff Involuntary 0
2009 F 23 Full Time Clerks/Assistants Layoff Involuntary 0
2009 F 23 Full Time Clerks/Assistants Layoff Involuntary 0
2009 F 23 Full Time Clerks/Assistants Layoff Involuntary 0
2009 F 23 Full Time Clerks/Assistants Layoff Involuntary 0
2009 F 23 Full Time Clerks/Assistants Layoff Involuntary 0
2009 F 23 Full Time Clerks/Assistants Layoff Involuntary 0
2009 F 23 Full Time Clerks/Assistants Layoff Involuntary 0
2009 F 23 Full Time Clerks/Assistants Layoff Involuntary 0
2009 F 23 Full Time Clerks/Assistants Layoff Involuntary 0
2009 F 23 Full Time Clerks/Assistants Layoff Involuntary 0
2009 F 24 Full Time Clerks/Assistants Layoff Involuntary 0
2009 F 24 Full Time Clerks/Assistants Layoff Involuntary 0
2009 F 24 Full Time Clerks/Assistants Layoff Involuntary 0
2009 F 24 Full Time Clerks/Assistants Layoff Involuntary 0
2009 F 24 Full Time Clerks/Assistants Layoff Involuntary 0
2009 F 25 Full Time Clerks/Assistants Layoff Involuntary 0
2009 F 25 Full Time Clerks/Assistants Layoff Involuntary 0
2009 F 25 Full Time Clerks/Assistants Layoff Involuntary 0
2009 F 25 Full Time Clerks/Assistants Layoff Involuntary 0
2009 F 25 Full Time Clerks/Assistants Layoff Involuntary 0
2009 F 25 Full Time Clerks/Assistants Layoff Involuntary 0
2009 F 26 Full Time Clerks/Assistants Layoff Involuntary 0
2009 F 26 Full Time Clerks/Assistants Layoff Involuntary 0
2009 F 27 Full Time Clerks/Assistants Layoff Involuntary 0
2009 F 29 Full Time Clerks/Assistants Layoff Involuntary 0
2009 F 30 Full Time Clerks/Assistants Layoff Involuntary 0
2009 F 30 Full Time Clerks/Assistants Layoff Involuntary 0
2009 M 23 Full Time Clerks/Assistants Layoff Involuntary 0
2009 M 23 Full Time Clerks/Assistants Layoff Involuntary 0
2009 M 23 Full Time Clerks/Assistants Layoff Involuntary 0
2009 M 23 Full Time Clerks/Assistants Layoff Involuntary 0
2009 M 23 Full Time Clerks/Assistants Layoff Involuntary 0
2009 M 23 Full Time Clerks/Assistants Layoff Involuntary 0
2009 M 23 Full Time Clerks/Assistants Layoff Involuntary 0
2009 M 23 Full Time Clerks/Assistants Layoff Involuntary 0
2009 M 23 Full Time Clerks/Assistants Layoff Involuntary 0
2009 M 23 Full Time Clerks/Assistants Layoff Involuntary 0
2009 M 23 Full Time Clerks/Assistants Layoff Involuntary 0
2009 M 23 Full Time Clerks/Assistants Layoff Involuntary 0
2009 M 23 Full Time Clerks/Assistants Layoff Involuntary 0
2009 M 23 Full Time Clerks/Assistants Layoff Involuntary 0
2009 M 23 Full Time Clerks/Assistants Layoff Involuntary 0
2009 M 24 Full Time Clerks/Assistants Layoff Involuntary 0
2009 M 24 Full Time Clerks/Assistants Layoff Involuntary 0
2009 M 24 Full Time Clerks/Assistants Layoff Involuntary 0
2009 M 24 Full Time Clerks/Assistants Layoff Involuntary 0
2009 M 24 Full Time Clerks/Assistants Layoff Involuntary 0
2009 M 24 Full Time Clerks/Assistants Layoff Involuntary 0
2009 M 24 Full Time Clerks/Assistants Layoff Involuntary 0
2009 M 24 Full Time Clerks/Assistants Layoff Involuntary 0
2009 M 24 Full Time Clerks/Assistants Layoff Involuntary 0
2009 M 24 Full Time Clerks/Assistants Layoff Involuntary 0
2009 M 24 Full Time Clerks/Assistants Layoff Involuntary 0
2009 M 24 Full Time Clerks/Assistants Layoff Involuntary 0
2009 M 24 Full Time …
Canuck Payroll
ID# Occupation Division Gender Age Status Leave Reason Part/Full Time Service Years Average Salary
1 CEO HQ Male 68 Active Active Full Time 52 500000
2 Clerks/Assistants Civil Female 65 Leave LTD Full Time 38 75000
3 Trades Utility Male 66 Active Active Full Time 40 67000
4 Accounting HQ Male 68 Active Active Full Time 41 62000
5 Clerks/Assistants HQ Male 67 Active Active Full Time 46 33000
6 Engineer Utility Male 64 Active Active Full Time 45 137000
7 Drafter Construction Male 64 Active Active Full Time 45 59000
8 Engineer Civil Male 59 Active Active Full Time 35 137000
9 Logistics HQ Male 64 Active Active Full Time 44 57000
10 Engineer Utility Male 65 Active Active Full Time 44 137000
11 Engineer Utility Male 66 Active Active Full Time 41 137000
12 Project Managers Civil Male 66 Active Active Full Time 40 72000
13 VP Utility Engineering HQ Male 66 Active Active Full Time 44 265000
14 Business Development HQ Male 63 Active Active Full Time 44 53000
15 Accounting HQ Female 64 Leave Sick Full Time 43 62000
16 Engineer Civil Male 64 Leave LTD Full Time 43 137000
17 Engineer Utility Male 64 Leave LTD Full Time 38 137000
18 Technician - Engineering Mining Male 68 Leave LTD Full Time 43 72000
19 Accounting HQ Male 62 Active Active Full Time 43 62000
20 Business Development HQ Male 62 Active Active Full Time 43 53000
21 Technician - Engineering Mining Male 62 Active Active Full Time 43 72000
22 Engineer Construction Male 65 Active Active Full Time 43 137000
23 Engineer Construction Male 65 Active Active Full Time 39 137000
24 HR HQ Male 65 Active Active Full Time 43 60000
25 Procurement HQ Male 65 Active Active Part Time 38 70000
26 Engineer Construction Male 62 Active Active Full Time 43 137000
27 Clerks/Assistants HQ Female 62 Leave LTD Full Time 39 33000
28 Trades Mining Male 62 Leave LTD Full Time 42 67000
29 Business Development HQ Male 62 Active Active Full Time 42 53000
30 Engineer Civil Male 62 Active Active Full Time 42 137000
31 Accounting HQ Male 64 Active Active Full Time 42 62000
32 Managers Utility Male 62 Active Active Full Time 42 164000
33 Technician - Engineering Utility Male 64 Active Active Full Time 42 72000
34 Trades Civil Male 66 Active Active Full Time 42 67000
35 Trades Construction Female 59 Leave Sick Full Time 41 67000
36 Clerks/Assistants Mining Female 59 Active Active Full Time 41 33000
37 Engineer Utility Male 57 Active Active Full Time 41 137000
38 Drafter Utility Male 58 Active Active Full Time 41 59000
39 Drafter Mining Male 60 Active Active Full Time 41 59000
40 Engineer Civil Male 60 Active Active Full Time 38 137000
41 VP Mining Engineering HQ Male 60 Active Active Full Time 41 265000
42 Engineer Civil Male 61 Active Active Full Time 41 137000
43 Trades Utility Male 61 Active Active Full Time 41 67000
44 Drafter Mining Male 62 Active Active Full Time 41 59000
45 Engineer Construction Male 63 Active Active Full Time 41 137000
46 Technician - Engineering Civil Male 64 Active Active Full Time 41 72000
47 Analysts Utility Male 60 Leave LTD Full Time 40 46000
48 Drafter Mining Male 60 Leave LTD Full Time 40 59000
49 Trades Construction Male 64 Leave Sick Full Time 40 67000
50 Accounting HQ Female 57 Active Active Full Time 25 62000
51 Technician - Engineering Civil Female 57 Active Active Full Time 33 72000
52 Clerks/Assistants Mining Female 61 Active Active Full Time 40 33000
53 Clerks/Assistants Utility Female 63 Active Active Full Time 40 33000
54 Trades Utility Male 56 Active Active Full Time 40 67000
55 Managers Construction Male 57 Active Active Full Time 32 164000
56 Technician - Engineering Mining Male 57 Active Active Full Time 40 72000
57 Managers Mining Male 58 Active Active Full Time 40 164000
58 Project Managers Mining Male 58 Active Active Full Time 28 72000
59 Technician - Engineering Construction Male 58 Active Active Full Time 40 72000
60 Technician - Engineering Utility Male 58 Active Active Full Time 40 72000
61 Technician - Engineering Utility Male 59 Active Active Full Time 40 72000
62 Drafter Mining Male 60 Active Active Full Time 40 59000
63 Managers Mining Male 60 Active Active Full Time 35 164000
64 Drafter Mining Male 61 Active Active Full Time 40 59000
65 Drafter Construction Male 61 Active Active Full Time 40 59000
66 Project Managers Construction Male 61 Active Active Full Time 40 72000
67 Technician - Engineering Utility Male 61 Active Active Full Time 40 72000
68 Engineer Civil Male 63 Active Active Full Time 40 137000
69 Engineer Mining Male 63 Active Active Full Time 40 137000
70 Engineer Mining Male 63 Active Active Full Time 40 137000
71 Managers Construction Male 63 Active Active Full Time 40 164000
72 Drafter Mining Male 65 Active Active Full Time 40 59000
73 Trades Civil Male 65 Active Active Full Time 40 67000
74 Trades Construction Male 65 Active Active Full Time 40 67000
75 Clerks/Assistants Utility Female 57 Leave Sick Full Time 39 33000
76 Drafter Civil Male 54 Leave LTD Full Time 39 59000
77 Procurement HQ Male 55 Leave Sick Full Time 33 70000
78 Engineer Civil Male 60 Leave LTD Full Time 33 137000
79 Drafter Utility Male 63 Leave LTD Full Time 33 59000
80 Clerks/Assistants HQ Female 55 Active Active Full Time 33 33000
81 Accounting HQ Female 57 Active Active Full Time 33 62000
82 HR HQ Female 58 Active Active Full Time 33 60000
83 Technician - Engineering Civil Female 59 Active Active Full Time 33 72000
84 Drafter Civil Female 65 Active Active Part Time 33 59000
85 Project Managers Civil Female 65 Active Active Full Time 33 72000
86 Engineer Civil Male 55 Active Active Full Time 27 137000
87 Engineer Utility Male 55 Active Active Full Time 33 137000
88 Managers Mining Male 55 Active Active Full Time 33 164000
89 Drafter Mining Male 56 Active Active Full Time 33 59000
90 Drafter Utility Male 56 Active Active Full Time 33 59000
91 Engineer Civil Male 56 Active Active Full Time 33 137000
92 IT HQ Male 56 Active Active Full Time 33 66000
93 Procurement HQ Male 56 Active Active Full Time 33 70000
94 Technician - Engineering Mining Male 56 Active Active Full Time 33 72000
95 Trades Civil Male 56 Active Active Full Time 33 67000
96 Accounting HQ Male 57 Active Active Full Time 33 62000
97 Drafter Utility Male 57 Active Active Full Time 33 59000
98 Engineer Utility Male 57 Active Active Full Time 33 137000
99 Technician - Engineering Mining Male 57 Active Active Full Time 33 72000
100 Trades Mining Male 57 Active Active Full Time 25 67000
101 Drafter Construction Male 58 Active Active Full Time 31 59000
102 Engineer Civil Male 58 Active Active Full Time 33 137000
103 Engineer Utility Male 58 Active Active Full Time 35 137000
104 Managers Mining Male 58 Active Active Full Time 24 164000
105 Managers Construction Male 58 Active Active Full Time 24 164000
106 Trades Utility Male 58 Active Active Full Time 24 67000
107 Trades Civil Male 58 Active Active Full Time 24 67000
108 Drafter Mining Male 59 Active Active Full Time 24 59000
109 Engineer Civil Male 59 Active Active Full Time 24 137000
110 Managers Mining Male 59 Active Active Full Time 24 164000
111 Procurement HQ Male 59 Active Active Full Time 24 70000
112 Procurement HQ Male 59 Active Active Full Time 24 70000
113 Technician - Engineering Utility Male 59 Active Active Full Time 24 72000
114 Technician - Engineering Utility Male 59 Active Active Full Time 24 72000
115 Technician - Engineering Utility Male 59 Active Active Full Time 24 72000
116 Drafter Mining Male 60 Active Active Full Time 39 59000
117 Drafter Construction Male 60 Active Active Full Time 39 59000
118 Drafter Civil Male 60 Active Active Full Time 39 59000
119 Engineer Utility Male 60 Active Active Full Time 39 137000
120 HR HQ Male 60 Active Active Full Time 39 60000
121 Technician - Engineering Civil Male 60 Active Active Full Time 39 72000
122 Drafter Civil Male 61 Active Active Full Time 39 59000
123 Engineer Civil Male 61 Active Active Full Time 39 137000
124 Engineer Utility Male 61 Active Active Full Time 39 137000
125 Engineer Utility Male 61 Active Active Full Time 39 137000
126 Technician - Engineering Utility Male 61 Active Active Full Time 39 72000
127 Analysts Construction Male 62 Active Active Full Time 39 46000
128 Drafter Civil Male 62 Active Active Full Time 39 59000
129 Engineer Construction Male 62 Active Active Full Time 39 137000
130 Engineer Mining Male 62 Active Active Full Time 39 137000
131 Project Managers Civil Male 62 Active Active Full Time 39 72000
132 Technician - Engineering Civil Male 62 Active Active Full Time 39 72000
133 Drafter Construction Male 63 Active Active Full Time 39 59000
134 Engineer Utility Male 63 Active Active Full Time 39 137000
135 Engineer Mining Male 63 Active Active Full Time 39 137000
136 Technician - Engineering Mining Male 63 Active Active Full Time 39 72000
137 Trades Mining Male 64 Active Active Full Time 39 67000
138 Engineer Construction Male 65 Active Active Full Time 39 137000
139 Trades Mining Male 65 Active Active Full Time 39 67000
140 Clerks/Assistants HQ Female 54 Leave LTD Full Time 38 33000
141 Drafter Utility Male 54 Leave LTD Full Time 38 59000
142 Drafter Mining Male 55 Leave LTD Full Time 38 59000
143 Drafter Civil Male 56 Leave LTD Full Time 38 59000
144 Technician - Engineering Civil Male 61 Leave Sick Full Time 38 72000
145 Technician - Engineering Utility Male 61 Leave LTD Full Time 38 72000
146 Clerks/Assistants Utility Male 62 Leave LTD Full Time 38 33000
147 Engineer Civil Male 62 Leave LTD Part Time 38 137000
148 Clerks/Assistants Utility Female 53 Active Active Full Time 38 33000
149 Clerks/Assistants HQ Female 57 Active Active Full Time 38 33000
150 Clerks/Assistants HQ Female 57 Active Active Full Time 38 33000
151 Clerks/Assistants Mining Female 57 Active Active Full Time 38 33000
152 Clerks/Assistants Utility Female 58 Active Active Full Time 38 33000
153 Clerks/Assistants Mining Female 59 Active Active Full Time 38 33000
154 Clerks/Assistants Civil Female 60 Active Active Full Time 38 33000
155 Clerks/Assistants HQ Female 61 Active Active Full Time 38 33000
156 Clerks/Assistants HQ Female 64 Active Active Full Time 36 33000
157 Drafter Utility Male 53 Active Active Full Time 38 59000
158 Engineer Utility Male 53 Active Active Full Time 38 137000
159 Trades Utility Male 53 Active Active Full Time 38 67000
160 Engineer Utility Male 54 Active Active Full Time 38 137000
161 Logistics HQ Male 54 Active Active Full Time 38 57000
162 Managers Construction Male 54 Active Active Full Time 38 164000
163 Technician - Engineering Mining Male 54 Active Active Full Time 38 72000
164 Trades Utility Male 54 Active Active Full Time 38 67000
165 Drafter Mining Male 55 Active Active Full Time 38 59000
166 Drafter Utility Male 55 Active Active Full Time 38 59000
167 Engineer Civil Male 55 Active Active Full Time 38 137000
168 Technician - Engineering Mining Male 55 Active Active Full Time 38 72000
169 Trades Utility Male 55 Active Active Full Time 36 67000
170 Analysts Utility Male 56 Active Active Full Time 38 46000
171 Drafter Mining Male 56 Active Active Full Time 38 59000
172 Engineer Civil Male 56 Active Active Full Time 38 137000
173 HR HQ Male 56 Active Active Full Time 38 60000
174 Technician - Engineering Construction Male 56 Active Active Full Time 38 72000
175 HR HQ Male 57 Active Active Full Time 38 60000
176 Managers Construction Male 57 Active Active Full Time 38 164000
177 Trades Construction Male 57 Active Active Full Time 38 67000
178 Clerks/Assistants Mining Male 58 Active Active Full Time 38 33000
179 Engineer Mining Male 58 Active Active Full Time 38 137000
180 Engineer Mining Male 58 Active Active Full Time 38 137000
181 Project Managers Mining Male 58 Active Active Full Time 38 72000
182 Technician - Engineering Mining Male 58 Active Active Full Time 38 72000
183 Technician - Engineering Utility Male 58 Active Active Full Time 38 72000
184 Drafter Mining Male 59 Active Active Full Time 38 59000
185 Drafter Mining Male 59 Active Active Part Time 38 59000
186 Engineer Civil Male 59 Active Active Full Time 38 137000
187 Engineer Utility Male 59 Active Active Full Time 38 137000
188 HR HQ Male 59 Active Active Full Time 38 60000
189 IT HQ Male 59 Active Active Full Time 38 66000
190 Procurement HQ Male 59 Active Active Full Time 38 70000
191 Technician - Engineering Utility Male 59 Active Active Full Time 38 72000
192 Drafter Utility Male 60 Active Active Full Time 38 59000
193 Engineer Civil Male 60 Active Active Full Time 38 137000
194 Engineer Mining Male 60 Active Active Full Time 38 137000
195 Engineer Mining Male 60 Active Active Full Time 38 137000
196 Technician - Engineering Construction Male 60 Active Active Full Time 38 72000
197 Trades Mining Male 60 Active Active Full Time 38 67000
198 Engineer Civil Male 61 Active Active Full Time 38 137000
199 Engineer Utility Male 61 Active Active Full Time 38 137000
200 Technician - Engineering Mining Male 61 Active Active Full Time 38 72000
201 Drafter Civil Male 62 Active Active Full Time 38 59000
202 IT HQ Male 62 Active Active Full Time 36 66000
203 Drafter Mining Male 63 Active Active Full Time 38 59000
204 Engineer Civil Male 63 Active Active Full Time 38 137000
205 Engineer Utility Male 63 Active Active Full Time 38 137000
206 Trades Construction Male 63 Active Active Full Time 38 67000
207 Engineer Mining Male 64 Active Active Full Time 38 137000
208 Clerks/Assistants HQ Male 65 Active Active Full Time 38 33000
209 Engineer Civil Male 65 Active Active Full Time 38 137000
210 Engineer Construction Male 65 Active Active Full Time 38 137000
211 Trades Construction Male 65 Active Active Full Time 38 67000
212 Clerks/Assistants Civil Female 53 Leave LTD Full Time 37 33000
213 Clerks/Assistants Utility Female 53 Leave LTD Full Time 37 33000
214 Building Maintenance HQ Female 54 Leave Sick Full Time 37 39000
215 Clerks/Assistants Civil Female 56 Leave LTD Full Time 37 33000
216 Clerks/Assistants Civil Female 59 Leave LTD Full Time 37 33000
217 Procurement HQ Female 65 Leave LTD Full Time 37 70000
218 Drafter Civil Male 57 Leave LTD Full Time 37 59000
219 Trades Utility Male 57 Leave LTD Full Time 37 67000
220 Accounting HQ Male 58 Leave LTD Full Time 37 62000
221 IT HQ Male 58 Leave Sick Full Time 37 66000
222 Business Development HQ Male 59 Leave LTD Full Time 37 53000
223 Engineer Civil Male 59 Leave Sick Full Time 37 137000
224 Engineer Utility Male 62 Leave Sick Full Time 37 137000
225 Drafter Construction Male 63 Leave LTD Full Time 37 59000
226 Business Development HQ Male 64 Leave Sick Full Time 37 53000
227 Accounting HQ Female 53 Active Active Full Time 37 62000
228 Clerks/Assistants Civil Female 54 Active Active Full Time 37 33000
229 IT HQ Female 58 Active Active Full Time 37 66000
230 Business Development HQ Female 60 Active Active Full Time 37 53000
231 Clerks/Assistants HQ Female 60 Active Active Full Time 37 33000
232 Clerks/Assistants Mining Female 61 Active Active Full Time 37 33000
233 Clerks/Assistants HQ Male 53 Active Active Full Time 37 33000
234 Drafter Mining Male 54 Active Active Full Time 37 59000
235 Drafter Mining Male 54 Active Active Full Time 37 59000
236 Drafter Utility Male 54 Active Active Full Time 37 59000
237 Drafter Civil Male 54 Active Active Full Time 37 59000
238 Engineer Utility Male 54 Active Active Full Time 37 137000
239 Managers Mining Male 54 Active Active Full Time 37 164000
240 Drafter Mining Male 55 Active Active Part Time 37 59000
241 Drafter Utility Male 55 Active Active Full Time 37 59000
242 Engineer Utility Male 55 Active Active Part Time 37 137000
243 Technician - Engineering Utility Male 55 Active Active Full Time 37 72000
244 Trades Utility Male 55 Active Active Full Time 37 67000
245 Trades Construction Male 55 Active Active Full Time 37 67000
246 Trades Construction Male 55 Active Active Full Time 37 67000
247 Accounting HQ Male 56 Active Active Full Time 37 62000
248 Drafter Mining Male 56 Active Active Full Time 37 59000
249 Drafter Civil Male 56 Active Active Full Time 37 59000
250 Drafter Civil Male 56 Active Active Full Time 37 59000
251 Engineer Mining Male 56 Active Active Full Time 37 137000
252 HR HQ Male 56 Active Active Full Time 37 60000
253 Managers Civil Male 56 Active Active Full Time 37 164000
254 Technician - Engineering Construction Male 56 Active Active Full Time 37 72000
255 Technician - Engineering Utility Male 56 Active Active Full Time 37 72000
256 Technician - Engineering Utility Male 56 Active Active Full Time 37 72000
257 Technician - Engineering Utility Male 56 Active Active Full Time 37 72000
258 Technician - Engineering Utility Male 56 Active Active Full Time 37 72000
259 Trades Utility Male 56 Active Active Full Time 37 67000
260 Trades Mining Male 56 Active Active Full Time 37 67000
261 Business Development HQ Male 57 Active Active Full Time 37 53000
262 Engineer Civil Male 57 Active Active Full Time 37 137000
263 Engineer Civil Male 57 Active Active Full Time 37 137000
264 Technician - Engineering Civil Male 57 Active Active Full Time 37 72000
265 Technician - Engineering Construction Male 57 Active Active Full Time 37 72000
266 Clerks/Assistants Mining Male 58 Active Active Full Time 37 33000
267 Drafter Utility Male 58 Active Active Part Time 37 59000
268 Drafter Construction Male 58 Active Active Full Time 37 59000
269 Engineer Construction Male 58 Active Active Full Time 37 137000
270 Technician - Engineering Construction Male 58 Active Active Full Time 37 72000
271 Trades Mining Male 58 Active Active Full Time 37 67000
272 Analysts Construction Male 59 Active Active Full Time 37 46000
273 Drafter Civil Male 59 Active Active Full Time 37 59000
274 Engineer Utility Male 59 Active Active Full Time 37 137000
275 Engineer Construction Male 59 Active Active Full Time 37 137000
276 Engineer Mining Male 59 Active Active Full Time 37 137000
277 Drafter Mining Male 60 Active Active Full Time 37 59000
278 Engineer Civil Male 60 Active Active Full Time 37 137000
279 Engineer Utility Male 60 Active Active Full Time 37 137000
280 Project Managers Construction Male 60 Active Active Full Time 37 72000
281 Engineer Utility Male 61 Active Active Full Time 37 137000
282 Technician - Engineering Construction Male 61 Active Active Full Time 37 72000
283 VP Construction Engineering HQ Male 61 Active Active Full Time 37 265000
284 Business Development HQ Male 62 Active Active Full Time 37 53000
285 Drafter Civil Male 62 Active Active Full Time 37 59000
286 Engineer Civil Male 62 Active Active Full Time 37 137000
287 Engineer Utility Male 62 Active Active Full Time 37 137000
288 Trades Utility Male 62 Active Active Full Time 37 67000
289 Trades Utility Male 62 Active Active Part Time 37 67000
290 Engineer Utility Male 63 Active Active Full Time 37 137000
291 Engineer Construction Male 63 Active Active Part Time 37 137000
292 Technician - Engineering Utility Male 63 Active Active Full Time 37 72000
293 Trades Utility Male 63 Active Active Full Time 37 67000
294 Trades Utility Male 63 Active Active Full Time 37 67000
295 Accounting HQ Male 64 Active Active Full Time 37 62000
296 Analysts Construction Male 64 Active Active Full Time 37 46000
297 Clerks/Assistants Civil Male 64 Active Active Full Time 37 33000
298 IT HQ Male 64 Active Active Full Time 37 66000
299 Trades Utility Male 64 Active Active Full Time 37 67000
300 Engineer Civil Male 65 Active Active Full Time 37 137000
301 Engineer Utility Male 65 Active Active Full Time 37 137000
302 Technician - Engineering Utility Male 65 Active Active Full Time 37 72000
303 Technician - Engineering Utility Male 58 Leave LTD Full Time 36 72000
304 Trades Construction Male 59 Leave LTD Full Time 36 67000
305 Engineer Utility Male 64 Leave LTD Full Time 36 137000
306 Project Managers Civil Female 51 Active Active Full Time 36 72000
307 Drafter Construction Female 56 Active Active Full Time 36 59000
308 HR HQ Female 57 Active Active Full Time 36 60000
309 Clerks/Assistants HQ Female 60 Active Active Full Time 36 33000
310 Drafter Civil Female 60 Active Active Full Time 36 59000
311 Drafter Civil Male 52 Active Active Full Time 36 59000
312 Procurement HQ Male 52 Active Active Full Time 36 70000
313 Drafter Mining Male 53 Active Active Full Time 36 59000
314 Drafter Utility Male 53 Active Active Full Time 36 59000
315 Trades Construction Male 53 Active Active Full Time 36 67000
316 Clerks/Assistants Utility Male 54 Active Active Full Time 36 33000
317 Drafter Mining Male 54 Active Active Full Time 36 59000
318 Technician - Engineering Civil Male 54 Active Active Full Time 36 72000
319 Trades Utility Male 54 Active Active Full Time 36 67000
320 Trades Utility Male 54 Active Active Full Time 36 67000
321 Trades Utility Male 54 Active Active Full Time 36 67000
322 Engineer Civil Male 55 Active Active Full Time 36 137000
323 Logistics HQ Male 55 Active Active Full Time 36 57000
324 Managers Civil Male 55 Active Active Full Time 36 164000
325 Technician - Engineering Civil Male 55 Active Active Full Time 36 72000
326 Trades Utility Male 55 Active Active Full Time 36 67000
327 Trades Mining Male 55 Active Active Full Time 36 67000
328 Drafter Mining Male 56 Active Active Full Time 36 59000
329 Engineer Construction Male 56 Active Active Full Time 36 137000
330 Engineer Mining Male 56 Active Active Full Time 36 137000
331 Analysts Utility Male 57 Active Active Full Time 36 46000
332 Engineer Mining Male 57 Active Active Full Time 36 137000
333 Engineer Mining Male 57 Active Active Full Time 36 137000
334 Engineer Mining Male 58 Active Active Full Time 36 137000
335 Project Managers Construction Male 58 Active Active Full Time 36 72000
336 Technician - Engineering Utility Male 58 Active Active Full Time 36 72000
337 Clerks/Assistants Mining Male 59 Active Active Full Time 36 33000
338 Engineer Utility Male 59 Active Active Full Time 36 137000
339 Engineer Utility Male 59 Active Active Full Time 36 137000
340 Engineer Construction Male 59 Active Active Full Time 36 137000
341 Trades Construction Male 59 Active Active Full Time 36 67000
342 Drafter Civil Male 60 Active Active Full Time 36 59000
343 Engineer Mining Male 60 Active Active Full Time 36 137000
344 Engineer Utility Male 61 Active Active Full Time 36 137000
345 Engineer Utility Male 61 Active Active Full Time 36 137000
346 Engineer Mining Male 61 Active Active Full Time 36 137000
347 Business Development HQ Male 62 Active Active Full Time 36 53000
348 Trades Utility Male 63 Active Active Full Time 36 67000
349 Engineer Utility Male 64 Active Active Full Time 36 137000
350 Technician - Engineering Mining Male 64 Active Active Full Time 36 72000
351 Technician - Engineering Mining Male 64 Active Active Full Time 36 72000
352 Engineer Utility Male 65 Active Active Full Time 36 137000
353 Clerks/Assistants Civil Female 51 Leave LTD Full Time 35 33000
354 Drafter Utility Female 52 Leave Sick Full Time 35 59000
355 Drafter Construction Female 52 Leave LTD Full Time 35 59000
356 Accounting HQ Female 54 Leave LTD Full Time 35 62000
357 Drafter Utility Female 54 Leave LTD Full Time 35 59000
358 HR HQ Male 52 Leave LTD Full Time 35 60000
359 Logistics HQ Male 53 Leave LTD Full Time 35 57000
360 Trades Civil Male 54 Leave LTD Full Time 35 67000
361 Managers Construction Male 64 Leave LTD Full Time 35 164000
362 Project Managers Mining Female 51 Active Active Full Time 35 72000
363 Project Managers Mining Female 51 Active Active Full Time 35 72000
364 Clerks/Assistants Civil Female 53 Active Active Part Time 35 33000
365 Accounting HQ Female 54 Active Active Full Time 35 62000
366 Accounting HQ Female 56 Active Active Full Time 35 62000
367 Drafter Civil Female 62 Active Active Full Time 35 59000
368 Accounting HQ Male 52 Active Active Full Time 35 62000
369 Engineer Civil Male 52 Active Active Full Time 35 137000
370 Engineer Utility Male 52 Active Active Full Time 35 137000
371 Clerks/Assistants HQ Male 53 Active Active Full Time 35 33000
372 Drafter Utility Male 53 Active Active Full Time 35 59000
373 Drafter Civil Male 53 Active Active Full Time 35 59000
374 Engineer Utility Male 53 Active Active Full Time 35 137000
375 Logistics HQ Male 53 Active Active Full Time 35 57000
376 Managers Civil Male 53 Active Active Full Time 35 164000
377 Technician - Engineering Utility Male 53 Active Active Full Time 35 72000
378 Trades Construction Male 53 Active Active Full Time 35 67000
379 IT HQ Male 54 Active Active Full Time 35 66000
380 Technician - Engineering Utility Male 54 Active Active Full Time 35 72000
381 Trades Utility Male 54 Active Active Full Time 35 67000
382 Trades Civil Male 54 Active Active Full Time 35 67000
383 Drafter Construction Male 55 Active Active Full Time 35 59000
384 Drafter Civil Male 55 Active Active Full Time 35 59000
385 Engineer Utility Male 55 Active Active Full Time 35 137000
386 Technician - Engineering Civil Male 55 Active Active Full Time 35 72000
387 Technician - Engineering Utility Male 55 Active Active Full Time 35 72000
388 Technician - Engineering Utility Male 55 Active Active Full Time 35 72000
389 Accounting HQ Male 56 Active Active Full Time 35 62000
390 Engineer Construction Male 56 Active Active Full Time 35 137000
391 Engineer Mining Male 56 Active Active Full Time 35 137000
392 Project Managers Utility Male 56 Active Active Full Time 35 72000
393 Technician - Engineering Utility Male 56 Active Active Full Time 35 72000
394 Drafter Utility Male 57 Active Active Full Time 35 59000
395 Engineer Construction Male 57 Active Active Full Time 35 137000
396 Procurement HQ Male 57 Active Active Full Time 35 70000
397 Project Managers Utility Male 57 Active Active Full Time 35 72000
398 Trades Utility Male 57 Active Active Full Time 35 67000
399 VP Civil Engineering HQ Male 57 Active Active Full Time 35 265000
400 Clerks/Assistants HQ Male 58 Active Active Full Time 35 33000
401 Drafter Civil Male 58 Active Active Full Time 35 59000
402 Engineer Civil Male 58 Active Active Full Time 35 137000
403 Engineer Utility Male 58 Active Active Full Time 35 137000
404 Managers Utility Male 58 Active Active Full Time 35 164000
405 Project Managers Construction Male 58 Active Active Full Time 35 72000
406 Drafter Mining Male 59 Active Active Full Time 35 59000
407 Technician - Engineering Utility Male 59 Active Active Full Time 35 72000
408 Technician - Engineering Utility Male 59 Active Active Full Time 35 72000
409 Analysts Civil Male 60 Active Active Full Time 35 46000
410 Engineer Civil Male 60 Active Active Full Time 35 137000
411 Engineer Utility Male 61 Active Active Full Time 35 137000
412 Engineer Mining Male 61 Active Active Full Time 35 137000
413 Procurement HQ Male 61 Active Active Full Time 35 70000
414 Trades Mining Male 61 Active Active Part Time 35 67000
415 Engineer Mining Male 62 Active Active Full Time 35 137000
416 Accounting HQ Male 65 Active Active Full Time 35 62000
417 Analysts Construction Male 65 Active Active Full Time 35 46000
418 Business Development HQ Male 65 Active Active Full Time 35 53000
419 Clerks/Assistants Utility Female 55 Leave Sick Full Time 34 33000
420 Accounting HQ Male 61 Leave LTD Full Time 34 62000
421 Trades Mining Male 63 Leave LTD Full Time 34 67000
422 Clerks/Assistants HQ Female 49 Active Active Full Time 34 33000
423 Clerks/Assistants Utility Female 50 Active Active Part Time 34 33000
424 IT HQ Female 50 Active Active Full Time 34 66000
425 Drafter Civil Female 51 Active Active Full Time 34 59000
426 Clerks/Assistants Civil Female 54 Active Active Full Time 34 33000
427 Clerks/Assistants HQ Female 54 Active Active Part Time 34 33000
428 Clerks/Assistants HQ Female 56 Active Active Full Time 34 33000
429 Clerks/Assistants Mining Female 57 Active Active Full Time 34 33000
430 Trades Construction Female 59 Active Active Full Time 34 67000
431 Clerks/Assistants Utility Female 60 Active Active Full Time 34 33000
432 Drafter Mining Male 51 Active Active Full Time 34 59000
433 Trades Civil Male 51 Active Active Full Time 34 67000
434 Drafter Civil Male 52 Active Active Full Time 34 59000
435 Engineer Civil Male 52 Active Active Full Time 34 137000
436 Engineer Mining Male 52 Active Active Full Time 34 137000
437 Project Managers Utility Male 52 Active Active Full Time 34 72000
438 Clerks/Assistants Utility Male 53 Active Active Full Time 34 33000
439 Drafter Utility Male 53 Active Active Full Time 34 59000
440 Drafter Construction Male 53 Active Active Full Time 34 59000
441 Drafter Construction Male 53 Active Active Full Time 34 59000
442 Engineer Civil Male 53 Active Active Full Time 34 137000
443 Engineer Utility Male 53 Active Active Full Time 34 137000
444 Engineer Mining Male 53 Active Active Full Time 34 137000
445 Drafter Construction Male 54 Active Active Full Time 34 59000
446 Engineer Civil Male 54 Active Active Full Time 34 137000
447 Engineer Utility Male 54 Active Active Full Time 34 137000
448 Managers Mining Male 54 Active Active Full Time 34 164000
449 Technician - Engineering Civil Male 54 Active Active Full Time 34 72000
450 Technician - Engineering Construction Male 54 Active Active Full Time 34 72000
451 Trades Mining Male 54 Active Active Full Time 34 67000
FORMAT COMPREHENSIVE ASSIGNMENT HRMN 1023 – HR ANALYTICS
Define:
• Introduction and Executive Summary
• A brief overview of the company and history
Define:
• Identify which four information items you are analyzing and
provide rationale from an HR perspective
Analyze:
• Follow the steps to complete the analysis for each one of the information requests
• Provide data and written analysis for each of the four information items
• Include at least two charts from your pivot table for each item
• Explain what each chart means
• Provide at least three to four paragraphs of written analysis per information item
Recommend:
• Provide HR Recommendations for improvement based on
what issues you identified from the written analysis for each
of the four items
• Identify how these recommendations will improve the
organization
• Include timelines for action
Close the loop:
• Closing summary paragraph reinforces what the report
identified and provides an exit out of the report
Write this last
Step 1: Pivot Table
Step 2: Convert to
Chart
Step 3: paste Chart
into Word
document
Step 4: provide
written analysis
DO THIS FIRST
Write this second
Write this third
Write this fourth
This case is reprinted, modified and used with permission. Original Source: Ashley Beddington - HRPA Metrics
Human Resources Analytics
HRMN 1023
Comprehensive Assignment
Summer
202 1
Case Study – Canuck Engineering Consulting
Based in southern Ontario, Canuck Engineering Consulting is a medium sized consulting firm of over 3,000 employees,
providing expertise to four key sectors in Canada and some northern US states. In the 2020 fiscal year, Canuck earned
gross revenue of over $480 million and turned its first profit since the 2012 fiscal year.
Business Lines
Mining – Canuck employs several types of engineers with significant technical and management experience in several
types of mines from around the world. These engineers have worked in everything from tunnels to open pits, mining
such materials as diamonds, coal, uranium, bauxite, iron, copper, lithium and even rare earth metals in China. These
engineers possess expertise in mine safety, structural integrity, ventilation and water systems, emergency preparedness
and response, and new mine construction.
Construction – The bulk of the revenues (80\%) in this business division are generated from consulting services sold to
large scale projects, including factories, apartment complexes, and commercial office towers. Most of the remaining
services are billed to property developers building new subdivisions of single family homes or townhouses, and Canuck
occasionally picks up a restoration project for unique buildings, such as heritage homes or parks.
Utilities – Canuck provides consulting services to all types of power plants except nuclear reactors, and has a healthy
business providing services to companies distributing electricity via their electrical transmission grids. Lately, Canuck has
seen an increase of business related to ‘smart grids,’ where a high degree of grid computerization and wireless smart
meters are now impacting the North American market. Canuck also has clients in oil and gas distribution, pipelines,
waterworks, sewage treatment, and cable/telephone/wireless networks.
Civic – Typically, the business generated here is related to the civic infrastructure of municipalities and cities. New
subdivisions, parks, roads, highways, bridges, and other city projects require consulting services for development and
auditing. Renovation projects, maintenance, repairs, conversions, and replacements of civic infrastructure also account
for a large percentage of the services provided in this division. However, because many city projects have overlap with
other business lines, many employees in this business division frequently work with other Canuck employees in the
Utilities and Construction business divisions.
Markets
Canuck has always maintained its headquarters in Toronto, Ontario. The majority of Canuck’s clients also maintain their
headquarters in the Greater Toronto Area, so the proximity and access help maintain close and cordial relations, even if
the cost of the maintaining a headquarters in Toronto is high. Canuck’s headquarters is a multi-purpose complex,
consisting of ample office space for corporate support (HR, IT, accounting, etc), state-of-the-art engineering design space
(computer stations, drafting tables, large meeting spaces), and stock yards, warehousing, and loading docks for the
procurement, inventory, and movement of supplies and materials.
Although the headquarters and most of Canuck’s clients are located in Toronto, the vast majority of projects require
many engineers and other employees to work off site at the location of the project. Many mining and utilities projects,
therefore, spread Canuck employees throughout the Canadian Shield, from Manitoba to Quebec. Typically, these
employees are flown in on Sunday night or Monday morning, and return to Toronto on Thursdays to work one final day
at headquarters on Friday. Some projects require the employees to stay lengths of time at the project site, but the
This case is reprinted, modified and used with permission. Original Source: Ashley Beddington - HRPA Metrics
Human Resources Analytics
HRMN 1023
Comprehensive Assignment
Summer
202 1
culture of the company typically does not want people there for longer than 3 weeks, though it does happen on
occasion.
History
Canuck was founded in 1951 by Frederick Taylor, who was the father of the current Chief Executive Officer (CEO), Daniel
Taylor. Frederick was a 30 year old construction engineer in the Canadian Armed Forces serving in Europe during the
Second World War, and upon returning home, founded a company providing engineering consulting services to
Canadian municipalities seeking to build new suburbs for the growing middle class. As Frederick’s new company received
contract after contract for civil engineering in Ontario, he began hiring more former soldiers to work for him as
engineers, labourers, drafters, and trades people.
By 1955, Frederick’s company was facing a decrease in government contracts for civil engineering, and some of his first
employees left the company to go work in mines, power plants, and the construction sector. For the next 5 years,
Frederick battled to keep the company afloat, but when the recession hit in 1960, many of his former employees had
lost their jobs and came back to him looking for projects and jobs. Frederick accepted them back, and in the ensuing two
years, was able to build a lean and efficient company that provided engineering consulting to mines, utilities, and
municipalities. This critical period in Canuck’s development set the tone for the company’s culture up until today, as
evidenced in the resistance to large scale pay increases that could bloat the company’s cost structure.
In 1985, the company moved into the construction sector and expanded into the United States. The economic expansion
in the US and Canada provided ample dollars to do both at the same time, though a recession in 1988 proved to be very
difficult for the firm. The company had contemplated the prospect of layoffs, but decided against it in favour of
company-wide wage rollbacks, a hiring freeze, expense account belt tightening, and asked senior employees to consider
early retirement. Once all of these measures were complete, Frederick formally stepped down as CEO at the age of 65,
blaming himself for what had to be done to survive, even if most employees wanted him to stay on. Daniel formally
stepped in as his successor without much protest, since he’d worked at the company since age 16, become an electrical
engineer by the time he was 21, worked in every division at Canuck after graduation, and was known, liked, and
respected by virtually everyone at the company. Frederick retained full ownership of the company until his death in
2005, and then passed it on in three equal shares to his three children. Daniel’s sisters, Patricia and Jodi, are also well
educated and wealthy, and do not involve themselves in the company. They typically use their share of the profits to
donate to charity or provide scholarships to students in southern Ontario.
When the recession hit in 1988, and lasted through to 1990, Canuck learned to computerize and streamline their
operations. They became one of the first companies in their industry to re-engineer business processes using technology
and created a very lean and efficient overhead. Once the economy rebounded and the tech sector started to grow,
Canuck took full advantage by hiring on many IT professionals and joining them to engineering teams and corporate
support leaders in the headquarters. Their revenue growth through the 1990’s was extensive, and provided the
company with significant cash reserves to invest in employees, technology, marketing, and research. In 2001, however,
the post-September 11th crash hit Canuck’s profits hard and virtually exhausted the company’s cash reserves. However,
the leadership of the company was very proud that not a single layoff had to occur at the time.
Unfortunately, when a second recession began in 2008 and carried into 2011, it proved to be the straw that broke the
camel’s back. The company simply could not continue their ‘no layoff’ culture, and was forced to initiate a series of
layoffs for the first time in the company’s history. The ‘layoff years’ came with considerable pain for the company. While
many older employees volunteered to retire early or leave to allow younger employees with families to stay on, their
This case is reprinted, modified and used with permission. Original Source: Ashley Beddington - HRPA Metrics
Human Resources Analytics
HRMN 1023
Comprehensive Assignment
Summer
202 1
experience and knowledge were the very lifeblood of the company and could not be lost. The layoff processes proved
clumsy, however, since the company and the HR department had never done it before, but in as many cases as possible,
jobs associated with ‘overhead’ at the company were eliminated. The unfortunate consequence of this, however, was
that the office and central service support to the consultants on the front line slowed considerably, and clients became
upset by bad service, shoddy invoicing and accounting, and an inability to even contact the company to ask about
acquiring their services. Even paycheques were showing up wrong from employees who had been at the company for
over 25 years and had never seen a mistake. Employee morale and engagement plummeted.
Survivor syndrome and a cloud of pessimism began to infect the company’s employees. Co-workers who had become
friends were suddenly separated by layoffs and surviving workers started to turn on each other. The many stages of
layoffs and poor execution had everyone on edge and wondering if they were next. The entire company began to hate
the HR department for constantly communicating expectations of no further layoffs, only to turn around shortly
thereafter and issue another wave of layoffs. Leaders and managers who had previously walked the halls of
headquarters or among the project staff on site at client locations began to dread doing so and stayed in their offices.
Even Daniel was seen less in the engineering halls, where he liked to participate in collaboration sessions with drafters
and engineers working on new and unique projects and was rarely seen outside of his office.
Financials
Canuck has gross revenue of over $480 million Canadian for 2020. This follows a downward trend from an all-time high
in 2008 of $580 million. Canuck employs over 3,000 people across 16 different occupational groups, and has employees
working on-site at projects in 7 Canadian provinces and 12 US states. Canadian clients generate 82\% of the company’s
revenue, yet this has fallen since 2010 from 98\% as business in the US has grown faster than business in Canada,
particularly as Canuck started hiring professionals with American or dual citizenship.
Employee compensation at the outset does not seem to be much higher than the midpoint of the labour market for
most occupational groups at Canuck. In the past, this generated higher turnover rates, and the executives did not
approve higher pay scales as it would affect the cost base and the price expectations of current and prospective clients.
To compensate for restricted wages, Canuck has tried out a number of options over time that, have now become part of
the ‘accepted culture’ and have historically not been questioned by employees or management.
Working Conditions
Consulting can be a difficult job for a person of any age. As with most big consulting firms, individual consultants or
teams are sent to projects in remote locations as needed. Canuck consultants, are on the road Monday to Thursday at
client sites, but once the consultant returns home on Thursday or Friday, they are not required to come into the office
unless needed for a meeting or special operational demands. The consultants are typically made up of project managers,
engineers, engineering technicians, trades and drafters who work out in the field either individually or as part of a
consulting team, flying back and forth to remote locations on a weekly basis.
Resources spent on hotels, flights, and employee expensing of food and client entertainment, however, are far more
generous and flexible than larger consulting firms, just to provide a point of ‘differentiation’ in employment with Canuck.
Being on the road, even with generous expense accounts, can also lead to burnout and turnover. Canuck has had to
constantly battle turnover and employee disengagement time and again, particularly as many of the consultants working
in cold, remote locations in the Canadian north would repeatedly request not to be assigned to projects in those
locations again.
This case is reprinted, modified and used with permission. Original Source: Ashley Beddington - HRPA Metrics
Human Resources Analytics
HRMN 1023
Comprehensive Assignment
Summer
202 1
In one instance, in 2010, a mining project was completed in northern Quebec. There were 7 engineers who worked as
part of the consulting team assigned to this project. All of them requested that their next project be closer to their
homes in the greater Toronto area. The manager reviewed their request and then assigned all of them to Sudbury,
Ontario for their next project, because they could fly out of a Toronto airport. However, this prompted all 7 engineers to
tender their resignations immediately and they all left Canuck for good. While this happened over ten years ago this
incident has now become part of Canuck’s negative corporate mythology.
For employees at headquarters, however, the standard model of a 40 hour work week still applied up until 2011. At this
point, pay scales began to fall significantly behind in the labour market and an exodus of professional corporate support
staff took place looking for better pay and perks elsewhere in the greater Toronto area. Again, leadership stalled on HR’s
request to improve pay scales. Instead, they provided an alternate solution in the form of the 10-month work schedule.
The 10 month work schedule has proven especially attractive to many experienced professionals who are looking to
work less in their mid to later years, but has also proven attractive to employees in their 30’s and 40’s raising children.
To ensure fairness, Canuck allows employees working at the headquarters to structure their entire work hours around
10 months of work per year, if they worked 40 hours per week. Parents enjoy taking 1 to 2 months off in July and August
while their children are on vacation, while others flex their entire year around slightly shorter hours per week and then
take a couple of weeks off to go on vacation. Employees at headquarters are allowed to flex their 40 hour work week
into fewer days, such as working Monday to Thursday, 7am to 5pm.
The introduction of this new policy, however, divided the company’s employees into two groups that resented each
other. The consultants who were in constant travel saw themselves as ‘road warriors’ who had to rough it out in remote
places. They considered the headquarters staff as ‘lazy commuters’ who were able to work less hours and take months
of vacation at a time. The headquarters staff saw themselves as ‘innovative and efficient,’ since their reduced time in the
office was associated with lower pay than consultants received, yet the reduced hours gave them an incentive to change
business processes in order to complete their work quicker and faster, so that they could go home. Headquarter staff
saw the consultants (‘road warriors’) as bossy, bitter, and overpaid, even if the consultants were the revenue generators
for the entire company. Organizational leaders were largely unaware of this stark divide, and when they did hear about
it, dismissed it merely as a few disgruntled employees loudly voicing some perceived inequities. Now, however, this
issue has also entrenched itself as part of Canuck’s negative corporate mythology.
Further, Canuck is struggling with its image as a male-dominated, paternalistic culture that is falling behind in its efforts
to promote and support women into traditional consulting roles, management positions and senior leadership positions.
Again, organizational leaders have dismissed these concerns as rumours and continue to see Canuck as a family
oriented, ‘everyone is treated equally’, kind of work place.
The Ticking Time Bomb
On top of the company’s culture and morale problems, the Chief Human Resources Officer recently sounded a few
alarms that could potentially devastate the company’s health.
A recent Human Resources Management post-graduate student from the School of Business at Georgian College started
to pull payroll data and turnover (churn) data from Canuck’s HRIS into excel worksheets. The student’s analysis
suggested that there were significant turnover problems and other problematic patterns in the workforce.
This case is reprinted, modified and used with permission. Original Source: Ashley Beddington - HRPA Metrics
Human Resources Analytics
HRMN 1023
Comprehensive Assignment
Summer
202 1
Unfortunately, this quick analysis was completed only one week before the student’s work term was due to expire, so
the HR department needs more research in order to determine what other information the data will support in relation
to emerging workforce difficulties.
The CEO and the rest of the executive team are interested in what other information and analysis HR can be provided on
the company’s workforce. They have submitted a list of things they would like more information on as follows:
Info Requested Concerns
Retirement Impacts, by occupation and years
of service - excluding senior leadership levels
(C-level and VP level)
What are the historic patterns for early retirement and ‘regular’
retirement?
When looking at data from the current payroll extract, what is the
potential for future retirements in critical occupations and what impact
might these retirements have for each of the occupations?
Turnover Analysis, by occupation and by
termination reason and by termination type
– excluding retirement information
What types of turnover patterns are evident, by occupation? What do
the historic patterns indicate as potential problem areas for the future?
Leadership and succession planning What is the level of urgency needed for the development of a leadership
succession plan? What impact will a leadership succession plan have on
future success? Include and identify role, age, years of service for each
member of the senior leadership team (C-level) and the VP level in your
succession planning analysis.
Salary analysis by occupation, and hierarchical
level of function
What is the evidence that would support (or not support) the ‘road
warriors’ vs. ‘lazy commuter’ compensation and cultural rift in the
organization? Show results including and excluding executive level
salaries in your analysis.
Leaves of Absence Analysis What are the patterns in leaves of absence? Are there particular
divisions and/or occupations that have higher rates of leaves? Where
are the potential problem areas that will impact the workforce?
Occupation by gender analysis Is there evidence of gender ‘discrimination’ in the existing workforce?
What is the pattern that has developed when reviewing service years
and data by occupation, within the organizational hierarchy and gender?
Include the executive level in your analysis.
This case is reprinted, modified and used with permission. Original Source: Ashley Beddington - HRPA Metrics
Human Resources Analytics
HRMN 1023
Comprehensive Assignment
Summer
202 1
Your task
You will prepare and submit a comprehensive report using the information in this case study and working with the data
from “Canuck Payroll 2020” and “Canuck Churn 2020”. You must select 4 of the 6 information requests and provide a
response for each one of the four. You must include information from the databases provided to you to support each
one of your four responses.
Using the HR Storytelling model as a guide, your report must include the following:
1. Cover page with student name and ID.
2. DEFINE: Introductory executive summary
Introduce the company; provide relevant information including the scope of review; the timeline for review; identify
the four information requests you are reviewing and explain why you have chosen each one (identify the problem
and clarify terminology.
3. ANALYZE: Detailed responses to each of the information requests:
• Review and analyze the data by using pivot table(s), lists, graphs or charts using excel formats or spreadsheet
manipulation that have been reviewed in class.
• Each response in the written report must include visual charts or graphs converted from the corresponding pivot
tables found within your excel documents. Do not insert pivot tables into the report.
• Provide a brief written analysis for each of the four information requests that respond to the concerns that have
been identified. You must link your written response to the data analysis that you have completed for each
information request. You must show clear evidence how the data supports your written analysis and response to the
concerns.
• Each written analysis for each information request must be a minimum of three to four paragraphs in length.
4. RECOMMEND:
Provide Human Resources recommendations for organizational success that will address each of the four identified
information requests and link back to the rationale you provided in the introductory executive summary. Identify
what decisions must be made and identify timelines for action.
5. CLOSE THE LOOP:
• Close with a concluding summary statement that encapsulates the concerns and puts closure to the report as a
whole.
Format:
This case is reprinted, modified and used with permission. Original Source: Ashley Beddington - HRPA Metrics
Human Resources Analytics
HRMN 1023
Comprehensive Assignment
Summer
202 1
• Any data (pivot tables, charts, etc) that you use for the report must be saved in individual work sheet format using
Excel. You must submit your completed Excel databases as well as a written report.
• Report must be in written format – professionally produced, typed and formatted.
• You must insert (cut and paste) charts or graphs from each pivot table for reference into the written report for each
information request. Do not cut and paste pivot tables into the written report.
• Save your written report into PDF format.
• Your data worksheets must be saved in Excel and must be identified with your ID.
• Report and spreadsheets are to be submitted electronically only – no hard copy required. o E-mail to:
[email protected]
Deadline for submission: Tuesday, August 17, 2021 @ 4pm - Electronic submission only
• Expect to spend a minimum of 9 to 10 hours to complete this assignment
• Class time (Modules 9 & 10) is set aside for you to assist with the time required for analysis and preparation
You may collaborate with your colleagues to compare data manipulation & analysis results.
• Your final submission must be your own work, in your own words. This is an individual assignment.
• The final product must be professional in appearance, format and content.
• Late submissions will not be accepted and will result in a forfeit of marks (Zero).
• Plagiarized work will result in a forfeit of marks (zero) for the assignment and a zero for the course, in accordance
with Georgian College’s Academic Integrity policies.
CATEGORIES
Economics
Nursing
Applied Sciences
Psychology
Science
Management
Computer Science
Human Resource Management
Accounting
Information Systems
English
Anatomy
Operations Management
Sociology
Literature
Education
Business & Finance
Marketing
Engineering
Statistics
Biology
Political Science
Reading
History
Financial markets
Philosophy
Mathematics
Law
Criminal
Architecture and Design
Government
Social Science
World history
Chemistry
Humanities
Business Finance
Writing
Programming
Telecommunications Engineering
Geography
Physics
Spanish
ach
e. Embedded Entrepreneurship
f. Three Social Entrepreneurship Models
g. Social-Founder Identity
h. Micros-enterprise Development
Outcomes
Subset 2. Indigenous Entrepreneurship Approaches (Outside of Canada)
a. Indigenous Australian Entrepreneurs Exami
Calculus
(people influence of
others) processes that you perceived occurs in this specific Institution Select one of the forms of stratification highlighted (focus on inter the intersectionalities
of these three) to reflect and analyze the potential ways these (
American history
Pharmacology
Ancient history
. Also
Numerical analysis
Environmental science
Electrical Engineering
Precalculus
Physiology
Civil Engineering
Electronic Engineering
ness Horizons
Algebra
Geology
Physical chemistry
nt
When considering both O
lassrooms
Civil
Probability
ions
Identify a specific consumer product that you or your family have used for quite some time. This might be a branded smartphone (if you have used several versions over the years)
or the court to consider in its deliberations. Locard’s exchange principle argues that during the commission of a crime
Chemical Engineering
Ecology
aragraphs (meaning 25 sentences or more). Your assignment may be more than 5 paragraphs but not less.
INSTRUCTIONS:
To access the FNU Online Library for journals and articles you can go the FNU library link here:
https://www.fnu.edu/library/
In order to
n that draws upon the theoretical reading to explain and contextualize the design choices. Be sure to directly quote or paraphrase the reading
ce to the vaccine. Your campaign must educate and inform the audience on the benefits but also create for safe and open dialogue. A key metric of your campaign will be the direct increase in numbers.
Key outcomes: The approach that you take must be clear
Mechanical Engineering
Organic chemistry
Geometry
nment
Topic
You will need to pick one topic for your project (5 pts)
Literature search
You will need to perform a literature search for your topic
Geophysics
you been involved with a company doing a redesign of business processes
Communication on Customer Relations. Discuss how two-way communication on social media channels impacts businesses both positively and negatively. Provide any personal examples from your experience
od pressure and hypertension via a community-wide intervention that targets the problem across the lifespan (i.e. includes all ages).
Develop a community-wide intervention to reduce elevated blood pressure and hypertension in the State of Alabama that in
in body of the report
Conclusions
References (8 References Minimum)
*** Words count = 2000 words.
*** In-Text Citations and References using Harvard style.
*** In Task section I’ve chose (Economic issues in overseas contracting)"
Electromagnetism
w or quality improvement; it was just all part of good nursing care. The goal for quality improvement is to monitor patient outcomes using statistics for comparison to standards of care for different diseases
e a 1 to 2 slide Microsoft PowerPoint presentation on the different models of case management. Include speaker notes... .....Describe three different models of case management.
visual representations of information. They can include numbers
SSAY
ame workbook for all 3 milestones. You do not need to download a new copy for Milestones 2 or 3. When you submit Milestone 3
pages):
Provide a description of an existing intervention in Canada
making the appropriate buying decisions in an ethical and professional manner.
Topic: Purchasing and Technology
You read about blockchain ledger technology. Now do some additional research out on the Internet and share your URL with the rest of the class
be aware of which features their competitors are opting to include so the product development teams can design similar or enhanced features to attract more of the market. The more unique
low (The Top Health Industry Trends to Watch in 2015) to assist you with this discussion.
https://youtu.be/fRym_jyuBc0
Next year the $2.8 trillion U.S. healthcare industry will finally begin to look and feel more like the rest of the business wo
evidence-based primary care curriculum. Throughout your nurse practitioner program
Vignette
Understanding Gender Fluidity
Providing Inclusive Quality Care
Affirming Clinical Encounters
Conclusion
References
Nurse Practitioner Knowledge
Mechanics
and word limit is unit as a guide only.
The assessment may be re-attempted on two further occasions (maximum three attempts in total). All assessments must be resubmitted 3 days within receiving your unsatisfactory grade. You must clearly indicate “Re-su
Trigonometry
Article writing
Other
5. June 29
After the components sending to the manufacturing house
1. In 1972 the Furman v. Georgia case resulted in a decision that would put action into motion. Furman was originally sentenced to death because of a murder he committed in Georgia but the court debated whether or not this was a violation of his 8th amend
One of the first conflicts that would need to be investigated would be whether the human service professional followed the responsibility to client ethical standard. While developing a relationship with client it is important to clarify that if danger or
Ethical behavior is a critical topic in the workplace because the impact of it can make or break a business
No matter which type of health care organization
With a direct sale
During the pandemic
Computers are being used to monitor the spread of outbreaks in different areas of the world and with this record
3. Furman v. Georgia is a U.S Supreme Court case that resolves around the Eighth Amendments ban on cruel and unsual punishment in death penalty cases. The Furman v. Georgia case was based on Furman being convicted of murder in Georgia. Furman was caught i
One major ethical conflict that may arise in my investigation is the Responsibility to Client in both Standard 3 and Standard 4 of the Ethical Standards for Human Service Professionals (2015). Making sure we do not disclose information without consent ev
4. Identify two examples of real world problems that you have observed in your personal
Summary & Evaluation: Reference & 188. Academic Search Ultimate
Ethics
We can mention at least one example of how the violation of ethical standards can be prevented. Many organizations promote ethical self-regulation by creating moral codes to help direct their business activities
*DDB is used for the first three years
For example
The inbound logistics for William Instrument refer to purchase components from various electronic firms. During the purchase process William need to consider the quality and price of the components. In this case
4. A U.S. Supreme Court case known as Furman v. Georgia (1972) is a landmark case that involved Eighth Amendment’s ban of unusual and cruel punishment in death penalty cases (Furman v. Georgia (1972)
With covid coming into place
In my opinion
with
Not necessarily all home buyers are the same! When you choose to work with we buy ugly houses Baltimore & nationwide USA
The ability to view ourselves from an unbiased perspective allows us to critically assess our personal strengths and weaknesses. This is an important step in the process of finding the right resources for our personal learning style. Ego and pride can be
· By Day 1 of this week
While you must form your answers to the questions below from our assigned reading material
CliftonLarsonAllen LLP (2013)
5 The family dynamic is awkward at first since the most outgoing and straight forward person in the family in Linda
Urien
The most important benefit of my statistical analysis would be the accuracy with which I interpret the data. The greatest obstacle
From a similar but larger point of view
4 In order to get the entire family to come back for another session I would suggest coming in on a day the restaurant is not open
When seeking to identify a patient’s health condition
After viewing the you tube videos on prayer
Your paper must be at least two pages in length (not counting the title and reference pages)
The word assimilate is negative to me. I believe everyone should learn about a country that they are going to live in. It doesnt mean that they have to believe that everything in America is better than where they came from. It means that they care enough
Data collection
Single Subject Chris is a social worker in a geriatric case management program located in a midsize Northeastern town. She has an MSW and is part of a team of case managers that likes to continuously improve on its practice. The team is currently using an
I would start off with Linda on repeating her options for the child and going over what she is feeling with each option. I would want to find out what she is afraid of. I would avoid asking her any “why” questions because I want her to be in the here an
Summarize the advantages and disadvantages of using an Internet site as means of collecting data for psychological research (Comp 2.1) 25.0\% Summarization of the advantages and disadvantages of using an Internet site as means of collecting data for psych
Identify the type of research used in a chosen study
Compose a 1
Optics
effect relationship becomes more difficult—as the researcher cannot enact total control of another person even in an experimental environment. Social workers serve clients in highly complex real-world environments. Clients often implement recommended inte
I think knowing more about you will allow you to be able to choose the right resources
Be 4 pages in length
soft MB-920 dumps review and documentation and high-quality listing pdf MB-920 braindumps also recommended and approved by Microsoft experts. The practical test
g
One thing you will need to do in college is learn how to find and use references. References support your ideas. College-level work must be supported by research. You are expected to do that for this paper. You will research
Elaborate on any potential confounds or ethical concerns while participating in the psychological study 20.0\% Elaboration on any potential confounds or ethical concerns while participating in the psychological study is missing. Elaboration on any potenti
3 The first thing I would do in the family’s first session is develop a genogram of the family to get an idea of all the individuals who play a major role in Linda’s life. After establishing where each member is in relation to the family
A Health in All Policies approach
Note: The requirements outlined below correspond to the grading criteria in the scoring guide. At a minimum
Chen
Read Connecting Communities and Complexity: A Case Study in Creating the Conditions for Transformational Change
Read Reflections on Cultural Humility
Read A Basic Guide to ABCD Community Organizing
Use the bolded black section and sub-section titles below to organize your paper. For each section
Losinski forwarded the article on a priority basis to Mary Scott
Losinksi wanted details on use of the ED at CGH. He asked the administrative resident