Ticket No. 1 2 3 4 5 6 7 8 9 10 Work Tires Tires Brakes Lube & Oil Tires Lube & Oil Lube & Oil Brakes Transmission Brakes Ticket No. 11 12 13 14 15 16 17 18 19 20 Work Brakes Tires Tires Tires Battery Brakes Lube & Oil Lube & Oil Lube & oll Battery Ticket No. 21 22 23 24 25 26 27 28 29 Work Lube & oll Lube & Oil Tires Lube & Oil Battery Lube & 011 Lube & 011 Transmission Tires Lube & oll 30 Prepare a check sheet for the above car repair shop data Frequency Work Type Lube & oil Tires Brakes Battery Transmission Total [The following information applies to the questions displayed below. An alr-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 301 302 303 304 305 306 307 308 309 310 311 312 313 314 Problem/ Customer Type F/C W/R W/C N/R N/R W/C O/C N/R W/R W/R O/R O/C N/R W/R Job Number 315 316 317 318 319 320 321 322 323 324 325 326 327 328 Problem/ Customer Type F/R N/C O/R N/C O/C N/R O/R N/R O/R O/R F/R W/C N/R O/R Job Number 329 330 331 332 333 334 335 336 337 338 339 340 341 Problem/ Customer Type O/C O/C W/R W/C N/R N/R F/R W/C N/R O/C O/R O/R O/R Key: Problem type: N = Noisy F = Equipment failure W= Runs warm O = Odor Customer type: C = Commercial customer R = Residential customer Using the data, prepare a check sheet for the problem types for each customer type. (1) Residential customer type Residential Noisy Odor Warm Failed Totals (2) Commercial customer type Commercial Noisy Failed Odor Warm Totals