AirQual Test Corporation provides on-site air quality testing services. The company has provided the following cost formulas and actual results for the month of February: Fixed Variable Component Component per Actual Total per Month Job for February Revenue $ 275 $ 30, 250 Technician wages $ 8, 206 $ 8,050 ile lab operating expenses $ 4,500 $ 31 $ 8,060 Office expenses $ 2,506 $ 2,716 Advertising expenses $ 1, 586 $ 1, 650 Insurance 2,890 $ 2 2,890 Miscellaneous expenses $ 960 $ 2 $ 505 The company uses the number of jobs as its measure of activity. For example, mobile lab operating expenses should be $4,500 plus $31 per job, and the actual mobile lab operating expenses for February were $8,060. The company expected to work 120 jobs in February, but actually worked 124 jobs. Required: Prepare a flexible budget performance report showing AirQual Test Corporation's revenue and spending variances and activity variances for February. (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.) AirQual Test Corporation Flexible Budget Performance Report For the Month Ended February 28 Actual Flexible Planning Results Budget Budget Jobs 124 Revenue $ 30,250 Expenses: Technician wages 8,050 Mobile lab operating expenses 8,060 Office expenses 2,710 Advertising expenses 1,650 Insurance 2,890 Miscellaneous expenses 505 Total expense 23,865John Fleming, chief administrator for Valley View Hospital, is concerned about the costs for tests in the hospital's lab. Charges for lab tests are consistently higher at Valley View than at other hospitals and have resulted in many complaints. Also, because of strict regulations on amounts reimbursed for lab tests, payments received from insurance companies and governmental units have not been high enough to cover lab costs. Mr. Fleming has asked you to evaluate costs in the hospital's lab for the past month. The following information is available: a. Two types oftests are performed in the labblood tests and smears. During the past month, 1,050 blood tests and 3,500 smears were performed in the lab. b. Small glass plates are used in both types of tests. During the past month,the hospital purchased 17,500 plates at a cost of $58,800. 2,500 of these plates were unused at the end ofthe month; no plates were on hand at the beginning of the month. c. During the past month, 2,500 hours oflabortime were recorded in the lab at a cost of$2?,625. d. The lab's variable overhead cost last month totaled $20,250. Valley View 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.50 each and are disposed of after the test is completed. Labor: Each blood test should require 0.6 hours to complete, and each smear should require 0.30 hours to complete. The average cost of this lab time is $11.70 per hour. Overhead: Overhead cost is based on direct laborhours. The average rate for variable overhead is $7.60 per hour. Required: 1. Compute a materials price variance for the plates purchased last month and a materials quantity variance for the plates used last month. 2. For labor cost in the lab: a. Compute a labor rate variance and a labor efciency variance. b. In most hospitals, onehalf of the workers in the lab are senior technicians and onehalf are assistants. In an effort to reduce costs, Valley View Hospital employs only onefourth senior technicians and threefourths assistants. Would you recommend that this policy be continued? 3a. Compute the variable overhead rate and efficiency variances. 3b. Is there any relation between the variable overhead efficiency variance and the labor efficiency variance? Complete this question by entering your answers in the tabs below. Reg 1 Req 2A R131: 23 REC] 3A Req BB 2,:>UU or these plates were unused at the end 0T Ine montn; no plates were on nano at the beginning 0T tne montn. c. During the past month, 2,500 hours of labor time were recorded in the lab at a cost of $27,625. d. The lab's variable overhead cost last month totaled $20,250. Valley View 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.50 each and are disposed of after the test is completed. Labor: Each blood test should require 0.6 hours to complete, and each smear should require 0.30 hours to complete. The average cost ofthis lab time is $11.70 per hour. Overhead: Overhead cost is based on direct laborhours. The average rate for variable overhead is $7.60 per hour. Required: 1. Compute a materials price variance for the plates purchased last month and a materials quantity variance for the plates used last month. 2. For labor cost in the lab: a. Compute a labor rate variance and a labor efciency variance. b. In most hospitals, onehalf of the workers in the lab are senior technicians and onehalfare assistants. In an effort to reduce costs, Valley View Hospital employs only onefourth senior technicians and threefourths assistants. Would you recommend that this policy be continued? 3a. Compute the variable overhead rate and efficiency variances. 3b. Is there any relation between the variable overhead efficiency variance and the labor efficiency variance? Complete this question by entering your answers in the tabs below. Red 1 Req 2A Req ZB Req 3A Req BB Compute a materials price variance for the plates purchased last month and a materials quantity variance for the plates used last month. (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect I{i.e.r zero variance]. Input all amounts as positive values.) Materials price variance Materials quantity variance RquA > ADUU or Inese plates were unuseo at me eno oTIne montn; no plates were on nano at me beginning or me montn. c. During the past month, 2,500 hours oflabor time were recorded in the lab at a cost of$27,625. d. The lab's variable overhead cost last month totaled $20,250. Valley View 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.50 each and are disposed of after the test is completed. Laboc'Each blood test should require 0.6 hours to complete, and each smearshould require 0.30 hours to complete. The average cost ofthis lab time is $11.70 per hour. Overhead: Overhead cost is based on direct laborhours. The average rate for variable overhead is $7.60 per hour. Required: 1. Compute a materials price variance for the plates purchased last month and a materials quantity variance for the plates used last month. 2. For labor cost in the lab: a. Compute a labor rate variance and a labor efciency variance. b. In most hospitals, onehalf of the workers in the lab are senior technicians and onehalf are assistants. In an effort to reduce costs, Valley View Hospital employs only onefourth senior technicians and threefourths assistants. Would you recommend that this policy be continued? 3a. Compute the variable overhead rate and efficiency variances. 3b. Is there any relation between the variable overhead efficiency variance and the labor efficiency variance? Complete this question by entering your answers in the tabs heluw. Reg 1 Reg ZA Req 23 Req 3A Req 33 For labor cost in the lab, Compute a labor rate variance and a labor efficiency variance. (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance}. Input all amounts as positive values.) Labor rate variance Labor efciency variance Apou or tnese plates were unused at tne eno oTIne montn; no plates were on nano at me beginning oT Ine montn. c. During the past month, 2,500 hours oflabortime were recorded in the lab at a cost of $27,625. d. The lab's variable overhead cost last month totaled $20,250. Valley Viewr Hospital has never used standard costs. By searching industry literature, however, you have determined the following nationwide averages for hospital labs: PlatesrThree plates are required per lab test. These plates cost $3.50 each and are disposed of after the test is completed. taboc'Each blood test should require 0.6 hours to complete, and each smear should require 0.30 hours to complete. The average cost of this lab time is $11.70 per hour. Overhead: Overhead cost is based on direct laborhours. The average rate for variable overhead is $7.60 per hour. Required: 1. Compute a materials price variance for the plates purchased last month and a materials quantity variance for the plates used last month. 2. For labor cost in the lab: a. Compute a labor rate variance and a labor efciency variance. b. In most hospitals, onehalf ofthe workers in the lab are senior technicians and onehalfare assistants. In an effort to reduce costs, Valley Viewr Hospital employs only onefourth senior technicians and threefourths assistants. Would you recommend that this policy be continued? 3a. Compute the variable overhead rate and efficiency variances. 3b. Is there any relation between the variable overhead efficiency variance and the labor efficiency variance? Complete this question by entering your answers in the tabs below. Req 1 Req 2A Req 23 Ron 3A Req 33 In most hospitals, onehalf of the workers in the lab are senior technicians and onehalf are assistants. In an effort to reduce costs, Valley View Hospital employs only one-fourth senior technicians and three-fourths assistants. Would you recommend that this policy he continued? 2,500 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, 2,500 hours of labor time were recorded in the lab at a cost of $27,625. d. The lab's variable overhead cost last month totaled $20,250. Valley View 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.50 each and are disposed of after the test is completed. Labor: Each blood test should require 0.6 hours to complete, and each smear should require 0.30 hours to complete. The average cost of this lab time is $11.70 per hour. Overhead: Overhead cost is based on direct labor-hours. The average rate for variable overhead is $7.60 per hour. Required: 1. Compute a materials price variance for the plates purchased last month and a materials quantity variance for the plates used last month. 2. For labor cost in the lab: a. Compute a labor rate variance and a labor efficiency variance. b. In most hospitals, one-half of the workers in the lab are senior technicians and one-half are assistants. In an effort to reduce costs, Valley View Hospital employs only one-fourth senior technicians and three-fourths assistants. Would you recommend that this policy be continued? 3-a. Compute the variable overhead rate and efficiency variances. 3-b. Is there any relation between the variable overhead efficiency variance and the labor efficiency variance? Complete this question by entering your answers in the tabs below. Req 1 Req 2A Req 2B Req 3A Req 3B Compute the variable overhead rate and efficiency variances. (Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Input all amounts as positive values.) Variable overhead rate variance Variable overhead efficiency variance spuu or these plates were unuseo at me eno oTIne montn; no plates were on nano at the beginning or me montn. c. During the past month, 2,500 hours of labor time were recorded in the lab at a cost of$2?,625. d. The lab's variable overhead cost last month totaled $20,250. Valley View 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.50 each and are disposed of after the test is completed. Labor: Each blood test should require 0.6 hours to complete, and each smearshould require 0.30 hours to complete. The average cost of this lab time is $11.70 per hour. Overhead: Overhead cost is based on direct laborhours. The average rate for variable overhead is $7.60 per hour. Required: 1. Compute a materials price variance for the plates purchased last month and a materials quantity variance for the plates used last month. 2. For labor cost in the lab: a. Compute a labor rate variance and a labor efciency variance. b. In most hospitals, onehalf of the workers in the lab are senior technicians and onehalf are assistants. In an effort to reduce costs, Valley View Hospital employs only onefourth senior technicians and threefourths assistants. Would you recommend thatthis policy be continued? 3a. Compute the variable overhead rate and efficiency variances. 3b. Is there any relation between the variable overhead efficiency variance and the labor efficiency variance? Complete this question by entering your answers in the tabs below. Ron 1 RBI] 2A RBI] ZB RBI] 3A Is there any relation between the variable overhead efficiency variance and the labor efciency variance? OYes ONo