Practice Exercise 171

Exhibit 172 presents the Variance Analysis for hospital rehab services for the third quarter. For our practice exercise we will duplicate this report for the fourth quarter. We are able to reformat the information in Exhibit 172 into a worksheet as follows. The fourth quarter assumptions appear below the worksheet.

Actual Cost
Less: Flexible Budget
Price Variance (favorable)
Budgeted Cost
Less: Flexible Budget
Quantity Variance (unfavorable)
Net Variance (unfavorable)

Assumptions

	Overhead Cost	divided by	# Therapy Minutes (Activity Level)	equals	Cost per Therapy Minute
Actual	(1) $950,000		(3) 350,000		(5) $2.71
Budgeted	(2) $930,000		(4) 310,000		(6) $3.00

Required

1. Set up a worksheet for the fourth quarter like that shown in Exhibit 172 for the third quarter.

2. Insert the Fourth Quarter Input Data (per assumptions given above) on the worksheet.

3. Complete the Actual Cost, Flexible Budget, and Budgeted Cost sections at the top of the worksheet.

4. Compute the Price Variance and the Quantity Variance in the middle of the worksheet.

5. Indicate whether the Price and the Quantity Variances are favorable or unfavorable for the fourth quarter.

Optional

Can you compute how the $950,000 actual overhead costs and the $930,000 budgeted overhead costs were calculated?