The administrator at the University Hospital gives you the planned and actual revenues. Since there are more hospitals in Halifax, the administrator is concerned with hidden rates in relation to those of his competitors Planned Actual Surgical Volume 1.000 1,200 Convenience Store 10,000 12,000 Revenue Surgery Revenue 400,000 500.000 Parking Revenue 16.000 18,000 Please perform a variance of analysis on the following and show your calcuation: a. Determine the total variance between the planned and actual budgets b. Prepare a flexible budget bastimate. Present side-by-side the budget, flexible budget estimate, and actual surgical revenues. c. Determine what variance is due to the change in volume and what volume is due to the change in rates