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 O/C 315 W/R 329 N/C 302 N/C 316 F/R 330 O/R 303 F/R 317 F/R 331 N/R 304 O/R 318 N/R 332 W/C 305 F/R 319 F/R 333 W/C 306 N/R 320 N/R 334 N/R 307 N/C 321 O/C 335 F/C 308 O/R 322 W/C 336 W/C 309 N/R 323 F/R 337 F/C 310 N/C 324 O/C 338 N/R 311 O/C 325 W/C 339 N/R 312 O/R 326 N/C 340 N/C 313 N/R 327 O/R 341 N/R 314 O/R 328 N/R Key: Problem type: Customer type: N = Noisy C = Commercial customer F = Equipment failure R = Residential customer W = Runs warm O = Odor Problem 9-2 Part a a. Using the data, prepare a check sheet for the problem types for each customer type. (1) Residential customer type Residential Noisy Failed Odor Warm Totals (2) Commercial customer type Commercial Odor Failed Noisy Warm Totals

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Required information

Problem 9-2

[The following information applies to the questions displayed below.]

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	O/C	315	W/R	329	N/C
302	N/C	316	F/R	330	O/R
303	F/R	317	F/R	331	N/R
304	O/R	318	N/R	332	W/C
305	F/R	319	F/R	333	W/C
306	N/R	320	N/R	334	N/R
307	N/C	321	O/C	335	F/C
308	O/R	322	W/C	336	W/C
309	N/R	323	F/R	337	F/C
310	N/C	324	O/C	338	N/R
311	O/C	325	W/C	339	N/R
312	O/R	326	N/C	340	N/C
313	N/R	327	O/R	341	N/R
314	O/R	328	N/R

Key:	Problem type:	Customer type:
	N	= Noisy	C	= Commercial customer
	F	= Equipment failure	R	= Residential customer
	W	= Runs warm
	O	= Odor

Problem 9-2 Part a

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

(1)	Residential customer type

	Residential
Noisy
Failed
Odor
Warm

Totals

(2)	Commercial customer type

	Commercial
Odor
Failed
Noisy
Warm

Totals

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 2 images

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.

Similar questions