QFD - Google Sheets

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1
2
3
4
5
6
7
8
9
10
11									2
12										2
13										1	2
14										1	1	2
15										1			2
16									2	1		2		2
17
18								Voice of the supplier	Electric Motor	Impellor	Agitator	Air filtration	Dust collection	Attachments	Structure	Current products	Competition A	Competition B
19
20	Voice of the customer	Needs	Hows	Requirements		Daily user value	Monthly user value
21				Removes dust particles		10	30		0	9	9	3	9	9	0	3	2	4
22				Removes large debris		5	10		0	9	9	0	9	9	0	2	2	5
23				Lower mass		15	10		3	0	3	0	3	9	9	4	4	2
24				Quiet		20	10		9	9	9	0	3	3	3	4	2	2
25				Uses fewer bags and filters		15	5		0	0	0	9	9	0	0	2	5	2
26				Less time changing bag/filters		10	5		0	0	0	9	3	0	9	4	5	2
27				A long life before failure		15	10		3	3	9	0	0	3	9	4	4	2
28				Self contained in a small volume		10	20		0	0	9	0	9	9	9	3	3	2
29
30
31					Daily user value				270	360	585	255	495	465	510
32					Monthly user value				150	480	750	180	660	690	435
33					Average				210	420	667.5	217.5	577.5	577.5	472.5
34
35					Our product				60	93	156	63	126	132	147
36					Competitor A				42	66	129	96	141	117	150
37					Competitor B				30	105	141	48	135	129	78
38					Competitive position				-18	12	-15	33	15	-3	3
39
40					Design Difficulty				3	2	2	4	4	4	2
41					Manufacturing Difficulty				2	4	3	4	4	4	2
42					Lowest				2	2	2	4	4	4	2
43
44					Deployment score				-7560	10080	-20025	28710	34650	-6930	2835
45
46					Rank					4		2	1		3
47
48
49
50
51
52
53	Legend
54
55		Correlation	N	None	0
56			W	Weak	1
57			M	Moderate	3
58			S	Strong	9
59
60		Competitor	0	None	0
61			1	Very Poor	1
62			2	Poor	2
63			3	Satisfactory	3
64			4	Good	4
65			5	Great	5
66
67
68