Question: Please answer question # 2 . Please answer using Excel and kindly show all the work on how you got the answer. I much appreciate

Please answer question #2. Please answer using Excel and kindly show all the work on how you got the answer. I much appreciate your help.
An air conditioning company had their repair manager compile data on the primary reason for 41 service calls for the previous week. The table below shows the results.
Job No. Problem Job No. Problem Job No. Problem 301 Equipment Failure 315 Equipment Failure 329 Odor 302 Odor 316 Odor 330 Noisy 303 Noisy 317 Runs Warm 331 Noisy 304 Noisy 318 Noisy 332 Runs Warm 305 Runs Warm 319 Odor 333 Odor 306 Noisy 320 Equipment Failure 334 Odor 307 Equipment Failure 321 Equipment Failure 335 Noisy 308 Noisy 322 Odor 336 Runs Warm 309 Runs Warm 323 Equipment Failure 337 Odor 310 Noisy 324 Noisy 338 Odor 311 Noisy 325 Equipment Failure 339 Equipment Failure 312 Equipment Failure 326 Odor 340 Noisy 313 Noisy 327 Runs Warm 341 Odor 314 Runs Warm 328 Odor 342 Runs Warm
Question 2
Make a Fishbone diagram reflecting possible causes affecting the highest incidence repair/defect captured on the data above. When doing so, at a minimum, cite causes that reflect the 4 Ms of operations management.
Please answer question # 2 . Please answer using

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!