Question

In: Accounting

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
Total expenses $ 51,200 $ 24.50

Actual results for October:

Revenue $ 160,661
Personnel expenses $ 84,652
Medical supplies $ 36,512
Occupancy expenses $ 25,831
Administrative expenses $ 9,367

The spending variance for medical supplies in October would be closest to:

Solutions

Expert Solution

Spending variance is difference between flexible budget and actual results.

Flexible budget = budgeted cost*actual level of activity

Variable costs changes with change in levels of activity whereas fixed costs remains same at all levels of activity.

  • Flexible budget for medical supplies= [$2,200+($7.80*4,290)]

                                                                     =$35,662

  • Actual results = $36,512

The spending variance for medical supplies = Actual result-flexible budget results

=$36,512-$35,662

=$850 Unfavorable[ as the actual cost>flexible cost, variance is unfavorable]

Please upvote if you find this helpful.In case of query please comment.


Related Solutions

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...
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...
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...
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...
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...
Stivason Clinic uses client-visits as its measure of volume. During June, the clinic budgeted for 3308...
Stivason Clinic uses client-visits as its measure of volume. During June, the clinic budgeted for 3308 client-visits, but it actually received 3243 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.49 Personnel expense 22516 8.02 Medical supplies exp. 523 4.42 Administration exp. 10733 0.83 Actual results: Revenue 83232 Personnel expense...
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...
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          ...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT