View the step-by-step solution to:

Question

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 study,

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 empha- sized quality

and considers the quality it builds into its products as its primary selling point. In the past 2

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 and market position by examining the information provided

in the database. Specifically, she is asking you to construct appropriate charts for the data in the

following worksheets and summarize your conclusions from analysis of these charts.

A. Dealer Satisfaction

B. End-User Satisfaction

C. Complaints

D. Unit Sales

E. Tractor Unit Sales

F. On-Time Delivery

G. Defects after Delivery

H. Response Time

Part 2: As noted in the case study, the supply chain worksheets provide cost data associated

with logistics between existing plants and customers as well as proposed new plants. Ms. Burke

wants you to extract the records associated with the unit shipping costs of proposed plant

locations and compare the costs of existing locations against those of the proposed locations

using quartiles.

Part 3: Ms. Burke would also like a quantitative summary of the average responses for each of

the customer attributes in the worksheet 2014 Customer Survey for each market region as a

cross-tabulation (use PivotTables as appropriate), along with frequency distributions,

histograms, and quartiles of these data.

Part 4: 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 6-8 charts, which should fit comfortably on one

screen.

Write a formal report summarizing your results for all four parts of this case.

Recently Asked Questions

Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors.

  • -

    Study Documents

    Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access.

    Browse Documents
  • -

    Question & Answers

    Get one-on-one homework help from our expert tutors—available online 24/7. Ask your own questions or browse existing Q&A threads. Satisfaction guaranteed!

    Ask a Question
Ask Expert Tutors You can ask You can ask ( soon) You can ask (will expire )
Answers in as fast as 15 minutes