The administrator of break-a- leg hospital is aware of the need to keep costs down because he has just negotiated a new capitates arrangement with a large insurance company. The following are selected planned and actual expenses for a previous month.

	planned	actual
patient days	27,000	26,000
pharmacy	$120,000	$160,000
miscellaneous supplies	$66,000	$77,500
fixed overhead costs	$808,000	$880,000

a.Determine the total variance associated with the planned and actual expenses
b.Calculate the amount of service related variance
c.Prepare a flexible expense estimate for variable costs. compare budgeted amount, flexible budget, ABD actual amount (show related volumes)
d.Determine what variance is due to change in volume and what variance is due to change in rates
e.Determine the volume variance and rate variance and rate variance based on per unit rates