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.INSTRUCTIONS: Do a dashboard page (one worksheet containing all data)Do a table, chart, and written summary for each category listed in A-H in the case studyYou MUST use a different chart type for each (examples being 1 bar chart, 1 radar chart, 1 pie chart, 1 scatter chart, 1 stacked bar chart, 1 area chart, etc.)You must write a few sentences explaining where the data from the table came from, how you interpreted it, and why the chart you used was the best representation to show the data visually