An air-conditioning repair department manager has compiled data on the primary reason for 41 service calls for the previous week as shown in the table. The coding system was to record the Type of Issue/Type of Customer. For example, F/R would be Equipment failure/Residential customer.

Using the data, make a check sheet for the problem types for each customer type, and then construct a Pareto diagram for each type of customer. You can use Excel to construct your check sheet and Pareto chart.

Once you complete this, what conclusions do you draw? What would you focus on?

Job Number	Problem	Job Number	Problem	Job Number	Problem
301	F/R	315	F/C	329	O/C
302	O/R	316	O/C	330	N/R
303	N/C	317	W/C	331	N/R
304	N/R	318	N/R	332	W/R
305	W/C	319	O/C	333	O/R
306	N/R	320	F/R	334	O/C
307	F/R	321	F/R	335	N/R
308	N/C	322	O/R	336	W/R
309	W/R	323	F/R	337	O/C
310	N/R	324	N/C	338	O/R
311	N/R	325	F/R	339	F/R
312	F/C	326	O/R	340	N/R
313	N/R	327	W/C	341	O/C
314	W/C	328	O/C

Problems Key:

N = Noisy

F = Equipment failure

W = Runs warm

O = Odor

Customer Key:

C = Commercial

R = Residential