Exercises 6.2 and 6.5

Listed below is the following instructions for this assignment:
Exercises: 6.2 and 6.5

The following exercises are required and cover topics in this week's required reading. Review the instructions carefully before completing and submitting the exercises.

Complete Exercises 6.2 and 6.5 on pages 156 and 158 in Quantitative Methods in Health Care Management. Use the Excel document below to record your answers. Save the template to your desktop before using.

Excel template for Exercises 6.2 and 6.5. The excel template is attached to this post. Also, here are the questions for Exercises 6.2 and 6.5. 

Exercise 6.2
Pre- and post-examination processing of patients in an outpatient clinic involves various tasks performed by clerks and nurses. A time study conducted by the decision support department is shown in Table Ex 6.2.
a. Determine the observed time for the pre-post exam process.
b. Determine the normal time for the pre-post exam process.
c. Determine the standard time for the pre-post process, using the basic moderate allowance for the job.
d. Calculate the standard time for the exam process. Do you think the time spent in the outpatient clinic, without including the exam time, is reasonable? If not, what improvements would you recommend?
Exercise 6.5
An initial work sampling survey to estimate the percentage of time that MRI equipment is idle between 8:00A.M. and 8:00P.M., found that the MRI was idle 9 of the 120 observations.
a. Determine the percentage of idle time.
b. From the results, approximately how many observations would it require to estimate the actual percentage of idle time to within 4 percent, with confidence of 95 percent?

Moreover, if you need the ISBN number, it is:978-1-118-63728-9, the book is titled Quantitative Methods Health Care Management. (2nd ed.). Author: Yasar A. Ozcan