I NEED IT AS SOON AS POSSIBLE!!!
Case: Performance Lawn Equipment
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:
Year Mower Price Tractor Price
$ 120 $ 3,000
$ 135 $ 3,100
$ 150 $ 3,250
$ 175 $ 3,400
$ 180 $ 3,600
Create 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.
The Performance Lawn Equipment database
contains data needed to develop a pro forma income statement. Dealers selling
PLE products all receive 20% of sales revenue for their part of doing business,
and this is accounted for as the selling expense. The tax rate is 40%. Develop
an Excel worksheet to extract and summarize the data needed to de-velop the
income statement for 2012 and implement an Excel model in the form of a pro
forma income statement for the company.