Please use the excel spread sheet for your answers.
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 the excel table.
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 exam 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?
Again use only the excel spread sheet below for answers.
For given data, observed, normal and standard times are estimated.
Quantitative methods in healthcare management
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 11.1 and 11.6 on pages 285 and 288 in Quantitative Methods in Health Care Management. Use this template for your calculations and answers:
• Excel template for Exercises 11.1 and 11.6
Note on using the Excel templates: Use the automated Excel tables in Sheets 1 and 3 to perform calculations, and Sheets 2 and 4 to record your answers. For an explanation of the automated Excel tables, refer to Quantitative Methods, pp. 281-284. Save the template to your desktop before using. Make sure macros are enabled.
Any existing numbers in green cells in the automated tables are for examples, and show where you should enter the data. You must delete or overwrite these numbers to perform the calculations. The yellow cells of templates are protected to prevent users from accidentally deleting or overwriting the formulas. There is no need to unprotect the templates.