ser Draw Formulas Data Review View Tell me Times New Roman La IN lile General ' ' A Paste BTU Conditional Formatting E Formats Table Cel Styles 9X Delete $ % ) Formato A36 Xfx Planning Budget C D F Pager Clinic uses client-visits as is measure of activity. During February, the clinic budgeted for 2.000 client visit, but its actual level of activity was 2,200 client viti. The cinemas 2 provided the following data concerning the formulas used in its budgeting and its actual results for February Fixed element per month Variable element per cent visit 70 Data used in budgeting: 5 6 Revenue 7 8 Personel expenses 9 Medical supplies 10 Oeupancy expenses 11 Administrative expenses 32,000 1,200 9,000 5.000 20.5 11.5 2.4 o 13 Actual real for February 15 Revenue $ 156,000 16 Personal expenses $ 75,000 17 Medical supplies 5 30,000 18 Ocewpancy expenses 5 16,000 19 Administrative expenses 4,500 281,500 -125,500 20 21 22 1. Prepare a planning budget and flexible budget, then calculate the activity variances, as well as revenue and spending variances Indicate whether och variance it forle e un forble 23 16 27 29 2. Please explain how you will evaluate the clinic's performance of Feburary using what you go 30 11 32 34 35 ser Draw Formulas Data Review View Tell me Times New Roman La IN lile General ' ' A Paste BTU Conditional Formatting E Formats Table Cel Styles 9X Delete $ % ) Formato A36 Xfx Planning Budget C D F Pager Clinic uses client-visits as is measure of activity. During February, the clinic budgeted for 2.000 client visit, but its actual level of activity was 2,200 client viti. The cinemas 2 provided the following data concerning the formulas used in its budgeting and its actual results for February Fixed element per month Variable element per cent visit 70 Data used in budgeting: 5 6 Revenue 7 8 Personel expenses 9 Medical supplies 10 Oeupancy expenses 11 Administrative expenses 32,000 1,200 9,000 5.000 20.5 11.5 2.4 o 13 Actual real for February 15 Revenue $ 156,000 16 Personal expenses $ 75,000 17 Medical supplies 5 30,000 18 Ocewpancy expenses 5 16,000 19 Administrative expenses 4,500 281,500 -125,500 20 21 22 1. Prepare a planning budget and flexible budget, then calculate the activity variances, as well as revenue and spending variances Indicate whether och variance it forle e un forble 23 16 27 29 2. Please explain how you will evaluate the clinic's performance of Feburary using what you go 30 11 32 34 35