Case Study-Performance Lawn Care – Episode 5 In reviewing the PLE data, Elizabeth Burke noticed that defects received from suppliers have decreased (worksh

 

In reviewing the PLE data, Elizabeth Burke noticed that defects received from suppliers have decreased (worksheet Defects After Delivery). Upon investigation, she learned that in 2010, PLE experienced some quality problems due to an increasing number of defects in materials received from suppliers. The company instituted an initiative in August 2011 to work with suppliers to reduce these defects, to more closely coordinate deliveries, and to improve material quality through reengineering supplier production policies. Elizabeth noted that the program appeared to reverse an increasing trend in defects; she would like to predict what might have happened had the supplier initiative not been implemented and how the number of defects might further be reduced in the near future.

In meeting with PLE’s human resources director, Elizabeth also discovered a concern about the high rate of turnover in its field service staff. Senior managers have suggested that the department look closer at its recruiting policies, particularly to try to identify the characteristics of individuals that lead to greater retention. However, in a recent staff meeting, HR managers could not agree on these characteristics. Some argued that years of education and grade point averages were good predictors. Others argued that hiring more mature applicants would lead to greater retention. To study these factors, the staff agreed to conduct a statistical study to determine the effect that years of education, college grade point average, and age when hired have on retention. A sample of 40 field service engineers hired 10 years ago was selected to determine the influence of these variables on how long each individual stayed with the company. Data are compiled in the Employee Retention worksheet.

Finally, as part of its efforts to remain competitive, PLE tries to keep up with the latest in production technology. This is especially important in the highly competitive lawn mower line, in which competitors can gain a real advantage if they develop more cost-effective means of production. Therefore, the lawn mower division spends a great deal of effort in testing new technology. When new production technology is introduced, firms often experience learning, resulting in a gradual decrease in the time required to produce successive units. Generally, the rate of improvement declines until the production time levels off. One example is the production of a new design for lawn mower engines. To determine the time required to produce these engines, PLE produced 50 units on its production line; test results are given on the worksheet Engines in the database. Because PLE is continually developing new technology, understanding the rate of learning can be useful in estimating future production costs without having to run extensive prototype trials, and Elizabeth would like a better handle on this. Use techniques of regression analysis to assist her in evaluating the data in these three worksheets and reaching useful conclusions. Summarize your work in a formal report with all appropriate results and analyses and upload your Word document AND your Excel worksheet file 

Dealer Satisfaction

Dealer Satisfaction
tc={BC340A24-8BBA-491F-B401-F2D940BCB741}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:
This chart is showing Dealer Satisfaction between North America, South America, Europe, Pacific Rim and China. The data that was selected was rated on a a survery scale from 0-5 and between the the years of 2010-2014, except for China who started later in 2012. North America was leading in sample size and “in 5s” dealer satisfacion for “excelltence”. Although North America recieved the highest total numbers in dealer satisfactions for excellent rankings, in 2014, South America recieved 60 surverys and North America recieved 56 within the level 5 category.

Survey Scale:012345Sample
North AmericaSize
201010214221150
201100214201450
20121118341560
2013126123445100
2014235154456125
South America
201000026210
201100026210
20120014111430
20130113123350
20141124226090
Europe
201000137415
201100128415
2012001215725
2013001221630
2014001417830
Pacific Rim
20100012205
20110011305
20120011316
201300025310
201400127212
China
20120001001
20130014207
201400158216

Dealer Satisfaction by Region and Year

0 2010 2011 2012 2013 2014 South America 2010 2011 2012 2013 2014 Europe 2010 2011 2012 2013 2014 Pacific Rim 2010 2011 2012 2013 2014 China 2012 2013 2014 1 0 1 1 2 0 0 0 0 1 0 0 0 0 0 0 0 0 0 0 0 0 0 1 2010 2011 2012 2013 2014 South America 2010 2011 2012 2013 2014 Europe 2010 2011 2012 2013 2014 Pacific Rim 2010 2011 2012 2013 2014 China 2012 2013 2014 0 0 1 2 3 0 0 0 1 1 0 0 0 0 0 0 0 0 0 0 0 0 0 2 2010 2011 2012 2013 2014 South America 2010 2011 2012 2013 2014 Europe 2010 2011 2012 2013 2014 Pacific Rim 2010 2011 2012 2013 2014 China 2012 2013 2014 2 2 1 6 5 0 0 1 1 2 1 1 1 1 1 1 1 1 0 1 0 1 1 3 2010 2011 2012 2013 2014 South America 2010 2011 2012 2013 2014 Europe 2010 2011 2012 2013 2014 Pacific Rim 2010 2011 2012 2013 2014 China 2012 2013 2014 14 14 8 12 15 2 2 4 3 4 3 2 2 2 4 2 1 1 2 2 1 4 5 4 2010 2011 2012 2013 2014 South America 2010 2011 2012 2013 2014 Europe 2010 2011 2012 2013 2014 Pacific Rim 2010 2011 2012 2013 2014 China 2012 2013 2014 22 20 34 34 44 6 6 11 12 22 7 8 15 21 17 2 3 3 5 7 0 2 8 5 2010 2011 2012 2013 2014 South America 2010 2011 2012 2013 2014 Europe 2010 2011 2012 2013 2014 Pacific Rim 2010 2011 2012 2013 2014 China 2012 2013 2014 11 14 15 45 56 2 2 14 33 60 4 4 7 6 8 0 0 1 3 2 0 0 2

This chart is showing Dealer Satisfaction between North America, South America, Europe, Pacific Rim and China. The data that was selected was rated on a a survery scale from 0-5 and between the the years of 2010-2014, except for China who started later in 2012. North America was leading in sample size and “in 5s” dealer satisfacion for “excelltence”. Although North America recieved the highest total numbers in dealer satisfactions for excellent rankings, in 2014, South America recieved 60 surverys and North America recieved 56 within the level 5 category.

End-User Satisfaction

End-User Satisfaction
tc={4E1782D3-7E9F-4E7B-83FB-A93AAF2BD2E6}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:
This chart is showing End-User Satisfaction between North America, South America, Europe, Pacific Rim and China. The data that was selected was rated on a a survery scale from 0-5 and between the the years of 2010-2014, except for China who started later in 2012. North America, South America, Europe, and the Pacific Rim all have the same sample size of 100 for each year between 2010 through 2014. China has a smaller sample size of 50 between the years of 2012 through 2014. You cansee that the ratings of 5’s, 4’s, and 3’s are the highest ratings. North America’s rating of 4 decreases every year starting with 2010 while the 5 ratings increase through the years. The Pacfic Rim’s 4 ratings are highest rated and is basically constant throughout the years while the 5 ratings are lower then 4 ratings the 5’s are constant throughout the years.

Sample
North America012345Size
2010136153738100
2011124183540100
2012125173441100
2013024153346100
2014023153149100
South America
2010125183638100
2011136173637100
2012026193736100
2013025203736100
2014025193737100
Europe
2010124213636100
2011125213437100
2012114263731100
2013113174137100
2014012194533100
Pacific Rim
2010235154134100
2011127154134100
2012125164036100
2013024174037100
2014013194235100
China
20120336281050
20131224301150
20140113311450

End-User Satisfaction by Region and Year

0 2010 2011 2012 2013 2014 South America 2010 2011 2012 2013 2014 Europe 2010 2011 2012 2013 2014 Pacific Rim 2010 2011 2012 2013 2014 China 2012 2013 2014 1 1 1 0 0 1 1 0 0 0 1 1 1 1 0 2 1 1 0 0 0 1 0 1 2010 2011 2012 2013 2014 South America 2010 2011 2012 2013 2014 Europe 2010 2011 2012 2013 2014 Pacific Rim 2010 2011 2012 2013 2014 China 2012 2013 2014 3 2 2 2 2 2 3 2 2 2 2 2 1 1 1 3 2 2 2 1 3 2 1 2 2010 2011 2012 2013 2014 South America 2010 2011 2012 2013 2014 Europe 2010 2011 2012 2013 2014 Pacific Rim 2010 2011 2012 2013 2014 China 2012 2013 2014 6 4 5 4 3 5 6 6 5 5 4 5 4 3 2 5 7 5 4 3 3 2 1 3 2010 2011 2012 2013 2014 South America 2010 2011 2012 2013 2014 Europe 2010 2011 2012 2013 2014 Pacific Rim 2010 2011 2012 2013 2014 China 2012 2013 2014 15 18 17 15 15 18 17 19 20 19 21 21 26 17 19 15 15 16 17 19 6 4 3 4 2010 2011 2012 2013 2014 South America 2010 2011 2012 2013 2014 Europe 2010 2011 2012 2013 2014 Pacific Rim 2010 2011 2012 2013 2014 China 2012 2013 2014 37 35 34 33 31 36 36 37 37 37 36 34 37 41 45 41 41 40 40 42 28 30 31 5 2010 2011 2012 2013 2014 South America 2010 2011 2012 2013 2014 Europe 2010 2011 2012 2013 2014 Pacific Rim 2010 2011 2012 2013 2014 China 2012 2013 2014 38 40 41 46 49 38 37 36 36 37 36 37 31 37 33 34 34 36 37 35 10 11 14

This chart is showing End-User Satisfaction between North America, South America, Europe, Pacific Rim and China. The data that was selected was rated on a a survery scale from 0-5 and between the the years of 2010-2014, except for China who started later in 2012. North America, South America, Europe, and the Pacific Rim all have the same sample size of 100 for each year between 2010 through 2014. China has a smaller sample size of 50 between the years of 2012 through 2014. You can see that the ratings of 5’s, 4’s, and 3’s are the highest ratings. North America’s rating of 4 decreases every year starting with 2010 while the 5 ratings increase through the years. The Pacfic Rim’s 4 ratings are highest rated and is basically constant throughout the years while the 5 ratings are lower then 4 ratings the 5’s are constant throughout the years.

Complaints

Complaints
tc={3A6BEBAD-C122-4573-AF72-C42391975593}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:
This chart is showing PLE’s Complaoints from registered by all customers each month within PLE’s 5 regions. From this data we can conclude that there is more use of the equipment in the summer months because of the higher number of complaints recieved. Based off the data shown form the region of China, their compaints are few and are steady throughout the months. This could be because they do not use this type of equipment in comparison to the other regions.

MonthWorldNASAEurPacChina
Jan-1016910212523
Feb-1018711513554
Mar-1021012815616
Apr-1022613616677
May-1023213717735
Jun-1026115119829
Jul-1024514018807
Aug-1022312816763
Sep-1019510315734
Oct-101749614622
Nov-101548411590
Dec-10163999541
Jan-1119512310593
Feb-1122114113625
Mar-1124015216666
Apr-11264163207011
May-1128317822758
Jun-11296170288612
Jul-11269153258110
Aug-1125614623798
Sep-1123113120737
Oct-1121412516685
Nov-1120111813664
Dec-111719611613
Jan-12200112156643
Feb-12216117187164
Mar-12234126207693
Apr-122531382379112
May-122821522685145
Jun-123051633091156
Jul-122961562889185
Aug-122791482686154
Sep-122661432482134
Oct-122431312176123
Nov-122321281873103
Dec-12203107157074
Jan-13216110197485
Feb-132391232379104
Mar-132661382683136
Apr-132841503088115
May-133151693391157
Jun-133401813795198
Jul-133191693492177
Aug-133041603290157
Sep-132771412987146
Oct-132501232683126
Nov-132281122477105
Dec-13213105237474
Jan-14240121268085
Feb-142511262882105
Mar-142811483185125
Apr-142981553589136
May-143221683995128
Jun-1435018343981511
Jul-1433017041951410
Aug-143111583893139
Sep-142891493389117
Oct-14265136308586
Nov-14239121268075
Dec-14219108237675

Complaints by Month and Region

World 40179 40210 40238 40269 40299 40330 40360 40391 40422 40452 40483 40513 40544 40575 40603 40634 40664 40695 40725 40756 40787 40817 40848 40878 40909 40940 40969 41000 41030 41061 41091 41122 41153 41183 41214 41244 41275 41306 41334 41365 41395 41426 41456 41487 41518 41548 41579 41609 41640 41671 41699 41730 41760 41791 41821 41852 41883 41913 41944 41974 169 187 210 226 232 261 245 223 195 174 154 163 195 221 240 264 283 296 269 256 231 214 201 171 200 216 234 253 282 305 296 279 266 243 232 203 216 239 266 284 315 340 319 304 277 250 228 213 240 251 281 298 322 350 330 311 289 265 239 219 NA 40179 40210 40238 40269 40299 40330 40360 40391 40422 40452 40483 40513 40544 40575 40603 40634 40664 40695 40725 40756 40787 40817 40848 40878 40909 40940 40969 41000 41030 41061 41091 41122 41153 41183 41214 41244 41275 41306 41334 41365 41395 41426 41456 41487 41518 41548 41579 41609 41640 41671 41699 41730 41760 41791 41821 41852 41883 41913 41944 41974 102 115 128 136 137 151 140 128 103 96 84 99 123 141 152 163 178 170 153 146 131 125 118 96 112 117 126 138 152 163 156 148 143 131 128 107 110 123 138 150 169 181 169 160 141 123 112 105 121 126 148 155 168 183 170 158 149 136 121 108 SA 40179 40210 40238 40269 40299 40330 40360 40391 40422 40452 40483 40513 40544 40575 40603 40634 40664 40695 40725 40756 40787 40817 40848 40878 40909 40940 40969 41000 41030 41061 41091 41122 41153 41183 41214 41244 41275 41306 41334 41365 41395 41426 41456 41487 41518 41548 41579 41609 41640 41671 41699 41730 41760 41791 41821 41852 41883 41913 41944 41974 12 13 15 16 17 19 18 16 15 14 11 9 10 13 16 20 22 28 25 23 20 16 13 11 15 18 20 23 26 30 28 26 24 21 18 15 19 23 26 30 33 37 34 32 29 26 24 23 26 28 31 35 39 43 41 38 33 30 26 23 Eur 40179 40210 40238 40269 40299 40330 40360 40391 40422 40452 40483 40513 40544 40575 40603 40634 40664 40695 40725 40756 40787 40817 40848 40878 40909 40940 40969 41000 41030 41061 41091 41122 41153 41183 41214 41244 41275 41306 41334 41365 41395 41426 41456 41487 41518 41548 41579 41609 41640 41671 41699 41730 41760 41791 41821 4185 2 41883 41913 41944 41974 52 55 61 67 73 82 80 76 73 62 59 54 59 62 66 70 75 86 81 79 73 68 66 61 66 71 76 79 85 91 89 86 82 76 73 70 74 79 83 88 91 95 92 90 87 83 77 74 80 82 85 89 95 98 95 93 89 85 80 76 Pac 40179 40210 40238 40269 40299 40330 40360 40391 40422 40452 40483 40513 40544 40575 40603 40634 40664 40695 40725 40756 40787 40817 40848 40878 40909 40940 40969 41000 41030 41061 41091 41122 41153 41183 41214 41244 41275 41306 41334 41365 41395 41426 41456 41487 41518 41548 41579 41609 41640 41671 41699 41730 41760 41791 41821 41852 41883 41913 41944 41974 3 4 6 7 5 9 7 3 4 2 0 1 3 5 6 11 8 12 10 8 7 5 4 3 4 6 9 11 14 15 18 15 13 12 10 7 8 10 13 11 15 19 17 15 14 12 10 7 8 10 12 13 12 15 14 13 11 8 7 7 China 40179 40210 40238 40269 40299 40330 40360 40391 40422 40452 40483 40513 40544 40575 40603 40634 40664 40695 40725 40756 40787 40817 40848 40878 40909 40940 40969 41000 41030 41061 41091 41122 41153 41183 41214 41244 41275 41306 41334 41365 41395 41426 41456 41487 41518 41548 41579 41609 41640 41671 41699 41730 41760 41791 41821 41852 41883 41913 41944 41974 3 4 3 2 5 6 5 4 4 3 3 4 5 4 6 5 7 8 7 7 6 6 5 4 5 5 5 6 8 11 10 9 7 6 5 5

This chart is showing PLE’s Complaints from registered customers each month within PLE’s 5 regions. From this data we can conclude that there is more use of the equipment in the summer months because of the higher number of complaints recieved. China has the fewest number of compaints, this is due to the less customer usage. Based off the data, the Pacific Rim and South America do not have as many complaints as North America does due to less people using or purchasing PLE’s equipment. .

Mower Unit Sales

Looking for this or a Similar Assignment? Click below to Place your Order

Mower Unit Sales
tc={6A814A1A-8E51-48A1-A543-AEC7E2B5497F}: [Threaded comment]

Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

Comment:
The chart identifies the unit sales PLE’s mower equipment. We can see that the highest peak for mower sales is in the summer months and then a decline in sales starting in early fall months. BAsed off this chart, North America is the region with the highest unit sales for PLE’s mowers.

MonthNASAEuropePacificChinaWorld
Jan-10600020072010007020
Feb-10795022099012009280
Mar-108100250132011009780
Apr-1090502801650120011100
May-1099003101590130011930
Jun-10102003001620120012240
Jul-1087302801590140010740
Aug-1081402501560130010080
Sep-106480230159013008430
Oct-105990220132012007650
Nov-10532021099013006650
Dec-10464018066014005620
Jan-11598021069014007020
Feb-117620240102015009030
Mar-1183702501290140010050
Apr-1188302901620150010890
May-1193103301650130011420
Jun-11102303101590140012270
Jul-1187202901560150010720
Aug-117710270153014009650
Sep-116320250159015008310
Oct-115840250126016007510
Nov-11496024090015006250
Dec-11435021066015005370
Jan-12602022057016006970
Feb-12792025084015009160
Mar-128430270111016009970
Apr-1290403101500170011020
May-1298203601440160011780
Jun-12103703301410170012280
Jul-1290503101440160010960
Aug-127620300141017009500
Sep-126420280135018008230
Oct-125890270108018007420
Nov-12534026084019006630
Dec-12443023051018005350
Jan-13610025048020007030
Feb-13801027075019009220
Mar-1384302801140200010050
Apr-1391103201410210011050
May-1397303801340190011640
Jun-13101203601360200012040
Jul-1390803201410200011010
Aug-137820