In: Accounting
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 51500
Medical supplies exp. 15164
Administration exp. 12560
Calculate the sales price variance,Sales volume variance, Personnel variance. SHOW ALL STEPS
Sales Price Variance = (Actual Price - Budgetted price)×Actual Clients
= ((87487/3400)-27.76)×3400 = 6897 (U)
Sales Volume Variance = (Actual clients- budgetted clients)×Budgeted price
= (3400-3300)×27.76 = 2776 (F)
Based on given information we can compute,
Personnel variance =>
Personnel Activity Variance = (22400 + 8.75×3300) -(22400+ 8.75×3400) = 875 (U)
For computing personnel spending variance we need actual fixed costs component too. Since the problem doesn't mention it we have to exclude it.
Please comment in case of any query regarding this solution. Also do give a thumbs up for the efforts put.