Purchase Solution

Case: Performance Lawn Equipment

Not what you're looking for?

Ask Custom Question

Elizabeth Burke wants some detailed statistical information about much of the data in the PLE database. In particular, she wants to know the following: (Use attached excel to show solution data for the below questions is in the attached excel.)
a. the mean satisfaction ratings and standard deviations by year and region in the worksheets Dealer Satisfaction and End-User Satisfaction (use attached excel to show solution)
b. a descriptive statistical summary for the 2012 customer survey data (use attached excel to show solution)
c. how the response times differ in each quarter of the worksheet Response Time (use attached excel to show solution)
d. how defects after delivery (worksheet Defects after Delivery) have changed over these 5 years (use attached excel to show solution)
e. how sales of mowers and tractors compare with industry totals and how strongly monthly product sales are correlated with industry sales
F. Perform these analyses and summarize your results in a written report to Ms. Burke. Report must be concise and detailed at least two pages with relevant information from the above questions.

Attachments
Purchase this Solution
Solution Summary

Using the report information, statistical information about the example company are found and explained.

Solution Preview

From the data available in PLE (Performance Lawn Equipment) database we have multiple data sheets. However, to serve the purpose of this report we will be focusing on few of the data sheets such as Dealer Satisfaction and End-User Satisfaction, 2014 customer survey data, Response Time, Defects after Delivery, Tractor Unit Sales, Mower Unit Sales, Industry Tractor Total Sales, and Industry Mower Total Sales.

From "Dealer Satisfaction" results, we have observed that over a period of time the average dealer satisfaction rate is increasing i.e. for North America region the mean dealer satisfaction score for year 2010 is 3.78, for year 2011 is 3.92, for year 2012 is 3.97, for year 2013 is 4.11 and for year 2014 is 4.112.

From "End-User Satisfaction" results, we have observed the same as we had observed for "Dealer Satisfaction" i.e. over a period of time the average end-user satisfaction rate is increasing i.e. for North America region the mean end-user satisfaction score for year 2010 is 3.98, for year 2011 is 4.04, for year 2012 is 4.04, for year 2013 is 4.17 and ...

Purchase this Solution
Free BrainMass Quizzes
Measures of Central Tendency

Tests knowledge of the three main measures of central tendency, including some simple calculation questions.

Measures of Central Tendency

This quiz evaluates the students understanding of the measures of central tendency seen in statistics. This quiz is specifically designed to incorporate the measures of central tendency as they relate to psychological research.

Terms and Definitions for Statistics

This quiz covers basic terms and definitions of statistics.

Know Your Statistical Concepts

Each question is a choice-summary multiple choice question that presents you with a statistical concept and then 4 numbered statements. You must decide which (if any) of the numbered statements is/are true as they relate to the statistical concept.

View More Free Quizzes
Related BrainMass Solutions

  • Income statement

    Doug rented lawn equipment, purchased supplies, and hired fellow students to mow and trim his customer's lawns. At the end of each month, Doug mailed bills to his customers.

  • Market Segmentation Analysis and a Value Proposition

    In the lawn and garden equipment market the benefits residential customers are looking for are that the equipment should be easy to use, easy to store, and does not break down.

  • Determining equations for accounting and economic profits

    They estimate the following costs: Insurance $2,600 Equipment Rental Fees 1,000 Fuel and Supplies $4 per lawn Miscellaneous Expenses $2 per lawn

  • Multiple Choice

    Varies directly with the number of hours the lawn equipment is operated. c. Is not affected by the number of hours the lawn equipment is operated. d. Both A and B.

  • Target Costing Over Product Life Cycle

    Would the company undertake production and selling of the riding lawn mower? 3. Southeast Equipment uses a target costing approach to new products. What steps would management take to try to make a profitable product of the riding lawn mower?

  • Maltbee Lawn Service

    Doug rented lawn equipment, purchased supplies, and hired fellow students to mow and trim his customer's lawns. At the end of each month, Doug mailed bills to his customers.

  • Maltbee Lawn Service

    Doug rented lawn equipment, purchased supplies, and hired fellow students to mow and trim his customer's lawns. At the end of each month, Doug mailed bills to his customers.

  • Binomial Probability in Lawn Mower Manufacturers

    399384 Binomial Probability in Lawn Mower Manufacturers See attached data file. A manufacturer of home and industrial lawn and garden equipment collects a variety of data from special studies, many of which are related to quality control.

  • Activity-based costing differ from Traditional costing

    59360 Accounting Problem Bailey's Leisure Equipment uses a traditional overhead allocation scheme in its manufacturing plant. The company produces three products: umbrellas, sunshades, and lawn chairs.

View More Related Solutions