A clinic uses patient-visits as its measure of activity. During July, the clinic budgeted for 2,700 patient-visits, but its actual level of activity was 3,200 patient-visits. The clinic uses the following revenue and cost formulas in its budgeting, where q is the number of patient-visits:

Revenue: $49.60q

Personnel expenses: $31,200 + $15.10q

Medical supplies: $700 + $9.60q

Occupancy expenses: $10,000 + $2.00q

Administrative expenses: $7,000 + $0.20q

The clinic reported the following actual results for July:

Revenue	$165,680
Personnel expenses	$76,190
Medical supplies	$31,790
Occupancy expenses	$15,960
Administrative expenses	$7,600

Required: Prepare a flexible budget performance report showing the clinic's planning budget, flexible budget and relevant variances for July. Label each variance as favorable (F) or unfavorable (U). The illustration posted here might help with this exercise.

	Planning Budget	Volume Variance	Flexible Budget	Flexible Budget Variance	Actual Results
Revenue