Help with case study paper

profileAV0723
CaseStudyData.xlsx
Home>Business & Finance homework help>Operations Management homework help>Help with case study paper

Manager Data

RST Manufacturing
Current Leadership/Management
Name Position Service Mgt Decision style Leadership style Power type
Art Anderson President 2017-2020 Autocratic Transactional Coercive
David Davis Operations Manager 2017-2020 Autocratic Transactional Coercive
Elizabeth English CFO/HR Manager 2020-2020 Democratic Servant Reward
Helen Hayes Engineering/Maint Manager 2020-2020 Laissez-Faire Transactional Reward
Ingred Ingle Quality Manager 2019-2020 Autocratic Transactional Expert
Charlie Chan IT Manager 2001-2017 Laissez-Faire Transformational Expert
Karen Kemp Purchasing/Materials Manager 2019-2020 Autocratic Transactional Coercive
Previous Leadership/Management
Name Position Service Mgt Decision style Leadership style Power type
Jerry Jones President-retired 1980-2017 Democratic Servant Referent
Dan Demis CFO-retired 1980-2017 Democratic Transformational Expert
Larry Lange Ops Manager-retired 1980-2017 Democratic Situational Legitimate
Mike Moore HR Manager-retired 1980-2010 Democratic Servant Expert
Nancy Nice HR Manager-quit 2010-2015 Democratic Transactional Expert
Olga Older HR Manager-quit 2015-2017 Democratic Servant Reward
Sam Selic Purchasing Manager-retired 1980-2010 Democratic Transactional Expert
Tom Thompson Purchasing Manager 2010-2015 Democratic Transformational Expert
Vicky Vanover Purchasing Manager 2015-2017 Democratic Servant Legitimate
Andy Andrews Engineering Manager-retired 1980-2017 Democratic Transformational Expert
Bob Bex Maintenance Manager-retired 1980-2017 Democratic Transformational Expert
Carl Candle Materials Manager-retired 1980-2017 Democratic Transformational Expert
Don Drysdale Quality Manager-deceased 1980-2000 Democratic Transactional Referent
Earl Engle Quality Manager-quit 2001-2019 Democratic Transformational Expert

BMIS 501

©W2 Solutions, LLC

Profit

Year 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020
Profit in Millions -0.17 0.25 0.4 0.6 0.8 0.7 1.5 1.2 1.8 2.1 2.3 2.8 4.1 4.3 4.4 3.9 4.9 4.8 4.7 5.3 3.6 5.5 6.4 6.6 6.9 7 7.3 7.5 6.9 7.8 9 8.5 8.8 9.4 10 8.5 11 10.9 4 1 -2.3

Profit in Millions 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 -0.17 0.25 0.4 0.6 0.8 0.7 1.5 1.2 1.8 2.1 2.2999999999999998 2.8 4.0999999999999996 4.3 4.4000000000000004 3.9 4. 9000000000000004 4.8 4.7 5.3 3.6 5.5 6.4 6.6 6.9 7 7.3 7.5 6.9 7.8 9 8.5 8.8000000000000007 9.4 10 8.5 11 10.9 4 1 -2.2999999999999998 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020

Quality

Year 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020
Rejects per 1000 70 80 75 60 55 56 64 45 36 32 27 28 32 40 25 31 27 18 27 24 18 25 19 17 19 15 12 13 11 17 12 10 9 8 9 8 9 7 57 101 160

Rejects per 1000 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 70 80 75 60 55 56 64 45 36 32 27 28 32 40 25 31 27 18 27 24 18 25 19 17 19 15 12 13 11 17 12 10 9 8 9 8 9 7 57 101 160 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020

Management Overtime

Year 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020
Management Overtime Hours 1200 1100 850 900 975 868 750 550 980 687 789 510 750 658 852 750 800 680 550 600 2050 1500 550 980 687 789 510 750 658 852 750 800 680 550 600 700 650 550 2800 3500 4000

Management Overtime Hours 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 1200 1100 850 900 975 868 750 550 980 687 789 510 750 658 852 750 800 680 550 600 2050 1500 550 980 687 789 510 750 658 852 750 800 680 550 600 700 650 550 2800 3500 4000 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020

Worker Overtime

Year 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020
Worker Overtime Hours per Employee 48 56 48 50 40 36 42 36 40 24 26 32 40 27 16 20 40 18 23 28 57 32 21 25 30 23 31 23 28 30 18 23 28 27 20 21 23 24 120 240 360

Worker Overtime Hours per Employee 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 48 56 48 50 40 36 42 36 40 24 26 32 40 27 16 20 40 18 23 28 57 32 21 25 30 23 31 23 28 30 18 23 28 27 20 21 23 24 120 240 360 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020

Accidents

Year 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020
Accidents 3 7 5 9 7 2 10 11 13 7 9 5 7 8 6 4 5 3 5 6 4 8 9 10 2 3 2 5 8 4 5 8 5 7 6 3 4 3 25 54 89

Accidents 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 3 7 5 9 7 2 10 11 13 7 9 5 7 8 6 4 5 3 5 6 4 8 9 10 2 3 2 5 8 4 5 8 5 7 6 3 4 3 25 54 89 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020

All data

Year 1980 1981 1982 1983 1984 1985 1986 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020
Rejects per 1000 70 80 75 60 55 56 64 45 36 32 27 28 32 40 25 31 27 18 27 24 18 25 19 17 19 15 12 13 11 17 12 10 9 8 9 8 9 7 57 101 160
Accidents 3 7 5 9 7 2 10 11 13 7 9 5 7 8 6 4 5 3 5 6 4 8 9 10 2 3 2 5 8 4 5 8 5 7 6 3 4 3 25 54 89
Management Overtime Hours 1200 1100 850 900 975 868 750 550 980 687 789 510 750 658 852 750 800 680 550 600 2050 1500 550 980 687 789 510 750 658 852 750 800 680 550 600 700 650 550 2800 3500 4000
Worker Overtime Hours per Employee 48 56 48 50 40 36 42 36 40 24 26 32 40 27 16 20 40 18 23 28 57 32 21 25 30 23 31 23 28 30 18 23 28 27 20 21 23 24 120 240 360
Profit in Millions -0.17 0.25 0.4 0.6 0.8 0.7 1.5 1.2 1.8 2.1 2.3 2.8 4.1 4.3 4.4 3.9 4.9 4.8 4.7 5.3 3.6 5.5 6.4 6.6 6.9 7 7.3 7.5 6.9 7.8 9 8.5 8.8 9.4 10 8.5 11 10.9 4 1 -2.3
Correlation Profit to rejects /1000 -0.82
Correlation Profit to accidents -0.42
Correlation Profit to management OT -0.44
Correlation Profit to worker OT -0.48