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 of be her chief analyst. She asked for your help to do the following tasks:

$1-$ 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. $(10$ Marks$)$

$2-$ Elizabeth has provided you with prices for PLE products for the past five years:

Prices for PLE products for the past $5$ years:

Year

Mower Price

Tractor Price

$2014$

$$150$

$$3,250$

$2015$

$$175$

$$3,400$

$2016$

$$180$

$$3,600$

$2017$

$$185$

$$3,700$

$2018$

$$190$

$$3,800$

Create a new worksheet 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. $(20$ Marks$)$

$3-$ She wants to know the market share for each product $($Mower & Tractor$)$ and region by month based on the PLE and industry sales data, and the average market share by region over the five years. $(20$ Marks$)$

$4-$ she is asking you to construct appropriate charts for the data in the worksheets in the Performance Lawn Equipment Database and summarize your conclusions from analysis of these charts $(20$ Marks$)$: $($take a snapshot $/$Copy from your worksheet after you did your task and paste it in your report and summarize your conclusions from analysis of these charts under each one$)$

A$-$ Dealer satisfaction $(5$ Marks$)$

B$-$ End$-$User Satisfaction $(5$ Marks$)$

C$-$ Mower Unit Sales $(5$ Marks$)$

D$-$ Tractor Unit Sales $(5$ Marks$)$

$5-$ Finally, propose a monthly dashboard of the most important business information that Ms$.$ Burke can use on a routine basis as data is updated. Create one using the most recent data. Your dashboard should consist of at least $4$ charts, which should fit comfortably on one screen. $($Take a snapshot $/$Copy from your worksheet after you did your task and paste it in your report and summarize your conclusions from analysis of these charts under each one$)(20$ Marks $/5$ Marks for each Chart$)$