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.

Job

Number Problem$/$

Customer Type Job

Number Problem$/$

Customer Type Job

Number Problem$/$

Customer Type

$301$ F$/$C $315$ F$/$R $329$ O$/$C

$302$ W$/$R $316$ N$/$C $330$ O$/$C

$303$ W$/$C $317$ O$/$R $331$ W$/$R

$304$ N$/$R $318$ N$/$C $332$ W$/$C

$305$ N$/$R $319$ O$/$C $333$ N$/$R

$306$ W$/$C $320$ N$/$R $334$ N$/$R

$307$ O$/$C $321$ O$/$R $335$ F$/$R

$308$ N$/$R $322$ N$/$R $336$ W$/$C

$309$ W$/$R $323$ O$/$R $337$ N$/$R

$310$ W$/$R $324$ O$/$R $338$ O$/$C

$311$ O$/$R $325$ F$/$R $339$ O$/$R

$312$ O$/$C $326$ W$/$C $340$ O$/$R

$313$ N$/$R $327$ N$/$R $341$ O$/$R

$314$ W$/$R $328$ O$/$R

Click here for the Excel Data File

Key: Problem type: Customer type:

N $=$ Noisy C $=$ Commercial customer

F $=$ Equipment failure R $=$ Residential customer

W $=$ Runs warm

O $=$ Using the data, prepare a check sheet for the problem types for each customer type.

$(1)$ Residential customer type

Odour

Noisy

Failed

Warm

Totals

$(2)$ Commercial customer type Odor

Noisy

Failed

Odor

Warm

Totals