What's going on in that lab?" asked Derek Warren, chief administrator for Cottonwood Hospital, as he studied the prior month's reports. "Every month the lab teeters between a profit and a loss. Are we going to have to increase our lab fees again?"
"We can't," replied Lois Ankers, the controller. "We're getting lots of complaints about the last increase, particularly from the insurance companies and governmental health units. They're now paying only about 80% of what we bill. I'm beginning to think the problem is on the cost side."
To determine if lab costs are in line with other hospitals, Mr. Warren has asked you to evaluate the costs for the past month. Ms. Ankers has provided you with the following information:
a.Two basic types of tests are performed in the lab-smears and blood tests. During the past month, 4,200 smears and 1,400 blood tests were performed in the lab.
b.Small glass plates are used in both types of tests. During the past month, the hospital purchased 21,000 plates at a cost of $71,820. This cost is net of a 5% purchase discount. A total of 3,200 of these plates were unused at the end of the month; no plates were on hand at the beginning of the month.
c.During the past month, 3,200 hours of labor time were used in performing smears and blood tests. The cost of this labor time was $36,480.
d.The lab's variable overhead cost last month totaled $28,160.
Cottonwood Hospital has never used standard costs. By searching industry literature, however, you have determined the following nationwide averages for hospital labs:
Plates:Three plates are required per lab test. These plates cost $3.60 each and are disposed of after the test is completed.
Labor:Each smear should require 0.40 hours to complete, and each blood test should require 0.80 hours to complete. The average cost of this lab time is $12.40 per hour.
Overhead:Overhead cost is based on direct labor-hours. The average rate of variable overhead is $8.30 per hour.
Required:
1.Compute the materials price variance for the plates purchased last month, and compute a materials quantity variance for the plates used last month. (Input all amounts as positive values. Leave no cells blank - be certain to enter "0" wherever required. Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance.)
Materials price variance$
Materials quantity variance$
2.For labor cost in the lab:
a.Compute a labor rate variance and a labor efficiency variance. (Input all amounts as positive values. Leave no cells blank - be certain to enter "0" wherever required. Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance.)
Labor rate variance$
Labor efficiency variance$
b.In most hospitals, three-fourths of the workers in the lab are certified technicians and one-fourth are assistants. In an effort to reduce costs, Cottonwood Hospital employs only one-half certified technicians and one-half assistants. Would you recommend that this policy be continued?
3a.Compute the variable overhead rate and efficiency variances. (Input all amounts as positive values. Leave no cells blank - be certain to enter "0" wherever required. Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance.)
Variable overhead rate variance$
Variable overhead efficiency variance$
3b.Is there any relation between the variable overhead efficiency variance and the labor efficiency variance?