Questions: Bartosiewicz Clinic uses client-visits as its measure of activity. During January, the clinic budgeted for 3,200 client-visits, but its actual level of activity was 3,180 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: 0 / 35.20
- Personnel expenses: 27,200 / 11.20
- Medical supplies: 1,200 / 5.20
- Occupancy expenses: 10,200 / 1.00
- Administrative expenses: 6,200 / 0.30
- Total expenses: 44,800 / 17.70
Actual results for January:
- Revenue: 124,670
- Personnel expenses: 72,020
- Medical supplies: 22,764
- Occupancy expenses: 14,620
- Administrative expenses: 8,125
The activity variance for net operating income in January would be closest to:
Transcript text: Bartosiewicz Clinic uses client-visits as its measure of activity. During January, the clinic budgeted for 3,200 client-visits, but its actual level of activity was 3,180 clientvisits. The clinic has provided the following data concerning the formulas used in its budgeting and its actual results for January:
Data used in budgeting:
\begin{tabular}{lrc}
\hline & \begin{tabular}{r}
Fixed element \\
per month
\end{tabular} & \begin{tabular}{c}
Variable element \\
per client-visit
\end{tabular} \\
Revenue & $\$ 0$ & $\$ 35.20$ \\
Personnel expenses & $\$ 27,200$ & $\$ 11.20$ \\
Medical supplies & 1,200 & 5.20 \\
Occupancy expenses & 10,200 & 1.00 \\
Administrative expenses & 6,200 & 0.30 \\
\hline Total expenses & $\$ 44,800$ & $\$ 17.70$ \\
\hline \hline
\end{tabular}
Actual results for January:
\begin{tabular}{lr}
Revenue & $\$ 124,670$ \\
Personnel expenses & $\$ 72,020$ \\
Medical supplies & $\$ 22,764$ \\
Occupancy expenses & $\$ 14,620$ \\
Administrative expenses & $\$ 8,125$
\end{tabular}
The activity variance for net operating income in January would be closest to:
Solution
Solution Steps
To find the activity variance for net operating income, we need to compare the budgeted net operating income at the budgeted level of activity with the budgeted net operating income at the actual level of activity. The activity variance is the difference between these two amounts.
Calculate the budgeted revenue and expenses at the budgeted level of activity (3,200 client-visits).
Calculate the budgeted revenue and expenses at the actual level of activity (3,180 client-visits).
Determine the net operating income for both the budgeted and actual levels of activity.
Subtract the net operating income at the actual level of activity from the net operating income at the budgeted level of activity to find the activity variance.
Step 1: Calculate Budgeted Revenue at Budgeted Level
The budgeted revenue at the budgeted level of activity (3,200 client-visits) is calculated as:
\[
\text{Budgeted Revenue} = 3200 \times 35.20 = 112640
\]
Step 2: Calculate Budgeted Expenses at Budgeted Level
The budgeted expenses at the budgeted level of activity are calculated as:
\[
\text{Budgeted Expenses} = 27200 + 1200 + 10200 + 6200 + (3200 \times (11.20 + 5.20 + 1.00 + 0.30)) = 101440
\]
Step 3: Calculate Budgeted Net Operating Income at Budgeted Level
The budgeted net operating income at the budgeted level is:
\[
\text{Budgeted Net Income} = 112640 - 101440 = 11200
\]
Step 4: Calculate Budgeted Revenue at Actual Level
The budgeted revenue at the actual level of activity (3,180 client-visits) is:
\[
\text{Budgeted Revenue} = 3180 \times 35.20 = 111936
\]
Step 5: Calculate Budgeted Expenses at Actual Level
The budgeted expenses at the actual level of activity are calculated as:
\[
\text{Budgeted Expenses} = 27200 + 1200 + 10200 + 6200 + (3180 \times (11.20 + 5.20 + 1.00 + 0.30)) = 101086
\]
Step 6: Calculate Budgeted Net Operating Income at Actual Level
The budgeted net operating income at the actual level is:
\[
\text{Budgeted Net Income} = 111936 - 101086 = 10850
\]
Step 7: Calculate Activity Variance
The activity variance is calculated as:
\[
\text{Activity Variance} = 10850 - 11200 = -350
\]
Final Answer
The activity variance for net operating income in January is \(\boxed{-350}\).