Question

In: Accounting

Filkins Clinic bases its budgets on the activity measure patient-visits. During February, the clinic planned for...

Filkins Clinic bases its budgets on the activity measure patient-visits. During February, the clinic planned for 5,300 patient-visits, but the actual level of activity was 5,500 patient-visits. The clinic has provided the following data concerning the formulas it uses in its budgeting:

Fixed element
per month
Variable element
per patient-visit
  Revenue $ 33.50          
  Personnel expenses $ 32,800         $ 10.90          
  Medical Supplies $ 2,800         $ 6.90          
  Occupancy expenses $ 7,800         $ 2.90          
  Administrative expenses $ 6,800         $ 0.29          

Required:

Complete the report showing the clinic's activity variances for February. (Input all amounts as positive values. Leave no cells blank - be certain to enter "0" wherever required. Indicate the effect of each variance by selecting "F" for favorable, "U" for unfavorable, and "None" for no effect (i.e., zero variance). Omit the "$" sign in your response.)

Filkins Clinic
Activity Variances
For the Month Ended February 28
  Revenue $        (Click to select)  None  F  U   
  Expenses:
       Personnel expenses        (Click to select)  F  U  None    
       Medical Supplies        (Click to select)  U  F  None   
       Occupancy expenses        (Click to select)  U  None  F   
       Administrative expenses        (Click to select)  U  F  None   
  Total expense        (Click to select)  None  F  U   
  Net operating income $        (Click to select)  U  None  F   

Solutions

Expert Solution


Related Solutions

Kaylar Clinic uses patient-visits as its measure of activity. During September, the clinic budgeted for 3,000...
Kaylar Clinic uses patient-visits as its measure of activity. During September, the clinic budgeted for 3,000 patient-visits, but its actual level of activity was 2,900 patient-visits. The clinic has provided the following data concerning the formulas used in its budgeting and its actual results for September: Data used in budgeting:                                                  Fixed Element per Month Variable Element per Month Revenue …………………….. $0 $37.20 Personal Expenses…………. $27600 $11.30 Medical Expenses………….. $1500 $6.80 Occupancy Expenses…….... $6200 $1.70 Administrative Expenses…... $3600 $0.30 Actual results...
Panda Clinic uses client-visits as its measure of activity. During October, the clinic budgeted for 4,300...
Panda Clinic uses client-visits as its measure of activity. During October, the clinic budgeted for 4,300 client-visits, but its actual level of activity was 4,290 client-visits. The clinic has provided the following data concerning the formulas used in its budgeting and its actual results for October: Data used in budgeting: Fixed element per month Variable element per client-visit Revenue - $ 37.40 Personnel expenses $ 31,500 $ 12.40 Medical supplies 2,200 7.80 Occupancy expenses 9,600 3.90 Administrative expenses 7,900 0.40...
Bartosiewicz Clinic uses client-visits as its measure of activity. During January, the clinic budgeted for 4,500...
Bartosiewicz Clinic uses client-visits as its measure of activity. During January, the clinic budgeted for 4,500 client-visits, but its actual level of activity was 4,480 client-visits. The clinic has provided the following data concerning the formulas used in its budgeting and its actual results for January: Data used in budgeting: Fixed element per month Variable element per client-visit Revenue - $ 36.50 Personnel expenses $ 28,500 $ 12.50 Medical supplies 1,400 6.50 Occupancy expenses 10,400 1.00 Administrative expenses 7,500 0.10...
Askland Clinic uses client-visits as its measure of activity. During October, the clinic budgeted for 3,100...
Askland Clinic uses client-visits as its measure of activity. During October, the clinic budgeted for 3,100 client-visits, buts its actual level of activity was 3,130 client-visits.  The clinic has provided the following data concerning the formulas used in its budgeting and its actual results for October: Data used in budgeting:                                                                                                 Fixed                            Variable                                                                                            amount per                         amount per                                                                                                 month                          client-visit Revenue ……………………………………………………                               -                                   $28.80 Personnel expenses ………………………………….                                $22,100                        $ 8.60 Medical supplies ……………………………………….                                   1,300                            5.50 Occupancy expenses………………………………..                                     6,300                            1.00 Administrative expenses ………………………….                                    3,500                              .40 Total expenses …………………………………………                                $33,200                        $15.50 Actual results for October: Revenue ………………………………………………….                                 $86,454                                                                                                    Total              Fixed Portion     Personnel...
Guareno Clinic uses client-visits as its measure of activity. During December, the clinic budgeted for 4,500...
Guareno Clinic uses client-visits as its measure of activity. During December, the clinic budgeted for 4,500 client-visits, but its actual level of activity was 4,430 client-visits. The clinic has provided the following data concerning the formulas used in its budgeting and its actual results for December: Data used in budgeting: Fixed element per month Variable element per client-visit Revenue - $ 45.10 Personnel expenses $ 36,300 $ 13.70 Medical supplies 2,000 5.70 Occupancy expenses 12,000 1.80 Administrative expenses 5,800 0.30...
Askland Clinic uses client-visits as its measure of activity. During October, the clinic budgeted for 3,100...
Askland Clinic uses client-visits as its measure of activity. During October, the clinic budgeted for 3,100 client-visits, buts its actual level of activity was 3,130 client-visits.  The clinic has provided the following data concerning the formulas used in its budgeting and its actual results for October: Data used in budgeting:                                                                                                 Fixed                            Variable                                                                                            amount per                         amount per                                                                                                 month                          client-visit Revenue ……………………………………………………                               -                                   $28.80 Personnel expenses ………………………………….                                $22,100                        $ 8.60 Medical supplies ……………………………………….                                   1,300                            5.50 Occupancy expenses………………………………..                                     6,300                            1.00 Administrative expenses ………………………….                                    3,500                              .40 Total expenses …………………………………………                                $33,200                        $15.50 Actual results for October: Revenue ………………………………………………….                                 $86,454                                                                                                    Total              Fixed Portion     Personnel...
Askland Clinic uses client-visits as its measure of activity. During October, the clinic budgeted for 3,100...
Askland Clinic uses client-visits as its measure of activity. During October, the clinic budgeted for 3,100 client-visits, buts its actual level of activity was 3,130 client-visits.  The clinic has provided the following data concerning the formulas used in its budgeting and its actual results for October: Data used in budgeting:                                                                                                 Fixed                            Variable                                                                                            amount per                         amount per                                                                                                 month                          client-visit Revenue ……………………………………………………                               -                                   $28.80 Personnel expenses ………………………………….                                $22,100                        $ 8.60 Medical supplies ……………………………………….                                   1,300                            5.50 Occupancy expenses………………………………..                                     6,300                            1.00 Administrative expenses ………………………….                                    3,500                              .40 Total expenses …………………………………………                                $33,200                        $15.50 Actual results for October: Revenue ………………………………………………….                                 $86,454                                                                                                    Total              Fixed Portion     Personnel...
Bellamy Corporation uses customers served as its measure of activity. The company bases its budgets on...
Bellamy Corporation uses customers served as its measure of activity. The company bases its budgets on the following information: Revenue should be $3.20 per customer served. Wages and salaries should be $21,000 per month plus $0.80 per customer served. Supplies should be $0.70 per customer served. Insurance should be $5,300 per month. Miscellaneous expenses should be $3,100 per month plus $0.10 per customer served. The company reported the following actual results for October: Customers served 22,000 Revenue $ 73,300 Wages...
Stivason Clinic uses client-visits as its measure of volume. During June, the clinic budgeted for 3360...
Stivason Clinic uses client-visits as its measure of volume. During June, the clinic budgeted for 3360 client-visits, but it actually received 3362 client-visits. The clinic has provided the following data concerning the formulas used in its budgeting and its actual results for April. All costs are mixed costs. Data used in budgeting: Fixed amount Variable amount per client visit Revenue 25.45 Personnel expense 22555 8.72 Medical supplies exp. 586 4.93 Administration exp. 10182 1.18 Actual results: Revenue 84171 Personnel expense...
Stivason Clinic uses client-visits as its measure of volume. During June, the clinic budgeted for 3300...
Stivason Clinic uses client-visits as its measure of volume. During June, the clinic budgeted for 3300 client-visits, but it actually received 3400 client-visits. The clinic has provided the following data concerning the formulas used in its budgeting and its actual results for April. All costs are mixed costs. Data used in budgeting: Fixed amount Variable amount per client visit Revenue 27.76 Personnel expense 22400 8.75 Medical supplies exp. 500 4.71 Administration exp. 9270 0.84 Actual results: Revenue 87487 Personnel expense...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT