The diagnostic department at Saints Memorial Hospital provides medical tests and evaluations for patients, ranging from analyzing blood samples to performing magnetic resonance imaging (MRI). Average cost to patients is $60 per patient. Labor costs average $15 per patient, materials costs are $20 per patient, and overhead costs are averaged at $20 per patient.You must show all calculations and explain your answer in detail.

1. A.Whatisthemultifactorproductivityratioforthediagnosticdepartment?Whatdoesthismean?
2. B.Iftheaveragelabworkerspendsthreehoursforeachpatient,whatisthelaborproductivityratio?Whatdoesthisfindingmeans?

• Use Excel spreadsheet to complete this assignment.
• You must show all calculations and explain your answer in detail.