I'm just looking for help on part 1, question A. I have posted the information above.

CASE: PERFORMANCE LAWN EQUIPMENT Part 1: PLE originally produced lawn mowers, but a significant portion of sales volume over recent years has come from the growing small-tractor market. As we noted in the case in Chapter 1, PLE sells their products worldwide, with sales regions including North America, South America, Europe, and the Pacific Rim. Three years ago, a new region was opened to serve China, where a booming market for small tractors has been established. PLE has always empha- sized quality and considers the quality it builds into its prod- ucts as its primary selling point. In the past two years, PLE has also emphasized the ease of use of their products. Before digging into the details of operations, Eliza- beth Burke wants to gain an overview of PLE's overall business performance and market position by examining the information provided in the database for this com- pany. Specifically, she is asking you to construct appropri- ate charts for the data in the following worksheets in the Performance Lawn Equipment Database and summarize your conclusions from analysis of these charts. a. Dealer Satisfaction b. End-User Satisfaction c. Complaints d. Mower Unit Sales e. Tractor Unit Sales f. On-Time Delivery g. Defects After Delivery h. Response Time Part 2: Propose a monthly dashboard of the most important business information that Ms. Burke can use on a routine basis as data are updated. Create one using the most recent data. Your dashboard should not consist of more than six to eight charts, which should fit comfortably on one screen. Write a formal report summarizing your results for both parts of this case. J 6 50 A B C D E F G H 1 Dealer Satisfaction 2 3 Survey Scale: 0 1 2 3 4 5 Sample 4 North America Size 5 2014 1 0 2 14 22 11 50 6 2015 0 0 2 14 20 14 50 7 2016 1 1 1 8 34 15 60 8 2017 1 2 6 12 34 45 100 9 2018 2 3 5 15 44 56 125 10 11 South America 12 2014 0 0 0 2 6 2 10 13 2015 0 0 0 2 6 2 10 14 2016 0 0 1 4 11 14 30 15 2017 0 1 1 3 12 33 16 2018 1 1 2 4 22 60 90 17 18 Europe 19 2014 0 0 1 3 7 4 15 20 2015 0 0 1 2 8 4 15 21 2016 0 0 1 2 15 7 22 2017 0 0 1 2 21 6 30 23 2018 0 0 1 4 17 8 30 24 25 Pacific Rim 26 2014 0 0 1 2 2 0 5 27 2015 0 0 1 1 3 0 5 28 2016 0 0 1 1 3 1 6 29 2017 0 0 0 2 5 3 10 30 2018 0 0 1 2 7 2 12 31 32 China 33 2016 0 0 0 1 0 0 1 34 2017 0 0 1 4 2 0 7 35 2018 0 0 1 5 8 2 16 36 25