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
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
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
Write a formal report summarizing your results for all four parts of this case.
Recently Asked Questions
- how did the industrial revolution in the Western developed world helped shape the humanistic movement?
- Can someone help me please figure out how to come up with a general environmental analysis for Nokia (Phone company) and explain it for me? I am having trouble
- Explain how you would ensure the work breakdown (WBS) structure for this project correctly represents the scope of work. Case study The local government wants