Business Finance Homework Help

I’m working on a excel multi-part question and need guidance to help me learn.

PLE originally produced lawn mowers, but a significant portion of sales volume over recent years has come from the growing small-tractor market. As noted in the case in Chapter 1 page 31, 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 emphasized quality and considers the quality it builds into its products 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, Elizabeth Burke wants to gain an overview of PLE’s overall business performance by examining the information provided in the database for this company.

Instructions:

Create a dashboard using the eight problem descriptions below and the Excel data file provided for this assignment. An illustration of the dashboard you are to develop is presented below the eight problem statements – Be sure to create the same charts and organize them as shown on this dashboard draft. The worksheet titled Dashboard must fit all eight charts within cells A1:N70. Format the axis labels, axis ticks, and titles as displayed in the example. Provide a summary report in the textbox provided underneath the Dashboard worksheet in Excel.

Problems:

1. Pie chart showing dealership satisfaction for North America in 2018.
2. Pie chart showing dealership satisfaction for Europe in 2018.
3. Line chart showing the number of complaints over time for both North America and Europe in 2018.
4. Line chart showing the total number of mower and tractor sales over time comparing North America and Europe in 2018.
5. Scatter chart showing the total number of mower and tractor sales over time and the number of complaints for North America in 2018.
6. Scatter chart showing the total number of mower and tractor sales over time and the number of complaints for Europe 2018.
7. Area chart showing the number of deliveries with the number of on time deliveries in 2018.
8. Bar chart showing the total number of defects after delivery each year.