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

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

Click here to Order a Custom answer to this Question from our writers. It’s fast and plagiarism-free.

 

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: 0 1 2 3 4 5 Sample
North America Size
2010 1 0 2 14 22 11 50
2011 0 0 2 14 20 14 50
2012 1 1 1 8 34 15 60
2013 1 2 6 12 34 45 100
2014 2 3 5 15 44 56 125
South America
2010 0 0 0 2 6 2 10
2011 0 0 0 2 6 2 10
2012 0 0 1 4 11 14 30
2013 0 1 1 3 12 33 50
2014 1 1 2 4 22 60 90
Europe
2010 0 0 1 3 7 4 15
2011 0 0 1 2 8 4 15
2012 0 0 1 2 15 7 25
2013 0 0 1 2 21 6 30
2014 0 0 1 4 17 8 30
Pacific Rim
2010 0 0 1 2 2 0 5
2011 0 0 1 1 3 0 5
2012 0 0 1 1 3 1 6
2013 0 0 0 2 5 3 10
2014 0 0 1 2 7 2 12
China
2012 0 0 0 1 0 0 1
2013 0 0 1 4 2 0 7
2014 0 0 1 5 8 2 16

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

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.

Month World NA SA Eur Pac China
Jan-10 169 102 12 52 3
Feb-10 187 115 13 55 4
Mar-10 210 128 15 61 6
Apr-10 226 136 16 67 7
May-10 232 137 17 73 5
Jun-10 261 151 19 82 9
Jul-10 245 140 18 80 7
Aug-10 223 128 16 76 3
Sep-10 195 103 15 73 4
Oct-10 174 96 14 62 2
Nov-10 154 84 11 59 0
Dec-10 163 99 9 54 1
Jan-11 195 123 10 59 3
Feb-11 221 141 13 62 5
Mar-11 240 152 16 66 6
Apr-11 264 163 20 70 11
May-11 283 178 22 75 8
Jun-11 296 170 28 86 12
Jul-11 269 153 25 81 10
Aug-11 256 146 23 79 8
Sep-11 231 131 20 73 7
Oct-11 214 125 16 68 5
Nov-11 201 118 13 66 4
Dec-11 171 96 11 61 3
Jan-12 200 112 15 66 4 3
Feb-12 216 117 18 71 6 4
Mar-12 234 126 20 76 9 3
Apr-12 253 138 23 79 11 2
May-12 282 152 26 85 14 5
Jun-12 305 163 30 91 15 6
Jul-12 296 156 28 89 18 5
Aug-12 279 148 26 86 15 4
Sep-12 266 143 24 82 13 4
Oct-12 243 131 21 76 12 3
Nov-12 232 128 18 73 10 3
Dec-12 203 107 15 70 7 4
Jan-13 216 110 19 74 8 5
Feb-13 239 123 23 79 10 4
Mar-13 266 138 26 83 13 6
Apr-13 284 150 30 88 11 5
May-13 315 169 33 91 15 7
Jun-13 340 181 37 95 19 8
Jul-13 319 169 34 92 17 7
Aug-13 304 160 32 90 15 7
Sep-13 277 141 29 87 14 6
Oct-13 250 123 26 83 12 6
Nov-13 228 112 24 77 10 5
Dec-13 213 105 23 74 7 4
Jan-14 240 121 26 80 8 5
Feb-14 251 126 28 82 10 5
Mar-14 281 148 31 85 12 5
Apr-14 298 155 35 89 13 6
May-14 322 168 39 95 12 8
Jun-14 350 183 43 98 15 11
Jul-14 330 170 41 95 14 10
Aug-14 311 158 38 93 13 9
Sep-14 289 149 33 89 11 7
Oct-14 265 136 30 85 8 6
Nov-14 239 121 26 80 7 5
Dec-14 219 108 23 76 7 5

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

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.

Month NA SA Europe Pacific China World
Jan-10 6000 200 720 100 0 7020
Feb-10 7950 220 990 120 0 9280
Mar-10 8100 250 1320 110 0 9780
Apr-10 9050 280 1650 120 0 11100
May-10 9900 310 1590 130 0 11930
Jun-10 10200 300 1620 120 0 12240
Jul-10 8730 280 1590 140 0 10740
Aug-10 8140 250 1560 130 0 10080
Sep-10 6480 230 1590 130 0 8430
Oct-10 5990 220 1320 120 0 7650
Nov-10 5320 210 990 130 0 6650
Dec-10 4640 180 660 140 0 5620
Jan-11 5980 210 690 140 0 7020
Feb-11 7620 240 1020 150 0 9030
Mar-11 8370 250 1290 140 0 10050
Apr-11 8830 290 1620 150 0 10890
May-11 9310 330 1650 130 0 11420
Jun-11 10230 310 1590 140 0 12270
Jul-11 8720 290 1560 150 0 10720
Aug-11 7710 270 1530 140 0 9650
Sep-11 6320 250 1590 150 0 8310
Oct-11 5840 250 1260 160 0 7510
Nov-11 4960 240 900 150 0 6250
Dec-11 4350 210 660 150 0 5370
Jan-12 6020 220 570 160 0 6970
Feb-12 7920 250 840 150 0 9160
Mar-12 8430 270 1110 160 0 9970
Apr-12 9040 310 1500 170 0 11020
May-12 9820 360 1440 160 0 11780
Jun-12 10370 330 1410 170 0 12280
Jul-12 9050 310 1440 160 0 10960
Aug-12 7620 300 1410 170 0 9500
Sep-12 6420 280 1350 180 0 8230
Oct-12 5890 270 1080 180 0 7420
Nov-12 5340 260 840 190 0 6630
Dec-12 4430 230 510 180 0 5350
Jan-13 6100 250 480 200 0 7030
Feb-13 8010 270 750 190 0 9220
Mar-13 8430 280 1140 200 0 10050
Apr-13 9110 320 1410 210 0 11050
May-13 9730 380 1340 190 0 11640
Jun-13 10120 360 1360 200 0 12040
Jul-13 9080 320 1410 200 0 11010
Aug-13 7820 310 1490 210 0 9830
Sep-13 6540 300 1310 220 0 8370
Oct-13 6010 290 980 210 0 7490
Nov-13 5270 270 770 220 0 6530
Dec-13 538

Place your order now for a similar assignment and have exceptional work written by one of our experts, guaranteeing you an A result.

Need an Essay Written?

This sample is available to anyone. If you want a unique paper order it from one of our professional writers.

Get help with your academic paper right away

Quality & Timely Delivery

Free Editing & Plagiarism Check

Security, Privacy & Confidentiality