Overview
Respond to the exam questions using a spreadsheet. All questions must be answered in a single spreadsheet using separate appropriately named worksheets for each problem.
1. The monthly ambulatory visits shown in the table below occurred in an outpatient clinic.
Table for Problem 1 | |
Months | Visits |
July | 2,160 |
August | 2,186 |
September | 2,246 |
October | 2,251 |
November | 2,243 |
December | 2,162 |
Predict visits for January using the naïve forecast method.
Predict visits for January using a three-period moving average.
Predict visits for January using a four-period moving average.
2. Data from the outpatient mammography operations in a healthcare facility were shown in the table below.
Table for problem 4 | ||||
Measurement | Year 1 | Year 2 | Year 3 | Year 4 |
Price ($) | 140 | 145 | 147 | 150 |
Volume | 16,387 | 19,336 | 18,555 | 17,557 |
Labor ($) | 275,000 | 307,000 | 318,000 | 325,000 |
Materials ($) | 6,750 | 7,250 | 7,100 | 7,000 |
Overhead ($) | 24,500 | 26,700 | 28,600 | 28,000 |
What are the multi-factor productivity ratios for these years?
What can you conclude about the productivity trend for mammography operations?
3. A regional laboratory that performs nontraditional tests is planning to offer new diagnostic tests for regional hospitals. Current analyzers and staff are capable of performing these tests. The laboratory manager assessed the required staff and analyzer times, as well as the chemical materials required for a bundle of 50 vials for each type of test listed in the table below.
Table for Problem 5 | ||||||
Test Type | I | II | III | IV | V | Available Resources |
Profit ($) | 8 | 20 | 8 | 7 | 10 | |
Staff (minutes) | 15 | 15 | 15 | 20 | 25 | 3,400 |
Auto analyzer equipment (minutes) | 20 | 40 | 40 | 60 | 45 | 6,000 |
Materials | 12 | 15 | 16 | 14 | 14 | 2,700 |
A. Formulate this as a linear programming problem.
B. Solve the problem using an Excel solver.
C. For the optimal solution, in terms of profit, which test(s) should be offered?
D. What is the optimal volume(s)?
E. What is the total expected profit from the new tests?
F. Which resources should be expanded?
4. A medical center routinely conducts a patient satisfaction survey upon discharge. The discharge survey, conducted on samples of two hundred discharges per month and the patients dissatisfied with their care, is shown in the table below.
Dissatisfied Patients | Jan | Feb | Mar | Apr | May | Jun |
At discharge | 4 | 2 | 5 | 8 | 6 | 5 |
A. Determine the fraction of dissatisfied patients at discharge for each month.
B. Estimate the mean and standard deviation of the sampling distribution of dissatisfied patients at discharge.
C. For the survey, determine the control limits for 95 percent confidence limits.
D. For the survey, construct appropriate control charts and identify any observations that are not within the control limits.
5. A small town with one hospital has two ambulances to supply ambulance service. Requests for ambulances during non-holiday weekends average 0.45 per hour and tend to be Poisson-distributed. Travel and assistance time averages two hours per call and follows an exponential distribution. Find:
A. System utilization.
B. The average number of customers waiting.
C. The average time customers wait for an ambulance.
D. The probability that both ambulances will be busy when a call comes in.
.