Use the Excel template to solve problem 9.1 from chapter 9 on page 232 of the OZCAN textbook.

Problem:

9.1) The chief at the ultrasound division of the radiology department in a community hospital would like to measure the multi-factor productivity for a complete abdomen procedure. The last three years of data were accumulated, as shown in Table EX 9.1.

TABLE EX 9.1 Measurement Year 1 Year 2 Year 3 Price ( $ ) 880 883 886 Volume 5,583 6,312 6,129 Labor ( $ ) 75,000 77,000 80,000 Materials ( $ ) 2,750 2,900 3,100 Overhead ( $ ) 6,500 6,700 7,000

a. What are the multi-factor productivity ratios for these years? b. What can you conclude about the productivity trend for this procedure?