Question

Laizure Clinic uses patient-visits as its measure of activity. The clinic bases its budgets on the following information: Revenue should be $69.90 per patient-visit. Personnel expenses should be $37,100 per month plus $17.20 per patient-visit. Medical supplies should be $3,400 per month plus $12.60 per patient-visit. Occupancy expenses should be $9,800 per month plus $9.00 per patient-visit. Administrative expenses should be $5,300 per month plus $7.10 per patient-visit. The clinic reported the following actual results for November: Patient-visits Revenue Personnel expenses Medical supplies Occupancy expenses Administrative expenses 2,940 $234, 240 $ 96,320 $ 45,840 $ 24,950 $ 15,350 Required: Prepare a report showing the clinic's revenue and spending variances for November. Label each variance as favorable (F) or unfavorable (U). (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.)
Laizure Clinic uses patient-visits as its measure of activity. The clinic bases its budgets on the following information: Revenue should be $69.90 per patient-visit. Personnel expenses should be $37,100 per month plus $17.20 per patient-visit. Medical supplies should be $3,400 per month plus $12.60 per patient-visit. Occupancy expenses should be $9,800 per month plus $9.00 per patient-visit. Administrative expenses should be $5,300 per month plus $7.10 per patient-visit. The clinic reported the following actual results for November: Patient-visits 2,940 Revenue $ 234,240 Personnel expenses $ 96,320 Medical supplies $ 45,840 Occupancy expenses $ 24,950 Administrative expenses $ 15,350 Required: Prepare a report showing the clinic's revenue and spending variances for November. Label each variance as favorable (F) or unfavorable (U). (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.)

Answer 1

Laizure Clinic Revenue and Spending Variances For The Month Ended November 30
	Actual results	Flexible budget	Revenue and Spending variances
Patient visits	2,940	2,940
Revenue	$234,240	$205,506 (2,940*$69.90)	$28,734	F
Expenses
Personnel expenses	96,320	87,668 (37,100+2,940*$17.20)	8,652	U
Medical supplies	45,840	40,444 (3,400+2,940*$12.60)	5,396	U
Occupancy expenses	24,950	36,260 (9,800+2,940*$9)	11,310	F
Administrative expenses	15,350	26,174 (5,300+2,940*$7.10)	10,824	F
Total expense	182,460	190,546	8,086	F
Net operating income	$51,780	$14,960	$36,820	F