Reference no: EM132401464
Case study Assignment - Perform Analyses for the Company
The case is on Performance Lawn Equipment. Follow the information and instructions given. Complete the questions and written summary for each Chapter. Cite all references using standard APA writing style. No more than 3 pages.
Chapter 1 -
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 to be her chief analyst in the coming weeks. She has asked you to do some preliminary analysis of the data for the company.
1. 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.
2. Second, she wants a count of the number of failures in the worksheet Mower Test.
3. Next, Elizabeth has provided you with prices for PLE products for the past five 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.
4. Finally, she wants to know the market share for each product and region by month based on the PLE and industry sales data, and the average market share by region over the five years.
Summarize all your findings in a report to Ms. Burke.
Chapter 2 - 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 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 case 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 and market position by examining the information provided in the database for this company. Specifically, she is asking you to construct appropriate 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.
Chapter 3 - CASE: Performance Lawn Equipment
Elizabeth Burke has received several questions from other PLE managers regarding quality, customer satisfaction, and operational performance. She would like you to summarize some data from the Performance Lawn Equipment Database using statistical tools and analysis:
1. Frequency distributions and histograms for the data in the Customer Survey worksheet.
2. Descriptive statistical measures for engine production time in the worksheet Engines.
3. A frequency distribution and histogram for the blade weight samples in the worksheet Blade Weight.
4. The proportion of samples that failed the functional performance test in the worksheet Mower Test.
5. PivotTables that summarize the data and provide useful insights in the worksheet Employee Retention.
6. Correlations among the satisfaction survey variables in the worksheet Purchasing Survey.
Write a report that clearly shows these results and explain the key insights.
Attachment:- Performance Lawn Equipment Database.rar