Essilor Case Study

Read the case of “Essilor: Building an Efficient Supply Chain to Serve the Company’s Mission.” For this assignment, you will review this case and analyze Essilor’s efforts to ensure an effective and efficient supply chain. Complete the following:

 

  • Review “Essilor: Building an Efficient Supply Chain to Serve the Company’s Mission” in the attached document.
  • Describe the structure of Essilor’s supply chain and variety of products produced and delivered along its supply chain. Respond to the following questions:

1.      What was Essilor’s mission and what was the innovative supply chain strategy used to support the mission?

2.      How did Essilor use the combination of innovation and customer service to become one of the world’s 30 most innovative companies by Forbes?

3.      How did the two operating models for the two types of lenses help Essilor build an efficient supply chain?

4.      What are differences between supply chains for finished lenses and semi-finished lenses?

5.      How did Essilor develop the global end-to-end supply chain?

 

Your assignment should be 3–4 double-spaced pages.

Page 77

Page 78

PRINTED BY: [email protected]. Printing is for personal, private use only. No part of this book may be reproduced or transmitted without publisher’s prior permission. Violators will be prosecuted.

SUPPLY CHAIN MANAGEMENT PROFILE

ESSILOR:

BUILDING AN EFFICIENT SUPPLY CHAIN TO

SERVE THE COMPANY’S MISSION

“Being able to serve, in a fast and economical manner, the 4.2 billion people who need lenses to live a

better life, from our 19 plants, means an efficient supply chain at the heart of our strategy. This is my

dream.”

—HUBERT SAGNIÈRES, CEO, ESSILOR

Every year or two, you go to an optician, who gives you a vision test and takes various eye measurements. Fast-forward a few hours or a couple of days: Voilà! Your glasses are waiting for you. Each lens is designed to perfectly suit the specific vision requirements of your left and right eyes while also taking into account how the two work together. In short, they are extremely personalized.

Thanks to ophthalmic-lens manufacturer Essilor, this is a familiar occurrence for millions of people in thousands of locations around the world. With more than 160 years of experience in the lens business, France-based Essilor Group—the name comes from the 1972 merger of Essel and Silor—is the world’s largest producer of corrective eyeglass lenses. In 2011, Essilor sold 385 million lenses in more than 100 countries, and revenue should be close to €5 billion in FY 2012.

Essilor is committed to providing people everywhere with high-quality vision. This goes beyond ensuring that people have glasses with the right prescription. Given the link that has been established between bad vision and a variety of problems, including poor health, subpar scholastic performance, compromised safety, reduced productivity at work, and even criminal behavior, Essilor is committed to helping the greatest number of people possible to see properly, in order to improve their quality of life.

“Essilor’s mission is to bring good vision to people around the world to increase their quality of life,” says Paul du Saillant, chief operating officer. “Our growth strategy is based on four pillars: innovation in products and services, development of the top and middle range of products, international growth via partnership and acquisition, and stimulation of demand to increase market size and fulfill our mission. Our supply chain has been one of our key strengths in executing this strategy. It is a real competitive advantage.”

https://jigsaw.vitalsource.com/api/v0/books/0071846646/print?from=77…

1 of 2 6/2/2016 11:35 PM

 

 

Page 79

INNOVATION AND CUSTOMER SERVICE: A WINNING COMBINATION

Essilor is well known in the industry for its innovative products. In 2012, for the second year running, the company was listed as one of the world’s 30 most innovative companies by the U.S. magazine Forbes. Having invented the progressive lens under the brand Varilux back in 1959, the company continues to make new product development a top priority today. Every year, Essilor launches more than 200 new products: in 2011, 45 percent of sales came from products less than three years old. Among its latest innovations is the UV Crizal lens. The most complete anti-UV lens created to date, Crizal helps protect the eyes from rays that cause cataracts and blindness.

For Essilor, however, innovation also plays an important role in the way lenses are made. Over the past few years, the company has developed digital surfacing technologies that make it possible to polish lenses so that they are not only much more accurate but also thinner, lighter, and more flattering for the wearer. To make the best use of these new high-definition technologies, Essilor made changes in its manufacturing processes. The company also developed new optical equipment that allows opticians to capture the information—for example, the degree of eye rotation—that’s needed for lenses that are so precise.

https://jigsaw.vitalsource.com/api/v0/books/0071846646/print?from=77…

2 of 2 6/2/2016 11:35 PM

 

 

Page 79

Page 80

PRINTED BY: [email protected]. Printing is for personal, private use only. No part of this book may

be reproduced or transmitted without publisher’s prior permission. Violators will be prosecuted.

The Varilux S series, introduced in 2012, is the most recent result of these innovations. Based on

the latest advances in optics and a deep understanding of human physiology, it is the first progressive

lens to offer wide-angle vision correction without compromising stability in motion. By eliminating this

trade-off, the Varilux S series marks a breakthrough in optics development.

To fuel its innovation engine, Essilor relies on its Centers of Innovation and Technology (CIT),

acquisitions, and strategic partnerships with a number of companies with advanced technologies—for

example, Nikon, known worldwide for its high-quality lenses. Essilor also acquired a number of

companies, including Johnson & Johnson Vision Care’s ophthalmic-lens business, The Spectacle Lens

Group, whose proprietary technology can be used to make progressive lenses more personalized.

The focus on innovation explains why, in 2011, Essilor produced approximately 650,000 different

SKUs, which is an astounding number of products by any count. This number represents all the different

high-end and midrange lenses—including all the various frames, coatings, tints, and brands—that

Essilor produces to meet the needs of its different customer segments.

While all of this translates into ultrapersonalized products, it also adds a great deal of complexity to

the end-to-end supply chain—both the “good” complexity that is critical to competitive advantage and

the “bad” complexity that can add unwanted costs and delays. This is especially challenging in light of

the company’s other key priority: high-level customer service in the form of short lead times. Essilor has

consistently been able to achieve both goals because of its innovative approach to the supply chain.

TWO TYPES OF LENSES, TWO OPERATING MODELS

Essilor sells lenses to many different types of retail customers, ranging from international retail optical

chains to small independent opticians. The value proposition of the retail location is to offer high-quality

glasses that can be turned around quickly. One Essilor client, for example, was founded on the promise

that a customer can walk into one of its stores needing a new pair of glasses and walk out wearing them

an hour later.

Providing personalized products with short lead times is a tall order, because Essilor’s supply chain

needs to produce and deliver two major types of lenses, finished and semifinished. Finished lenses

correct a single vision problem like myopia (nearsightedness), whereas semifinished lenses address

presbyopia (farsightedness), a dual vision condition that people develop in middle age.

Essilor has met this challenge by developing two distinct operating models. Finished lenses are

made to stock, while semifinished lenses are a combination of made to stock and made to order.

FINISHED LENSES

The end-customer visits a glasses store (either retail chain or independent), where an optician asks

whether he wants the glasses to have any of a variety of features, including glare resistance, scratch

resistance, and UV protection. The optician sends the prescription purchase order to Essilor. This is a

retail business that is very local by nature, with hundreds of thousands of sales points sending in orders

every day.

Upstream, the lenses are mass-produced in factories dedicated to making finished lenses. During

this process, two molds are created for each lens—a convex mold for the front (outer) side of the lens

https://jigsaw.vitalsource.com/api/v0/books/0071846646/print?from=79…

1 of 2 6/2/2016 11:35 PM

 

 

Page 81

and a concave mold for the back (inner) side.

After the lenses are molded, a number of coatings and tints are added to meet the needs of opticians

and retail customers. The lenses are then shipped to regional distribution centers (DCs), where they are

held as inventory. (Lenses can, however, be shipped directly to large accounts.) Upon receiving a

purchase order from an optician, the local DC sends the store the lenses that fit the specific requirements

of that order. Usually, the optician then edges and mounts the lenses in a frame of the end-customer’s

choosing, though this activity can be subcontracted to an Essilor finishing center.

https://jigsaw.vitalsource.com/api/v0/books/0071846646/print?from=79…

2 of 2 6/2/2016 11:35 PM

 

 

Page 81

Page 82

PRINTED BY: [email protected]. Printing is for personal, private use only. No part of this book may

be reproduced or transmitted without publisher’s prior permission. Violators will be prosecuted.

Finished Single-Vision Supply Chain

Source: Essilor

SEMIFINISHED LENSES Essilor finalizes its semifinished lenses in one of two ways, either in local prescription labs (Rx local

labs) or in mass-production labs (Rx export labs).

Semifinished Lenses, Local

In this operating model, the end-customer visits an independent optician. After taking eye

measurements, the optician (or large account) sends the prescription, along with a list of the specific

coatings requested by the end-customer, to the local Essilor prescription laboratory (Rx local lab). This

lab belongs to Essilor or to one of its partners; alternatively, it may be a laboratory that is not part of the

Essilor network. These premium progressive lenses are distinguished from finished lenses in four ways:

there is a wider variety, they are appropriate for a larger number of eye prescriptions, they are of a higher

quality, and they can be ordered with a greater number of coating options.

Upstream, semifinished lenses (clear and polarized) are mass-produced in a dedicated plant that

prepares only the front surface of the lenses. These lenses are shipped to a regional DC, where they are

held and subsequently sent to fill the stock of labs.

After receiving a prescription from the optician, the lab polishes the back surface of the lenses and

adds the coatings and tints requested by the optician. Surface finishing in the labs thus makes it possible

for Essilor to produce many different combinations of lenses while at the same time keeping the number

of lenses in inventory low.

The Rx local lab sends the lenses back to the optician, who edges and mounts them in a frame for

the end-customer; alternatively, the labs can do the edging and mounting. The whole order-fulfillment

https://jigsaw.vitalsource.com/api/v0/books/0071846646/print?from=81…

1 of 2 6/2/2016 11:36 PM

 

 

Page 83

process—from the customer’s first visit to having glasses available for the customer—takes only two

days.

Semifinished and Export Supply Chain

Source: Essilor

https://jigsaw.vitalsource.com/api/v0/books/0071846646/print?from=81…

2 of 2 6/2/2016 11:36 PM

 

 

Page 83

Page 84

PRINTED BY: [email protected]. Printing is for personal, private use only. No part of this book may

be reproduced or transmitted without publisher’s prior permission. Violators will be prosecuted.

Semifinished Lenses for Export

A few years ago, Essilor added six lower-cost prescription labs to the supply chain “Rx export labs,”

which are mass-production labs located in low-cost countries. Instead of being finalized in regular Rx

labs, a portion of semifinished lenses are sent from the mass-production plants and regional DCs to Rx

export labs. These labs then ship the lenses to local labs and large accounts in markets worldwide for

last-mile consolidation. The Rx export lab in Mexico, for instance, supplies lenses to retail chains in the

United States. Only a few megastores have their own labs for finalizing lenses.

“The capability of the carriers used to transport product between countries in different continents

has evolved, as has IT,” notes Vice President of Supply Chain and Rx Strategy Eric Javellaud. “So we

were able to build export labs in low-cost countries while retaining proximity to developed markets.

This makes it possible to fulfill customer orders in just five days: two days in the lab to surface and treat

the lens, one day for transportation from the lab to the store, and two days in the store to do the edging

and mounting.”

DEVELOPING THE GLOBAL END-TO-END SUPPLY CHAIN

Up until the 1970s, Essilor produced its lenses in France and sold them mostly in Europe. Over the next

20 years, the company expanded internationally, setting up regional manufacturing and distribution

facilities to be close to its customers. Essilor’s first factories outside Europe were in the continental

United States and the Philippines, followed by plants in Mexico, Puerto Rico, and Brazil.

In the late 1990s, Essilor decided to go truly global, acquiring and partnering with companies to

expand its operational footprint. Unlike some companies, the lens maker developed its supply chain as

an integral part of its growth strategy. The goal was to grow in developed markets while establishing a

presence in emerging ones. To this end, Essilor built new factories in Thailand and China; the company

also acquired a number of lens makers in China.

At the same time, Essilor acquired or partnered with a number of Rx lab companies in the United

States and India. This bolstered the company’s capacity to produce quality progressive lenses in regions

with high demand.

Notably, the companies that joined the Essilor network were not forced to change all their processes

immediately. They did, however, have to adopt Essilor’s worldwide codification of products and use the

same electronic data interchange standards for placing orders. In return, they were given access to

Essilor’s advanced production technology. Even more important, they became part of Essilor’s global

supply chain and could enjoy the attendant steady customer demand and global economies of scale.

To support the global supply chain, Essilor put global sourcing and planning processes in place.

The first step was to consolidate the various IT systems used by operations worldwide into one

integrated end-to-end system. “We set up an ERP system that connected all the relevant operational

functions—order management, procurement, purchasing, and so on,” recalls Gérard Tourenq, vice

president of worldwide logistics. “This has enabled the company to set up the same processes in every

region worldwide.”

The global IT system also enables Essilor to manage a tremendous amount of information coming

https://jigsaw.vitalsource.com/api/v0/books/0071846646/print?from=83…

1 of 2 6/2/2016 11:36 PM

 

 

Page 85

from the end-customer—the dozens of different types of progressive lenses as well as the wide range of

coatings and tints. Essilor’s IT system is robust enough to convey such information to both Rx labs and

Rx export labs alike.

At the same time, Essilor set up a global supply chain organization. Each of the company’s four

regions—America, Latin America, Europe, and AMERA (Asia, the Middle East, Russia, and

Africa)—has a supply chain department. A global team works on processes and practices with a focus

on planning, plant scheduling, and inventory management, while in each zone—that is, each subset of

countries in a particular region— managers are accountable for providing demand information and for

driving inventory replenishment.

https://jigsaw.vitalsource.com/api/v0/books/0071846646/print?from=83…

2 of 2 6/2/2016 11:36 PM

 

 

Page 85

Page 86

PRINTED BY: [email protected]. Printing is for personal, private use only. No part of this book may

be reproduced or transmitted without publisher’s prior permission. Violators will be prosecuted.

As a result of these global initiatives, Essilor became the first in its industry to develop a truly

global supply chain. By 2011, the company had 19 manufacturing plants—4 in Europe, 9 in southern

Asia, 1 in Japan, 4 in North and Central America, and 1 in Brazil—and 390 Rx labs.

BALANCING INVENTORY WITH SERVICE

By any standard, Essilor manages an enormous number of SKUs, which grows steadily as new products

are added to the portfolio. In this situation, excess and obsolete inventory presents a major challenge,

and makes it essential to find the right balance between costs and service.

For Essilor, the solution is to generally keep little if any inventory at its plants. As they are

produced, lenses are shipped to regional DCs or to Rx labs. The network varies by region: the United

States is very centralized, but lead-time requirements in Europe, with its various transportation

challenges, necessitate a DC in practically every country.

Moreover, the global planning process covers forecasts and inventory sizing for each subsidiary. In

addition to biannual reviews, there’s a monthly sales and operations planning process. The purpose is to

develop an achievable plan that is based on forecast demand, sales targets, and the operational

capabilities of Essilor, external partners, and suppliers. Each month, forecast updates are used to size

inventory and manage plant loads.

In the United States, Essilor implemented a replenishment process that’s based on real-time sales.

When an order for a pair of progressive lenses arrives at one of the 127 U.S. labs, it is filled with

semifinished lenses sitting on the lab shelf. Within 24 hours, those lenses are replaced automatically by

the nearest DC. The following Monday, the DC places a replenishment order online, which generates

make-to-order production at a plant in Mexico or Asia. Regardless of where the production takes place,

replenishment processes are a collaborative effort of the entire supply chain: the laboratories, the Essilor

subsidiaries, the geographic regions, and the global supply chain organization.

Essilor has refrained from fully automating some of its planning processes—a decision that

underscores the company’s interest in balancing cost savings with service. “By keeping some steps

dependent on human decision, we have the flexibility to change the product mix when needed,” explains

Tourenq. “If you optimize everything, what’s optimized could end up being a constraint.”

MASTERING COMPLEXITY

Producing some 650,000 SKUs and managing deliveries to some 200,000 ship-to points requires

extremely good management of complexity. In addition to differentiating flows for finished and

semifinished lenses, Essilor has greatly streamlined the delivery process. The company has worked

steadily to consolidate the number of U.S. distribution centers, which had multiplied as a result of

several acquisitions. Essilor has also pushed back the final packaging process so that it occurs after

receipt of a customer’s purchase order, thus eliminating the need for repackaging in the event of a

last-minute order change. In addition, the lens maker has begun shipping directly to customers where

possible.

https://jigsaw.vitalsource.com/api/v0/books/0071846646/print?from=85…

1 of 2 6/2/2016 11:37 PM

 

 

Page 87

Page 88

PRINTED BY: [email protected]. Printing is for personal, private use only. No part of this book may

be reproduced or transmitted without publisher’s prior permission. Violators will be prosecuted.

Essilor has also consistently turned to technology to manage complexity. This includes the use of

digital surfacing, which makes it possible to create different prescription surfaces at a late stage of

production. At the same time, the company has invested in advanced technologies that make it possible

to track individual customer orders as they progress through the supply chain.

Taken together, these practices have had a major impact, both operationally and financially. Not

only is Essilor recognized for service in the industry, its inventory as a percentage of sales declined from

an index of 100 in 1999 to one of 81 in 2011.

BUILDING IN ADAPTABILITY AND RELIABILITY

Being global is great, but it is not enough: a natural disaster can suddenly throw a supply chain off

course. Such events can be especially problematic for a company that views its customer service as a

source of competitive advantage.

Essilor deploys a number of strategies to mitigate the risk of disruption. First, it has built a closely

linked network around its Rx labs and distribution centers. This allows the company to adjust

production, capacity, distribution, and pricing with little advanced notice.1

Essilor has also made a point of placing redundant plants and additional inventory in vulnerable

parts of the supply chain. Its large network helped the lens maker weather the flooding in Thailand in

late 2011.

In addition, Essilor has taken steps to standardize its process architecture worldwide. The company

is standardizing manufacturing processes to facilitate moving production from one plant to another. It is

also standardizing distribution processes in order to shift inventory easily between DCs, while securing

the distribution network with a business continuity plan. At Essilor, adaptability also means being able

to develop new supply chain setups to meet customer needs. In response to requests by retail chain

customers, the lens maker has started developing value-added services, taking over some of its

customers’ supply chain responsibilities. For some large retailers, Essilor has built a supply chain to

provide lenses and to manage the vast number of frames they sell.

Essilor’s emphasis on flexibility makes sense in an industry where technological change is a

constant. Every new development, whether it’s the next generation of progressive lenses (there have

been four so far) or the next manufacturing process, makes it crucial for the supply chain to be able to

adapt readily and easily.

THE NEXT 2.5 BILLION

Worldwide, 4.2 billion people are in need of visual correction. Yet nearly 60 percent go without glasses,

either because they cannot afford them or because there’s no optical store nearby. Most of those 2.5

billion people live in emerging markets, 50 percent are under the poverty line, 60 percent are in rural

areas, and 30 percent are children. By 2030, if nothing is done globally, there could be as many as 3.5

billion people in need going without correction.

Making visual health accessible to the greatest number of people is for Essilor both an ambition and

https://jigsaw.vitalsource.com/api/v0/books/0071846646/print?from=87…

1 of 2 6/2/2016 11:39 PM

 

 

Page 89

a responsibility. The company aims to help reverse, by 2020, the rise in the number of people lacking

access to visual correction.

To this end, Essilor is innovating with new products and business models and using partnerships

and new competencies to develop offerings that address customer needs. And a number of local

initiatives are helping to distribute lenses to the people who need them: mobile optical shops in rural

India, screening projects in China, and charity initiatives led by the Essilor Vision Foundation.

https://jigsaw.vitalsource.com/api/v0/books/0071846646/print?from=87…

2 of 2 6/2/2016 11:39 PM

 

 

Page 89

Page 90

PRINTED BY: [email protected]. Printing is for personal, private use only. No part of this book may

be reproduced or transmitted without publisher’s prior permission. Violators will be prosecuted.

Making a lasting contribution to society is one of the key objectives of Essilor as a company—and

an energizing purpose for its teams.

https://jigsaw.vitalsource.com/api/v0/books/0071846646/print?from=89…

1 of 1 6/2/2016 11:39 PM

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

The Goals Of Data Screening

Data Screening

For this discussion, identify the goals of data screening. Then discuss how you can identify and remedy

the following:

• Errors in data entry.

• Outliers.

• Missing data.

Use your IBM SPSS Statistics Step by Step text to complete the following:

• Review “An Introduction to the Example” in Chapter 1. This section provides definitions of SPSS

variables used in your Unit 3 assignment.

• Read Chapter 6, “Frequencies.” This reading addresses the following topics:

◦ Frequencies.

◦ Bar charts.

◦ Histograms.

◦ Percentiles.

• Read Chapter 7, “Descriptive Statistics.” This reading addresses the following topics:

◦ Statistical significance.

◦ The normal distribution.

◦ Mean, median, and mode.

◦ Variance and standard deviation, skewness, and kurtosis.

◦ Maximum, minimum, range, and sum.

◦ Standard error.

Chapter 1 An Overview of IBM® SPSS® Statistics

Introduction: An Overview of IBM SPSS Statistics 23

THIS BOOK gives you the step-by-step instructions necessary to do most major types of data analysis using SPSS. The software was originally created by three Stanford graduate students in the late 1960s. The acronym “SPSS” initially stood for “Statistical Package for the Social Sciences.” As SPSS expanded their package to address the hard sciences and business markets, the name changed to “Statistical Product and Service Solutions.” In 2009 IBM purchased SPSS and the name morphed to “IBM SPSS Statistics.” SPSS is now such a standard in the industry that IBM has retained the name due to its recognizability. No one particularly cares what the letters “SPSS” stand for any longer. IBM SPSS Statistics is simply one of the world’s largest and most successful statistical software companies. In this book we refer to the program as SPSS.

1.1 Necessary Skills

For this book to be effective when you conduct data analysis with SPSS, you should have certain limited knowledge of statistics and have access to a computer that has the necessary resources to run SPSS. Each issue is addressed in the next two paragraphs.

STATISTICS You should have had at least a basic course in statistics or be in the process of taking such a course. While it is true that this book devotes the first two or three pages of each chapter to a description of the statistical procedure that follows, these descriptions are designed to refresh the reader’s memory, not to instruct the novice. While it is certainly possible for the novice to follow the steps in each chapter and get SPSS to produce pages of output, a fundamental grounding in statistics is important for an understanding of which procedures to use and what all the output means. In addition, while the first 16 chapters should be understandable by individuals with limited statistical background, the final 12 chapters deal with much more complex and involved types of analyses. These chapters require substantial grounding in the statistical techniques involved.

COMPUTER REQUIREMENTS You must:

· Have access to a personal computer that has

· Microsoft® Windows Vista® or Windows® 7 or 8.1 or 10; MAC OS® 10.8 (Mountain Lion) or higher installed

· IBM SPSS Statistics 23.0 installed

· Know how to turn the computer on

· Have a working knowledge of the keys on the keyboard and how to use a mouse—or other selection device such as key board strokes or touch screen monitors.

This book will take you the rest of the way. If you are using SPSS on a network of computers (rather than your own PC or MAC) the steps necessary to access IBM SPSS Statistics may vary slightly from the single step shown in the pages that follow.

1.2 Scope of Coverage

IBM SPSS Statistics is a complex and powerful statistical program by any standards. The software occupies about 800 MB of your hard drive and requires at least 1 GB of RAM to operate adequately. Despite its size and complexity, SPSS has created a program that is not only powerful but is user friendly (you’re the user; the program tries to be friendly). By improvements over the years, SPSS has done for data analysis what Henry Ford did for the automobile: made it available to the masses. SPSS is able to perform essentially any type of statistical analysis ever used in the social sciences, in the business world, and in other scientific disciplines.

This book was written for Version 23 of IBM SPSS Statistics. More specifically, the screen shots and output are based on Version 23.0. With some exceptions, what you see here will be similar to SPSS Version 7.0 and higher. Because only a few parts of SPSS are changed with each version, most of this book will apply to previous versions. It’s 100% up-to-date with Version 23.0, but it will lead you astray only about 2% of the time if you’re using Version 21.0 or 22 and is perhaps 60% accurate for Version 7.0 (if you can find a computer and software that old).

Our book covers the statistical procedures present in three of the modules created by SPSS that are most frequently used by researchers. A module (within the SPSS context) is simply a set of different statistical operations. We include the Base Module (technically called IBM SPSS Statistics Base), the module covering advanced statistics (IBM SPSS Advanced Statistics), and the module that addresses regression models (IBM SPSS Regression)—all described in greater detail later in this chapter. To support their program, SPSS has created a set of comprehensive manuals that cover all procedures these three modules are designed to perform. To a person fluent in statistics and data analysis, the manuals are well written and intelligently organized. To anyone less fluent, however, the organization is often undetectable, and the comprehensiveness (the equivalent of almost 2,000 pages of fine-print text) is overwhelming. To the best of our knowledge, hard-copy manuals are no longer available but most of this information may now be accessed from SPSS as PDF downloads. The same information is also available in the exhaustive online Help menu. Despite changes in the method of accessing this information, for sake of simplicity we still refer to this body of information as “SPSS manuals” or simply “manuals.” Our book is about 400 pages long. Clearly we cannot cover in 400 pages as much material as the manuals do in 2,000, but herein lies our advantage.

The purpose of this book is to make the fundamentals of most types of data analysis clear. To create this clarity requires the omission of much (often unnecessary) detail. Despite brevity, we have been keenly selective in what we have included and believe that the material presented here is sufficient to provide simple instructions that cover 95% of analyses ever conducted by researchers. Although we cannot substantiate that exact number, our time in the manuals suggests that at least 1,600 of the 2,000 pages involve detail that few researchers ever consider. How often do you really need 7 different methods of extracting and 6 methods of rotating factors in factor analysis, or 18 different methods for post-hoc comparisons after a one-way ANOVA? (By the way, that last sentence should be understood by statistical geeks only.)

We are in no way critical of the manuals; they do well what they are designed to do and we regard them as important adjuncts to the present book. When our space limitations prevent explanation of certain details, we often refer our readers to the SPSS manuals. Within the context of presenting a statistical procedure, we often show a window that includes several options but describe only one or two of them. This is done without apology except for the occasional “description of these options extends beyond the scope of this book” and cheerfully refer you to the appropriate SPSS manual. The ultimate goal of this format is to create clarity without sacrificing necessary detail.

1.3 Overview

This chapter introduces the major concepts discussed in this book and gives a brief overview of the book’s organization and the basic tools that are needed in order to use it.

If you want to run a particular statistical procedure, have used IBM SPSS Statistics before, and already know which analysis you wish to conduct, you should read the Typographical and Formatting Conventions section in this chapter (pages 5–7) and then go to the appropriate chapter in the last portion of the book (Chapters 6 through 28). Those chapters will tell you exactly what steps you need to perform to produce the output you desire.

If, however, you are new to IBM SPSS Statistics, then this chapter will give you important background information that will be useful whenever you use this book.

1.4 This Book’s Organization, Chapter by Chapter

This book was created to describe the crucial concepts of analyzing data. There are three basic tasks associated with data analysis:

1. You must type data into the computer, and organize and format the data so both SPSS and you can identify it easily,

2. You must tell SPSS what type of analysis you wish to conduct, and

3. You must be able to interpret what the SPSS output means.

After this introductory chapter, Chapter 2 deals with basic operations such as types of SPSS windows, the use of the toolbar and menus, saving, viewing, and editing the output, printing output, and so forth. While this chapter has been created with the beginner in mind, there is much SPSS-specific information that should be useful to anyone. Chapter 3 addresses the first step mentioned above—creating, editing, and formatting a data file. The SPSS data editor is an instrument that makes the building, organizing, and formatting of data files wonderfully clear and straightforward.

Chapters 4 and 5 deal with two important issues—modification and transformation of data (Chapter 4) and creation of graphs or charts (Chapter 5). Chapter 4 deals specifically with different types of data manipulation, such as creating new variables, reordering, restructuring, merging files, or selecting subsets of data for analysis. Chapter 5 introduces the basic procedures used when making a number of different graphs; some graphs, however, are described more fully in the later chapters.

Chapters 6 through 28 then address Steps B and C—analyzing your data and interpreting the output. It is important to note that each of the analysis chapters is self-contained. If the beginner, for example, were instructed to conduct t tests on certain data, Chapter 11 would give complete instructions for accomplishing that procedure. In the Step by Step section, Step 1 is always “start the SPSS program” and refers the reader to Chapter 2 if there are questions about how to do this. The second step is always “create a data file or edit (if necessary) an already existing file,” and the reader is then referred to Chapter 3 for instructions if needed. Then the steps that follow explain exactly how to conduct a t test.

As mentioned previously, this book covers three modules produced by SPSS: IBM SPSS Statistics Base, IBM SPSS Advanced Statistics, and IBM SPSS Regression. Since some computers at colleges or universities may not have all of these modules (the Base module is always present), the book is organized according to the structure SPSS has imposed: We cover almost all procedures included in the Base module and then selected procedures from the more complex Advanced and Regression Modules. Chapters 6–22 deal with processes included in the Base module. Chapters 23–27 deal with procedures in the Advanced Statistics and Regression Modules, and Chapter 28, the analysis of residuals, draws from all three.

IBM SPSS STATISTICS BASE, Chapters 6 through 10 describe the most fundamental data analysis methods available, including frequencies, bar charts, histograms, and percentiles (Chapter 6); descriptive statistics such as means, medians, modes, skewness, and ranges (Chapter 7); crosstabulations and chi-square tests of independence (Chapter 8); subpopulation means (Chapter 9); and correlations between variables (Chapter 10).

The next group of chapters (Chapters 11 through 17) explains ways of testing for differences between subgroups within your data or showing the strength of relationships between a dependent variable and one or more independent variables through the use of t tests (Chapter 11); ANOVAs (Chapters 12, 13, and 14); linear, curvilinear, and multiple regression analysis (Chapters 15 and 16); and the most common forms of nonparametric tests are discussed in Chapter 17.

Reliability analysis (Chapter 18) is a standard measure used in research that involves multiple response measures; multidimensional scaling is designed to identify and model the structure and dimensions of a set of stimuli from dissimilarity data (Chapter 19); and then factor analysis (Chapter 20), cluster analysis (Chapter 21), and discriminant analysis (Chapter 22) all occupy stable and important niches in research conducted by scientists.

IBM SPSS ADVANCED STATISTICS AND REGRESSION: The next series of chapters deals with analyses that involve multiple dependent variables (SPSS calls these procedures General Linear Models; they are also commonly called MANOVAs or MANCOVAs). Included under the heading General Linear Model are simple and general factorial models and multivariate models (Chapter 23), and models with repeated measures or within-subjects factors (Chapter 24).

The next three chapters deal with procedures that are only infrequently performed, but they are described here because when these procedures are needed they are indispensable. Chapter 25 describes logistic regression analysis and Chapters 26 and 27 describe hierarchical and nonhierarchical log-linear models, respectively. As mentioned previously, Chapter 28 on residuals closes out the book.

1.5 An Introduction to the Example

A single data file is used in 17 of the first 19 chapters of this book. For more complex procedures it has been necessary to select different data files to reflect the particular procedures that are presented. Example data files are useful because often, things that appear to be confusing in the SPSS documentation become quite clear when you see an example of how they are done. Although only the most frequently used sample data file is described here, there are a total of 12 data sets that are used to demonstrate procedures throughout the book, in addition to data sets utilized in the exercises. Data files are available for download at www.spss-step-by-step.net. These files can be of substantial benefit to you as you practice some of the processes presented here without the added burden of having to input the data. We suggest that you make generous use of these files by trying different procedures and then comparing your results with those included in the output sections of different chapters.

The example has been designed so it can be used to demonstrate most of the statistical procedures presented here. It consists of a single data file used by a teacher who teaches three sections of a class with approximately 35 students in each section. For each student, the following information is recorded:

· ID number

· Name

· Gender

· Ethnicity

· Year in school

· Upper- or lower-division class person

· Previous GPA

· Section

· Whether or not he or she attended review sessions or did the extra credit

· The scores on five 10-point quizzes and one 75-point final exam

In Chapter 4 we describe how to create four new variables. In all presentations that follow (and on the data file available on the website), these four variables are also included:

· The total number of points earned

· The final percent

· The final grade attained

· Whether the student passed or failed the course

The example data file (the entire data set is displayed at the end of Chapter 3) will also be used as the example in the introductory chapters (Chapters 2 through 5). If you enter the data yourself and follow the procedures described in these chapters, you will have a working example data file identical to that used through the first half of this book. Yes, the same material is recorded on the downloadable data files, but it may be useful for you to practice data entry, formatting, and certain data manipulations with this data set. If you have your own set of data to work with, all the better.

One final note: All of the data in the grades file are totally fictional, so any findings exist only because we created them when we made the file.

1.6 Typographical and Formatting Conventions

CHAPTER ORGANIZATION Chapters 2 through 5 describe IBM SPSS Statistics formatting and procedures, and the material covered dictates each chapter’s organization. Chapters 6 through 28 (the analysis chapters) are, with only occasional exceptions, organized identically. This format includes:

1. The Introduction in which the procedure that follows is described briefly and concisely. These introductions vary in length from one to seven pages depending on the complexity of the analysis being described.

2. The Step by Step section in which the actual steps necessary to accomplish particular analyses are presented. Most of the typographical and formatting conventions described in the following pages refer to the Step by Step sections.

3. The Output section, in which the results from analyses described earlier are displayed—often abbreviated. Text clarifies the meaning of the output, and all of the critical output terms are defined.

THE SCREENS Due to the very visual nature of SPSS, every chapter contains pictures of screens or windows that appear on the computer monitor as you work. The first picture from Chapter 6 (below) provides an example. These pictures are labeled “Screens” despite the fact that sometimes what is pictured is a screen (everything that appears on the monitor at a given time) and other times is a portion of a screen (a window, a dialog box, or something smaller). If the reader sees reference to Screen 13.3, she knows that this is simply the third picture in Chapter 13. The screens are typically positioned within breaks in the text (the screen icon and a title are included) and are used for sake of reference as procedures involving that screen are described. Sometimes the screens are separate from the text and labels identify certain characteristics of the screen (see the inside front cover for an example). Because screens take up a lot of space, frequently used screens are included on the inside front and back covers of this book. At other times, within a particular chapter, a screen from a different chapter may be cited to save space.

 

Screen 1.1 The Frequencies Window

Sometimes a portion of a screen or window is displayed (such as the menu bar included here) and is embedded within the text without a label.

 

The Step by Step boxes: Text that surrounds the screens may designate a procedure, but it is the Step by Step boxes that identify exactly what must be done to execute a procedure. The following box illustrates:

 

Sequence Step 3 means: “Beginning with Screen 1 (displayed on the inside front cover), click on the word File, move the cursor to Open, and then click the word Data. At this point a new window will open (Screen 2 on the inside front cover); type ‘grades.sav’ and then click the Open button, at which point a screen with your data file opens.” Notice that within brackets shortcuts are sometimes suggested: Rather than the File → Open → Data sequence, it is quicker to click the icon. Instead of typing grades.sav and then clicking Open, it is quicker to double click on the grades.sav (with or without the “.sav” suffix; this depends on your settings) file name. Items within Step by Step boxes include:

Screens: A small screen icon will be placed to the left of each group of instructions that are based on that screen. There are three different types of screen icons:

 

Other images with special meaning inside of Step by Step boxes include:

 

Sometimes fonts can convey information, as well:

Font What it Means
Monospaced font (Courier) Any text within the boxes that is rendered in the Courier font represents text (numbers, letters, words) to be typed into the computer (rather than being clicked or selected).
Italicized text Italicized text is used for information or clarifications within the Step by Step boxes.
Bold font The bold font is used for words that appear on the computer screen.

The groundwork is now laid. We wish you a pleasant journey through the exciting and challenging world of data analysis!

George, Darren. IBM SPSS Statistics 23 Step by Step, 14th Edition. Routledge, 20160322. VitalBook file.

The citation provided is a guideline. Please check each citation for accuracy before use.

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Hoover Data Analysis and Visualization

For this assignment – you will demonstrate your ability to use Excel Pivot tables to analyze data and produce charts/graphs to aid you in presenting your analysis and supporting your recommendations.

 

Case Background:

Hoover Medical Supplies, Inc, is a large manufacturing company located in Columbus, Ohio. The company is currently seeking to gain operational efficiencies in its supply chain by reducing the number of transportation carriers that it is using from five to three and thereafter open discussions concerning volume discounts with its remaining carriers. Brian Hoover, the CEO of Hoover Medical Supplies, has hired you to analyze its data and make a clear recommendation about how to reduce transportation costs while retaining a high level of service from its best carriers. Hoover has customers in Michigan, West Virginia, Virginia, Pennsylvania, Indiana, Kentucky and Ohio.

 

Data Available:

The HooverData.xlsx file contains all the shipping invoices submitted by its current carriers and paid by Hoover. Shipping is billed by the pound at a rate that considers fuel costs, driver costs and truck costs. The file also includes data collected by tracking the delivery schedule of the shipments – reflected in the column of Days Overdue. Late deliveries are not tolerated by Hoover’s customers and need to be minimized within its carrier pool.

 

Project Focus:

Carrier selection should be based on the assumptions that all environmental factors are equal and that historical cost trends will continue. Review the data from the past several years to determine your recommendation for the top three carriers that Hoover should continue to do business with. Be sure that the three carriers recommended will provide adequate coverage of all states currently serviced. (Don’t assume carriers will expand their services to states not currently served.)

 

1) Analyze the last 24 months of Hoover’s carrier transactions found in the data file: HooverData.xlsx.

 

2) Apply what you learned about the use of Excel Pivot Tables and do a thorough analysis of the data to determine which carriers provide the best service at the best price to the states that Hoover services. Consider whether you should look at totals or averages in your analysis. (We discussed this in class!) Slice and Dice (pivot) the data a number of different ways to help you in your analysis. Look at each factor – service, price and quality. Spend some time thinking about the problem and how best to analyze the data.

 

3) Review your analysis and determine the top three carriers that you recommend to be retained. Prepare a memo to Mr. Brian Hoover in which you detail your recommendation for the top three carriers with which Hoover should continue to do business. Organize your memo to be succinct but informative. Be sure to support your recommendation with the facts and results of your analysis because there are some biases amongst your co-workers that may distort their view of the carriers. To better make your argument, your report must support your recommendation by presenting the data using visualization techniques. Charts and graphs should be well designed

Assignment #2 –Data Analysis, Visualization and Reporting

 

and labeled, and include legends, titles, and values where appropriate. Assume that Mr. Hoover will not have access to your Excel document – thus your memo will need to display the charts/graphs to support your analysis and conclusion. Don’t just put the graphics at the end of the document – but rather insert and discuss each visualized data point.

 

Use a formal and professional writing style and tone in your report. Use a Memo template

(found in Microsoft Word). Address the memo to Mr. Hoover – use your name in the “From” section. Check your grammar and spelling. Use complete sentences and bulleted lists to succinctly but thoroughly state the results of your analysis and your recommendation. Make your recommendation easy to find – in fact, best versions will begin and end the memo with a clearly stated recommendation.

 

Project Deliverables:

 

You must demonstrate your ability to create and use pivot tables to complete this assignment. Save each of your Pivot Tables in your Excel workbook. Create Charts on the data elements that you will use to justify your recommendation in the Word document. Upload your Excel file – (with all the Pivot tables that you created to perform your analysis) to the Blackboard assignment link. You may not need to use or reference each created pivot table in your final report – its ok to leave any extra pivot tables in your Excel document.

 

I would like to remind you that this homework assignment must be completed and submitted individually and that no late work is accepted.

 

Assignment Deliverables:

· Submit your Excel workbook to the Blackboard Assignment #2 Course Link

· Also submit your Word document (memo) to the Blackboard Assignment #2 Course Link

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

2

 

Assignment #2 –Data Analysis, Visualization and Reporting

 

Submitted by: _________________________________ Section: ________

 

Grading Rubric for Assignment #2:

Points Earned Category Description/Requirements
______(10) Analysis of Data Demonstrate the correct use of Pivot Tables and a thorough analysis of the data (file must be posted to Blackboard to receive credit). I define thorough as 3 or more points of analysis.
______(5) Proper analysis Proper analysis uses the right variables, and the correct statistical measurements. Don’t just include a graph or table of every column of the Excel data.
______(8) Word Document Submission of Word Document using a Memo template and a formal, professional tone with attention to writing and style submitted in printed form and also posted to Blackboard. Strategic use of bullets – or short paragraphs to make the info on the memo easy to find.
______(7) Visualization Use of easily consumed and visualized data (tables and charts) inserted into your Word Document, introduced and discussed to illustrate and support your analysis and recommendation
______(3) Clear & Concise Recommendation Clear and Concise recommendation of 3 carriers to keep. Don’t make me look for this info. Better versions will introduce and conclude with the recommendation clearly stated.
______(2) Correct

Recommendation

Correct Recommendation of 3 Best Carriers
______(5) Proper

Submission

Grading Rubric as cover page submitted in class with hardcopy version of Memo to Mr. Brian Hoover. Submission of electronic copy of Excel document to Blackboard Assignment Course Link.
 

______(40)

 

Total Points Earned

 

Attention: No late work accepted. Notes:

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Legoland Forecasting Application

Study the Week 3 Virtual Company Tours.

Answer the following questions in short answer or list format. Each answer must be at least 300 words.

  • Why      is forecasting important to the Legoland® California Resort?
  • What      are the forecasting techniques that Legoland® might find helpful when      forecasting and why?
  • What      events might occur that could produce a significant error in      Legoland’s® forecast on any particular day?
  • Based      on your assessment of all of the rides, attractions, and restaurants,      provide a rough estimate for the number of guests that the park can      accommodate at any given time. Then provide a rough estimate of the number      of employees needed in the park on a busy day. How many employees would be      needed on a day with light attendance?

Format any resources used consistent with APA guidelines.

Click the Assignment Files tab to submit your assignment.

Study the Week 3 Virtual Company Tours.

Answer the following questions in short answer or list format. Each answer must be at least 300 words.

  • Why      is forecasting important to the Legoland® California Resort?
  • What      are the forecasting techniques that Legoland® might find helpful when      forecasting and why?
  • What      events might occur that could produce a significant error in      Legoland’s® forecast on any particular day?
  • Based      on your assessment of all of the rides, attractions, and restaurants,      provide a rough estimate for the number of guests that the park can      accommodate at any given time. Then provide a rough estimate of the number      of employees needed in the park on a busy day. How many employees would be      needed on a day with light attendance?

Format any resources used consistent with APA guidelines.

Click the Assignment Files tab to submit your assignment.

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"