T 125% View Zoom Add Category Insert Table Chart Taxt Shape Media Comment Collaborate Format Organize + Instructions 9 10 11 12 Sheet Sheet Name Fager Clinic uses client-visits as its measure of activity. During February, the clinic hudgeted for 2,000 client-visits, hul ils actual level of activity was 2,200 client-visits. The clinic has provided the following data concerning the formulas used in its budgeting and its actual results for February: 9 Duta used in budgeting: Fixed element per month Variable clement per client-visit S 70 Revenue Background S Personnel expenses Medical supplies Occupancy expenses Administrative expenses 32,000 1,200 9,000 5,000 20.5 11.5 2.4 0 Duplicate Sheet Delete Sheet Actual results for February: Revenue Personnel expenses Medical supplies Occupancy expenses Administrative expenses $ S $ S S 156,000 75,000 30,000 16,000 4,500 1. Prepare a planning buclget and a flexible hudget, then calculate the activity variances, its well as revenue and spending variances. Incacale whether each variance is favorable or unla 2. Please explain how you will evaluate the clinic's performance of Feburary using what you got ar #I