Fluent Essays

Assignment:Elizabeth Burke has recently joined the PLE management team to oversee production operations. She has reviewed the types of data that the company collects and has assigned you the responsibility to be her chief analyst in the coming weeks. To prepare for this task, you have decided to review each worksheet and determine whether the data were gathered from internal sources, external sources, or have been generated from special studies. Also, you need to know whether the measures are categorical, ordinal, interval, or ratio.Prepare a report summarizing the characteristics of the metrics used in each worksheet.Elizabeth Burke has asked you to do some preliminary analysis of the data in the Performance Lawn Equipment database.First, she would like you to edit the worksheets Dealer Satisfaction and End-User Satisfaction to display the total number of responses to each level of the survey scale across all regions for each year.Second, she wants a count of the number of failures in the worksheet Mower Test.Next, Elizabeth has provided you with prices for PLE products for the past 5 years:YearMower Price ($)Tractor Price ($)20101503,25020111753,40020121803,60020131853,70020141903,800Create a new worksheet in the database to compute gross revenues by month and region, as well as worldwide totals, for each product using the data in Mower Unit Sales and Tractor Unit Sales.Finally, she wants to know the market share for each product and region based on the PLE and industry sales data in the database.Create and save these calculations in a new worksheet. Summarize all your findings in a report to Ms. Burke..-------------------------------------------------------------------------------------------------------------------------------.Please develop YOUR OWN TEAM Business Analytics EXCEL model(s) to support all your answers and analyses and post this(these) file(s) in addition to your Case Analysis Performance Lawn Equipment Report. .Finally, please answer ALL Questions and Sections of this Data Analytics for Business Case with great detail AND STEP BY STEP being extremely methodical and accurate in your answers. It is extremely important that for each Question and Section, you write the entire question and you LABEL and/or PLACE the appropriate headings and subheadings clearly for EACH part of the question and/or section..Please address, analyze, and discuss in great detail and thoroughly support and explain the what’s, how’s, and why’s of each of your answers. .I expect high caliber Case Analysis Reports with top analyses and interesting insights!! If you have any questions, please let me know. I am here to help..Jose Rocha.-------------------------------------------------------------------------------------------------------------------------------.Learning Assignment Guidelines.Case Analysis Written Report:This document should be a typed professional written report in Word and PDF format with a 1.5 max line space, a suitable font such as Times Roman or Calibri of 12 point maximum, and left, right, top, bottom margins of .8 inches maximum..** No Word and PDF format documents: No grading..Please submit your Team Case Analysis Written Report and YOUR OWN TEAM Business Analytics Case Analysis EXCEL model(s) files..** No Team Case Analysis Written Report and YOUR OWN TEAM Business Analytics Case Analysis EXCEL model(s) files: No grading..TurnItIn Originality Score IndexCase Analysis Reports with a TurnItIn Originality Score Index:* Orange (50-74\% similarity index) and/or Red (75-100\% similarity index)will NOT be graded and will be reviewed and assess for potentialAcademic Dishonesty misconduct..Using APA Style and Tips in WritingYou can find several readings and support material for your writing learning assignments and APA Style use at our Canvas Learning Management System section:Course Content: 1.2 Using APA Style and Tips in Writing. case_background___reference.docx performance_lawn_equipment_database.xlsx Unformatted Attachment Preview Reference: Business Analytics (2e). - James R. Evans. Pearson 2013 - ISBN: 9780132950619. Case Analysis Background The case scenario was based on Gateway Estate Lawn Equipment Co. Case Study, used for the 1997 Malcolm Baldrige National Quality Award Examiner Training course. This material is in the public domain. The database, however, was developed by the author. 33 PLE, headquartered in St. Louis, Missouri, is a privately owned designer and producer of traditional lawn mowers used by homeowners. In the past 10 years, PLE has added another key product, a medium-size diesel power lawn tractor with front and rear power takeoffs, Class I three-point hitches, four-wheel drive, power steering, and full hydraulics. This equipment is built primarily for a niche market consisting of large estates, including golf and country clubs, resorts, private estates, city parks, large commercial complexes, lawn care service providers, private homeowners with five or more acres, and government (federal, state, and local) parks, building complexes, and military bases. PLE provides most of the products to dealerships, which, in turn, sell directly to end users. PLE employs 1,660 people worldwide. About half the workforce is based in St. Louis; the remainder is split among their manufacturing plants. In the United States, the focus of sales is on the eastern seaboard, California, the Southeast, and the south central states, which have the greatest concentration of customers. Outside the United States, PLE’s sales include a European market, a growing South American market, and developing markets in the Pacific Rim and China. The market is cyclical, but the different products and regions balance some of this, with just less than 30\% of total sales in the spring and summer (in the United States), about 25\% in the fall, and about 20\% in the winter. Annual sales are approximately $180 million. Both end users and dealers have been established as important customers for PLE. Collection and analysis of end-user data showed that satisfaction with the products depends on high quality, easy attachment/dismount of implements, low maintenance, price value, and service. For dealers, key requirements are high quality, parts and feature availability, rapid restock, discounts, and timeliness of support. PLE has several key suppliers: Mitsitsiu, Inc., the sole source of all diesel engines; LANTO Axles, Inc., which provides tractor axles; Schorst Fabrication, which provides subassemblies; Cuberillo, Inc, supplier of transmissions; and Specialty Machining, Inc., a supplier of precision machine parts. To help manage the company, PLE managers have developed a “balanced scorecard” of measures. These data, which are summarized shortly, are stored in the form of a Microsoft Excel workbook (Performance Lawn Equipment) accompanying this book. The database contains various measures captured on a monthly or quarterly basis and used by various managers to evaluate business performance. Data for each of the key measures are stored in a separate worksheet. A summary of these worksheets is given next: • Dealer Satisfaction, measured on a scale of 1–5 (1 = poor, 2 = less than average, 3 = average, 4 = above average, and 5 = excellent). Each year, dealers in each region are surveyed about their overall satisfaction with PLE. The worksheet contains summary data from surveys for the past 5 years. • End-User Satisfaction, measured on the same scale as dealers. Each year, 100 users from each region are surveyed. The worksheet contains summary data for the past 5 years. • 2014 Customer Survey, results from a survey for customer ratings of specific attributes of PLE tractors: quality, ease of use, price, and service on the same 1–5 scale. This sheet contains 200 observations of customer ratings. • Complaints, which shows the number of complaints registered by all customers each month in each of PLE’s five regions (North America, South America, Europe, the Pacific, and China). Mower Unit Sales and Tractor Unit Sales, which provide sales by product by region on a monthly basis. Unit sales for each region are aggregated to obtain world sales figures. • • Industry Mower Total Sales and Industry Tractor Total Sales, which list the number of units sold by all producers by region. • Unit Production Costs, which provides monthly accounting estimates of the variable cost per unit for manufacturing tractors and mowers over the past 5 years. • Operating and Interest Expenses, which provides monthly administrative, depreciation, and interest expenses at the corporate level. • On-Time Delivery, which provides the number of deliveries made each month from each of PLE’s major suppliers, number on time, and the percent on time. • Defects After Delivery, which shows the number of defects in supplier-provided material found in all shipments received from suppliers. • Time to Pay Suppliers, which provides measurements in days from the time the invoice is received until payment is sent. • Response Time, which gives samples of the times taken by PLE customer-service personnel to respond to service calls by quarter over the past 2 years. • Employee Satisfaction, which provides data for the past 4 years of internal surveys of employees to determine their overall satisfaction with their jobs, using the same scale used for customers. Employees are surveyed quarterly, and results are stratified by employee category: design and production, managerial, and sales/administrative support. In addition to these business measures, the PLE database contains worksheets with data from special studies: • Engines, which lists 50 samples of the time required to produce a lawn-mower blade using a new technology. • Transmission Costs, which provides the results of 30 samples each for the current process used to produce tractor transmissions and two proposed new processes. • Blade Weight, which provides samples of mower-blade weights to evaluate the consistency of the production process. • Mower Test, which lists test results of mower functional performance after assembly for 30 samples of 100 units each. • Employee Retention, data from a study of employee duration (length of hire) with PLE. The 40 subjects were identified by reviewing hires from 10 years prior and identifying those who were involved in managerial positions (either hired into management or promoted into management) at some time in this 10-year period. • Shipping Cost, which gives the unit shipping cost for mowers and tractors from existing and proposed plants for a supply-chain-design study. • Fixed Cost, which lists the fixed cost to expand existing plants or build new facilities, also as part of the supply-chain-design study. • Purchasing Survey, which provides data obtained from a third-party survey of purchasing managers of customers of Performance Lawn Care. Dealer Satisfaction Survey Scale: North America 2010 2011 2012 2013 2014 0 1 2 3 4 1 0 1 1 2 0 0 1 2 3 2 2 1 6 5 14 14 8 12 15 22 20 34 34 44 5 Sample Size 11 50 14 50 15 60 45 100 56 125 0 0 0 0 1 0 0 0 1 1 0 0 1 1 2 2 2 4 3 4 6 6 11 12 22 2 2 14 33 60 10 10 30 50 90 2010 2011 2012 2013 2014 0 0 0 0 0 0 0 0 0 0 1 1 1 1 1 3 2 2 2 4 7 8 15 21 17 4 4 7 6 8 15 15 25 30 30 2010 2011 2012 2013 2014 0 0 0 0 0 0 0 0 0 0 1 1 1 0 1 2 1 1 2 2 2 3 3 5 7 0 0 1 3 2 5 5 6 10 12 2012 2013 2014 0 0 0 0 0 0 0 1 1 1 4 5 0 2 8 0 0 2 1 7 16 South America 2010 2011 2012 2013 2014 Europe Pacific Rim China End-User Satisfaction North America 2010 2011 2012 2013 2014 0 1 1 1 0 0 1 3 2 2 2 2 2 6 4 5 4 3 3 15 18 17 15 15 4 37 35 34 33 31 Sample 5 Size 38 100 40 100 41 100 46 100 49 100 South America 2010 2011 2012 2013 2014 1 1 0 0 0 2 3 2 2 2 5 6 6 5 5 18 17 19 20 19 36 36 37 37 37 38 37 36 36 37 100 100 100 100 100 2010 2011 2012 2013 2014 1 1 1 1 0 2 2 1 1 1 4 5 4 3 2 21 21 26 17 19 36 34 37 41 45 36 37 31 37 33 100 100 100 100 100 2010 2011 2012 2013 2014 2 1 1 0 0 3 2 2 2 1 5 7 5 4 3 15 15 16 17 19 41 41 40 40 42 34 34 36 37 35 100 100 100 100 100 2012 2013 2014 0 1 0 3 2 1 3 2 1 6 4 3 28 30 31 10 11 14 50 50 50 Europe Pacific Rim China 2014 Customer Survey Region NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA Quality 4 4 4 5 5 5 5 5 4 4 4 5 5 4 5 5 5 5 4 4 4 4 5 5 5 5 5 4 5 5 5 4 4 5 5 5 5 5 4 5 5 5 5 3 5 5 5 5 5 5 5 5 5 5 4 5 5 5 4 5 4 5 5 5 5 4 4 5 5 5 5 Ease of Use Price Service 1 3 4 4 4 5 5 4 3 4 4 4 4 5 4 5 3 5 4 4 2 5 4 5 4 4 5 5 4 5 5 1 4 5 4 4 4 3 3 5 4 4 4 3 5 5 2 5 4 2 5 4 2 5 5 4 4 4 5 4 4 2 4 3 3 4 5 2 5 3 4 3 4 4 5 5 2 5 5 5 3 4 5 4 4 4 4 1 5 5 4 3 5 5 1 4 4 3 5 3 4 4 5 2 4 4 4 4 5 4 4 5 4 5 3 3 5 4 4 3 4 3 4 5 1 5 4 5 4 4 3 4 4 2 4 5 4 5 5 3 4 4 4 4 4 4 4 4 4 5 4 1 4 4 5 5 5 3 4 4 4 5 3 5 5 4 4 4 5 5 5 5 4 5 4 4 4 4 5 5 5 5 4 5 5 4 5 3 5 4 4 4 4 5 2 4 5 5 4 4 5 4 4 4 4 3 5 4 5 4 5 4 5 NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA NA SA SA SA SA SA SA SA SA SA SA SA SA SA SA SA SA SA SA SA SA SA SA SA SA SA SA SA SA SA SA SA SA SA SA SA SA SA SA SA SA SA SA SA SA SA 5 5 5 5 5 4 3 5 4 3 1 4 5 4 5 5 4 5 5 5 5 4 5 4 5 4 5 4 4 5 5 5 4 5 4 5 4 4 4 5 3 5 5 4 4 1 5 4 4 5 4 4 3 5 4 4 4 4 4 5 4 5 5 4 4 5 5 5 3 4 4 5 4 5 4 4 3 4 4 5 5 5 4 2 4 5 5 5 5 5 2 4 4 5 5 5 5 4 5 5 5 5 5 4 4 4 2 4 5 4 5 4 4 4 3 4 4 4 4 5 4 4 4 4 4 4 3 4 4 5 1 5 4 4 4 5 5 4 4 4 4 4 4 3 4 4 3 3 4 5 4 5 1 3 2 4 3 4 3 3 4 5 4 4 4 5 5 4 5 5 4 5 3 2 5 4 5 3 2 5 4 4 2 4 3 4 2 3 5 3 2 3 3 3 2 4 5 2 5 4 4 4 4 5 4 4 4 3 4 4 4 2 4 4 4 1 4 5 2 3 4 5 4 2 5 5 5 5 5 4 5 5 4 5 4 5 5 4 5 4 4 3 5 3 5 5 4 4 4 3 4 5 4 5 5 5 5 4 5 3 4 4 5 4 5 4 5 4 4 4 5 4 5 3 5 4 1 5 5 4 5 4 5 3 4 4 5 5 4 4 5 4 3 3 5 5 SA SA SA SA SA Eur Eur Eur Eur Eur Eur Eur Eur Eur Eur Eur Eur Eur Eur Eur Eur Eur Eur Eur Eur Eur Eur Eur Eur Eur Eur Eur Eur Eur Eur Pac Pac Pac Pac Pac Pac Pac Pac Pac Pac China China China China China China China China China China 5 5 3 4 4 4 4 3 3 4 5 5 4 3 3 4 5 5 5 3 4 4 5 4 3 4 5 5 4 4 5 2 5 4 5 5 5 4 4 5 4 5 4 3 5 5 5 4 4 4 4 4 3 3 2 4 4 4 4 3 5 4 4 4 4 5 5 5 4 5 4 4 3 5 4 5 5 4 5 5 4 5 3 5 3 4 4 4 5 4 4 5 4 3 4 4 5 2 4 4 5 5 4 4 4 4 4 4 4 3 4 4 3 1 4 5 4 5 1 5 5 5 5 4 3 5 5 4 4 4 4 4 4 4 3 4 3 4 2 4 3 4 5 4 1 4 5 4 4 5 4 4 3 4 4 4 4 3 3 3 3 3 3 2 2 4 4 4 4 3 3 2 4 3 5 5 1 4 4 3 4 5 4 5 4 5 4 5 4 4 2 4 5 4 4 3 4 4 3 5 5 5 4 4 4 4 5 3 4 5 4 3 3 3 2 3 2 3 2 1 Complaints 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 A B C D E F 1 Mower Unit Sales 2 3 Month NA SA Europe Pacific China 4 Jan-10 6000 200 720 100 0 5 Feb-10 7950 220 990 120 0 6 Mar-10 8100 250 1320 110 0 7 Apr-10 9050 280 1650 120 0 8 May-10 9900 310 1590 130 0 9 Jun-10 10200 300 1620 120 0 10 Jul-10 8730 280 1590 140 0 11 Aug-10 8140 250 1560 130 0 12 Sep-10 6480 230 1590 130 0 13 Oct-10 5990 220 1320 120 0 14 Nov-10 5320 210 990 130 0 15 Dec-10 4640 180 660 140 0 16 Jan-11 5980 210 690 140 0 17 Feb-11 7620 240 1020 150 0 18 Mar-11 8370 250 1290 140 0 19 Apr-11 8830 290 1620 150 0 20 May-11 9310 330 1650 130 0 21 Jun-11 10230 310 1590 140 0 22 Jul-11 8720 290 1560 150 0 23 Aug-11 7710 270 1530 140 0 24 Sep-11 6320 250 1590 150 0 25 Oct-11 5840 250 1260 160 0 26 Nov-11 4960 240 900 150 0 27 Dec-11 4350 210 660 150 0 28 Jan-12 6020 220 570 160 0 29 Feb-12 7920 250 840 150 0 30 Mar-12 8430 270 1110 160 0 31 Apr-12 9040 310 1500 170 0 32 May-12 9820 360 1440 160 0 33 Jun-12 10370 330 1410 170 0 34 Jul-12 9050 310 1440 160 0 35 Aug-12 7620 300 1410 170 0 36 Sep-12 6420 280 1350 180 0 37 Oct-12 5890 270 1080 180 0 38 Nov-12 5340 260 840 190 0 39 Dec-12 4430 230 510 180 0 40 Jan-13 6100 250 480 200 0 41 Feb-13 8010 270 750 190 0 42 Mar-13 8430 280 1140 200 0 43 Apr-13 9110 320 1410 210 0 44 May-13 9730 380 1340 190 0 45 Jun-13 10120 360 1360 200 0 46 Jul-13 9080 320 1410 200 0 47 Aug-13 7820 310 1490 210 0 48 Sep-13 6540 300 1310 220 0 49 Oct-13 6010 290 980 210 0 50 Nov-13 5270 270 770 220 0 51 Dec-13 5380 260 430 230 0 52 Jan-14 6210 270 400 200 0 53 Feb-14 8030 280 750 190 0 54 Mar-14 8540 300 970 210 0 55 Apr-14 9120 340 1310 220 5 56 May-14 9570 390 1260 200 16 57 Jun-14 10230 380 1240 210 22 58 Jul-14 9580 350 1300 230 26 59 Aug-14 7680 340 1250 220 14 60 Sep-14 6870 320 1210 220 15 61 Oct-14 5930 310 970 230 11 62 Nov-14 5260 300 650 240 3 63 Dec-14 4830 290 300 230 1 G World 7020 9280 9780 11100 11930 12240 10740 10080 8430 7650 6650 5620 7020 9030 10050 10890 11420 12270 10720 9650 8310 7510 6250 5370 6970 9160 9970 11020 11780 12280 10960 9500 8230 7420 6630 5350 7030 9220 10050 11050 11640 12040 11010 9830 8370 7490 6530 6300 7080 9250 10020 10995 11436 12082 11486 9504 8635 7451 6453 5651 Tractor Unit Sales Month NA SA Eur Jan-10 570 250 Feb-10 611 270 Mar-10 630 260 Apr-10 684 270 May-10 650 280 Jun-10 600 270 Jul-10 512 264 Aug-10 500 280 Sep-10 478 290 Oct-10 455 280 Nov-10 407 290 Dec-10 360 280 Jan-11 571 320 Feb-11 650 350 Mar-11 740 390 Apr-11 840 440 May-11 830 470 Jun-11 760 490 Jul-11 681 481 Aug-11 670 460 Sep-11 640 460 Oct-11 620 440 Nov-11 570 436 Dec-11 533 420 Jan-12 620 510 Feb-12 792 590 Mar-12 890 610 Apr-12 960 600 May-12 1040 620 Jun-12 1032 640 Jul-12 1006 590 Aug-12 910 600 Sep-12 803 670 Oct-12 730 630 Nov-12 699 710 Dec-12 647 570 Jan-13 730 650 Feb-13 930 680 Mar-13 1160 724 Apr-13 1510 730 May-13 1650 760 Jun-13 1490 800 Jul-13 1460 840 Aug-13 1390 830 Sep-13 1360 820 Oct-13 1340 810 Nov-13 1240 827 Dec-13 1103 750 Jan-14 1250 780 Feb-14 1550 805 Mar-14 1820 830 Apr-14 2010 890 May-14 2230 930 Jun-14 2490 980 Jul-14 2440 1002 Aug-14 2334 970 Sep-14 2190 960 Oct-14 2080 930 Nov-14 2050 920 Dec-14 2004 902 Pac 560 600 680 650 580 590 760 645 650 670 888 850 620 760 742 780 690 721 680 711 695 650 680 657 610 680 730 820 810 807 760 720 660 630 603 570 500 590 620 730 740 720 670 610 599 560 550 520 480 523 560 570 590 600 580 570 550 530 517 490 China 212 230 240 263 269 280 290 270 263 258 240 230 250 275 270 280 290 300 312 305 290 260 250 240 250 250 260 270 290 310 340 320 313 290 280 260 287 290 300 310 330 340 350 341 330 320 300 290 200 210 220 230 253 270 280 250 230 220 190 190 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 10 12 20 22 20 24 20 31 30 37 32 33 35 50 63 68 70 82 80 90 100 102 110 114 111 121 123 120 130 136 134 132 137 130 139 131 World 1592 1711 1810 1867 1779 1740 1826 1695 1681 1663 1825 1720 1761 2035 2142 2340 2280 2271 2154 2146 2085 1970 1936 1850 2000 2324 2510 2672 2780 2813 2716 2581 2476 2317 2324 2080 2202 2540 2867 3348 3550 3432 3400 3261 3209 3132 3027 2777 2821 3209 3553 3820 4133 4476 4436 4256 4067 3890 3816 3717 Industry Mower Total Sales Month NA SA Eur Pac World Jan-10 60000 571 13091 1045 74662 Feb-10 77184 611 17679 1111 96585 Mar-10 77885 658 22759 1068 102369 Apr-10 86190 778 27966 1237 116171 May-10 96117 886 27895 1313 126210 Jun-10 97143 882 30566 1176 129768 Jul-10 84757 848 29444 1359 116409 Aug-10 79804 735 28364 1238 110141 Sep-10 64800 657 28393 1215 95065 Oct-10 59307 595 24444 1154 85500 Nov-10 52157 553 18000 1262 71972 Dec-10 45049 462 12453 1386 59349 Jan-11 58627 553 12778 1443 73401 Feb-11 76200 615 18214 1515 96545 Mar-11 82871 658 23889 1373 108791 Apr-11 84904 784 29455 1442 116584 May-11 93100 846 29464 1215 124625 Jun-11 93000 838 27414 1333 122585 Jul-11 83048 763 27368 1415 112594 Aug-11 74854 694 27321 1296 104164 Sep-11 60769 625 29444 1402 92241 Oct-11 55619 610 23774 1468 81470 Nov-11 48155 571 17308 1351 67386 Dec-11 42647 512 12941 1389 57489 Jan-12 57885 537 10962 1509 70892 Feb-12 77647 595 15273 1402 94917 Mar-12 81845 659 20556 1524 104583 Apr-12 86095 756 26786 1574 115211 May-12 91776 878 24828 1468 118949 Jun-12 100680 825 24737 1560 127801 Jul-12 86190 756 24828 1441 113216 Aug-12 71887 714 25179 1545 99325 Sep-12 60000 651 24545 1667 86863 Oct-12 55566 643 19286 1698 77193 Nov-12 50857 619 15273 1810 68558 Dec-12 42596 548 9107 1731 53982 Jan-13 58095 581 8571 1887 69135 Feb-13 75566 614 13158 1845 91182 Mar-13 80286 622 19655 1923 102486 Apr-13 85140 727 25179 1981 113027 May-13 90093 826 23103 1810 115832 Jun-13 95472 783 24286 1942 122482 Jul-13 87308 681 24737 1961 114686 Aug-13 74476 646 26607 2000 103729 Sep-13 61698 625 22982 2075 87381 Oct-13 57238 617 16897 2019 76771 Nov-13 50673 587 13750 2095 67105 Dec-13 51238 591 7818 2150 61797 Jan-14 59712 563 7547 1852 69673 Feb-14 77961 571 13889 1743 94165 Mar-14 83725 625 18302 1892 104544 Apr-14 90297 723 25192 2037 118250 May-14 91143 848 24706 1887 118583 Jun-14 99320 792 25306 1944 127363 Jul-14 93922 745 27083 2170 123919 Aug-14 73143 739 26042 2037 101961 Sep-14 66699 667 26304 2018 95688 Oct-14 56476 660 22558 2072 81766 Nov-14 51068 625 14773 2182 68648 Dec-14 46893 608 6977 2035 56510 Industry Tractor Total Sales Month NA SA Eur Pac China World Jan-10 8143 984 5091 987 278 15483 Feb-10 8592 1051 5310 1090 283 16325 Mar-10 8630 1016 6071 1127 285 17129 Apr-10 8947 1027 5856 1209 288 17327 May-10 8442 1057 5273 1221 286 16278 Jun-10 7500 1019 5315 1327 287 15448 Jul-10 6145 977 7170 1324 289 15905 Aug-10 5882 1057 5926 1268 290 14422 Sep-10 5595 1086 6075 1209 293 14258 Oct-10 5233 1045 6321 1168 295 14061 Nov-10 4494 1078 8381 1127 298 15378 Dec-10 3913 1029 7944 1085 301 14272 Jan-11 5938 1172 5688 1185 306 14289 Feb-11 6633 1273 7037 1286 302 16530 Mar-11 7327 1423 6981 1286 303 17320 Apr-11 8077 1612 7500 1346 307 18842 May-11 7830 1728 6571 1388 309 17826 Jun-11 7103 1815 6990 1449 312 17669 Jul-11 6239 1776 6667 1490 315 16487 Aug-11 6036 1685 6762 1449 318 16250 Sep-11 5664 1679 6635 1394 321 15692 Oct-11 5345 1618 6311 1256 315 14844 Nov-11 4831 1564 6476 1214 318 14402 Dec-11 4454 1522 6250 1171 320 13716 Jan-12 5299 1835 5922 1208 333 14597 Feb-12 6529 2115 6667 1214 313 16836 Mar-12 7120 2202 7228 1256 606 18412 Apr-12 7619 2151 8200 1311 571 19852 May-12 8387 2214 7941 1415 556 20513 Jun-12 8110 2278 7921 1520 526 20355 Jul-12 7752 2100 7677 1675 513 19716 Aug-12 6894 2128 7200 1584 769 18575 Sep-12 6015 2367 6735 1527 750 17394 Oct-12 5368 2211 6495 1422 732 16226 Nov-12 4964 2483 6061 1366 714 15587 Dec-12 4444 1986 5816 1262 698 14207 Jan-13 5000 2257 5051 1373 714 14394 Feb-13 6284 2353 6082 1436 1063 17218 Mar-13 7785 2457 6327 1478 1264 19310 Apr-13 9934 2517 7604 1512 1333 22901 May-13 10645 2612 7789 1642 1556 24244 Jun-13 9491 2749 7347 1 ... Purchase answer to see full attachment