Design Evaluation Spreadsheet For The Design of A Baby Teether
Design Evaluation Spreadsheet For The Design of A Baby Teether
by
Deborah J. Bein
at the
June 1990
Signature of Author
Department of Mechanical Engineering
June 4, 1990
-,~ /~
Certified by
ProfessoP Steven D. Eppinger
Thesis Supervisor
Accepted by
Profes eter Griffith
Chairman, Undergraduate hfris Committee
MASSACHUSETTS INSTITUTE
OF TECHNOLOGY
JUL 09 1990
LIBRARS
DESIGN EVALUATION SPREADSHEET FOR THE
DESIGN OF A BABY TEETHER
by
Deborah J. Bein
Abstract
A computer spreadsheet is used as a method of evaluating designs for baby
teethers. Four goals for the design are chosen: functionality, marketability,
safety, and cost economy. These goals are further defined and analyzed.
Goal scores are determined by weighting the design specifications in order
of importance and then summing their individual scores. The four goals
are also weighted and summed to obtain a final score for a design. The
preparation of the design spreadsheet is presented. Four teethers are
evaluated and compared: Cooling Teether with handle, Cooling Teether,
and Cool Ring Teether, all made by Kiddie Products, Inc., and Nuk
Teether, made by Gerber.
I would like to thank Steve Eppinger and the rest of the thesis group, Mark
Lester, George Nunn, Stephanie Patterson, and Carolyn Theodore, for all
their help. I would also like to thank everyone at Kiddie Products for their
time with us.
I dedicate my thesis to my mother and to Andrew, for all their love and
support, and to Kent McCord, for always being there when I needed him.
Table of Contents
Abstract 2
Acknowledgements and Dedication 3
Table of Contents 4
List of Figures 5
List of Tables 6
1. Introduction 7
2. Methods of Choosing a Quality Design 10
2.1 The Desig n Process 10
2.2 Existin Methods 11
2.2.1 uality Function Deployment 11
2.2.2 e Concept Selection Matrix 11
2.2.3 The Design Spreadsheet 12
3. The Design Spreadsheet for Baby Teethers 15
3.1 Spreadsheet Structure 16
3.2 Teether Design Goals, Characteristics, and Formulas 22
3.2.1 Functionality 24
3.2.2 Marketability 31
3.2.3 Safety 34
3.2.4 Cost Economy 37
3.3 Results of Tested Teethers 38
4. Conclusions 42
Appendix A. The Teether Spreadsheet 44
A. 1 Design Goals 44
A.2 Design Parameters 45
A.3 UserParameters 47
A.4 User Values 52
Appendix B. Spreadsheet Formulas 57
B. 1 Design Goals 57
B.2 Design Parameters 58
B.3 User Parameters 60
List of Figures
Kiddie Products' 1438 cooling teether with handle and 1437 cooling
teether without handle have been available for approximately ten years.
The 1438 is shown in Figure 1-1. Kiddie produces over 20,000
pieces/month each of the two teethers.
Figure 1-1: Cooling Teether With Handle
The teether has a triangle shape and blue color. It is filled with water,
allowing it to become cold in a refrigerator. The teething ring is made of
ethylene vinyl acetate through a blow molding process and the handle is
made of polypropylene through an injection molding process. Each of
these processes is performed by an outside contractor. The two
components are then shipped to Kiddie's facility in Avon, Massachusetts,
where filling and sealing of the teether, attachment of the handle (for the
1438), packaging, and shipping operations are performed.
2) Food particles may collect in the crevices of the handle, making the
teether harder to clean and less sanitary. Water may also get trapped inside
the handle, giving bacteria a place to grow.
3) For the 1437 (teether without the handle), if the teether is sealed
too high, the extra material may leave a very rough edge. On the 1438, the
handle covers this area.
To help determine the best possible design, I will present the a design
spreadsheet for teethers. The spreadsheet lists all the important
characteristics and performance measures for a cooling teether and
quantitatively measures one design against another. This tool then may be
used to compare proposed teether designs to find the best one.
Chapter 2
On the other hand, the design spreadsheet has some drawbacks, also.
It is only an effective tool if it is used correctly. Specific design parameters
Preparing a spreadsheet involves five major steps. First, the goals for
the design must be defined. The goals should be in broad terms which
cover every area of any importance in the design. For example, one goal
for a teether design is that the teether appear attractive and safe for a child,
enticing a shopper to buy it. The color of the teether affects this
attractiveness. Brown is certainly less pleasing to view as a baby teether
than bright blue. Therefore, one broad goal of the design is marketability,
defined here as all the characteristics that would make someone looking at
a teether want to buy it. Brand loyalty and advertising also make a product
more marketable, but they are not directly affected by the product design,
and are therefore not included in the goal of marketability. Some
characteristics of marketability are attractive appearance, or aesthetic
appeal, and appearance of safety. These are listed under marketability.
The color of the teether, then, since it affects attractiveness, would be a
parameter under aesthetic appeal, which is a characteristic of marketability.
Section 3.2 describes the goals chosen for the teether and all of their
components. Designers can always easily revise the spreadsheet, so any
forgotten or new goals or components may easily be added later. In fact,
the spreadsheet is meant for revision. It should be able to help determine
where a goal or parameter may be missing. The designer can then add the
missing section and repeat the process.
Step two is to decide what determines the goals. Each goal should
have a set of design parameters that define it. An equation is formulated
for each goal using those design parameters. The design parameters are
weighted according to importance and summed for the total goal score.
The design parameters can also be broken down into more specific user
parameters. Again, an equation for each design parameter is formulated
using the user parameters. There are a total of three levels under the design
goals: design parameters, user parameters, and user values. The user
values contain the data entered by the user about the teether design. The
user parameter scores are formed from equations comparing the user values
to chosen design values. Each design thus gets compared to the same set of
standard values. This step is described in more detail later. An example
from the teether spreadsheet of a goal, its design parameters, and its user
parameters is displayed in Figure3-1.
Every parameter and goal is scaled so that each one receives a value
that can be relatively compared to the others. The values for the user
parameters are all scaled between zero (worst) and one (best). The goals
and design parameters are rated from zero (worst) to ten (best). Every
formula follows the theory, "more is better," meaning the higher the final
value, the better the score.
The best way to start devising the formulas is by starting at the lowest
level of the spreadsheet that uses formulas, the user parameters. For
example, before the formula for the goal Functionality (see Figure3-1) can
Goal: Functionality
Soothing to Baby
calms baby
ability to get cold
handle
Usable as a Toy
shape
fun
moving objects
sound
Handling Size
thickness
length
width
weight
Ease of Cleaning
dishwasher safe
grooves
cleaning thoroughness
Durability
lifetime
material
destructibility
[The parameters in this example are explained
in the following section.]
Figure 3-1: Structure of a Goal and its Parameters
be computed, each of the design parameter scores (Soothing to Baby,
Usable as a Toy, etc.) must be formulated. The design parameters, though,
are formed from the user parameters. For instance, Handling Size is based
on length, width, thickness, and weight. So, it is best to begin with the user
parameter formulas. A user parameter formula must transform the user
value into a number which ranks the quality of the pertaining parameter
issue. In order to determine whether a user value is good or bad, it is
compared to a set of known values, called the base case. These values may
be an existing design, or a suggested design. For the teether spreadsheet,
"optimal" values were determined based on teether market research. These
values are not necessarily the best possible values for a teether design, but
they represent the teether market's opinion of what the most desirable
teether qualities should be. (Again, it must be stressed here that the design
scores are very dependent on the people who choose the spreadsheet goals,
pick a base case and influence the spreadsheet in any way.) Every design
in the spreadsheet is compared to the base case. Therefore, all the designs
are compared to the same set of standard values. Within the spreadsheet,
the base case values are incorporated into the user parameter formulas.
Every number can be easily replaced, thus continuing the iterative design
process. Since the spreadsheet is set up using optimal values as a base
case, no design can be better than the base case and the final score is a
value between zero and ten. However, a spreadsheet can also be prepared
such that a design that matches the quality of the base case receives a score
of five, a design worse than the base case receives less than five, and a
design surpassing the base case receives a score between five and ten.
Each user parameter within the group that defines one design
parameter is not necessarily of equal importance. For example, the design
parameter Aesthetic Appeal includes the user parameters size and color. It
is more important that the teether is small enough to fit in a baby's mouth
than exactly what color it is. The user parameters are therefore weighted
according to how important they are relative to each other. The design
parameter formulas sum the weighted scores of each user parameter. The
user parameters are then multiplied by their importance percentage. In a
similar manner, the scores for each goal are formulated by weighting the
design parameter values.
A low final goal score shows that an area of the design needs
improvement or a parameter may even have been forgotten. The scores
also demonstrate how an issue in one design compares to the same issue in
another design. Every score is based on the user parameters, which are
obtained directly from information about the design currently being
evaluated.
The design goals and their components are listed in columns on the
left side of the spreadsheet and numerical values for the goals and
parameters continue across the sheet. A sample spreadsheet would be
similar to Figure 3-2.
The spreadsheet is now prepared for a "trial run." The third step is
testing it and checking that the formulas are correct. Data from an existing
Design Goal Design Parameter User Parameter Comments User
Goals Score Parameters Values Parameters Values Values
Formulas Formulas Formulas These Actual
based on based on based on comments data about
desi9n user user contain teether
parameters. parameters. values. informationdesign.
and
questions
to be
answered
inthe User
Value
Column.
The last step is for the designer. Once the weaknesses and strengths
of a design are exposed, the product should be redesigned and retested.
Hopefully, the more the design is tested, the number of areas that need
improvement will decrease.
The design spreadsheet process starts with the first step, picking
design goals for a teether. It is important not to pick too many goals. Too
many goals can make the spreadsheet very hard to read and the results very
confusing. It is also important, however, not too pick too few goals. No
substantial conclusions can be made without enough information.
5 Carolyn
Theodore, Marketing Analysis of a Children's Product, M.I.T. Sloan School
of Management S.M. Thesis, June, 1990
Table 3-I: Desired Characteristics of Teethers
Interesting to child/
toy-like 56%
Easy to hold 56%
Refrigeratable/cooling 50%
Bright color/attractive
to child 50%
Safety 50%
Material 50%
Brand Name 44%
Texture 25%
Comfortable in Mouth 25%
Shape 19%
Durable 19%
Easy to Clean 12%
Attachable 12%
There are three types of questions that the spreadsheet user may be
asked. The first type asks for a certain dimension or characteristic of the
teether. The second type asks the user to rate a specific quality of the
teether. The ratings are from one (worst) to ten (best). The third question
just requires a yes or no answer. In the third case, a one is the input for a
"yes" answer and a zero is the input for a "no" answer. (All the inputs are
numerical.) Every user parameter formula considers the kind of data it
receives and incorporates it into a value between zero and one.
All of the parameter formulas are listed in Appendix B. The base case
values are within the user parameter formulas in B.2.
3.2.1 Functionality
One method that has been found to ease pain is applying a cold
surface to the pain. The coldness numbs the pain. So, the user is next
asked if the teether has the ability to get cold, and to stay cold (heat
capacity). If the answer is yes, the user parameter becomes "1," the highest
value. The next question is whether the teether has a handle and, if so, if
the handle is useful or if it is just a cumbersome addition to the teething
ring. Particularly in cooling teethers, the handle may be a different
material and therefore not get cold, giving the teether a warmer temperature
with which to be held. This handle question rates the use of the handle,
where an input of "10" means the handle makes the teether much easier to
grasp, provides a non-cold surface to hold, and does not make the teether
too bulky.
For these three cases, the user parameter formulas are relatively
simple. Any user value that is a rating from one to ten is divided by ten to
scale all the values between zero and one. The yes/no questions use the
format "if, then, else." For example, the parameter ability to get cold asks a
question which prompts prompts for a yes or no answer. If the teether is a
cooling teether, the answer is "yes." The user value input is then "1." The
formula for ability to get cold states, if(UV= 1,1,0). This translates as, if the
user value (UV) equals one, then display one, otherwise display zero. Thus,
the cooling teether receives a value of one, the highest possible score for a
user parameter. This score adds points towards the soothing to baby score,
the functionality score, and eventually the total design score.
Now that the user parameters of soothing to baby have been decided
upon, the three parameters must be weighted in order of importance.
Calming the baby is the most important function of a teether, so that
parameter gets the highest percentage. It has been given an importance
weight of 50% of the soothing to baby design parameter. A cold teether
has been proven to help soreness and it is a desirable quality among
parents, so ability to get cold is rated next. It has been given 40%. Last is
whether the handle is helpful, with 10%. The formula for the design
parameter soothing to baby, therefore, is 0.5*(calmness rating) +
0.4*(ability to get cold (1 or 0)) + 0.1*(handle rating). ("*"t is the symbol
for multiplication.) The design parameter formulas are listed in Appendix
B.2.
Usable as a Toy
As Table 3-I proves, many parents look for more than one function in
products that they buy for their children. Teethers do not have to just
soothe aching gums, they can be entertaining also. Not only does a fun
teether keep the baby's attention longer, but parents may also think that
they are getting more use from their money. The factors that determine
whether a teether can also be a toy are its shape, that is, whether it is in the
shape of a particular animal or object; its fun factor, meaning a rating of
how fun the teether is to play with; its contents, whether there are any
fascinating moving objects; and the teether's sound, that is, whether the
teether makes any noise, similar to a rattle, for example.
Handling Size
Teethers are used by babies from age three months and older.
Because teething starts so young, the size of a teether is especially
important. Since a teether belongs in the mouth, the teether must fit well in
a baby's small mouth and be able to reach the aching gums. The baby
should also be able to hold the teether comfortably in her/his small hands.
A big, bulky teether is not desirable.
The parameters used to evaluate the handling size are the teether
dimensions thickness, length, and width, and the weight of the teether.
Parents generally agree that a thin teether is easier to hold and to chew.
Heavy teethers may be difficult for a baby to hold for a length of time.
Bulkiness adds more weight and makes the teether difficult to hold.
Overall, small teethers receive more positive response than large ones.
The user parameter formulas for size and weight are quite
complicated. The required dimensions are thickness, length, and width.
To define these dimensions, the teether is treated as if it were surrounded
by a square or rectangle. The length and width are defined by the two
longer sides. Figure 3-3(a) describes the dimensions more clearly, using
Kiddie's Cooling Teether as an example. The thickness is generally the
part of the teether that the child will wrap her/his fingers around, or put in
her/his mouth. This dimension therefore is desired quite small.
The dimensions are still not that simple, unfortunately. The formulas
need to distinguish between a circular teether and a polygon teether. The
spreadsheet asks the user to distinguish the teether type. If a circular
teether were treated the same way as above, a teether such as the Cool Ring
teether, by Kiddie Products, would be quite difficult to measure, and, more
than that, its measurements would not have the same definitions as those of
the Cooling Teether. The dimensions would be inaccurate. For a circular
teether, the diameter is used in place of the length. The width and
thickness are measured around the area on which the baby will chew. The
dimensions are shown in Figure3-3(b), using Kiddie's Cool Ring Teether
as an example.
The length and width optimal values chosen are two inches each.
This value was determined based on the teether market research which
revealed much interest in small teethers. The optimal diameter chosen for
circular teethers is four inches, but a diameter even two inches above or
below four will still receive a high score. Circular teethers may be larger
than others since many of them consist of just an outside ring with nothing
in the middle.
Ease of Cleaning
(tx)
ToP VIEW ,
teether a very simple process. Whether it is dishwasher safe or not, a
teether should be easy to clean. Since babies play with dirt and practically
anything they touch, baby products get dirty very easily. It is very
important that the teether contain no areas where dirt could get stuck.
Since the teether is also meant for the mouth, cleanliness is even more
important. There cannot be any grooves or crevices where dirt and germs
can collect. If the teether has a handle or more than one part, it would be
advantageous to have the parts removable, thus allowing the teether to be
cleansed more thoroughly.
Durability
Aesthetic Appeal
The aesthetic appeal parameter above considers only the teething ring,
not any attachments. The handle aesthetic appeal is also important because
an unattractive handle could destroy the presence of what could be an
attractive teething ring. Like above, size, shape, and color of the handle
are considered.
Appearance of Safety/Durability
Appearance of Comfort
Appearance of Cleaning
Price
Almost any consumer, for almost all products, is concerned with the
3.2.3 Safety
This test measures any holes within the teether, for example, Kiddie's
cooling teether in Figure 1.1 has an inside hole. The holes may not be less
than .5 inch. This is to prevent the entrapment of small fingers in the hole.
Strings/Cords
This test measures the full uncoiled length of any strings or cords
attached to the teether. A cord may not be more than twelve inches long.
The purpose of the test is to prevent the possibility of the cord strangling
the child.
Sanitary Liquids
Size Requirements
Abuse Tests
These tests all measure the strength and durability of the teether and
ensure that the teether can not fall apart. After each of these tests, the
teether should be checked again for accessible edges. The tests are the
following:
* Impact Test (or Drop Test)
The impact test requires the teether to be dropped from a
height of at least 36.5 inches and be intact without any
damage. Sharp edges and points should be checked for after
the impact test.
* Bite Test
The teether must be able to resist successfully a load that
incrementally builds up to 100 pounds.
8 AmericanSociety of Testing and Materials, Section F 963, 4.7 and 4.8, Annual
Book of ASTM Standards, Philadelphia, 1986
" Puncture Resistance Test
A needle is applied to a smooth surface of the teether with
a force of one pound.
The scores have no units. The numbers are relative to each other.
The Cooling Teether with handle receives a lower relative score for a
few reasons. Although the handle adds another surface on which to hold or
chew, it contains grooves that are difficult to clean. The handle is designed
to snap on to the teething ring with just enough loose area inbetween them
to become a place for dirt to collect. The teether is also slightly bulky,
particularly with the handle.
The Cool Ring does best in Functionality mostly because of its play
value. None of the others tested have any fun features. The Cool Ring is a
colorful and fun toy. This advantage is fully exposed under the
Functionality goal. However, there are a number of safety appearance
Tabie 3-II: Scores of Tested Teethers
problems. (See Appendix A.2 for the breakdown scores of the design
parameters.) Parents worry that the small animals within the teether may
puncture the material, or if the teether breaks, their children may swallow
the animals. These appearance problems are uncovered under the
Marketability goal, explaining why the Cool Ring's Marketability score is
lower than some of the others.
The Cooling Teether (without handle) and the Nuk are very similar.
They both look alike and neither has any special features. The Nuk is
slightly smaller and can be held very easily in a baby's hand.
The Nuk does comes out slightly ahead, though, because of its
simplicity. Parents have no cause to worry about a dangerous seal, because
the Nuk uses a sealing process in which the edges are all smooth. It is not
difficult to clean, and it looks like it will work.
Every design has a purpose and some goals. The goals, however, may
have different meanings to different people. The design spreadsheet
analyzes each design goal and considers every design specification and
constraint. It produces a score for each goal, exposing the areas of the
design that need more improvement. The spreadsheet is easy to revise and
is a simple method of comparing designs in any stage of the design process.
The evaluations of the four tested teethers were quite accurate. All
the known advantages and disadvantages of each product were exposed in
the design parameter and goal scores. Gerber's Nuk Teether ranked
highest because of its small size and safe appearance. The Cool Ring was
in sceond place with a very small margin between the two teethers. The
Cool Ring's advantage is its play value. However, it may appear
dangerous to some parents because of the small, hard parts that it contains.
The Cooling Teether's (1437) score was just behind the Cool Ring, but it
does not have the play value of the Cool Ring and is slightly larger than the
Nuk. If the sealing process is changed or fixed to remove the sharp edge
that sometimes occurs, it will receive a higher score. The Cooling Teether
with handle (1438) ranked fourth due to the cleaning difficulties caused by
MEOW"
the handle. An improved handle that is easy to clean would increase the
1438 cooling teether's score.
The evaluated teethers all received scores that were not surprising to
the user. However, when a proposed design is entered into the spreadsheet,
there will be no predicted outcome. The results will demonstrate to the
user the strengths and weaknesses of the design.
Appendix A
The Teether Spreadsheet
9.3 9.67 9. 67
E2
c .t [13.
of 1) E4
(o'ut (ot
oft 10)
oo thinci t
9 -35
9c IC) 9? . I ()
Scyiosh cly! i
1.50 1.50
U Sable s a To C 1.50
Hinnd A Hestheti. C
Appea .1 6.77 6) 00
A Ex
rppearace Sat
and Durability 10- 00 9-67 1 C-C)C
Appearance c-f
Ease of C1EEning 10.- 00 9 .0 1 - 0C
Pr i c.e 9 ,, 06 1. 88
DesiQn Parameter Pa.r ameter Parameter Parameter
Parameiters Va l . u e- Val I ues . V,,,a Iue
[1] [33 [43
Ma t er i a( 1 E. 1 0 . 00 10 00 10 . 00 1.
A.3 User Parameters
Uae r. Far ameter Far am e ter Par [Link] Par ame ter
Far amet er VaI LeS 1 f? s
V le Ve 1 AE Val ues
[1] [2] [3] [4]
U -I.
5ound -o 0,00 .0 00
Teether Weicht
User Par ameter Par ame ter Far amet er Parame t er
'.Aa I U ! Va IL V alu es
Par ameter Va 1ues
131
[13
Value ()
0 .0 C)(
0
Gr C oves E F. C - ,(-- -- 10 -) - 1 0(
~~)i)
ClI ean i ng Thoro:iughness
I *OC) 1- 0 --
Materi al Strencgth
C) 20 0 -20 0- 2 L
0 2
Mater ial Permeabi i ty
-?
a3. 6.- -63
"L.
'E hap e 0 -4 45
C) . 50
C.o lor /L..Iuster
1-70
Mater ial /Te. ture -9)? 0 .5
U-0
C)
iFaniLe Sie 0-59
User Parameter Parameter Parameter F'a ra meter
Pa rrameters Values VC, 1 UE'2 Val 1 ues YE41 U ES
[1] [33 J4I
Handle Shape 1. c) (l
0.0 U (-.)
0-0 ):.
Handle Color 0. ?0 i0 .0 i.00
1.* U' I.
P rie J.C -S
Circular c.
Strinot/Cr ds 1* 1.00 it I
ie~ .
~ 1.0- I Ci')
U ser Par ameter Par ameter Parameter par ameter
Parameter s Va l uies Vae S Va l ues V a I ue S
[1] [.2] [33 [4]
1. ) 1 -0C) 1 . 00
A.4 User Values
Notes User User
Va Fu: V a 1 LAfe-Si:
V Lr ue :
[1] Ur
k 3]3 [4]
E~es I , No =0)3
ER ating s:1=worst 10-=b e st]
teether must be at
least 1.25
i.n. The longest side must be
at least 1.96S in.. Enter
l engtrvh of shor test sd i.: 2.50 2.5 2.2
ID 5
lent h of lon ge s:.t Sid e(i.: 2-50 2.0
Process 5:
Enter # of materials required
for each teether. 2. 00 1 .00 1 . 00
Appendix B
Spreadsheet Formulas
S afet y @IF @MIN (HOLES, STRINGS, L IQUIDS, MIN SIZE ,EDGES,( ABUSE
(Requlat icns) TESTS)=0,0, (1/6)*HOLES+( 1/6.)*STRIN3S+( 1/6))*LIQUIDS+
(1/ 6)*MINSIZE+(1/6)*EDGES+(1/6)*ABUSE TESTS)
Soocthing to
Baby 5*CALM+4*COLD+1*HANDLE
Handle Aesthetic
Appeal @IF(T105>O, 10* ( 2/10)*HANDLESHAF'E+ ("5/10)
[Ignore if there is *HsANDLE SIZE+(3/10)*HANDLE COLOR) !Z)
nc hiandle. ] where TI05 is the user value in which
a value of 0 means. there is no handle.
Appearance of Safety
and Durability 10*( (1/3)*SHARFNES:,+(1/3)*FOINTY
+(1/3)*DESTRUCTIB(ILITY)
Appearance of
Eas.e of Cleaning 1 0*CREV I CES
Sound @IF(S27=1I,1,0)
Lifetime 1IF(S69)12,)IFC 9
13-S69,0))
S ize @I F(S44=0,1-0.075*.@ABihS(3.5-S
S87, ) IF(S38*S4*4*848) >:1 .5 ,
ABS (1-0. 1* ( S38*S44*S48)
@IF(S38*S44*sL').92,
(S38*S44*S48) -. 5 , 0))
Shape 0.1*890
Material/Texture 0. 1*S95
Features/Attractic'ns 0.1*898
Graspable 01.I*S126
Ci ILA .r Hol*1eis
@IF(OCS41<20.5 1)
t r i nc,/Ccr d s I F (014412, 0 1)
tAry L. i
DI F S 144'11 2 5 1 ~(8 5
I1.9 58.1. 1 IF S 5 =O A D
User Parameter
Parameters
5159=0,D IF(S162>1.68,1,),
0) )